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 |
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
 Posted - 2009-08-08 : 18:22:18
|
| Hello,we have 2 instances of mssql 2008 and configured the port of the 1st installation to be 3433. and the 2nd to be 3533However, in the server configuration manager, it shows 3433.MAIN PROBLEM is that we cant connect.1. in the server configuration, remote connections is set to true2. and both ports are open.port 3433 works fine, but the 2nd installation doesnt allow remote connectionsAny advice ?Ehi |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
Posted - 2009-08-09 : 17:23:11
|
| I have restarted 1. the server via windows rebooting2. restarted services on server config utility3. restarted via right clicking the dbI also checked via netstat at command prompt, and the ports are listening. But somewhere somehow its not working. I checked the server aliases and its only port 3433 that appears there.The first time, i configured the server it was ok, but after reformating, it doesnt seem to work. |
 |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2009-08-09 : 23:43:37
|
| made sure 2nd instance allows remote connections? |
|
|
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
Posted - 2009-08-11 : 02:19:48
|
| yes, it does. But i noticed the main instance was passworded and admin account disabled, am wondering if this is whats affecting it ??? |
|
|
|
|
|
|
|
|
multiple instances of mssql