Suntower
Posts: 225
|
| Posted: 10/03/2008, 2:56 PM |
|
Hi,
A client of ours had a server break down. Their IT guy -swears- they 'cloned' the machine (including the install of SQL Server 2000. We are using ASP with SQL Server Standard (not 'Windows Integrated') log-in and I'm sure the SQL Server login is correctly set up.
However, now the users cannot open the web site... they get the above error. Also, I can no longer get the 'Test Connection' to work in CodeCharge. The dialog no longer shows the name of the server or the catalog of databases. I guess that means that the server is no longer able to broadcast SQL Server info, right?
So...Any idea what has happened? Is this a firewall issue (ie. blocking a port to the outside which SQL Server uses to broadcast it's catalog?) If so, which port(s)?
Thanks!
---JC
_________________
---On a campaign for more examples and better docs! |
 |
 |
tsgroman
Posts: 64
|
| Posted: 10/03/2008, 10:52 PM |
|
Make sure that mixed mode is enabled, that sql server is started, and that SQL Server is listening on the protocol or port that you are using to connect.
|
|
|
|
Suntower
Posts: 225
|
| Posted: 10/03/2008, 10:59 PM |
|
Quote tsgroman:
Make sure that mixed mode is enabled, that sql server is started, and that SQL Server is listening on the protocol or port that you are using to connect.
SQL Server is started. Mixed Mode is enabled.
How can I be sure that it is 'listening'?
Do you mean port 1433? Does that need to be unblocked on the firewall?
TIA,
---JC
_________________
---On a campaign for more examples and better docs! |
|
|
|
Suntower
Posts: 225
|
| Posted: 10/06/2008, 12:49 PM |
|
Help!
What do I look for? I can log in using the standard (non-Integrated) login. Port 1433 is not blocked to the internet. I checked the Enterprise Manager configuration and 1433 is the selected port and is not hidden.
My connectionstring in COMMON.ASP is...
'ConnectionString = "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=SIMPLE;Initial Catalog=C08;Data Source=123.456.789.21"
User = "MYUSER"
Password = "MYPASSWORD"
'MYUSER' is a standard login with owner access to the C08 database. Again, this worked fine on the old server.
What do I check for next?
Thanks!
---JC
_________________
---On a campaign for more examples and better docs! |
|
|
|
Suntower
Posts: 225
|
| Posted: 10/07/2008, 11:23 AM |
|
Well.. I looked at this topic... http://forums.yessoftware.com/posts.php?post_id=68321
...and I went line by line through the Registry for MSSQL for both the old server and new server and found only one difference...
In the old server there were no entries under...
HKLM\Software\Microsoft\MSSQLServer\Client\ConnectTo
But in the new server there -was- an entry similar to Paul Shearing's entry.
By removing that entry from the new server's registry, magically the web site works... users are able to connect to the database so long as I change the connection string in COMMON.ASP to refer not to the IP address of the server, but rather the network name of the server. ie...
'ConnectionString = "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=SIMPLE;Initial Catalog=C08;Data Source=MYSERVER"
User = "MYUSER"
Password = "MYPASSWORD"
...Any idea -why- that worked? Why I couldn't get it to work before? What is the significance of that ClientConnectTo line in the registry?
Also, one problem left: I can no longer run a 'Test' connection from within CCS. in the Connection Builder. Any idea what to do about -that-?
Please, will -someone- take pity or suggest where to go for help? I admit, I'm no SQL Server configuration expert... until now I haven't had to be.
TIA,
---JC
_________________
---On a campaign for more examples and better docs! |
|
|
|
|
