4

I recently rebuilt my machine to Windows 7 x64, installed Sql Server 2008 enterprise. I can connect fine to other remote instances via Management Studio (be they 2000, 2005 or 2008), but i cannot find my local default instance.

  • I have verified that a directory was created for the default instance C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER
  • I can connect to SQLEXPRESS instance fine
  • I have rerun setup to ensure I have everything installed
  • I have verified that the SQLSERVER(MSSQLSERVER) service is running
  • I have verified that SQL Server Browser is running
  • I have tried brownsing for the instance and see all the others available except my local one
  • I have tried using this for servername: TSOUTHERLANDPC\MSSQLSERVER, the first part being my local machine name

My issue is not the same as this post or this post.

Any ideas?

Community
  • 1
Tone
  • 611

5 Answers5

3

re-install sql server. I had the same problem and then noticed that instead of installing a local instance I installed a named instance ( that just so happened to be the same name as a local instance). For some reason there is a difference between a local instance with the exact same name as a local instance and when you actually choose local instance.

Jim B
  • 24,276
3

Try your hostname followed by the instancename, for instance PC\SQLEXPRESS

1

Check the configuration manager and make sure the browser is running.

Saif Khan
  • 1,955
1

The instance name that you should use for the default instance is the hostname of your machine, so try just tsoutherlandpc and see if that does it for you.

squillman
  • 38,163
1

As stupid as this sounds, open SQL Management Studio by using Right Click -> Run As Administrator.

You should now be able to connect to your default instance.

This is a wonderfully undocumented 'feature' that occurs on any of the newer Windows OS' with UAC enabled.

Chris Thorpe
  • 9,953
  • 25
  • 33