Friday, March 30, 2012

MSSQL 2000 connection problem, please help

Explanation:
After attaching MSSQL 2000 SP3 server into domain,
Local Admin and SA cannot login into MSSQL
EM and QA are not working.
"Change the MSSQLServer service account to be a domain account. Make this
domain account a member of the
Local Administrators group on the machine." - Tried, but no chance.Hi
If SA can't login and you have not changed the password, it means that SQL
Server is not running. Check in control panel > services and also check the
NT event log to see what the failures are.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Djangar S." <snapplefor@.hotmail.com> wrote in message
news:%23HeSsEDnFHA.320@.TK2MSFTNGP09.phx.gbl...
> Explanation:
> After attaching MSSQL 2000 SP3 server into domain,
> Local Admin and SA cannot login into MSSQL
> EM and QA are not working.
>
>
> "Change the MSSQLServer service account to be a domain account. Make this
> domain account a member of the
> Local Administrators group on the machine." - Tried, but no chance.
>|||It is running, I have another applications witch constantly using SQL
Server.
Any ideas?
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
news:%23DjkpWDnFHA.3380@.TK2MSFTNGP12.phx.gbl...
> Hi
> If SA can't login and you have not changed the password, it means that SQL
> Server is not running. Check in control panel > services and also check
> the NT event log to see what the failures are.
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "Djangar S." <snapplefor@.hotmail.com> wrote in message
> news:%23HeSsEDnFHA.320@.TK2MSFTNGP09.phx.gbl...
>> Explanation:
>> After attaching MSSQL 2000 SP3 server into domain,
>> Local Admin and SA cannot login into MSSQL
>> EM and QA are not working.
>>
>>
>> "Change the MSSQLServer service account to be a domain account. Make this
>> domain account a member of the
>> Local Administrators group on the machine." - Tried, but no chance.
>>
>|||Hi,
What is the exact error message you are getting when trying to connect using
SA?
Thanks
Hari
SQL Server MVP
"Djangar S." <snapplefor@.hotmail.com> wrote in message
news:%23nD$t4DnFHA.1996@.TK2MSFTNGP10.phx.gbl...
> It is running, I have another applications witch constantly using SQL
> Server.
> Any ideas?
>
>
> "Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
> news:%23DjkpWDnFHA.3380@.TK2MSFTNGP12.phx.gbl...
>> Hi
>> If SA can't login and you have not changed the password, it means that
>> SQL Server is not running. Check in control panel > services and also
>> check the NT event log to see what the failures are.
>> Regards
>> --
>> Mike Epprecht, Microsoft SQL Server MVP
>> Zurich, Switzerland
>> IM: mike@.epprecht.net
>> MVP Program: http://www.microsoft.com/mvp
>> Blog: http://www.msmvps.com/epprecht/
>> "Djangar S." <snapplefor@.hotmail.com> wrote in message
>> news:%23HeSsEDnFHA.320@.TK2MSFTNGP09.phx.gbl...
>> Explanation:
>> After attaching MSSQL 2000 SP3 server into domain,
>> Local Admin and SA cannot login into MSSQL
>> EM and QA are not working.
>>
>>
>> "Change the MSSQLServer service account to be a domain account. Make
>> this domain account a member of the
>> Local Administrators group on the machine." - Tried, but no chance.
>>
>>
>sql

No comments:

Post a Comment