June 2, 2009 at 1:53 am
Please let me know how to solve the below mentioned error. This error message appears when i try to enter the data in the sql through visual studio.
I am able to import the data in the visual studio from sql. but not able to export the data in the sql from the visual studio.
The error message which i am getting is as follows:
An error has occurred while establishing the connection to the server. When connecting to SQL Server 2005 this failure may be caused by the fact that under the default setting SQL server does not allow remote connection(provider : Named pipes provider, error:40 - could not open a connection to sql server)
June 2, 2009 at 6:37 am
That's a connection error. You either have the wrong name for the server, you don't have permissions to the server, or you don't have the right network settings on the client. Are you using named pipes, because that's what the error says. Usually it's not named pipes but TCPIP. Check the Configuration Manager on the client to see if the right network protocols are enabled.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
June 3, 2009 at 7:59 am
Use SQL Server Surface Area Configuration to set the connection options for the SQL instance.
SQL Server Surface Area Configuration is located in the start menu -> SQL Server 2005 -> Configuration Tools -> SQL Server Surface Area Configuration
Then choose Configure Surface Area Configuration for Services and Connections
Choose your instance and then database engine -> remote connections
Set it to both named pipes and tcpip
"There are three kinds of men. The one that learns by reading. The few who learn by observation. The rest of them have to pee on the electric fence for themselves." -- Will Rogers
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply