We sell a software package that runs on dedicated servers at sites that
typically have no db administrator. SQL Server 2000 is the database, and the
application is very write intensive – data for 50 to 200 parameters is
written to the database every minute, 24 hours a day, 7 days a week. Typical
database size is about 4 or 5 GB. Usually there are a few client
workstations. The application is also read intensive. We have configured
the systems with 3 drives such that tempdb is on C, database files are on D
and the log is on E. Because of frequent disk failures and the relatively
high expense of correcting those failures, we want to switch to RAID. Having
little experience, we are looking for advice. RAID 10 is probably not an
option because of the expense. I would highly appreciate any suggestions.
Rethink your aversion to RAID10. It performs better than RAID5 on
write-intensive installations and there is more high-availability associated
with it. Calculate how much revenue your business will lose in one day.
It's likely more than a handful of disks.
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinpub.com
..
"KMP" <KMP@.discussions.microsoft.com> wrote in message
news:87394BC3-4BD5-4D70-A0B4-C4D4C2DCC7AA@.microsoft.com...
We sell a software package that runs on dedicated servers at sites that
typically have no db administrator. SQL Server 2000 is the database, and
the
application is very write intensive – data for 50 to 200 parameters is
written to the database every minute, 24 hours a day, 7 days a week.
Typical
database size is about 4 or 5 GB. Usually there are a few client
workstations. The application is also read intensive. We have configured
the systems with 3 drives such that tempdb is on C, database files are on D
and the log is on E. Because of frequent disk failures and the relatively
high expense of correcting those failures, we want to switch to RAID.
Having
little experience, we are looking for advice. RAID 10 is probably not an
option because of the expense. I would highly appreciate any suggestions.
|||With such small amounts of data you might as well go with RAID 1
(mirroring), with three pairs of drives. RAID 10 has advantages but
with just 4 to 5 GB of data it would be difficult justifying enough
drives to make a good RAID 10 set. For a write intensive application
you should avoid RAID 5 altogether.
One question I have to ask. You say you have "frequent disk
failures". What kind of drives are you using? (For server
applications I expect SCSI.) What brand are they?
Good luck!
Roy
On Wed, 22 Feb 2006 12:11:27 -0800, KMP
<KMP@.discussions.microsoft.com> wrote:
>We sell a software package that runs on dedicated servers at sites that
>typically have no db administrator. SQL Server 2000 is the database, and the
>application is very write intensive data for 50 to 200 parameters is
>written to the database every minute, 24 hours a day, 7 days a week. Typical
>database size is about 4 or 5 GB. Usually there are a few client
>workstations. The application is also read intensive. We have configured
>the systems with 3 drives such that tempdb is on C, database files are on D
>and the log is on E. Because of frequent disk failures and the relatively
>high expense of correcting those failures, we want to switch to RAID. Having
>little experience, we are looking for advice. RAID 10 is probably not an
>option because of the expense. I would highly appreciate any suggestions.
Showing posts with label administrator. Show all posts
Showing posts with label administrator. Show all posts
Thursday, March 29, 2012
Advice on RAID
We sell a software package that runs on dedicated servers at sites that
typically have no db administrator. SQL Server 2000 is the database, and the
application is very write intensive â' data for 50 to 200 parameters is
written to the database every minute, 24 hours a day, 7 days a week. Typical
database size is about 4 or 5 GB. Usually there are a few client
workstations. The application is also read intensive. We have configured
the systems with 3 drives such that tempdb is on C, database files are on D
and the log is on E. Because of frequent disk failures and the relatively
high expense of correcting those failures, we want to switch to RAID. Having
little experience, we are looking for advice. RAID 10 is probably not an
option because of the expense. I would highly appreciate any suggestions.Rethink your aversion to RAID10. It performs better than RAID5 on
write-intensive installations and there is more high-availability associated
with it. Calculate how much revenue your business will lose in one day.
It's likely more than a handful of disks.
--
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinpub.com
.
"KMP" <KMP@.discussions.microsoft.com> wrote in message
news:87394BC3-4BD5-4D70-A0B4-C4D4C2DCC7AA@.microsoft.com...
We sell a software package that runs on dedicated servers at sites that
typically have no db administrator. SQL Server 2000 is the database, and
the
application is very write intensive â' data for 50 to 200 parameters is
written to the database every minute, 24 hours a day, 7 days a week.
Typical
database size is about 4 or 5 GB. Usually there are a few client
workstations. The application is also read intensive. We have configured
the systems with 3 drives such that tempdb is on C, database files are on D
and the log is on E. Because of frequent disk failures and the relatively
high expense of correcting those failures, we want to switch to RAID.
Having
little experience, we are looking for advice. RAID 10 is probably not an
option because of the expense. I would highly appreciate any suggestions.|||With such small amounts of data you might as well go with RAID 1
(mirroring), with three pairs of drives. RAID 10 has advantages but
with just 4 to 5 GB of data it would be difficult justifying enough
drives to make a good RAID 10 set. For a write intensive application
you should avoid RAID 5 altogether.
One question I have to ask. You say you have "frequent disk
failures". What kind of drives are you using? (For server
applications I expect SCSI.) What brand are they?
Good luck!
Roy
On Wed, 22 Feb 2006 12:11:27 -0800, KMP
<KMP@.discussions.microsoft.com> wrote:
>We sell a software package that runs on dedicated servers at sites that
>typically have no db administrator. SQL Server 2000 is the database, and the
>application is very write intensive ? data for 50 to 200 parameters is
>written to the database every minute, 24 hours a day, 7 days a week. Typical
>database size is about 4 or 5 GB. Usually there are a few client
>workstations. The application is also read intensive. We have configured
>the systems with 3 drives such that tempdb is on C, database files are on D
>and the log is on E. Because of frequent disk failures and the relatively
>high expense of correcting those failures, we want to switch to RAID. Having
>little experience, we are looking for advice. RAID 10 is probably not an
>option because of the expense. I would highly appreciate any suggestions.
typically have no db administrator. SQL Server 2000 is the database, and the
application is very write intensive â' data for 50 to 200 parameters is
written to the database every minute, 24 hours a day, 7 days a week. Typical
database size is about 4 or 5 GB. Usually there are a few client
workstations. The application is also read intensive. We have configured
the systems with 3 drives such that tempdb is on C, database files are on D
and the log is on E. Because of frequent disk failures and the relatively
high expense of correcting those failures, we want to switch to RAID. Having
little experience, we are looking for advice. RAID 10 is probably not an
option because of the expense. I would highly appreciate any suggestions.Rethink your aversion to RAID10. It performs better than RAID5 on
write-intensive installations and there is more high-availability associated
with it. Calculate how much revenue your business will lose in one day.
It's likely more than a handful of disks.
--
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinpub.com
.
"KMP" <KMP@.discussions.microsoft.com> wrote in message
news:87394BC3-4BD5-4D70-A0B4-C4D4C2DCC7AA@.microsoft.com...
We sell a software package that runs on dedicated servers at sites that
typically have no db administrator. SQL Server 2000 is the database, and
the
application is very write intensive â' data for 50 to 200 parameters is
written to the database every minute, 24 hours a day, 7 days a week.
Typical
database size is about 4 or 5 GB. Usually there are a few client
workstations. The application is also read intensive. We have configured
the systems with 3 drives such that tempdb is on C, database files are on D
and the log is on E. Because of frequent disk failures and the relatively
high expense of correcting those failures, we want to switch to RAID.
Having
little experience, we are looking for advice. RAID 10 is probably not an
option because of the expense. I would highly appreciate any suggestions.|||With such small amounts of data you might as well go with RAID 1
(mirroring), with three pairs of drives. RAID 10 has advantages but
with just 4 to 5 GB of data it would be difficult justifying enough
drives to make a good RAID 10 set. For a write intensive application
you should avoid RAID 5 altogether.
One question I have to ask. You say you have "frequent disk
failures". What kind of drives are you using? (For server
applications I expect SCSI.) What brand are they?
Good luck!
Roy
On Wed, 22 Feb 2006 12:11:27 -0800, KMP
<KMP@.discussions.microsoft.com> wrote:
>We sell a software package that runs on dedicated servers at sites that
>typically have no db administrator. SQL Server 2000 is the database, and the
>application is very write intensive ? data for 50 to 200 parameters is
>written to the database every minute, 24 hours a day, 7 days a week. Typical
>database size is about 4 or 5 GB. Usually there are a few client
>workstations. The application is also read intensive. We have configured
>the systems with 3 drives such that tempdb is on C, database files are on D
>and the log is on E. Because of frequent disk failures and the relatively
>high expense of correcting those failures, we want to switch to RAID. Having
>little experience, we are looking for advice. RAID 10 is probably not an
>option because of the expense. I would highly appreciate any suggestions.
Advice on RAID
We sell a software package that runs on dedicated servers at sites that
typically have no db administrator. SQL Server 2000 is the database, and th
e
application is very write intensive – data for 50 to 200 parameters is
written to the database every minute, 24 hours a day, 7 days a week. Typica
l
database size is about 4 or 5 GB. Usually there are a few client
workstations. The application is also read intensive. We have configured
the systems with 3 drives such that tempdb is on C, database files are on D
and the log is on E. Because of frequent disk failures and the relatively
high expense of correcting those failures, we want to switch to RAID. Havin
g
little experience, we are looking for advice. RAID 10 is probably not an
option because of the expense. I would highly appreciate any suggestions.Rethink your aversion to RAID10. It performs better than RAID5 on
write-intensive installations and there is more high-availability associated
with it. Calculate how much revenue your business will lose in one day.
It's likely more than a handful of disks.
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinpub.com
.
"KMP" <KMP@.discussions.microsoft.com> wrote in message
news:87394BC3-4BD5-4D70-A0B4-C4D4C2DCC7AA@.microsoft.com...
We sell a software package that runs on dedicated servers at sites that
typically have no db administrator. SQL Server 2000 is the database, and
the
application is very write intensive – data for 50 to 200 parameters is
written to the database every minute, 24 hours a day, 7 days a week.
Typical
database size is about 4 or 5 GB. Usually there are a few client
workstations. The application is also read intensive. We have configured
the systems with 3 drives such that tempdb is on C, database files are on D
and the log is on E. Because of frequent disk failures and the relatively
high expense of correcting those failures, we want to switch to RAID.
Having
little experience, we are looking for advice. RAID 10 is probably not an
option because of the expense. I would highly appreciate any suggestions.|||With such small amounts of data you might as well go with RAID 1
(mirroring), with three pairs of drives. RAID 10 has advantages but
with just 4 to 5 GB of data it would be difficult justifying enough
drives to make a good RAID 10 set. For a write intensive application
you should avoid RAID 5 altogether.
One question I have to ask. You say you have "frequent disk
failures". What kind of drives are you using? (For server
applications I expect SCSI.) What brand are they?
Good luck!
Roy
On Wed, 22 Feb 2006 12:11:27 -0800, KMP
<KMP@.discussions.microsoft.com> wrote:
>We sell a software package that runs on dedicated servers at sites that
>typically have no db administrator. SQL Server 2000 is the database, and t
he
>application is very write intensive data for 50 to 200 parameters is
>written to the database every minute, 24 hours a day, 7 days a week. Typic
al
>database size is about 4 or 5 GB. Usually there are a few client
>workstations. The application is also read intensive. We have configured
>the systems with 3 drives such that tempdb is on C, database files are on D
>and the log is on E. Because of frequent disk failures and the relatively
>high expense of correcting those failures, we want to switch to RAID. Havi
ng
>little experience, we are looking for advice. RAID 10 is probably not an
>option because of the expense. I would highly appreciate any suggestions.
typically have no db administrator. SQL Server 2000 is the database, and th
e
application is very write intensive – data for 50 to 200 parameters is
written to the database every minute, 24 hours a day, 7 days a week. Typica
l
database size is about 4 or 5 GB. Usually there are a few client
workstations. The application is also read intensive. We have configured
the systems with 3 drives such that tempdb is on C, database files are on D
and the log is on E. Because of frequent disk failures and the relatively
high expense of correcting those failures, we want to switch to RAID. Havin
g
little experience, we are looking for advice. RAID 10 is probably not an
option because of the expense. I would highly appreciate any suggestions.Rethink your aversion to RAID10. It performs better than RAID5 on
write-intensive installations and there is more high-availability associated
with it. Calculate how much revenue your business will lose in one day.
It's likely more than a handful of disks.
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinpub.com
.
"KMP" <KMP@.discussions.microsoft.com> wrote in message
news:87394BC3-4BD5-4D70-A0B4-C4D4C2DCC7AA@.microsoft.com...
We sell a software package that runs on dedicated servers at sites that
typically have no db administrator. SQL Server 2000 is the database, and
the
application is very write intensive – data for 50 to 200 parameters is
written to the database every minute, 24 hours a day, 7 days a week.
Typical
database size is about 4 or 5 GB. Usually there are a few client
workstations. The application is also read intensive. We have configured
the systems with 3 drives such that tempdb is on C, database files are on D
and the log is on E. Because of frequent disk failures and the relatively
high expense of correcting those failures, we want to switch to RAID.
Having
little experience, we are looking for advice. RAID 10 is probably not an
option because of the expense. I would highly appreciate any suggestions.|||With such small amounts of data you might as well go with RAID 1
(mirroring), with three pairs of drives. RAID 10 has advantages but
with just 4 to 5 GB of data it would be difficult justifying enough
drives to make a good RAID 10 set. For a write intensive application
you should avoid RAID 5 altogether.
One question I have to ask. You say you have "frequent disk
failures". What kind of drives are you using? (For server
applications I expect SCSI.) What brand are they?
Good luck!
Roy
On Wed, 22 Feb 2006 12:11:27 -0800, KMP
<KMP@.discussions.microsoft.com> wrote:
>We sell a software package that runs on dedicated servers at sites that
>typically have no db administrator. SQL Server 2000 is the database, and t
he
>application is very write intensive data for 50 to 200 parameters is
>written to the database every minute, 24 hours a day, 7 days a week. Typic
al
>database size is about 4 or 5 GB. Usually there are a few client
>workstations. The application is also read intensive. We have configured
>the systems with 3 drives such that tempdb is on C, database files are on D
>and the log is on E. Because of frequent disk failures and the relatively
>high expense of correcting those failures, we want to switch to RAID. Havi
ng
>little experience, we are looking for advice. RAID 10 is probably not an
>option because of the expense. I would highly appreciate any suggestions.
Sunday, March 25, 2012
Advice needed - how to build skills as a MS database administrator
Would appreciate some advice for a small/mid company IT MCSE that is now
required to pick up MCDBA skills (with a training budget that limits me to
Barnes&Noble).
Our environment has an SQL 2000 on our ERP server; both will be upgraded in
November, where we will have SQL 2005.
I've scanned over free technet documentation, and subscribed to newsletters
- but could use a bit more direction.
I'd be interested in an SQL guru's advice on how I could ramp up my skill
quickly - to at least maintain an existing SQL database with an app server.
High quality books (they don't need to start at ground zero, I am a
proficient SQL writer already), and quality websites, would be greatly
appreciated. I'm looking for materials that will show me how to provide
proper maintenace and optimize performance of an SQL server.
Thanks in advance,
--
pbrill1You might find something useful here.
http://msdn2.microsoft.com/en-us/virtuallabs/aa740409.aspx
http://www.microsoft.com/learning/assessment/ind/windowsserver/default.mspx#EWD
Regards,
Dave Patrick ...Please no email replies - reply in newsgroup.
Microsoft Certified Professional
Microsoft MVP [Windows]
http://www.microsoft.com/protect
"pbrill1" wrote:
> Would appreciate some advice for a small/mid company IT MCSE that is now
> required to pick up MCDBA skills (with a training budget that limits me to
> Barnes&Noble).
> Our environment has an SQL 2000 on our ERP server; both will be upgraded
> in
> November, where we will have SQL 2005.
> I've scanned over free technet documentation, and subscribed to
> newsletters
> - but could use a bit more direction.
> I'd be interested in an SQL guru's advice on how I could ramp up my skill
> quickly - to at least maintain an existing SQL database with an app
> server.
> High quality books (they don't need to start at ground zero, I am a
> proficient SQL writer already), and quality websites, would be greatly
> appreciated. I'm looking for materials that will show me how to provide
> proper maintenace and optimize performance of an SQL server.
> Thanks in advance,
> --
> pbrill1|||Hello!
There are self-training kits you can buy. They are very good.
MCDBA certificate is for SQL Server 2000. There is a new certification path
for SQL Server 2005.
First you need to achieve MCTS: SQL Server 2005 certificate by sitting for
70-431 exam.
http://www.microsoft.com/learning/mcp/mcts/sql/default.mspx
And then you need to achieve MCITP: DBA certificate by sitting for 70-443
and 70-444 exams.
http://www.microsoft.com/learning/mcp/mcitp/dbadmin/default.mspx
You can find recommended sources by Microsoft from the links above to study
on these exams.
Ekrem Ã?nsoy
"pbrill1" <pbrill1@.discussions.microsoft.com> wrote in message
news:36FADB02-C067-42FC-84DD-9A36425B9997@.microsoft.com...
> Would appreciate some advice for a small/mid company IT MCSE that is now
> required to pick up MCDBA skills (with a training budget that limits me to
> Barnes&Noble).
> Our environment has an SQL 2000 on our ERP server; both will be upgraded
> in
> November, where we will have SQL 2005.
> I've scanned over free technet documentation, and subscribed to
> newsletters
> - but could use a bit more direction.
> I'd be interested in an SQL guru's advice on how I could ramp up my skill
> quickly - to at least maintain an existing SQL database with an app
> server.
> High quality books (they don't need to start at ground zero, I am a
> proficient SQL writer already), and quality websites, would be greatly
> appreciated. I'm looking for materials that will show me how to provide
> proper maintenace and optimize performance of an SQL server.
> Thanks in advance,
> --
> pbrill1|||Thank you for the information.
At present, I won't be looking to certify as an SQL DBA (on a personal note
- no training funding until well into 2008) - so I need to run up the
learning curve on a budget of $50 or less.
Microsoft books (hardcover or online) or good how-to websites/blogs that can
show me how to 1) set up a maintenance schedule for SQL 2005 (what to
maintain/how often), and 2) tips/tricks to provide overall performance
improvements (i.e., I don't intend to dive into complex coding to seek
performance improvements) - would be the type of resource that I'm looking
for. A Microsoft SQL 2005 "DBA Secrets" type reference, maybe?
Any advice on inexpensive (again $50 range) resources would be greatly
appreciated.
--
pbrill1
"Dave Patrick" wrote:
> You might find something useful here.
> http://msdn2.microsoft.com/en-us/virtuallabs/aa740409.aspx
> http://www.microsoft.com/learning/assessment/ind/windowsserver/default.mspx#EWD
>
> --
> Regards,
> Dave Patrick ...Please no email replies - reply in newsgroup.
> Microsoft Certified Professional
> Microsoft MVP [Windows]
> http://www.microsoft.com/protect
> "pbrill1" wrote:
> > Would appreciate some advice for a small/mid company IT MCSE that is now
> > required to pick up MCDBA skills (with a training budget that limits me to
> > Barnes&Noble).
> >
> > Our environment has an SQL 2000 on our ERP server; both will be upgraded
> > in
> > November, where we will have SQL 2005.
> >
> > I've scanned over free technet documentation, and subscribed to
> > newsletters
> > - but could use a bit more direction.
> >
> > I'd be interested in an SQL guru's advice on how I could ramp up my skill
> > quickly - to at least maintain an existing SQL database with an app
> > server.
> > High quality books (they don't need to start at ground zero, I am a
> > proficient SQL writer already), and quality websites, would be greatly
> > appreciated. I'm looking for materials that will show me how to provide
> > proper maintenace and optimize performance of an SQL server.
> >
> > Thanks in advance,
> > --
> > pbrill1
>
required to pick up MCDBA skills (with a training budget that limits me to
Barnes&Noble).
Our environment has an SQL 2000 on our ERP server; both will be upgraded in
November, where we will have SQL 2005.
I've scanned over free technet documentation, and subscribed to newsletters
- but could use a bit more direction.
I'd be interested in an SQL guru's advice on how I could ramp up my skill
quickly - to at least maintain an existing SQL database with an app server.
High quality books (they don't need to start at ground zero, I am a
proficient SQL writer already), and quality websites, would be greatly
appreciated. I'm looking for materials that will show me how to provide
proper maintenace and optimize performance of an SQL server.
Thanks in advance,
--
pbrill1You might find something useful here.
http://msdn2.microsoft.com/en-us/virtuallabs/aa740409.aspx
http://www.microsoft.com/learning/assessment/ind/windowsserver/default.mspx#EWD
Regards,
Dave Patrick ...Please no email replies - reply in newsgroup.
Microsoft Certified Professional
Microsoft MVP [Windows]
http://www.microsoft.com/protect
"pbrill1" wrote:
> Would appreciate some advice for a small/mid company IT MCSE that is now
> required to pick up MCDBA skills (with a training budget that limits me to
> Barnes&Noble).
> Our environment has an SQL 2000 on our ERP server; both will be upgraded
> in
> November, where we will have SQL 2005.
> I've scanned over free technet documentation, and subscribed to
> newsletters
> - but could use a bit more direction.
> I'd be interested in an SQL guru's advice on how I could ramp up my skill
> quickly - to at least maintain an existing SQL database with an app
> server.
> High quality books (they don't need to start at ground zero, I am a
> proficient SQL writer already), and quality websites, would be greatly
> appreciated. I'm looking for materials that will show me how to provide
> proper maintenace and optimize performance of an SQL server.
> Thanks in advance,
> --
> pbrill1|||Hello!
There are self-training kits you can buy. They are very good.
MCDBA certificate is for SQL Server 2000. There is a new certification path
for SQL Server 2005.
First you need to achieve MCTS: SQL Server 2005 certificate by sitting for
70-431 exam.
http://www.microsoft.com/learning/mcp/mcts/sql/default.mspx
And then you need to achieve MCITP: DBA certificate by sitting for 70-443
and 70-444 exams.
http://www.microsoft.com/learning/mcp/mcitp/dbadmin/default.mspx
You can find recommended sources by Microsoft from the links above to study
on these exams.
Ekrem Ã?nsoy
"pbrill1" <pbrill1@.discussions.microsoft.com> wrote in message
news:36FADB02-C067-42FC-84DD-9A36425B9997@.microsoft.com...
> Would appreciate some advice for a small/mid company IT MCSE that is now
> required to pick up MCDBA skills (with a training budget that limits me to
> Barnes&Noble).
> Our environment has an SQL 2000 on our ERP server; both will be upgraded
> in
> November, where we will have SQL 2005.
> I've scanned over free technet documentation, and subscribed to
> newsletters
> - but could use a bit more direction.
> I'd be interested in an SQL guru's advice on how I could ramp up my skill
> quickly - to at least maintain an existing SQL database with an app
> server.
> High quality books (they don't need to start at ground zero, I am a
> proficient SQL writer already), and quality websites, would be greatly
> appreciated. I'm looking for materials that will show me how to provide
> proper maintenace and optimize performance of an SQL server.
> Thanks in advance,
> --
> pbrill1|||Thank you for the information.
At present, I won't be looking to certify as an SQL DBA (on a personal note
- no training funding until well into 2008) - so I need to run up the
learning curve on a budget of $50 or less.
Microsoft books (hardcover or online) or good how-to websites/blogs that can
show me how to 1) set up a maintenance schedule for SQL 2005 (what to
maintain/how often), and 2) tips/tricks to provide overall performance
improvements (i.e., I don't intend to dive into complex coding to seek
performance improvements) - would be the type of resource that I'm looking
for. A Microsoft SQL 2005 "DBA Secrets" type reference, maybe?
Any advice on inexpensive (again $50 range) resources would be greatly
appreciated.
--
pbrill1
"Dave Patrick" wrote:
> You might find something useful here.
> http://msdn2.microsoft.com/en-us/virtuallabs/aa740409.aspx
> http://www.microsoft.com/learning/assessment/ind/windowsserver/default.mspx#EWD
>
> --
> Regards,
> Dave Patrick ...Please no email replies - reply in newsgroup.
> Microsoft Certified Professional
> Microsoft MVP [Windows]
> http://www.microsoft.com/protect
> "pbrill1" wrote:
> > Would appreciate some advice for a small/mid company IT MCSE that is now
> > required to pick up MCDBA skills (with a training budget that limits me to
> > Barnes&Noble).
> >
> > Our environment has an SQL 2000 on our ERP server; both will be upgraded
> > in
> > November, where we will have SQL 2005.
> >
> > I've scanned over free technet documentation, and subscribed to
> > newsletters
> > - but could use a bit more direction.
> >
> > I'd be interested in an SQL guru's advice on how I could ramp up my skill
> > quickly - to at least maintain an existing SQL database with an app
> > server.
> > High quality books (they don't need to start at ground zero, I am a
> > proficient SQL writer already), and quality websites, would be greatly
> > appreciated. I'm looking for materials that will show me how to provide
> > proper maintenace and optimize performance of an SQL server.
> >
> > Thanks in advance,
> > --
> > pbrill1
>
Sunday, February 12, 2012
administrators group is deleted...
I deleted "administrators" group and "administrator" user in sql server by
chance.
How can I create them back.
Thanks in advance.I mean;
MyServer\administrator
BUILTIN\administrators
"haode" <haode@.hao.com> wrote in message
news:u8R%234Tf9DHA.1816@.TK2MSFTNGP12.phx.gbl...
> I deleted "administrators" group and "administrator" user in sql server by
> chance.
> How can I create them back.
> Thanks in advance.
>|||Log is as SA and you should be able to do it.
"haode" <haode@.hao.com> wrote in message
news:u8R%234Tf9DHA.1816@.TK2MSFTNGP12.phx.gbl...
> I deleted "administrators" group and "administrator" user in sql server by
> chance.
> How can I create them back.
> Thanks in advance.
>
chance.
How can I create them back.
Thanks in advance.I mean;
MyServer\administrator
BUILTIN\administrators
"haode" <haode@.hao.com> wrote in message
news:u8R%234Tf9DHA.1816@.TK2MSFTNGP12.phx.gbl...
> I deleted "administrators" group and "administrator" user in sql server by
> chance.
> How can I create them back.
> Thanks in advance.
>|||Log is as SA and you should be able to do it.
"haode" <haode@.hao.com> wrote in message
news:u8R%234Tf9DHA.1816@.TK2MSFTNGP12.phx.gbl...
> I deleted "administrators" group and "administrator" user in sql server by
> chance.
> How can I create them back.
> Thanks in advance.
>
administrators group is deleted...
I deleted "administrators" group and "administrator" user in sql server by
chance.
How can I create them back.
Thanks in advance.I mean;
MyServer\administrator
BUILTIN\administrators
"haode" <haode@.hao.com> wrote in message
news:u8R%234Tf9DHA.1816@.TK2MSFTNGP12.phx.gbl...
> I deleted "administrators" group and "administrator" user in sql server by
> chance.
> How can I create them back.
> Thanks in advance.
>|||Log is as SA and you should be able to do it.
"haode" <haode@.hao.com> wrote in message
news:u8R%234Tf9DHA.1816@.TK2MSFTNGP12.phx.gbl...
> I deleted "administrators" group and "administrator" user in sql server by
> chance.
> How can I create them back.
> Thanks in advance.
>
chance.
How can I create them back.
Thanks in advance.I mean;
MyServer\administrator
BUILTIN\administrators
"haode" <haode@.hao.com> wrote in message
news:u8R%234Tf9DHA.1816@.TK2MSFTNGP12.phx.gbl...
> I deleted "administrators" group and "administrator" user in sql server by
> chance.
> How can I create them back.
> Thanks in advance.
>|||Log is as SA and you should be able to do it.
"haode" <haode@.hao.com> wrote in message
news:u8R%234Tf9DHA.1816@.TK2MSFTNGP12.phx.gbl...
> I deleted "administrators" group and "administrator" user in sql server by
> chance.
> How can I create them back.
> Thanks in advance.
>
Administrator with No Report Manager Privileges
I am logged on as a user with administrative privileges to
my machine, to the machine housing the report server
database, and to the the web server, yet when I go to
Report Manager, I do not have access to the Home folder,
only one lower folder, and no Site Settings for anything.
How do I add the necessary privileges if I'm already the
administrator?I found that if you have set the Report Server virtual directory to allow
anonymous access in the IIS mgmt console, you may find yourself in the
situation you described. I was experimenting with anonymous and got into the
situation, where I was a local admin but options like create new folders and
upload files were all gone from Report Manager. After I removed anonymous
access, I was able to fully administer Reporting Services via Report Manager
again.
Linchi
"Terry" <anonymous@.discussions.microsoft.com> wrote in message
news:029c01c47a5e$9cc531a0$a601280a@.phx.gbl...
> I am logged on as a user with administrative privileges to
> my machine, to the machine housing the report server
> database, and to the the web server, yet when I go to
> Report Manager, I do not have access to the Home folder,
> only one lower folder, and no Site Settings for anything.
> How do I add the necessary privileges if I'm already the
> administrator?
>|||Linchi, Thanks for your response and you are correct
about the configuration of anonymous access, however,
this site needs anonymous access. Any suggestions on how
to get my rights back and keep anonymous access?
>--Original Message--
>I found that if you have set the Report Server virtual
directory to allow
>anonymous access in the IIS mgmt console, you may find
yourself in the
>situation you described. I was experimenting with
anonymous and got into the
>situation, where I was a local admin but options like
create new folders and
>upload files were all gone from Report Manager. After I
removed anonymous
>access, I was able to fully administer Reporting
Services via Report Manager
>again.
>Linchi
>"Terry" <anonymous@.discussions.microsoft.com> wrote in
message
>news:029c01c47a5e$9cc531a0$a601280a@.phx.gbl...
>> I am logged on as a user with administrative
privileges to
>> my machine, to the machine housing the report server
>> database, and to the the web server, yet when I go to
>> Report Manager, I do not have access to the Home
folder,
>> only one lower folder, and no Site Settings for
anything.
>> How do I add the necessary privileges if I'm already
the
>> administrator?
>
>.
>|||No, I have not found why or how to work around it. In my case, I didn't
really need anonymous access. I hope MS folks can shed some light on this
behavior.
Linchi
"Terry" <anonymous@.discussions.microsoft.com> wrote in message
news:085c01c47af3$75d2fe20$a301280a@.phx.gbl...
> Linchi, Thanks for your response and you are correct
> about the configuration of anonymous access, however,
> this site needs anonymous access. Any suggestions on how
> to get my rights back and keep anonymous access?
>
> >--Original Message--
> >I found that if you have set the Report Server virtual
> directory to allow
> >anonymous access in the IIS mgmt console, you may find
> yourself in the
> >situation you described. I was experimenting with
> anonymous and got into the
> >situation, where I was a local admin but options like
> create new folders and
> >upload files were all gone from Report Manager. After I
> removed anonymous
> >access, I was able to fully administer Reporting
> Services via Report Manager
> >again.
> >
> >Linchi
> >
> >"Terry" <anonymous@.discussions.microsoft.com> wrote in
> message
> >news:029c01c47a5e$9cc531a0$a601280a@.phx.gbl...
> >> I am logged on as a user with administrative
> privileges to
> >> my machine, to the machine housing the report server
> >> database, and to the the web server, yet when I go to
> >> Report Manager, I do not have access to the Home
> folder,
> >> only one lower folder, and no Site Settings for
> anything.
> >> How do I add the necessary privileges if I'm already
> the
> >> administrator?
> >>
> >
> >
> >.
> >|||When you enable anonymous access, all requests come in as the anonymous
user. Since that user does not have any role assignments in the report
server, they cannot see any folders, nor can they perform operations.
We recommend that you do not use anonymous access to the report server, but
enable windows secuirty.
-Lukasz
This posting is provided "AS IS" with no warranties, and confers no rights.
"Linchi Shea" <linchi_shea@.NOSPAM.ml.com> wrote in message
news:eBZrcj1eEHA.2028@.tk2msftngp13.phx.gbl...
> No, I have not found why or how to work around it. In my case, I didn't
> really need anonymous access. I hope MS folks can shed some light on this
> behavior.
> Linchi
> "Terry" <anonymous@.discussions.microsoft.com> wrote in message
> news:085c01c47af3$75d2fe20$a301280a@.phx.gbl...
>> Linchi, Thanks for your response and you are correct
>> about the configuration of anonymous access, however,
>> this site needs anonymous access. Any suggestions on how
>> to get my rights back and keep anonymous access?
>>
>> >--Original Message--
>> >I found that if you have set the Report Server virtual
>> directory to allow
>> >anonymous access in the IIS mgmt console, you may find
>> yourself in the
>> >situation you described. I was experimenting with
>> anonymous and got into the
>> >situation, where I was a local admin but options like
>> create new folders and
>> >upload files were all gone from Report Manager. After I
>> removed anonymous
>> >access, I was able to fully administer Reporting
>> Services via Report Manager
>> >again.
>> >
>> >Linchi
>> >
>> >"Terry" <anonymous@.discussions.microsoft.com> wrote in
>> message
>> >news:029c01c47a5e$9cc531a0$a601280a@.phx.gbl...
>> >> I am logged on as a user with administrative
>> privileges to
>> >> my machine, to the machine housing the report server
>> >> database, and to the the web server, yet when I go to
>> >> Report Manager, I do not have access to the Home
>> folder,
>> >> only one lower folder, and no Site Settings for
>> anything.
>> >> How do I add the necessary privileges if I'm already
>> the
>> >> administrator?
>> >>
>> >
>> >
>> >.
>> >
>
my machine, to the machine housing the report server
database, and to the the web server, yet when I go to
Report Manager, I do not have access to the Home folder,
only one lower folder, and no Site Settings for anything.
How do I add the necessary privileges if I'm already the
administrator?I found that if you have set the Report Server virtual directory to allow
anonymous access in the IIS mgmt console, you may find yourself in the
situation you described. I was experimenting with anonymous and got into the
situation, where I was a local admin but options like create new folders and
upload files were all gone from Report Manager. After I removed anonymous
access, I was able to fully administer Reporting Services via Report Manager
again.
Linchi
"Terry" <anonymous@.discussions.microsoft.com> wrote in message
news:029c01c47a5e$9cc531a0$a601280a@.phx.gbl...
> I am logged on as a user with administrative privileges to
> my machine, to the machine housing the report server
> database, and to the the web server, yet when I go to
> Report Manager, I do not have access to the Home folder,
> only one lower folder, and no Site Settings for anything.
> How do I add the necessary privileges if I'm already the
> administrator?
>|||Linchi, Thanks for your response and you are correct
about the configuration of anonymous access, however,
this site needs anonymous access. Any suggestions on how
to get my rights back and keep anonymous access?
>--Original Message--
>I found that if you have set the Report Server virtual
directory to allow
>anonymous access in the IIS mgmt console, you may find
yourself in the
>situation you described. I was experimenting with
anonymous and got into the
>situation, where I was a local admin but options like
create new folders and
>upload files were all gone from Report Manager. After I
removed anonymous
>access, I was able to fully administer Reporting
Services via Report Manager
>again.
>Linchi
>"Terry" <anonymous@.discussions.microsoft.com> wrote in
message
>news:029c01c47a5e$9cc531a0$a601280a@.phx.gbl...
>> I am logged on as a user with administrative
privileges to
>> my machine, to the machine housing the report server
>> database, and to the the web server, yet when I go to
>> Report Manager, I do not have access to the Home
folder,
>> only one lower folder, and no Site Settings for
anything.
>> How do I add the necessary privileges if I'm already
the
>> administrator?
>
>.
>|||No, I have not found why or how to work around it. In my case, I didn't
really need anonymous access. I hope MS folks can shed some light on this
behavior.
Linchi
"Terry" <anonymous@.discussions.microsoft.com> wrote in message
news:085c01c47af3$75d2fe20$a301280a@.phx.gbl...
> Linchi, Thanks for your response and you are correct
> about the configuration of anonymous access, however,
> this site needs anonymous access. Any suggestions on how
> to get my rights back and keep anonymous access?
>
> >--Original Message--
> >I found that if you have set the Report Server virtual
> directory to allow
> >anonymous access in the IIS mgmt console, you may find
> yourself in the
> >situation you described. I was experimenting with
> anonymous and got into the
> >situation, where I was a local admin but options like
> create new folders and
> >upload files were all gone from Report Manager. After I
> removed anonymous
> >access, I was able to fully administer Reporting
> Services via Report Manager
> >again.
> >
> >Linchi
> >
> >"Terry" <anonymous@.discussions.microsoft.com> wrote in
> message
> >news:029c01c47a5e$9cc531a0$a601280a@.phx.gbl...
> >> I am logged on as a user with administrative
> privileges to
> >> my machine, to the machine housing the report server
> >> database, and to the the web server, yet when I go to
> >> Report Manager, I do not have access to the Home
> folder,
> >> only one lower folder, and no Site Settings for
> anything.
> >> How do I add the necessary privileges if I'm already
> the
> >> administrator?
> >>
> >
> >
> >.
> >|||When you enable anonymous access, all requests come in as the anonymous
user. Since that user does not have any role assignments in the report
server, they cannot see any folders, nor can they perform operations.
We recommend that you do not use anonymous access to the report server, but
enable windows secuirty.
-Lukasz
This posting is provided "AS IS" with no warranties, and confers no rights.
"Linchi Shea" <linchi_shea@.NOSPAM.ml.com> wrote in message
news:eBZrcj1eEHA.2028@.tk2msftngp13.phx.gbl...
> No, I have not found why or how to work around it. In my case, I didn't
> really need anonymous access. I hope MS folks can shed some light on this
> behavior.
> Linchi
> "Terry" <anonymous@.discussions.microsoft.com> wrote in message
> news:085c01c47af3$75d2fe20$a301280a@.phx.gbl...
>> Linchi, Thanks for your response and you are correct
>> about the configuration of anonymous access, however,
>> this site needs anonymous access. Any suggestions on how
>> to get my rights back and keep anonymous access?
>>
>> >--Original Message--
>> >I found that if you have set the Report Server virtual
>> directory to allow
>> >anonymous access in the IIS mgmt console, you may find
>> yourself in the
>> >situation you described. I was experimenting with
>> anonymous and got into the
>> >situation, where I was a local admin but options like
>> create new folders and
>> >upload files were all gone from Report Manager. After I
>> removed anonymous
>> >access, I was able to fully administer Reporting
>> Services via Report Manager
>> >again.
>> >
>> >Linchi
>> >
>> >"Terry" <anonymous@.discussions.microsoft.com> wrote in
>> message
>> >news:029c01c47a5e$9cc531a0$a601280a@.phx.gbl...
>> >> I am logged on as a user with administrative
>> privileges to
>> >> my machine, to the machine housing the report server
>> >> database, and to the the web server, yet when I go to
>> >> Report Manager, I do not have access to the Home
>> folder,
>> >> only one lower folder, and no Site Settings for
>> anything.
>> >> How do I add the necessary privileges if I'm already
>> the
>> >> administrator?
>> >>
>> >
>> >
>> >.
>> >
>
administrator rights
This doesn't seem to have anything to do with SQL Server Reporting Services, but to answer your question you are probably a limited user.
Go to control panel and click User Accounts. Click on your user account from the list of users. Then click "change the account type". Next, select Computer Administrator.
Administrator Password changed causes backup failure
We changed our administrator password on all of our servers. We were backin
g
up our SQL databases to another server
(ex: \\anotherserver\dropbox\databackup) However, we can no longer backup
to any other location other than a local drive on our SQL 2000 server.
If we try to create a backup to another location, we get a message that
reads something like: SQL can not verify the location of the file. Do you
want to use this location anyway?
When we try to backup to the location, the we get the error message that
reads: file or folder not on-line.
If we change the network adminstrator password back to it's original, we can
once again backup.
Thank you,
Ron Dittmann
--
Ron DittmannHere is the error code I found in the SqlServerAgent log:
[298] SQLServer Error: 8198, Could not obtain information about Windows
NT
group/user 'domain\username'. [SQLSTATE 42000] (ConnIsLoginSysAdmin)
Any info on this issue would be helpful. We are using Service Pack 3 one
SQL 2000 on Windows 2000 Server with ALL service packs and Windows updates
installed. The password we changed was the Administrator password for the
network, not the "sa" password. We even tried to reenter the Server Agent
password with no luck.
Thank you
Ron Dittmann
"dpolara" wrote:
> We changed our administrator password on all of our servers. We were back
ing
> up our SQL databases to another server
> (ex: \\anotherserver\dropbox\databackup) However, we can no longer backup
> to any other location other than a local drive on our SQL 2000 server.
> If we try to create a backup to another location, we get a message that
> reads something like: SQL can not verify the location of the file. Do you
> want to use this location anyway?
> When we try to backup to the location, the we get the error message that
> reads: file or folder not on-line.
> If we change the network adminstrator password back to it's original, we c
an
> once again backup.
> Thank you,
> Ron Dittmann
> --
> Ron Dittmann|||Check the following troubleshooting article:
How to troubleshoot a SQL Server 8198 error
http://support.microsoft.com/?id=834124
-Sue
On Wed, 13 Oct 2004 20:39:07 -0700, "dpolara"
<dpolara@.discussions.microsoft.com> wrote:
>We changed our administrator password on all of our servers. We were backi
ng
>up our SQL databases to another server
>(ex: \\anotherserver\dropbox\databackup) However, we can no longer backup
>to any other location other than a local drive on our SQL 2000 server.
>If we try to create a backup to another location, we get a message that
>reads something like: SQL can not verify the location of the file. Do you
>want to use this location anyway?
>When we try to backup to the location, the we get the error message that
>reads: file or folder not on-line.
>If we change the network adminstrator password back to it's original, we ca
n
>once again backup.
>Thank you,
>Ron Dittmann
g
up our SQL databases to another server
(ex: \\anotherserver\dropbox\databackup) However, we can no longer backup
to any other location other than a local drive on our SQL 2000 server.
If we try to create a backup to another location, we get a message that
reads something like: SQL can not verify the location of the file. Do you
want to use this location anyway?
When we try to backup to the location, the we get the error message that
reads: file or folder not on-line.
If we change the network adminstrator password back to it's original, we can
once again backup.
Thank you,
Ron Dittmann
--
Ron DittmannHere is the error code I found in the SqlServerAgent log:
[298] SQLServer Error: 8198, Could not obtain information about Windows
NT
group/user 'domain\username'. [SQLSTATE 42000] (ConnIsLoginSysAdmin)
Any info on this issue would be helpful. We are using Service Pack 3 one
SQL 2000 on Windows 2000 Server with ALL service packs and Windows updates
installed. The password we changed was the Administrator password for the
network, not the "sa" password. We even tried to reenter the Server Agent
password with no luck.
Thank you
Ron Dittmann
"dpolara" wrote:
> We changed our administrator password on all of our servers. We were back
ing
> up our SQL databases to another server
> (ex: \\anotherserver\dropbox\databackup) However, we can no longer backup
> to any other location other than a local drive on our SQL 2000 server.
> If we try to create a backup to another location, we get a message that
> reads something like: SQL can not verify the location of the file. Do you
> want to use this location anyway?
> When we try to backup to the location, the we get the error message that
> reads: file or folder not on-line.
> If we change the network adminstrator password back to it's original, we c
an
> once again backup.
> Thank you,
> Ron Dittmann
> --
> Ron Dittmann|||Check the following troubleshooting article:
How to troubleshoot a SQL Server 8198 error
http://support.microsoft.com/?id=834124
-Sue
On Wed, 13 Oct 2004 20:39:07 -0700, "dpolara"
<dpolara@.discussions.microsoft.com> wrote:
>We changed our administrator password on all of our servers. We were backi
ng
>up our SQL databases to another server
>(ex: \\anotherserver\dropbox\databackup) However, we can no longer backup
>to any other location other than a local drive on our SQL 2000 server.
>If we try to create a backup to another location, we get a message that
>reads something like: SQL can not verify the location of the file. Do you
>want to use this location anyway?
>When we try to backup to the location, the we get the error message that
>reads: file or folder not on-line.
>If we change the network adminstrator password back to it's original, we ca
n
>once again backup.
>Thank you,
>Ron Dittmann
administrator password and sql startup
A reality check please...
After changing the domain administrator password, we are no longer
able to connect to databases on a MS SQL Server 2000 server when
attempting to use ODBC drivers from W2K workstations.
The MSSQLSERVER and SQLSERVERAGENT services both show DomainName
\Administrator under the "Logon under This Account" in the 'Logon' tab
in services.msc. The server name inside the SQL server are set to
mixed mode.
Am I correct in thinking that changing the password field shown in the
"Login under This Account: DomainName\Administrator to match the new
domain administrator password will bring Joy?
Thanks!
BenoitSorry dude, I just saw this post. Yes, if you change a domain acct password
,
you have to change it in the services config box as well.
However, let me caution you... running SQL under an admin acct is bad
enough, but running it under the domain admin acct is just irresponsible.
Seriously, create a separate acct for SQL and give it local admin rights if
you have to, but DON"T use the domain admin acct.
"bntgoogle@.yahoo.com" wrote:
> A reality check please...
> After changing the domain administrator password, we are no longer
> able to connect to databases on a MS SQL Server 2000 server when
> attempting to use ODBC drivers from W2K workstations.
> The MSSQLSERVER and SQLSERVERAGENT services both show DomainName
> \Administrator under the "Logon under This Account" in the 'Logon' tab
> in services.msc. The server name inside the SQL server are set to
> mixed mode.
> Am I correct in thinking that changing the password field shown in the
> "Login under This Account: DomainName\Administrator to match the new
> domain administrator password will bring Joy?
> Thanks!
> Benoit
>
After changing the domain administrator password, we are no longer
able to connect to databases on a MS SQL Server 2000 server when
attempting to use ODBC drivers from W2K workstations.
The MSSQLSERVER and SQLSERVERAGENT services both show DomainName
\Administrator under the "Logon under This Account" in the 'Logon' tab
in services.msc. The server name inside the SQL server are set to
mixed mode.
Am I correct in thinking that changing the password field shown in the
"Login under This Account: DomainName\Administrator to match the new
domain administrator password will bring Joy?
Thanks!
BenoitSorry dude, I just saw this post. Yes, if you change a domain acct password
,
you have to change it in the services config box as well.
However, let me caution you... running SQL under an admin acct is bad
enough, but running it under the domain admin acct is just irresponsible.
Seriously, create a separate acct for SQL and give it local admin rights if
you have to, but DON"T use the domain admin acct.
"bntgoogle@.yahoo.com" wrote:
> A reality check please...
> After changing the domain administrator password, we are no longer
> able to connect to databases on a MS SQL Server 2000 server when
> attempting to use ODBC drivers from W2K workstations.
> The MSSQLSERVER and SQLSERVERAGENT services both show DomainName
> \Administrator under the "Logon under This Account" in the 'Logon' tab
> in services.msc. The server name inside the SQL server are set to
> mixed mode.
> Am I correct in thinking that changing the password field shown in the
> "Login under This Account: DomainName\Administrator to match the new
> domain administrator password will bring Joy?
> Thanks!
> Benoit
>
administrator password and sql startup
A reality check please...
After changing the domain administrator password, we are no longer
able to connect to databases on a MS SQL Server 2000 server when
attempting to use ODBC drivers from W2K workstations.
The MSSQLSERVER and SQLSERVERAGENT services both show DomainName
\Administrator under the "Logon under This Account" in the 'Logon' tab
in services.msc. The server name inside the SQL server are set to
mixed mode.
Am I correct in thinking that changing the password field shown in the
"Login under This Account: DomainName\Administrator to match the new
domain administrator password will bring Joy?
Thanks!
Benoit
Sorry dude, I just saw this post. Yes, if you change a domain acct password,
you have to change it in the services config box as well.
However, let me caution you... running SQL under an admin acct is bad
enough, but running it under the domain admin acct is just irresponsible.
Seriously, create a separate acct for SQL and give it local admin rights if
you have to, but DON"T use the domain admin acct.
"bntgoogle@.yahoo.com" wrote:
> A reality check please...
> After changing the domain administrator password, we are no longer
> able to connect to databases on a MS SQL Server 2000 server when
> attempting to use ODBC drivers from W2K workstations.
> The MSSQLSERVER and SQLSERVERAGENT services both show DomainName
> \Administrator under the "Logon under This Account" in the 'Logon' tab
> in services.msc. The server name inside the SQL server are set to
> mixed mode.
> Am I correct in thinking that changing the password field shown in the
> "Login under This Account: DomainName\Administrator to match the new
> domain administrator password will bring Joy?
> Thanks!
> Benoit
>
After changing the domain administrator password, we are no longer
able to connect to databases on a MS SQL Server 2000 server when
attempting to use ODBC drivers from W2K workstations.
The MSSQLSERVER and SQLSERVERAGENT services both show DomainName
\Administrator under the "Logon under This Account" in the 'Logon' tab
in services.msc. The server name inside the SQL server are set to
mixed mode.
Am I correct in thinking that changing the password field shown in the
"Login under This Account: DomainName\Administrator to match the new
domain administrator password will bring Joy?
Thanks!
Benoit
Sorry dude, I just saw this post. Yes, if you change a domain acct password,
you have to change it in the services config box as well.
However, let me caution you... running SQL under an admin acct is bad
enough, but running it under the domain admin acct is just irresponsible.
Seriously, create a separate acct for SQL and give it local admin rights if
you have to, but DON"T use the domain admin acct.
"bntgoogle@.yahoo.com" wrote:
> A reality check please...
> After changing the domain administrator password, we are no longer
> able to connect to databases on a MS SQL Server 2000 server when
> attempting to use ODBC drivers from W2K workstations.
> The MSSQLSERVER and SQLSERVERAGENT services both show DomainName
> \Administrator under the "Logon under This Account" in the 'Logon' tab
> in services.msc. The server name inside the SQL server are set to
> mixed mode.
> Am I correct in thinking that changing the password field shown in the
> "Login under This Account: DomainName\Administrator to match the new
> domain administrator password will bring Joy?
> Thanks!
> Benoit
>
Administrator logon rejected with ODBC Drivers error '80040e4d'
I'm running SQL Server 2000 under Windows 2000 Advanced Server.
Authentication is set up as Windows Only. The Administrator account for the
server is set up as an SQL user (this is done by default). I'm using the
following ASP code to log onto a sample database (for which the
Administrator has been granted access):
strConnectionString = "Provider=MSDASQL;DRIVER={SQL Server};" +_
"Server=localhost;database=" + strDBaseName +
";UID=MACHINENAME\Administrator;PWD=password;"
However, I get the following error:
Microsoft OLE DB Provider for ODBC Drivers error '80040e4d'
[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user
'MACHINENAME\Administrator'. Reason: Not associated with a trusted SQL
Server connection.
I get the same error even if I use Administrator without MACHINENAME. I
even enabled Basic Authentication on the default website, as Microsoft
suggested.
Any ideas why the Administrator is being rejected?
Thanks,
Lisa
Lisa wrote:
> I'm running SQL Server 2000 under Windows 2000 Advanced Server.
> Authentication is set up as Windows Only. The Administrator account
> for the server is set up as an SQL user (this is done by default).
> I'm using the following ASP code to log onto a sample database (for
> which the Administrator has been granted access):
> strConnectionString = "Provider=MSDASQL;DRIVER={SQL Server};" +_
> "Server=localhost;database=" + strDBaseName +
> ";UID=MACHINENAME\Administrator;PWD=password;"
> However, I get the following error:
> Microsoft OLE DB Provider for ODBC Drivers error '80040e4d'
> [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user
> 'MACHINENAME\Administrator'. Reason: Not associated with a trusted SQL
> Server connection.
> I get the same error even if I use Administrator without MACHINENAME.
> I even enabled Basic Authentication on the default website, as
> Microsoft suggested.
> Any ideas why the Administrator is being rejected?
> Thanks,
> Lisa
You don't want to do it that way. UserID and Password are only for SQL
Authentication, not Windows Authentication. It looks like your IIS
server is running on the same box as SQL Server (not a great idea for
anything but an internal site). If that's the case, you only need to
specify in the connection string that you are using an Trusted
Connection. No password is required.
Add "TrustedConnection=Yes" to the connection string. It automatically
uses the current connection to Windows to authenticate.
David Gugick
Imceda Software
www.imceda.com
Authentication is set up as Windows Only. The Administrator account for the
server is set up as an SQL user (this is done by default). I'm using the
following ASP code to log onto a sample database (for which the
Administrator has been granted access):
strConnectionString = "Provider=MSDASQL;DRIVER={SQL Server};" +_
"Server=localhost;database=" + strDBaseName +
";UID=MACHINENAME\Administrator;PWD=password;"
However, I get the following error:
Microsoft OLE DB Provider for ODBC Drivers error '80040e4d'
[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user
'MACHINENAME\Administrator'. Reason: Not associated with a trusted SQL
Server connection.
I get the same error even if I use Administrator without MACHINENAME. I
even enabled Basic Authentication on the default website, as Microsoft
suggested.
Any ideas why the Administrator is being rejected?
Thanks,
Lisa
Lisa wrote:
> I'm running SQL Server 2000 under Windows 2000 Advanced Server.
> Authentication is set up as Windows Only. The Administrator account
> for the server is set up as an SQL user (this is done by default).
> I'm using the following ASP code to log onto a sample database (for
> which the Administrator has been granted access):
> strConnectionString = "Provider=MSDASQL;DRIVER={SQL Server};" +_
> "Server=localhost;database=" + strDBaseName +
> ";UID=MACHINENAME\Administrator;PWD=password;"
> However, I get the following error:
> Microsoft OLE DB Provider for ODBC Drivers error '80040e4d'
> [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user
> 'MACHINENAME\Administrator'. Reason: Not associated with a trusted SQL
> Server connection.
> I get the same error even if I use Administrator without MACHINENAME.
> I even enabled Basic Authentication on the default website, as
> Microsoft suggested.
> Any ideas why the Administrator is being rejected?
> Thanks,
> Lisa
You don't want to do it that way. UserID and Password are only for SQL
Authentication, not Windows Authentication. It looks like your IIS
server is running on the same box as SQL Server (not a great idea for
anything but an internal site). If that's the case, you only need to
specify in the connection string that you are using an Trusted
Connection. No password is required.
Add "TrustedConnection=Yes" to the connection string. It automatically
uses the current connection to Windows to authenticate.
David Gugick
Imceda Software
www.imceda.com
Administrator logon rejected with ODBC Drivers error '80040e4d'
I'm running SQL Server 2000 under Windows 2000 Advanced Server.
Authentication is set up as Windows Only. The Administrator account for the
server is set up as an SQL user (this is done by default). I'm using the
following ASP code to log onto a sample database (for which the
Administrator has been granted access):
strConnectionString = "Provider=MSDASQL;DRIVER={SQL Server};" +_
"Server=localhost;database=" + strDBaseName +
";UID=MACHINENAME\Administrator;PWD=password;"
However, I get the following error:
Microsoft OLE DB Provider for ODBC Drivers error '80040e4d'
[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user
'MACHINENAME\Administrator'. Reason: Not associated with a trusted SQL
Server connection.
I get the same error even if I use Administrator without MACHINENAME. I
even enabled Basic Authentication on the default website, as Microsoft
suggested.
Any ideas why the Administrator is being rejected?
Thanks,
Lisa
Lisa wrote:
> I'm running SQL Server 2000 under Windows 2000 Advanced Server.
> Authentication is set up as Windows Only. The Administrator account
> for the server is set up as an SQL user (this is done by default).
> I'm using the following ASP code to log onto a sample database (for
> which the Administrator has been granted access):
> strConnectionString = "Provider=MSDASQL;DRIVER={SQL Server};" +_
> "Server=localhost;database=" + strDBaseName +
> ";UID=MACHINENAME\Administrator;PWD=password;"
> However, I get the following error:
> Microsoft OLE DB Provider for ODBC Drivers error '80040e4d'
> [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user
> 'MACHINENAME\Administrator'. Reason: Not associated with a trusted SQL
> Server connection.
> I get the same error even if I use Administrator without MACHINENAME.
> I even enabled Basic Authentication on the default website, as
> Microsoft suggested.
> Any ideas why the Administrator is being rejected?
> Thanks,
> Lisa
You don't want to do it that way. UserID and Password are only for SQL
Authentication, not Windows Authentication. It looks like your IIS
server is running on the same box as SQL Server (not a great idea for
anything but an internal site). If that's the case, you only need to
specify in the connection string that you are using an Trusted
Connection. No password is required.
Add "TrustedConnection=Yes" to the connection string. It automatically
uses the current connection to Windows to authenticate.
David Gugick
Imceda Software
www.imceda.com
Authentication is set up as Windows Only. The Administrator account for the
server is set up as an SQL user (this is done by default). I'm using the
following ASP code to log onto a sample database (for which the
Administrator has been granted access):
strConnectionString = "Provider=MSDASQL;DRIVER={SQL Server};" +_
"Server=localhost;database=" + strDBaseName +
";UID=MACHINENAME\Administrator;PWD=password;"
However, I get the following error:
Microsoft OLE DB Provider for ODBC Drivers error '80040e4d'
[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user
'MACHINENAME\Administrator'. Reason: Not associated with a trusted SQL
Server connection.
I get the same error even if I use Administrator without MACHINENAME. I
even enabled Basic Authentication on the default website, as Microsoft
suggested.
Any ideas why the Administrator is being rejected?
Thanks,
Lisa
Lisa wrote:
> I'm running SQL Server 2000 under Windows 2000 Advanced Server.
> Authentication is set up as Windows Only. The Administrator account
> for the server is set up as an SQL user (this is done by default).
> I'm using the following ASP code to log onto a sample database (for
> which the Administrator has been granted access):
> strConnectionString = "Provider=MSDASQL;DRIVER={SQL Server};" +_
> "Server=localhost;database=" + strDBaseName +
> ";UID=MACHINENAME\Administrator;PWD=password;"
> However, I get the following error:
> Microsoft OLE DB Provider for ODBC Drivers error '80040e4d'
> [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user
> 'MACHINENAME\Administrator'. Reason: Not associated with a trusted SQL
> Server connection.
> I get the same error even if I use Administrator without MACHINENAME.
> I even enabled Basic Authentication on the default website, as
> Microsoft suggested.
> Any ideas why the Administrator is being rejected?
> Thanks,
> Lisa
You don't want to do it that way. UserID and Password are only for SQL
Authentication, not Windows Authentication. It looks like your IIS
server is running on the same box as SQL Server (not a great idea for
anything but an internal site). If that's the case, you only need to
specify in the connection string that you are using an Trusted
Connection. No password is required.
Add "TrustedConnection=Yes" to the connection string. It automatically
uses the current connection to Windows to authenticate.
David Gugick
Imceda Software
www.imceda.com
Administrator logon rejected with ODBC Drivers error '80040e4d'
I'm running SQL Server 2000 under Windows 2000 Advanced Server.
Authentication is set up as Windows Only. The Administrator account for the
server is set up as an SQL user (this is done by default). I'm using the
following ASP code to log onto a sample database (for which the
Administrator has been granted access):
strConnectionString = "Provider=MSDASQL;DRIVER={SQL Server};" +_
"Server=localhost;database=" + strDBaseName +
";UID=MACHINENAME\Administrator;PWD=password;"
However, I get the following error:
Microsoft OLE DB Provider for ODBC Drivers error '80040e4d'
[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user
'MACHINENAME\Administrator'. Reason: Not associated with a trusted SQL
Server connection.
I get the same error even if I use Administrator without MACHINENAME. I
even enabled Basic Authentication on the default website, as Microsoft
suggested.
Any ideas why the Administrator is being rejected?
Thanks,
Lisa
Lisa wrote:
> I'm running SQL Server 2000 under Windows 2000 Advanced Server.
> Authentication is set up as Windows Only. The Administrator account
> for the server is set up as an SQL user (this is done by default).
> I'm using the following ASP code to log onto a sample database (for
> which the Administrator has been granted access):
> strConnectionString = "Provider=MSDASQL;DRIVER={SQL Server};" +_
> "Server=localhost;database=" + strDBaseName +
> ";UID=MACHINENAME\Administrator;PWD=password;"
> However, I get the following error:
> Microsoft OLE DB Provider for ODBC Drivers error '80040e4d'
> [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user
> 'MACHINENAME\Administrator'. Reason: Not associated with a trusted SQL
> Server connection.
> I get the same error even if I use Administrator without MACHINENAME.
> I even enabled Basic Authentication on the default website, as
> Microsoft suggested.
> Any ideas why the Administrator is being rejected?
> Thanks,
> Lisa
You don't want to do it that way. UserID and Password are only for SQL
Authentication, not Windows Authentication. It looks like your IIS
server is running on the same box as SQL Server (not a great idea for
anything but an internal site). If that's the case, you only need to
specify in the connection string that you are using an Trusted
Connection. No password is required.
Add "TrustedConnection=Yes" to the connection string. It automatically
uses the current connection to Windows to authenticate.
David Gugick
Imceda Software
www.imceda.com
Authentication is set up as Windows Only. The Administrator account for the
server is set up as an SQL user (this is done by default). I'm using the
following ASP code to log onto a sample database (for which the
Administrator has been granted access):
strConnectionString = "Provider=MSDASQL;DRIVER={SQL Server};" +_
"Server=localhost;database=" + strDBaseName +
";UID=MACHINENAME\Administrator;PWD=password;"
However, I get the following error:
Microsoft OLE DB Provider for ODBC Drivers error '80040e4d'
[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user
'MACHINENAME\Administrator'. Reason: Not associated with a trusted SQL
Server connection.
I get the same error even if I use Administrator without MACHINENAME. I
even enabled Basic Authentication on the default website, as Microsoft
suggested.
Any ideas why the Administrator is being rejected?
Thanks,
Lisa
Lisa wrote:
> I'm running SQL Server 2000 under Windows 2000 Advanced Server.
> Authentication is set up as Windows Only. The Administrator account
> for the server is set up as an SQL user (this is done by default).
> I'm using the following ASP code to log onto a sample database (for
> which the Administrator has been granted access):
> strConnectionString = "Provider=MSDASQL;DRIVER={SQL Server};" +_
> "Server=localhost;database=" + strDBaseName +
> ";UID=MACHINENAME\Administrator;PWD=password;"
> However, I get the following error:
> Microsoft OLE DB Provider for ODBC Drivers error '80040e4d'
> [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user
> 'MACHINENAME\Administrator'. Reason: Not associated with a trusted SQL
> Server connection.
> I get the same error even if I use Administrator without MACHINENAME.
> I even enabled Basic Authentication on the default website, as
> Microsoft suggested.
> Any ideas why the Administrator is being rejected?
> Thanks,
> Lisa
You don't want to do it that way. UserID and Password are only for SQL
Authentication, not Windows Authentication. It looks like your IIS
server is running on the same box as SQL Server (not a great idea for
anything but an internal site). If that's the case, you only need to
specify in the connection string that you are using an Trusted
Connection. No password is required.
Add "TrustedConnection=Yes" to the connection string. It automatically
uses the current connection to Windows to authenticate.
David Gugick
Imceda Software
www.imceda.com
Administrator logon rejected with ODBC Drivers error '80040e4d'
I'm running SQL Server 2000 under Windows 2000 Advanced Server.
Authentication is set up as Windows Only. The Administrator account for the
server is set up as an SQL user (this is done by default). I'm using the
following ASP code to log onto a sample database (for which the
Administrator has been granted access):
strConnectionString = "Provider=MSDASQL;DRIVER={SQL Server};" +_
"Server=localhost;database=" + strDBaseName +
" ;UID=MACHINENAME\Administrator;PWD=passw
ord;"
However, I get the following error:
Microsoft OLE DB Provider for ODBC Drivers error '80040e4d'
[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for
user
'MACHINENAME\Administrator'. Reason: Not associated with a trusted SQL
Server connection.
I get the same error even if I use Administrator without MACHINENAME. I
even enabled Basic Authentication on the default website, as Microsoft
suggested.
Any ideas why the Administrator is being rejected?
Thanks,
LisaLisa wrote:
> I'm running SQL Server 2000 under Windows 2000 Advanced Server.
> Authentication is set up as Windows Only. The Administrator account
> for the server is set up as an SQL user (this is done by default).
> I'm using the following ASP code to log onto a sample database (for
> which the Administrator has been granted access):
> strConnectionString = "Provider=MSDASQL;DRIVER={SQL Server};" +_
> "Server=localhost;database=" + strDBaseName +
> " ;UID=MACHINENAME\Administrator;PWD=passw
ord;"
> However, I get the following error:
> Microsoft OLE DB Provider for ODBC Drivers error '80040e4d'
> [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed fo
r user
> 'MACHINENAME\Administrator'. Reason: Not associated with a trusted SQL
> Server connection.
> I get the same error even if I use Administrator without MACHINENAME.
> I even enabled Basic Authentication on the default website, as
> Microsoft suggested.
> Any ideas why the Administrator is being rejected?
> Thanks,
> Lisa
You don't want to do it that way. UserID and Password are only for SQL
Authentication, not Windows Authentication. It looks like your IIS
server is running on the same box as SQL Server (not a great idea for
anything but an internal site). If that's the case, you only need to
specify in the connection string that you are using an Trusted
Connection. No password is required.
Add "TrustedConnection=Yes" to the connection string. It automatically
uses the current connection to Windows to authenticate.
David Gugick
Imceda Software
www.imceda.com
Authentication is set up as Windows Only. The Administrator account for the
server is set up as an SQL user (this is done by default). I'm using the
following ASP code to log onto a sample database (for which the
Administrator has been granted access):
strConnectionString = "Provider=MSDASQL;DRIVER={SQL Server};" +_
"Server=localhost;database=" + strDBaseName +
" ;UID=MACHINENAME\Administrator;PWD=passw
ord;"
However, I get the following error:
Microsoft OLE DB Provider for ODBC Drivers error '80040e4d'
[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for
user
'MACHINENAME\Administrator'. Reason: Not associated with a trusted SQL
Server connection.
I get the same error even if I use Administrator without MACHINENAME. I
even enabled Basic Authentication on the default website, as Microsoft
suggested.
Any ideas why the Administrator is being rejected?
Thanks,
LisaLisa wrote:
> I'm running SQL Server 2000 under Windows 2000 Advanced Server.
> Authentication is set up as Windows Only. The Administrator account
> for the server is set up as an SQL user (this is done by default).
> I'm using the following ASP code to log onto a sample database (for
> which the Administrator has been granted access):
> strConnectionString = "Provider=MSDASQL;DRIVER={SQL Server};" +_
> "Server=localhost;database=" + strDBaseName +
> " ;UID=MACHINENAME\Administrator;PWD=passw
ord;"
> However, I get the following error:
> Microsoft OLE DB Provider for ODBC Drivers error '80040e4d'
> [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed fo
r user
> 'MACHINENAME\Administrator'. Reason: Not associated with a trusted SQL
> Server connection.
> I get the same error even if I use Administrator without MACHINENAME.
> I even enabled Basic Authentication on the default website, as
> Microsoft suggested.
> Any ideas why the Administrator is being rejected?
> Thanks,
> Lisa
You don't want to do it that way. UserID and Password are only for SQL
Authentication, not Windows Authentication. It looks like your IIS
server is running on the same box as SQL Server (not a great idea for
anything but an internal site). If that's the case, you only need to
specify in the connection string that you are using an Trusted
Connection. No password is required.
Add "TrustedConnection=Yes" to the connection string. It automatically
uses the current connection to Windows to authenticate.
David Gugick
Imceda Software
www.imceda.com
administrator for win98se
Hello. I need an administrator for pc with win98se. Where i will find it?
Thanks for all...!
Regards
RV
hi Richard,
"Richard Villalon" <villalon@.cantv.net> ha scritto nel messaggio
news:OUZF4KbUEHA.1764@.TK2MSFTNGP10.phx.gbl...
> Hello. I need an administrator for pc with win98se. Where i will find it?
> Thanks for all...!
>
what kind of "administrator" do you need?
MSDE administrator, remote administrator, ... ?
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.8.0 - DbaMgr ver 0.54.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||hi andrea. Thanks for your comments. Where are you from? I'm from caracas,
venezuela.
Well, about my question is simple. The sql server 2000 has the enterpride
manager for create databases, field, store procedure, etc. but in msde 2000
i don't know the similar for pc with win98se.
Thanks for all and best regards.
rv@.cantv.net
"Andrea Montanari" <andrea.sqlDMO@.virgilio.it> escribi en el mensaje
news:2j5ppvFtncgoU1@.uni-berlin.de...[vbcol=seagreen]
> hi Richard,
> "Richard Villalon" <villalon@.cantv.net> ha scritto nel messaggio
> news:OUZF4KbUEHA.1764@.TK2MSFTNGP10.phx.gbl...
it?
> what kind of "administrator" do you need?
> MSDE administrator, remote administrator, ... ?
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.8.0 - DbaMgr ver 0.54.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>
|||hi Richard,
"Richard Villalon" <villalon@.cantv.net> ha scritto nel messaggio
news:ueBV9TnUEHA.3944@.tk2msftngp13.phx.gbl...
> hi andrea. Thanks for your comments. Where are you from? I'm from caracas,
> venezuela.
> Well, about my question is simple. The sql server 2000 has the enterpride
> manager for create databases, field, store procedure, etc. but in msde
2000
> i don't know the similar for pc with win98se.
> Thanks for all and best regards.
I'm italian =;-D
MSDE is not provided with client tools bu oSql.exe, the command line
utility..
you can find some visual tools at
http://www.microsoft.com/sql/msde/partners/default.asp and/or
http://www.aspfaq.com/show.asp?id=2442 or you can have a look at a free prj
of mine at the link following my wign., which provides a user interface
similar to Enterprise Manager...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.8.0 - DbaMgr ver 0.54.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Ok Andrea. Very nice. Do you work in Italy or another country?
I saw that you have an excellent tools for msde. It's the "DBAMGR2K"
It's free thsi tool?
Thanks for all.
PD. My personal e-mail is rv@.cantv.net
*************************************
"Andrea Montanari" <andrea.sqlDMO@.virgilio.it> escribi en el mensaje
news:2j84guFukheuU1@.uni-berlin.de...[vbcol=seagreen]
> hi Richard,
> "Richard Villalon" <villalon@.cantv.net> ha scritto nel messaggio
> news:ueBV9TnUEHA.3944@.tk2msftngp13.phx.gbl...
caracas,[vbcol=seagreen]
enterpride
> 2000
> I'm italian =;-D
> MSDE is not provided with client tools bu oSql.exe, the command line
> utility..
> you can find some visual tools at
> http://www.microsoft.com/sql/msde/partners/default.asp and/or
> http://www.aspfaq.com/show.asp?id=2442 or you can have a look at a free
prj
> of mine at the link following my wign., which provides a user interface
> similar to Enterprise Manager...
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.8.0 - DbaMgr ver 0.54.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>
|||hi Richard,
"Richard Villaln" <rv@.cantv.net> ha scritto nel messaggio
news:ug7enr6UEHA.2484@.TK2MSFTNGP11.phx.gbl...
> Ok Andrea. Very nice. Do you work in Italy or another country?
> I saw that you have an excellent tools for msde. It's the "DBAMGR2K"
> It's free thsi tool?
> Thanks for all.
yep, I work and live in Italy, Adriatic East Coast =;-D , but this is OT
=;-D
DbaMgr2k is free to use, but please post questions relative to it privately,
as this is a public news-group...
I'll be happy to try answering as I can...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.8.0 - DbaMgr ver 0.54.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Thanks Andrea and sorry for my personal comments.
See ya..!
"Andrea Montanari" <andrea.sqlDMO@.virgilio.it> escribi en el mensaje
news:2jb347FunmskU1@.uni-berlin.de...
> hi Richard,
> "Richard Villaln" <rv@.cantv.net> ha scritto nel messaggio
> news:ug7enr6UEHA.2484@.TK2MSFTNGP11.phx.gbl...
> yep, I work and live in Italy, Adriatic East Coast =;-D , but this is OT
> =;-D
> DbaMgr2k is free to use, but please post questions relative to it
privately,
> as this is a public news-group...
> I'll be happy to try answering as I can...
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.8.0 - DbaMgr ver 0.54.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>
Thanks for all...!
Regards
RV
hi Richard,
"Richard Villalon" <villalon@.cantv.net> ha scritto nel messaggio
news:OUZF4KbUEHA.1764@.TK2MSFTNGP10.phx.gbl...
> Hello. I need an administrator for pc with win98se. Where i will find it?
> Thanks for all...!
>
what kind of "administrator" do you need?
MSDE administrator, remote administrator, ... ?
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.8.0 - DbaMgr ver 0.54.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||hi andrea. Thanks for your comments. Where are you from? I'm from caracas,
venezuela.
Well, about my question is simple. The sql server 2000 has the enterpride
manager for create databases, field, store procedure, etc. but in msde 2000
i don't know the similar for pc with win98se.
Thanks for all and best regards.
rv@.cantv.net
"Andrea Montanari" <andrea.sqlDMO@.virgilio.it> escribi en el mensaje
news:2j5ppvFtncgoU1@.uni-berlin.de...[vbcol=seagreen]
> hi Richard,
> "Richard Villalon" <villalon@.cantv.net> ha scritto nel messaggio
> news:OUZF4KbUEHA.1764@.TK2MSFTNGP10.phx.gbl...
it?
> what kind of "administrator" do you need?
> MSDE administrator, remote administrator, ... ?
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.8.0 - DbaMgr ver 0.54.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>
|||hi Richard,
"Richard Villalon" <villalon@.cantv.net> ha scritto nel messaggio
news:ueBV9TnUEHA.3944@.tk2msftngp13.phx.gbl...
> hi andrea. Thanks for your comments. Where are you from? I'm from caracas,
> venezuela.
> Well, about my question is simple. The sql server 2000 has the enterpride
> manager for create databases, field, store procedure, etc. but in msde
2000
> i don't know the similar for pc with win98se.
> Thanks for all and best regards.
I'm italian =;-D
MSDE is not provided with client tools bu oSql.exe, the command line
utility..
you can find some visual tools at
http://www.microsoft.com/sql/msde/partners/default.asp and/or
http://www.aspfaq.com/show.asp?id=2442 or you can have a look at a free prj
of mine at the link following my wign., which provides a user interface
similar to Enterprise Manager...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.8.0 - DbaMgr ver 0.54.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Ok Andrea. Very nice. Do you work in Italy or another country?
I saw that you have an excellent tools for msde. It's the "DBAMGR2K"
It's free thsi tool?
Thanks for all.
PD. My personal e-mail is rv@.cantv.net
*************************************
"Andrea Montanari" <andrea.sqlDMO@.virgilio.it> escribi en el mensaje
news:2j84guFukheuU1@.uni-berlin.de...[vbcol=seagreen]
> hi Richard,
> "Richard Villalon" <villalon@.cantv.net> ha scritto nel messaggio
> news:ueBV9TnUEHA.3944@.tk2msftngp13.phx.gbl...
caracas,[vbcol=seagreen]
enterpride
> 2000
> I'm italian =;-D
> MSDE is not provided with client tools bu oSql.exe, the command line
> utility..
> you can find some visual tools at
> http://www.microsoft.com/sql/msde/partners/default.asp and/or
> http://www.aspfaq.com/show.asp?id=2442 or you can have a look at a free
prj
> of mine at the link following my wign., which provides a user interface
> similar to Enterprise Manager...
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.8.0 - DbaMgr ver 0.54.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>
|||hi Richard,
"Richard Villaln" <rv@.cantv.net> ha scritto nel messaggio
news:ug7enr6UEHA.2484@.TK2MSFTNGP11.phx.gbl...
> Ok Andrea. Very nice. Do you work in Italy or another country?
> I saw that you have an excellent tools for msde. It's the "DBAMGR2K"
> It's free thsi tool?
> Thanks for all.
yep, I work and live in Italy, Adriatic East Coast =;-D , but this is OT
=;-D
DbaMgr2k is free to use, but please post questions relative to it privately,
as this is a public news-group...
I'll be happy to try answering as I can...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.8.0 - DbaMgr ver 0.54.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Thanks Andrea and sorry for my personal comments.
See ya..!
"Andrea Montanari" <andrea.sqlDMO@.virgilio.it> escribi en el mensaje
news:2jb347FunmskU1@.uni-berlin.de...
> hi Richard,
> "Richard Villaln" <rv@.cantv.net> ha scritto nel messaggio
> news:ug7enr6UEHA.2484@.TK2MSFTNGP11.phx.gbl...
> yep, I work and live in Italy, Adriatic East Coast =;-D , but this is OT
> =;-D
> DbaMgr2k is free to use, but please post questions relative to it
privately,
> as this is a public news-group...
> I'll be happy to try answering as I can...
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.8.0 - DbaMgr ver 0.54.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>
Administrator does not have any privileges
I am logged on as a user with administrative privileges to my machine, yet when I go to the Report Manager, I have no tabs or Site Settings. How do I add the necessary privileges if I'm already the administrator?Are you using a custom security extension?
-Lukasz
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Patrick_McD" <Patrick_McD@.discussions.microsoft.com> wrote in message
news:56D7FB04-7279-4193-A809-E12D46827F6A@.microsoft.com...
> I am logged on as a user with administrative privileges to my machine, yet
when I go to the Report Manager, I have no tabs or Site Settings. How do I
add the necessary privileges if I'm already the administrator?|||No. I have everything set up very generically.
"Lukasz Pawlowski [MSFT]" wrote:
> Are you using a custom security extension?
> -Lukasz
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Patrick_McD" <Patrick_McD@.discussions.microsoft.com> wrote in message
> news:56D7FB04-7279-4193-A809-E12D46827F6A@.microsoft.com...
> > I am logged on as a user with administrative privileges to my machine, yet
> when I go to the Report Manager, I have no tabs or Site Settings. How do I
> add the necessary privileges if I'm already the administrator?
>
>|||Are you loggedin locally? Your user is a memeber of the local
administrators group?
-Lukasz
This posting is provided "AS IS" with no warranties, and confers no rights.
"Patrick_McD" <Patrick_McD@.discussions.microsoft.com> wrote in message
news:EC031FF7-BDCB-46B4-98E2-2E8787C030A6@.microsoft.com...
> No. I have everything set up very generically.
> "Lukasz Pawlowski [MSFT]" wrote:
> > Are you using a custom security extension?
> >
> > -Lukasz
> >
> > --
> > This posting is provided "AS IS" with no warranties, and confers no
rights.
> >
> >
> >
> > "Patrick_McD" <Patrick_McD@.discussions.microsoft.com> wrote in message
> > news:56D7FB04-7279-4193-A809-E12D46827F6A@.microsoft.com...
> > > I am logged on as a user with administrative privileges to my machine,
yet
> > when I go to the Report Manager, I have no tabs or Site Settings. How
do I
> > add the necessary privileges if I'm already the administrator?
> >
> >
> >|||Yes. I am logged on as a member of the Administrators group. Thanks!
"Lukasz Pawlowski [MSFT]" wrote:
> Are you loggedin locally? Your user is a memeber of the local
> administrators group?
> -Lukasz
>
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Patrick_McD" <Patrick_McD@.discussions.microsoft.com> wrote in message
> news:EC031FF7-BDCB-46B4-98E2-2E8787C030A6@.microsoft.com...
> > No. I have everything set up very generically.
> >
> > "Lukasz Pawlowski [MSFT]" wrote:
> >
> > > Are you using a custom security extension?
> > >
> > > -Lukasz
> > >
> > > --
> > > This posting is provided "AS IS" with no warranties, and confers no
> rights.
> > >
> > >
> > >
> > > "Patrick_McD" <Patrick_McD@.discussions.microsoft.com> wrote in message
> > > news:56D7FB04-7279-4193-A809-E12D46827F6A@.microsoft.com...
> > > > I am logged on as a user with administrative privileges to my machine,
> yet
> > > when I go to the Report Manager, I have no tabs or Site Settings. How
> do I
> > > add the necessary privileges if I'm already the administrator?
> > >
> > >
> > >
>
>|||Was this ever resolved? I am having the same problem.
>--Original Message--
>Yes. I am logged on as a member of the Administrators
group. Thanks!
>"Lukasz Pawlowski [MSFT]" wrote:
>> Are you loggedin locally? Your user is a memeber of
the local
>> administrators group?
>> -Lukasz
>>
>> --
>> This posting is provided "AS IS" with no warranties,
and confers no rights.
>>
>> "Patrick_McD" <Patrick_McD@.discussions.microsoft.com>
wrote in message
>> news:EC031FF7-BDCB-46B4-98E2-
2E8787C030A6@.microsoft.com...
>> > No. I have everything set up very generically.
>> >
>> > "Lukasz Pawlowski [MSFT]" wrote:
>> >
>> > > Are you using a custom security extension?
>> > >
>> > > -Lukasz
>> > >
>> > > --
>> > > This posting is provided "AS IS" with no
warranties, and confers no
>> rights.
>> > >
>> > >
>> > >
>> > > "Patrick_McD"
<Patrick_McD@.discussions.microsoft.com> wrote in message
>> > > news:56D7FB04-7279-4193-A809-
E12D46827F6A@.microsoft.com...
>> > > > I am logged on as a user with administrative
privileges to my machine,
>> yet
>> > > when I go to the Report Manager, I have no tabs or
Site Settings. How
>> do I
>> > > add the necessary privileges if I'm already the
administrator?
>> > >
>> > >
>> > >
>>
>.
>|||Are the /reportserver and /reports virtual directories configured to use
integrated security and *no* anonymous access?
--
Tudor Trufinescu
Dev Lead
Sql Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Patrick_McD" <PatrickMcD@.discussions.microsoft.com> wrote in message
news:3086AADF-A3F3-4698-88E1-5AE6B2689424@.microsoft.com...
> Yes. I am logged on as a member of the Administrators group. Thanks!
> "Lukasz Pawlowski [MSFT]" wrote:
> > Are you loggedin locally? Your user is a memeber of the local
> > administrators group?
> >
> > -Lukasz
> >
> >
> > --
> > This posting is provided "AS IS" with no warranties, and confers no
rights.
> >
> >
> >
> > "Patrick_McD" <Patrick_McD@.discussions.microsoft.com> wrote in message
> > news:EC031FF7-BDCB-46B4-98E2-2E8787C030A6@.microsoft.com...
> > > No. I have everything set up very generically.
> > >
> > > "Lukasz Pawlowski [MSFT]" wrote:
> > >
> > > > Are you using a custom security extension?
> > > >
> > > > -Lukasz
> > > >
> > > > --
> > > > This posting is provided "AS IS" with no warranties, and confers no
> > rights.
> > > >
> > > >
> > > >
> > > > "Patrick_McD" <Patrick_McD@.discussions.microsoft.com> wrote in
message
> > > > news:56D7FB04-7279-4193-A809-E12D46827F6A@.microsoft.com...
> > > > > I am logged on as a user with administrative privileges to my
machine,
> > yet
> > > > when I go to the Report Manager, I have no tabs or Site Settings.
How
> > do I
> > > > add the necessary privileges if I'm already the administrator?
> > > >
> > > >
> > > >
> >
> >
> >|||Tudor;
There is another thread on this same issue. I wonder whether you know why
setting anonymous access would result in this behavior, and whether there is
a way to retain both the admin privileges for the local admin and anonymous
access.
Linchi
"Tudor Trufinescu (MSFT)" <tudortr@.ms.com> wrote in message
news:eyJlrcyeEHA.2848@.TK2MSFTNGP10.phx.gbl...
> Are the /reportserver and /reports virtual directories configured to use
> integrated security and *no* anonymous access?
> --
> Tudor Trufinescu
> Dev Lead
> Sql Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> "Patrick_McD" <PatrickMcD@.discussions.microsoft.com> wrote in message
> news:3086AADF-A3F3-4698-88E1-5AE6B2689424@.microsoft.com...
> > Yes. I am logged on as a member of the Administrators group. Thanks!
> >
> > "Lukasz Pawlowski [MSFT]" wrote:
> >
> > > Are you loggedin locally? Your user is a memeber of the local
> > > administrators group?
> > >
> > > -Lukasz
> > >
> > >
> > > --
> > > This posting is provided "AS IS" with no warranties, and confers no
> rights.
> > >
> > >
> > >
> > > "Patrick_McD" <Patrick_McD@.discussions.microsoft.com> wrote in message
> > > news:EC031FF7-BDCB-46B4-98E2-2E8787C030A6@.microsoft.com...
> > > > No. I have everything set up very generically.
> > > >
> > > > "Lukasz Pawlowski [MSFT]" wrote:
> > > >
> > > > > Are you using a custom security extension?
> > > > >
> > > > > -Lukasz
> > > > >
> > > > > --
> > > > > This posting is provided "AS IS" with no warranties, and confers
no
> > > rights.
> > > > >
> > > > >
> > > > >
> > > > > "Patrick_McD" <Patrick_McD@.discussions.microsoft.com> wrote in
> message
> > > > > news:56D7FB04-7279-4193-A809-E12D46827F6A@.microsoft.com...
> > > > > > I am logged on as a user with administrative privileges to my
> machine,
> > > yet
> > > > > when I go to the Report Manager, I have no tabs or Site Settings.
> How
> > > do I
> > > > > add the necessary privileges if I'm already the administrator?
> > > > >
> > > > >
> > > > >
> > >
> > >
> > >
>|||Yes, allowing anonymous access would result in this behavior.
Allowing anonymous access means all users will be seen as the same user, the
server won't even ask them to provide their authentication information.
You can't have both anonymous and non anonymous on the same virtual
directories. I presume you could create two virtual directories one allowing
anonymous access, the other not.
--
Tudor Trufinescu
Dev Lead
Sql Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Linchi Shea" <linchi_shea@.NOSPAM.ml.com> wrote in message
news:ebSCkhBfEHA.3520@.TK2MSFTNGP10.phx.gbl...
> Tudor;
> There is another thread on this same issue. I wonder whether you know why
> setting anonymous access would result in this behavior, and whether there
is
> a way to retain both the admin privileges for the local admin and
anonymous
> access.
> Linchi
> "Tudor Trufinescu (MSFT)" <tudortr@.ms.com> wrote in message
> news:eyJlrcyeEHA.2848@.TK2MSFTNGP10.phx.gbl...
> > Are the /reportserver and /reports virtual directories configured to use
> > integrated security and *no* anonymous access?
> >
> > --
> > Tudor Trufinescu
> > Dev Lead
> > Sql Server Reporting Services
> > This posting is provided "AS IS" with no warranties, and confers no
> rights.
> >
> > "Patrick_McD" <PatrickMcD@.discussions.microsoft.com> wrote in message
> > news:3086AADF-A3F3-4698-88E1-5AE6B2689424@.microsoft.com...
> > > Yes. I am logged on as a member of the Administrators group. Thanks!
> > >
> > > "Lukasz Pawlowski [MSFT]" wrote:
> > >
> > > > Are you loggedin locally? Your user is a memeber of the local
> > > > administrators group?
> > > >
> > > > -Lukasz
> > > >
> > > >
> > > > --
> > > > This posting is provided "AS IS" with no warranties, and confers no
> > rights.
> > > >
> > > >
> > > >
> > > > "Patrick_McD" <Patrick_McD@.discussions.microsoft.com> wrote in
message
> > > > news:EC031FF7-BDCB-46B4-98E2-2E8787C030A6@.microsoft.com...
> > > > > No. I have everything set up very generically.
> > > > >
> > > > > "Lukasz Pawlowski [MSFT]" wrote:
> > > > >
> > > > > > Are you using a custom security extension?
> > > > > >
> > > > > > -Lukasz
> > > > > >
> > > > > > --
> > > > > > This posting is provided "AS IS" with no warranties, and confers
> no
> > > > rights.
> > > > > >
> > > > > >
> > > > > >
> > > > > > "Patrick_McD" <Patrick_McD@.discussions.microsoft.com> wrote in
> > message
> > > > > > news:56D7FB04-7279-4193-A809-E12D46827F6A@.microsoft.com...
> > > > > > > I am logged on as a user with administrative privileges to my
> > machine,
> > > > yet
> > > > > > when I go to the Report Manager, I have no tabs or Site
Settings.
> > How
> > > > do I
> > > > > > add the necessary privileges if I'm already the administrator?
> > > > > >
> > > > > >
> > > > > >
> > > >
> > > >
> > > >
> >
> >
>|||Tudor;
Could you please elaborate how you can create two virtual directories and
work the way you described, when it comes to Reporting Services?
Linchi
"Tudor Trufinescu (MSFT)" <tudortr@.ms.com> wrote in message
news:uXhU5KKfEHA.140@.TK2MSFTNGP12.phx.gbl...
> Yes, allowing anonymous access would result in this behavior.
> Allowing anonymous access means all users will be seen as the same user,
the
> server won't even ask them to provide their authentication information.
> You can't have both anonymous and non anonymous on the same virtual
> directories. I presume you could create two virtual directories one
allowing
> anonymous access, the other not.
> --
> Tudor Trufinescu
> Dev Lead
> Sql Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>
> "Linchi Shea" <linchi_shea@.NOSPAM.ml.com> wrote in message
> news:ebSCkhBfEHA.3520@.TK2MSFTNGP10.phx.gbl...
> > Tudor;
> >
> > There is another thread on this same issue. I wonder whether you know
why
> > setting anonymous access would result in this behavior, and whether
there
> is
> > a way to retain both the admin privileges for the local admin and
> anonymous
> > access.
> >
> > Linchi
> >
> > "Tudor Trufinescu (MSFT)" <tudortr@.ms.com> wrote in message
> > news:eyJlrcyeEHA.2848@.TK2MSFTNGP10.phx.gbl...
> > > Are the /reportserver and /reports virtual directories configured to
use
> > > integrated security and *no* anonymous access?
> > >
> > > --
> > > Tudor Trufinescu
> > > Dev Lead
> > > Sql Server Reporting Services
> > > This posting is provided "AS IS" with no warranties, and confers no
> > rights.
> > >
> > > "Patrick_McD" <PatrickMcD@.discussions.microsoft.com> wrote in message
> > > news:3086AADF-A3F3-4698-88E1-5AE6B2689424@.microsoft.com...
> > > > Yes. I am logged on as a member of the Administrators group.
Thanks!
> > > >
> > > > "Lukasz Pawlowski [MSFT]" wrote:
> > > >
> > > > > Are you loggedin locally? Your user is a memeber of the local
> > > > > administrators group?
> > > > >
> > > > > -Lukasz
> > > > >
> > > > >
> > > > > --
> > > > > This posting is provided "AS IS" with no warranties, and confers
no
> > > rights.
> > > > >
> > > > >
> > > > >
> > > > > "Patrick_McD" <Patrick_McD@.discussions.microsoft.com> wrote in
> message
> > > > > news:EC031FF7-BDCB-46B4-98E2-2E8787C030A6@.microsoft.com...
> > > > > > No. I have everything set up very generically.
> > > > > >
> > > > > > "Lukasz Pawlowski [MSFT]" wrote:
> > > > > >
> > > > > > > Are you using a custom security extension?
> > > > > > >
> > > > > > > -Lukasz
> > > > > > >
> > > > > > > --
> > > > > > > This posting is provided "AS IS" with no warranties, and
confers
> > no
> > > > > rights.
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > > > "Patrick_McD" <Patrick_McD@.discussions.microsoft.com> wrote in
> > > message
> > > > > > > news:56D7FB04-7279-4193-A809-E12D46827F6A@.microsoft.com...
> > > > > > > > I am logged on as a user with administrative privileges to
my
> > > machine,
> > > > > yet
> > > > > > > when I go to the Report Manager, I have no tabs or Site
> Settings.
> > > How
> > > > > do I
> > > > > > > add the necessary privileges if I'm already the administrator?
> > > > > > >
> > > > > > >
> > > > > > >
> > > > >
> > > > >
> > > > >
> > >
> > >
> >
> >
>
-Lukasz
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Patrick_McD" <Patrick_McD@.discussions.microsoft.com> wrote in message
news:56D7FB04-7279-4193-A809-E12D46827F6A@.microsoft.com...
> I am logged on as a user with administrative privileges to my machine, yet
when I go to the Report Manager, I have no tabs or Site Settings. How do I
add the necessary privileges if I'm already the administrator?|||No. I have everything set up very generically.
"Lukasz Pawlowski [MSFT]" wrote:
> Are you using a custom security extension?
> -Lukasz
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Patrick_McD" <Patrick_McD@.discussions.microsoft.com> wrote in message
> news:56D7FB04-7279-4193-A809-E12D46827F6A@.microsoft.com...
> > I am logged on as a user with administrative privileges to my machine, yet
> when I go to the Report Manager, I have no tabs or Site Settings. How do I
> add the necessary privileges if I'm already the administrator?
>
>|||Are you loggedin locally? Your user is a memeber of the local
administrators group?
-Lukasz
This posting is provided "AS IS" with no warranties, and confers no rights.
"Patrick_McD" <Patrick_McD@.discussions.microsoft.com> wrote in message
news:EC031FF7-BDCB-46B4-98E2-2E8787C030A6@.microsoft.com...
> No. I have everything set up very generically.
> "Lukasz Pawlowski [MSFT]" wrote:
> > Are you using a custom security extension?
> >
> > -Lukasz
> >
> > --
> > This posting is provided "AS IS" with no warranties, and confers no
rights.
> >
> >
> >
> > "Patrick_McD" <Patrick_McD@.discussions.microsoft.com> wrote in message
> > news:56D7FB04-7279-4193-A809-E12D46827F6A@.microsoft.com...
> > > I am logged on as a user with administrative privileges to my machine,
yet
> > when I go to the Report Manager, I have no tabs or Site Settings. How
do I
> > add the necessary privileges if I'm already the administrator?
> >
> >
> >|||Yes. I am logged on as a member of the Administrators group. Thanks!
"Lukasz Pawlowski [MSFT]" wrote:
> Are you loggedin locally? Your user is a memeber of the local
> administrators group?
> -Lukasz
>
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Patrick_McD" <Patrick_McD@.discussions.microsoft.com> wrote in message
> news:EC031FF7-BDCB-46B4-98E2-2E8787C030A6@.microsoft.com...
> > No. I have everything set up very generically.
> >
> > "Lukasz Pawlowski [MSFT]" wrote:
> >
> > > Are you using a custom security extension?
> > >
> > > -Lukasz
> > >
> > > --
> > > This posting is provided "AS IS" with no warranties, and confers no
> rights.
> > >
> > >
> > >
> > > "Patrick_McD" <Patrick_McD@.discussions.microsoft.com> wrote in message
> > > news:56D7FB04-7279-4193-A809-E12D46827F6A@.microsoft.com...
> > > > I am logged on as a user with administrative privileges to my machine,
> yet
> > > when I go to the Report Manager, I have no tabs or Site Settings. How
> do I
> > > add the necessary privileges if I'm already the administrator?
> > >
> > >
> > >
>
>|||Was this ever resolved? I am having the same problem.
>--Original Message--
>Yes. I am logged on as a member of the Administrators
group. Thanks!
>"Lukasz Pawlowski [MSFT]" wrote:
>> Are you loggedin locally? Your user is a memeber of
the local
>> administrators group?
>> -Lukasz
>>
>> --
>> This posting is provided "AS IS" with no warranties,
and confers no rights.
>>
>> "Patrick_McD" <Patrick_McD@.discussions.microsoft.com>
wrote in message
>> news:EC031FF7-BDCB-46B4-98E2-
2E8787C030A6@.microsoft.com...
>> > No. I have everything set up very generically.
>> >
>> > "Lukasz Pawlowski [MSFT]" wrote:
>> >
>> > > Are you using a custom security extension?
>> > >
>> > > -Lukasz
>> > >
>> > > --
>> > > This posting is provided "AS IS" with no
warranties, and confers no
>> rights.
>> > >
>> > >
>> > >
>> > > "Patrick_McD"
<Patrick_McD@.discussions.microsoft.com> wrote in message
>> > > news:56D7FB04-7279-4193-A809-
E12D46827F6A@.microsoft.com...
>> > > > I am logged on as a user with administrative
privileges to my machine,
>> yet
>> > > when I go to the Report Manager, I have no tabs or
Site Settings. How
>> do I
>> > > add the necessary privileges if I'm already the
administrator?
>> > >
>> > >
>> > >
>>
>.
>|||Are the /reportserver and /reports virtual directories configured to use
integrated security and *no* anonymous access?
--
Tudor Trufinescu
Dev Lead
Sql Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Patrick_McD" <PatrickMcD@.discussions.microsoft.com> wrote in message
news:3086AADF-A3F3-4698-88E1-5AE6B2689424@.microsoft.com...
> Yes. I am logged on as a member of the Administrators group. Thanks!
> "Lukasz Pawlowski [MSFT]" wrote:
> > Are you loggedin locally? Your user is a memeber of the local
> > administrators group?
> >
> > -Lukasz
> >
> >
> > --
> > This posting is provided "AS IS" with no warranties, and confers no
rights.
> >
> >
> >
> > "Patrick_McD" <Patrick_McD@.discussions.microsoft.com> wrote in message
> > news:EC031FF7-BDCB-46B4-98E2-2E8787C030A6@.microsoft.com...
> > > No. I have everything set up very generically.
> > >
> > > "Lukasz Pawlowski [MSFT]" wrote:
> > >
> > > > Are you using a custom security extension?
> > > >
> > > > -Lukasz
> > > >
> > > > --
> > > > This posting is provided "AS IS" with no warranties, and confers no
> > rights.
> > > >
> > > >
> > > >
> > > > "Patrick_McD" <Patrick_McD@.discussions.microsoft.com> wrote in
message
> > > > news:56D7FB04-7279-4193-A809-E12D46827F6A@.microsoft.com...
> > > > > I am logged on as a user with administrative privileges to my
machine,
> > yet
> > > > when I go to the Report Manager, I have no tabs or Site Settings.
How
> > do I
> > > > add the necessary privileges if I'm already the administrator?
> > > >
> > > >
> > > >
> >
> >
> >|||Tudor;
There is another thread on this same issue. I wonder whether you know why
setting anonymous access would result in this behavior, and whether there is
a way to retain both the admin privileges for the local admin and anonymous
access.
Linchi
"Tudor Trufinescu (MSFT)" <tudortr@.ms.com> wrote in message
news:eyJlrcyeEHA.2848@.TK2MSFTNGP10.phx.gbl...
> Are the /reportserver and /reports virtual directories configured to use
> integrated security and *no* anonymous access?
> --
> Tudor Trufinescu
> Dev Lead
> Sql Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> "Patrick_McD" <PatrickMcD@.discussions.microsoft.com> wrote in message
> news:3086AADF-A3F3-4698-88E1-5AE6B2689424@.microsoft.com...
> > Yes. I am logged on as a member of the Administrators group. Thanks!
> >
> > "Lukasz Pawlowski [MSFT]" wrote:
> >
> > > Are you loggedin locally? Your user is a memeber of the local
> > > administrators group?
> > >
> > > -Lukasz
> > >
> > >
> > > --
> > > This posting is provided "AS IS" with no warranties, and confers no
> rights.
> > >
> > >
> > >
> > > "Patrick_McD" <Patrick_McD@.discussions.microsoft.com> wrote in message
> > > news:EC031FF7-BDCB-46B4-98E2-2E8787C030A6@.microsoft.com...
> > > > No. I have everything set up very generically.
> > > >
> > > > "Lukasz Pawlowski [MSFT]" wrote:
> > > >
> > > > > Are you using a custom security extension?
> > > > >
> > > > > -Lukasz
> > > > >
> > > > > --
> > > > > This posting is provided "AS IS" with no warranties, and confers
no
> > > rights.
> > > > >
> > > > >
> > > > >
> > > > > "Patrick_McD" <Patrick_McD@.discussions.microsoft.com> wrote in
> message
> > > > > news:56D7FB04-7279-4193-A809-E12D46827F6A@.microsoft.com...
> > > > > > I am logged on as a user with administrative privileges to my
> machine,
> > > yet
> > > > > when I go to the Report Manager, I have no tabs or Site Settings.
> How
> > > do I
> > > > > add the necessary privileges if I'm already the administrator?
> > > > >
> > > > >
> > > > >
> > >
> > >
> > >
>|||Yes, allowing anonymous access would result in this behavior.
Allowing anonymous access means all users will be seen as the same user, the
server won't even ask them to provide their authentication information.
You can't have both anonymous and non anonymous on the same virtual
directories. I presume you could create two virtual directories one allowing
anonymous access, the other not.
--
Tudor Trufinescu
Dev Lead
Sql Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Linchi Shea" <linchi_shea@.NOSPAM.ml.com> wrote in message
news:ebSCkhBfEHA.3520@.TK2MSFTNGP10.phx.gbl...
> Tudor;
> There is another thread on this same issue. I wonder whether you know why
> setting anonymous access would result in this behavior, and whether there
is
> a way to retain both the admin privileges for the local admin and
anonymous
> access.
> Linchi
> "Tudor Trufinescu (MSFT)" <tudortr@.ms.com> wrote in message
> news:eyJlrcyeEHA.2848@.TK2MSFTNGP10.phx.gbl...
> > Are the /reportserver and /reports virtual directories configured to use
> > integrated security and *no* anonymous access?
> >
> > --
> > Tudor Trufinescu
> > Dev Lead
> > Sql Server Reporting Services
> > This posting is provided "AS IS" with no warranties, and confers no
> rights.
> >
> > "Patrick_McD" <PatrickMcD@.discussions.microsoft.com> wrote in message
> > news:3086AADF-A3F3-4698-88E1-5AE6B2689424@.microsoft.com...
> > > Yes. I am logged on as a member of the Administrators group. Thanks!
> > >
> > > "Lukasz Pawlowski [MSFT]" wrote:
> > >
> > > > Are you loggedin locally? Your user is a memeber of the local
> > > > administrators group?
> > > >
> > > > -Lukasz
> > > >
> > > >
> > > > --
> > > > This posting is provided "AS IS" with no warranties, and confers no
> > rights.
> > > >
> > > >
> > > >
> > > > "Patrick_McD" <Patrick_McD@.discussions.microsoft.com> wrote in
message
> > > > news:EC031FF7-BDCB-46B4-98E2-2E8787C030A6@.microsoft.com...
> > > > > No. I have everything set up very generically.
> > > > >
> > > > > "Lukasz Pawlowski [MSFT]" wrote:
> > > > >
> > > > > > Are you using a custom security extension?
> > > > > >
> > > > > > -Lukasz
> > > > > >
> > > > > > --
> > > > > > This posting is provided "AS IS" with no warranties, and confers
> no
> > > > rights.
> > > > > >
> > > > > >
> > > > > >
> > > > > > "Patrick_McD" <Patrick_McD@.discussions.microsoft.com> wrote in
> > message
> > > > > > news:56D7FB04-7279-4193-A809-E12D46827F6A@.microsoft.com...
> > > > > > > I am logged on as a user with administrative privileges to my
> > machine,
> > > > yet
> > > > > > when I go to the Report Manager, I have no tabs or Site
Settings.
> > How
> > > > do I
> > > > > > add the necessary privileges if I'm already the administrator?
> > > > > >
> > > > > >
> > > > > >
> > > >
> > > >
> > > >
> >
> >
>|||Tudor;
Could you please elaborate how you can create two virtual directories and
work the way you described, when it comes to Reporting Services?
Linchi
"Tudor Trufinescu (MSFT)" <tudortr@.ms.com> wrote in message
news:uXhU5KKfEHA.140@.TK2MSFTNGP12.phx.gbl...
> Yes, allowing anonymous access would result in this behavior.
> Allowing anonymous access means all users will be seen as the same user,
the
> server won't even ask them to provide their authentication information.
> You can't have both anonymous and non anonymous on the same virtual
> directories. I presume you could create two virtual directories one
allowing
> anonymous access, the other not.
> --
> Tudor Trufinescu
> Dev Lead
> Sql Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>
> "Linchi Shea" <linchi_shea@.NOSPAM.ml.com> wrote in message
> news:ebSCkhBfEHA.3520@.TK2MSFTNGP10.phx.gbl...
> > Tudor;
> >
> > There is another thread on this same issue. I wonder whether you know
why
> > setting anonymous access would result in this behavior, and whether
there
> is
> > a way to retain both the admin privileges for the local admin and
> anonymous
> > access.
> >
> > Linchi
> >
> > "Tudor Trufinescu (MSFT)" <tudortr@.ms.com> wrote in message
> > news:eyJlrcyeEHA.2848@.TK2MSFTNGP10.phx.gbl...
> > > Are the /reportserver and /reports virtual directories configured to
use
> > > integrated security and *no* anonymous access?
> > >
> > > --
> > > Tudor Trufinescu
> > > Dev Lead
> > > Sql Server Reporting Services
> > > This posting is provided "AS IS" with no warranties, and confers no
> > rights.
> > >
> > > "Patrick_McD" <PatrickMcD@.discussions.microsoft.com> wrote in message
> > > news:3086AADF-A3F3-4698-88E1-5AE6B2689424@.microsoft.com...
> > > > Yes. I am logged on as a member of the Administrators group.
Thanks!
> > > >
> > > > "Lukasz Pawlowski [MSFT]" wrote:
> > > >
> > > > > Are you loggedin locally? Your user is a memeber of the local
> > > > > administrators group?
> > > > >
> > > > > -Lukasz
> > > > >
> > > > >
> > > > > --
> > > > > This posting is provided "AS IS" with no warranties, and confers
no
> > > rights.
> > > > >
> > > > >
> > > > >
> > > > > "Patrick_McD" <Patrick_McD@.discussions.microsoft.com> wrote in
> message
> > > > > news:EC031FF7-BDCB-46B4-98E2-2E8787C030A6@.microsoft.com...
> > > > > > No. I have everything set up very generically.
> > > > > >
> > > > > > "Lukasz Pawlowski [MSFT]" wrote:
> > > > > >
> > > > > > > Are you using a custom security extension?
> > > > > > >
> > > > > > > -Lukasz
> > > > > > >
> > > > > > > --
> > > > > > > This posting is provided "AS IS" with no warranties, and
confers
> > no
> > > > > rights.
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > > > "Patrick_McD" <Patrick_McD@.discussions.microsoft.com> wrote in
> > > message
> > > > > > > news:56D7FB04-7279-4193-A809-E12D46827F6A@.microsoft.com...
> > > > > > > > I am logged on as a user with administrative privileges to
my
> > > machine,
> > > > > yet
> > > > > > > when I go to the Report Manager, I have no tabs or Site
> Settings.
> > > How
> > > > > do I
> > > > > > > add the necessary privileges if I'm already the administrator?
> > > > > > >
> > > > > > >
> > > > > > >
> > > > >
> > > > >
> > > > >
> > >
> > >
> >
> >
>
Administrator cannot see administration toolbar, buttons and shortcuts on Report Manager
Hy everybody.
I have recently installed from scratch RS 2003 on a WIN2003 SRV and got that the problem that the administrator cannot access or even see the regular administration toolbar and links at the Report Manager, such as Site Configuration, Upload New File, the common 'Contents | Properties ' tab, among other stuff. The only options available are 'Home', 'My Subscriptions' and 'Help', in the right superior link bar. I find this behaviour very strange, since the RS comes right out of the box configured with full access to administrator, but right now I CAN'T do any administration task on the RS Server.
Another strange behaviours I've found:
- The few links that appear redirect to the internal ip address of the server.
- When you call the '/ReportServer/ReportingService.asmx' it returns an XML document, not the usual browsing interface.
There's some information about the server configuration I think it might help:
- IIS is running more than one website, and the RS server is not installed on the Default WebSite, wich is stopped.
- SharePoint Services is running in the server, but not in the DefaultWebSite.
- The security settings of the virtual directory of the Report Manager are configured to use Windows Authentication and are NOT configured to use anonymous authentication.
- The server is published to the Internet.
There's some stuff that I tried and for now didn't worked:
- Create the virtual directories in other websites.
- Switch the attributes of the 'impersonate' attribute in Web.config file between true and false.
- Enable anonymous authentication and use the administrator account to impersonate.
- The steps described in the help article 'Troubleshooting a Side-by-Side Installation of Reporting Services and Windows SharePoint Services'
- Reinstalling the RS product.
I really hope you guys can help me with this.
Thanks in advance.
JCAlthough you said your Report Manager is configured for WIndows auth, is your Report Server directory the same way? Anonymous is not on either one?
Administrator access Lost
Hello,
I seem to have lost the ability to access the site settings as well as any security tabs and modify the properties under the directories etc...somehow i have lost administrator access , how do i get this back? I am still local administrator of the server reporting services is running on...only thing i can think off that could of done this is i installed Sharepoint onto the same machine and created a sharepoint site...are there things i can check in IIS or RS or etc to get this admin access back
thanks
A couple points come to mind. If you haven't already, run the Report Services Configuration application and try resetting (or creating new) the Report Server Virtual Directory. The configuration tool should remove any conflicts with SharePoint. In addition, in IIS make sure that anonymous access is disabled for the ReportServer virtual directory (on the Direcory Security tab of the ReportServer Properties dialog). It may be that, even though you are logged on as user, it is the IUSR_ account that is authenticating to the report server instead of the administrator.
This is assuming you're not yet attempting to integrate Reporting Services with SharePoint.
Administrator access Lost
Hello,
I seem to have lost the ability to access the site settings as well as any security tabs and modify the properties under the directories etc...somehow i have lost administrator access , how do i get this back? I am still local administrator of the server reporting services is running on...only thing i can think off that could of done this is i installed Sharepoint onto the same machine and created a sharepoint site...are there things i can check in IIS or RS or etc to get this admin access back
thanks
A couple points come to mind. If you haven't already, run the Report Services Configuration application and try resetting (or creating new) the Report Server Virtual Directory. The configuration tool should remove any conflicts with SharePoint. In addition, in IIS make sure that anonymous access is disabled for the ReportServer virtual directory (on the Direcory Security tab of the ReportServer Properties dialog). It may be that, even though you are logged on as user, it is the IUSR_ account that is authenticating to the report server instead of the administrator.
This is assuming you're not yet attempting to integrate Reporting Services with SharePoint.
Subscribe to:
Posts (Atom)