SQL Server 2008 R2 can t connect to local database in Management Studio

Question

I am using SQL Server 2008 R2 Express   I first installed SQL Server 2008 R2 Express Management Studio and then I installed SQL Server 2008 R2 Express  I have the instance SQLEXPRESS running and it is set to automatic    I am trying to connect to it locally using Windows authentication - server name is set to local and the username is grayed out and set to my profile username   When I try to connect I get the following error     Have I installed the wrong SQL Server Management Studio

User · Answer

I know  this problem can be faced by so many people and many of them have uninstalled and re-installed the sql server for resolving this issue   In my observation the problem of not connecting the database service locally is just because of your network connection you are using  in most of the cases these problems will come when you are using wi-fi network   Solution  is  if you are using wi-fi then just right click on status of the network and get the ip details and enter the same ip in sql server name  it will work  Regards Vishwajeet

User · Answer

Follow these steps to connect with SQL Server 2008 r2  windows authentication    Step 1   Goto Control Panel --  Administrator Tools --  Services   select SQL SERVER  MSSQLSERVER  and double click on it   Step 2   Click on start Service   Step 3  Now login to SQL server with Windows authentication  and use user name    local   Enjoy

User · Answer

Okay so there might be various reasons behind Sql Server Management Studio s SSMS  above behaviour   1 It seems that if our SSMS hasn t been opened for quite some while  the OS puts it to sleep The solution is to manually activate our SQL server as shown below    Go to Computer Management-- Services and Applications-- Services  As you see that the status of this service is currently blank which means that it has stopped   Double click the SQL Server option and a wizard box will popup as shown below Set the startup type to  Automatic  and click on the start button which will start our SQL service    Now check the status of your SQL Server  It will display as  Running    Also you need to check that other associated services which are also required by our SQL Server to fully function are also up and running such as SQL Server Browser SQL Server Agent etc    2 The second reason could be due to incorrect credentials entered So enter in the correct credentials   3 If you happen to forget your credentials then follow the below steps    First what you could do is sign in using  Windows Authentication  instead of  SQL Server Authentication  This will work only if you are logged in as administrator  Second case what if you forget your local server name  No issues simply use     instead of your server name and it should work     NOTE  This will only work for local server and not for remote server To connect to a remote server you need to have an I P  address of your remote server

User · Answer

Your  SQL Server Browser  service has to be started too   Browse to Computer Management   Services    Find find  SQL Server Browser    set it to Automatic  and also Manually start it  2      Hope it helps

User · Answer

I also received this error when the service stopped  Here s another path to start your service      Search for  Services  in you start menu like so and click on it       Find the service for the instance you need started and select it  shown below  Click start  shown below      Note  As Kenan stated  if your services Startup Type is not set to Automatic  then you probably want to double click on the service and set it to Automatic

User · Answer

I had this problem  My solution is  change same password of other in windowns  Restart Service  check logon in tab Service SQL

User · Answer

I have the same error but with different case  Let me quote the solution from here       Luckly I also have the same set up on my desktop   I have installed   first default instance and then Sql Express   Everything is fine for   me for several days   Then I tried connecting the way you trying  i e   with MachineName MsSqlServer to default instance and I got exctaly the   same error       So the solution is when you trying to connect to default instance you   don t need to provide instance name  well this is something puzzled   me  why it is failing when we are giving instance name when it is a   default instance  Is it some bug  don t know       Just try with - PC-NAME and everything will be fine   PC-NAME is the   MSSQLServer instance       Edit    Well after reading your question again I realized that you are   not aware of the fact that MSSQLSERVER is the default instance of Sql   Server   And for connecting to default instance  MSSQLSERVER  you   don t need to provide the instance name in connection string   The     MachineName  is itself means  MachineName MSSQLSERVER

User · Answer

If your instance is called SQLEXPRESS  then you need to use   SQLEXPRESS or  local  SQLEXPRESS or  yourMachineName SQLEXPRESS as your server name - if you have a named instance  you need to specify that name of the instance in your server name

User · Answer

Lots of the above helped for me  plus the accepted answer  but since I was on an EC2 instance  I had no idea what my instance name was  Finally  I opened SQLServer Configuration Manager and in the Name column  use whatever is there as your connection server  so in my case    EC2SQLEXPRESS and worked great

[sql-server] SQL Server 2008 R2 can't connect to local database in Management Studio

Examples related to sql-server

Examples related to sql-server-2008-r2