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 |
|
CanadaDBA
583 Posts |
 Posted - 2005-03-22 : 09:39:13
|
I have two instances of SQL Server installed on my Test server. 1.2.3.4 which is the (Local)1.2.3.4\Test which is the second instance Today, no one could connect to the SQL Server. I restarted the server. Both instances services are running. Now, everyone can connect to the 1.2.3.4\Test but still it is not possible to the (Local). I am trying to connect to it using EM or QA on the server's console but nothing. I have tried different id and passwords. What should I do?Thanks,Canada DBA |
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2005-03-22 : 10:03:16
|
| Is the service running? Go to the Control Panel/Administrative Tools/Services and see if MSSQLSERVER is actually running. Do you have the latest service packs? What version of Windows/SQL Server?MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
 |
|
|
jason
Posting Yak Master
164 Posts |
Posted - 2005-03-22 : 10:45:32
|
| Are they both listening on the same port? |
|
|
|
CanadaDBA
583 Posts |
Posted - 2005-03-22 : 11:09:17
|
| Yesterday, one of our testers was trying to install SQL Server on her local and register one of the instances. She noticed that although she has registerd the second instance but expanding the databases shows the first instance data. Our SQL server restarts everyday at 4am. When I checked the Ports on the server's consol I found that the ports are 4354 for local and 1783 for the second one while they were 1433 for local and 4354 for the second one. I fixed the ports and stopped and restarted the SQL-Server and problem is resolved.Canada DBA |
|
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2005-03-22 : 11:18:56
|
| :) That's a fun one. You might want to restrict administrator access to that box.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
|
|
|
Problem to connect to SQL Server