Re: Connextion Error After Installing SQL Server 2005 on Vista

Hi Rick,

Your suggestion of right clicking and running as an admin worked perfectly. Thanks very much for the info. I clicked on the link you listed, but do not quite understand something. In Management Studio, under Security/Logins there are 6 accounts listed:

1. Bob-PC\SQLServer2005MSFTEUser$BOB-PC$MSSQLSERVER
2. Bob-PC\SQLServer2005MSSQLUser$BOB-PC$MSSQLSERVER
3. Bob-PC\SQLServer2005SQLAgentUser$BOB-PC$MSSQLSERVER
4. BUILTIN\Administrators
5. NT AUTHORITY\SYSTEM
6. sa

I right clicked the first login above and selected Properties. It did not have any admin privs under Server Roles. So, I added sysadmin privs for this login. All the other logins already had sysadmin selected. When I exited and tried to restart, this time without right clicking and selecting "run as admin", it failed to connect again. So, can you tell me what the first 3 logins are used for and if I need to create a new login, then what should be the exact name of that login?

Thanks again for your help.

Bob Bryan

"Rick Byham, (MSFT)" <rickbyh@xxxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:E2BEF355-D50A-4329-BF9B-99853A5876DF@xxxxxxxxxxxxxxxx
You are probably trying to connect as Bob using your membership in the computers local administrators group; the BUILTIN\ADMINISTRATORS group being a member of the sysadmin fixed server role in SQL Server. But Vista User Account Control (UAC) doesn't automatically pass your administrator credentials to programs. The solution is to explicitly grant Bob access to SQL Server.
Right-click Management Studio and click Run as Administrator (passing your admin credentials). Then, if this was your problem you will be able to connect. Add Bob as a login and as a sysadmin.
From now on you can connect without using your administrator credentials.
For more info: http://msdn.microsoft.com/en-us/library/bb326612.aspx
--
Rick Byham (MSFT), SQL Server Books Online
This posting is provided "AS IS" with no warranties, and confers no rights.

"Bob Bryan" <RobertGBryanREMOVETHIS@xxxxxxx> wrote in message news:RcTqk.23542$LF2.22284@xxxxxxxxxxxxxxx
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

  • Re: Domain Admin login failure.
    ... specific login in SQL Server. ... Then it won't need it's admin privileges. ... Rick Byham, SQL Server Books Online ... administrator, it will let my domain admin account login. ...
    (microsoft.public.sqlserver.security)
  • Re: Is there any way to prevent hacker trying to guess sa password?
    ... What is the migration path like to SQL Server 2005? ... How is installation and setup? ... I setup my own SQL Server accounts and use those. ... You can include the login (such as sa, admin, ...
    (microsoft.public.sqlserver.security)
  • Re: SQL Server 2005 login with Windows Authentication
    ... I obviously installed SQL Server using my Francois (admin) local user ... So having stated that I chose windows authentication as ... And the reason for this is that a Windows login also can have access ...
    (microsoft.public.sqlserver.security)
  • Re: MSDE password change for "sa"
    ... I login to the machine as a local admin and connect via the ... > Upgrading to SQL Server isn't too bad. ... You will be asked if you want to upgrade ...
    (microsoft.public.sqlserver.server)
  • RE: Linked server issue
    ... SQL Server logins to the Admin account of the Access database. ... Add a new linked server using SQL Server Enterprise Manager. ... Remote login: Admin ...
    (microsoft.public.sqlserver.tools)