Solved

Lost access to local SQL Server via SSMS

Posted on 2015-01-22
3
107 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 50

Accepted Solution

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

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

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Suggested Solutions

For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Via a live example, show how to shrink a transaction log file down to a reasonable size.

751 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