Linked Server to Access Database on a Terminal Server

Question

question

kathyw asked Feb 7, '11

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-server microsoft-access

2

10 |1200

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

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

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

0 ·

kathyw commented · Feb 07, 2011 at 07:37 PM

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 ·

Answer 1 · 2011-02-08T04:37:05Z

Grant Fritchey answered Feb 8, '11

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

10 |1200

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

kathyw commented · Feb 08, 2011 at 11:40 AM

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 ·

question