stretch73
asked on
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
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
open up the surface area configuration tool on the server and enable remote connections.
ASKER
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
-------------------------- ----
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
--------------------------
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"
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?
Did you make sure you installed the db engine and not just the client tools?
ASKER
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Nope, not installed. Will reinstall and see what happens.
Great response, exactly what I needed.
N
Great response, exactly what I needed.
N