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 - 2008-09-19 : 09:22:12
|
Hello,we are running two instances of MS SQL server on the same machine.We used to run MS SQL 2005 Express version. But now installed a seperate instance of MS SQL 2008.Prior to this, we could connect remotely to the instance of MS SQL 2005 Express and locally using the IP address and port number e.g.xxx.xxx.xxx.xx,2433Now we have two instances, we just cant connect to the MS SQL express version locally or remotely, using the IP address, However using the servername\sqlexpress is ok.I can connect locally to the 2008 using the IP, but not remotely.Any advice Or anyone with similar problems ?thanksEhiNB: I have stopped and started the browser service. to no avail  |
|
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
Posted - 2008-09-19 : 13:38:16
|
| Its been sorted.It was a firewall issue |
 |
|
|
|
|
|
Running two instance(s) of MS SQL on same server