Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Lost access to local SQL Server via SSMS

Posted on 2015-01-22
3
Medium Priority
?
120 Views
Last Modified: 2015-01-22
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
Comment
Question by:JonahGroup
  • 2
3 Comments
 
LVL 52

Accepted Solution

by:
Vitor Montalvão earned 2000 total points
ID: 40564255
SQL Server Browser service is running?
0
 
LVL 52

Expert Comment

by:Vitor Montalvão
ID: 40564256
And is better you changer your SA password. Now everyone knows it :)
0
 

Author Closing Comment

by:JonahGroup
ID: 40564269
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

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I have a large data set and a SSIS package. How can I load this file in multi threading?
In part one, we reviewed the prerequisites required for installing SQL Server vNext. In this part we will explore how to install Microsoft's SQL Server on Ubuntu 16.04.
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
Via a live example, show how to shrink a transaction log file down to a reasonable size.

783 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question