broken SQL 2008 SP1 Web Edition (can not login with SSMS)

Posted by gerryLowry on Stack Overflow See other posts from Stack Overflow or by gerryLowry
Published on 2010-03-01T13:14:33Z Indexed on 2010/03/21 9:11 UTC
Read the original article Hit count: 340

Filed under:

Scenario:

My installation of SQL Server 2008 Web Edition SP1 was working properly.

Since I've recently joined Microsoft's Website Spark*, I removed SQL2008 and installed SQL 2008 again using my Website Spark edition and license from the MSDN download site.

Next, I updated SQL 2008 to SP1 (this is required because I'm running Windows 2008 Server R2 Web edition).

When I launch SSMS (SQL Server Management Studio), "User name" is "myhost\Administrator" and is greyed out so it can not be changed.

When I installed my Website Spark version, I did not include "myhost\Administrator" when I was configuring SQL 2008 service accounts.

Instead I created an administrator account "myhost\mySQLaccount".

ERROR MESSAGE:

Connect to Server
  (X)  Cannot connect to    (local)

   Additional information:
      Login failed for user 'myhost'Admistrator'
      (Microsoft SQL Server, Error:  18456)

I tried to use the SQL Server Configuration Manager to correct this problem but could not find any useful way to fix this issue.

How to I fix this problem?

Connect to Server ...
  Server type:          Database Engine
  Server name:           (local)
  Authentication:     Windows Authentication

Please advise.

Thank you.

Gerry

* http://www.microsoft.com/web/websitespark/default.aspx

© Stack Overflow or respective owner

Related posts about sql-server