<div>
And is better you changer your SA password. Now everyone knows it :)
</div>


And is better you changer your SA password. Now everyone knows it :)

<div>
Oh geez, I forgot about that thing. Sure enough, it was stopped. <br />
<br />
The &quot;sa&quot; password shown is my special &quot;expose to the world&quot; password. I'll change it back.<br />
<br />
Thanks so much!<br />
<br />
Scott.
</div>


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.

<div>
<div class="content wysiwyg-content">
Hello,<br />
<br />
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 &nbsp;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.<br />
<br />
<br />
<a href="https://filedb.experts-exchange.com/incoming/2015/01_w04/893819/SSMS-access1.jpg" target="_blank" title="SSMS-access1.jpg (103 KB)"><img alt="SSMS-access1.jpg" class="file-block lazyload" style="max-width: 623px;" data-src="https://filedb.experts-exchange.com/incoming/2015/01_w04/893819/SSMS-access1.jpg" /></a><a href="https://filedb.experts-exchange.com/incoming/2015/01_w04/893820/sqlcmd-access1.jpg" target="_blank" title="sqlcmd-access1.jpg (80 KB)"><img alt="sqlcmd-access1.jpg" class="file-block lazyload" style="max-width: 800px;" data-src="https://filedb.experts-exchange.com/incoming/2015/01_w04/800_893820/sqlcmd-access1.jpg" /></a><a href="https://filedb.experts-exchange.com/incoming/2015/01_w04/893821/SSMS-version1.jpg" target="_blank" title="SSMS-version1.jpg (95 KB)"><img alt="SSMS-version1.jpg" class="file-block lazyload" style="max-width: 476px;" data-src="https://filedb.experts-exchange.com/incoming/2015/01_w04/893821/SSMS-version1.jpg" /></a>
</div>
</div>


SSMS-access1.jpg

SSMS-version1.jpg

sqlcmd-access1.jpg

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.






Lost access to local SQL Server via SSMS

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.