How to connect to local SQL Server

[LonnieJohnson]

We have new software that has a SQL Server 2005 back end that was packaged with it. This back end sql server was put on the C drive of a file server that is accessible by the network.

I am trying to get to it from my Enterprise manager (2000 or 2005 Express) and cannot connect. I can see the File Server in my list of available servers but cannot connect to it.

Does anyone have any clues on what may be the problem?

Thanks.


ProDev, Builders of Affordable Software Applications
Visit me at ==>

http://www.prodev.us

May God bless you beyond your imagination!!!

 

[bborissov]

If you post what error you get that could make things easier for us .
If that server is installed on your local drive, maybe you could login with your current Windows login just using Windows Authentication. But that is not sure at all.


Borislav Borissov
VFP9 SP2, SQL Server 2000/2005.
Microsoft MVP VFP

 

[LonnieJohnson]

Thanks for the quick response...

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)

ProDev, Builders of Affordable Software Applications
Visit me at ==>

http://www.prodev.us

May God bless you beyond your imagination!!!

 

[bborissov]

Start->All Programs->Microsoft SQL Server 2005->Configuration tools->SQL Server Surface Area Configration

Click on the "Surface Area Configration for Service and Connections" link
Go to "Remote Connections" node under Database engine and select:
"Local and remote Connections->Using both TCP/IP and named pipes"

Borislav Borissov
VFP9 SP2, SQL Server 2000/2005.
Microsoft MVP VFP