sql-default-instance

SQL Server Default Instance: If you change host machine's name...

Say I have a Server named "MyServerABC", on which I have Sql Server 2005 installed with a Default Instance. Thus I can always connect to my sql server just by specifying "MyServerABC". Now, I change my server's name to "MyServerDEF". Will I now be able to connect to the sql server by just specifying "MyServerDEF"? Are there any hol...

What problems will I cause by installing SQL Express as MSSQLSERVER?

As with the people in this feedback doc, Selecting the "Default Instance" option in SQL Server 2008 Express RTM has no effect, I had to install SQL Server Express 2008 twice before I realised what was I was doing. The installation defaults to "SQLExpress" even if you select Default Instance. What problems might I cause myself in the fu...