cannot connect to sql server....

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

cannot connect to sql server....

Author

Topic

alexjamesbrown
Starting Member

48 Posts

Posted - 2007-11-05 : 10:15:43

up until now, both SQL Server, and IIS were running one one machine.

i have bought a new server, running sql server 2000.
this machine is called LSSQL
the webserver, is called LSWEBSERVER

on LSWEBSERVER we have an internal application, which can access the LSSQL sql server absolutely fine, however, in a seperate folder, there are the live websites, which use the same connection string, and i get the SQL Server does not exist or access denied. error.

i dont know whats going on... when the db was hosted on LSWEBSERVER as well, it was the same connection string.

this is the connection string im using:

Provider=SQLOLEDB;server=lssql;database=<<db name>>;uid=<<user>>;pwd=<<password>>

any ideas?

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2007-11-05 : 10:17:15

Are you using same permissions on all web sites?

E 12°55'05.25"
N 56°04'39.16"