StrataFrame Forum

Error accesing SQL Server (Express 2005)

http://forum.strataframe.net/Topic34.aspx

By Scott - 11/21/2005

I get the following error when hitting the "browse" button in the sample application.  I have setup the connection to the database and can see the "StrataFrame Sample" database using the connection wizard.  I am using a user name and password to connection,  I have also tried to used integrated security to connection,  both are not working.  I am thinking that there is just something not setup correctly on my machine,  but I know very little about SQL server, any help would be appreciated.

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)

Thanks,

Scott

By StrataFrame Team - 11/21/2005

Ah, yes, the connection string is configured to connect using TCP/IP and the SQL server instance is not configured to allow that. Pretty simple fix:



1) Open the SQL Configuration Manager from Start -> Program Files -> Microsoft SQL Server 2005 -> Configuration Tools -> SQL Server Configuration Manager

2) In the configuration manager click the plus sign beside SQL Server 2005 Network Configuration and select Protocols for MSSQLSERVER.

3) In the right hand menu, it should say 'Disabled' for TCP/IP. Right-click the TCP/IP and select Enable.

4) Right click TCP/IP again and select Properties.

5) From the properties dialog, make sure all of the IP Addresses say 'Yes' for active, (blank) for TCP Dynamic Ports, and 1433 for TCP Port. I don't think the Enabled in here matters on each IP Address because all of them say 'No' on our production server and we connect to it fine.



That should get you going. You'll have to at least re-start the service and maybe even reboot your computer, not sure.
By Scott - 11/21/2005

Made all the changes, restarted my machine and I am still getting the same message.  I then enabled named pipes,  same result.

Any thing else I should be looking at?

By StrataFrame Team - 11/21/2005

It is quite possible that your connection string is off...



When you run the application, click File -> Database Connection and edit the database connection you created. In the SQL Server blank, add \SqlExpress to the end of the server name (i.e. if your computer name is "ScottComp," the SQL Server name will need to be "ScottComp\SqlExpress" or "192.168.1.10\SqlExpress" if you want to use your IP address for the servername).



It is quite possible that the autodetection of the server did not find the instance name SqlExpress, so you might have to add it manually.
By Scott - 11/21/2005

un-installed SQL 05 and reinstalled it.... had nothing to do today but look at the framework.  Made the change you suggested... works just fine now.

Thanks for the help.

By StrataFrame Team - 11/21/2005

Glad to hear it... just start up a new post with any other questions you have Smile