SQL2005 non-administrator Service Account

On server BOB, the SQL Services are running under an ID that by default was
added to the SQL server groups
SQLServer2005MSFTEUser$-ServerName-$MSSQLSERVER etc. However, the ID is also
under the administrators group and I would like to remove it from there. I
used a test 2005 box to test this, however, when I removed the id from the
administrators, the SQL Server Service would not start up. We did however
change the name of this box as it was a replacement for an existing server,
the initial name was BOBnew because it was replacing a server named BOB, then
when we shut down BOB, we renamed BOBnew to BOB. In the SQL server group, the
–ServerName- is still BOBnew – it didn’t change when we changed the name of
the box.

Could this have something to do with the SQL service not starting up?

Thanks,
Karime

.

Relevant Pages

  • Re: How to represent category, subcategory, product
    ... I waited days with no reply on a SQL Server ... Thanks Gene, Lennart, Neo, Bob for your suggestions, some very helpful ... Neo, your suggestion is intriguing, I'll be looking into it. ... haven't found any database counterparts of the libraries of algorithms ...
    (comp.databases.theory)
  • Re: Connextion Error After Installing SQL Server 2005 on Vista
    ... But Vista User Account Control doesn't automatically pass your administrator credentials to programs. ... The solution is to explicitly grant Bob access to SQL Server. ... During the installation, I was prompted a couple of times to install a service pack for Visual Studio 2005, which is not currently installed. ...
    (microsoft.public.sqlserver.connect)
  • Re: THANKS! -> Re: Valid MS Access SQL Syntax (Double JOINtedness)
    ... >> expanding my knowledge on the topic. ... >> Will the Access syntax work on SQL Server? ... > Bob Barrows. ... > quicker response by posting to the newsgroup. ...
    (microsoft.public.access.formscoding)
  • Re: THANKS! -> Re: Valid MS Access SQL Syntax (Double JOINtedness)
    ... >> expanding my knowledge on the topic. ... >> Will the Access syntax work on SQL Server? ... > Bob Barrows. ... > quicker response by posting to the newsgroup. ...
    (microsoft.public.sqlserver.programming)
  • Re: Alter Database Move column
    ... Although you didn't ask, Bob, it is often considered to be a flaw when we ... I support the Professional Association of SQL Server and it's community of SQL Server professionals. ... > I have looked at the Alter Table syntax help but can't see any indication of> ordinal control. ... > alter table MasterStationTest ...
    (microsoft.public.sqlserver.server)