Posted by: mikel June 6, 2016
Login in to Rate this Post:
0
?
From your computer where you have installed SQL server,
Lets do this,
1. Go to sql server configuration manager
2. Sql server network configuration
3. Protocols for MSSQLSERVER
there you will see three options,
1. Shared memory
2. Named Pipes
3. TCP IP
check if they are disabled, if Named PIPED disabled, enable them,
do same thing on SQL Native client 11.0 configuration---Client protocols--- you will see same options as above. Enable Named pipe . ( this is important since you are connecting through ODBC or any external connections. )
Lets do this,
1. Go to sql server configuration manager
2. Sql server network configuration
3. Protocols for MSSQLSERVER
there you will see three options,
1. Shared memory
2. Named Pipes
3. TCP IP
check if they are disabled, if Named PIPED disabled, enable them,
do same thing on SQL Native client 11.0 configuration---Client protocols--- you will see same options as above. Enable Named pipe . ( this is important since you are connecting through ODBC or any external connections. )