following is the error that I get:
"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 dows not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) "
I have following fields that I am supposed to fill:
1) Data Source : Defauld value "Microsoft SQL Server (SqlClient)"
2) Server Name: Empty - I am supposed to enter something. It has a button says Refresh. I entered localhost as you suggested, but not to avail.
3)Select or enter a database name: I am entrying SQLEXPRESS which is the default name of my SQL server. It is not working.
No, there is only one instance of the server.
I guess this information will help you to help me.....:-)
Have you used the surface area configuration tool to allow remote connections to SQL Server?
-Jamie
No comments:
Post a Comment