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

MSRS Java Client

We tried to develop a MSRS Java Client to communicate with the MSRS server
via web services. Because of integrated windows authentication, we
encountered an access denial error. Has anyone encountered this problem and
know how to embed windows security in the Java client. By the way, I used
Apache Axis to create client stub classes from a WSDL file. I obtained the
WSDL file from the MSRS server directly.
Thanks,
JamesJames, I am trying to do exactly what you are describing and have run into
the same problem. Did you ever discover a solution?
Thanks!
"James" wrote:
> We tried to develop a MSRS Java Client to communicate with the MSRS server
> via web services. Because of integrated windows authentication, we
> encountered an access denial error. Has anyone encountered this problem and
> know how to embed windows security in the Java client. By the way, I used
> Apache Axis to create client stub classes from a WSDL file. I obtained the
> WSDL file from the MSRS server directly.
> Thanks,
> James|||Josh, James, I'm having this problem as well. Was there a solution?
"Josh Hensley" wrote:
> James, I am trying to do exactly what you are describing and have run into
> the same problem. Did you ever discover a solution?
> Thanks!
> "James" wrote:
> > We tried to develop a MSRS Java Client to communicate with the MSRS server
> > via web services. Because of integrated windows authentication, we
> > encountered an access denial error. Has anyone encountered this problem and
> > know how to embed windows security in the Java client. By the way, I used
> > Apache Axis to create client stub classes from a WSDL file. I obtained the
> > WSDL file from the MSRS server directly.
> >
> > Thanks,
> >
> > James|||Hey LT,
I did find a solution, but forgot to come back and mention it here.
The problem comes from the fact that we need to call the Render method
without specifying some optional parameters (like historyID). When you call
a Web Service API method from Java and leave out an optional parameter, the
SOAP message that is generated by AXIS can either exclude the tag for that
missing parameter or include the tag with a special attribute saying it's not
being used (xsi:nil="true"). The default for behavior for AXIS is to send
the tag with the special attribute but apparently Microsoft Reporting
Services doesn't want the tag sent at all. So you have to modify AXIS to
satisfy Reporting Services and stop sending tags for arguments that aren't
specified.
A much more detailed explanation is in this article written by a fella from
France. (You will have to register on their site to read the article)
http://www.sqlreportingservices.net/Tools/1996.aspx
Good luck!
"LT" wrote:
> Josh, James, I'm having this problem as well. Was there a solution?
> "Josh Hensley" wrote:
> > James, I am trying to do exactly what you are describing and have run into
> > the same problem. Did you ever discover a solution?
> >
> > Thanks!
> >
> > "James" wrote:
> >
> > > We tried to develop a MSRS Java Client to communicate with the MSRS server
> > > via web services. Because of integrated windows authentication, we
> > > encountered an access denial error. Has anyone encountered this problem and
> > > know how to embed windows security in the Java client. By the way, I used
> > > Apache Axis to create client stub classes from a WSDL file. I obtained the
> > > WSDL file from the MSRS server directly.
> > >
> > > Thanks,
> > >
> > > Jamessql