• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 123
  • Last Modified:

Lost access to local SQL Server via SSMS

Hello,

I seem to have lost my ability to connect to my local server using SQL Server Management Studio. I had been using it for many months, then it just  stopped working. The strange thing is that I can connect fine with sqlcmd. I don't really know where to start looking to investigate this. I've attached some details below.


SSMS-access1.jpgsqlcmd-access1.jpgSSMS-version1.jpg
0
JonahGroup
Asked:
JonahGroup
  • 2
1 Solution
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
SQL Server Browser service is running?
0
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
And is better you changer your SA password. Now everyone knows it :)
0
 
JonahGroupAuthor Commented:
Oh geez, I forgot about that thing. Sure enough, it was stopped.

The "sa" password shown is my special "expose to the world" password. I'll change it back.

Thanks so much!

Scott.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now