question

kathyw avatar image
kathyw asked

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?
linked-servermicrosoft-access
2 comments
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Grant Fritchey avatar image Grant Fritchey ♦♦ commented ·
What errors are you getting when you make the attempt to connect to the Access DB?
0 Likes 0 ·
kathyw avatar image kathyw commented ·
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.
0 Likes 0 ·

1 Answer

·
Grant Fritchey avatar image
Grant Fritchey answered
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.
1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

kathyw avatar image kathyw commented ·
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.
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.