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 Snap-In Issue

I have been running SQL Server 2000, client tools only.
i installed SQL Server Express (and associated .NET
framework upgrade) to take a look.
I then uninstalled sql server express and went back to
version 1.1 of .NET framework.
My query analyzer works fine, however when i try to load
Enterprise Manager, it says:
Snap-in failed to initialize.
Name: Microsoft SQL Enterprise Manager
CLSID:{00100100-1816-11D0-8EF5-00AA0062C58F}
I have looked through the knowledge base articles and
have not found one specific to my situation.
I have uninstalled/reinstalled sql server 2000 (and
therefore, MDAC as well) and I am running into the same
issues.
Any help is appreciated.
Did you try regsvr32 c:\...\...\sqldmo.dll
http://www.aspfaq.com/
(Reverse address to reply.)
"RR" <anonymous@.discussions.microsoft.com> wrote in message
news:bf9001c489db$bebd80f0$a501280a@.phx.gbl...
> I have been running SQL Server 2000, client tools only.
> i installed SQL Server Express (and associated .NET
> framework upgrade) to take a look.
> I then uninstalled sql server express and went back to
> version 1.1 of .NET framework.
> My query analyzer works fine, however when i try to load
> Enterprise Manager, it says:
> Snap-in failed to initialize.
> Name: Microsoft SQL Enterprise Manager
> CLSID:{00100100-1816-11D0-8EF5-00AA0062C58F}
> I have looked through the knowledge base articles and
> have not found one specific to my situation.
> I have uninstalled/reinstalled sql server 2000 (and
> therefore, MDAC as well) and I am running into the same
> issues.
> Any help is appreciated.
|||I just tried it with the same result.

>--Original Message--
>Did you try regsvr32 c:\...\...\sqldmo.dll
>--
>http://www.aspfaq.com/
>(Reverse address to reply.)
>
>
>"RR" <anonymous@.discussions.microsoft.com> wrote in
message[vbcol=seagreen]
>news:bf9001c489db$bebd80f0$a501280a@.phx.gbl...
load
>
>.
>
|||> I just tried it with the same result.
Did you find the actual sqldmo.dll file that corresponds to the SQL Server
2000 install? Or did you run exactly what I posted? Did you get a dialog
that told you the registration was successful?
http://www.aspfaq.com/
(Reverse address to reply.)
|||Yes - the file came from the sql 2000 install and
received a message that is was successful.

>--Original Message--
>Did you find the actual sqldmo.dll file that corresponds
to the SQL Server
>2000 install? Or did you run exactly what I posted?
Did you get a dialog
>that told you the registration was successful?
>--
>http://www.aspfaq.com/
>(Reverse address to reply.)
>
>.
>
|||You might want to post your issue and any relevant log files from the
install/uninstall to the SQL Server 2005 newsgroups. I'm sure they are
dealing with a lot of similar issues.
For information on access to those groups:
http://communities.microsoft.com/new...elcomePage.htm
http://www.aspfaq.com/
(Reverse address to reply.)
<anonymous@.discussions.microsoft.com> wrote in message
news:508f01c489e1$cf7b55b0$a301280a@.phx.gbl...[vbcol=seagreen]
> Yes - the file came from the sql 2000 install and
> received a message that is was successful.
>
> to the SQL Server
> Did you get a dialog
sql

Enterprise Mgr Snap-In Issue

I have been running SQL Server 2000, client tools only.
i installed SQL Server Express (and associated .NET
framework upgrade) to take a look.
I then uninstalled sql server express and went back to
version 1.1 of .NET framework.
My query analyzer works fine, however when i try to load
Enterprise Manager, it says:
Snap-in failed to initialize.
Name: Microsoft SQL Enterprise Manager
CLSID:{00100100-1816-11D0-8EF5-00AA0062C58F}
I have looked through the knowledge base articles and
have not found one specific to my situation.
I have uninstalled/reinstalled sql server 2000 (and
therefore, MDAC as well) and I am running into the same
issues.
Any help is appreciated.Did you try regsvr32 c:\...\...\sqldmo.dll
http://www.aspfaq.com/
(Reverse address to reply.)
"RR" <anonymous@.discussions.microsoft.com> wrote in message
news:bf9001c489db$bebd80f0$a501280a@.phx.gbl...
> I have been running SQL Server 2000, client tools only.
> i installed SQL Server Express (and associated .NET
> framework upgrade) to take a look.
> I then uninstalled sql server express and went back to
> version 1.1 of .NET framework.
> My query analyzer works fine, however when i try to load
> Enterprise Manager, it says:
> Snap-in failed to initialize.
> Name: Microsoft SQL Enterprise Manager
> CLSID:{00100100-1816-11D0-8EF5-00AA0062C58F}
> I have looked through the knowledge base articles and
> have not found one specific to my situation.
> I have uninstalled/reinstalled sql server 2000 (and
> therefore, MDAC as well) and I am running into the same
> issues.
> Any help is appreciated.|||I just tried it with the same result.

>--Original Message--
>Did you try regsvr32 c:\...\...\sqldmo.dll
>--
>http://www.aspfaq.com/
>(Reverse address to reply.)
>
>
>"RR" <anonymous@.discussions.microsoft.com> wrote in
message
>news:bf9001c489db$bebd80f0$a501280a@.phx.gbl...
load[vbcol=seagreen]
>
>.
>|||> I just tried it with the same result.
Did you find the actual sqldmo.dll file that corresponds to the SQL Server
2000 install? Or did you run exactly what I posted? Did you get a dialog
that told you the registration was successful?
http://www.aspfaq.com/
(Reverse address to reply.)|||Yes - the file came from the sql 2000 install and
received a message that is was successful.

>--Original Message--
>Did you find the actual sqldmo.dll file that corresponds
to the SQL Server
>2000 install? Or did you run exactly what I posted?
Did you get a dialog
>that told you the registration was successful?
>--
>http://www.aspfaq.com/
>(Reverse address to reply.)
>
>.
>|||You might want to post your issue and any relevant log files from the
install/uninstall to the SQL Server 2005 newsgroups. I'm sure they are
dealing with a lot of similar issues.
For information on access to those groups:
url]
[url]http://www.aspfaq.com/" target="_blank">http://communities.microsoft.com/ne...www.aspfaq.com/
(Reverse address to reply.)
<anonymous@.discussions.microsoft.com> wrote in message
news:508f01c489e1$cf7b55b0$a301280a@.phx.gbl...[vbcol=seagreen]
> Yes - the file came from the sql 2000 install and
> received a message that is was successful.
>
> to the SQL Server
> Did you get a dialog

Enterprise Mgr Snap-In Issue

I have been running SQL Server 2000, client tools only.
i installed SQL Server Express (and associated .NET
framework upgrade) to take a look.
I then uninstalled sql server express and went back to
version 1.1 of .NET framework.
My query analyzer works fine, however when i try to load
Enterprise Manager, it says:
Snap-in failed to initialize.
Name: Microsoft SQL Enterprise Manager
CLSID:{00100100-1816-11D0-8EF5-00AA0062C58F}
I have looked through the knowledge base articles and
have not found one specific to my situation.
I have uninstalled/reinstalled sql server 2000 (and
therefore, MDAC as well) and I am running into the same
issues.
Any help is appreciated.Did you try regsvr32 c:\...\...\sqldmo.dll
--
http://www.aspfaq.com/
(Reverse address to reply.)
"RR" <anonymous@.discussions.microsoft.com> wrote in message
news:bf9001c489db$bebd80f0$a501280a@.phx.gbl...
> I have been running SQL Server 2000, client tools only.
> i installed SQL Server Express (and associated .NET
> framework upgrade) to take a look.
> I then uninstalled sql server express and went back to
> version 1.1 of .NET framework.
> My query analyzer works fine, however when i try to load
> Enterprise Manager, it says:
> Snap-in failed to initialize.
> Name: Microsoft SQL Enterprise Manager
> CLSID:{00100100-1816-11D0-8EF5-00AA0062C58F}
> I have looked through the knowledge base articles and
> have not found one specific to my situation.
> I have uninstalled/reinstalled sql server 2000 (and
> therefore, MDAC as well) and I am running into the same
> issues.
> Any help is appreciated.|||I just tried it with the same result.
>--Original Message--
>Did you try regsvr32 c:\...\...\sqldmo.dll
>--
>http://www.aspfaq.com/
>(Reverse address to reply.)
>
>
>"RR" <anonymous@.discussions.microsoft.com> wrote in
message
>news:bf9001c489db$bebd80f0$a501280a@.phx.gbl...
>> I have been running SQL Server 2000, client tools only.
>> i installed SQL Server Express (and associated .NET
>> framework upgrade) to take a look.
>> I then uninstalled sql server express and went back to
>> version 1.1 of .NET framework.
>> My query analyzer works fine, however when i try to
load
>> Enterprise Manager, it says:
>> Snap-in failed to initialize.
>> Name: Microsoft SQL Enterprise Manager
>> CLSID:{00100100-1816-11D0-8EF5-00AA0062C58F}
>> I have looked through the knowledge base articles and
>> have not found one specific to my situation.
>> I have uninstalled/reinstalled sql server 2000 (and
>> therefore, MDAC as well) and I am running into the same
>> issues.
>> Any help is appreciated.
>
>.
>|||> I just tried it with the same result.
Did you find the actual sqldmo.dll file that corresponds to the SQL Server
2000 install? Or did you run exactly what I posted? Did you get a dialog
that told you the registration was successful?
--
http://www.aspfaq.com/
(Reverse address to reply.)|||Yes - the file came from the sql 2000 install and
received a message that is was successful.
>--Original Message--
>> I just tried it with the same result.
>Did you find the actual sqldmo.dll file that corresponds
to the SQL Server
>2000 install? Or did you run exactly what I posted?
Did you get a dialog
>that told you the registration was successful?
>--
>http://www.aspfaq.com/
>(Reverse address to reply.)
>
>.
>|||You might want to post your issue and any relevant log files from the
install/uninstall to the SQL Server 2005 newsgroups. I'm sure they are
dealing with a lot of similar issues.
For information on access to those groups:
http://communities.microsoft.com/newsgroups/ICP/sqlserver2005/us/welcomePage.htm
--
http://www.aspfaq.com/
(Reverse address to reply.)
<anonymous@.discussions.microsoft.com> wrote in message
news:508f01c489e1$cf7b55b0$a301280a@.phx.gbl...
> Yes - the file came from the sql 2000 install and
> received a message that is was successful.
>
> >--Original Message--
> >> I just tried it with the same result.
> >
> >Did you find the actual sqldmo.dll file that corresponds
> to the SQL Server
> >2000 install? Or did you run exactly what I posted?
> Did you get a dialog
> >that told you the registration was successful?
> >
> >--
> >http://www.aspfaq.com/
> >(Reverse address to reply.)
> >
> >
> >.
> >

Enterprise Manger Error

I am getting an error:
MMC cannot open the file C:\program files\Miscorosft SQL
Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC.
This may be because the file does not exist, is not an MMC console, or was
creted by a later version of MMC. This may also by because you do not have
sufficient access rights to the file.
I've tried uninstalling/reinstalling reapplying SP3a etc. with no luck.
I did find that renaming the file to anything else will allow it to work.
Which makes for an easy enough work around but was wondering if anybody knew
what is going on?
TIA
Hi
Have you tried running MMC and opening the file from there?
Check the file permissions.
If you have EM on another machine you may want to try copying the file.
Alternatively may want to extract the MSC file from the original CD.
John
"Ken Rinaman" <go@.away.net> wrote in message
news:%23sPCyhiUEHA.2972@.TK2MSFTNGP12.phx.gbl...
> I am getting an error:
> MMC cannot open the file C:\program files\Miscorosft SQL
> Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC.
> This may be because the file does not exist, is not an MMC console, or was
> creted by a later version of MMC. This may also by because you do not have
> sufficient access rights to the file.
> I've tried uninstalling/reinstalling reapplying SP3a etc. with no luck.
> I did find that renaming the file to anything else will allow it to work.
> Which makes for an easy enough work around but was wondering if anybody
knew
> what is going on?
> TIA
>
|||
> Have you tried running MMC and opening the file from there?
Yes, same error.

> Check the file permissions.
I have the ability to rename, delete, etc.

> If you have EM on another machine you may want to try copying the file.
> Alternatively may want to extract the MSC file from the original CD.
I did pull the file from the CD which is how I discovered changing the name
fixes the problem. On the CD the file is called SQLEM.msc if I copy that
file to my computer it runs fine. However if I rename it to SQL Server
Enterprise Manger.msc it no longer runs.
sql

Enterprise Manager Tools SQL2000

I have a new laptop with xp pro. Where are the client tools for SQL2000?
I need Query Anzlyser and Enterprise Mgr.

Thanks,
MikeHi Mike,

The SQL Server client tools are part of the SQL Server installation and come with the SQL Server CD.

See the following KB article: (see section: To Install Client Tools Only for SQL Server 2000)
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q303747

This is not included as part of Windows XP Professional.

Regards,
Vikram

Enterprise Manager Tools

Can someone point me to the licensing requirements of the
admin tools. I have a number of db's that I admin. I am
wondering about the use of the admin tools on these
databases.
TIA
meh
"MEH" <mehogberg@.cox.net> wrote in message
news:20af01c53eaf$03fb58d0$a601280a@.phx.gbl...
> Can someone point me to the licensing requirements of the
> admin tools. I have a number of db's that I admin. I am
> wondering about the use of the admin tools on these
> databases.
As long as you have a licensed copy of SQL Server, you are authorized to use
the SQL Server tools, like Enterprise Manager, on multiple databases. If I
didn't answer your question, provide more detail?
Steve
|||Steve;
Thanks for the reply. I work for a company that not only
has its own database's (and copies of SQL Enterprise) but
we have customers that we sell, create and maintain SQL
enterprise (and some MSDE) databases. I loaded the tools
on my laptop so that I can go to different sites and work
on said databases. We were talking the other day about
weather or not it was within the licensing agreement if
I ...i.e load the tools from one of my companys
enterprise CD's and then go to a site and connect to
other databases. Or should I be using the tools from
their CD's?
TIA
Thanks for any info in this matter
meh
[vbcol=seagreen]
>--Original Message--
>"MEH" <mehogberg@.cox.net> wrote in message
>news:20af01c53eaf$03fb58d0$a601280a@.phx.gbl...
the[vbcol=seagreen]
am
>As long as you have a licensed copy of SQL Server, you
are authorized to use
>the SQL Server tools, like Enterprise Manager, on
multiple databases. If I
>didn't answer your question, provide more detail?
>Steve
>
>.
>
|||hi,
MEH wrote:
> Can someone point me to the licensing requirements of the
> admin tools. I have a number of db's that I admin. I am
> wondering about the use of the admin tools on these
> databases.
please have a look at
http://www.google.it/groups?q=group:...phx.gbl&rnum=1
... according to this pst, due to a Microosft representative, you are not
entitled at all to use the SQL Server Client Tools on production MSDE
instance...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.11.1 - DbaMgr ver 0.57.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Try SQL Admin Studio from www.simego.com it's only $40 yet far faster than
Enterprise Manager.
"Andrea Montanari" <andrea.sqlDMO@.virgilio.it> wrote in message
news:3c26v1F6jpo62U1@.individual.net...
> hi,
> MEH wrote:
> please have a look at
> http://www.google.it/groups?q=group:...phx.gbl&rnum=1
> ... according to this pst, due to a Microosft representative, you are not
> entitled at all to use the SQL Server Client Tools on production MSDE
> instance...
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.11.1 - DbaMgr ver 0.57.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>

Enterprise Manager tail snap-in initialization

Hi Guys,
I tried to install client tools of Sql Server 2005 DevEd. Wow! Big
product... but my boss imposed me to deinstall this tools.
Now when I launch Enterprise Manager I get this message:
Snap-in failed to initialize.
Name:<unknown>
CLSID:{00100100-1816-11D0-8EF5-00AA0062C58F}
I already tried to verify to have access my local register (I'm
connected to a domain) and reregister DMO typing:
regsvr32 "c:\Program Files\Microsoft SQL
Server\80\Tools\Binn\SQLDMO.DLL"
Registration succeed but.. the problem it's not solved.
I would not to reinstall Sql Server 2000 if it's possible.
Can you give me an help, please?
My Best Regards
PierpaoloI am afraid you need to install the tools, otherwise you can=B4t access
the EM.
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
--|||Uninstalling SQL 2005 unregisters the dmo dll's so EM doesn't work in SQL
2000 anymore, try this:
regsvr32 "C:\Program Files\Microsoft SQL Server\80\Tools\Binn\sqldmo.dll"
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"Pierpaolo" <pierpaolo.simoncini@.txt.it> wrote in message
news:1144061808.495311.176670@.e56g2000cwe.googlegroups.com...
> Hi Guys,
> I tried to install client tools of Sql Server 2005 DevEd. Wow! Big
> product... but my boss imposed me to deinstall this tools.
> Now when I launch Enterprise Manager I get this message:
> Snap-in failed to initialize.
> Name:<unknown>
> CLSID:{00100100-1816-11D0-8EF5-00AA0062C58F}
> I already tried to verify to have access my local register (I'm
> connected to a domain) and reregister DMO typing:
> regsvr32 "c:\Program Files\Microsoft SQL
> Server\80\Tools\Binn\SQLDMO.DLL"
> Registration succeed but.. the problem it's not solved.
> I would not to reinstall Sql Server 2000 if it's possible.
> Can you give me an help, please?
> My Best Regards
> Pierpaolo
>

Enterprise Manager tail snap-in initialization

Hi Guys,
I tried to install client tools of Sql Server 2005 DevEd. Wow! Big
product... but my boss imposed me to deinstall this tools.
Now when I launch Enterprise Manager I get this message:
Snap-in failed to initialize.
Name:<unknown>
CLSID:{00100100-1816-11D0-8EF5-00AA0062C58F}
I already tried to verify to have access my local register (I'm
connected to a domain) and reregister DMO typing:
regsvr32 "c:\Program Files\Microsoft SQL
Server\80\Tools\Binn\SQLDMO.DLL"
Registration succeed but.. the problem it's not solved.
I would not to reinstall Sql Server 2000 if it's possible.
Can you give me an help, please?
My Best Regards
Pierpaolo
I am afraid you need to install the tools, otherwise you can=B4t access
the EM.
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
|||Uninstalling SQL 2005 unregisters the dmo dll's so EM doesn't work in SQL
2000 anymore, try this:
regsvr32 "C:\Program Files\Microsoft SQL Server\80\Tools\Binn\sqldmo.dll"
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"Pierpaolo" <pierpaolo.simoncini@.txt.it> wrote in message
news:1144061808.495311.176670@.e56g2000cwe.googlegr oups.com...
> Hi Guys,
> I tried to install client tools of Sql Server 2005 DevEd. Wow! Big
> product... but my boss imposed me to deinstall this tools.
> Now when I launch Enterprise Manager I get this message:
> Snap-in failed to initialize.
> Name:<unknown>
> CLSID:{00100100-1816-11D0-8EF5-00AA0062C58F}
> I already tried to verify to have access my local register (I'm
> connected to a domain) and reregister DMO typing:
> regsvr32 "c:\Program Files\Microsoft SQL
> Server\80\Tools\Binn\SQLDMO.DLL"
> Registration succeed but.. the problem it's not solved.
> I would not to reinstall Sql Server 2000 if it's possible.
> Can you give me an help, please?
> My Best Regards
> Pierpaolo
>

Enterprise Manager for SQL server 2005

Hi,

i just installed sql 2k5 server and client tools.

When i run SQL ServerManagment Studio i dont find a way to create database.

Sajajd

Right click Databases. It will give you the option to create a new database.

Adamus

|||

First thing you have to do is to connect to the server so that you can view the system in the object explorer... once there expand the server so that you can view the database tab and as above right click and select create database or new database.

Enterprise Manager and MSDE

I have an MSDE database that I want to be able to look at the table
structure and schedule backups.
Does MSDE come with a set of client tools?
If not, can I simply install the client tools from SQL Server 2000 Standard
Edition and use them with MSDE?> Does MSDE come with a set of client tools?
No.
> If not, can I simply install the client tools from SQL Server 2000
Standard
> Edition and use them with MSDE?
This can be a very tricky licensing issue, and I strongly recommend speaking
to your licensing rep (or where you obtained the standard license(s)) to
determine if your current agreement allows you to manage MSDE. MS' response
to this issue has varied from "whatever" to "you cannot do that."
In the meantime, you can try and see if any of these other tools will allow
you to schedule backups/jobs (most, if not all, will allow you to look at
schema):
http://www.aspfaq.com/2442
--
http://www.aspfaq.com/
(Reverse address to reply.)|||HI
Does MSDE come with a set of client tools? : Not, but if you have SQL Server
2000 Server licence, you can install client tools, like Enterprise manager
ect. an you can use with MSDE.
Andras Jakus MCDBA
"Dave" wrote:
> I have an MSDE database that I want to be able to look at the table
> structure and schedule backups.
> Does MSDE come with a set of client tools?
> If not, can I simply install the client tools from SQL Server 2000 Standard
> Edition and use them with MSDE?
>
>|||No, that's not true. Generally you cannot use those tools against MSDE. See
the sixth question in the Appropriate Uses of MSDE FAQ at
http://www.microsoft.com/sql/msde/howtobuy/msdeuse.asp, copied below for
your benefit. The big catch here is the "in conjunction with a properly
licensed copy of SQL Server 2000", the definition of which is left up to
your lawyer because from what I've heard, the explanation of what that means
requires a room full of lawyers and a white board. :-) I'd strongly
recommend that you take a look at the alternatives that Aaron pointed you
at.
The good news is the MSDE's replacement, SQL Server 2005 Express, will come
with a GUI administration interface. The bad news is that SQL Server 2005
won't be released until next year.
Q. Can I use SQL Server tools and services in conjunction with MSDE?
A. You can only use SQL Server tools and services in conjunction with
MSDE if you acquired MSDE through SQL Server 2000 (Developer Edition,
Standard Edition, or Enterprise Edition), and if you are using MSDE in
conjunction with a properly licensed copy of SQL Server 2000. Visit the How
to Buy page for information on obtaining a valid SQL Server license.
Note: The tools and services included with SQL Server Developer
Edition may not be used to manage production server environments.
The following utilities are installed by the MSDE setup application
and are provided without restrictions for use with the copy of MSDE that is
installed by your application: bcp.exe, cnfgsvr.exe, dcomscm.exe, osql.exe,
sqlmaint.exe, sqlmangr.exe, scm.exe, sqladhlp.exe, and svrnetcn.exe. The
dtsrun.exe utility is also provided, but can only be used to run existing
Data Transformation Services (DTS) packages against the copy of MSDE
installed by your application; it cannot be used to develop new DTS
packages.
Sincerely,
Stephen Dybing
This posting is provided "AS IS" with no warranties, and confers no rights.
"Andras Jakus" <AndrasJakus@.discussions.microsoft.com> wrote in message
news:47DD19D4-A087-42F5-86D0-CB0BC3444DAA@.microsoft.com...
> HI
> Does MSDE come with a set of client tools? : Not, but if you have SQL
> Server
> 2000 Server licence, you can install client tools, like Enterprise manager
> ect. an you can use with MSDE.
> Andras Jakus MCDBA
> "Dave" wrote:
>> I have an MSDE database that I want to be able to look at the table
>> structure and schedule backups.
>> Does MSDE come with a set of client tools?
>> If not, can I simply install the client tools from SQL Server 2000
>> Standard
>> Edition and use them with MSDE?
>>
begin 666 ts.gif
J1TE&.#EA`0`!`( ``````/___R'Y! $`````+ `````!``$```(!1 `[
`
end