Post by Greg Westendor » Sat, 27 Mar 1999 04:00:00

I'm trying to connect to a password protected Access database through
SQLServer 7.0

Now Microsoft recommends using:
EXEC sp_addlinkedserver 'Foodmart', '','Microsoft.Jet.OLEDB.4.0',
EXEC sp_addlinkedsrvlogin 'Foodmart', false, NULL, 'Admin', NULL

The sp_addliinkedserver works fine And so does the sp_addlinkedsrvlogin as
long I use 'Admin' with a password NULL.  However, when I attempt to use
another login with a password the srvlogin command fails.  (The login and
password are created in the Access Database)
What am I missing?

Thanks in advance
Greg Westendorf


1. sp_addlinkedsrvlogin problems

Hi -

When using linked SQL Server definitions, and using sp_addlinkedsrvlogin, is
there any way to designate the remote user as a Windows Domain login?

Given that OHIO is the Domain and OHIO\Joe is in the System Administrator
role on the remote server;

The above call will execute the link login definition, but fail the link
with [Login failed for user 'OHIO\Joe'].

For that matter, is there any way to do that in Enterprise Mgr.? Using

[OLE/DB provider returned message: Invalid connection string attribute].

How can I access the linked SQL Server using a specific Domain account?


2. Resultset: select next 200 row in a sybase stored proc ?

3. sp_addlinkedsrvlogin failing?

4. Very strange JDBC problem