4

They have installed SQL Server 2008 R2 on my work machine.

Connecting to (local) win auth does not seem to work. How do I determine if I have a local instance of it?

thanks

marc_s
  • 732,580
  • 175
  • 1,330
  • 1,459
user9969
  • 15,632
  • 39
  • 107
  • 175
  • Check your SQL Server Configuration Manager to see if there are any instances. – TIHan Sep 08 '11 at 16:56
  • Possible Duplicate: http://stackoverflow.com/questions/141154/how-can-i-determine-installed-sql-server-instances-and-their-versions – rlb.usa Sep 08 '11 at 16:59
  • What exactly do you want to know? If there is **any** SQL Server installed, or if SQL Server **2008 R2** is installed? Just connecting to local with win auth would work with any version of SQL Server. – Christian Specht Sep 08 '11 at 20:32
  • Just want to make sure that Sql server was installed locally ,that I am running locally and not pointing to the server.At the minute I can only seem to connect to a database that is on the network.Trying to logon with (local) win I have not success.Could it be that it was installed with a named instance?In a nutshell I want to install some db locally.(NOT sql express) – user9969 Sep 09 '11 at 06:00

1 Answers1

3

Check your SQL Server Configuration Manager.

enter image description here

If there isn't an instance running, follow this tutorial: http://technet.microsoft.com/en-us/library/ms190699.aspx

You also want to make sure your instance is a Network Service. For your instance, right click on it, then click properties. Set Log On As - Built in Account: Network Service.

enter image description here

TIHan
  • 632
  • 4
  • 12