Connextion Error After Installing SQL Server 2005 on Vista

I just installed SQL Server 2005 on my Vista (SP1) laptop. I also successfully installed SQL Server SP2 for Vista. When going into SQL Server Management Studio and connection to the default instance of the server that was just installed, the following error is generated in the log file:

2008-08-20 03:09:55.36 Logon Error: 18456, Severity: 14, State: 11.
2008-08-20 03:09:55.36 Logon Login failed for user 'Bob-PC\Bob'. [CLIENT: <local machine>]

During the installation, I was prompted a couple of times to install a service pack for Visual Studio 2005, which is not currently installed. Visual Studio 2008 with Beta SP1 is installed. Using the Surface Area Configuration tool, the Database engine component, SQL Server Agent, Full-Text Search, and SQL Server Browser are all running.

SQL Server 2008 was installed on this machine previously, but since there were similar problems with connecting, I tried to un-install it, but not all of the components were completely removed. I have now spent at least 10 hours trying to get this to work and am about to give up and try another database. I never had any problems installing or connecting to SQL Server 2005 with Windows XP. Can anyone offer any helpful suggestions?

Thanks,

Bob Bryan

.

Relevant Pages

  • [NT] SQL Server Installation Process May Leave Passwords on System
    ... service pack for SQL Server 7.0 or SQL Server 2000, ... without having to actually perform an installation. ... to SQL Server 7.0 Service Pack 4, the passwords were stored in clear text. ... information in the setup.iss and log files would not allow any access. ...
    (Securiteam)
  • RE: Error Code: 1073807364 sql server 2005
    ... contain the files that are required during the installation of SQL Server ... In the D:\SQLServer2005 folder, ... Setup.exe to start the SQL Server 2005 Setup program. ...
    (microsoft.public.windows.server.sbs)
  • RE: Error installing (KB 921896)
    ... Package Language: 1033 ... Package Platform: x86 ... Product Installation Status ... to SQL Server. ...
    (microsoft.public.windowsupdate)
  • RE: Upgrading to SQL 2005 ENT
    ... It gives a good step by step how to on upgrading to SQL Server 2005. ... I might not have IIS installed which might have ... some SQL Server features will not be available for installation. ... It has the same version from the Enterprise Manager. ...
    (microsoft.public.sqlserver.server)
  • RE: Getting to the bottom of MSDE network connection problems ...
    ... the way using the same installation scenario on Win2K works with no problem. ... > various versions of MSDE and Windows XP ... > and it seems the problems are due to Windows XP and not MSDE. ... > on a desktop OS like XP (meaning that, you can not compare SQL Server ...
    (microsoft.public.sqlserver.msde)