Last post Sep 30, 2008 01:22 PM by waitecolin
Sep 26, 2008 02:10 PM|waitecolin|LINK
I am sure this is a simple thing to overcome. I have tried a number of different things. Always get the following error:
A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections.
(provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
My Training DB instance is in the Database folder.
I have not used any of the logins as integrated security is set to true.
Would be most grateful as to what I should set up so my App can speak to my database. (I have setup the Allow Remote Connections)
Thanks in advance
Sep 26, 2008 02:38 PMfirstname.lastname@example.org|LINK
This resource should help to make sure that you have it enabled to recieve TCP connections
Sep 26, 2008 02:39 PM|bullpit|LINK
Do you have the SQL Server on the same machine on which your application resides?
Sep 27, 2008 07:44 AM|waitecolin|LINK
Yes. The application and DB both reside on my desktop.
I will have a look at the TCP connections link. Thanks.
Sep 27, 2008 10:37 AM|bullpit|LINK
I don't think you need to turn on TCP connections in your case. I am thinking that the SQL Server related services are either not installed properly or started on your machine. Go to Services on your computer and make sure they are started, especially SQL
Server Agent service.
Sep 30, 2008 01:22 PM|waitecolin|LINK
You were correct, the SQL Server Agent was not started.
Alas, I am unable to start it. It auto stops when I try to start it. It says some services start automaticall if they are not in use. It seems I have an issue with the install.
I have a horrible feeling the instance of SQL2005 that auto loaded as part of Visual Studio 2008, I installed SQL Express afterwards, has rather screwed things up.
Do I need to uninstall both and reinstall SQL2005 Express?
Thanks in advance.