I need to setup an Alias for a Name Instance on SQL server 2012 sp2 CU2. I tried to set it up with SQL System configurator for both 32 bit and 64bit native client alias. on the server where the name instance lives. For both Named Pipes and TCP/IP
I go try to connect to it from another SQL server 2012 management studios. I get the error for named pipes
(provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (.Net SqlClient Data Provider)
I know allow remote connection is set to 1. I am running each instance using a different port. SQL Server Browser is running.
What am I missing. do I have to go to every machine that uses this named instance and setup the alias for the name instance. I am checking it by trying to connect to using SSMS on another server using the alias.
I have setup link servers before with no problems, but I can not get it to work for named instances alias. I am trying to consolidate 3 servers to 1 server with a named instance for each of the servers.
But what matters is the port that the SQL instance is listening on. DNS can't help with that. You need an alias on each client machine that has this issue or figure out why the clients can't communicate with the SQL Browser service on the database server.