Installing SQL Express 2008 As A Default Instance

<div><p>I installed SQL Express 2008 yesterday for the first time and ran into an interesting “feature”. I was trying to set it up as a default instance, which seems pretty straightforward based on this screenshot:</p> <p><img alt="image" border="0" height="480" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiTqPI-b7wLxtuc_nEnar7xiUST8456M4pHQ0ItNCphwWHAn7fgjduHQJmzkDBLH2viHK7qtGRrpInigfCcDDxpTw8sb4lldTfCXWndsdsQFBInqnm0tMZHE_JIDVeQlOsXlAFTBxUBlC5q/?imgmax=800" style="border-top-width: 0px; display: block; border-left-width: 0px; float: none; border-bottom-width: 0px; margin-left: auto; margin-right: auto; border-right-width: 0px" title="image" width="640" /> </p> <p>The only problem is that after the install was complete I had a named instance called <strong>SQLEXPRESS</strong>. I did the install again, thinking maybe I had missed something, and got the same result. It turns out that the current release of SQL Express simply ignores that “Default instance” checkbox and creates an instance with whatever name was entered in the “Instance ID” field.</p> <p>Fortunately there’s a workaround: Create a named instance called <strong>MSSQLSERVER</strong> (also using MSSQLSERVER as the Instance ID):</p> <p><img alt="image" border="0" height="480" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjNxhEiQa8LWqV_z8lRWv9VSUQWOocEr3o4mnaNWOXc1dNKOYqLzIkqeygcd_60HND82XA7hM3J8QWQBwNsehEKOyOQlHF3nnbzK0tHZfxhvH0lkgmOJ1YP8Ox1YwE3RqKT0RtEcnj8RRWd/?imgmax=800" style="border-top-width: 0px; display: block; border-left-width: 0px; float: none; border-bottom-width: 0px; margin-left: auto; margin-right: auto; border-right-width: 0px" title="image" width="640" /> </p> <p>This issue has been reported as <a href="https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=361809&wa=wsignin1.0" target="_blank">Bug ID 361809 in Connect</a> and Microsoft has indicated that it will be fixed in the next public update which will be released “soon”</p> </div>

Share This

• Twitter
• Google+
• Linked In
• Facebook

Related Posts

SQL Server 2008 Tips