Enumerating instances without DMO

Can anyone suggest a method of enumerating instances of MSDE 2000 without
using DMO ?

Using C++, MFC, and ADO.

ThanksSee questions 12 and 13:

http://support.microsoft.com/defaul...6&Product=sql2k

If you need to enumerate instances externally (ie without access to the
server's registry), then SQLDMO may still be the best option - see the
ListAvailableSQLServers method. Also see here:

http://www.sqldev.net/misc/ListSQLSvr.htm

Simon|||Simon,

Many thanks. I feel a bit foolish as I trawled through that document,
although it was a few years ago...

I have not got satisfactory results from 'ListAvailableSQLServers'. Function
returns OK but the resulting loop yields only 1 server, I have two
instances. Never mind, the registry is fine for my needs and a lot simpler.

Cheers

Jon.

"Simon Hayes" <sql@.hayes.ch> wrote in message
news:1118213082.991451.13250@.f14g2000cwb.googlegro ups.com...
> See questions 12 and 13:
> http://support.microsoft.com/defaul...6&Product=sql2k
> If you need to enumerate instances externally (ie without access to the
> server's registry), then SQLDMO may still be the best option - see the
> ListAvailableSQLServers method. Also see here:
> http://www.sqldev.net/misc/ListSQLSvr.htm
> Simonsql

enumerate the list of MSDE instances

Hi All,
I want to enumerate the list of MSDE instances on LAN using VB6.I
cannot use SQLDMO or SMO library.
I am using NetServerEnum API but it displays only SQL servers and
default MSDE instance.
Is there any API or other means to get the list of named instance of
MSDE in VB6.
Please advice.
Nidhi Sharma
Thanks for your response!
SuperSockets Network Protocols were enabled during installation of
MSDE2000.
I am able to connect successfully using <Computer Name>/
<InstanceName>. But the problem is that i am unable to get the list of
MSDE instances on the LAN.It displays the default instance if present.
Could you guide me how to broadcast UDP on port 1434 in VB6?
Nidhi Sharma

Enumerate SQL servers?

I'm working on an Access app that will have a SQL 2K backend. My setup will
install MSDE, and I will set the sa password, etc. which I don't want the
end user's to know. My problem is in Relinking the ODBC tables once it is
installed in the field. The one item I won't know is the name of the server
MSDE is installed on. I want to prompt the user to pick the server from a
list, much like you do when creating a DSN through the ODBC Administrator. I
can't use the ODBC Administrator to create a DSN because if the user doesn't
enter the sa password, it fails; also, I want to use DSN-less connections.
But I can't seem to find an API call to enumerate the SQL servers available
on the network. Does anyone know of an API to call? Alternatively, some code
to enumerate SQL servers running on the LAN? TIA!Can also look at :
http://www.extremeexperts.com/sql/f...istServers.aspx
HTH,
Vinod Kumar
MCSE, DBA, MCAD, MCSD
http://www.extremeexperts.com
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp
"Ron Hinds" <__NoSpam@.__NoSpamramac.com> wrote in message
news:%23rKHj4H3DHA.1392@.TK2MSFTNGP11.phx.gbl...

quote:

---

> I'm working on an Access app that will have a SQL 2K backend. My setup

---

will

quote:

---

> install MSDE, and I will set the sa password, etc. which I don't want the
> end user's to know. My problem is in Relinking the ODBC tables once it is
> installed in the field. The one item I won't know is the name of the

---

server

quote:

---

> MSDE is installed on. I want to prompt the user to pick the server from a
> list, much like you do when creating a DSN through the ODBC Administrator.

---

I

quote:

---

> can't use the ODBC Administrator to create a DSN because if the user

---

doesn't

quote:

---

> enter the sa password, it fails; also, I want to use DSN-less connections.
> But I can't seem to find an API call to enumerate the SQL servers

---

available

quote:

---

> on the network. Does anyone know of an API to call? Alternatively, some

---

code

quote:

---

> to enumerate SQL servers running on the LAN? TIA!
>

---

|||Hi Vinodk,
I can list SQL server instances on my personal computer fairly easily using
SQLBrowseConnect and associated methods but I have trouble trying to
enumerate all SQL servers on the network if I am not connected to a browser
service. Obviously, I don't expect to get a list of servers if I am not
connected but I can't seem to get a *faster* way to check if I am connected
to the browser service.
I use something like the folowing to see if any master browsers are
available in hopes for speed bit it is very slow. If the status return
ERROR_NO_BROWSER_SERVERS_FOUND, I don't want to go further.
nStatus = NetServerEnum(NULL,
(DWORD)100,
(LPBYTE *) &pBufServerBrowser,
dwPrefMaxLen,
&dwEntriesRead,
&dwTotalEntries,
SV_TYPE_DOMAIN_MASTER |
SV_TYPE_POTENTIAL_BROWSER |
SV_TYPE_BACKUP_BROWSER |
SV_TYPE_MASTER_BROWSER,
NULL,
&dwResumeHandle);
Any thoughts on this'
Thanks in advance for any help...
Regards,
Chris H
"Vinodk" <vinodk_sct@.NO_SPAM_hotmail.com> wrote in message
news:eXEf9iL3DHA.2296@.TK2MSFTNGP11.phx.gbl...
> Can also look at :
> http://www.extremeexperts.com/sql/f...istServers.aspx
> --
> HTH,
> Vinod Kumar
> MCSE, DBA, MCAD, MCSD
> http://www.extremeexperts.com
> Books Online for SQL Server SP3 at
> http://www.microsoft.com/sql/techin.../2000/books.asp
>
> "Ron Hinds" <__NoSpam@.__NoSpamramac.com> wrote in message
> news:%23rKHj4H3DHA.1392@.TK2MSFTNGP11.phx.gbl...
> will
the
is
> server
a
Administrator.
> I
> doesn't
connections.
> available
> code
>

Enterprise Mgr

I have recently installed MSDE on my computer. Now I need to get a copy of
Enterprise Mgr or equivalent. Does anyone know if I can obtain this from
somewhere without having to purchase anything from M$http://www.aspfaq.com/show.asp?id=2442

--
David Portas
SQL Server MVP
--

Enterprise Manager: The connection to SQL Server <server> has been broken.

All~
I am currently running the most recent version of MSDE and using EM as
a front end interface. In EM, I go to look at the databases I had
previously created, but receive the message:
The connection to SQL Server <server> has been broken. The connection
to the SQL Server is broken. Do you want to try reconnection...
I am unable to start SQL Agent, but I am not sure whether this is the
cause. I am able to connect via the Query Analyzer facility fine. I
get the following SQLDump [truncated].
What is the EXCEPTION_ACCESS_VIOLATION and how can I fix it?
...
**
*
* BEGIN STACK DUMP:
* 07/31/04 09:59:24 spid 0
*
* Exception Address = 00000000
* Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION
* Access Violation occurred reading address 00000000
...
Your help is greatly appreciated.
Richard
Check your SQL Server error logs for more information. Also
check the SQL Agent log and see if you find any errors
related to that issue. You may also want to check the stack
dump and compare it with that mentioned in the following
article:
PRB: Removal of Guest Account May Cause Handled Exception
Access Violation in SQL Server
http://support.microsoft.com/?id=315523
-Sue
On 31 Jul 2004 07:22:35 -0700, rkinnie01@.excite.com (Richard
K) wrote:

>All~
>I am currently running the most recent version of MSDE and using EM as
>a front end interface. In EM, I go to look at the databases I had
>previously created, but receive the message:
>The connection to SQL Server <server> has been broken. The connection
>to the SQL Server is broken. Do you want to try reconnection...
>I am unable to start SQL Agent, but I am not sure whether this is the
>cause. I am able to connect via the Query Analyzer facility fine. I
>get the following SQLDump [truncated].
>What is the EXCEPTION_ACCESS_VIOLATION and how can I fix it?
>...
>**
>*
>* BEGIN STACK DUMP:
>* 07/31/04 09:59:24 spid 0
>*
>* Exception Address = 00000000
>* Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION
>* Access Violation occurred reading address 00000000
>...
>Your help is greatly appreciated.
>Richard

Enterprise Manager: The connection to SQL Server <server> has been broken.

All~
I am currently running the most recent version of MSDE and using EM as
a front end interface. In EM, I go to look at the databases I had
previously created, but receive the message:
The connection to SQL Server <server> has been broken. The connection
to the SQL Server is broken. Do you want to try reconnection...
I am unable to start SQL Agent, but I am not sure whether this is the
cause. I am able to connect via the Query Analyzer facility fine. I
get the following SQLDump [truncated].
What is the EXCEPTION_ACCESS_VIOLATION and how can I fix it?
...
**
*
* BEGIN STACK DUMP:
* 07/31/04 09:59:24 spid 0
*
* Exception Address = 00000000
* Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION
* Access Violation occurred reading address 00000000
...
Your help is greatly appreciated.
RichardCheck your SQL Server error logs for more information. Also
check the SQL Agent log and see if you find any errors
related to that issue. You may also want to check the stack
dump and compare it with that mentioned in the following
article:
PRB: Removal of Guest Account May Cause Handled Exception
Access Violation in SQL Server
http://support.microsoft.com/?id=315523
-Sue
On 31 Jul 2004 07:22:35 -0700, rkinnie01@.excite.com (Richard
K) wrote:

>All~
>I am currently running the most recent version of MSDE and using EM as
>a front end interface. In EM, I go to look at the databases I had
>previously created, but receive the message:
>The connection to SQL Server <server> has been broken. The connection
>to the SQL Server is broken. Do you want to try reconnection...
>I am unable to start SQL Agent, but I am not sure whether this is the
>cause. I am able to connect via the Query Analyzer facility fine. I
>get the following SQLDump [truncated].
>What is the EXCEPTION_ACCESS_VIOLATION and how can I fix it?
>...
>**
>*
>* BEGIN STACK DUMP:
>* 07/31/04 09:59:24 spid 0
>*
>* Exception Address = 00000000
>* Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION
>* Access Violation occurred reading address 00000000
>...
>Your help is greatly appreciated.
>Richard

Enterprise Manager Messed up completely

Hi. I spent half a day trying to figure this out, so i finally turn to you
guys for help.
first i had enterprise manager for 7.0
then i installed MSDE 2000 on my machine, then enterprise manager for 2000.
then i couldnt return rows for any table in enterprise manager (big
problem) - it said procedure not found or something
so i played around, and finally i replaced MSDART.DLL with a newer one, so
now i get different error message:
unknown error 8007007F.
ANYBODY know what in the world to do?
I have MDAC 2.8 installed, it doesnt want to rollback, it doesnt want to
reinstall - i tried 100 different ways.
Thanks!Hi i got solution through guessing in the registry, thanks
"Michael" <Michael@.nospamplease.com> wrote in message
news:u%23DhOP8BEHA.3360@.TK2MSFTNGP11.phx.gbl...
> Hi. I spent half a day trying to figure this out, so i finally turn to you
> guys for help.
> first i had enterprise manager for 7.0
> then i installed MSDE 2000 on my machine, then enterprise manager for
2000.
> then i couldnt return rows for any table in enterprise manager (big
> problem) - it said procedure not found or something
> so i played around, and finally i replaced MSDART.DLL with a newer one, so
> now i get different error message:
> unknown error 8007007F.
> ANYBODY know what in the world to do?
> I have MDAC 2.8 installed, it doesnt want to rollback, it doesnt want to
> reinstall - i tried 100 different ways.
> Thanks!
>|||Hi,
It must be a problem with some mismatched file version
Reinstall MDAC 2.8 from the following location and see if it helps
http://www.microsoft.com/downloads/...0fe3-c795-4b7d-
b037-185d0506396c&DisplayLang=en
If that fails, use the component checker from the following location to see
if there are any mismatched file versions. You can do that by running an
analysis against MDAC 2.8
http://www.microsoft.com/downloads/...8df6-4a21-4b43-
bf53-14332ef092c9&DisplayLang=en
Try to replace the mismatched files with the right ones from another server
and then stop and restart SQL. Pay specific attention to OLEDB32.dll.
Regards,
Gayathri Rau [MSFT]
This posting is provided "AS IS" with no warranties, and confers no rights.|||I had the same problem after upgrading to Windows 2003 Server. I called Mic
rosoft and here is the fix:
Symptoms:
After upgrading from Windows 2000 to Windows 2003 attempting to access a dat
abase or data component will result in a '8007007f' or "The specified proced
ure could not be found" error.
Status:
This is a known issue with some installations of Windows 2003
Workaround:
Extract oledb32.dll from the zip file into these two directories. It's impo
rtant that it be done in this order:
1) C:\WINNT\system32\dllCache
2) C:\Program Files\Common Files\System\OLE DB
3) Reboot the server
Cause:
This issue is caused when the Windows 2003 installer did not update the oled
b32.dll file.
You can dowload the oledb32.dll file here: [url]http://www.promiseweb.co
m/oledb32.zip[/url]
This is per Malcolm Stewart at Microsoft Developer Support
****************************************
******************************
Sent via Fuzzy Software @. http://www.fuzzysoftware.com/
Comprehensive, categorised, searchable collection of links to ASP & ASP.NET
resources...

Enterprise Manager Licensing with MSDE

Hello.
I have an application I am developing with MSDE. I know that I am properly
licensed to use MSDE and distribute that with my application. However, I
cannot seem to find any information about Enterprise Manager licensing. We
have a valid license of Sql Server 2000 and I have been using Enterprise
Manager to configure my MSDE database. I need to install the application at
a client's site and I was wondering if the licensing would allow me to
install Enterprise Manager so that I can configure the database on site
without having to use OSQL. (e.g. attaching the database)
Thanks.
Ryan
hi Ryan,
Ryan Taylor wrote:
> Hello.
> I have an application I am developing with MSDE. I know that I am
> properly licensed to use MSDE and distribute that with my
> application. However, I cannot seem to find any information about
> Enterprise Manager licensing. We have a valid license of Sql Server
> 2000 and I have been using Enterprise Manager to configure my MSDE
> database. I need to install the application at a client's site and I
> was wondering if the licensing would allow me to install Enterprise
> Manager so that I can configure the database on site without having
> to use OSQL. (e.g. attaching the database)
from Microsoft representative, http://tinyurl.com/eyukf, you are not
entitled to manage MSDE in production scenario with standard SQL Server
Client Tools... you have to rely on home made tools and/or 3rd party
tools...
you can find a partial list of them, both commercial and free, at
http://www.microsoft.com/sql/msde/partners/default.asp and
http://www.aspfaq.com/show.asp?id=2442
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
|||There is a free tool called DbaMgr that might fill your need. This tool can
be obtained at the following URL:
http://www.microsoft.com/sql/msde/partners/default.asp
The description of the tool reads as follows:
DbaMgr for MSDE 1.0 and DbaMgr2k for MSDE 2000 provide a free graphical
management interface for MSDE installations. They allow to manage and
administer servers, databases and database objects from a Windows interface
similar to Microsoft Enterprise Manager. To traditionals SQL Server tasks as
objects management and permissions, data manipulation, SQL Agent management,
custom T-SQL statements execution window, extended properties management,
DbaMgr and DbaMgr2k provide a visual interface for BCP operations, export to
'INSERT INTO' DDL sql files, HTML database documentation as well, and are
fully localizable.
Appriopriate SQL Server Client Components and MDAC versions are required.
Microsoft Visual Basic 6.0 source code is available.
There are other, similar, tools listed on the same page.
Carl
"Ryan Taylor" <rtaylor@.stgeorgeconsulting.com> wrote in message
news:Obe5VyZUFHA.2892@.TK2MSFTNGP14.phx.gbl...
> Hello.
> I have an application I am developing with MSDE. I know that I am properly
> licensed to use MSDE and distribute that with my application. However, I
> cannot seem to find any information about Enterprise Manager licensing. We
> have a valid license of Sql Server 2000 and I have been using Enterprise
> Manager to configure my MSDE database. I need to install the application
> at a client's site and I was wondering if the licensing would allow me to
> install Enterprise Manager so that I can configure the database on site
> without having to use OSQL. (e.g. attaching the database)
> Thanks.
> Ryan
>

Enterprise manager licencing

1. If someone is using SQL2000 MSDE, can he install enterprise manager to
manage it without SQL server licence?
2. If someone has a SQL2000 standard licence, can he install enterprise
manager (or any other CLIENT tools) to other client machines too?
3. SQL2005 express now has a GUI tool called Microsoft SQL Server Management
Studio Express that is free for download from Microsoft. Can it be used to
manage 2000 MSDE too?
Thanks
Tom
Hi Tom,
1. Yes. EM is a client tool which does not need to be licensed, because SQL
Server is licensed.
2. Yes. See above.
3. I'm not sure, but I think it is possible.
Danijel Novak
"Tom" <mcseman@.hotmail.com> wrote in message
news:%23LyUS4hGGHA.648@.TK2MSFTNGP14.phx.gbl...
> 1. If someone is using SQL2000 MSDE, can he install enterprise manager to
> manage it without SQL server licence?
> 2. If someone has a SQL2000 standard licence, can he install enterprise
> manager (or any other CLIENT tools) to other client machines too?
> 3. SQL2005 express now has a GUI tool called Microsoft SQL Server
> Management Studio Express that is free for download from Microsoft. Can it
> be used to manage 2000 MSDE too?
> Thanks
> Tom
>
|||Sorry Danijel & Tom, but:
1. No, you can't use SQL EM to manage the MSDE without a "real" SQL Server
license being involved. EM is licensed via a client access license from a
"real" SQL Server license.
2. Yes, if those systems have SQL Server CALs themselves.
3. Yes
HTH,
Greg
"Danijel Novak" <danijel.novak@.triera.net> wrote in message
news:ugwNzDnGGHA.1288@.TK2MSFTNGP09.phx.gbl...
> Hi Tom,
> 1. Yes. EM is a client tool which does not need to be licensed, because
> SQL Server is licensed.
> 2. Yes. See above.
> 3. I'm not sure, but I think it is possible.
> --
> Danijel Novak
>
> "Tom" <mcseman@.hotmail.com> wrote in message
> news:%23LyUS4hGGHA.648@.TK2MSFTNGP14.phx.gbl...
>
|||Danijel Novak wrote:
> Hi Tom,
> 1. Yes. EM is a client tool which does not need to be licensed, because SQL
> Server is licensed.
> 2. Yes. See above.
> 3. I'm not sure, but I think it is possible.
> --
> Danijel Novak
>
Danijel,

> 1. Yes. EM is a client tool which does not need to be licensed, because SQL
> Server is licensed.
That's not so. Client tools must ALWAYS be licensed. Tom either needs
to purchase a Server Processor licence or purchase a client licence for
each Enterprise Manager installation or user.
As to the other questions, if in doubt consult a Microsoft
representative but my understanding is that you cannot use Enterprise
Manager to manage MSDE installations.
David Portas, SQL Server MVP
Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.
SQL Server Books Online:
http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
|||Hi Greg,
1. Is then any possibility to buy just EM license as buying SQL Server
license and CALs is to expensive for using just MSDE.
Thanks,
Danijel Novak
"Greg Low [MVP]" <greglow@.lowell.com.au> wrote in message
news:uB742BoGGHA.376@.TK2MSFTNGP12.phx.gbl...
> Sorry Danijel & Tom, but:
> 1. No, you can't use SQL EM to manage the MSDE without a "real" SQL Server
> license being involved. EM is licensed via a client access license from a
> "real" SQL Server license.
> 2. Yes, if those systems have SQL Server CALs themselves.
> 3. Yes
> HTH,
> Greg
> "Danijel Novak" <danijel.novak@.triera.net> wrote in message
> news:ugwNzDnGGHA.1288@.TK2MSFTNGP09.phx.gbl...
>
|||Hi Danijel,
No, that's why myself and others have built tools to do this. Mine were at
www.whitebearconsulting.com. There is a free personal use license for MSDE
Manager there.
Tons of others can be found online, both free and paid. It will be less of
an issue now with SQL Server Express edition which I'd suggest you look
into.
HTH,
Greg
"Danijel Novak" <danijel.novak@.triera.net> wrote in message
news:%23j1h6ToGGHA.596@.TK2MSFTNGP10.phx.gbl...
> Hi Greg,
> 1. Is then any possibility to buy just EM license as buying SQL Server
> license and CALs is to expensive for using just MSDE.
> Thanks,
> --
> Danijel Novak
>
> "Greg Low [MVP]" <greglow@.lowell.com.au> wrote in message
> news:uB742BoGGHA.376@.TK2MSFTNGP12.phx.gbl...
>

Enterprise manager licencing

1. If someone is using SQL2000 MSDE, can he install enterprise manager to
manage it without SQL server licence?
2. If someone has a SQL2000 standard licence, can he install enterprise
manager (or any other CLIENT tools) to other client machines too?
3. SQL2005 express now has a GUI tool called Microsoft SQL Server Management
Studio Express that is free for download from Microsoft. Can it be used to
manage 2000 MSDE too?
Thanks
TomHi Tom,
1. Yes. EM is a client tool which does not need to be licensed, because SQL
Server is licensed.
2. Yes. See above.
3. I'm not sure, but I think it is possible.
--
Danijel Novak
"Tom" <mcseman@.hotmail.com> wrote in message
news:%23LyUS4hGGHA.648@.TK2MSFTNGP14.phx.gbl...
> 1. If someone is using SQL2000 MSDE, can he install enterprise manager to
> manage it without SQL server licence?
> 2. If someone has a SQL2000 standard licence, can he install enterprise
> manager (or any other CLIENT tools) to other client machines too?
> 3. SQL2005 express now has a GUI tool called Microsoft SQL Server
> Management Studio Express that is free for download from Microsoft. Can it
> be used to manage 2000 MSDE too?
> Thanks
> Tom
>|||Sorry Danijel & Tom, but:
1. No, you can't use SQL EM to manage the MSDE without a "real" SQL Server
license being involved. EM is licensed via a client access license from a
"real" SQL Server license.
2. Yes, if those systems have SQL Server CALs themselves.
3. Yes
HTH,
Greg
"Danijel Novak" <danijel.novak@.triera.net> wrote in message
news:ugwNzDnGGHA.1288@.TK2MSFTNGP09.phx.gbl...
> Hi Tom,
> 1. Yes. EM is a client tool which does not need to be licensed, because
> SQL Server is licensed.
> 2. Yes. See above.
> 3. I'm not sure, but I think it is possible.
> --
> Danijel Novak
>
> "Tom" <mcseman@.hotmail.com> wrote in message
> news:%23LyUS4hGGHA.648@.TK2MSFTNGP14.phx.gbl...
>> 1. If someone is using SQL2000 MSDE, can he install enterprise manager to
>> manage it without SQL server licence?
>> 2. If someone has a SQL2000 standard licence, can he install enterprise
>> manager (or any other CLIENT tools) to other client machines too?
>> 3. SQL2005 express now has a GUI tool called Microsoft SQL Server
>> Management Studio Express that is free for download from Microsoft. Can
>> it be used to manage 2000 MSDE too?
>> Thanks
>> Tom
>|||Danijel Novak wrote:
> Hi Tom,
> 1. Yes. EM is a client tool which does not need to be licensed, because SQL
> Server is licensed.
> 2. Yes. See above.
> 3. I'm not sure, but I think it is possible.
> --
> Danijel Novak
>
Danijel,
> 1. Yes. EM is a client tool which does not need to be licensed, because SQL
> Server is licensed.
That's not so. Client tools must ALWAYS be licensed. Tom either needs
to purchase a Server Processor licence or purchase a client licence for
each Enterprise Manager installation or user.
As to the other questions, if in doubt consult a Microsoft
representative but my understanding is that you cannot use Enterprise
Manager to manage MSDE installations.
--
David Portas, SQL Server MVP
Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.
SQL Server Books Online:
http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
--|||Hi Greg,
1. Is then any possibility to buy just EM license as buying SQL Server
license and CALs is to expensive for using just MSDE.
Thanks,
--
Danijel Novak
"Greg Low [MVP]" <greglow@.lowell.com.au> wrote in message
news:uB742BoGGHA.376@.TK2MSFTNGP12.phx.gbl...
> Sorry Danijel & Tom, but:
> 1. No, you can't use SQL EM to manage the MSDE without a "real" SQL Server
> license being involved. EM is licensed via a client access license from a
> "real" SQL Server license.
> 2. Yes, if those systems have SQL Server CALs themselves.
> 3. Yes
> HTH,
> Greg
> "Danijel Novak" <danijel.novak@.triera.net> wrote in message
> news:ugwNzDnGGHA.1288@.TK2MSFTNGP09.phx.gbl...
>> Hi Tom,
>> 1. Yes. EM is a client tool which does not need to be licensed, because
>> SQL Server is licensed.
>> 2. Yes. See above.
>> 3. I'm not sure, but I think it is possible.
>> --
>> Danijel Novak
>>
>> "Tom" <mcseman@.hotmail.com> wrote in message
>> news:%23LyUS4hGGHA.648@.TK2MSFTNGP14.phx.gbl...
>> 1. If someone is using SQL2000 MSDE, can he install enterprise manager
>> to manage it without SQL server licence?
>> 2. If someone has a SQL2000 standard licence, can he install enterprise
>> manager (or any other CLIENT tools) to other client machines too?
>> 3. SQL2005 express now has a GUI tool called Microsoft SQL Server
>> Management Studio Express that is free for download from Microsoft. Can
>> it be used to manage 2000 MSDE too?
>> Thanks
>> Tom
>>
>|||Hi Danijel,
No, that's why myself and others have built tools to do this. Mine were at
www.whitebearconsulting.com. There is a free personal use license for MSDE
Manager there.
Tons of others can be found online, both free and paid. It will be less of
an issue now with SQL Server Express edition which I'd suggest you look
into.
HTH,
Greg
"Danijel Novak" <danijel.novak@.triera.net> wrote in message
news:%23j1h6ToGGHA.596@.TK2MSFTNGP10.phx.gbl...
> Hi Greg,
> 1. Is then any possibility to buy just EM license as buying SQL Server
> license and CALs is to expensive for using just MSDE.
> Thanks,
> --
> Danijel Novak
>
> "Greg Low [MVP]" <greglow@.lowell.com.au> wrote in message
> news:uB742BoGGHA.376@.TK2MSFTNGP12.phx.gbl...
>> Sorry Danijel & Tom, but:
>> 1. No, you can't use SQL EM to manage the MSDE without a "real" SQL
>> Server license being involved. EM is licensed via a client access license
>> from a "real" SQL Server license.
>> 2. Yes, if those systems have SQL Server CALs themselves.
>> 3. Yes
>> HTH,
>> Greg
>> "Danijel Novak" <danijel.novak@.triera.net> wrote in message
>> news:ugwNzDnGGHA.1288@.TK2MSFTNGP09.phx.gbl...
>> Hi Tom,
>> 1. Yes. EM is a client tool which does not need to be licensed, because
>> SQL Server is licensed.
>> 2. Yes. See above.
>> 3. I'm not sure, but I think it is possible.
>> --
>> Danijel Novak
>>
>> "Tom" <mcseman@.hotmail.com> wrote in message
>> news:%23LyUS4hGGHA.648@.TK2MSFTNGP14.phx.gbl...
>> 1. If someone is using SQL2000 MSDE, can he install enterprise manager
>> to manage it without SQL server licence?
>> 2. If someone has a SQL2000 standard licence, can he install enterprise
>> manager (or any other CLIENT tools) to other client machines too?
>> 3. SQL2005 express now has a GUI tool called Microsoft SQL Server
>> Management Studio Express that is free for download from Microsoft. Can
>> it be used to manage 2000 MSDE too?
>> Thanks
>> Tom
>>
>>
>

Enterprise manager licencing

1. If someone is using SQL2000 MSDE, can he install enterprise manager to
manage it without SQL server licence?
2. If someone has a SQL2000 standard licence, can he install enterprise
manager (or any other CLIENT tools) to other client machines too?
3. SQL2005 express now has a GUI tool called Microsoft SQL Server Management
Studio Express that is free for download from Microsoft. Can it be used to
manage 2000 MSDE too?
Thanks
TomHi Tom,
1. Yes. EM is a client tool which does not need to be licensed, because SQL
Server is licensed.
2. Yes. See above.
3. I'm not sure, but I think it is possible.
Danijel Novak
"Tom" <mcseman@.hotmail.com> wrote in message
news:%23LyUS4hGGHA.648@.TK2MSFTNGP14.phx.gbl...
> 1. If someone is using SQL2000 MSDE, can he install enterprise manager to
> manage it without SQL server licence?
> 2. If someone has a SQL2000 standard licence, can he install enterprise
> manager (or any other CLIENT tools) to other client machines too?
> 3. SQL2005 express now has a GUI tool called Microsoft SQL Server
> Management Studio Express that is free for download from Microsoft. Can it
> be used to manage 2000 MSDE too?
> Thanks
> Tom
>|||Sorry Danijel & Tom, but:
1. No, you can't use SQL EM to manage the MSDE without a "real" SQL Server
license being involved. EM is licensed via a client access license from a
"real" SQL Server license.
2. Yes, if those systems have SQL Server CALs themselves.
3. Yes
HTH,
Greg
"Danijel Novak" <danijel.novak@.triera.net> wrote in message
news:ugwNzDnGGHA.1288@.TK2MSFTNGP09.phx.gbl...
> Hi Tom,
> 1. Yes. EM is a client tool which does not need to be licensed, because
> SQL Server is licensed.
> 2. Yes. See above.
> 3. I'm not sure, but I think it is possible.
> --
> Danijel Novak
>
> "Tom" <mcseman@.hotmail.com> wrote in message
> news:%23LyUS4hGGHA.648@.TK2MSFTNGP14.phx.gbl...
>|||Danijel Novak wrote:
> Hi Tom,
> 1. Yes. EM is a client tool which does not need to be licensed, because SQ
L
> Server is licensed.
> 2. Yes. See above.
> 3. I'm not sure, but I think it is possible.
> --
> Danijel Novak
>
Danijel,

> 1. Yes. EM is a client tool which does not need to be licensed, because SQ
L
> Server is licensed.
That's not so. Client tools must ALWAYS be licensed. Tom either needs
to purchase a Server Processor licence or purchase a client licence for
each Enterprise Manager installation or user.
As to the other questions, if in doubt consult a Microsoft
representative but my understanding is that you cannot use Enterprise
Manager to manage MSDE installations.
David Portas, SQL Server MVP
Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.
SQL Server Books Online:
http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
--|||Hi Greg,
1. Is then any possibility to buy just EM license as buying SQL Server
license and CALs is to expensive for using just MSDE.
Thanks,
Danijel Novak
"Greg Low [MVP]" <greglow@.lowell.com.au> wrote in message
news:uB742BoGGHA.376@.TK2MSFTNGP12.phx.gbl...
> Sorry Danijel & Tom, but:
> 1. No, you can't use SQL EM to manage the MSDE without a "real" SQL Server
> license being involved. EM is licensed via a client access license from a
> "real" SQL Server license.
> 2. Yes, if those systems have SQL Server CALs themselves.
> 3. Yes
> HTH,
> Greg
> "Danijel Novak" <danijel.novak@.triera.net> wrote in message
> news:ugwNzDnGGHA.1288@.TK2MSFTNGP09.phx.gbl...
>|||Hi Danijel,
No, that's why myself and others have built tools to do this. Mine were at
www.whitebearconsulting.com. There is a free personal use license for MSDE
Manager there.
Tons of others can be found online, both free and paid. It will be less of
an issue now with SQL Server Express edition which I'd suggest you look
into.
HTH,
Greg
"Danijel Novak" <danijel.novak@.triera.net> wrote in message
news:%23j1h6ToGGHA.596@.TK2MSFTNGP10.phx.gbl...
> Hi Greg,
> 1. Is then any possibility to buy just EM license as buying SQL Server
> license and CALs is to expensive for using just MSDE.
> Thanks,
> --
> Danijel Novak
>
> "Greg Low [MVP]" <greglow@.lowell.com.au> wrote in message
> news:uB742BoGGHA.376@.TK2MSFTNGP12.phx.gbl...
>

Enterprise Manager for MSDE

Howdy All,
How do I open Enterprise Manager for MSDE SP3?
I have installed MSDE as part of ACT! installation and have found references
to Enterprise Manager, but don't know how to get into it.
Thanks,
Brian
Enterprise Manager doesnt ship with MSDE, thats one of the limitations in
there. There are other free tools out there to use with the MSDE for
administering. For Queries there is QALite, which I think is a really good
one.
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
"Brian" <treddderx@.yahoo.com> schrieb im Newsbeitrag
news:uCgVoBiWFHA.3280@.TK2MSFTNGP09.phx.gbl...
> Howdy All,
> How do I open Enterprise Manager for MSDE SP3?
> I have installed MSDE as part of ACT! installation and have found
> references to Enterprise Manager, but don't know how to get into it.
> Thanks,
> Brian
>
|||Hi,
Microsoft is giving a free tool named "SQL Server Web data Administrator" to
manager and administrator the SQl server. This will be more useful to
MSDE users. Download the free tool from below site.
http://www.microsoft.com/downloads/d...displaylang=en
Thanks
Hari
SQL Server MVP
"Brian" <treddderx@.yahoo.com> wrote in message
news:uCgVoBiWFHA.3280@.TK2MSFTNGP09.phx.gbl...
> Howdy All,
> How do I open Enterprise Manager for MSDE SP3?
> I have installed MSDE as part of ACT! installation and have found
> references to Enterprise Manager, but don't know how to get into it.
> Thanks,
> Brian
>
|||Thanks for the help!
Very useful.
"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:ulsS4ylWFHA.2288@.TK2MSFTNGP14.phx.gbl...
> Hi,
> Microsoft is giving a free tool named "SQL Server Web data Administrator"
> to manager and administrator the SQl server. This will be more useful to
> MSDE users. Download the free tool from below site.
>
> http://www.microsoft.com/downloads/d...displaylang=en
>
> Thanks
> Hari
> SQL Server MVP
> "Brian" <treddderx@.yahoo.com> wrote in message
> news:uCgVoBiWFHA.3280@.TK2MSFTNGP09.phx.gbl...
>

Enterprise Manager and named instances

Hi, How to connect via internet to MSDE 2000 named instance using Enterprise
Manager?
On remote server (2K Server) there are installed MSDE 2000 default instance
and named instance. Named instance is using port 3077.
Adam,
in the Client Network utility define an alias which points to your
named instance and define the port number.
M

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

Is Enterprise Manager available as a separate download and installable on a
system with MSDE installed?
Are there any similar third-party tools?
Many thanks.
Am Fri, 11 Nov 2005 19:51:45 -0600 schrieb Andrew Chalk:

> Is Enterprise Manager available as a separate download and installable on a
> system with MSDE installed?
> Are there any similar third-party tools?
> Many thanks.
No, Enterprise Manager is not free, it's part of the 'big' SQL-Server,
where you have to pay for. You can manage MSDE with EM, yes, but you are
not allowed to copy EM from somebody or to give it away for free. You can
buy a SQL-Server Developer Edition CD from Microsoft (around 60$), this
includes an EM you can use for development.
Or you can use this free tool (can handle SQL2005 too!):
http://sqlmanager.net/en/products/mssql/manager
(the lite version is free)
bye,
Helmut
|||Thanks, I'll check it out.
- Andrew
"helmut woess" <hw@.iis.at> wrote in message
news:2pvy6t2z8b4o.1xpt7hatujbcl.dlg@.40tude.net...
> Am Fri, 11 Nov 2005 19:51:45 -0600 schrieb Andrew Chalk:
>
> No, Enterprise Manager is not free, it's part of the 'big' SQL-Server,
> where you have to pay for. You can manage MSDE with EM, yes, but you are
> not allowed to copy EM from somebody or to give it away for free. You can
> buy a SQL-Server Developer Edition CD from Microsoft (around 60$), this
> includes an EM you can use for development.
> Or you can use this free tool (can handle SQL2005 too!):
> http://sqlmanager.net/en/products/mssql/manager
> (the lite version is free)
> bye,
> Helmut