Re: SQL2005 non-administrator Service Account
- From: "Rick Byham, \(MSFT\)" <rickbyh@xxxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Thu, 1 May 2008 08:55:49 -0700
You may have this figured out by now, but some observations:
Your first message says the SQL Server Service won't start, but the second message has the results of queries, so it must have started.
Your second message says the queries return bob as the name of the server. Since you say "we renamed BOBnew to BOB" you sound like you don't have a problem.
Do you only have a problem with the name in Registered Servers? Drop the server registration and re-register it.
I probably don't understand something. If you still have a problem, please clarify.
--
Rick Byham (MSFT), SQL Server Books Online
This posting is provided "AS IS" with no warranties, and confers no rights.
"SQLDudette" <SQLDudette@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:49784645-A3F4-4FA7-B898-7A2433B0A155@xxxxxxxxxxxxxxxx
Also, i have run both of these and they both give the results "bob"
SELECT @@SERVERNAME
SELECT SERVERPROPERTY('MachineName'), SERVERPROPERTY ('InstanceName')
When I right click on the server in Managment Studio, and hit register, it
also has bob as the server name.
Any assistance would be appreciated!!
"SQLDudette" wrote:
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
.
- Follow-Ups:
- Re: SQL2005 non-administrator Service Account
- From: SQLDudette
- Re: SQL2005 non-administrator Service Account
- Prev by Date: Re: Confused about Windows Authentication
- Next by Date: Builtin\Administrator does not have server access
- Previous by thread: Re: Confused about Windows Authentication
- Next by thread: Re: SQL2005 non-administrator Service Account
- Index(es):
Relevant Pages
|
|
