Enumerate Users in NT Groups

Hi,
How Can I list the users in an NT group, ie I have user Joe Bloggs who is
in NT Group Domain/Users.
I need to return to a client app what group they are in.
Julian
Julian
Look at sp_helpusers and also
DECLARE @.cmd VARCHAR(100)
SET @.cmd = 'NET USER "' + yourloginname+ '"'
EXEC master.dbo.xp_cmdshell @.cmd
"Julian" <Jpotter730@.msn.com> wrote in message
news:#GH7q9cLEHA.1484@.tk2msftngp13.phx.gbl...
> Hi,
> How Can I list the users in an NT group, ie I have user Joe Bloggs who
is
> in NT Group Domain/Users.
> I need to return to a client app what group they are in.
> Julian
>
|||Hi,
Run the below command from command prompt to list the users inside a group.
net group groupname
and for local groups run the below command
net localgroup groupname
Note: From Query analyzer as Uri mentioned you can use xp_cmdshell to
execute the above commands.
Thanks
Hari
MCDBA
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:ep7KNCdLEHA.3472@.TK2MSFTNGP09.phx.gbl...[vbcol=seagreen]
> Julian
> Look at sp_helpusers and also
> DECLARE @.cmd VARCHAR(100)
> SET @.cmd = 'NET USER "' + yourloginname+ '"'
> EXEC master.dbo.xp_cmdshell @.cmd
> "Julian" <Jpotter730@.msn.com> wrote in message
> news:#GH7q9cLEHA.1484@.tk2msftngp13.phx.gbl...
who
> is
>
sql

Enumerate Users in NT Groups

Hi,
How Can I list the users in an NT group, ie I have user Joe Bloggs who is
in NT Group Domain/Users.
I need to return to a client app what group they are in.
JulianJulian
Look at sp_helpusers and also
DECLARE @.cmd VARCHAR(100)
SET @.cmd = 'NET USER "' + yourloginname+ '"'
EXEC master.dbo.xp_cmdshell @.cmd
"Julian" <Jpotter730@.msn.com> wrote in message
news:#GH7q9cLEHA.1484@.tk2msftngp13.phx.gbl...
> Hi,
> How Can I list the users in an NT group, ie I have user Joe Bloggs who
is
> in NT Group Domain/Users.
> I need to return to a client app what group they are in.
> Julian
>|||Hi,
Run the below command from command prompt to list the users inside a group.
net group groupname
and for local groups run the below command
net localgroup groupname
Note: From Query analyzer as Uri mentioned you can use xp_cmdshell to
execute the above commands.
Thanks
Hari
MCDBA
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:ep7KNCdLEHA.3472@.TK2MSFTNGP09.phx.gbl...
> Julian
> Look at sp_helpusers and also
> DECLARE @.cmd VARCHAR(100)
> SET @.cmd = 'NET USER "' + yourloginname+ '"'
> EXEC master.dbo.xp_cmdshell @.cmd
> "Julian" <Jpotter730@.msn.com> wrote in message
> news:#GH7q9cLEHA.1484@.tk2msftngp13.phx.gbl...
who[vbcol=seagreen]
> is
>

Enumerate Users in NT Groups

Hi,
How Can I list the users in an NT group, ie I have user Joe Bloggs who is
in NT Group Domain/Users.
I need to return to a client app what group they are in.
JulianJulian
Look at sp_helpusers and also
DECLARE @.cmd VARCHAR(100)
SET @.cmd = 'NET USER "' + yourloginname+ '"'
EXEC master.dbo.xp_cmdshell @.cmd
"Julian" <Jpotter730@.msn.com> wrote in message
news:#GH7q9cLEHA.1484@.tk2msftngp13.phx.gbl...
> Hi,
> How Can I list the users in an NT group, ie I have user Joe Bloggs who
is
> in NT Group Domain/Users.
> I need to return to a client app what group they are in.
> Julian
>|||Hi,
Run the below command from command prompt to list the users inside a group.
net group groupname
and for local groups run the below command
net localgroup groupname
Note: From Query analyzer as Uri mentioned you can use xp_cmdshell to
execute the above commands.
Thanks
Hari
MCDBA
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:ep7KNCdLEHA.3472@.TK2MSFTNGP09.phx.gbl...
> Julian
> Look at sp_helpusers and also
> DECLARE @.cmd VARCHAR(100)
> SET @.cmd = 'NET USER "' + yourloginname+ '"'
> EXEC master.dbo.xp_cmdshell @.cmd
> "Julian" <Jpotter730@.msn.com> wrote in message
> news:#GH7q9cLEHA.1484@.tk2msftngp13.phx.gbl...
> > Hi,
> >
> > How Can I list the users in an NT group, ie I have user Joe Bloggs
who
> is
> > in NT Group Domain/Users.
> >
> > I need to return to a client app what group they are in.
> >
> > Julian
> >
> >
>

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 mangler

Hi all,
I have two workstations with fresh reloaded sql2000 client
software and fresh reloaded MDAC(current version).
When I go thru SQLEM to the database and drill down to
query the individual tables, I get a the table trying to
open and the the "Provider not found. It may not be
installed correctl" error. The provider is installed
correctly.
The only way I have found to fix this issue is to reload
Window Operating system on the workstation and then there
is no more problem. Needless to say, this is unacceptable.
Does anyone know of a fix for this? MS Support has sofar
been unable to address. Any info could help.
TIA!Did you uninstall and reinstall the client tools? Did you apply SP3a?
--
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"Chip" <cjsmith@.teampdc.com> wrote in message
news:10c401c4384e$421a9760$3501280a@.phx.gbl...
> Hi all,
> I have two workstations with fresh reloaded sql2000 client
> software and fresh reloaded MDAC(current version).
> When I go thru SQLEM to the database and drill down to
> query the individual tables, I get a the table trying to
> open and the the "Provider not found. It may not be
> installed correctl" error. The provider is installed
> correctly.
> The only way I have found to fix this issue is to reload
> Window Operating system on the workstation and then there
> is no more problem. Needless to say, this is unacceptable.
> Does anyone know of a fix for this? MS Support has sofar
> been unable to address. Any info could help.
> TIA!

Enterprise Manager Under XP

Just installed SQL on an XP client (my workstation). When I run enterprise manager, I have found that I no longer have toolbars (command bars) in the child windows (i.e. design table, open table, etc.). The toolbar buttons appear in the main window but not in the child window. This only appears to happen with XP (not in 2000). A buddy of mine is having the same issue.

Anybody know how to get my child window toolbars back? Thanks...Originally posted by pate
Just installed SQL on an XP client (my workstation). When I run enterprise manager, I have found that I no longer have toolbars (command bars) in the child windows (i.e. design table, open table, etc.). The toolbar buttons appear in the main window but not in the child window. This only appears to happen with XP (not in 2000). A buddy of mine is having the same issue.

Anybody know how to get my child window toolbars back? Thanks...

Menu>VIEW>CUSTOMIZE

??|||Originally posted by Brett Kaiser
Menu>VIEW>CUSTOMIZE

??

Been there and tried every possible option available without any luck...|||Originally posted by pate
Just installed SQL on an XP client (my workstation). When I run enterprise manager, I have found that I no longer have toolbars (command bars) in the child windows (i.e. design table, open table, etc.). The toolbar buttons appear in the main window but not in the child window. This only appears to happen with XP (not in 2000). A buddy of mine is having the same issue.

Anybody know how to get my child window toolbars back? Thanks...

I never did like xp...why that platform?

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 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 Server Registrations

Has anyone discovered a way to be able to transfer all registered instances
within Enterprise Manager to another client(s) without having to re-register
them in each client?
thanks
No simple way. You used to be able to export the registry key(s), but not
anymore.
See http://tinyurl.com/6gf85
If you don't trust tinyurl links, then you can piece together this one:
http://groups.google.com/groups?hl=e...oft.com&rnum=6
http://www.aspfaq.com/
(Reverse address to reply.)
"tom frost" <tomfrost@.discussions.microsoft.com> wrote in message
news:32722264-3144-45B2-BB76-B47E01A123DE@.microsoft.com...
> Has anyone discovered a way to be able to transfer all registered
instances
> within Enterprise Manager to another client(s) without having to
re-register
> them in each client?
> thanks

Enterprise Manager Server Registrations

Has anyone discovered a way to be able to transfer all registered instances
within Enterprise Manager to another client(s) without having to re-register
them in each client?
thanksNo simple way. You used to be able to export the registry key(s), but not
anymore.
See http://tinyurl.com/6gf85
If you don't trust tinyurl links, then you can piece together this one:
http://groups.google.com/groups?hl=...soft.com&rnum=6
http://www.aspfaq.com/
(Reverse address to reply.)
"tom frost" <tomfrost@.discussions.microsoft.com> wrote in message
news:32722264-3144-45B2-BB76-B47E01A123DE@.microsoft.com...
> Has anyone discovered a way to be able to transfer all registered
instances
> within Enterprise Manager to another client(s) without having to
re-register
> them in each client?
> thanks

Enterprise Manager Server Registrations

Has anyone discovered a way to be able to transfer all registered instances
within Enterprise Manager to another client(s) without having to re-register
them in each client?
thanksNo simple way. You used to be able to export the registry key(s), but not
anymore.
See http://tinyurl.com/6gf85
If you don't trust tinyurl links, then you can piece together this one:
http://groups.google.com/groups?hl=en&lr=&selm=F54D32AC-191D-42A0-8737-F6D87E4A3232%40microsoft.com&rnum=6
--
http://www.aspfaq.com/
(Reverse address to reply.)
"tom frost" <tomfrost@.discussions.microsoft.com> wrote in message
news:32722264-3144-45B2-BB76-B47E01A123DE@.microsoft.com...
> Has anyone discovered a way to be able to transfer all registered
instances
> within Enterprise Manager to another client(s) without having to
re-register
> them in each client?
> thanks

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 Connection

I need to open up my firewall so that a client can access my SQL server
using the Enterprise Manager. I opened up port 1433, but apparently
that's just the data connection port, not for management.
Where can I get a list of all SQL related ports?
Thanks!
--DaveINF: TCP Ports Needed for Communication to SQL Server Through a Firewall
http://support.microsoft.com/defaul...2&Product=sql2k
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Dave Navarro" <dave@.dave.dave> wrote in message
news:MPG.1a959ad45c280f7a989782@.news-40.giganews.com...
> I need to open up my firewall so that a client can access my SQL server
> using the Enterprise Manager. I opened up port 1433, but apparently
> that's just the data connection port, not for management.
> Where can I get a list of all SQL related ports?
> Thanks!
> --Dave|||You can use 1433 for management if the client is connecting using TCP
Sockets. They can create an alias or change the NetLib choice in the Client
Network Utility to use 1433 for this. If they are using Named Pipes
(probably) then they are using the same ports as TCP over NetBios. I think
it is 135, 137, and 138. If they are using MultiProtocol (doubt it) they
are using the ports for RPC, 135 for the mapper and then 50,000 and up.
Christian Smith
"Dave Navarro" <dave@.dave.dave> wrote in message
news:MPG.1a959ad45c280f7a989782@.news-40.giganews.com...
> I need to open up my firewall so that a client can access my SQL server
> using the Enterprise Manager. I opened up port 1433, but apparently
> that's just the data connection port, not for management.
> Where can I get a list of all SQL related ports?
> Thanks!
> --Dave|||In article <OPZAL5Z8DHA.2480@.TK2MSFTNGP12.phx.gbl>,
SRDBA@.Careerbuilder.com says...
> INF: TCP Ports Needed for Communication to SQL Server Through a Firewall
> http://support.microsoft.com/defaul...www.sqlpass.org
> "Dave Navarro" <dave@.dave.dave> wrote in message
> news:MPG.1a959ad45c280f7a989782@.news-40.giganews.com...
Thanks for the URL.
Unfortunately, I can't connect to the server using Enterprise Manager.
I can connect to it from ASP, however. The FAQ isn't specific as to
what the connection is used for, but from experience it's used to send
queries/receive data (strictly for data access).
When I am "inside" the firewall and use Enterprise Manager to connect
from another computer on the same network, it works just fine. But I
can't connect to it using Enterprise Manager from outside of the
firewall.
--Dave|||In article <u39HU5Z8DHA.1632@.TK2MSFTNGP12.phx.gbl>, csmith@.digex.com
says...
> You can use 1433 for management if the client is connecting using TCP
> Sockets. They can create an alias or change the NetLib choice in the Clie
nt
> Network Utility to use 1433 for this. If they are using Named Pipes
> (probably) then they are using the same ports as TCP over NetBios. I thin
k
> it is 135, 137, and 138. If they are using MultiProtocol (doubt it) they
> are using the ports for RPC, 135 for the mapper and then 50,000 and up.
> Christian Smith
> "Dave Navarro" <dave@.dave.dave> wrote in message
> news:MPG.1a959ad45c280f7a989782@.news-40.giganews.com...
Thanks for the info. I can successfully connect to port 1433 on the
server using ASP code running in IIS from outside the firewall.
However, Enterprise Manager will not make a connection to the server at
all.
--Dave|||I download TDImon from www.sysinternals.com and watched the
connections...
Enterprise Manager uses port 1433 for its data connection and port 1434
for the management connection.
It's working now.
--Dave
In article <MPG.1a9600c12aad755f989784@.news-40.giganews.com>,
dave@.dave.dave says...
> In article <u39HU5Z8DHA.1632@.TK2MSFTNGP12.phx.gbl>, csmith@.digex.com
> says...
> Thanks for the info. I can successfully connect to port 1433 on the
> server using ASP code running in IIS from outside the firewall.
> However, Enterprise Manager will not make a connection to the server at
> all.

Enterprise Manager Connection

I need to open up my firewall so that a client can access my SQL server
using the Enterprise Manager. I opened up port 1433, but apparently
that's just the data connection port, not for management.
Where can I get a list of all SQL related ports?
Thanks!
--DaveYou can use 1433 for management if the client is connecting using TCP
Sockets. They can create an alias or change the NetLib choice in the Client
Network Utility to use 1433 for this. If they are using Named Pipes
(probably) then they are using the same ports as TCP over NetBios. I think
it is 135, 137, and 138. If they are using MultiProtocol (doubt it) they
are using the ports for RPC, 135 for the mapper and then 50,000 and up.
Christian Smith
"Dave Navarro" <dave@.dave.dave> wrote in message
news:MPG.1a959ad45c280f7a989782@.news-40.giganews.com...
> I need to open up my firewall so that a client can access my SQL server
> using the Enterprise Manager. I opened up port 1433, but apparently
> that's just the data connection port, not for management.
> Where can I get a list of all SQL related ports?
> Thanks!
> --Dave|||INF: TCP Ports Needed for Communication to SQL Server Through a Firewall
http://support.microsoft.com/default.aspx?scid=kb;en-us;287932&Product=sql2k
--
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Dave Navarro" <dave@.dave.dave> wrote in message
news:MPG.1a959ad45c280f7a989782@.news-40.giganews.com...
> I need to open up my firewall so that a client can access my SQL server
> using the Enterprise Manager. I opened up port 1433, but apparently
> that's just the data connection port, not for management.
> Where can I get a list of all SQL related ports?
> Thanks!
> --Dave|||In article <OPZAL5Z8DHA.2480@.TK2MSFTNGP12.phx.gbl>,
SRDBA@.Careerbuilder.com says...
> INF: TCP Ports Needed for Communication to SQL Server Through a Firewall
> http://support.microsoft.com/default.aspx?scid=kb;en-us;287932&Product=sql2k
> --
> Geoff N. Hiten
> Microsoft SQL Server MVP
> Senior Database Administrator
> Careerbuilder.com
> I support the Professional Association for SQL Server
> www.sqlpass.org
> "Dave Navarro" <dave@.dave.dave> wrote in message
> news:MPG.1a959ad45c280f7a989782@.news-40.giganews.com...
> > I need to open up my firewall so that a client can access my SQL server
> > using the Enterprise Manager. I opened up port 1433, but apparently
> > that's just the data connection port, not for management.
> >
> > Where can I get a list of all SQL related ports?
Thanks for the URL.
Unfortunately, I can't connect to the server using Enterprise Manager.
I can connect to it from ASP, however. The FAQ isn't specific as to
what the connection is used for, but from experience it's used to send
queries/receive data (strictly for data access).
When I am "inside" the firewall and use Enterprise Manager to connect
from another computer on the same network, it works just fine. But I
can't connect to it using Enterprise Manager from outside of the
firewall.
--Dave|||In article <u39HU5Z8DHA.1632@.TK2MSFTNGP12.phx.gbl>, csmith@.digex.com
says...
> You can use 1433 for management if the client is connecting using TCP
> Sockets. They can create an alias or change the NetLib choice in the Client
> Network Utility to use 1433 for this. If they are using Named Pipes
> (probably) then they are using the same ports as TCP over NetBios. I think
> it is 135, 137, and 138. If they are using MultiProtocol (doubt it) they
> are using the ports for RPC, 135 for the mapper and then 50,000 and up.
> Christian Smith
> "Dave Navarro" <dave@.dave.dave> wrote in message
> news:MPG.1a959ad45c280f7a989782@.news-40.giganews.com...
> > I need to open up my firewall so that a client can access my SQL server
> > using the Enterprise Manager. I opened up port 1433, but apparently
> > that's just the data connection port, not for management.
> >
> > Where can I get a list of all SQL related ports?
Thanks for the info. I can successfully connect to port 1433 on the
server using ASP code running in IIS from outside the firewall.
However, Enterprise Manager will not make a connection to the server at
all.
--Dave|||I download TDImon from www.sysinternals.com and watched the
connections...
Enterprise Manager uses port 1433 for its data connection and port 1434
for the management connection.
It's working now.
--Dave
In article <MPG.1a9600c12aad755f989784@.news-40.giganews.com>,
dave@.dave.dave says...
> In article <u39HU5Z8DHA.1632@.TK2MSFTNGP12.phx.gbl>, csmith@.digex.com
> says...
> > You can use 1433 for management if the client is connecting using TCP
> > Sockets. They can create an alias or change the NetLib choice in the Client
> > Network Utility to use 1433 for this. If they are using Named Pipes
> > (probably) then they are using the same ports as TCP over NetBios. I think
> > it is 135, 137, and 138. If they are using MultiProtocol (doubt it) they
> > are using the ports for RPC, 135 for the mapper and then 50,000 and up.
> >
> > Christian Smith
> >
> > "Dave Navarro" <dave@.dave.dave> wrote in message
> > news:MPG.1a959ad45c280f7a989782@.news-40.giganews.com...
> > > I need to open up my firewall so that a client can access my SQL server
> > > using the Enterprise Manager. I opened up port 1433, but apparently
> > > that's just the data connection port, not for management.
> > >
> > > Where can I get a list of all SQL related ports?
> Thanks for the info. I can successfully connect to port 1433 on the
> server using ASP code running in IIS from outside the firewall.
> However, Enterprise Manager will not make a connection to the server at
> all.

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...[vbcol=seagreen]
> 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:
begin 666 ts.gif
J1TE&.#EA`0`!`( ``````/___R'Y! $`````+ `````!``$```(!1 `[
`
end

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

Enterprise Manager

OK Guys, flame away!

After finally getting to grips with phpmyadmin and mysql.

A client of mine is insisting on using M$ SQL... I am told Enterprise manager is the best way to access this! Can someone point me in the right direction from where I can get this client from.

Regards
ChrisAll you will need to do is install "Client Tools" from the SQL Server CD. You will then have Enterprise Manager on that PC/Server.

As for "best way to access the data", well, I think Query Analyzer is better for most day to day things. But that is just my not-so-humble opinion....Now, about those flames...
~Matt