MSDTC and Win2K3: domain

Showing posts with label domain. Show all posts

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

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

Wednesday, March 28, 2012

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

Mssql

create table ename (cid bigint,cname varchar(20),yoe bigint,domain varchar(20),special varchar(20),location varchar(20),age bigint,rsta varchar(20),percentage bigint,record varchar(20))

select cid,cname,yoe,domain,special from ename where (cid=23 and cname='Tamil' and yoe=2 and domain ='it' and special='computer' and location='chennai' and record='dotnet') or (age='' and rsta='' and percentage='')

Quote:

Originally Posted by thamilarasangc

create table ename (cid bigint,cname varchar(20),yoe bigint,domain varchar(20),special varchar(20),location varchar(20),age bigint,rsta varchar(20),percentage bigint,record varchar(20))

select cid,cname,yoe,domain,special from ename where ((cid=23 and cname='Tamil' and yoe=2 and domain ='it' and special='computer' and location='chennai' and record='dotnet') or (age='' or rsta='' or percentage=''))

Friday, March 23, 2012

MSOLAP Connection error

Hi,
I have RS with sp1 in one server and MS Analysis server with sp3 in another.
Both inside of Domain and the user is the administrator. Also I have the
correct roles in the AS.
I got this error:
An error has occurred during report processing.
Cannot create a connection to data source 'Sales_MDX_Colinas23'. Database
'Sales' does not exist.
In the dev. env works fine and also if AS is in the same server as RS.
The problem is when AS and RS are in different server.
Does some one knows whats wrong?
Thanks in advanceDid you get a solution for this. I have the same problem?
"Carlos Lara" wrote:
> Hi,
> I have RS with sp1 in one server and MS Analysis server with sp3 in another.
> Both inside of Domain and the user is the administrator. Also I have the
> correct roles in the AS.
> I got this error:
> An error has occurred during report processing.
> Cannot create a connection to data source 'Sales_MDX_Colinas23'. Database
> 'Sales' does not exist.
> In the dev. env works fine and also if AS is in the same server as RS.
> The problem is when AS and RS are in different server.
> Does some one knows whats wrong?
> Thanks in advance
>|||Yes, I am also having the same problem and noticed that Jane has also posted
the same problem under "Database connection problem".
Can some please help.
Cheers.
"Ramdas" wrote:
> Did you get a solution for this. I have the same problem?
> "Carlos Lara" wrote:
> > Hi,
> > I have RS with sp1 in one server and MS Analysis server with sp3 in another.
> > Both inside of Domain and the user is the administrator. Also I have the
> > correct roles in the AS.
> >
> > I got this error:
> > An error has occurred during report processing.
> > Cannot create a connection to data source 'Sales_MDX_Colinas23'. Database
> > 'Sales' does not exist.
> >
> > In the dev. env works fine and also if AS is in the same server as RS.
> >
> > The problem is when AS and RS are in different server.
> >
> > Does some one knows whats wrong?
> >
> > Thanks in advance
> >
> >|||Same problem here as well. Any luck?
Cheers,
"Kelvin" wrote:
> Yes, I am also having the same problem and noticed that Jane has also posted
> the same problem under "Database connection problem".
> Can some please help.
> Cheers.
> "Ramdas" wrote:
> > Did you get a solution for this. I have the same problem?
> >
> > "Carlos Lara" wrote:
> >
> > > Hi,
> > > I have RS with sp1 in one server and MS Analysis server with sp3 in another.
> > > Both inside of Domain and the user is the administrator. Also I have the
> > > correct roles in the AS.
> > >
> > > I got this error:
> > > An error has occurred during report processing.
> > > Cannot create a connection to data source 'Sales_MDX_Colinas23'. Database
> > > 'Sales' does not exist.
> > >
> > > In the dev. env works fine and also if AS is in the same server as RS.
> > >
> > > The problem is when AS and RS are in different server.
> > >
> > > Does some one knows whats wrong?
> > >
> > > Thanks in advance
> > >
> > >sql

Saturday, February 25, 2012

MSDTC Fails

SQL Server 2000 servers are running on two different servers on Windows 2003.
One is part of domain but the other one is not part of any domain.
MSDTC failed to communicate with error msg 7391.
Followed the instruction as mentioned in KB-329332, but still failed.
Followed the instruction as mentioned in KB-827805 but failed too. In
KB-827805, it only tells to add the registry with value name
"TurnOffRpcSecurity". Is it the only thing to do ?
OR both server must be run under the same domain.
Can any SQL Server MVP or Microsoft technical support persons help ?
"Johnny" wrote:

> SQL Server 2000 servers are running on two different servers on Windows 2003.
> One is part of domain but the other one is not part of any domain.
> MSDTC failed to communicate with error msg 7391.
> Followed the instruction as mentioned in KB-329332, but still failed.
> Followed the instruction as mentioned in KB-827805 but failed too. In
> KB-827805, it only tells to add the registry with value name
> "TurnOffRpcSecurity". Is it the only thing to do ?
> OR both server must be run under the same domain.
>
|||Have you enabled Network COM+ and DTC access under application server on the
add\remove windows components portion of add\remove programs?
nivek
"Johnny" <Johnny@.discussions.microsoft.com> wrote in message
news:80C3DF07-4C7C-4A1E-B2B4-8D091C09B73B@.microsoft.com...
> SQL Server 2000 servers are running on two different servers on Windows
> 2003.
> One is part of domain but the other one is not part of any domain.
> MSDTC failed to communicate with error msg 7391.
> Followed the instruction as mentioned in KB-329332, but still failed.
> Followed the instruction as mentioned in KB-827805 but failed too. In
> KB-827805, it only tells to add the registry with value name
> "TurnOffRpcSecurity". Is it the only thing to do ?
> OR both server must be run under the same domain.
>
|||I also went through the KB-816701. The components Network COM+ and Network
DTC access are already enable by default.
When I put the two servers to the same domain, MSDTC works beautifully. But
why Windows 2003 has this restriction.
"nivek" wrote:

> Have you enabled Network COM+ and DTC access under application server on the
> add\remove windows components portion of add\remove programs?
> --
> nivek
>
>
> "Johnny" <Johnny@.discussions.microsoft.com> wrote in message
> news:80C3DF07-4C7C-4A1E-B2B4-8D091C09B73B@.microsoft.com...
>
>

MSDTC Fails

SQL Server 2000 servers are running on two different servers on Windows 2003.
One is part of domain but the other one is not part of any domain.
MSDTC failed to communicate with error msg 7391.
Followed the instruction as mentioned in KB-329332, but still failed.
Followed the instruction as mentioned in KB-827805 but failed too. In
KB-827805, it only tells to add the registry with value name
"TurnOffRpcSecurity". Is it the only thing to do ?
OR both server must be run under the same domain.Can any SQL Server MVP or Microsoft technical support persons help ?
"Johnny" wrote:
> SQL Server 2000 servers are running on two different servers on Windows 2003.
> One is part of domain but the other one is not part of any domain.
> MSDTC failed to communicate with error msg 7391.
> Followed the instruction as mentioned in KB-329332, but still failed.
> Followed the instruction as mentioned in KB-827805 but failed too. In
> KB-827805, it only tells to add the registry with value name
> "TurnOffRpcSecurity". Is it the only thing to do ?
> OR both server must be run under the same domain.
>|||Have you enabled Network COM+ and DTC access under application server on the
add\remove windows components portion of add\remove programs?
--
nivek
"Johnny" <Johnny@.discussions.microsoft.com> wrote in message
news:80C3DF07-4C7C-4A1E-B2B4-8D091C09B73B@.microsoft.com...
> SQL Server 2000 servers are running on two different servers on Windows
> 2003.
> One is part of domain but the other one is not part of any domain.
> MSDTC failed to communicate with error msg 7391.
> Followed the instruction as mentioned in KB-329332, but still failed.
> Followed the instruction as mentioned in KB-827805 but failed too. In
> KB-827805, it only tells to add the registry with value name
> "TurnOffRpcSecurity". Is it the only thing to do ?
> OR both server must be run under the same domain.
>|||I also went through the KB-816701. The components Network COM+ and Network
DTC access are already enable by default.
When I put the two servers to the same domain, MSDTC works beautifully. But
why Windows 2003 has this restriction.
"nivek" wrote:
> Have you enabled Network COM+ and DTC access under application server on the
> add\remove windows components portion of add\remove programs?
> --
> nivek
>
>
> "Johnny" <Johnny@.discussions.microsoft.com> wrote in message
> news:80C3DF07-4C7C-4A1E-B2B4-8D091C09B73B@.microsoft.com...
> > SQL Server 2000 servers are running on two different servers on Windows
> > 2003.
> > One is part of domain but the other one is not part of any domain.
> > MSDTC failed to communicate with error msg 7391.
> >
> > Followed the instruction as mentioned in KB-329332, but still failed.
> > Followed the instruction as mentioned in KB-827805 but failed too. In
> > KB-827805, it only tells to add the registry with value name
> > "TurnOffRpcSecurity". Is it the only thing to do ?
> >
> > OR both server must be run under the same domain.
> >
>
>

MSDTC Fails

SQL Server 2000 servers are running on two different servers on Windows 2003
.
One is part of domain but the other one is not part of any domain.
MSDTC failed to communicate with error msg 7391.
Followed the instruction as mentioned in KB-329332, but still failed.
Followed the instruction as mentioned in KB-827805 but failed too. In
KB-827805, it only tells to add the registry with value name
"TurnOffRpcSecurity". Is it the only thing to do ?
OR both server must be run under the same domain.Can any SQL Server MVP or Microsoft technical support persons help ?
"Johnny" wrote:

> SQL Server 2000 servers are running on two different servers on Windows 20
03.
> One is part of domain but the other one is not part of any domain.
> MSDTC failed to communicate with error msg 7391.
> Followed the instruction as mentioned in KB-329332, but still failed.
> Followed the instruction as mentioned in KB-827805 but failed too. In
> KB-827805, it only tells to add the registry with value name
> "TurnOffRpcSecurity". Is it the only thing to do ?
> OR both server must be run under the same domain.
>|||Have you enabled Network COM+ and DTC access under application server on the
add\remove windows components portion of add\remove programs?
nivek
"Johnny" <Johnny@.discussions.microsoft.com> wrote in message
news:80C3DF07-4C7C-4A1E-B2B4-8D091C09B73B@.microsoft.com...
> SQL Server 2000 servers are running on two different servers on Windows
> 2003.
> One is part of domain but the other one is not part of any domain.
> MSDTC failed to communicate with error msg 7391.
> Followed the instruction as mentioned in KB-329332, but still failed.
> Followed the instruction as mentioned in KB-827805 but failed too. In
> KB-827805, it only tells to add the registry with value name
> "TurnOffRpcSecurity". Is it the only thing to do ?
> OR both server must be run under the same domain.
>|||I also went through the KB-816701. The components Network COM+ and Network
DTC access are already enable by default.
When I put the two servers to the same domain, MSDTC works beautifully. But
why Windows 2003 has this restriction.
"nivek" wrote:

> Have you enabled Network COM+ and DTC access under application server on t
he
> add\remove windows components portion of add\remove programs?
> --
> nivek
>
>
> "Johnny" <Johnny@.discussions.microsoft.com> wrote in message
> news:80C3DF07-4C7C-4A1E-B2B4-8D091C09B73B@.microsoft.com...
>
>

Friday, March 30, 2012

MSSQL 2000 connection problem, please help

MSSQL 2000 connection problem, please help

MSSQL 2000 connection problem, please help

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

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

Wednesday, March 28, 2012

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

Mssql

Friday, March 23, 2012

MSOLAP Connection error

Saturday, February 25, 2012

MSDTC Fails

MSDTC Fails

MSDTC Fails

MSDTC and Win2K3

Blog Archive

About Me