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 |
|
TRACEYSQL
Aged Yak Warrior
594 Posts |
 Posted - 2007-11-16 : 10:23:12
|
| I have two instances of sql one using 1433 and one using 1434 the one with 1434 will not work...Tried leaving blank nothing.Is there something i have to enable ? or this something with network ports. Nothing disabled on ports. |
|
|
TRACEYSQL
Aged Yak Warrior
594 Posts |
Posted - 2007-11-16 : 10:29:15
|
| I have it configued as port 1433 but when you go to odbc to test and say use 1433 it not working so its using another port so it looks like SQL is not set up for 1433 or not taking the settings... |
 |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2007-11-16 : 10:31:45
|
which one is not working ? 1433 or 1434 ?Did you restart the SQL Server after setting the ports ?
KH[spoiler]Time is always against us[/spoiler] |
|
|
|
dirtydavey
Yak Posting Veteran
80 Posts |
Posted - 2007-11-16 : 11:32:38
|
| Stop and restart sqlagent, see if that does it. I had the same problem, and for some reason that did it. |
|
|
|
TRACEYSQL
Aged Yak Warrior
594 Posts |
Posted - 2007-11-16 : 15:08:59
|
| yes restarted both...I did not have sp4 on this server so i just reinstalled this i give it a try.Thanks |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-11-17 : 01:44:32
|
| Find port number of each instance in server network utility. Can't use 1434 since Microsoft uses it for sql management. |
|
|
|
TRACEYSQL
Aged Yak Warrior
594 Posts |
Posted - 2007-11-17 : 08:37:04
|
| Oh did not know 1434 used as could not see if used in netstat - a command...SP4 fixed 1433 for 1st instance now i choose another port for 2nd instance. |
|
|
|
|
|
|
Two instances for ports