Please help!

Erin17777


I downloaded the SQL Express and the trial package and all I am getting are the configuration tools. I con not get the actual program to get to the database....does anyone know what I should do

Vidhya Sagar


Installing sqlserver Express edition wont provide you management studio. You need to download SSMS setup seperately and install.

Refer the link to download SSMSE download.

Erin17777

Thank you very much for your help! I seem to have gotten that downloaded but then when I put the server name in I am getting this message:

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) (.Net SqlClient Data Provider)

Do you know anything about that

Thank you!

Vidhya Sagar

Pls check whether sql services are running on the machine.

richbrownesq

As suggested, first up check that the sql services are running (either by the services applet or the sql configuration manager).

If this is the case, can you confirm that the tools and database engine are on the same box as you may need to allow remote connections to the database (sp_configure).

DaleJ

Also, make sure you are trying to connect to the instance that you installed. If it was named then you'll need to connect to: [servername]\[instance name].

You should be able to see the name used in the configuation manager tool.