SQL Server Express 2005 - Install Problem

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

Reply to
matthew.warr
Loading thread data ...

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.

Reply to
Stephen Zwarts

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

Reply to
Glenn Adams [MVP - Retail Mgmt

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.