SQL Server Express 2005 - Install Problem

May 14, 2007 2 Replies
M

Getting a "SQL Server does not exist or access denied. Connection open (Connect())" error when trying to connect to the SQL Server service whioch is installed on the local PC. Have tried to connect to (local) MACHINENAME and IP.ADD.RE.SS and still nothing. The installation completed successfully, the service is running and have tried restarting it. Still nothing.



Its XPSP2, I have tried explicitly allowing the ports in the firewall to allow everything and even switched it off.



Any ideas?



Thanks, Matt



Vote
Twitter Facebook LinkedIn
S

Hi Matt

Please check that you have enabled named pipes and tcp/ip remote connection to the instance you connecting to. Have you got the management studio installed as it is much easier to administrate the machine with it installed.

Vote
Twitter Facebook LinkedIn
G

Have you installed a default instance, or a named instance? a default instance is connected by just the servername (in any of the variations you have tried). a named instance required you to append the instance name to the server name: 192.168.1.100\SQLExpress machineName\InstanceName (local)\InstanceName

By default, SQL Express installs a named instance with the name "SQLExpress"

Have you tried connecting using Windows Authentication? SQL Express defaults to Windows Authentication Only, but RMS requires Mixed Mode.

If you installed SQL Express from the RMS 2.0 CD, both of these defaults should be overridden for you - if you installed from a copy downloaded from Microsoft's web site they may be the problem.

Glenn Adams Tiber Creek C> Getting a "SQL Server

Vote
Twitter Facebook LinkedIn

Join the Discussion

Have something to add? Share your thoughts — no account required.

Didn't find your answer?

Ask the community — no account required