Currently I am connecting to SQL server using
192.168.1.157\MyInstance. I would like to connect to SQL server by just using
192.168.1.157 i.e if I type IP addressin SSMS it should connect properly using 1433 port number. How can I do so?
migrated from stackoverflow.com Jul 10 '12 at 10:43
Create an SQL Client Alias as Goody said. Maybe better to put a name isntead of the IP address on the alias name.
Here below an screenshot:
I think you have to set it when you install SQL Server. Just choose the "install as default instance" option during the installation.