SQL Server 2008 Management Studio Not Showing Database

I’ve got a fresh install of Windows Server 2008 R2 SP1 and just installed SQL Server 2008 R2, including SQL Server 2008 R2 Management Studio.

When I go into Management Studio, it does NOT show the SQL Server instance that was created during setup. It only has (local) and won’t let me connect to it at all.

  • how to declare global variable in SQL Server..?
  • How to incorporate date range in a WHERE clause?
  • SQL Query to insert values from one table into another
  • Do I need parenthesis around a simple IF in Transact SQL?
  • Unique constraint between several columns derived from the same one to many relationship
  • Sql data transformation
  • Any ideas?

  • SQL Forgot Email PHP Page Giving Error `The multi-part identifier could not be bound. (severity 16) `
  • Windows Form SqlCommand C# Error
  • Select Top 1 field and assign to local variable
  • Dealing with backslashes in JavaScript, PHP and MSSQL
  • Why is select query not working?
  • MS SQL Server - Bulk Insert Across a Network
  • 3 Solutions collect form web for “SQL Server 2008 Management Studio Not Showing Database”

    First check if SQL Server 2008 instance is installed show on your SQL Configuration Manager.

    If it doesn’t exist you need to re install you sql server 2008 r2 and follow these steps on this link below:

    SQL SERVER – 2008 – Step By Step Installation Guide With Images

    And it exist just add server name : yourpcname

    Best Regards

    Problem solved. Management studio requires <computer name>/<instance name> under the “Server” section. I was only entering in the instance name.

    Another solution that worked for me:

    enter “localhost” as the server (computer-name\MSSQLSERVER failed)

    Not sure why but the name “MSSQLSERVER” as shown in Configuration Manager is not the name shown when I log in via Management Studio. The name in Management Studio is SQL Server 9.0.5000 which corresponds to SQL Server 2005 SP4 (which is correct in my case).

    MS SQL Server is a Microsoft SQL Database product, include sql server standard, sql server management studio, sql server express and so on.