<div>
Make Sure that you are running Sql Server Managment Studio as Administrator.
</div>


<div>
I am running as a domain administrator
</div>


<div>
Have you Try to login as Sql Server Authentication with administrator credentials . 
</div>


<div>
Its the built in sharepoint server with sbs2008 so I dont know the sql server auth account. Is there a default?
</div>


<div>
The main database username and password that you have provided while installing Sql Server Managment Studio. 
</div>


<div>
No this is sbs 2008 it's a complete auto install.
</div>


<div>
Do you have UAE enabled?<br />
<br />
If so turn it off and try again.
</div>


<div>
LOL you are a legend. Man I feel stupid when UAC gets in the way. Thanks heaps
</div>


<div>
Dont feel stupid.<br />
<br />
I know about this error because I was getting microsoft support to help and they were having the same problem.<br />
<br />
I suggested UAC to be turned off as a possibility and it worked. That was after about 2 hours of doing all sorts of things!<br />
<br />
Glad it helped.<br />
<br />
Cheers<br />
<br />
nat 
</div>


<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
Having a few issues logging into the internal database. <br />
<br />
Background is I am getting a lot of 17137 errors in the event log on my sbs2008 box. <br />
Tried to follow this guide to resolve it: <a href="http://chrisdill.wordpress.com/2010/11/03/event-id-280/" rel="ugc">http://chrisdill.wordpress.com/2010/11/03/event-id-280/</a><br />
<br />
When I try to login to the SQL Management Studio Express I get the follow error<br />
<br />
&nbsp;<br />
&nbsp;<a href="https://filedb.experts-exchange.com/incoming/2011/01_w05/400162/2011-01-24-15h31-27.png" target="_blank" title="loginscreen (2 KB)"><img alt="loginscreen" class="file-block lazyload" style="max-width: 407px;" data-src="https://filedb.experts-exchange.com/incoming/2011/01_w05/400162/2011-01-24-15h31-27.png" /></a><br />
I then get the following error messege:<br />
TITLE: Connect to Server<br />
--------------------------<wbr />----<br />
<br />
Cannot connect to \\.\pipe\MSSQL$MICROSOFT##<wbr />SSEE\sql\q<wbr />uery.<br />
<br />
--------------------------<wbr />----<br />
ADDITIONAL INFORMATION:<br />
<br />
Login failed for user 'Administrator account'. (Microsoft SQL Server, Error: 18456)<br />
<br />
<br />
Another odd thing I noticed is when I go to the surage are configuation tool and change Local connections only -&gt; Local and Remote using both TCP/IP and named pipes after I reset the service and reopen the tool it is back to Local Connections Only. <br />
<br />
<br />
<br />
<br />

</div>
</div>


2011-01-24-15h31-27.png

Hi,

Having a few issues logging into the internal database. 

Background is I am getting a lot of 17137 errors in the event log on my sbs2008 box. 
Tried to follow this guide to resolve it: http://chrisdill.wordpress.com/2010/11/03/event-id-280/

When I try to login to the SQL Management Studio Express I get the follow error

 
 

I then get the following error messege:
TITLE: Connect to Server
------------------------------

Cannot connect to \\.\pipe\MSSQL$MICROSOFT##SSEE\sql\query.

------------------------------
ADDITIONAL INFORMATION:

Login failed for user 'Administrator account'. (Microsoft SQL Server, Error: 18456)


Another odd thing I noticed is when I go to the surage are configuation tool and change Local connections only -> Local and Remote using both TCP/IP and named pipes after I reset the service and reopen the tool it is back to Local Connections Only. 






Cannot log into SQL instance. \\.\pipe\MSSQL$MICROSOFT##SSEE\sql\query

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.

Microsoft SQL Server 2005

Small Business Server (SBS) is a line of server operating systems targeted at small businesses by bundling the operating system with a number of other Microsoft products that would normally need to be purchased or licensed separately. The most notable inclusions are Exchange, SQL Server, SharePoint and ISA/TMG (Microsoft's firewall and proxy server).