ASP and connectionstring to SQL 2005

[plarsen]

Hi

I have an ASP application what used to use an SQL 2000 database, but as we want to upgrade our server farm I need to connect to a SQL 2005 database instead.

I have tried changing the connectionstring in many different ways but it will still not connect to my 2005 database.

My current connectionstring looks like this:

ConnStr = "Provider=SQLOLEDB.1;Password=[Passeword];Persist Security Info=True;User ID=[Username];Initial Catalog=GoodGod;Data Source=[IP-address]"

If I use the same connectionsstring on the new server I get the following error:

-2147467259 - [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.

I have consulted connectionstrings.com, but non of the connectionsstrings are working.

I have tried using the following providers: {SQL server}, SQLDNLI, SQLOLEDB

I have also tried using servernames instead of IP-addresses.

Can anyone point me in the right direction?

 

[wvdba]

try looking here for connection strings:

http://www.connectionstrings.com/sql-server-2005

 

[plarsen]

Thank you for your response wvdba

But I have already checked connectionstrings.com, and they couldn't provide me with at solution.

Could the reason be that the SQL server or the Webserver are not set up to ASP/SQL2005?

 

[gmmastros]

I assume you have IIS installed on a different computer than SQL Server (which is good). I suggest you troubleshoot your connection issue by following the advice here:

faq962-5481

You should probably do this from your IIS computer.



-George

"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom