Linked Server Express Edition failure

Last Post 04 Apr 2009 01:27 PM by SQL_Veteran. 0 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
New Member
New Member

04 Apr 2009 01:27 PM
I'm using sp_addlinkedserver and sp_addlinkedsrvlogin to access an unsecured Access database. The TSQL Select statements I then use to read from the specified .mdb file work fine when I'm running SQL Server Personal Edition, but fail when using Express Edition (2005). When my Windows account is made an Administrator, then it works using Express Edition. I'm running with Windows authentication in both SQL Server instances (each is on a separate PC) and have the System Administrator role in both instances.

What could cause this behavior, and how can I deploy my tool on a laptop with SQL Server Express Edition without granting the users admin rights to the PC? I'll certainly appreciate any help, as the documentain I have says nothing about this. Thanks!

Acceptable Use Policy