Open SQL Configuration manager
Under SQL native Claint Configuration
Enable TCP,Named Pipes, VIA
Then open
1. Go to server machine and log in to Sql Server Management Studio.
2. Right click on server -> select Properties
3. Click on connections -> Check whether 'Allow remote connections to this server'.
4. If this option is not checked then select the option and try to connect from other system.
5. Also check the Security tab -> Server authentication -> should be 'SQL Server and Windows Authentication mode'
If you are using Windows 7 then
When you open the SQL Server Configuration, right click and select RUN AS ADMINISTRATOR if you are on Windows 7 before making the above mentioned changes.
Under SQL native Claint Configuration
Enable TCP,Named Pipes, VIA
Then open
1. Go to server machine and log in to Sql Server Management Studio.
2. Right click on server -> select Properties
3. Click on connections -> Check whether 'Allow remote connections to this server'.
4. If this option is not checked then select the option and try to connect from other system.
5. Also check the Security tab -> Server authentication -> should be 'SQL Server and Windows Authentication mode'
If you are using Windows 7 then
When you open the SQL Server Configuration, right click and select RUN AS ADMINISTRATOR if you are on Windows 7 before making the above mentioned changes.
No comments:
Post a Comment