[RESOLVED] Help connect SQL SERVER 2008 to ASP pages

[yamaharuss]

I'm having a heck of a time getting my ADODB connection string to work with a new install of SQL SERVER 2008 Enterprise.

For SQL SERVER 2000 I have used the following:

"PROVIDER=SQLOLEDB;DATA SOURCE=myIPAddress,xxxx;network=DBMSSOCN;DATABASE=myDatabase;USER ID=myUserID;PASSWORD=myPassword;"

I have set 2008 to listen on port xxxx but I keep getting a database does not exist or login not valid error.

Does anyone have experience with 200 and ASP connection?

[ssystems]

Use SSMS to go to reach the db REMOTELY using the credentials you provided.

[yamaharuss]

The connection was fine.. I had to configure MSSQL properly.

Solved