RE: SQL2005 non-administrator Service Account
- From: SQLDudette <SQLDudette@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Mon, 28 Apr 2008 16:00:00 -0700
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
- References:
- SQL2005 non-administrator Service Account
- From: SQLDudette
- SQL2005 non-administrator Service Account
- Prev by Date: SQL2005 non-administrator Service Account
- Next by Date: SQL 2005 Profiler
- Previous by thread: SQL2005 non-administrator Service Account
- Next by thread: SQL 2005 Profiler
- Index(es):
Relevant Pages
|
|
