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?

asked Feb 07 '11 at 05:05 PM in Default

kathyw
11 ● 1 ● 1 ● 1

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

Feb 07 '11 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 '11 at 07:37 PM kathyw

(comments are locked)

1 answer:

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.

answered Feb 08 '11 at 04:37 AM

Grant Fritchey ♦♦
62.3k ● 12 ● 20 ● 66

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 '11 at 11:40 AM kathyw

(comments are locked)