Linked Server to Access Database on a Terminal Server

We have SQL Server 2005 and 2008. Recently An access 2003 database has been installed running on a Terminal Server (Not my idea). I would dearly love to be able to link this database to either SQL Server 2005 or 2008 we have but have so far been unable to get anything to work. Has anyone come across this type of thing before?

more ▼

asked Feb 07, 2011 at 05:05 PM in Default

avatar image

11 1 1 1

What errors are you getting when you make the attempt to connect to the Access DB?

Feb 07, 2011 at 07:28 PM Grant Fritchey ♦♦

I get path not valid so not too sure if syntax is correct. Also (which I should have stated earlier) I am hesitant to share the folder that the access database is in. Last time I tried that something corrupted the access database.

Feb 07, 2011 at 07:37 PM kathyw
(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first

Thanks for the clarification. It sounds like it's a permissions issue. The SQL Server instance is running under a security context that doesn't have access to the Access folder.

more ▼

answered Feb 08, 2011 at 04:37 AM

avatar image

Grant Fritchey ♦♦
137k 20 46 81

Thanks for that Grant. I have resolved this after a good nights sleep. I obviously had something wrong in my path to the Access Database on the Terminal Server. Instead of trying to Link directly to the Terminal Server from SQL Server, I mapped a drive on the SQL Server to the Terminal Server eg (\\\\TerminalServer\\E$) and then linked to the access database via this mapped drive.

Feb 08, 2011 at 11:40 AM kathyw
(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Feb 07, 2011 at 05:05 PM

Seen: 1840 times

Last Updated: Feb 07, 2011 at 05:05 PM

Copyright 2018 Redgate Software. Privacy Policy