Jeez, you know it’s time to get some sleep when it takes you 15 minutes (plus a reboot!) to figure out how to reference your SQL Server instance. I installed SQL Express on my machine and tried to connect with the machine name, localhost and several other choice words before finally trying zujitsu\sqlexpress, which did work. Also OK are localhost\sqlexpress and .\sqlexpress. Once I’d figured this out, I Google’d this up: http://forums.microsoft.com/msdn/ShowPost.aspx?PostID=60175
(Reverse order of events is another sign I should get some sleep…)
Oh, BTW, the default installation of VS .NET 2005 Beta 2 doesn’t install SQL Server Express Manager (XM) by default. Integration through VS gives you everything XM offers and more, so this isn’t an issue. However, devs might want to keep XM open as a convenient lightweight interface, especially for quick queries.
Update: Although all those instance names do work, .\sqlexpress is what you should use. Why? Well, see this: the other names don’t play well with the ASP .NET admin tool (WebAdmin.axd). I’m going to replace my provider with an SQL Server instance eventually, but this is good info for now.
0 Responses to “SQL Server 2005 Express June CTP instance name”