Enterprise Manager?

If I understand correctly, Enterprise manager has been replaced with SQL Ser
ver 2005
Express?
Can I use SQL Server 2005 Express from my desktop to connect to an SQL 2000
database on
the internet?
Thanks,
VicAm Fri, 21 Jul 2006 23:14:27 -0400 schrieb Victor:

> If I understand correctly, Enterprise manager has been replaced with SQL S
erver 2005
> Express?
> Can I use SQL Server 2005 Express from my desktop to connect to an SQL 200
0 database on
> the internet?
> Thanks,
> Vic
You can use the new Server Management Studio Express to manage SQL2005 and
SQL2000, no problem. You can even use the old QueryAnalizer from SQL2000 to
work with SQL2005. Only EM is not compatible.
And if you connect over internet, then the only problems may be when
routers or firewalls are not right configured. I support all my clients, no
matter if MSDE, SQLExpress or any other server edition, over internet.
bye, Helmut|||"Helmut Woess" wrote...
> Am Fri, 21 Jul 2006 23:14:27 -0400 schrieb Victor:
>
on[vbcol=seagreen]
> You can use the new Server Management Studio Express to manage SQL2005 and
> SQL2000, no problem. You can even use the old QueryAnalizer from SQL2000 t
o
> work with SQL2005. Only EM is not compatible.
> And if you connect over internet, then the only problems may be when
> routers or firewalls are not right configured. I support all my clients, n
o
> matter if MSDE, SQLExpress or any other server edition, over internet.
> bye, Helmut
Thanks, Helmut!
From here:
http://msdn.microsoft.com/vstudio/express/sql/download/
I downloaded "SQL Server 2005 Express Edition with Advanced Services SP1" be
cause it
supports full-text search (which my SQL 2000 db uses). Is that all I need?
How does my firewall need to be configured? I assume that if I access my db
over the
Internet, Server Management Studio Express will require a particular port to
access my
db over the Internet.
Also, can Server Management Studio Express be used to access a remote mysql
database?
Thanks so much!!!
Vic

Enterprise Manager from desktop

Is there a way to install just the Enterprise Manager on my workstation so I
can access databases on our servers without having to install the whole SQL
Server 2000 program? Thanks.
David
Yes, install just the client tools. This can be done by only selecting the
"Client Tools Only" radio button on the "Installation Definition"
installation window.
----
Need SQL Server Examples check out my website at
http://www.geocities.com/sqlserverexamples
"David" <dlchase@.lifetimeinc.com> wrote in message
news:ew0zW4hUEHA.3988@.tk2msftngp13.phx.gbl...
> Is there a way to install just the Enterprise Manager on my workstation so
I
> can access databases on our servers without having to install the whole
SQL
> Server 2000 program? Thanks.
> David
>

Enterprise Manager from desktop

Is there a way to install just the Enterprise Manager on my workstation so I
can access databases on our servers without having to install the whole SQL
Server 2000 program? Thanks.
DavidYes, install just the client tools. This can be done by only selecting the
"Client Tools Only" radio button on the "Installation Definition"
installation window.
----
----
--
Need SQL Server Examples check out my website at
http://www.geocities.com/sqlserverexamples
"David" <dlchase@.lifetimeinc.com> wrote in message
news:ew0zW4hUEHA.3988@.tk2msftngp13.phx.gbl...
> Is there a way to install just the Enterprise Manager on my workstation so
I
> can access databases on our servers without having to install the whole
SQL
> Server 2000 program? Thanks.
> David
>

Enterprise Manager from desktop

Is there a way to install just the Enterprise Manager on my workstation so I
can access databases on our servers without having to install the whole SQL
Server 2000 program? Thanks.
DavidYes, install just the client tools. This can be done by only selecting the
"Client Tools Only" radio button on the "Installation Definition"
installation window.
----
----
--
Need SQL Server Examples check out my website at
http://www.geocities.com/sqlserverexamples
"David" <dlchase@.lifetimeinc.com> wrote in message
news:ew0zW4hUEHA.3988@.tk2msftngp13.phx.gbl...
> Is there a way to install just the Enterprise Manager on my workstation so
I
> can access databases on our servers without having to install the whole
SQL
> Server 2000 program? Thanks.
> David
>

Enterprise Manager crashes

Using SQL Server 2000 SP3 Developer Edition and MDAC 2.7

After installing SP3 to my desktop to inoculate against the Slammer worm, Enterprise Manager started crashing with the following whenever I try to open database properties with the following: The instruction at "0x4247b98b" referenced memory at "0x0000001c" could not be 'read'. I've reinstalled SQL Server and the MDAC to no avail. Has anyone else had this and are there any ideas for possible solutions?

ThanksYou might want to take a look at the error log to see which component is failing. There is a known issue with DTSUI.DLL after installing sp3. You will have to contact PSS to get the fix.

G'luck.|||Get SQLDMO.DLL from \Program Files\Microsoft SQL Server\80\Tools\Binn and SQLDMO.rll from Program Files\Microsoft SQL Server\80\Tools\Binn\Resources\1033 and Register it again using the REGSVR32 command.
We use to have the same problem now everything seems to be working fine.|||I was never able to get sqldmo.rll to register, as regsvr32 said that it only liked to register dll's and ocx's. But, moving the 2 files to the system32 folder replaced some really old ones and fixed the problem. Thanks for your help!|||Just be carefule the next time when you uninstall any user application as it tends to take away the SQLDMO.dll,which again results in the same thing.

enterprise manager cost?

I need to put enterprise mgr on a desktop at my office to administer a sql
server database that I am renting from a hosting service. The server is
shared at the hosting site and I pay only the monthly 39.00 for that right.
Do I have to buy enterprise manager to be legal. If so any idea how much it
would cost for a single processor, one user desktop computer?
thanks, leonThis one is tricky. For properly licensed copies of SQL Server
installations, which I am assuming your host has done on your behalf, there
is no additional charge for the installation nor use of the client-side
tools. However, it is unlikely that you will have port 1433 outbound open
on your company's firewall nor will the host likely have port 1433 inbound
opened to the SQL Server installation.
Normally, the host will provide terminal server sessions, in which case you
would use the remote installation of the client tools.
Sincerely,
Anthony Thomas
"enterprise manager cost?" <enterprise manager
cost?@.discussions.microsoft.com> wrote in message
news:11367BEF-6886-49FF-A5D7-B702AE964688@.microsoft.com...
> I need to put enterprise mgr on a desktop at my office to administer a sql
> server database that I am renting from a hosting service. The server is
> shared at the hosting site and I pay only the monthly 39.00 for that
right.
> Do I have to buy enterprise manager to be legal. If so any idea how much
it
> would cost for a single processor, one user desktop computer?
> thanks, leon|||Thanks for responding,
I orginally thought they would allow me to access through ts also but said I
would just be allowed to access that particular database which makes sense if
there are other people's databases on the server they wouldn't want to give
me access to the whole server.
I think I am just going to be given a domain.server name and once hooked up
only that database would appear because that is all I would have rights to.
I also don't think they are going to give me access to their copy of
Enterprise manager from there disk I will just be expected to provide it.
I found one company that offers an product to access from www.teratrax.com
but I am used to sql server tools and need the dts packages.
"AnthonyThomas" wrote:
> This one is tricky. For properly licensed copies of SQL Server
> installations, which I am assuming your host has done on your behalf, there
> is no additional charge for the installation nor use of the client-side
> tools. However, it is unlikely that you will have port 1433 outbound open
> on your company's firewall nor will the host likely have port 1433 inbound
> opened to the SQL Server installation.
> Normally, the host will provide terminal server sessions, in which case you
> would use the remote installation of the client tools.
> Sincerely,
>
> Anthony Thomas
>
> --
> "enterprise manager cost?" <enterprise manager
> cost?@.discussions.microsoft.com> wrote in message
> news:11367BEF-6886-49FF-A5D7-B702AE964688@.microsoft.com...
> > I need to put enterprise mgr on a desktop at my office to administer a sql
> > server database that I am renting from a hosting service. The server is
> > shared at the hosting site and I pay only the monthly 39.00 for that
> right.
> >
> > Do I have to buy enterprise manager to be legal. If so any idea how much
> it
> > would cost for a single processor, one user desktop computer?
> >
> > thanks, leon
>
>|||You could purchase the developers edition for around $50 -
you'd have all the client tools that way. Other options are
here: http://www.aspfaq.com/show.asp?id=2442
-Sue
On Thu, 11 Nov 2004 13:10:01 -0800, "LLittle"
<LLittle@.discussions.microsoft.com> wrote:
>Thanks for responding,
>I orginally thought they would allow me to access through ts also but said I
>would just be allowed to access that particular database which makes sense if
>there are other people's databases on the server they wouldn't want to give
>me access to the whole server.
>I think I am just going to be given a domain.server name and once hooked up
>only that database would appear because that is all I would have rights to.
>I also don't think they are going to give me access to their copy of
>Enterprise manager from there disk I will just be expected to provide it.
>I found one company that offers an product to access from www.teratrax.com
>but I am used to sql server tools and need the dts packages.
>
>
>"AnthonyThomas" wrote:
>> This one is tricky. For properly licensed copies of SQL Server
>> installations, which I am assuming your host has done on your behalf, there
>> is no additional charge for the installation nor use of the client-side
>> tools. However, it is unlikely that you will have port 1433 outbound open
>> on your company's firewall nor will the host likely have port 1433 inbound
>> opened to the SQL Server installation.
>> Normally, the host will provide terminal server sessions, in which case you
>> would use the remote installation of the client tools.
>> Sincerely,
>>
>> Anthony Thomas
>>
>> --
>> "enterprise manager cost?" <enterprise manager
>> cost?@.discussions.microsoft.com> wrote in message
>> news:11367BEF-6886-49FF-A5D7-B702AE964688@.microsoft.com...
>> > I need to put enterprise mgr on a desktop at my office to administer a sql
>> > server database that I am renting from a hosting service. The server is
>> > shared at the hosting site and I pay only the monthly 39.00 for that
>> right.
>> >
>> > Do I have to buy enterprise manager to be legal. If so any idea how much
>> it
>> > would cost for a single processor, one user desktop computer?
>> >
>> > thanks, leon
>>|||Sue Hoegemeier wrote:
> You could purchase the developers edition for around $50 -
> you'd have all the client tools that way. Other options are
> here: http://www.aspfaq.com/show.asp?id=2442
> -Sue
That wouldn't work legally.
You can use the SQL Server Web Administrator from MS without any
licensing requirements. I don't know that the ASP license for SQL Server
(what the ISP probably has) allows distribution of client tools. The web
data administrator should allow you to administer SQL Server from your
web browser.
http://www.microsoft.com/downloads/details.aspx?FamilyID=c039a798-c57a-419e-acbc-2a332cb7f959&displaylang=en
David Gugick
Imceda Software
www.imceda.com|||Depends on how it's licensed. I never heard of the ASP
license for SQL Server though - don't think there is such a
thing. See the link referenced for options - there are some
licensing explanations for the different options.
-Sue
On Thu, 11 Nov 2004 23:13:01 -0500, "David Gugick"
<davidg-nospam@.imceda.com> wrote:
>Sue Hoegemeier wrote:
>> You could purchase the developers edition for around $50 -
>> you'd have all the client tools that way. Other options are
>> here: http://www.aspfaq.com/show.asp?id=2442
>> -Sue
>That wouldn't work legally.
>You can use the SQL Server Web Administrator from MS without any
>licensing requirements. I don't know that the ASP license for SQL Server
>(what the ISP probably has) allows distribution of client tools. The web
>data administrator should allow you to administer SQL Server from your
>web browser.
>http://www.microsoft.com/downloads/details.aspx?FamilyID=c039a798-c57a-419e-acbc-2a332cb7f959&displaylang=en|||See the end of Brian's article for a note about using SQL Server in an
ASP environment:
http://www.developer.com/tech/article.php/630451
From Microsoft:
http://www.microsoft.com/serviceproviders/licensing/licensing.asp
David Gugick
Imceda Software
www.imceda.com

enterprise manager cost?

I need to put enterprise mgr on a desktop at my office to administer a sql
server database that I am renting from a hosting service. The server is
shared at the hosting site and I pay only the monthly 39.00 for that right.
Do I have to buy enterprise manager to be legal. If so any idea how much it
would cost for a single processor, one user desktop computer?
thanks, leon
This one is tricky. For properly licensed copies of SQL Server
installations, which I am assuming your host has done on your behalf, there
is no additional charge for the installation nor use of the client-side
tools. However, it is unlikely that you will have port 1433 outbound open
on your company's firewall nor will the host likely have port 1433 inbound
opened to the SQL Server installation.
Normally, the host will provide terminal server sessions, in which case you
would use the remote installation of the client tools.
Sincerely,
Anthony Thomas

"enterprise manager cost?" <enterprise manager
cost?@.discussions.microsoft.com> wrote in message
news:11367BEF-6886-49FF-A5D7-B702AE964688@.microsoft.com...
> I need to put enterprise mgr on a desktop at my office to administer a sql
> server database that I am renting from a hosting service. The server is
> shared at the hosting site and I pay only the monthly 39.00 for that
right.
> Do I have to buy enterprise manager to be legal. If so any idea how much
it
> would cost for a single processor, one user desktop computer?
> thanks, leon
|||Thanks for responding,
I orginally thought they would allow me to access through ts also but said I
would just be allowed to access that particular database which makes sense if
there are other people's databases on the server they wouldn't want to give
me access to the whole server.
I think I am just going to be given a domain.server name and once hooked up
only that database would appear because that is all I would have rights to.
I also don't think they are going to give me access to their copy of
Enterprise manager from there disk I will just be expected to provide it.
I found one company that offers an product to access from www.teratrax.com
but I am used to sql server tools and need the dts packages.
"AnthonyThomas" wrote:

> This one is tricky. For properly licensed copies of SQL Server
> installations, which I am assuming your host has done on your behalf, there
> is no additional charge for the installation nor use of the client-side
> tools. However, it is unlikely that you will have port 1433 outbound open
> on your company's firewall nor will the host likely have port 1433 inbound
> opened to the SQL Server installation.
> Normally, the host will provide terminal server sessions, in which case you
> would use the remote installation of the client tools.
> Sincerely,
>
> Anthony Thomas
>
> --
> "enterprise manager cost?" <enterprise manager
> cost?@.discussions.microsoft.com> wrote in message
> news:11367BEF-6886-49FF-A5D7-B702AE964688@.microsoft.com...
> right.
> it
>
>
|||You could purchase the developers edition for around $50 -
you'd have all the client tools that way. Other options are
here: http://www.aspfaq.com/show.asp?id=2442
-Sue
On Thu, 11 Nov 2004 13:10:01 -0800, "LLittle"
<LLittle@.discussions.microsoft.com> wrote:
[vbcol=seagreen]
>Thanks for responding,
>I orginally thought they would allow me to access through ts also but said I
>would just be allowed to access that particular database which makes sense if
>there are other people's databases on the server they wouldn't want to give
>me access to the whole server.
>I think I am just going to be given a domain.server name and once hooked up
>only that database would appear because that is all I would have rights to.
>I also don't think they are going to give me access to their copy of
>Enterprise manager from there disk I will just be expected to provide it.
>I found one company that offers an product to access from www.teratrax.com
>but I am used to sql server tools and need the dts packages.
>
>
>"AnthonyThomas" wrote:
|||Sue Hoegemeier wrote:
> You could purchase the developers edition for around $50 -
> you'd have all the client tools that way. Other options are
> here: http://www.aspfaq.com/show.asp?id=2442
> -Sue
That wouldn't work legally.
You can use the SQL Server Web Administrator from MS without any
licensing requirements. I don't know that the ASP license for SQL Server
(what the ISP probably has) allows distribution of client tools. The web
data administrator should allow you to administer SQL Server from your
web browser.
http://www.microsoft.com/downloads/d...displaylang=en
David Gugick
Imceda Software
www.imceda.com
|||Depends on how it's licensed. I never heard of the ASP
license for SQL Server though - don't think there is such a
thing. See the link referenced for options - there are some
licensing explanations for the different options.
-Sue
On Thu, 11 Nov 2004 23:13:01 -0500, "David Gugick"
<davidg-nospam@.imceda.com> wrote:

>Sue Hoegemeier wrote:
>That wouldn't work legally.
>You can use the SQL Server Web Administrator from MS without any
>licensing requirements. I don't know that the ASP license for SQL Server
>(what the ISP probably has) allows distribution of client tools. The web
>data administrator should allow you to administer SQL Server from your
>web browser.
>http://www.microsoft.com/downloads/d...displaylang=en
|||See the end of Brian's article for a note about using SQL Server in an
ASP environment:
http://www.developer.com/tech/article.php/630451
From Microsoft:
http://www.microsoft.com/serviceprov.../licensing.asp
David Gugick
Imceda Software
www.imceda.com

enterprise manager cost?

I need to put enterprise mgr on a desktop at my office to administer a sql
server database that I am renting from a hosting service. The server is
shared at the hosting site and I pay only the monthly 39.00 for that right.
Do I have to buy enterprise manager to be legal. If so any idea how much it
would cost for a single processor, one user desktop computer?
thanks, leonThis one is tricky. For properly licensed copies of SQL Server
installations, which I am assuming your host has done on your behalf, there
is no additional charge for the installation nor use of the client-side
tools. However, it is unlikely that you will have port 1433 outbound open
on your company's firewall nor will the host likely have port 1433 inbound
opened to the SQL Server installation.
Normally, the host will provide terminal server sessions, in which case you
would use the remote installation of the client tools.
Sincerely,
Anthony Thomas
"enterprise manager cost?" <enterprise manager
cost?@.discussions.microsoft.com> wrote in message
news:11367BEF-6886-49FF-A5D7-B702AE964688@.microsoft.com...
> I need to put enterprise mgr on a desktop at my office to administer a sql
> server database that I am renting from a hosting service. The server is
> shared at the hosting site and I pay only the monthly 39.00 for that
right.
> Do I have to buy enterprise manager to be legal. If so any idea how much
it
> would cost for a single processor, one user desktop computer?
> thanks, leon|||Thanks for responding,
I orginally thought they would allow me to access through ts also but said I
would just be allowed to access that particular database which makes sense i
f
there are other people's databases on the server they wouldn't want to give
me access to the whole server.
I think I am just going to be given a domain.server name and once hooked up
only that database would appear because that is all I would have rights to.
I also don't think they are going to give me access to their copy of
Enterprise manager from there disk I will just be expected to provide it.
I found one company that offers an product to access from www.teratrax.com
but I am used to sql server tools and need the dts packages.
"AnthonyThomas" wrote:

> This one is tricky. For properly licensed copies of SQL Server
> installations, which I am assuming your host has done on your behalf, ther
e
> is no additional charge for the installation nor use of the client-side
> tools. However, it is unlikely that you will have port 1433 outbound open
> on your company's firewall nor will the host likely have port 1433 inbound
> opened to the SQL Server installation.
> Normally, the host will provide terminal server sessions, in which case yo
u
> would use the remote installation of the client tools.
> Sincerely,
>
> Anthony Thomas
>
> --
> "enterprise manager cost?" <enterprise manager
> cost?@.discussions.microsoft.com> wrote in message
> news:11367BEF-6886-49FF-A5D7-B702AE964688@.microsoft.com...
> right.
> it
>
>|||You could purchase the developers edition for around $50 -
you'd have all the client tools that way. Other options are
here: http://www.aspfaq.com/show.asp?id=2442
-Sue
On Thu, 11 Nov 2004 13:10:01 -0800, "LLittle"
<LLittle@.discussions.microsoft.com> wrote:
[vbcol=seagreen]
>Thanks for responding,
>I orginally thought they would allow me to access through ts also but said
I
>would just be allowed to access that particular database which makes sense
if
>there are other people's databases on the server they wouldn't want to give
>me access to the whole server.
>I think I am just going to be given a domain.server name and once hooked up
>only that database would appear because that is all I would have rights to.
>I also don't think they are going to give me access to their copy of
>Enterprise manager from there disk I will just be expected to provide it.
>I found one company that offers an product to access from www.teratrax.com
>but I am used to sql server tools and need the dts packages.
>
>
>"AnthonyThomas" wrote:
>|||Sue Hoegemeier wrote:
> You could purchase the developers edition for around $50 -
> you'd have all the client tools that way. Other options are
> here: http://www.aspfaq.com/show.asp?id=2442
> -Sue
That wouldn't work legally.
You can use the SQL Server Web Administrator from MS without any
licensing requirements. I don't know that the ASP license for SQL Server
(what the ISP probably has) allows distribution of client tools. The web
data administrator should allow you to administer SQL Server from your
web browser.
http://www.microsoft.com/downloads/...&displaylang=en
David Gugick
Imceda Software
www.imceda.com|||Depends on how it's licensed. I never heard of the ASP
license for SQL Server though - don't think there is such a
thing. See the link referenced for options - there are some
licensing explanations for the different options.
-Sue
On Thu, 11 Nov 2004 23:13:01 -0500, "David Gugick"
<davidg-nospam@.imceda.com> wrote:

>Sue Hoegemeier wrote:
>That wouldn't work legally.
>You can use the SQL Server Web Administrator from MS without any
>licensing requirements. I don't know that the ASP license for SQL Server
>(what the ISP probably has) allows distribution of client tools. The web
>data administrator should allow you to administer SQL Server from your
>web browser.
>http://www.microsoft.com/downloads/...&displaylang=en|||See the end of Brian's article for a note about using SQL Server in an
ASP environment:
http://www.developer.com/tech/article.php/630451
From Microsoft:
http://www.microsoft.com/servicepro...g/licensing.asp
David Gugick
Imceda Software
www.imceda.com

Enterprise Manager Availability

Hi there,
I currently have SQL7 installed on a webserver, and have the Enterprise
Manager installed on my desktop. I have just purchased another dedicated
server but this one has SQL2000. Since the host installed SQL2000 I do
not have install disks so can not install Enterprise Manager.
When I tried to connect with my Enterprise Manager to the new SQL2000
manager I am told I need another version.
Is the SQL2000 version available for download anywhere?
Steve
No (not regarding any eval version). You need to get a media containing
the EM from your hoster, or use one of the free admin tools:
http://www.aspfaq.com/show.asp?id=2442
HTH, Jens Suessmeyer.
|||Jens wrote:
> No (not regarding any eval version). You need to get a media containing
> the EM from your hoster, or use one of the free admin tools:
> http://www.aspfaq.com/show.asp?id=2442
> HTH, Jens Suessmeyer.
>
Hi Jens,
Thanks for your help, I thought that may be the case. I remember
downloading an eval of SQL7 some years ago and I could install EM from
that. Is this not the case anymore?
Steve
|||As an off the wall work around, get either a CTP for SS2005 or wait a couple
of weeks and get the production version. I have the June CTP and it connects
to SS2K fine. It is the future anyway.
Joseph R.P. Maloney, CSP,CCP,CDP
"Dooza" wrote:

> Hi there,
> I currently have SQL7 installed on a webserver, and have the Enterprise
> Manager installed on my desktop. I have just purchased another dedicated
> server but this one has SQL2000. Since the host installed SQL2000 I do
> not have install disks so can not install Enterprise Manager.
> When I tried to connect with my Enterprise Manager to the new SQL2000
> manager I am told I need another version.
> Is the SQL2000 version available for download anywhere?
> Steve
>
|||jrpm wrote:
> As an off the wall work around, get either a CTP for SS2005 or wait a couple
> of weeks and get the production version. I have the June CTP and it connects
> to SS2K fine. It is the future anyway.
What is a CTP?
Steve
|||Community Technical Preview of SQL Server 2005.
Jens Suessmeyer.
|||Jens wrote:
> Community Technical Preview of SQL Server 2005.
> Jens Suessmeyer.
>
Ah, right, I see. Thanks for the info.
Steve

Enterprise Manager Availability

Hi there,
I currently have SQL7 installed on a webserver, and have the Enterprise
Manager installed on my desktop. I have just purchased another dedicated
server but this one has SQL2000. Since the host installed SQL2000 I do
not have install disks so can not install Enterprise Manager.
When I tried to connect with my Enterprise Manager to the new SQL2000
manager I am told I need another version.
Is the SQL2000 version available for download anywhere?
SteveNo (not regarding any eval version). You need to get a media containing
the EM from your hoster, or use one of the free admin tools:
http://www.aspfaq.com/show.asp?id=2442
HTH, Jens Suessmeyer.|||Jens wrote:
> No (not regarding any eval version). You need to get a media containing
> the EM from your hoster, or use one of the free admin tools:
> http://www.aspfaq.com/show.asp?id=2442
> HTH, Jens Suessmeyer.
>
Hi Jens,
Thanks for your help, I thought that may be the case. I remember
downloading an eval of SQL7 some years ago and I could install EM from
that. Is this not the case anymore?
Steve|||As an off the wall work around, get either a CTP for SS2005 or wait a couple
of weeks and get the production version. I have the June CTP and it connects
to SS2K fine. It is the future anyway.
--
Joseph R.P. Maloney, CSP,CCP,CDP
"Dooza" wrote:

> Hi there,
> I currently have SQL7 installed on a webserver, and have the Enterprise
> Manager installed on my desktop. I have just purchased another dedicated
> server but this one has SQL2000. Since the host installed SQL2000 I do
> not have install disks so can not install Enterprise Manager.
> When I tried to connect with my Enterprise Manager to the new SQL2000
> manager I am told I need another version.
> Is the SQL2000 version available for download anywhere?
> Steve
>|||jrpm wrote:
> As an off the wall work around, get either a CTP for SS2005 or wait a coup
le
> of weeks and get the production version. I have the June CTP and it connec
ts
> to SS2K fine. It is the future anyway.
What is a CTP?
Steve|||Community Technical Preview of SQL Server 2005.
Jens Suessmeyer.|||Jens wrote:
> Community Technical Preview of SQL Server 2005.
> Jens Suessmeyer.
>
Ah, right, I see. Thanks for the info.
Steve

Enterprise Manager Availability

Hi there,
I currently have SQL7 installed on a webserver, and have the Enterprise
Manager installed on my desktop. I have just purchased another dedicated
server but this one has SQL2000. Since the host installed SQL2000 I do
not have install disks so can not install Enterprise Manager.
When I tried to connect with my Enterprise Manager to the new SQL2000
manager I am told I need another version.
Is the SQL2000 version available for download anywhere?
SteveNo (not regarding any eval version). You need to get a media containing
the EM from your hoster, or use one of the free admin tools:
http://www.aspfaq.com/show.asp?id=2442
HTH, Jens Suessmeyer.|||Jens wrote:
> No (not regarding any eval version). You need to get a media containing
> the EM from your hoster, or use one of the free admin tools:
> http://www.aspfaq.com/show.asp?id=2442
> HTH, Jens Suessmeyer.
>
Hi Jens,
Thanks for your help, I thought that may be the case. I remember
downloading an eval of SQL7 some years ago and I could install EM from
that. Is this not the case anymore?
Steve|||As an off the wall work around, get either a CTP for SS2005 or wait a couple
of weeks and get the production version. I have the June CTP and it connects
to SS2K fine. It is the future anyway.
--
Joseph R.P. Maloney, CSP,CCP,CDP
"Dooza" wrote:
> Hi there,
> I currently have SQL7 installed on a webserver, and have the Enterprise
> Manager installed on my desktop. I have just purchased another dedicated
> server but this one has SQL2000. Since the host installed SQL2000 I do
> not have install disks so can not install Enterprise Manager.
> When I tried to connect with my Enterprise Manager to the new SQL2000
> manager I am told I need another version.
> Is the SQL2000 version available for download anywhere?
> Steve
>|||jrpm wrote:
> As an off the wall work around, get either a CTP for SS2005 or wait a couple
> of weeks and get the production version. I have the June CTP and it connects
> to SS2K fine. It is the future anyway.
What is a CTP?
Steve|||Community Technical Preview of SQL Server 2005.
Jens Suessmeyer.|||Jens wrote:
> Community Technical Preview of SQL Server 2005.
> Jens Suessmeyer.
>
Ah, right, I see. Thanks for the info.
Steve

Enterprise Manager

I've got SQL Server 2000 tools-only installed on my desktop and have a
bunch of servers registered within Enterprise Manager. Every time I
connect to one of my registered servers then right-click and select
Properties, Enterprise Manager closes on me. I never receive an error,
it just closes. As far as I know, I've applied all the same service
packs and hotfixes to my tools-only install as we have on each of the
servers so versions should be the same.
What can I do to resolve this?
Toni
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!
I have not experienced this error. Are the servers SQL7 (not that this
should matter)? If you have not applied SQL Server 2000 SP3 on your client
system you might want to do that. It will update a few binaries. Perhaps
this will help solve your problem.
Keith
"Toni" <teibner@.nospam.allina.com> wrote in message
news:%239749jDuEHA.2596@.TK2MSFTNGP15.phx.gbl...
> I've got SQL Server 2000 tools-only installed on my desktop and have a
> bunch of servers registered within Enterprise Manager. Every time I
> connect to one of my registered servers then right-click and select
> Properties, Enterprise Manager closes on me. I never receive an error,
> it just closes. As far as I know, I've applied all the same service
> packs and hotfixes to my tools-only install as we have on each of the
> servers so versions should be the same.
> What can I do to resolve this?
> Toni
> *** Sent via Developersdex http://www.codecomments.com ***
> Don't just participate in USENET...get rewarded for it!
|||The registered servers are both SQL 7 and SQL 2000. I've already
applied the latest patches (sp3a + ms03-031 and KB826161). Any other
ideas (other than just deal with it or call Microsoft)?
Thanks.
Toni
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!