Hello, I have a couple of "simple" questions.
I have been told, that with rare exception, all my "production procedures
and tables" should all be owned by "dbo". Does this represent reality.
What are some "common" examples of of where there is a need for different
naming conventions.
When Executing a procedure, should it always be qualified with the Database
name.owner? Are there different rules for client applications? I believe
as part of the connection string for a C# or VB application, it requires
the "Catalog", which equates to the database name. So is there any reason
to specify the DataBase name in these situations?
Thanks in advance for your assistance!!!!!!!Whether it's owned by dbo or some other user depends on your requirements.
Unless you have a specific reason to have the objects owned by individual
users keeping them owned by dbo makes life much simpler and cleaner. You
should always preference a call to an object (sp, table etc) by the
owner.object regardless of who the owner happens to be. Never use the
db.owner.object syntax unless you are calling an object in another db. Doing
these helps the compiler to work most efficiently and reduces the work sql
server must do to properly determine which object you are calling.
--
Andrew J. Kelly
SQL Server MVP
"Jim Heavey" <JimHeavey@.nospam.com> wrote in message
news:Xns945A6552D56CAJimHeaveyhotmailcom@.207.46.248.16...
> Hello, I have a couple of "simple" questions.
> I have been told, that with rare exception, all my "production procedures
> and tables" should all be owned by "dbo". Does this represent reality.
> What are some "common" examples of of where there is a need for different
> naming conventions.
> When Executing a procedure, should it always be qualified with the
Database
> name.owner? Are there different rules for client applications? I believe
> as part of the connection string for a C# or VB application, it requires
> the "Catalog", which equates to the database name. So is there any reason
> to specify the DataBase name in these situations?
> Thanks in advance for your assistance!!!!!!!sql
Showing posts with label couple. Show all posts
Showing posts with label couple. Show all posts
Wednesday, March 28, 2012
Monday, March 26, 2012
Product error installs
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.
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:
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
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.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
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
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.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:
>
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:
>
Monday, March 12, 2012
Processing cube error
Hi,
I have a small problem when trying to process the cubes in AS. We have a
datawarehouse and have done couple of cubes also. In the beginning the cubes
processed fine, but after a while I have begin to get lots of errors. The
error message is "The attribute key cannot be foun. The record was skipped
because the attribute key was not found". Its a clear message, but the
problem is that the key it gives can be found and exists in the database...
Could there be other reasons for this message?
Any ideas? Thanks in advance!are you processing your dimensions?
"beatmasta" <beatmasta@.discussions.microsoft.com> wrote in message
news:2731F26C-2DB8-40D0-B791-A4478D9F0813@.microsoft.com...
> Hi,
> I have a small problem when trying to process the cubes in AS. We have a
> datawarehouse and have done couple of cubes also. In the beginning the
> cubes
> processed fine, but after a while I have begin to get lots of errors. The
> error message is "The attribute key cannot be foun. The record was skipped
> because the attribute key was not found". Its a clear message, but the
> problem is that the key it gives can be found and exists in the
> database...
> Could there be other reasons for this message?
> Any ideas? Thanks in advance!|||Nope...
And yes, that was the problem! Thanks a lot for helping the noobie!
I have a small problem when trying to process the cubes in AS. We have a
datawarehouse and have done couple of cubes also. In the beginning the cubes
processed fine, but after a while I have begin to get lots of errors. The
error message is "The attribute key cannot be foun. The record was skipped
because the attribute key was not found". Its a clear message, but the
problem is that the key it gives can be found and exists in the database...
Could there be other reasons for this message?
Any ideas? Thanks in advance!are you processing your dimensions?
"beatmasta" <beatmasta@.discussions.microsoft.com> wrote in message
news:2731F26C-2DB8-40D0-B791-A4478D9F0813@.microsoft.com...
> Hi,
> I have a small problem when trying to process the cubes in AS. We have a
> datawarehouse and have done couple of cubes also. In the beginning the
> cubes
> processed fine, but after a while I have begin to get lots of errors. The
> error message is "The attribute key cannot be foun. The record was skipped
> because the attribute key was not found". Its a clear message, but the
> problem is that the key it gives can be found and exists in the
> database...
> Could there be other reasons for this message?
> Any ideas? Thanks in advance!|||Nope...
And yes, that was the problem! Thanks a lot for helping the noobie!
Wednesday, March 7, 2012
Process Info
Dear All,
Under Managment/Current Activity/Process Info you can see
all the users with connections to the system.
Here is the problem. A couple of users seem to have
multiple (10 or more) process ID's, all of them sleeping.
After a chat with them they said they were not in the
application, but the process was still being displayed.
My questions are then, should I be concerned, and why
aren't they closing automatically ?
Thanks
Peter
Users have different ideas of what "being in an application"
means so it depends on what they meant. If they meant they
weren't actively using it, then the processes would still be
there if they are still connected. If they application was
actually closed then the processes will clean up eventually.
The processes remaining after closing an app could be due to
poor coding practices in the application, such as ado
references are not being cleaned up. If the issue is the 10
or more processes, that is also controlled by the
application. If it's an ADO app, then it probably wasn't
written to use the active connection - instead it keeps
creating new connections for whatever it needs to do.
It's not really going to hurt anything but it looks like
it's likely related to how the application was written.
-Sue
On Wed, 7 Apr 2004 08:17:28 -0700, "Peter"
<anonymous@.discussions.microsoft.com> wrote:
>Dear All,
>Under Managment/Current Activity/Process Info you can see
>all the users with connections to the system.
>Here is the problem. A couple of users seem to have
>multiple (10 or more) process ID's, all of them sleeping.
>After a chat with them they said they were not in the
>application, but the process was still being displayed.
>My questions are then, should I be concerned, and why
>aren't they closing automatically ?
>Thanks
>Peter
Under Managment/Current Activity/Process Info you can see
all the users with connections to the system.
Here is the problem. A couple of users seem to have
multiple (10 or more) process ID's, all of them sleeping.
After a chat with them they said they were not in the
application, but the process was still being displayed.
My questions are then, should I be concerned, and why
aren't they closing automatically ?
Thanks
Peter
Users have different ideas of what "being in an application"
means so it depends on what they meant. If they meant they
weren't actively using it, then the processes would still be
there if they are still connected. If they application was
actually closed then the processes will clean up eventually.
The processes remaining after closing an app could be due to
poor coding practices in the application, such as ado
references are not being cleaned up. If the issue is the 10
or more processes, that is also controlled by the
application. If it's an ADO app, then it probably wasn't
written to use the active connection - instead it keeps
creating new connections for whatever it needs to do.
It's not really going to hurt anything but it looks like
it's likely related to how the application was written.
-Sue
On Wed, 7 Apr 2004 08:17:28 -0700, "Peter"
<anonymous@.discussions.microsoft.com> wrote:
>Dear All,
>Under Managment/Current Activity/Process Info you can see
>all the users with connections to the system.
>Here is the problem. A couple of users seem to have
>multiple (10 or more) process ID's, all of them sleeping.
>After a chat with them they said they were not in the
>application, but the process was still being displayed.
>My questions are then, should I be concerned, and why
>aren't they closing automatically ?
>Thanks
>Peter
Process Info
Dear All,
Under Managment/Current Activity/Process Info you can see
all the users with connections to the system.
Here is the problem. A couple of users seem to have
multiple (10 or more) process ID's, all of them sleeping.
After a chat with them they said they were not in the
application, but the process was still being displayed.
My questions are then, should I be concerned, and why
aren't they closing automatically ?
Thanks
PeterUsers have different ideas of what "being in an application"
means so it depends on what they meant. If they meant they
weren't actively using it, then the processes would still be
there if they are still connected. If they application was
actually closed then the processes will clean up eventually.
The processes remaining after closing an app could be due to
poor coding practices in the application, such as ado
references are not being cleaned up. If the issue is the 10
or more processes, that is also controlled by the
application. If it's an ADO app, then it probably wasn't
written to use the active connection - instead it keeps
creating new connections for whatever it needs to do.
It's not really going to hurt anything but it looks like
it's likely related to how the application was written.
-Sue
On Wed, 7 Apr 2004 08:17:28 -0700, "Peter"
<anonymous@.discussions.microsoft.com> wrote:
>Dear All,
>Under Managment/Current Activity/Process Info you can see
>all the users with connections to the system.
>Here is the problem. A couple of users seem to have
>multiple (10 or more) process ID's, all of them sleeping.
>After a chat with them they said they were not in the
>application, but the process was still being displayed.
>My questions are then, should I be concerned, and why
>aren't they closing automatically ?
>Thanks
>Peter
Under Managment/Current Activity/Process Info you can see
all the users with connections to the system.
Here is the problem. A couple of users seem to have
multiple (10 or more) process ID's, all of them sleeping.
After a chat with them they said they were not in the
application, but the process was still being displayed.
My questions are then, should I be concerned, and why
aren't they closing automatically ?
Thanks
PeterUsers have different ideas of what "being in an application"
means so it depends on what they meant. If they meant they
weren't actively using it, then the processes would still be
there if they are still connected. If they application was
actually closed then the processes will clean up eventually.
The processes remaining after closing an app could be due to
poor coding practices in the application, such as ado
references are not being cleaned up. If the issue is the 10
or more processes, that is also controlled by the
application. If it's an ADO app, then it probably wasn't
written to use the active connection - instead it keeps
creating new connections for whatever it needs to do.
It's not really going to hurt anything but it looks like
it's likely related to how the application was written.
-Sue
On Wed, 7 Apr 2004 08:17:28 -0700, "Peter"
<anonymous@.discussions.microsoft.com> wrote:
>Dear All,
>Under Managment/Current Activity/Process Info you can see
>all the users with connections to the system.
>Here is the problem. A couple of users seem to have
>multiple (10 or more) process ID's, all of them sleeping.
>After a chat with them they said they were not in the
>application, but the process was still being displayed.
>My questions are then, should I be concerned, and why
>aren't they closing automatically ?
>Thanks
>Peter
Process Info
Dear All,
Under Managment/Current Activity/Process Info you can see
all the users with connections to the system.
Here is the problem. A couple of users seem to have
multiple (10 or more) process ID's, all of them sleeping.
After a chat with them they said they were not in the
application, but the process was still being displayed.
My questions are then, should I be concerned, and why
aren't they closing automatically ?
Thanks
PeterUsers have different ideas of what "being in an application"
means so it depends on what they meant. If they meant they
weren't actively using it, then the processes would still be
there if they are still connected. If they application was
actually closed then the processes will clean up eventually.
The processes remaining after closing an app could be due to
poor coding practices in the application, such as ado
references are not being cleaned up. If the issue is the 10
or more processes, that is also controlled by the
application. If it's an ADO app, then it probably wasn't
written to use the active connection - instead it keeps
creating new connections for whatever it needs to do.
It's not really going to hurt anything but it looks like
it's likely related to how the application was written.
-Sue
On Wed, 7 Apr 2004 08:17:28 -0700, "Peter"
<anonymous@.discussions.microsoft.com> wrote:
>Dear All,
>Under Managment/Current Activity/Process Info you can see
>all the users with connections to the system.
>Here is the problem. A couple of users seem to have
>multiple (10 or more) process ID's, all of them sleeping.
>After a chat with them they said they were not in the
>application, but the process was still being displayed.
>My questions are then, should I be concerned, and why
>aren't they closing automatically ?
>Thanks
>Peter
Under Managment/Current Activity/Process Info you can see
all the users with connections to the system.
Here is the problem. A couple of users seem to have
multiple (10 or more) process ID's, all of them sleeping.
After a chat with them they said they were not in the
application, but the process was still being displayed.
My questions are then, should I be concerned, and why
aren't they closing automatically ?
Thanks
PeterUsers have different ideas of what "being in an application"
means so it depends on what they meant. If they meant they
weren't actively using it, then the processes would still be
there if they are still connected. If they application was
actually closed then the processes will clean up eventually.
The processes remaining after closing an app could be due to
poor coding practices in the application, such as ado
references are not being cleaned up. If the issue is the 10
or more processes, that is also controlled by the
application. If it's an ADO app, then it probably wasn't
written to use the active connection - instead it keeps
creating new connections for whatever it needs to do.
It's not really going to hurt anything but it looks like
it's likely related to how the application was written.
-Sue
On Wed, 7 Apr 2004 08:17:28 -0700, "Peter"
<anonymous@.discussions.microsoft.com> wrote:
>Dear All,
>Under Managment/Current Activity/Process Info you can see
>all the users with connections to the system.
>Here is the problem. A couple of users seem to have
>multiple (10 or more) process ID's, all of them sleeping.
>After a chat with them they said they were not in the
>application, but the process was still being displayed.
>My questions are then, should I be concerned, and why
>aren't they closing automatically ?
>Thanks
>Peter
Saturday, February 25, 2012
Process AS Database
Hi There,
I have one Cube database with couple of facttable and dimensions (SQL 2005), one of the dimension is invoice dimension which has 2 million records, and as you know it is growing every day with new invoice.
I setup SSIS process cube task to process the whole AS Database, however it is failed on me. then I open up my project, try to process one cube at a time, it still gives me error and it is releated my invoice dimension, then I try to process the invoice dimension first, then process the cube, then there is no error.
so the question is: for chaning dimension (new entry every day), should I process this first before processing the cube? I thought when you process the whole AS Database, it should automatically process the dimension then cube.
Thanks
When you are getting the errors, it sounds like you have fact records that have keys pointing to dimension values that have not yet been pulled into the invoice dimension. Processing the invoice dimension first or processing the whole database will avoid this problem. Still, there are other approaches.
First, SSAS includes Unknown member logic. There are a series of properties set on both the dimension and on the cube that determine how this situation is handled. You can configure your cube to recognize the missing dimension value, substitute the Unknown member in its place, and move on. (Use Books Online to help you get started with this. Search for "Unknown Member".)
I must make clear I personally do not like this approach. There are better ways to handle missing/late arriving dimension values, but there are situations where this may be appropriate.
Second, I don't know much about your model, but it sounds like you are working with what Kimball would call a degenerate dimension which is addressed in SSAS as a "fact dimension". Take a look at the Books Online document "Defining a Fact Relationship ". Using fact dimensions may offer some processing advantages to you.
Thanks,
Bryan Smith
Hi Bryan,
Thanks a lot for quick reply. I realize there is error configuration for unknow member, but in my case, this is, as you pointed out correctly, "late arriving dimension", it really should not be in "Unknown", you should think As should be smart enough to process the dimension first, then cube, but it seems not the case here.
Subscribe to:
Posts (Atom)