x

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

kathyw gravatar image

kathyw
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

Grant Fritchey gravatar image

Grant Fritchey ♦♦
98.1k 19 21 74

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.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

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

By RSS:

Answers

Answers and Comments

SQL Server Central

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

Topics:

x106
x49

asked: Feb 07, 2011 at 05:05 PM

Seen: 1064 times

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