Hello,
I just installed VS 2008.
I opened the Server Explorer window and right clicked on Data Connections and selected "Create New SQL Server Database".
Then I selected the Server Name and wrote the database name. I have Windows Authentication selected.
When I click OK I get the error:
"An error has occurred while establishing a connection to the server. When connection 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 Provides, error: 40 - Could not open a connection to SQL Server)
Could someone, please, tell me what I am doing wrong?
Thanks,
Miguel
error: 40 - Could not open a connection to SQL Server
It's a connection problem. Are you sure you have typed the correct server name? Also note there could be firewall issues which block your connection. I would suggest you connecting the database server
through mangement studio frist and see if the server is reachable from your machine.
Hope my suggestion helps
No comments:
Post a Comment