February 18, 2015 at 10:30 pm
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
February 19, 2015 at 2:34 am
Does sqlcmd work?
-- Gianluca Sartori
February 19, 2015 at 5:05 am
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
February 19, 2015 at 3:09 pm
Did you try to run as Administrator?
February 19, 2015 at 4:50 pm
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