• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1128
  • Last Modified:

SQL Server 2005 - No local database available after installation

I just installed SQL Server 2005 and when I run the management studio there is no local database available in the server name drop down.  Not sure if I missed something in the setup, but when I try to put my computer name in there I get the following error:

TITLE: Connect to Server
------------------------------

Cannot connect to COMPUTERNAME.

------------------------------
ADDITIONAL INFORMATION:

An error has occurred while establishing a connection to the server.  When connecting to SQL Server 2005, this failure
may be caused by the fact that under the default settings SQL Server does not allow remote connections.
(provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 2)

TIA,

N
0
stretch73
Asked:
stretch73
  • 3
  • 3
1 Solution
 
chapmandewCommented:
open up the surface area configuration tool on the server and enable remote connections.
0
 
stretch73Author Commented:
Thanks for the quick reply.  Tried what you said and received the following:

TITLE: Surface Area Configuration
------------------------------

No SQL Server 2005 components were found on the specified computer. Either no components are installed, or you are not an administrator on this computer. (SQLSAC)

------------------------------
BUTTONS:

OK
------------------------------
0
 
i2mentalCommented:
Also, if you installed SQL Server Express try "COMPUTERNAME/SQLEXPRESS" as it's installed into a named instance by default. Remember SQL Server does not come with anything but the system database on installation. In 2005 they are located inside the "System Databases" folder inside "Databases"
0
Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

 
chapmandewCommented:
Are you doing this on the server that you installed SQL Server on?

Did you make sure you installed the db engine and not just the client tools?
0
 
stretch73Author Commented:
I thought I installed everything.  I'd rather not go through the whole uninstall/install routine but from what I'm reading it doesn't sound like the installation went through correctly.
0
 
chapmandewCommented:
right click on My computer and go to Manage.  From there, open up the Services tab and see if MSSQLSERVER service is running or even present.  If it is not present, then it is not installed.  If it is present and not running, start it and try again.
0
 
stretch73Author Commented:
Nope, not installed.  Will reinstall and see what happens.  

Great response, exactly what I needed.

N
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now