A reality check please...
After changing the domain administrator password, we are no longer
able to connect to databases on a MS SQL Server 2000 server when
attempting to use ODBC drivers from W2K workstations.
The MSSQLSERVER and SQLSERVERAGENT services both show DomainName
\Administrator under the "Logon under This Account" in the 'Logon' tab
in services.msc. The server name inside the SQL server are set to
mixed mode.
Am I correct in thinking that changing the password field shown in the
"Login under This Account: DomainName\Administrator to match the new
domain administrator password will bring Joy?
Thanks!
BenoitSorry dude, I just saw this post. Yes, if you change a domain acct password
,
you have to change it in the services config box as well.
However, let me caution you... running SQL under an admin acct is bad
enough, but running it under the domain admin acct is just irresponsible.
Seriously, create a separate acct for SQL and give it local admin rights if
you have to, but DON"T use the domain admin acct.
"bntgoogle@.yahoo.com" wrote:
> A reality check please...
> After changing the domain administrator password, we are no longer
> able to connect to databases on a MS SQL Server 2000 server when
> attempting to use ODBC drivers from W2K workstations.
> The MSSQLSERVER and SQLSERVERAGENT services both show DomainName
> \Administrator under the "Logon under This Account" in the 'Logon' tab
> in services.msc. The server name inside the SQL server are set to
> mixed mode.
> Am I correct in thinking that changing the password field shown in the
> "Login under This Account: DomainName\Administrator to match the new
> domain administrator password will bring Joy?
> Thanks!
> Benoit
>
Showing posts with label startup. Show all posts
Showing posts with label startup. Show all posts
Sunday, February 12, 2012
administrator password and sql startup
A reality check please...
After changing the domain administrator password, we are no longer
able to connect to databases on a MS SQL Server 2000 server when
attempting to use ODBC drivers from W2K workstations.
The MSSQLSERVER and SQLSERVERAGENT services both show DomainName
\Administrator under the "Logon under This Account" in the 'Logon' tab
in services.msc. The server name inside the SQL server are set to
mixed mode.
Am I correct in thinking that changing the password field shown in the
"Login under This Account: DomainName\Administrator to match the new
domain administrator password will bring Joy?
Thanks!
Benoit
Sorry dude, I just saw this post. Yes, if you change a domain acct password,
you have to change it in the services config box as well.
However, let me caution you... running SQL under an admin acct is bad
enough, but running it under the domain admin acct is just irresponsible.
Seriously, create a separate acct for SQL and give it local admin rights if
you have to, but DON"T use the domain admin acct.
"bntgoogle@.yahoo.com" wrote:
> A reality check please...
> After changing the domain administrator password, we are no longer
> able to connect to databases on a MS SQL Server 2000 server when
> attempting to use ODBC drivers from W2K workstations.
> The MSSQLSERVER and SQLSERVERAGENT services both show DomainName
> \Administrator under the "Logon under This Account" in the 'Logon' tab
> in services.msc. The server name inside the SQL server are set to
> mixed mode.
> Am I correct in thinking that changing the password field shown in the
> "Login under This Account: DomainName\Administrator to match the new
> domain administrator password will bring Joy?
> Thanks!
> Benoit
>
After changing the domain administrator password, we are no longer
able to connect to databases on a MS SQL Server 2000 server when
attempting to use ODBC drivers from W2K workstations.
The MSSQLSERVER and SQLSERVERAGENT services both show DomainName
\Administrator under the "Logon under This Account" in the 'Logon' tab
in services.msc. The server name inside the SQL server are set to
mixed mode.
Am I correct in thinking that changing the password field shown in the
"Login under This Account: DomainName\Administrator to match the new
domain administrator password will bring Joy?
Thanks!
Benoit
Sorry dude, I just saw this post. Yes, if you change a domain acct password,
you have to change it in the services config box as well.
However, let me caution you... running SQL under an admin acct is bad
enough, but running it under the domain admin acct is just irresponsible.
Seriously, create a separate acct for SQL and give it local admin rights if
you have to, but DON"T use the domain admin acct.
"bntgoogle@.yahoo.com" wrote:
> A reality check please...
> After changing the domain administrator password, we are no longer
> able to connect to databases on a MS SQL Server 2000 server when
> attempting to use ODBC drivers from W2K workstations.
> The MSSQLSERVER and SQLSERVERAGENT services both show DomainName
> \Administrator under the "Logon under This Account" in the 'Logon' tab
> in services.msc. The server name inside the SQL server are set to
> mixed mode.
> Am I correct in thinking that changing the password field shown in the
> "Login under This Account: DomainName\Administrator to match the new
> domain administrator password will bring Joy?
> Thanks!
> Benoit
>
Thursday, February 9, 2012
admin name change does not allow mssql to start up
I installed mssql 2K when the sys admin acount name was adminis1. I used that as the service startup account. Everything worked fine. I had to change the sys admin account name to adminis2. When I rebooted Mssql would not start up (because adminis1 did not exist anymore). I added a new account with the old name (adminis1) then rebooted but mssql would still not start. I renamed the sys admin account back to the original name and now mssql starts up. We still need to go to the adminis2 name (a local standards thing)
How do I set up the data base to start with this new name?Hi,
From your post I understand that you only change the Account name and not
the password. If this is the case then, you can edit the registry and
change the user name, to reflect the new user and the SQL Server Service
will start. Once the SQL Service starts, you can modify the Startup Account
Name for the additional services like the SQL Server Agent Service.
Start Regedit and go the following key
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\MSSQLSERVER
Modify the String Value for "ObjectName" to the new account name.
Close Regedit
Start the SQL Server Service.
IMPORTANT: This article contains information about editing the registry.
Before you edit the registry, you should first make a backup copy of the
registry files (System.dat and User.dat). Both are hidden files in the
Windows folder.
WARNING: Using Registry Editor incorrectly can cause serious problems that
may require you to reinstall Operating System. Microsoft cannot guarantee
that problems resulting from the incorrect use of Registry Editor can be
solved. Use Registry Editor at your own risk.
Ashish
This posting is provided "AS IS" with no warranties, and confers no rights.
How do I set up the data base to start with this new name?Hi,
From your post I understand that you only change the Account name and not
the password. If this is the case then, you can edit the registry and
change the user name, to reflect the new user and the SQL Server Service
will start. Once the SQL Service starts, you can modify the Startup Account
Name for the additional services like the SQL Server Agent Service.
Start Regedit and go the following key
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\MSSQLSERVER
Modify the String Value for "ObjectName" to the new account name.
Close Regedit
Start the SQL Server Service.
IMPORTANT: This article contains information about editing the registry.
Before you edit the registry, you should first make a backup copy of the
registry files (System.dat and User.dat). Both are hidden files in the
Windows folder.
WARNING: Using Registry Editor incorrectly can cause serious problems that
may require you to reinstall Operating System. Microsoft cannot guarantee
that problems resulting from the incorrect use of Registry Editor can be
solved. Use Registry Editor at your own risk.
Ashish
This posting is provided "AS IS" with no warranties, and confers no rights.
admin name change does not allow mssql to start up
I installed mssql 2K when the sys admin acount name was adminis1. I used that as the service startup account. Everything worked fine. I had to change the sys admin account name to adminis2. When I rebooted Mssql would not start up (because adminis1 di
d not exist anymore). I added a new account with the old name (adminis1) then rebooted but mssql would still not start. I renamed the sys admin account back to the original name and now mssql starts up. We still need to go to the adminis2 name (a local
standards thing).
How do I set up the data base to start with this new name?
Hi,
From your post I understand that you only change the Account name and not
the password. If this is the case then, you can edit the registry and
change the user name, to reflect the new user and the SQL Server Service
will start. Once the SQL Service starts, you can modify the Startup Account
Name for the additional services like the SQL Server Agent Service.
Start Regedit and go the following key
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Servic es\MSSQLSERVER
Modify the String Value for "ObjectName" to the new account name.
Close Regedit
Start the SQL Server Service.
IMPORTANT: This article contains information about editing the registry.
Before you edit the registry, you should first make a backup copy of the
registry files (System.dat and User.dat). Both are hidden files in the
Windows folder.
WARNING: Using Registry Editor incorrectly can cause serious problems that
may require you to reinstall Operating System. Microsoft cannot guarantee
that problems resulting from the incorrect use of Registry Editor can be
solved. Use Registry Editor at your own risk.
Ashish
This posting is provided "AS IS" with no warranties, and confers no rights.
d not exist anymore). I added a new account with the old name (adminis1) then rebooted but mssql would still not start. I renamed the sys admin account back to the original name and now mssql starts up. We still need to go to the adminis2 name (a local
standards thing).
How do I set up the data base to start with this new name?
Hi,
From your post I understand that you only change the Account name and not
the password. If this is the case then, you can edit the registry and
change the user name, to reflect the new user and the SQL Server Service
will start. Once the SQL Service starts, you can modify the Startup Account
Name for the additional services like the SQL Server Agent Service.
Start Regedit and go the following key
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Servic es\MSSQLSERVER
Modify the String Value for "ObjectName" to the new account name.
Close Regedit
Start the SQL Server Service.
IMPORTANT: This article contains information about editing the registry.
Before you edit the registry, you should first make a backup copy of the
registry files (System.dat and User.dat). Both are hidden files in the
Windows folder.
WARNING: Using Registry Editor incorrectly can cause serious problems that
may require you to reinstall Operating System. Microsoft cannot guarantee
that problems resulting from the incorrect use of Registry Editor can be
solved. Use Registry Editor at your own risk.
Ashish
This posting is provided "AS IS" with no warranties, and confers no rights.
admin name change does not allow mssql to start up
I installed mssql 2K when the sys admin acount name was adminis1. I used th
at as the service startup account. Everything worked fine. I had to change
the sys admin account name to adminis2. When I rebooted Mssql would not st
art up (because adminis1 di
d not exist anymore). I added a new account with the old name (adminis1) th
en rebooted but mssql would still not start. I renamed the sys admin accoun
t back to the original name and now mssql starts up. We still need to go to
the adminis2 name (a local
standards thing).
How do I set up the data base to start with this new name?Hi,
From your post I understand that you only change the Account name and not
the password. If this is the case then, you can edit the registry and
change the user name, to reflect the new user and the SQL Server Service
will start. Once the SQL Service starts, you can modify the Startup Account
Name for the additional services like the SQL Server Agent Service.
Start Regedit and go the following key
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControl
Set\Services\MSSQLSERVER
Modify the String Value for "ObjectName" to the new account name.
Close Regedit
Start the SQL Server Service.
IMPORTANT: This article contains information about editing the registry.
Before you edit the registry, you should first make a backup copy of the
registry files (System.dat and User.dat). Both are hidden files in the
Windows folder.
WARNING: Using Registry Editor incorrectly can cause serious problems that
may require you to reinstall Operating System. Microsoft cannot guarantee
that problems resulting from the incorrect use of Registry Editor can be
solved. Use Registry Editor at your own risk.
Ashish
This posting is provided "AS IS" with no warranties, and confers no rights.
at as the service startup account. Everything worked fine. I had to change
the sys admin account name to adminis2. When I rebooted Mssql would not st
art up (because adminis1 di
d not exist anymore). I added a new account with the old name (adminis1) th
en rebooted but mssql would still not start. I renamed the sys admin accoun
t back to the original name and now mssql starts up. We still need to go to
the adminis2 name (a local
standards thing).
How do I set up the data base to start with this new name?Hi,
From your post I understand that you only change the Account name and not
the password. If this is the case then, you can edit the registry and
change the user name, to reflect the new user and the SQL Server Service
will start. Once the SQL Service starts, you can modify the Startup Account
Name for the additional services like the SQL Server Agent Service.
Start Regedit and go the following key
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControl
Set\Services\MSSQLSERVER
Modify the String Value for "ObjectName" to the new account name.
Close Regedit
Start the SQL Server Service.
IMPORTANT: This article contains information about editing the registry.
Before you edit the registry, you should first make a backup copy of the
registry files (System.dat and User.dat). Both are hidden files in the
Windows folder.
WARNING: Using Registry Editor incorrectly can cause serious problems that
may require you to reinstall Operating System. Microsoft cannot guarantee
that problems resulting from the incorrect use of Registry Editor can be
solved. Use Registry Editor at your own risk.
Ashish
This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to:
Posts (Atom)