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.
| Author |
Topic |
|
ann06
Posting Yak Master
171 Posts |
 Posted - 2008-06-08 : 05:18:22
|
| Hi, i have a web application (iis 6) and a databasae. web application is using windows authentication. when iis and the database are on the same server the application is running fine and can be accessed from clients. but when i moved the database to another server it stated giving the error([DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied ) only from clients from IIS server its working.- when using in iis windows basic authentication its working but integrated Authentication giving the error.- web application pool is using a domain/user that has access to the database- All servers are win 2003<add key="ConnectionString" value="Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=EFILING;Data Source=RPDHO07;"/> i tried also to use the username and password in connection string same problemPlease help this puzzled me aloooot :@ |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-06-08 : 05:51:16
|
| may be thishttp://support.microsoft.com/kb/175671 |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-06-08 : 14:39:30
|
| Ensure sql allows remote connection. |
|
|
|
ann06
Posting Yak Master
171 Posts |
Posted - 2008-06-09 : 02:48:03
|
| I Tried to make Connection through ODBC in system DSN i created one connection to the server using TCP ip and port 1433 it is giving error. csql server error 10061 sql server does not exist or access denied!! i made sure TCPIP is enabled in SQL enterprise manager. when starting SQL service the log showing "The server is listening on shared memory" while in the articles i read it should mention something like this "Using 'SSMSSO60.DLL' version '6.5.0.0' to listen on '1433'" |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-06-09 : 23:05:11
|
| Enable remote connection in surface area configuration. |
|
|
|
ann06
Posting Yak Master
171 Posts |
Posted - 2008-06-10 : 08:00:27
|
| How to enable this in sql 2000 ?? |
|
|
|
ann06
Posting Yak Master
171 Posts |
Posted - 2008-06-10 : 08:22:15
|
| Ok Guys just solved it i installed SP4, the problem solved on test server on live it didnt. then i read article to edit in the registry keyHKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\ [Instance Name]\MSSQLServer\SuperSocketNetLib\Tcp\REG_SZ TcpPort=1433it was blank before. then i was able to connect using tcpipfinally after 2 weeks i was able to solve :D thanks alll |
|
|
|
|
|
|
IIS and Database on separate Box ERROR!!