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...
>
|||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...
>

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...
>|||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...
>

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

MSSQL 2000 authentication problem.Please help, it is really interesting.

Explanation:
After attaching MSSQL 2000 SP3 server into domain,
Local Admin and SA cannot login into MSSQL
EM and QA are not working.
Even Local Admin cannot do it. But MSSQL is running, I have another
applications witch constantly using SQL Server (authentication by sql).
From previous thread.
Q.From Mike Epprecht
Q.Hi
Q.If SA can't login and you have not changed the password, it means that
SQL
Q.Server is not running. Check in control panel > services and also check
the
Q.NT event log to see what the failures are.
A.It is running, I have another applications witch constantly using SQL
Server.
1. Are the services runnin under local system account
2. Was this SP3 all along or did you patch it right before move
3. What Server/DBRoles is the login used by the application that can connect
part of
4. Was this server part of a different domain or standalone before move
5. What aduit level do you have set
6. What is showing up in errorlog
"Djangar S." <snapplefor@.hotmail.com> wrote in message
news:%23GkT2AuvFHA.3932@.TK2MSFTNGP15.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.
> Even Local Admin cannot do it. But MSSQL is running, I have another
> applications witch constantly using SQL Server (authentication by sql).
>
> From previous thread.
> Q.From Mike Epprecht
> Q.Hi
> Q.If SA can't login and you have not changed the password, it means that
> SQL
> Q.Server is not running. Check in control panel > services and also check
> the
> Q.NT event log to see what the failures are.
>
> A.It is running, I have another applications witch constantly using SQL
> Server.
>
|||Thank you David for your response.
1. Are the services runnin under local system account.
Yes. It is.
2. Was this SP3 all along or did you patch it right before move
Before move.
3.What Server/DBRoles is the login used by the application that can connect
part of.
Not able say exactly because it EM not working , but as far as I know
login's has different roles for one specific DB.
4.Was this server part of a different domain or standalone before move
Standalone.
5.What aduit level do you have set
Nothing.
6. What is showing up in errorlog
Nothing specific.
QA is showing :
Unable to connect to server XXX:
Msg 18456,Level 16,State 1
"David J. Cartwright" <davidcartwright@.hotmail.com> wrote in message
news:exIRpLuvFHA.3740@.TK2MSFTNGP14.phx.gbl...
> 1. Are the services runnin under local system account
> 2. Was this SP3 all along or did you patch it right before move
> 3. What Server/DBRoles is the login used by the application that can
> connect part of
> 4. Was this server part of a different domain or standalone before move
> 5. What aduit level do you have set
> 6. What is showing up in errorlog
>
> "Djangar S." <snapplefor@.hotmail.com> wrote in message
> news:%23GkT2AuvFHA.3932@.TK2MSFTNGP15.phx.gbl...
>
|||what does the sql server log have in it, also you can try to start sqlserver
from the command line while logged in as the (local) administrator account
for the computer...then try to connect with osql -E or Query analyzer...
"Djangar S." <snapplefor@.hotmail.com> wrote in message
news:eSqBy4uvFHA.2292@.TK2MSFTNGP12.phx.gbl...
> Thank you David for your response.
> 1. Are the services runnin under local system account.
> Yes. It is.
> 2. Was this SP3 all along or did you patch it right before move
> Before move.
> 3.What Server/DBRoles is the login used by the application that can
> connect part of.
> Not able say exactly because it EM not working , but as far as I
> know login's has different roles for one specific DB.
> 4.Was this server part of a different domain or standalone before move
> Standalone.
> 5.What aduit level do you have set
> Nothing.
>
> 6. What is showing up in errorlog
> Nothing specific.
> QA is showing :
> Unable to connect to server XXX:
> Msg 18456,Level 16,State 1
>
>
>
>
> "David J. Cartwright" <davidcartwright@.hotmail.com> wrote in message
> news:exIRpLuvFHA.3740@.TK2MSFTNGP14.phx.gbl...
>
|||Djangar S. wrote:
> Explanation:
> After attaching MSSQL 2000 SP3 server into domain,
> Local Admin and SA cannot login into MSSQL
> EM and QA are not working.
> Even Local Admin cannot do it. But MSSQL is running, I have another
> applications witch constantly using SQL Server (authentication by sql).
>
> From previous thread.
> Q.From Mike Epprecht
> Q.Hi
> Q.If SA can't login and you have not changed the password, it means that
> SQL
> Q.Server is not running. Check in control panel > services and also check
> the
> Q.NT event log to see what the failures are.
>
> A.It is running, I have another applications witch constantly using SQL
> Server.
>
When you have another application that can use the SQL server, have you
then tried to connect to the instance from EM using the account this
application is using? You could also check which account you have
registered in EM for connecting to the instance. Have you tried to to
create a new SQL server registration in EM using Windows Authentication
(while logged on to the server with an account that is local
administrator on the server.
Regards
Steen
|||Hello, Steen

>When you have another application that can use the SQL server, have you
>then tried to connect to the instance from EM using the account this
>application is using?
Unfortunatly this user information is not avalible for me. This
application is the closed box.

>Have you tried to to create a new SQL server registration in EM using
>Windows Authentication (while logged on to the server with an account that
>is local administrator on the server.
Yes, I did but same result.
"Steen Persson (DK)" <spe@.REMOVEdatea.dk> wrote in message
news:ec7j6P2vFHA.664@.tk2msftngp13.phx.gbl...
> Djangar S. wrote:
> When you have another application that can use the SQL server, have you
> then tried to connect to the instance from EM using the account this
> application is using? You could also check which account you have
> registered in EM for connecting to the instance. Have you tried to to
> create a new SQL server registration in EM using Windows Authentication
> (while logged on to the server with an account that is local administrator
> on the server.
> Regards
> Steen

MSSQL 2000 authentication problem.Please help, it is really interesting.

Explanation:
After attaching MSSQL 2000 SP3 server into domain,
Local Admin and SA cannot login into MSSQL
EM and QA are not working.
Even Local Admin cannot do it. But MSSQL is running, I have another
applications witch constantly using SQL Server (authentication by sql).
From previous thread.
Q.From Mike Epprecht
Q.Hi
Q.If SA can't login and you have not changed the password, it means that
SQL
Q.Server is not running. Check in control panel > services and also check
the
Q.NT event log to see what the failures are.
A.It is running, I have another applications witch constantly using SQL
Server.1. Are the services runnin under local system account
2. Was this SP3 all along or did you patch it right before move
3. What Server/DBRoles is the login used by the application that can connect
part of
4. Was this server part of a different domain or standalone before move
5. What aduit level do you have set
6. What is showing up in errorlog
"Djangar S." <snapplefor@.hotmail.com> wrote in message
news:%23GkT2AuvFHA.3932@.TK2MSFTNGP15.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.
> Even Local Admin cannot do it. But MSSQL is running, I have another
> applications witch constantly using SQL Server (authentication by sql).
>
> From previous thread.
> Q.From Mike Epprecht
> Q.Hi
> Q.If SA can't login and you have not changed the password, it means that
> SQL
> Q.Server is not running. Check in control panel > services and also check
> the
> Q.NT event log to see what the failures are.
>
> A.It is running, I have another applications witch constantly using SQL
> Server.
>|||Thank you David for your response.
1. Are the services runnin under local system account.
Yes. It is.
2. Was this SP3 all along or did you patch it right before move
Before move.
3.What Server/DBRoles is the login used by the application that can connect
part of.
Not able say exactly because it EM not working , but as far as I know
login's has different roles for one specific DB.
4.Was this server part of a different domain or standalone before move
Standalone.
5.What aduit level do you have set
Nothing.
6. What is showing up in errorlog
Nothing specific.
QA is showing :
Unable to connect to server XXX:
Msg 18456,Level 16,State 1
"David J. Cartwright" <davidcartwright@.hotmail.com> wrote in message
news:exIRpLuvFHA.3740@.TK2MSFTNGP14.phx.gbl...
> 1. Are the services runnin under local system account
> 2. Was this SP3 all along or did you patch it right before move
> 3. What Server/DBRoles is the login used by the application that can
> connect part of
> 4. Was this server part of a different domain or standalone before move
> 5. What aduit level do you have set
> 6. What is showing up in errorlog
>
> "Djangar S." <snapplefor@.hotmail.com> wrote in message
> news:%23GkT2AuvFHA.3932@.TK2MSFTNGP15.phx.gbl...
>|||what does the sql server log have in it, also you can try to start sqlserver
from the command line while logged in as the (local) administrator account
for the computer...then try to connect with osql -E or Query analyzer...
"Djangar S." <snapplefor@.hotmail.com> wrote in message
news:eSqBy4uvFHA.2292@.TK2MSFTNGP12.phx.gbl...
> Thank you David for your response.
> 1. Are the services runnin under local system account.
> Yes. It is.
> 2. Was this SP3 all along or did you patch it right before move
> Before move.
> 3.What Server/DBRoles is the login used by the application that can
> connect part of.
> Not able say exactly because it EM not working , but as far as I
> know login's has different roles for one specific DB.
> 4.Was this server part of a different domain or standalone before move
> Standalone.
> 5.What aduit level do you have set
> Nothing.
>
> 6. What is showing up in errorlog
> Nothing specific.
> QA is showing :
> Unable to connect to server XXX:
> Msg 18456,Level 16,State 1
>
>
>
>
> "David J. Cartwright" <davidcartwright@.hotmail.com> wrote in message
> news:exIRpLuvFHA.3740@.TK2MSFTNGP14.phx.gbl...
>|||Djangar S. wrote:
> Explanation:
> After attaching MSSQL 2000 SP3 server into domain,
> Local Admin and SA cannot login into MSSQL
> EM and QA are not working.
> Even Local Admin cannot do it. But MSSQL is running, I have another
> applications witch constantly using SQL Server (authentication by sql).
>
> From previous thread.
> Q.From Mike Epprecht
> Q.Hi
> Q.If SA can't login and you have not changed the password, it means that
> SQL
> Q.Server is not running. Check in control panel > services and also check
> the
> Q.NT event log to see what the failures are.
>
> A.It is running, I have another applications witch constantly using SQL
> Server.
>
When you have another application that can use the SQL server, have you
then tried to connect to the instance from EM using the account this
application is using? You could also check which account you have
registered in EM for connecting to the instance. Have you tried to to
create a new SQL server registration in EM using Windows Authentication
(while logged on to the server with an account that is local
administrator on the server.
Regards
Steen|||Hello, Steen

>When you have another application that can use the SQL server, have you
>then tried to connect to the instance from EM using the account this
>application is using?
Unfortunatly this user information is not avalible for me. This
application is the closed box.

>Have you tried to to create a new SQL server registration in EM using
>Windows Authentication (while logged on to the server with an account that
>is local administrator on the server.
Yes, I did but same result.
"Steen Persson (DK)" <spe@.REMOVEdatea.dk> wrote in message
news:ec7j6P2vFHA.664@.tk2msftngp13.phx.gbl...
> Djangar S. wrote:
> When you have another application that can use the SQL server, have you
> then tried to connect to the instance from EM using the account this
> application is using? You could also check which account you have
> registered in EM for connecting to the instance. Have you tried to to
> create a new SQL server registration in EM using Windows Authentication
> (while logged on to the server with an account that is local administrator
> on the server.
> Regards
> Steensql

MSSQL 2000 authentication problem.Please help, it is really interesting.

Explanation:
After attaching MSSQL 2000 SP3 server into domain,
Local Admin and SA cannot login into MSSQL
EM and QA are not working.
Even Local Admin cannot do it. But MSSQL is running, I have another
applications witch constantly using SQL Server (authentication by sql).
From previous thread.
Q.From Mike Epprecht
Q.Hi
Q.If SA can't login and you have not changed the password, it means that
SQL
Q.Server is not running. Check in control panel > services and also check
the
Q.NT event log to see what the failures are.
A.It is running, I have another applications witch constantly using SQL
Server.1. Are the services runnin under local system account
2. Was this SP3 all along or did you patch it right before move
3. What Server/DBRoles is the login used by the application that can connect
part of
4. Was this server part of a different domain or standalone before move
5. What aduit level do you have set
6. What is showing up in errorlog
"Djangar S." <snapplefor@.hotmail.com> wrote in message
news:%23GkT2AuvFHA.3932@.TK2MSFTNGP15.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.
> Even Local Admin cannot do it. But MSSQL is running, I have another
> applications witch constantly using SQL Server (authentication by sql).
>
> From previous thread.
> Q.From Mike Epprecht
> Q.Hi
> Q.If SA can't login and you have not changed the password, it means that
> SQL
> Q.Server is not running. Check in control panel > services and also check
> the
> Q.NT event log to see what the failures are.
>
> A.It is running, I have another applications witch constantly using SQL
> Server.
>|||Thank you David for your response.
1. Are the services runnin under local system account.
Yes. It is.
2. Was this SP3 all along or did you patch it right before move
Before move.
3.What Server/DBRoles is the login used by the application that can connect
part of.
Not able say exactly because it EM not working , but as far as I know
login's has different roles for one specific DB.
4.Was this server part of a different domain or standalone before move
Standalone.
5.What aduit level do you have set
Nothing.
6. What is showing up in errorlog
Nothing specific.
QA is showing :
Unable to connect to server XXX:
Msg 18456,Level 16,State 1
"David J. Cartwright" <davidcartwright@.hotmail.com> wrote in message
news:exIRpLuvFHA.3740@.TK2MSFTNGP14.phx.gbl...
> 1. Are the services runnin under local system account
> 2. Was this SP3 all along or did you patch it right before move
> 3. What Server/DBRoles is the login used by the application that can
> connect part of
> 4. Was this server part of a different domain or standalone before move
> 5. What aduit level do you have set
> 6. What is showing up in errorlog
>
> "Djangar S." <snapplefor@.hotmail.com> wrote in message
> news:%23GkT2AuvFHA.3932@.TK2MSFTNGP15.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.
>> Even Local Admin cannot do it. But MSSQL is running, I have another
>> applications witch constantly using SQL Server (authentication by sql).
>>
>> From previous thread.
>> Q.From Mike Epprecht
>> Q.Hi
>> Q.If SA can't login and you have not changed the password, it means that
>> SQL
>> Q.Server is not running. Check in control panel > services and also check
>> the
>> Q.NT event log to see what the failures are.
>>
>> A.It is running, I have another applications witch constantly using SQL
>> Server.
>>
>|||what does the sql server log have in it, also you can try to start sqlserver
from the command line while logged in as the (local) administrator account
for the computer...then try to connect with osql -E or Query analyzer...
"Djangar S." <snapplefor@.hotmail.com> wrote in message
news:eSqBy4uvFHA.2292@.TK2MSFTNGP12.phx.gbl...
> Thank you David for your response.
> 1. Are the services runnin under local system account.
> Yes. It is.
> 2. Was this SP3 all along or did you patch it right before move
> Before move.
> 3.What Server/DBRoles is the login used by the application that can
> connect part of.
> Not able say exactly because it EM not working , but as far as I
> know login's has different roles for one specific DB.
> 4.Was this server part of a different domain or standalone before move
> Standalone.
> 5.What aduit level do you have set
> Nothing.
>
> 6. What is showing up in errorlog
> Nothing specific.
> QA is showing :
> Unable to connect to server XXX:
> Msg 18456,Level 16,State 1
>
>
>
>
> "David J. Cartwright" <davidcartwright@.hotmail.com> wrote in message
> news:exIRpLuvFHA.3740@.TK2MSFTNGP14.phx.gbl...
>> 1. Are the services runnin under local system account
>> 2. Was this SP3 all along or did you patch it right before move
>> 3. What Server/DBRoles is the login used by the application that can
>> connect part of
>> 4. Was this server part of a different domain or standalone before move
>> 5. What aduit level do you have set
>> 6. What is showing up in errorlog
>>
>> "Djangar S." <snapplefor@.hotmail.com> wrote in message
>> news:%23GkT2AuvFHA.3932@.TK2MSFTNGP15.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.
>> Even Local Admin cannot do it. But MSSQL is running, I have another
>> applications witch constantly using SQL Server (authentication by sql).
>>
>> From previous thread.
>> Q.From Mike Epprecht
>> Q.Hi
>> Q.If SA can't login and you have not changed the password, it means that
>> SQL
>> Q.Server is not running. Check in control panel > services and also
>> check the
>> Q.NT event log to see what the failures are.
>>
>> A.It is running, I have another applications witch constantly using SQL
>> Server.
>>
>>
>|||Djangar S. wrote:
> Explanation:
> After attaching MSSQL 2000 SP3 server into domain,
> Local Admin and SA cannot login into MSSQL
> EM and QA are not working.
> Even Local Admin cannot do it. But MSSQL is running, I have another
> applications witch constantly using SQL Server (authentication by sql).
>
> From previous thread.
> Q.From Mike Epprecht
> Q.Hi
> Q.If SA can't login and you have not changed the password, it means that
> SQL
> Q.Server is not running. Check in control panel > services and also check
> the
> Q.NT event log to see what the failures are.
>
> A.It is running, I have another applications witch constantly using SQL
> Server.
>
When you have another application that can use the SQL server, have you
then tried to connect to the instance from EM using the account this
application is using? You could also check which account you have
registered in EM for connecting to the instance. Have you tried to to
create a new SQL server registration in EM using Windows Authentication
(while logged on to the server with an account that is local
administrator on the server.
Regards
Steen|||Hello, Steen
>When you have another application that can use the SQL server, have you
>then tried to connect to the instance from EM using the account this
>application is using?
Unfortunatly this user information is not avalible for me. This
application is the closed box.
>Have you tried to to create a new SQL server registration in EM using
>Windows Authentication (while logged on to the server with an account that
>is local administrator on the server.
Yes, I did but same result.
"Steen Persson (DK)" <spe@.REMOVEdatea.dk> wrote in message
news:ec7j6P2vFHA.664@.tk2msftngp13.phx.gbl...
> Djangar S. wrote:
>> Explanation:
>> After attaching MSSQL 2000 SP3 server into domain,
>> Local Admin and SA cannot login into MSSQL
>> EM and QA are not working.
>> Even Local Admin cannot do it. But MSSQL is running, I have another
>> applications witch constantly using SQL Server (authentication by sql).
>>
>> From previous thread.
>> Q.From Mike Epprecht
>> Q.Hi
>> Q.If SA can't login and you have not changed the password, it means that
>> SQL
>> Q.Server is not running. Check in control panel > services and also
>> check the
>> Q.NT event log to see what the failures are.
>>
>> A.It is running, I have another applications witch constantly using SQL
>> Server.
>>
> When you have another application that can use the SQL server, have you
> then tried to connect to the instance from EM using the account this
> application is using? You could also check which account you have
> registered in EM for connecting to the instance. Have you tried to to
> create a new SQL server registration in EM using Windows Authentication
> (while logged on to the server with an account that is local administrator
> on the server.
> Regards
> Steen

MSDTC Question - Need Help

Hello All:
Not familiar with SQL but our DB Admin is stuck so I need some help. Our
Webserver is sitting in DMZ and needs communication to SQL on LAN.
Specifically, DTC. What was explained to me is that through a web page,
several tables are updated and DTC supposedly will roll back the process if
something should fail prior to the process completing.
The page hangs. Without the code in the page requiring the transaction, it
goes. I also pulled the server out of the DMZ and back onto the LAN and it
worked. So, this logically points to the Firewall. Looking through the FW
logs, I see RPC packet being dropped. So, I follow Microsoft's fix for
specifying a fixed range of ports for RPC instead if letting it assigning
ports dynamically. I opened those ports from DMZ to LAN and still nothing.
The packets are no longer being dropped but the page will still not display.
I'm stumped.
I woul greatly appreciate any suggestions or help on this one.
Hello,
Based on my experience, this problem is mostly like a network configuration
issue. You can use dtcping.exe tool mentioned in the KB306843 to perform
further research on this problem. In the meantime, please check the
suggestions in the following articles to see if they meet your requirements.
250367 INFO: Configuring Microsoft Distributed Transaction Coordinator
(DTC) to
http://support.microsoft.com/?id=250367
306843 HOWTO: Troubleshoot MS DTC Firewall Issues
http://support.microsoft.com/?id=306843
Also, due to the feature of this issue, it usually is very hard to
troubleshoot in newsgroup. It would be best to contact Microsoft Product
Support Services via telephone so that a dedicated Support Professional can
assist with your request. To obtain the phone numbers for specific
technology request please take a look at the web site listed below.
http://support.microsoft.com/default...S;PHONENUMBERS
Regards,
Michael Shao
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.

MSDTC Question - Need Help

Hello All:
Not familiar with SQL but our DB Admin is stuck so I need some help. Our
Webserver is sitting in DMZ and needs communication to SQL on LAN.
Specifically, DTC. What was explained to me is that through a web page,
several tables are updated and DTC supposedly will roll back the process if
something should fail prior to the process completing.
The page hangs. Without the code in the page requiring the transaction, it
goes. I also pulled the server out of the DMZ and back onto the LAN and it
worked. So, this logically points to the Firewall. Looking through the FW
logs, I see RPC packet being dropped. So, I follow Microsoft's fix for
specifying a fixed range of ports for RPC instead if letting it assigning
ports dynamically. I opened those ports from DMZ to LAN and still nothing.
The packets are no longer being dropped but the page will still not display.
I'm stumped.
I woul greatly appreciate any suggestions or help on this one.Hello,
Based on my experience, this problem is mostly like a network configuration
issue. You can use dtcping.exe tool mentioned in the KB306843 to perform
further research on this problem. In the meantime, please check the
suggestions in the following articles to see if they meet your requirements.
250367 INFO: Configuring Microsoft Distributed Transaction Coordinator
(DTC) to
http://support.microsoft.com/?id=250367
306843 HOWTO: Troubleshoot MS DTC Firewall Issues
http://support.microsoft.com/?id=306843
Also, due to the feature of this issue, it usually is very hard to
troubleshoot in newsgroup. It would be best to contact Microsoft Product
Support Services via telephone so that a dedicated Support Professional can
assist with your request. To obtain the phone numbers for specific
technology request please take a look at the web site listed below.
http://support.microsoft.com/default.aspx?scid=fh;EN-US;PHONENUMBERS
Regards,
Michael Shao
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.

MSDTC Question - Need Help

Hello All:
Not familiar with SQL but our DB Admin is stuck so I need some help. Our
Webserver is sitting in DMZ and needs communication to SQL on LAN.
Specifically, DTC. What was explained to me is that through a web page,
several tables are updated and DTC supposedly will roll back the process if
something should fail prior to the process completing.
The page hangs. Without the code in the page requiring the transaction, it
goes. I also pulled the server out of the DMZ and back onto the LAN and it
worked. So, this logically points to the Firewall. Looking through the FW
logs, I see RPC packet being dropped. So, I follow Microsoft's fix for
specifying a fixed range of ports for RPC instead if letting it assigning
ports dynamically. I opened those ports from DMZ to LAN and still nothing.
The packets are no longer being dropped but the page will still not display.
I'm stumped.
I woul greatly appreciate any suggestions or help on this one.Hello,
Based on my experience, this problem is mostly like a network configuration
issue. You can use dtcping.exe tool mentioned in the KB306843 to perform
further research on this problem. In the meantime, please check the
suggestions in the following articles to see if they meet your requirements.
250367 INFO: Configuring Microsoft Distributed Transaction Coordinator
(DTC) to
http://support.microsoft.com/?id=250367
306843 HOWTO: Troubleshoot MS DTC Firewall Issues
http://support.microsoft.com/?id=306843
Also, due to the feature of this issue, it usually is very hard to
troubleshoot in newsgroup. It would be best to contact Microsoft Product
Support Services via telephone so that a dedicated Support Professional can
assist with your request. To obtain the phone numbers for specific
technology request please take a look at the web site listed below.
http://support.microsoft.com/defaul...US;PHONENUMBERS
Regards,
Michael Shao
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.

MSDTC and vulnerabilties

I was asked a by my SQL admin if there are any vulnerablities for SQL Server
caused by the use of MSDTC? If so are there any patches I need to be aware of
and install?Well, today's Microsoft Security Newsletter list this
MS06-018: Vulnerability in Microsoft Distributed Transaction Coordinator
Could Allow Denial of Service (913580)
http://www.microsoft.com/technet/security/Bulletin/MS06-018.mspx
Ben Nevarez, MCDBA, OCP
Database Administrator
"chris" wrote:
> I was asked a by my SQL admin if there are any vulnerablities for SQL Server
> caused by the use of MSDTC? If so are there any patches I need to be aware of
> and install?

MSDTC and vulnerabilties

I was asked a by my SQL admin if there are any vulnerablities for SQL Server
caused by the use of MSDTC? If so are there any patches I need to be aware o
f
and install?Well, today's Microsoft Security Newsletter list this
MS06-018: Vulnerability in Microsoft Distributed Transaction Coordinator
Could Allow Denial of Service (913580)
http://www.microsoft.com/technet/se...n/MS06-018.mspx
Ben Nevarez, MCDBA, OCP
Database Administrator
"chris" wrote:

> I was asked a by my SQL admin if there are any vulnerablities for SQL Serv
er
> caused by the use of MSDTC? If so are there any patches I need to be aware
of
> and install?