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?
- Anybody can ask a question
- Anybody can answer
- The best answers are voted up and rise to the top
migrated from stackoverflow.com Jul 10 '12 at 10:43
This question came from our site for professional and enthusiast programmers.
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.