January 3, 2007 at 3:58 am
Hello!
I have an sql server express (2005) database on a win2003 server. In this database I have made a linked server to an access (mdb) file that resides on the server.
The link works perfectly if I am logged in as Administrator (both on the server and on clients). But as soon as I log on with a user account I get this error:
"OLE DB Provider Microsoft.JET.OLEDB.4.0 for linked server "Boatreg" returned message "unspecified error"
The user accounts has full rights (sysadmin) on the sql server and can access/change everything but the linked servers...
Any ideas?
/Erik
January 3, 2007 at 6:42 am
just try accessing your access database with opendatasource to see if you get the error in that also if so please send the exact error message
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
January 3, 2007 at 9:06 am
Hi Sugesh! Thank you for the reply.
I tried you suggestion without any luck. I still get this error when querying logged on as a domain user:
OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "(null)" returned message "Unspecified error".
Cannot initialize the data source object of OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "(null)".
This is a security issue for sure, but I don´t know how I can give the user more access! (sql server sysadmin with full rights on the mdb file...)
Regards
/Erik
January 4, 2007 at 6:22 am
Just check this link. http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=904828&SiteID=1
Also i would like to know ur parameters that you are using in creating the linked server.
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
January 5, 2007 at 10:41 am
Hi again
The problem is now solved. It had to do with the account on the server that the SQL Server Service runs under. I changed it from Network Service to Local System, and now it works perfectly! Do you know the difference between the two accounts?
/Erik
January 7, 2007 at 6:22 am
The difference is the local system account is a user only pertaining to that machine. I can access resources only in that machine. But a network user can even access resources of other machine where he has access like a shared folder.
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply