Cannot connect to sql2k801

Discussion in 'Databases' started by abodineau, Dec 6, 2010.

Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.
  1. I suddendly cannot connect to SQL Server (sql2k801) from Microsoft SQL Server Management Studio. I get this error message:

    The login and passwords are correct. It worked fine until a few hours ago.

    Any ideas?

    Anthony.
     
  2. The solution was to untick the 'Encrypt connection' box in the login window of Microsoft SQL Server Management Studio.

    This is very weird because I've always encrypted the connection until now and it has always worked.

    Has anything changed lately in the settings of the SQL Server?
     
  3. ...That is odd.
    Curious, do you also specify the Protocol or allow it to use the default?
    For example, I have always made sure I prefix the server with tcp:
    I've never used the Encrypt option however.
     
  4. I use the default protocol. I've just tried to prefix the server name with tcp: but it didn't change anything.
    Curiously if I specify the database I want to connect to, it works with the encrypted connection. Very weird.

    For info, if you don't encrypt the connection then any sql query you send from SQL Server MAnagement Studio to SQL Server over the internet is in clear text. It might not be very important but it's something to keep in mind. Encrypting the connection is straightfoward (you just need to tick the box) so I always do it. Well, until now that is.
     
  5. Thanks, noted. I'll play with this more and make some notes.

    It isn't important to me as you mentioned because I only use it for you guys. ;-)
    (Not that you guys aren't important, just that my test data isn't.)
    All the best,
    Mark
     
Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.

Share This Page