Hi to all! I am using sql server 2008 enterprise edition. My instance name is "saboor-pc/ SQLSERVERENT". I am using this server for many months and i am satisfied but today an unexpected error occured when i clicked on "connect" button in sql server management studio. The error was: "Cannot connect to
SABOOR-PC/MSSQLSERVERENT
A connection was successfully established with the server, but then an error occured during the pre-login handshake(provider: SSL Provider, error:0 The message recieved was un expected or badly formatted)(MicroSoft SQL Server)"
above is the error statement in double quots. Please guide me how can i solve this error because i have to do v important work on database which i have created in this server.
Saboor880 9 Junior Poster
rubberman 1,355 Nearly a Posting Virtuoso Featured Poster
Have you tried restarting the server? Did your system crash while SqlServer was running? You also might run a disk check to see if you have disc / file system problems.
RudyM
Have there been changes in the system, like new software install/upgrade? I've come across this: https://social.msdn.microsoft.com/Forums/vstudio/en-US/2d11b6f9-3ada-4682-b643-c721a97af4ba/cant-connect-to-database-after-installing-vs-11-pro-beta?forum=vssetup
TL;DR, this may help:netsh Winsock reset
Saboor880 9 Junior Poster
RudyM , I have tried "netsh Winsock reset" but my problem is not solved . But i have installed Eclipse as new software in my system.
Rubber Man I have tried to restarted my problem but my server does not restared and again that error message displayed which I showed above. My system did not crash ever using SQl server.
Saboor880 9 Junior Poster
Sorry , restarted my server not problem.
Saboor880 9 Junior Poster
Hello! actually i wrote above statement ("sorry, restarted my server not problem ") to correct my sentence in previous reply. My server connection problem is not solved yet. if any person have any technique to solve this then please reply.
Oleg_3 0 Newbie Poster
Have you visited msdn? maybe there you can find the solution..
Alec_2 0 Newbie Poster
In some installations of SQL Server, connecting to the Database Engine from another computer is not enabled unless an administrator uses Configuration Manager to enable it. To enable connections from another computer:
Open SQL Server Configuration Manager, as described earlier.
Using Configuration Manager, in the left pane expand SQL Server Network Configuration, and then select the instance of SQL Server that you want to connect to. The right-pane lists the connection protocols available. Shared Memory is normally enabled. It can only be used from the same computer, so most installations leave Shared Memory enabled. To connect to SQL Server from another computer you will normally use TCP/IP. If TCP/IP is not enabled, right-click TCP/IP, and then click Enable.
If you changed the enabled setting for any protocol you must restart the Database Engine. In the left pane select SQL Server Services. In the right-pane, right-click the instance of the Database Engine, and then click Restart.
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.