After that, just open the SQL Server Configuration Manager Tool and go to the TCP/IP Protocols Setting. Also, I have a server with only 1 Named Instance (SQL_NAMEDINST) installed.
Next, you want to make sure no Default Instance has been installed. First, simply let your SQL Server listen to the Default port (1433). It is actually very uncomplicated to convert a Named Instance into a Default Instance. Convert your Named Instance into Default Instance Together with our customer we decided to go for the second option. I could either install a Default Instance on the server or make the current Named Instance look like a Default Instance. In a perfect world I would say that this could not go into production, but our customer really wanted this into production that day. This was a problem because our server is not accessible with ‘.’ or ‘localhost’. Server=localhost Database=someDB User Id=IgnorentUser Password=IgnorentUserPwd During a huge project deployment, an obstacle occurred: this customer had hardcoded the SQL connection string which pointed to the local Default Instance (even worse ‘.’).
Recently I was working for a big international customer who, according to policy installs, Named Instances of SQL Server only.
0 kommentar(er)
