Very strange SSMS connection issue

  • i am at a lost and hope the brain trust here can help...

    I am unable to log in to database via SSMS both local sql server or networked sql server.

    I am able to ping the server, telnet 1433 to it but when SSMS is trying to log in, the color bar just keeps running. I am able to log into the integrated services but not the database engine.

    This is happening to my machine and another user. But the third person is fine. The server themselves are running fine and log in with no problem.

    It must be my machine but I just can't find out what... firewall or no firewall makes no difference. It just stopped working today as it worked a few days ago.

    Any suggestions are welcome...

    Frank

  • Does sqlcmd work?

    -- Gianluca Sartori

  • Check your Configuration Manager to see if you have any config issues, aliases, something along those lines. Compare your Config Manager to the person who is successful to see if they're using a different protocol or something.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

  • Did you try to run as Administrator?

  • Thank you all for your suggestions.

    I am not sure why this is the case but "Run as Administrator" resolved the issue. I have been running the SSMS from my shortcut all this time without issue before.

    I am back to "Happy Mood" now - Thanks you all.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply