January 31, 2007 at 9:15 am
We install all the copies of SQL such that they take the computer name to avoid naming conflicts and we can use the "(local)" reference when creating ODBC connections from other applications. We can't figure out how to do that during the installation of SQL 2005. Help!
January 31, 2007 at 7:33 pm
Unless you're installing a named instance it should do that by default. Where in the install proces are you running into issues? Or is it after installation you aren't able to connect?
K. Brian Kelley
@kbriankelley
February 1, 2007 at 7:31 am
As Brian says, the default instance of SQL 2005 will do what you want. The default instance actually has a name of MSSQLSERVER, but you do not need to specify this when you connect - you just use the machine name.
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
February 1, 2007 at 8:45 am
Thank you for the information. We finally figured it out, what confused us is SQL 2005 Express appears to require installation as a named server, but the "big" version does not. Never dull, is it?
By the way, Ed, 12 was a great age, I am getting older, but I refuse to grow up!
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply