Friday, February 10, 2012

can not login sql server

Hello,
We have a Win 2003 server with SQL 2000 installed. When we upgrade Win 2003
server to Active Directory, then the SQL 2000 can not work any more.
We try to uninstall and install again, window mode or mixed mode.
The error message alwsays say "xxx/administrator is not associated with
trusted SQL server connection" or "login failed for user sa"
ThanksSo you promoted the Server to a domain controller ? The local Administrator
is deactivated with promoting the Server. Although the domain administrators
group is still working and should be associated with the
SystemAdministrators group. I wonder what security Account you typed in for
starting the sql Service ? Did you put in the system account or the
Administrators account ? If you put in the local admin account change it to
start up the server. When do you get thios messages ?
HTH, Jens Süßmeyer.
"Newbie" <Newbie@.discussions.microsoft.com> schrieb im Newsbeitrag
news:1FA3AC6A-C62A-4570-8242-BE4EBA273DA1@.microsoft.com...
> Hello,
> We have a Win 2003 server with SQL 2000 installed. When we upgrade Win
> 2003
> server to Active Directory, then the SQL 2000 can not work any more.
> We try to uninstall and install again, window mode or mixed mode.
> The error message alwsays say "xxx/administrator is not associated with
> trusted SQL server connection" or "login failed for user sa"
> Thanks|||So you promoted the Server to a domain controller ?
Yes.
The local Administrator is deactivated with promoting the Server. Although
the domain administrators group is still working and should be associated
with the SystemAdministrators group.
I wonder what security Account you typed in for starting the sql Service ?
Did you put in the system account or the Administrators account ?
If you put in the local admin account change it to start up the server. When
do you get this messages ?
I tried administrator first, the error message is "xxx/administrator is not
associated with trusted SQL server connection"
Then I installed again with mixed mode, the error message is "login failed
for user sa"
Thanks

No comments:

Post a Comment