Problem :
A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 28 - Server doesn't support strong text requested protocol .
Solution :
In general this issues will be occurred in SQL Express editions in order to fix it follow the below steps .
1. Start --> Microsoft SQL Server (Version ) --> Configuration Tools --> SQL Server Configuration Manager
2. Make sure for any client protocols for SQL Express needs that TCP/IP is set to "Enabled" and Named Pipes are set to "Disabled".
After the above steps you need to restart SQL Server Browser and SQL Server (Instance ) services.
A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 28 - Server doesn't support strong text requested protocol .
Solution :
In general this issues will be occurred in SQL Express editions in order to fix it follow the below steps .
1. Start --> Microsoft SQL Server (Version ) --> Configuration Tools --> SQL Server Configuration Manager
2. Make sure for any client protocols for SQL Express needs that TCP/IP is set to "Enabled" and Named Pipes are set to "Disabled".
After the above steps you need to restart SQL Server Browser and SQL Server (Instance ) services.
No comments:
Post a Comment