[RESOLVED] SQL Server connection problem on release

[Strider]

I have made an installer for my web projecct. This is to be installed on a server, however the server does not have sql server installed on it. The sql server i'm connecting to in my project is a remote server.

My web project cannot connect to this server though from where it was installed. Does this server need to have sql server or msde client installed on it?? for my project to work

[simonm]

I had an identical problem and have yet to find a satisfactory solution to this problem.

Do you get the "Server does not exist or access denied" message?

[Strider]

i think if you install mdac 2.8 on the server it may work. I have just installed it...however waiting for a server reboot before i can test but some early indication looks good

[simonm]

Interesting...let me know if it works.

[nswan]

are you using SSPI authentication in your connection string? or have you set up a username and password you are using?

[Strider]

yes installing mdac on the end users server solved the issue i was having.