CODEWITHSUNDEEP
sql-serversql-server-2022sql-server-config-manager
A510
A510

Reputation: 304

How to properly add an alias in SQL Server Configuration Manager for Local Server

The application in the configuration has the given name (localdb)/MyProj. I do not want to change the application code to connect to the server, so for this purpose I wanted to use the aliasing functionality available in SQL Server Configuration Manager.

In SQL Server Configuration Manager: In Client Protocols I set TCP/IP and Named Pipes to Enabled. In aliases, I added two new aliases. Alias name: (localdb)/MyProj Port No: 1433 Protocol: TCP/IP Server: MyServer

and another with a different name: MyProj

In Protocols for MSSQLSERVER > TCP/IP > I have TCP Port 1433 set. I checked with cmd netstat -an if the port is listening, it is. I restarted the service and the machine. SELECT @@SERVERNAME returns MyServer

Using Microsoft SQL Server Management Studio with MyServer or MyServer,1433 or using ip I can connect to the server.

However, none of the prepared aliases work. What else should I check or change to use an alias?

Upvotes: 0

Views: 402

Answers (0)

Related Questions