SQL remote port problem

Question

Hi,

I have installed the SQL server 2008 R2 and have already one instance SQLEXPRESS installed on the same server but my problem is,

When i am connecting remotely to SQLEXpress it automatically connects by just providing the IP Address or  or host name

but when i am trying to connect to MSSQLSERVER i have provide 10.11.12.13\MSSQLSERVER,1433

can you please tell me why this is happening and i want my MSSQLSERVER instance connects only after enterning ip can we do this.

Thanks,

Akshay V

---

Akshay Vithalkar
(MCTS) | Windows Server 2008 R2 Server Virtualization
(MCTS) | Windows Server 2008 R2 Network Infrastructure,Configuration
(MCTS) | Windows Server 2008 R2 Active Directory, Configuration
(MCITP)| Windows Server 2008 Server Administrator
(MCSA) | WindowsServer2008;

Answer 1

When i am connecting remotely to SQLEXpress it automatically connects by just providing the IP Address or  or host name

This could be your default instance which listens on 1433. Default instance can be connected by just specifiying hostyname.

but when i am trying to connect to MSSQLSERVER i have provide 10.11.12.13\MSSQLSERVER, 1433

You are trying 1433 port. Are you sure your named instance listens on 1433? 

---

Srinivasan

Answer 2

Hi,

Yes MSSQLSERVER is a default instance but there is already one instance running as SQLEXPRESS which is installed by Visual Studio 2008 and that's the reason it treating SQLEXPRESS as a default instance.

Thanks,

---

Akshay Vithalkar
(MCTS) | Windows Server 2008 R2 Server Virtualization
(MCTS) | Windows Server 2008 R2 Network Infrastructure,Configuration
(MCTS) | Windows Server 2008 R2 Active Directory, Configuration
(MCITP)| Windows Server 2008 Server Administrator
(MCSA) | WindowsServer2008;

Answer 3

Hello,

Please use

for your default instance:  10.11.12.13
for your express instance:  10.11.12.13\SQLEXPRESS

as server name. For a named instance you have to add the instance name with a backslash to the machine name, for a default instance not.

---

Olaf Helper

Blog Xing

Answer 4

Hi Olaf,

This works for me.

Thanks,

Akshay V

---

Akshay Vithalkar
(MCTS) | Windows Server 2008 R2 Server Virtualization
(MCTS) | Windows Server 2008 R2 Network Infrastructure,Configuration
(MCTS) | Windows Server 2008 R2 Active Directory, Configuration
(MCITP)| Windows Server 2008 Server Administrator
(MCSA) | WindowsServer2008;