Wednesday, March 28, 2012
Profile Trace: how to tell which database when filtering on user
DB#2 have stored procedures identically named (.e.g. "uspGetOrders") with
the same signature. Is it possible when running a trace that filters on
user like JOE, to determine which database the procedure belongs to which
JOE happens to be executing? How can I tell which it is? When I double
click on the trace line to view the details, the sp name is displayed
without a db or owner prefix. And if I filter on database name, I see this:
exec uspGetOrders @.p1 no matter which database I happen to choose. The
trace doesn't seem to tell me where the procedure "originates" so to speak.
I'm trying to figure out why the procedure is returning no data when it is
moved to DB#2 and points back to tables in DB1. The procedure worked fine
when it was in DB#1. The stored procedure refers to the table as
DB1.dbo.Orders and JOE has been granted execute privileges (via a role) on
DB2.dbo.uspGetOrders. JOE had no problem working with the procedure when
it was in the same database as the table. JOE belongs to a role that has
select privileges on Orders.
The only other thing that has changed is the Initial Catalog when JOE
connects. Now it is DB2.
Thanks!
TimoIf a user is in DB#1 and what you see executed is
uspGetOrders, it's executing the stored procedure in DB#1.
It would have to be qualified by the database name to
execute the stored procedure in DB#2.
If you are on SQL Server 2000 and if you are on SP3, then
the issue with the stored procedure could be due to not
having cross database ownership chaining enabled. If you are
running under this configuration and have updated your books
online, you can find more information in books online under
the topic:
Cross DB Ownership Chaining
-Sue
On Mon, 12 Apr 2004 12:25:28 -0400, "Timo"
<timo@.anonymous.com> wrote:
>Let's say there are two databases, DB#1 and DB#2, and a user JOE. DB#1 and
>DB#2 have stored procedures identically named (.e.g. "uspGetOrders") with
>the same signature. Is it possible when running a trace that filters on
>user like JOE, to determine which database the procedure belongs to which
>JOE happens to be executing? How can I tell which it is? When I double
>click on the trace line to view the details, the sp name is displayed
>without a db or owner prefix. And if I filter on database name, I see this
:
>exec uspGetOrders @.p1 no matter which database I happen to choose. The
>trace doesn't seem to tell me where the procedure "originates" so to speak.
>I'm trying to figure out why the procedure is returning no data when it is
>moved to DB#2 and points back to tables in DB1. The procedure worked fine
>when it was in DB#1. The stored procedure refers to the table as
>DB1.dbo.Orders and JOE has been granted execute privileges (via a role) on
>DB2.dbo.uspGetOrders. JOE had no problem working with the procedure when
>it was in the same database as the table. JOE belongs to a role that has
>select privileges on Orders.
>The only other thing that has changed is the Initial Catalog when JOE
>connects. Now it is DB2.
>Thanks!
>Timo
>
>
>|||Sue,
Thanks for the reply. It doesn't appear to be Cross DB Ownership chaining;
same issue after this:
EXEC sp_configure 'Cross DB Ownership Chaining', '0'; RECONFIGURE
EXEC sp_dboption 'DB1', 'db chaining', 'ON'
EXEC sp_dboption 'DB2', 'db chaining', 'ON'
Trace shows the procedure being invoked; the IN parameter is there, but all
the OUT parameters are null. When I've encountered similar symptoms in Trace
before, it was because the user lacked execute privileges on the procedure.
But JOE has these privileges by virtue of membership in a db role.
Any other way to troubleshoot this scenario using Trace?
Thanks again.
Timo
"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
news:vcil70hj0j37239l9ds5tevbtfotc6n506@.
4ax.com...
> If a user is in DB#1 and what you see executed is
> uspGetOrders, it's executing the stored procedure in DB#1.
> It would have to be qualified by the database name to
> execute the stored procedure in DB#2.
> If you are on SQL Server 2000 and if you are on SP3, then
> the issue with the stored procedure could be due to not
> having cross database ownership chaining enabled. If you are
> running under this configuration and have updated your books
> online, you can find more information in books online under
> the topic:
> Cross DB Ownership Chaining
> -Sue
> On Mon, 12 Apr 2004 12:25:28 -0400, "Timo"
> <timo@.anonymous.com> wrote:
>
and
which
this:
speak.
is
on
when
>|||In Profiler, you'd want to select exceptions from the Errors
and Warnings event class. That will give you any errors
being raised. You should also make sure you are capturing
the completion of the stored procedure, not just the
starting event.
Did you check the owners of the objects (the stored
procedure and the underlying tables) and databases involved?
The databases need to be owned by the same login. The
objects need to have the same object owner.
-Sue
On Mon, 12 Apr 2004 13:40:39 -0400, "Timo"
<timo@.anonymous.com> wrote:
>Sue,
>Thanks for the reply. It doesn't appear to be Cross DB Ownership chaining;
>same issue after this:
>EXEC sp_configure 'Cross DB Ownership Chaining', '0'; RECONFIGURE
>EXEC sp_dboption 'DB1', 'db chaining', 'ON'
>EXEC sp_dboption 'DB2', 'db chaining', 'ON'
>Trace shows the procedure being invoked; the IN parameter is there, but all
>the OUT parameters are null. When I've encountered similar symptoms in Trac
e
>before, it was because the user lacked execute privileges on the procedure.
>But JOE has these privileges by virtue of membership in a db role.
>Any other way to troubleshoot this scenario using Trace?
>Thanks again.
>Timo
>
>"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
> news:vcil70hj0j37239l9ds5tevbtfotc6n506@.
4ax.com...
>and
>which
>this:
>speak.
>is
>on
>when
>|||To add to Sue's response, if your objects are owned by 'dbo', the database
owners need to be the same in order to maintain an unbroken ownership chain
for dbo-owned objects. If needed, you can use sp_changedbowner to ensure
the databases are owned by the same login:
USE DB1
EXEC sp_changedbowner 'MyOwnerLogin'
USE DB2
EXEC sp_changedbowner 'MyOwnerLogin'
Users will need access to both databases but permissions on indirectly
referenced objects are not needed.
Hope this helps.
Dan Guzman
SQL Server MVP
"Timo" <timo@.anonymous.com> wrote in message
news:%23t2AiVLIEHA.580@.TK2MSFTNGP12.phx.gbl...
> Sue,
> Thanks for the reply. It doesn't appear to be Cross DB Ownership
chaining;
> same issue after this:
> EXEC sp_configure 'Cross DB Ownership Chaining', '0'; RECONFIGURE
> EXEC sp_dboption 'DB1', 'db chaining', 'ON'
> EXEC sp_dboption 'DB2', 'db chaining', 'ON'
> Trace shows the procedure being invoked; the IN parameter is there, but
all
> the OUT parameters are null. When I've encountered similar symptoms in
Trace
> before, it was because the user lacked execute privileges on the
procedure.
> But JOE has these privileges by virtue of membership in a db role.
> Any other way to troubleshoot this scenario using Trace?
> Thanks again.
> Timo
>
> "Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
> news:vcil70hj0j37239l9ds5tevbtfotc6n506@.
4ax.com...
> and
with
on
> which
> this:
The
> speak.
> is
fine
> on
> when
has
>|||Thank you Dan for the dbchangeowner tip, and Sue for the Errors and Warnings
event class tip. I will use them to advantage. In Trace, I was not seeing
the completion of the sp, only the starting event, and so was unable to
determine what database the client was pointing at. After having the
developer re-check the connection string in the client-side code, we found
that the wrong database was being specified as the initial catalog.
Timo
"Dan Guzman" <danguzman@.nospam-earthlink.net> wrote in message
news:ukvyQdVIEHA.2972@.TK2MSFTNGP12.phx.gbl...
> To add to Sue's response, if your objects are owned by 'dbo', the database
> owners need to be the same in order to maintain an unbroken ownership
chain
> for dbo-owned objects. If needed, you can use sp_changedbowner to ensure
> the databases are owned by the same login:
> USE DB1
> EXEC sp_changedbowner 'MyOwnerLogin'
> USE DB2
> EXEC sp_changedbowner 'MyOwnerLogin'
> Users will need access to both databases but permissions on indirectly
> referenced objects are not needed.
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "Timo" <timo@.anonymous.com> wrote in message
> news:%23t2AiVLIEHA.580@.TK2MSFTNGP12.phx.gbl...
> chaining;
> all
> Trace
> procedure.
DB#1
> with
> on
double
see
> The
it
> fine
role)
> has
>
Monday, March 26, 2012
Product error installs
install SQL databases. However I get similar errors during both for the
install.
I'll end up w/ an Error 11001 in the app event log and the contents of the
error common to both is: Error 1001.Setup failed. --> Windows NT user or
group 'NT AUTHORITY\domain users' not found. Check the name again.
Windows NT user or group 'NT AUTHORITY\domain users' not found. Check the
name again.
User or role 'NT AUTHORITY\domain users' does not exist in this database.
User or role 'NT AUTHORITY\domain users' does not exist in this database.,
(NULL), (NULL), (NULL).
I've talked to a couple other users and they haven't experienced the same
issues. My server is set to mixed mode and the SA account does have a
password. I've tried installing using the SA account as well as a domain
admin account and neither worked.
Is the NT account you are using to install a member of the local server
Administrator group?
Brad Feaker
Ex nihilo, nihil fit
"Mike" wrote:
> I have a couple third part applications that I'm trying to install that
> install SQL databases. However I get similar errors during both for the
> install.
> I'll end up w/ an Error 11001 in the app event log and the contents of the
> error common to both is: Error 1001.Setup failed. --> Windows NT user or
> group 'NT AUTHORITY\domain users' not found. Check the name again.
> Windows NT user or group 'NT AUTHORITY\domain users' not found. Check the
> name again.
> User or role 'NT AUTHORITY\domain users' does not exist in this database.
> User or role 'NT AUTHORITY\domain users' does not exist in this database.,
> (NULL), (NULL), (NULL).
>
> I've talked to a couple other users and they haven't experienced the same
> issues. My server is set to mixed mode and the SA account does have a
> password. I've tried installing using the SA account as well as a domain
> admin account and neither worked.
|||Yes
"Brad Feaker" wrote:
[vbcol=seagreen]
> Is the NT account you are using to install a member of the local server
> Administrator group?
> Brad Feaker
> Ex nihilo, nihil fit
> "Mike" wrote:
|||Try installing using a local system account and then changing the service
accounts after the install is complete.
Brad
"Mike" wrote:
[vbcol=seagreen]
> Yes
> "Brad Feaker" wrote:
|||Tried using the Administrator account on the local machine. Same problem.
"Brad Feaker" wrote:
[vbcol=seagreen]
> Try installing using a local system account and then changing the service
> accounts after the install is complete.
> Brad
> "Mike" wrote:
|||Instead of using a windows account at all, choose the 'Local System Account'
option during the install.
Brad
"Mike" wrote:
[vbcol=seagreen]
> Tried using the Administrator account on the local machine. Same problem.
> "Brad Feaker" wrote:
|||this is an interactive application that i'm trying to install so I'm not sure
there is a way to do what your asking. i'm assuming it comes to this error
some point where it's creating the db in sql. it's funny though the the db
and tables appear to be created fine.
"Brad Feaker" wrote:
[vbcol=seagreen]
> Instead of using a windows account at all, choose the 'Local System Account'
> option during the install.
> Brad
> "Mike" wrote:
|||At this point you may want to toss the problem back to the vendor....sorry I
could not be of any assistance...
Brad
"Mike" wrote:
[vbcol=seagreen]
> this is an interactive application that i'm trying to install so I'm not sure
> there is a way to do what your asking. i'm assuming it comes to this error
> some point where it's creating the db in sql. it's funny though the the db
> and tables appear to be created fine.
> "Brad Feaker" wrote:
|||Thanks. I did so Monday. I believe they're stumped.
"Brad Feaker" wrote:
[vbcol=seagreen]
> At this point you may want to toss the problem back to the vendor....sorry I
> could not be of any assistance...
> Brad
> "Mike" wrote:
Product error installs
install SQL databases. However I get similar errors during both for the
install.
I'll end up w/ an Error 11001 in the app event log and the contents of the
error common to both is: Error 1001.Setup failed. --> Windows NT user or
group 'NT AUTHORITY\domain users' not found. Check the name again.
Windows NT user or group 'NT AUTHORITY\domain users' not found. Check the
name again.
User or role 'NT AUTHORITY\domain users' does not exist in this database.
User or role 'NT AUTHORITY\domain users' does not exist in this database.,
(NULL), (NULL), (NULL).
I've talked to a couple other users and they haven't experienced the same
issues. My server is set to mixed mode and the SA account does have a
password. I've tried installing using the SA account as well as a domain
admin account and neither worked.Is the NT account you are using to install a member of the local server
Administrator group?
Brad Feaker
Ex nihilo, nihil fit
"Mike" wrote:
> I have a couple third part applications that I'm trying to install that
> install SQL databases. However I get similar errors during both for the
> install.
> I'll end up w/ an Error 11001 in the app event log and the contents of the
> error common to both is: Error 1001.Setup failed. --> Windows NT user or
> group 'NT AUTHORITY\domain users' not found. Check the name again.
> Windows NT user or group 'NT AUTHORITY\domain users' not found. Check the
> name again.
> User or role 'NT AUTHORITY\domain users' does not exist in this database.
> User or role 'NT AUTHORITY\domain users' does not exist in this database.,
> (NULL), (NULL), (NULL).
>
> I've talked to a couple other users and they haven't experienced the same
> issues. My server is set to mixed mode and the SA account does have a
> password. I've tried installing using the SA account as well as a domain
> admin account and neither worked.|||Yes
"Brad Feaker" wrote:
> Is the NT account you are using to install a member of the local server
> Administrator group?
> Brad Feaker
> Ex nihilo, nihil fit
> "Mike" wrote:
> > I have a couple third part applications that I'm trying to install that
> > install SQL databases. However I get similar errors during both for the
> > install.
> >
> > I'll end up w/ an Error 11001 in the app event log and the contents of the
> > error common to both is: Error 1001.Setup failed. --> Windows NT user or
> > group 'NT AUTHORITY\domain users' not found. Check the name again.
> > Windows NT user or group 'NT AUTHORITY\domain users' not found. Check the
> > name again.
> > User or role 'NT AUTHORITY\domain users' does not exist in this database.
> > User or role 'NT AUTHORITY\domain users' does not exist in this database.,
> > (NULL), (NULL), (NULL).
> >
> >
> > I've talked to a couple other users and they haven't experienced the same
> > issues. My server is set to mixed mode and the SA account does have a
> > password. I've tried installing using the SA account as well as a domain
> > admin account and neither worked.|||Try installing using a local system account and then changing the service
accounts after the install is complete.
Brad
"Mike" wrote:
> Yes
> "Brad Feaker" wrote:
> > Is the NT account you are using to install a member of the local server
> > Administrator group?
> >
> > Brad Feaker
> > Ex nihilo, nihil fit
> >
> > "Mike" wrote:
> >
> > > I have a couple third part applications that I'm trying to install that
> > > install SQL databases. However I get similar errors during both for the
> > > install.
> > >
> > > I'll end up w/ an Error 11001 in the app event log and the contents of the
> > > error common to both is: Error 1001.Setup failed. --> Windows NT user or
> > > group 'NT AUTHORITY\domain users' not found. Check the name again.
> > > Windows NT user or group 'NT AUTHORITY\domain users' not found. Check the
> > > name again.
> > > User or role 'NT AUTHORITY\domain users' does not exist in this database.
> > > User or role 'NT AUTHORITY\domain users' does not exist in this database.,
> > > (NULL), (NULL), (NULL).
> > >
> > >
> > > I've talked to a couple other users and they haven't experienced the same
> > > issues. My server is set to mixed mode and the SA account does have a
> > > password. I've tried installing using the SA account as well as a domain
> > > admin account and neither worked.|||Tried using the Administrator account on the local machine. Same problem.
"Brad Feaker" wrote:
> Try installing using a local system account and then changing the service
> accounts after the install is complete.
> Brad
> "Mike" wrote:
> > Yes
> >
> > "Brad Feaker" wrote:
> >
> > > Is the NT account you are using to install a member of the local server
> > > Administrator group?
> > >
> > > Brad Feaker
> > > Ex nihilo, nihil fit
> > >
> > > "Mike" wrote:
> > >
> > > > I have a couple third part applications that I'm trying to install that
> > > > install SQL databases. However I get similar errors during both for the
> > > > install.
> > > >
> > > > I'll end up w/ an Error 11001 in the app event log and the contents of the
> > > > error common to both is: Error 1001.Setup failed. --> Windows NT user or
> > > > group 'NT AUTHORITY\domain users' not found. Check the name again.
> > > > Windows NT user or group 'NT AUTHORITY\domain users' not found. Check the
> > > > name again.
> > > > User or role 'NT AUTHORITY\domain users' does not exist in this database.
> > > > User or role 'NT AUTHORITY\domain users' does not exist in this database.,
> > > > (NULL), (NULL), (NULL).
> > > >
> > > >
> > > > I've talked to a couple other users and they haven't experienced the same
> > > > issues. My server is set to mixed mode and the SA account does have a
> > > > password. I've tried installing using the SA account as well as a domain
> > > > admin account and neither worked.|||Instead of using a windows account at all, choose the 'Local System Account'
option during the install.
Brad
"Mike" wrote:
> Tried using the Administrator account on the local machine. Same problem.
> "Brad Feaker" wrote:
> > Try installing using a local system account and then changing the service
> > accounts after the install is complete.
> >
> > Brad
> >
> > "Mike" wrote:
> >
> > > Yes
> > >
> > > "Brad Feaker" wrote:
> > >
> > > > Is the NT account you are using to install a member of the local server
> > > > Administrator group?
> > > >
> > > > Brad Feaker
> > > > Ex nihilo, nihil fit
> > > >
> > > > "Mike" wrote:
> > > >
> > > > > I have a couple third part applications that I'm trying to install that
> > > > > install SQL databases. However I get similar errors during both for the
> > > > > install.
> > > > >
> > > > > I'll end up w/ an Error 11001 in the app event log and the contents of the
> > > > > error common to both is: Error 1001.Setup failed. --> Windows NT user or
> > > > > group 'NT AUTHORITY\domain users' not found. Check the name again.
> > > > > Windows NT user or group 'NT AUTHORITY\domain users' not found. Check the
> > > > > name again.
> > > > > User or role 'NT AUTHORITY\domain users' does not exist in this database.
> > > > > User or role 'NT AUTHORITY\domain users' does not exist in this database.,
> > > > > (NULL), (NULL), (NULL).
> > > > >
> > > > >
> > > > > I've talked to a couple other users and they haven't experienced the same
> > > > > issues. My server is set to mixed mode and the SA account does have a
> > > > > password. I've tried installing using the SA account as well as a domain
> > > > > admin account and neither worked.|||this is an interactive application that i'm trying to install so I'm not sure
there is a way to do what your asking. i'm assuming it comes to this error
some point where it's creating the db in sql. it's funny though the the db
and tables appear to be created fine.
"Brad Feaker" wrote:
> Instead of using a windows account at all, choose the 'Local System Account'
> option during the install.
> Brad
> "Mike" wrote:
> > Tried using the Administrator account on the local machine. Same problem.
> >
> > "Brad Feaker" wrote:
> >
> > > Try installing using a local system account and then changing the service
> > > accounts after the install is complete.
> > >
> > > Brad
> > >
> > > "Mike" wrote:
> > >
> > > > Yes
> > > >
> > > > "Brad Feaker" wrote:
> > > >
> > > > > Is the NT account you are using to install a member of the local server
> > > > > Administrator group?
> > > > >
> > > > > Brad Feaker
> > > > > Ex nihilo, nihil fit
> > > > >
> > > > > "Mike" wrote:
> > > > >
> > > > > > I have a couple third part applications that I'm trying to install that
> > > > > > install SQL databases. However I get similar errors during both for the
> > > > > > install.
> > > > > >
> > > > > > I'll end up w/ an Error 11001 in the app event log and the contents of the
> > > > > > error common to both is: Error 1001.Setup failed. --> Windows NT user or
> > > > > > group 'NT AUTHORITY\domain users' not found. Check the name again.
> > > > > > Windows NT user or group 'NT AUTHORITY\domain users' not found. Check the
> > > > > > name again.
> > > > > > User or role 'NT AUTHORITY\domain users' does not exist in this database.
> > > > > > User or role 'NT AUTHORITY\domain users' does not exist in this database.,
> > > > > > (NULL), (NULL), (NULL).
> > > > > >
> > > > > >
> > > > > > I've talked to a couple other users and they haven't experienced the same
> > > > > > issues. My server is set to mixed mode and the SA account does have a
> > > > > > password. I've tried installing using the SA account as well as a domain
> > > > > > admin account and neither worked.|||At this point you may want to toss the problem back to the vendor....sorry I
could not be of any assistance...
Brad
"Mike" wrote:
> this is an interactive application that i'm trying to install so I'm not sure
> there is a way to do what your asking. i'm assuming it comes to this error
> some point where it's creating the db in sql. it's funny though the the db
> and tables appear to be created fine.
> "Brad Feaker" wrote:
> > Instead of using a windows account at all, choose the 'Local System Account'
> > option during the install.
> >
> > Brad
> >
> > "Mike" wrote:
> >
> > > Tried using the Administrator account on the local machine. Same problem.
> > >
> > > "Brad Feaker" wrote:
> > >
> > > > Try installing using a local system account and then changing the service
> > > > accounts after the install is complete.
> > > >
> > > > Brad
> > > >
> > > > "Mike" wrote:
> > > >
> > > > > Yes
> > > > >
> > > > > "Brad Feaker" wrote:
> > > > >
> > > > > > Is the NT account you are using to install a member of the local server
> > > > > > Administrator group?
> > > > > >
> > > > > > Brad Feaker
> > > > > > Ex nihilo, nihil fit
> > > > > >
> > > > > > "Mike" wrote:
> > > > > >
> > > > > > > I have a couple third part applications that I'm trying to install that
> > > > > > > install SQL databases. However I get similar errors during both for the
> > > > > > > install.
> > > > > > >
> > > > > > > I'll end up w/ an Error 11001 in the app event log and the contents of the
> > > > > > > error common to both is: Error 1001.Setup failed. --> Windows NT user or
> > > > > > > group 'NT AUTHORITY\domain users' not found. Check the name again.
> > > > > > > Windows NT user or group 'NT AUTHORITY\domain users' not found. Check the
> > > > > > > name again.
> > > > > > > User or role 'NT AUTHORITY\domain users' does not exist in this database.
> > > > > > > User or role 'NT AUTHORITY\domain users' does not exist in this database.,
> > > > > > > (NULL), (NULL), (NULL).
> > > > > > >
> > > > > > >
> > > > > > > I've talked to a couple other users and they haven't experienced the same
> > > > > > > issues. My server is set to mixed mode and the SA account does have a
> > > > > > > password. I've tried installing using the SA account as well as a domain
> > > > > > > admin account and neither worked.|||Thanks. I did so Monday. I believe they're stumped.
"Brad Feaker" wrote:
> At this point you may want to toss the problem back to the vendor....sorry I
> could not be of any assistance...
> Brad
> "Mike" wrote:
> > this is an interactive application that i'm trying to install so I'm not sure
> > there is a way to do what your asking. i'm assuming it comes to this error
> > some point where it's creating the db in sql. it's funny though the the db
> > and tables appear to be created fine.
> >
> > "Brad Feaker" wrote:
> >
> > > Instead of using a windows account at all, choose the 'Local System Account'
> > > option during the install.
> > >
> > > Brad
> > >
> > > "Mike" wrote:
> > >
> > > > Tried using the Administrator account on the local machine. Same problem.
> > > >
> > > > "Brad Feaker" wrote:
> > > >
> > > > > Try installing using a local system account and then changing the service
> > > > > accounts after the install is complete.
> > > > >
> > > > > Brad
> > > > >
> > > > > "Mike" wrote:
> > > > >
> > > > > > Yes
> > > > > >
> > > > > > "Brad Feaker" wrote:
> > > > > >
> > > > > > > Is the NT account you are using to install a member of the local server
> > > > > > > Administrator group?
> > > > > > >
> > > > > > > Brad Feaker
> > > > > > > Ex nihilo, nihil fit
> > > > > > >
> > > > > > > "Mike" wrote:
> > > > > > >
> > > > > > > > I have a couple third part applications that I'm trying to install that
> > > > > > > > install SQL databases. However I get similar errors during both for the
> > > > > > > > install.
> > > > > > > >
> > > > > > > > I'll end up w/ an Error 11001 in the app event log and the contents of the
> > > > > > > > error common to both is: Error 1001.Setup failed. --> Windows NT user or
> > > > > > > > group 'NT AUTHORITY\domain users' not found. Check the name again.
> > > > > > > > Windows NT user or group 'NT AUTHORITY\domain users' not found. Check the
> > > > > > > > name again.
> > > > > > > > User or role 'NT AUTHORITY\domain users' does not exist in this database.
> > > > > > > > User or role 'NT AUTHORITY\domain users' does not exist in this database.,
> > > > > > > > (NULL), (NULL), (NULL).
> > > > > > > >
> > > > > > > >
> > > > > > > > I've talked to a couple other users and they haven't experienced the same
> > > > > > > > issues. My server is set to mixed mode and the SA account does have a
> > > > > > > > password. I've tried installing using the SA account as well as a domain
> > > > > > > > admin account and neither worked.sql
Product error installs
install SQL databases. However I get similar errors during both for the
install.
I'll end up w/ an Error 11001 in the app event log and the contents of the
error common to both is: Error 1001.Setup failed. --> Windows NT user or
group 'NT AUTHORITY\domain users' not found. Check the name again.
Windows NT user or group 'NT AUTHORITY\domain users' not found. Check the
name again.
User or role 'NT AUTHORITY\domain users' does not exist in this database.
User or role 'NT AUTHORITY\domain users' does not exist in this database.,
(NULL), (NULL), (NULL).
I've talked to a couple other users and they haven't experienced the same
issues. My server is set to mixed mode and the SA account does have a
password. I've tried installing using the SA account as well as a domain
admin account and neither worked.Is the NT account you are using to install a member of the local server
Administrator group?
Brad Feaker
Ex nihilo, nihil fit
"Mike" wrote:
> I have a couple third part applications that I'm trying to install that
> install SQL databases. However I get similar errors during both for the
> install.
> I'll end up w/ an Error 11001 in the app event log and the contents of the
> error common to both is: Error 1001.Setup failed. --> Windows NT user or
> group 'NT AUTHORITY\domain users' not found. Check the name again.
> Windows NT user or group 'NT AUTHORITY\domain users' not found. Check the
> name again.
> User or role 'NT AUTHORITY\domain users' does not exist in this database.
> User or role 'NT AUTHORITY\domain users' does not exist in this database.,
> (NULL), (NULL), (NULL).
>
> I've talked to a couple other users and they haven't experienced the same
> issues. My server is set to mixed mode and the SA account does have a
> password. I've tried installing using the SA account as well as a domain
> admin account and neither worked.|||Yes
"Brad Feaker" wrote:
[vbcol=seagreen]
> Is the NT account you are using to install a member of the local server
> Administrator group?
> Brad Feaker
> Ex nihilo, nihil fit
> "Mike" wrote:
>|||Try installing using a local system account and then changing the service
accounts after the install is complete.
Brad
"Mike" wrote:
[vbcol=seagreen]
> Yes
> "Brad Feaker" wrote:
>|||Tried using the Administrator account on the local machine. Same problem.
"Brad Feaker" wrote:
[vbcol=seagreen]
> Try installing using a local system account and then changing the service
> accounts after the install is complete.
> Brad
> "Mike" wrote:
>|||Instead of using a windows account at all, choose the 'Local System Account'
option during the install.
Brad
"Mike" wrote:
[vbcol=seagreen]
> Tried using the Administrator account on the local machine. Same problem.
> "Brad Feaker" wrote:
>|||this is an interactive application that i'm trying to install so I'm not sur
e
there is a way to do what your asking. i'm assuming it comes to this error
some point where it's creating the db in sql. it's funny though the the db
and tables appear to be created fine.
"Brad Feaker" wrote:
[vbcol=seagreen]
> Instead of using a windows account at all, choose the 'Local System Accoun
t'
> option during the install.
> Brad
> "Mike" wrote:
>|||At this point you may want to toss the problem back to the vendor....sorry
I
could not be of any assistance...
Brad
"Mike" wrote:
[vbcol=seagreen]
> this is an interactive application that i'm trying to install so I'm not s
ure
> there is a way to do what your asking. i'm assuming it comes to this erro
r
> some point where it's creating the db in sql. it's funny though the the d
b
> and tables appear to be created fine.
> "Brad Feaker" wrote:
>|||Thanks. I did so Monday. I believe they're stumped.
"Brad Feaker" wrote:
[vbcol=seagreen]
> At this point you may want to toss the problem back to the vendor....sorr
y I
> could not be of any assistance...
> Brad
> "Mike" wrote:
>
Wednesday, March 21, 2012
processor delegation
I know it's possible in SQL Server 2K to delegate which
processors for the engine to use, but is it possible to
delegate which databases or even which tables can use
which processor in a multi-processor server?
Thanks,
BrentOnly if you use multiple instances and use the processor affinity to
delegate certain cpu's for each instance. You could place each db in it's
own instance and then use the affinity as such. But unless you have more
than 8 procs I wouldn't recommend doing this without a really good reason.
It is usually better to let sql server decide how to use the resources.
--
Andrew J. Kelly
SQL Server MVP
"Brent" <brent.sodtke@.nucomm.net> wrote in message
news:0e3e01c34627$da6b4d80$a301280a@.phx.gbl...
> Hi,
> I know it's possible in SQL Server 2K to delegate which
> processors for the engine to use, but is it possible to
> delegate which databases or even which tables can use
> which processor in a multi-processor server?
> Thanks,
> Brent|||Brent,
Nope. If you really want it and have a good case for it, then send your
reasoning to sqlwish@.microsoft.com
> I know it's possible in SQL Server 2K to delegate which
> processors for the engine to use, but is it possible to
> delegate which databases or even which tables can use
> which processor in a multi-processor server?
> Thanks,
> Brent
>
Neil Pike MVP/MCSE. Protech Computing Ltd
Reply here - no email
SQL FAQ (484 entries) see
http://forumsb.compuserve.com/gvforums/UK/default.asp?SRV=MSDevApps
(faqxxx.zip in lib 7)
or www.ntfaq.com/Articles/Index.cfm?DepartmentID=800
or www.sqlserverfaq.com
or www.mssqlserver.com/faqsql
Saturday, February 25, 2012
process cube
I am using analysis server 2000. I have a cube on one of the databases which i am trying to process through the Business Intelligence Development studio.
i have specified the Server and the database name in the 'connection managers' through 'New Analysis Services Connection'
I added the 'Analysis Services Processing Task' to the Control flow but get the following error when i double click on it:
"A connection cannot be made. Ensure that the server is running'
Does anyone know what am i doing wrong?
Any help is appreciated.
Unfortunately you will not be able to use AS 2005 tools against AS2000.
Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
Edward,
Are you from Microsoft's SQL Server Team.
Just wanted to know if the answer was official :)
thanks