Don’t Tell SharePoint The Name of Your SQL Server

SQL Aliases have been around for a while however I am amazed at how many folks either don’t know about them or don’t use them. A SQL Alias is just a really easy way to do a string substitution of a connection string just before a connection is made to a SQL server. The SQL Alias configuration is stored in the registry and the anywhere the server name portion of the connection string matches the server alias the substation is made.

Continue reading “Don’t Tell SharePoint The Name of Your SQL Server”