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 blocks network on XP

I'm running XP SP2 (and all the latest hotfixes) and administer a
bunch of SQL2000 servers. Whenever I have enterprise manager running,
I find that my network access seems to block regularly. What I mean by
that is, If I open Explorer and try to access network drives, explorer
will hang for 10-15 second before responding. The same thing occurs
for other apps that access network drives (open/save dialogs, apps
with directory tree windows, etc).
Is anyone else seeing this same behavior? Any idea how to trace
something like this? It isn't network related according to a sniffer -
it seems more similar to they type of blocking we used to see with old
ODBC-based applications.
Thanks
What happens if you turn off the server state polling in
Enterprise Manager? On the menu go to tools then select
options. Clear the checkbox for Server State Polling on the
General tab.
You'd also want to check the event logs if turning off the
polling makes no difference.
-Sue
On 27 Feb 2007 12:28:53 -0800, steven.cardinal@.gmail.com
wrote:

>I'm running XP SP2 (and all the latest hotfixes) and administer a
>bunch of SQL2000 servers. Whenever I have enterprise manager running,
>I find that my network access seems to block regularly. What I mean by
>that is, If I open Explorer and try to access network drives, explorer
>will hang for 10-15 second before responding. The same thing occurs
>for other apps that access network drives (open/save dialogs, apps
>with directory tree windows, etc).
>Is anyone else seeing this same behavior? Any idea how to trace
>something like this? It isn't network related according to a sniffer -
>it seems more similar to they type of blocking we used to see with old
>ODBC-based applications.
>Thanks
|||I am hesitantly optimistic. Since turning that off, things seem
better. I was aware of the option in each server registration about
showing the server state (which, if turned off prompts me everytime I
want to connect) but wasn't aware of the global polling option.
Thank you very, very, very, very much
Steve
On Feb 27, 11:32 pm, Sue Hoegemeier <S...@.nomail.please> wrote:[vbcol=seagreen]
> What happens if you turn off the server state polling in
> Enterprise Manager? On the menu go to tools then select
> options. Clear the checkbox for Server State Polling on the
> General tab.
> You'd also want to check the event logs if turning off the
> polling makes no difference.
> -Sue
> On 27 Feb 2007 12:28:53 -0800, steven.cardi...@.gmail.com
> wrote:
>

Enterprise Manager blocks network on XP

I'm running XP SP2 (and all the latest hotfixes) and administer a
bunch of SQL2000 servers. Whenever I have enterprise manager running,
I find that my network access seems to block regularly. What I mean by
that is, If I open Explorer and try to access network drives, explorer
will hang for 10-15 second before responding. The same thing occurs
for other apps that access network drives (open/save dialogs, apps
with directory tree windows, etc).
Is anyone else seeing this same behavior? Any idea how to trace
something like this? It isn't network related according to a sniffer -
it seems more similar to they type of blocking we used to see with old
ODBC-based applications.
ThanksWhat happens if you turn off the server state polling in
Enterprise Manager? On the menu go to tools then select
options. Clear the checkbox for Server State Polling on the
General tab.
You'd also want to check the event logs if turning off the
polling makes no difference.
-Sue
On 27 Feb 2007 12:28:53 -0800, steven.cardinal@.gmail.com
wrote:

>I'm running XP SP2 (and all the latest hotfixes) and administer a
>bunch of SQL2000 servers. Whenever I have enterprise manager running,
>I find that my network access seems to block regularly. What I mean by
>that is, If I open Explorer and try to access network drives, explorer
>will hang for 10-15 second before responding. The same thing occurs
>for other apps that access network drives (open/save dialogs, apps
>with directory tree windows, etc).
>Is anyone else seeing this same behavior? Any idea how to trace
>something like this? It isn't network related according to a sniffer -
>it seems more similar to they type of blocking we used to see with old
>ODBC-based applications.
>Thanks|||I am hesitantly optimistic. Since turning that off, things seem
better. I was aware of the option in each server registration about
showing the server state (which, if turned off prompts me everytime I
want to connect) but wasn't aware of the global polling option.
Thank you very, very, very, very much
Steve
On Feb 27, 11:32 pm, Sue Hoegemeier <S...@.nomail.please> wrote:[vbcol=seagreen]
> What happens if you turn off the server state polling in
> Enterprise Manager? On the menu go to tools then select
> options. Clear the checkbox for Server State Polling on the
> General tab.
> You'd also want to check the event logs if turning off the
> polling makes no difference.
> -Sue
> On 27 Feb 2007 12:28:53 -0800, steven.cardi...@.gmail.com
> wrote:
>
>
>

Enterprise Manager blocks network on XP

I'm running XP SP2 (and all the latest hotfixes) and administer a
bunch of SQL2000 servers. Whenever I have enterprise manager running,
I find that my network access seems to block regularly. What I mean by
that is, If I open Explorer and try to access network drives, explorer
will hang for 10-15 second before responding. The same thing occurs
for other apps that access network drives (open/save dialogs, apps
with directory tree windows, etc).
Is anyone else seeing this same behavior? Any idea how to trace
something like this? It isn't network related according to a sniffer -
it seems more similar to they type of blocking we used to see with old
ODBC-based applications.
ThanksWhat happens if you turn off the server state polling in
Enterprise Manager? On the menu go to tools then select
options. Clear the checkbox for Server State Polling on the
General tab.
You'd also want to check the event logs if turning off the
polling makes no difference.
-Sue
On 27 Feb 2007 12:28:53 -0800, steven.cardinal@.gmail.com
wrote:
>I'm running XP SP2 (and all the latest hotfixes) and administer a
>bunch of SQL2000 servers. Whenever I have enterprise manager running,
>I find that my network access seems to block regularly. What I mean by
>that is, If I open Explorer and try to access network drives, explorer
>will hang for 10-15 second before responding. The same thing occurs
>for other apps that access network drives (open/save dialogs, apps
>with directory tree windows, etc).
>Is anyone else seeing this same behavior? Any idea how to trace
>something like this? It isn't network related according to a sniffer -
>it seems more similar to they type of blocking we used to see with old
>ODBC-based applications.
>Thanks|||I am hesitantly optimistic. Since turning that off, things seem
better. I was aware of the option in each server registration about
showing the server state (which, if turned off prompts me everytime I
want to connect) but wasn't aware of the global polling option.
Thank you very, very, very, very much
Steve
On Feb 27, 11:32 pm, Sue Hoegemeier <S...@.nomail.please> wrote:
> What happens if you turn off the server state polling in
> Enterprise Manager? On the menu go to tools then select
> options. Clear the checkbox for Server State Polling on the
> General tab.
> You'd also want to check the event logs if turning off the
> polling makes no difference.
> -Sue
> On 27 Feb 2007 12:28:53 -0800, steven.cardi...@.gmail.com
> wrote:
> >I'm running XP SP2 (and all the latest hotfixes) and administer a
> >bunch of SQL2000 servers. Whenever I have enterprise manager running,
> >I find that my network access seems to block regularly. What I mean by
> >that is, If I open Explorer and try to access network drives, explorer
> >will hang for 10-15 second before responding. The same thing occurs
> >for other apps that access network drives (open/save dialogs, apps
> >with directory tree windows, etc).
> >Is anyone else seeing this same behavior? Any idea how to trace
> >something like this? It isn't network related according to a sniffer -
> >it seems more similar to they type of blocking we used to see with old
> >ODBC-based applications.
> >Thanks