Re: at least one service or driver failed during startup - SQLSERVERAG

The services logged in using local credentials (Servername\accountname).
When you changed the server name, the account information was no longer
valid. I find it helpful to use domain-level accounts for the SQL servicess
to avoid this type of situation. Put the domain account in the local
administrators group and everything should work just fine.

BTW, you will need to change the name within the SQL Server. BOL has an
incomplete description of how

BUG: "Renaming A Server" Topic in SQL Server Books Online is Incomplete
http://support.microsoft.com/default.aspx?scid=kb;en-us;303774

--
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP




"yodarules" <yodarules@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:BB8024E0-A990-4F25-BE55-2D0FEF4CBAB4@xxxxxxxxxxxxxxxx
> Hi,
>
> We were in the process of building a new system, Windows 2003 SP1, SQL
> Server 2000 Ent Ed SP4. Installed Outlook 2003 and configured email for a
> local user with administrative previleges. Everything was working fine,
> email, startup accounts, etc. One of my collegue, changed the windows
> server
> name and on the next reboot we got this message.
>
> at least one service or driver failed during startup......
>
> Went into Eventviewer, and its said that "The SQLSERVERAGENT service
> hung on starting", but then when I looked at services it was running. So
> I
> changes the MSSQL Server and Agent startup account as LocalSystem and
> rebooted the box. No errors and all fine. Then I went & dropped the old
> local user, created a new user with admin rights. Added this user as the
> starup account for both services, when adding I added servername\username
> and
> all worked. Rebooted the error message pops up. What could have happened
> due to name change on the server and how can I rectify this. Thanks a
> lot.


.

Relevant Pages

  • Re: Compromise?
    ... Yes, if you don't provide a password on your SA account, anybody able to run ... and connect now has complete control over your SQL Server. ... Server has. ...
    (microsoft.public.sqlserver.security)
  • Re: Windows Auth to SQL Server from ATL Web Service not working...
    ... account I'm logged on as. ... SQL on a different box from my web service in an Atl Server web ... impersonation token is not passed on to the SQL Server. ... Event Category: Account Logon ...
    (microsoft.public.vc.atl)
  • Re: Discussing 3 different strategies for deleting from multiple tables
    ... I will be using SQL Server but I am riding on top of a third party ... FYI, Account contains around 20K ... >>> This results in one parameterized query followed by two more trips to ...
    (microsoft.public.data.ado)
  • Re: New Hardware, same domain name
    ... So I built a new server and loaded up 2003 sbs using the same domain ... Logged in as the local admin account on the WS and joined the ... While the computer is still in domain A, create a local user account. ... You really need to keep your profiles miniscule, ...
    (microsoft.public.windows.server.sbs)
  • RE: connection problems in secondary site and SQL server
    ... Do you have a Windows 2003 server anywhere in your environment? ... i can't add this account to this group. ... SMS Management Point encountered an error when connecting to its Database ... SMS on SQL Server My_Primary_SMS_Server. ...
    (microsoft.public.sms.admin)