Enterprise monitoring tool

Hi experts!
Could you please recomment good third party tools for Enterprise SQL Server/
Oracle performance monitoring. Currently we have 60+ database servers
different shape and size spread all over our WAN unwatched.
Thanks in advance.
Eli,
Options include (among others):
Microsoft Operations Manager 2000 or 2005
NETIQ AppManager Suite
Quest Spotlight for SQL Server
Idera Diagnostic Manager
HTH
Jerry
"Eli Milkova" <EliMilkova@.discussions.microsoft.com> wrote in message
news:1CAD2EF7-A756-4886-BD16-040465A624BB@.microsoft.com...
> Hi experts!
> Could you please recomment good third party tools for Enterprise SQL
> Server/
> Oracle performance monitoring. Currently we have 60+ database servers
> different shape and size spread all over our WAN unwatched.
> Thanks in advance.
>
|||thanks a lot i will check them all
"Jerry Spivey" wrote:

> Eli,
> Options include (among others):
> Microsoft Operations Manager 2000 or 2005
> NETIQ AppManager Suite
> Quest Spotlight for SQL Server
> Idera Diagnostic Manager
> HTH
> Jerry
> "Eli Milkova" <EliMilkova@.discussions.microsoft.com> wrote in message
> news:1CAD2EF7-A756-4886-BD16-040465A624BB@.microsoft.com...
>
>

Enterprise monitoring tool

Hi experts!
Could you please recomment good third party tools for Enterprise SQL Server/
Oracle performance monitoring. Currently we have 60+ database servers
different shape and size spread all over our WAN unwatched.
Thanks in advance.Eli,
Options include (among others):
Microsoft Operations Manager 2000 or 2005
NETIQ AppManager Suite
Quest Spotlight for SQL Server
Idera Diagnostic Manager
HTH
Jerry
"Eli Milkova" <EliMilkova@.discussions.microsoft.com> wrote in message
news:1CAD2EF7-A756-4886-BD16-040465A624BB@.microsoft.com...
> Hi experts!
> Could you please recomment good third party tools for Enterprise SQL
> Server/
> Oracle performance monitoring. Currently we have 60+ database servers
> different shape and size spread all over our WAN unwatched.
> Thanks in advance.
>|||thanks a lot i will check them all
"Jerry Spivey" wrote:
> Eli,
> Options include (among others):
> Microsoft Operations Manager 2000 or 2005
> NETIQ AppManager Suite
> Quest Spotlight for SQL Server
> Idera Diagnostic Manager
> HTH
> Jerry
> "Eli Milkova" <EliMilkova@.discussions.microsoft.com> wrote in message
> news:1CAD2EF7-A756-4886-BD16-040465A624BB@.microsoft.com...
> > Hi experts!
> >
> > Could you please recomment good third party tools for Enterprise SQL
> > Server/
> > Oracle performance monitoring. Currently we have 60+ database servers
> > different shape and size spread all over our WAN unwatched.
> >
> > Thanks in advance.
> >
> >
>
>

Enterprise monitoring tool

Hi experts!
Could you please recomment good third party tools for Enterprise SQL Server/
Oracle performance monitoring. Currently we have 60+ database servers
different shape and size spread all over our WAN unwatched.
Thanks in advance.Eli,
Options include (among others):
Microsoft Operations Manager 2000 or 2005
NETIQ AppManager Suite
Quest Spotlight for SQL Server
Idera Diagnostic Manager
HTH
Jerry
"Eli Milkova" <EliMilkova@.discussions.microsoft.com> wrote in message
news:1CAD2EF7-A756-4886-BD16-040465A624BB@.microsoft.com...
> Hi experts!
> Could you please recomment good third party tools for Enterprise SQL
> Server/
> Oracle performance monitoring. Currently we have 60+ database servers
> different shape and size spread all over our WAN unwatched.
> Thanks in advance.
>|||thanks a lot i will check them all
"Jerry Spivey" wrote:

> Eli,
> Options include (among others):
> Microsoft Operations Manager 2000 or 2005
> NETIQ AppManager Suite
> Quest Spotlight for SQL Server
> Idera Diagnostic Manager
> HTH
> Jerry
> "Eli Milkova" <EliMilkova@.discussions.microsoft.com> wrote in message
> news:1CAD2EF7-A756-4886-BD16-040465A624BB@.microsoft.com...
>
>

Enterprise Mgr as an end-user data manipulation tool

As DBAs we typically restrict the use of Enterprise Manager and other DBA
Admin type utilities from end-users. Even with a user's SQL server
permissions being appropriately defined and restricted, to limit their
abilities within Enterprise Manager, I typically do not allow end users to
use Enterprise Manager, for the same reason that an Exchange administrator
doesn't allow end-users to run Exchange Administrator to manage their
mailbox. It's an administration utility and is not intended as a data
manipulation interface.
I am faced with a unique situation where a 'power user' insists on wanting
to use SQL Enterprise Manager to access a particular database to which he has
read/write permissions to the production data, as he wants to browse and
modify data ad-hoc within the Enterprise Manager GUI (by right-clicking on a
table and selecting the 'Open, Return All Rows', etc. Due to political
reasons beyond my control, it appears that I will be 'told' to let him use
Enterprise Manager by upper management, so that the user can manage the data
via SQL EM.
Outside of the technical reasons why an end-user should not be using SQL
Enterprise Manager as the GUI to manage data within a database, even with
proper security, does anyone know of official audit guidelines that would
raise a 'red flag' if an audit determined that an end-user(s) were managing
data via SQL Enterprise Manager?
Thanks
D
Apart from read/write to certain tables in the DB, what other rights does
this user have within the server and database? The fact that an end-user
can (knowingly or not), if their rights aren't severely restricted, drop a
table, access and modify security/login info, modify/overwrite/delete
backups, add/remove indexes, etc. would make me wary.
Maybe you can suggest to them that this guy use Access as the front end, and
Link the tables he needs into Access so he can edit to his heart's content
without getting anywhere near EM?
"DBADave" <DBADave@.discussions.microsoft.com> wrote in message
news:D8E94FA5-3F83-4B63-9EFA-1A65F14C1857@.microsoft.com...
> As DBAs we typically restrict the use of Enterprise Manager and other DBA
> Admin type utilities from end-users. Even with a user's SQL server
> permissions being appropriately defined and restricted, to limit their
> abilities within Enterprise Manager, I typically do not allow end users to
> use Enterprise Manager, for the same reason that an Exchange administrator
> doesn't allow end-users to run Exchange Administrator to manage their
> mailbox. It's an administration utility and is not intended as a data
> manipulation interface.
> I am faced with a unique situation where a 'power user' insists on wanting
> to use SQL Enterprise Manager to access a particular database to which he
> has
> read/write permissions to the production data, as he wants to browse and
> modify data ad-hoc within the Enterprise Manager GUI (by right-clicking on
> a
> table and selecting the 'Open, Return All Rows', etc. Due to political
> reasons beyond my control, it appears that I will be 'told' to let him use
> Enterprise Manager by upper management, so that the user can manage the
> data
> via SQL EM.
> Outside of the technical reasons why an end-user should not be using SQL
> Enterprise Manager as the GUI to manage data within a database, even with
> proper security, does anyone know of official audit guidelines that would
> raise a 'red flag' if an audit determined that an end-user(s) were
> managing
> data via SQL Enterprise Manager?
> Thanks
> D

Enterprise Mgr as an end-user data manipulation tool

As DBAs we typically restrict the use of Enterprise Manager and other DBA
Admin type utilities from end-users. Even with a user's SQL server
permissions being appropriately defined and restricted, to limit their
abilities within Enterprise Manager, I typically do not allow end users to
use Enterprise Manager, for the same reason that an Exchange administrator
doesn't allow end-users to run Exchange Administrator to manage their
mailbox. It's an administration utility and is not intended as a data
manipulation interface.
I am faced with a unique situation where a 'power user' insists on wanting
to use SQL Enterprise Manager to access a particular database to which he ha
s
read/write permissions to the production data, as he wants to browse and
modify data ad-hoc within the Enterprise Manager GUI (by right-clicking on a
table and selecting the 'Open, Return All Rows', etc. Due to political
reasons beyond my control, it appears that I will be 'told' to let him use
Enterprise Manager by upper management, so that the user can manage the data
via SQL EM.
Outside of the technical reasons why an end-user should not be using SQL
Enterprise Manager as the GUI to manage data within a database, even with
proper security, does anyone know of official audit guidelines that would
raise a 'red flag' if an audit determined that an end-user(s) were managing
data via SQL Enterprise Manager?
Thanks
DApart from read/write to certain tables in the DB, what other rights does
this user have within the server and database? The fact that an end-user
can (knowingly or not), if their rights aren't severely restricted, drop a
table, access and modify security/login info, modify/overwrite/delete
backups, add/remove indexes, etc. would make me wary.
Maybe you can suggest to them that this guy use Access as the front end, and
Link the tables he needs into Access so he can edit to his heart's content
without getting anywhere near EM?
"DBADave" <DBADave@.discussions.microsoft.com> wrote in message
news:D8E94FA5-3F83-4B63-9EFA-1A65F14C1857@.microsoft.com...
> As DBAs we typically restrict the use of Enterprise Manager and other DBA
> Admin type utilities from end-users. Even with a user's SQL server
> permissions being appropriately defined and restricted, to limit their
> abilities within Enterprise Manager, I typically do not allow end users to
> use Enterprise Manager, for the same reason that an Exchange administrator
> doesn't allow end-users to run Exchange Administrator to manage their
> mailbox. It's an administration utility and is not intended as a data
> manipulation interface.
> I am faced with a unique situation where a 'power user' insists on wanting
> to use SQL Enterprise Manager to access a particular database to which he
> has
> read/write permissions to the production data, as he wants to browse and
> modify data ad-hoc within the Enterprise Manager GUI (by right-clicking on
> a
> table and selecting the 'Open, Return All Rows', etc. Due to political
> reasons beyond my control, it appears that I will be 'told' to let him use
> Enterprise Manager by upper management, so that the user can manage the
> data
> via SQL EM.
> Outside of the technical reasons why an end-user should not be using SQL
> Enterprise Manager as the GUI to manage data within a database, even with
> proper security, does anyone know of official audit guidelines that would
> raise a 'red flag' if an audit determined that an end-user(s) were
> managing
> data via SQL Enterprise Manager?
> Thanks
> D

Enterprise Manager with developer kit

Is anyone aware if we are allowed to purchase the
Enterprise Manager that comes with the developer kit and
then use it as a graphical management tool for the MSDE
version of SQL?
Microsoft list that MSDE does not come with a graphical
management tool, I don't want to break licenses.
http://www.microsoft.com/sql/evaluat...iew/default.as
p
Indeed is it a graphical management tool?
You are not allow to purchase by itself. You have to purchase any of the other versions of SQL Server (Personal edition is $50 I think) in order to get the Enterprise Manager.
But then you are not licensed to redistribute it.
"rob" wrote:

> Is anyone aware if we are allowed to purchase the
> Enterprise Manager that comes with the developer kit and
> then use it as a graphical management tool for the MSDE
> version of SQL?
> Microsoft list that MSDE does not come with a graphical
> management tool, I don't want to break licenses.
> http://www.microsoft.com/sql/evaluat...iew/default.as
> p
> Indeed is it a graphical management tool?
>
|||Did you mean Developer Edition? That is $49, but more importantly than
redistribution rights, you are not allowed to buy this version and manage
production databases with it. It is for development and testing only.
I don't think you can buy Personal Edition except that it comes with retail
versions.
http://www.aspfaq.com/
(Reverse address to reply.)

> You are not allow to purchase by itself. You have to purchase any of the
> other versions of SQL Server (Personal edition is $50 I think) in order to
> get the Enterprise Manager.
> But then you are not licensed to redistribute it.
|||http://www.aspfaq.com/2442
http://www.aspfaq.com/
(Reverse address to reply.)
"rob" <another@.psotago.org.nz> wrote in message
news:233f701c45e3a$9805fd60$a401280a@.phx.gbl...
> Is anyone aware if we are allowed to purchase the
> Enterprise Manager that comes with the developer kit and
> then use it as a graphical management tool for the MSDE
> version of SQL?
> Microsoft list that MSDE does not come with a graphical
> management tool, I don't want to break licenses.
> http://www.microsoft.com/sql/evaluat...iew/default.as
> p
> Indeed is it a graphical management tool?
|||Yes I did
"Aaron [SQL Server MVP]" wrote:

> Did you mean Developer Edition? That is $49, but more importantly than
> redistribution rights, you are not allowed to buy this version and manage
> production databases with it. It is for development and testing only.
> I don't think you can buy Personal Edition except that it comes with retail
> versions.
> --
> http://www.aspfaq.com/
> (Reverse address to reply.)
>
>
>
>
|||OK, it's a gotcha, looks like we would need the Standard
edition, unless we can get by without the graphical
interface. Thanks

>--Original Message--
>Did you mean Developer Edition? That is $49, but more
importantly than
>redistribution rights, you are not allowed to buy this
version and manage
>production databases with it. It is for development and
testing only.
>I don't think you can buy Personal Edition except that it
comes with retail[vbcol=seagreen]
>versions.
>--
>http://www.aspfaq.com/
>(Reverse address to reply.)
>
>
purchase any of the[vbcol=seagreen]
think) in order to
>
>.
>

Enterprise Manager Query Tool

We have noticed some random failures to write data to some
of our databases. In the
research that I have done I think it is being caused by
users querying the tables
with Enterprise Manager's Query Tool. I am seeing table
level locks that are granted
against the table in Mode IS. I am interpreting this to
mean that there is an 'Shared
Intent' Lock on that table. Which to my understanding
means that anyone can continue
to read but that I have also declared an intent to update
the table and therefore
requests for exclusive locks for update, insert or delete
operations would block
until my intent lock is removed. If the block occurs for
too long the blocked call
would then timeout. I believe that Enterprise Manager is
creating this type of lock
because the user interface allows the data that is
displayed to be updated and if the
Intent lock was not declared then data syncronization
issues would occur.
For now I have instructed people who access the tables to
use Query Analyzer since it
will only lock when queries that require the lock are
executed and will not hold the
lock while the user browses the results.
My questions are as follows:
1) Is my interpretation of the IS Mode Table lock correct?
2) Is there a way to prevent Enterprise Manager from
locking the table in this way
(i.e. make the query results read-only)?
3) If the user that is performing the query only has
dbreader privledges then why is
the Intent lock being created?
Thanxshttp://vyaskn.tripod.com/sql_enterp...er_or_t-sql.htm
"" <anonymous@.discussions.microsoft.com> wrote in message
news:535b01c4003c$1ec4aca0$a301280a@.phx.gbl...
> We have noticed some random failures to write data to some
> of our databases. In the
> research that I have done I think it is being caused by
> users querying the tables
> with Enterprise Manager's Query Tool. I am seeing table
> level locks that are granted
> against the table in Mode IS. I am interpreting this to
> mean that there is an 'Shared
> Intent' Lock on that table. Which to my understanding
> means that anyone can continue
> to read but that I have also declared an intent to update
> the table and therefore
> requests for exclusive locks for update, insert or delete
> operations would block
> until my intent lock is removed. If the block occurs for
> too long the blocked call
> would then timeout. I believe that Enterprise Manager is
> creating this type of lock
> because the user interface allows the data that is
> displayed to be updated and if the
> Intent lock was not declared then data syncronization
> issues would occur.
> For now I have instructed people who access the tables to
> use Query Analyzer since it
> will only lock when queries that require the lock are
> executed and will not hold the
> lock while the user browses the results.
> My questions are as follows:
> 1) Is my interpretation of the IS Mode Table lock correct?
> 2) Is there a way to prevent Enterprise Manager from
> locking the table in this way
> (i.e. make the query results read-only)?
> 3) If the user that is performing the query only has
> dbreader privledges then why is
> the Intent lock being created?
> Thanxs

Enterprise Manager Query Tool

We have noticed some random failures to write data to some
of our databases. In the
research that I have done I think it is being caused by
users querying the tables
with Enterprise Manager's Query Tool. I am seeing table
level locks that are granted
against the table in Mode IS. I am interpreting this to
mean that there is an 'Shared
Intent' Lock on that table. Which to my understanding
means that anyone can continue
to read but that I have also declared an intent to update
the table and therefore
requests for exclusive locks for update, insert or delete
operations would block
until my intent lock is removed. If the block occurs for
too long the blocked call
would then timeout. I believe that Enterprise Manager is
creating this type of lock
because the user interface allows the data that is
displayed to be updated and if the
Intent lock was not declared then data syncronization
issues would occur.
For now I have instructed people who access the tables to
use Query Analyzer since it
will only lock when queries that require the lock are
executed and will not hold the
lock while the user browses the results.
My questions are as follows:
1) Is my interpretation of the IS Mode Table lock correct?
2) Is there a way to prevent Enterprise Manager from
locking the table in this way
(i.e. make the query results read-only)?
3) If the user that is performing the query only has
dbreader privledges then why is
the Intent lock being created?
Thanxshttp://vyaskn.tripod.com/sql_enterprise_manager_or_t-sql.htm
":)" <anonymous@.discussions.microsoft.com> wrote in message
news:535b01c4003c$1ec4aca0$a301280a@.phx.gbl...
> We have noticed some random failures to write data to some
> of our databases. In the
> research that I have done I think it is being caused by
> users querying the tables
> with Enterprise Manager's Query Tool. I am seeing table
> level locks that are granted
> against the table in Mode IS. I am interpreting this to
> mean that there is an 'Shared
> Intent' Lock on that table. Which to my understanding
> means that anyone can continue
> to read but that I have also declared an intent to update
> the table and therefore
> requests for exclusive locks for update, insert or delete
> operations would block
> until my intent lock is removed. If the block occurs for
> too long the blocked call
> would then timeout. I believe that Enterprise Manager is
> creating this type of lock
> because the user interface allows the data that is
> displayed to be updated and if the
> Intent lock was not declared then data syncronization
> issues would occur.
> For now I have instructed people who access the tables to
> use Query Analyzer since it
> will only lock when queries that require the lock are
> executed and will not hold the
> lock while the user browses the results.
> My questions are as follows:
> 1) Is my interpretation of the IS Mode Table lock correct?
> 2) Is there a way to prevent Enterprise Manager from
> locking the table in this way
> (i.e. make the query results read-only)?
> 3) If the user that is performing the query only has
> dbreader privledges then why is
> the Intent lock being created?
> Thanxs

enterprise manager in sql 2005?

Hi,
Our tech support person installed SQL 2005. But I was not to find
enterprise manager. What tool in SQL 2005 does what enterprise manager does
in the early versions of SQL server? I read the SQL 2005 overview
http://www.microsoft.com/technet/prodtechnol/sql/2005/sqlydba.mspx. It
appears to me SQL Object Explorer should be the right tool. But I was not
able to find it either on the SQL 2005.
Thanks in advance for any help,
BingYou are looking for Management Studio. If it is not in the SQL Server 2005
program folder on the start menu, then perhaps your tech support person did
not choose to install the workstation components. You might want to update
the installation using add/remove programs. Make sure you pay close
attention to each screen during the wizard.
--
Aaron Bertrand
SQL Server MVP
http://www.sqlblog.com/
http://www.aspfaq.com/5006
"bing" <bing@.discussions.microsoft.com> wrote in message
news:B2093CF1-FE12-473D-98D1-8E66BC4B6D37@.microsoft.com...
> Hi,
> Our tech support person installed SQL 2005. But I was not to find
> enterprise manager. What tool in SQL 2005 does what enterprise manager
> does
> in the early versions of SQL server? I read the SQL 2005 overview
> http://www.microsoft.com/technet/prodtechnol/sql/2005/sqlydba.mspx. It
> appears to me SQL Object Explorer should be the right tool. But I was not
> able to find it either on the SQL 2005.
> Thanks in advance for any help,
> Bing|||Thanks much for the fast response. I checked the start menu and found this.
STart
-> All Programs
-> Microsoft SQL Server 2005
-> Configuration Tools
-> Notification Services Command Prompt
SQL Server Configuration Manager
SQL Server Error and Usage Reporting
SQL server Surface Area Configuration
In control panel, Servers has:
SQL Server (MSSQLSERVER)
SQL Server Active Directory Helper
SQL Server Agent (MSSQLSERVER)
SQL Server Analysis Servics (MSSQLSERVER)
SQL Server Browser
SQL Server FullText Search (MSSQLSERVER)
SQL Server VSS Writer
Can that confirm management studio is not installed?
Bing
"Aaron Bertrand [SQL Server MVP]" wrote:
> You are looking for Management Studio. If it is not in the SQL Server 2005
> program folder on the start menu, then perhaps your tech support person did
> not choose to install the workstation components. You might want to update
> the installation using add/remove programs. Make sure you pay close
> attention to each screen during the wizard.
> --
> Aaron Bertrand
> SQL Server MVP
> http://www.sqlblog.com/
> http://www.aspfaq.com/5006
>
>
> "bing" <bing@.discussions.microsoft.com> wrote in message
> news:B2093CF1-FE12-473D-98D1-8E66BC4B6D37@.microsoft.com...
> > Hi,
> >
> > Our tech support person installed SQL 2005. But I was not to find
> > enterprise manager. What tool in SQL 2005 does what enterprise manager
> > does
> > in the early versions of SQL server? I read the SQL 2005 overview
> > http://www.microsoft.com/technet/prodtechnol/sql/2005/sqlydba.mspx. It
> > appears to me SQL Object Explorer should be the right tool. But I was not
> > able to find it either on the SQL 2005.
> >
> > Thanks in advance for any help,
> >
> > Bing
>
>|||> Can that confirm management studio is not installed?
Looks like it, yes.
I have filed an issue on Connect because I see this situation a lot.
http://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=272806|||Excellent! Really appreciated your attention on this issue. I'm sure that
would help a lot upgraders like myself understand SQL 2005 better.
Bing
"Aaron Bertrand [SQL Server MVP]" wrote:
> > Can that confirm management studio is not installed?
> Looks like it, yes.
> I have filed an issue on Connect because I see this situation a lot.
> http://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=272806
>
>|||I'm now trying to modify the SQL 2005 installation to get Management Studio
installed. But I don't see Management Studio as an option in the lists of
Components to Install. Here are all the options I can see:
SQL Server Database Services
Analysis Services
Reporting Services (grayed out)
Notification Services
Integration Services
Workstation components, Book Online and development tools
Clicking the Advanced button shows:
Database Services
Analysis Services
Notification Services
Integration Services
Client Components
Documentation, Samples, and Sample Databases
This is the version of SQL 2005 we are running.
Microsoft SQL Server 2005 9.00.3042.00
OS Version : Microsoft Windows Server 2003 family, Standard Edition
Service Pack 2 (Build 3790)
Any ideas?
Thanks,
Bing
"Aaron Bertrand [SQL Server MVP]" wrote:
> > Can that confirm management studio is not installed?
> Looks like it, yes.
> I have filed an issue on Connect because I see this situation a lot.
> http://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=272806
>
>|||I think you need to Check "Workstation components, ..." and then click
Advanced. If you don't have the top level checked, its subcomponents
shouldn't be available.
--
Aaron Bertrand
SQL Server MVP
http://www.sqlblog.com/
http://www.aspfaq.com/5006
"bing" <bing@.discussions.microsoft.com> wrote in message
news:FCEB799E-C4E5-4634-B63A-FABFAC64ACB1@.microsoft.com...
> I'm now trying to modify the SQL 2005 installation to get Management
> Studio
> installed. But I don't see Management Studio as an option in the lists of
> Components to Install. Here are all the options I can see:
> SQL Server Database Services
> Analysis Services
> Reporting Services (grayed out)
> Notification Services
> Integration Services
> Workstation components, Book Online and development tools
> Clicking the Advanced button shows:
> Database Services
> Analysis Services
> Notification Services
> Integration Services
> Client Components
> Documentation, Samples, and Sample Databases
> This is the version of SQL 2005 we are running.
> Microsoft SQL Server 2005 9.00.3042.00
> OS Version : Microsoft Windows Server 2003 family, Standard Edition
> Service Pack 2 (Build 3790)
> Any ideas?
> Thanks,
> Bing
> "Aaron Bertrand [SQL Server MVP]" wrote:
>> > Can that confirm management studio is not installed?
>> Looks like it, yes.
>> I have filed an issue on Connect because I see this situation a lot.
>> http://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=272806
>>|||Aha, yes, you are right. Now I got the management studio installed
successfully. If you hadn't mentioned 'Workstation components', I would have
known the management studio is part of that component. Thanks much again for
the help!
Bing
"Aaron Bertrand [SQL Server MVP]" wrote:
> I think you need to Check "Workstation components, ..." and then click
> Advanced. If you don't have the top level checked, its subcomponents
> shouldn't be available.
> --
> Aaron Bertrand
> SQL Server MVP
> http://www.sqlblog.com/
> http://www.aspfaq.com/5006
>
>
> "bing" <bing@.discussions.microsoft.com> wrote in message
> news:FCEB799E-C4E5-4634-B63A-FABFAC64ACB1@.microsoft.com...
> > I'm now trying to modify the SQL 2005 installation to get Management
> > Studio
> > installed. But I don't see Management Studio as an option in the lists of
> > Components to Install. Here are all the options I can see:
> >
> > SQL Server Database Services
> > Analysis Services
> > Reporting Services (grayed out)
> > Notification Services
> > Integration Services
> > Workstation components, Book Online and development tools
> >
> > Clicking the Advanced button shows:
> >
> > Database Services
> > Analysis Services
> > Notification Services
> > Integration Services
> > Client Components
> > Documentation, Samples, and Sample Databases
> >
> > This is the version of SQL 2005 we are running.
> >
> > Microsoft SQL Server 2005 9.00.3042.00
> > OS Version : Microsoft Windows Server 2003 family, Standard Edition
> > Service Pack 2 (Build 3790)
> >
> > Any ideas?
> >
> > Thanks,
> >
> > Bing
> >
> > "Aaron Bertrand [SQL Server MVP]" wrote:
> >
> >> > Can that confirm management studio is not installed?
> >>
> >> Looks like it, yes.
> >>
> >> I have filed an issue on Connect because I see this situation a lot.
> >> http://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=272806
> >>
> >>
> >>
>
>

enterprise manager in sql 2005?

Hi,
Our tech support person installed SQL 2005. But I was not to find
enterprise manager. What tool in SQL 2005 does what enterprise manager does
in the early versions of SQL server? I read the SQL 2005 overview
http://www.microsoft.com/technet/prodtechnol/sql/2005/sqlydba.mspx. It
appears to me SQL Object Explorer should be the right tool. But I was not
able to find it either on the SQL 2005.
Thanks in advance for any help,
Bing
You are looking for Management Studio. If it is not in the SQL Server 2005
program folder on the start menu, then perhaps your tech support person did
not choose to install the workstation components. You might want to update
the installation using add/remove programs. Make sure you pay close
attention to each screen during the wizard.
Aaron Bertrand
SQL Server MVP
http://www.sqlblog.com/
http://www.aspfaq.com/5006
"bing" <bing@.discussions.microsoft.com> wrote in message
news:B2093CF1-FE12-473D-98D1-8E66BC4B6D37@.microsoft.com...
> Hi,
> Our tech support person installed SQL 2005. But I was not to find
> enterprise manager. What tool in SQL 2005 does what enterprise manager
> does
> in the early versions of SQL server? I read the SQL 2005 overview
> http://www.microsoft.com/technet/prodtechnol/sql/2005/sqlydba.mspx. It
> appears to me SQL Object Explorer should be the right tool. But I was not
> able to find it either on the SQL 2005.
> Thanks in advance for any help,
> Bing
|||Thanks much for the fast response. I checked the start menu and found this.
STart
-> All Programs
-> Microsoft SQL Server 2005
-> Configuration Tools
-> Notification Services Command Prompt
SQL Server Configuration Manager
SQL Server Error and Usage Reporting
SQL server Surface Area Configuration
In control panel, Servers has:
SQL Server (MSSQLSERVER)
SQL Server Active Directory Helper
SQL Server Agent (MSSQLSERVER)
SQL Server Analysis Servics (MSSQLSERVER)
SQL Server Browser
SQL Server FullText Search (MSSQLSERVER)
SQL Server VSS Writer
Can that confirm management studio is not installed?
Bing
"Aaron Bertrand [SQL Server MVP]" wrote:

> You are looking for Management Studio. If it is not in the SQL Server 2005
> program folder on the start menu, then perhaps your tech support person did
> not choose to install the workstation components. You might want to update
> the installation using add/remove programs. Make sure you pay close
> attention to each screen during the wizard.
> --
> Aaron Bertrand
> SQL Server MVP
> http://www.sqlblog.com/
> http://www.aspfaq.com/5006
>
>
> "bing" <bing@.discussions.microsoft.com> wrote in message
> news:B2093CF1-FE12-473D-98D1-8E66BC4B6D37@.microsoft.com...
>
>
|||> Can that confirm management studio is not installed?
Looks like it, yes.
I have filed an issue on Connect because I see this situation a lot.
http://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=272806
|||Excellent! Really appreciated your attention on this issue. I'm sure that
would help a lot upgraders like myself understand SQL 2005 better.
Bing
"Aaron Bertrand [SQL Server MVP]" wrote:

> Looks like it, yes.
> I have filed an issue on Connect because I see this situation a lot.
> http://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=272806
>
>
|||I'm now trying to modify the SQL 2005 installation to get Management Studio
installed. But I don't see Management Studio as an option in the lists of
Components to Install. Here are all the options I can see:
SQL Server Database Services
Analysis Services
Reporting Services (grayed out)
Notification Services
Integration Services
Workstation components, Book Online and development tools
Clicking the Advanced button shows:
Database Services
Analysis Services
Notification Services
Integration Services
Client Components
Documentation, Samples, and Sample Databases
This is the version of SQL 2005 we are running.
Microsoft SQL Server 2005 9.00.3042.00
OS Version : Microsoft Windows Server 2003 family, Standard Edition
Service Pack 2 (Build 3790)
Any ideas?
Thanks,
Bing
"Aaron Bertrand [SQL Server MVP]" wrote:

> Looks like it, yes.
> I have filed an issue on Connect because I see this situation a lot.
> http://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=272806
>
>
|||I think you need to Check "Workstation components, ..." and then click
Advanced. If you don't have the top level checked, its subcomponents
shouldn't be available.
Aaron Bertrand
SQL Server MVP
http://www.sqlblog.com/
http://www.aspfaq.com/5006
"bing" <bing@.discussions.microsoft.com> wrote in message
news:FCEB799E-C4E5-4634-B63A-FABFAC64ACB1@.microsoft.com...[vbcol=seagreen]
> I'm now trying to modify the SQL 2005 installation to get Management
> Studio
> installed. But I don't see Management Studio as an option in the lists of
> Components to Install. Here are all the options I can see:
> SQL Server Database Services
> Analysis Services
> Reporting Services (grayed out)
> Notification Services
> Integration Services
> Workstation components, Book Online and development tools
> Clicking the Advanced button shows:
> Database Services
> Analysis Services
> Notification Services
> Integration Services
> Client Components
> Documentation, Samples, and Sample Databases
> This is the version of SQL 2005 we are running.
> Microsoft SQL Server 2005 9.00.3042.00
> OS Version : Microsoft Windows Server 2003 family, Standard Edition
> Service Pack 2 (Build 3790)
> Any ideas?
> Thanks,
> Bing
> "Aaron Bertrand [SQL Server MVP]" wrote:
|||Aha, yes, you are right. Now I got the management studio installed
successfully. If you hadn't mentioned 'Workstation components', I would have
known the management studio is part of that component. Thanks much again for
the help!
Bing
"Aaron Bertrand [SQL Server MVP]" wrote:

> I think you need to Check "Workstation components, ..." and then click
> Advanced. If you don't have the top level checked, its subcomponents
> shouldn't be available.
> --
> Aaron Bertrand
> SQL Server MVP
> http://www.sqlblog.com/
> http://www.aspfaq.com/5006
>
>
> "bing" <bing@.discussions.microsoft.com> wrote in message
> news:FCEB799E-C4E5-4634-B63A-FABFAC64ACB1@.microsoft.com...
>
>

enterprise manager in sql 2005?

Hi,
Our tech support person installed SQL 2005. But I was not to find
enterprise manager. What tool in SQL 2005 does what enterprise manager does
in the early versions of SQL server? I read the SQL 2005 overview
http://www.microsoft.com/technet/pr...5/sqlydba.mspx. It
appears to me SQL Object Explorer should be the right tool. But I was not
able to find it either on the SQL 2005.
Thanks in advance for any help,
BingYou are looking for Management Studio. If it is not in the SQL Server 2005
program folder on the start menu, then perhaps your tech support person did
not choose to install the workstation components. You might want to update
the installation using add/remove programs. Make sure you pay close
attention to each screen during the wizard.
Aaron Bertrand
SQL Server MVP
http://www.sqlblog.com/
http://www.aspfaq.com/5006
"bing" <bing@.discussions.microsoft.com> wrote in message
news:B2093CF1-FE12-473D-98D1-8E66BC4B6D37@.microsoft.com...
> Hi,
> Our tech support person installed SQL 2005. But I was not to find
> enterprise manager. What tool in SQL 2005 does what enterprise manager
> does
> in the early versions of SQL server? I read the SQL 2005 overview
> http://www.microsoft.com/technet/pr...5/sqlydba.mspx. It
> appears to me SQL Object Explorer should be the right tool. But I was not
> able to find it either on the SQL 2005.
> Thanks in advance for any help,
> Bing|||Thanks much for the fast response. I checked the start menu and found this.
STart
-> All Programs
-> Microsoft SQL Server 2005
-> Configuration Tools
-> Notification Services Command Prompt
SQL Server Configuration Manager
SQL Server Error and Usage Reporting
SQL server Surface Area Configuration
In control panel, Servers has:
SQL Server (MSSQLSERVER)
SQL Server Active Directory Helper
SQL Server Agent (MSSQLSERVER)
SQL Server Analysis Servics (MSSQLSERVER)
SQL Server Browser
SQL Server FullText Search (MSSQLSERVER)
SQL Server VSS Writer
Can that confirm management studio is not installed?
Bing
"Aaron Bertrand [SQL Server MVP]" wrote:

> You are looking for Management Studio. If it is not in the SQL Server 200
5
> program folder on the start menu, then perhaps your tech support person di
d
> not choose to install the workstation components. You might want to updat
e
> the installation using add/remove programs. Make sure you pay close
> attention to each screen during the wizard.
> --
> Aaron Bertrand
> SQL Server MVP
> http://www.sqlblog.com/
> http://www.aspfaq.com/5006
>
>
> "bing" <bing@.discussions.microsoft.com> wrote in message
> news:B2093CF1-FE12-473D-98D1-8E66BC4B6D37@.microsoft.com...
>
>|||> Can that confirm management studio is not installed?
Looks like it, yes.
I have filed an issue on Connect because I see this situation a lot.
http://connect.microsoft.com/SQLSer...=27280
6|||Excellent! Really appreciated your attention on this issue. I'm sure that
would help a lot upgraders like myself understand SQL 2005 better.
Bing
"Aaron Bertrand [SQL Server MVP]" wrote:

> Looks like it, yes.
> I have filed an issue on Connect because I see this situation a lot.
> http://connect.microsoft.com/SQLSer...=272
806
>
>|||I'm now trying to modify the SQL 2005 installation to get Management Studio
installed. But I don't see Management Studio as an option in the lists of
Components to Install. Here are all the options I can see:
SQL Server Database Services
Analysis Services
Reporting Services (grayed out)
Notification Services
Integration Services
Workstation components, Book Online and development tools
Clicking the Advanced button shows:
Database Services
Analysis Services
Notification Services
Integration Services
Client Components
Documentation, Samples, and Sample Databases
This is the version of SQL 2005 we are running.
Microsoft SQL Server 2005 9.00.3042.00
OS Version : Microsoft Windows Server 2003 family, Standard Edition
Service Pack 2 (Build 3790)
Any ideas?
Thanks,
Bing
"Aaron Bertrand [SQL Server MVP]" wrote:

> Looks like it, yes.
> I have filed an issue on Connect because I see this situation a lot.
> http://connect.microsoft.com/SQLSer...=272
806
>
>|||I think you need to Check "Workstation components, ..." and then click
Advanced. If you don't have the top level checked, its subcomponents
shouldn't be available.
Aaron Bertrand
SQL Server MVP
http://www.sqlblog.com/
http://www.aspfaq.com/5006
"bing" <bing@.discussions.microsoft.com> wrote in message
news:FCEB799E-C4E5-4634-B63A-FABFAC64ACB1@.microsoft.com...[vbcol=seagreen]
> I'm now trying to modify the SQL 2005 installation to get Management
> Studio
> installed. But I don't see Management Studio as an option in the lists of
> Components to Install. Here are all the options I can see:
> SQL Server Database Services
> Analysis Services
> Reporting Services (grayed out)
> Notification Services
> Integration Services
> Workstation components, Book Online and development tools
> Clicking the Advanced button shows:
> Database Services
> Analysis Services
> Notification Services
> Integration Services
> Client Components
> Documentation, Samples, and Sample Databases
> This is the version of SQL 2005 we are running.
> Microsoft SQL Server 2005 9.00.3042.00
> OS Version : Microsoft Windows Server 2003 family, Standard Edition
> Service Pack 2 (Build 3790)
> Any ideas?
> Thanks,
> Bing
> "Aaron Bertrand [SQL Server MVP]" wrote:
>|||Aha, yes, you are right. Now I got the management studio installed
successfully. If you hadn't mentioned 'Workstation components', I would hav
e
known the management studio is part of that component. Thanks much again fo
r
the help!
Bing
"Aaron Bertrand [SQL Server MVP]" wrote:

> I think you need to Check "Workstation components, ..." and then click
> Advanced. If you don't have the top level checked, its subcomponents
> shouldn't be available.
> --
> Aaron Bertrand
> SQL Server MVP
> http://www.sqlblog.com/
> http://www.aspfaq.com/5006
>
>
> "bing" <bing@.discussions.microsoft.com> wrote in message
> news:FCEB799E-C4E5-4634-B63A-FABFAC64ACB1@.microsoft.com...
>
>

Enterprise Manager Hangs

Everytime I try to use the Enterprise Manager tool to
access my SQL 2000 (sp3) server on a W2K3 Enterprise
machine it hangs (stops responding). The tool loads
correctly but when I dig down the tree to get at the
instance on the local machine it stops responding when
trying to Establish the Connection and checking Windows
Security.
The server is loading and running, but I can't make any
new databases.
I can stop and start the server.
I have tried reinstalling. I have checked that the
services are running correctly.Hi, please verify permissions on folder Microsoft SQL Server.
Verify if you services account have permissions on foder MSSQL
Verify the event viewer to view if you have more messages about mssqlserver
The problem is generally by permissions
I hope help you
Carlos Augusto
Bogot=E1 Colombia
>--Original Message--
>Everytime I try to use the Enterprise Manager tool to >access my SQL 2000 (sp3) server on a W2K3 Enterprise >machine it hangs (stops responding). The tool loads >correctly but when I dig down the tree to get at the >instance on the local machine it stops responding when >trying to Establish the Connection and checking Windows >Security.
>The server is loading and running, but I can't make any >new databases.
>I can stop and start the server.
>I have tried reinstalling. I have checked that the >services are running correctly.
>.
>

Enterprise Manager

Hi:
I'm not sure if its called Enterprise manager in SQL 2005 but I'm trying to
find a tool that would allow me to see all of the databases so I can set the
"autogrowth" value in the ONEPOINT database which is used by Microsoft
Operations Manager. I've looked all over after installing SQL 2005 and
cannot find it or any tool that would allow me to make changes to the
databases configuration.
Do I need to install another component?
Thanks,
Charles
The replacement for Enterprise Manager is called "SQL Server Management Studio". You find it in the
SQL Server program group, provided you installed it in the first place. If you didn't, you can run
setup and install it.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Charles" <Charles@.discussions.microsoft.com> wrote in message
news:9A2FDED2-74C7-498E-808F-52946E127576@.microsoft.com...
> Hi:
> I'm not sure if its called Enterprise manager in SQL 2005 but I'm trying to
> find a tool that would allow me to see all of the databases so I can set the
> "autogrowth" value in the ONEPOINT database which is used by Microsoft
> Operations Manager. I've looked all over after installing SQL 2005 and
> cannot find it or any tool that would allow me to make changes to the
> databases configuration.
> Do I need to install another component?
> Thanks,
> Charles
|||Thaks Tibor but I am still having problems getting the Enterprise Manager to
install. I get to the Componets to Install screen and
1) check the "Workstation components, Books Online and development tools" box.
2) Click Advanced.
3) Then I expand "Client Components. Then I make sure all under client
components are selected to make sure I got it.
4) Then I click next next
5) Eventually it gets to a dialogue box called "Microsoft SQL Server 2005
Setup" and it says: There was an unexpected failure during the setup wizard.
You may review the setup logs and/or click the help button for more
information.
It never installs it. Is there a way just to copy over the program? I've
tried this several times and just can't get it to install.
Thanks,
Charles
"Tibor Karaszi" wrote:

> The replacement for Enterprise Manager is called "SQL Server Management Studio". You find it in the
> SQL Server program group, provided you installed it in the first place. If you didn't, you can run
> setup and install it.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://sqlblog.com/blogs/tibor_karaszi
>
> "Charles" <Charles@.discussions.microsoft.com> wrote in message
> news:9A2FDED2-74C7-498E-808F-52946E127576@.microsoft.com...
>
|||> Thaks Tibor but I am still having problems getting the Enterprise Manager to
> install.
Just to be clear: The replacement tool in 2005 is called 'SQL Server Management Studio".

> 5) Eventually it gets to a dialogue box called "Microsoft SQL Server 2005
> Setup" and it says: There was an unexpected failure during the setup wizard.
I guess you have to troubleshoot this error. Perhaps try the .setup group? Or open a case with MS...
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Charles" <Charles@.discussions.microsoft.com> wrote in message
news:1B7125FD-513B-4D2C-8C0D-A661FCD86C62@.microsoft.com...[vbcol=seagreen]
> Thaks Tibor but I am still having problems getting the Enterprise Manager to
> install. I get to the Componets to Install screen and
> 1) check the "Workstation components, Books Online and development tools" box.
> 2) Click Advanced.
> 3) Then I expand "Client Components. Then I make sure all under client
> components are selected to make sure I got it.
> 4) Then I click next next
> 5) Eventually it gets to a dialogue box called "Microsoft SQL Server 2005
> Setup" and it says: There was an unexpected failure during the setup wizard.
> You may review the setup logs and/or click the help button for more
> information.
> It never installs it. Is there a way just to copy over the program? I've
> tried this several times and just can't get it to install.
> Thanks,
> Charles
>
> "Tibor Karaszi" wrote:
|||> 5) Eventually it gets to a dialogue box called "Microsoft SQL Server 2005
> Setup" and it says: There was an unexpected failure during the setup
> wizard.
> You may review the setup logs and/or click the help button for more
> information.
We can't help if we can't see the error that was in the setup log. Even
then, unless you have come across a common issue, it is likely an issue for
MS to help resolve.

> It never installs it. Is there a way just to copy over the program?
No, you can't just copy the .exe, there are plenty of dependencies and
requirements for it to run correctly.
A