Sql Enterprise Edition: service

Showing posts with label service. Show all posts

Thursday, March 22, 2012

Enterprise manger won't connect

Installed SQL 2000 on a completely up to date windows 2003 advanced server,
then applied sp3a, then I installed reporting service developer addition,
then installed VS .net 2003 the reinstalled reporting services to get the
Report Developer.
Now I can't connect to the Server using EM.
I Get "SQL_alloc_handle on SQL_handle_env failed"
Tried all types of registrations.
Seems to be some sort of ODBC problem since I can attach to the database
remotely from access.
Any suggestions short of starting from scratch?I haven't encountered this particular problem, but I'd suggest you could try
re-intalling the SQL client tools only & see if that solves your problems.
Regards,
Greg Linwood
SQL Server MVP
"sdrexler" <sdrexler@.nospam.optonline.net> wrote in message
news:OB0VFOO9DHA.2944@.TK2MSFTNGP11.phx.gbl...
> Installed SQL 2000 on a completely up to date windows 2003 advanced
server,
> then applied sp3a, then I installed reporting service developer addition,
> then installed VS .net 2003 the reinstalled reporting services to get the
> Report Developer.
> Now I can't connect to the Server using EM.
> I Get "SQL_alloc_handle on SQL_handle_env failed"
> Tried all types of registrations.
> Seems to be some sort of ODBC problem since I can attach to the database
> remotely from access.
> Any suggestions short of starting from scratch?
>|||Thanks, I will give it a try.
"Greg Linwood" <g_linwoodQhotmail.com> wrote in message
news:eYlgmYO9DHA.2656@.TK2MSFTNGP11.phx.gbl...
> I haven't encountered this particular problem, but I'd suggest you could
try
> re-intalling the SQL client tools only & see if that solves your problems.
> Regards,
> Greg Linwood
> SQL Server MVP
> "sdrexler" <sdrexler@.nospam.optonline.net> wrote in message
> news:OB0VFOO9DHA.2944@.TK2MSFTNGP11.phx.gbl...
> > Installed SQL 2000 on a completely up to date windows 2003 advanced
> server,
> > then applied sp3a, then I installed reporting service developer
addition,
> > then installed VS .net 2003 the reinstalled reporting services to get
the
> > Report Developer.
> >
> > Now I can't connect to the Server using EM.
> >
> > I Get "SQL_alloc_handle on SQL_handle_env failed"
> >
> > Tried all types of registrations.
> >
> > Seems to be some sort of ODBC problem since I can attach to the database
> > remotely from access.
> >
> > Any suggestions short of starting from scratch?
> >
> >
>|||I solved the problem. Installing VS.net 2003 overwrote the ODBC and SQL
related DLL's in the windows\system32 directory. Restoring them fixed the
problem.
"Greg Linwood" <g_linwoodQhotmail.com> wrote in message
news:eYlgmYO9DHA.2656@.TK2MSFTNGP11.phx.gbl...
> I haven't encountered this particular problem, but I'd suggest you could
try
> re-intalling the SQL client tools only & see if that solves your problems.
> Regards,
> Greg Linwood
> SQL Server MVP
> "sdrexler" <sdrexler@.nospam.optonline.net> wrote in message
> news:OB0VFOO9DHA.2944@.TK2MSFTNGP11.phx.gbl...
> > Installed SQL 2000 on a completely up to date windows 2003 advanced
> server,
> > then applied sp3a, then I installed reporting service developer
addition,
> > then installed VS .net 2003 the reinstalled reporting services to get
the
> > Report Developer.
> >
> > Now I can't connect to the Server using EM.
> >
> > I Get "SQL_alloc_handle on SQL_handle_env failed"
> >
> > Tried all types of registrations.
> >
> > Seems to be some sort of ODBC problem since I can attach to the database
> > remotely from access.
> >
> > Any suggestions short of starting from scratch?
> >
> >
>|||Thanks for the feedback
Regards,
Greg Linwood
SQL Server MVP
"sdrexler" <sdrexler@.nospam.optonline.net> wrote in message
news:eHipkUyAEHA.3988@.tk2msftngp13.phx.gbl...
> I solved the problem. Installing VS.net 2003 overwrote the ODBC and SQL
> related DLL's in the windows\system32 directory. Restoring them fixed the
> problem.
> "Greg Linwood" <g_linwoodQhotmail.com> wrote in message
> news:eYlgmYO9DHA.2656@.TK2MSFTNGP11.phx.gbl...
> > I haven't encountered this particular problem, but I'd suggest you could
> try
> > re-intalling the SQL client tools only & see if that solves your
problems.
> >
> > Regards,
> > Greg Linwood
> > SQL Server MVP
> >
> > "sdrexler" <sdrexler@.nospam.optonline.net> wrote in message
> > news:OB0VFOO9DHA.2944@.TK2MSFTNGP11.phx.gbl...
> > > Installed SQL 2000 on a completely up to date windows 2003 advanced
> > server,
> > > then applied sp3a, then I installed reporting service developer
> addition,
> > > then installed VS .net 2003 the reinstalled reporting services to get
> the
> > > Report Developer.
> > >
> > > Now I can't connect to the Server using EM.
> > >
> > > I Get "SQL_alloc_handle on SQL_handle_env failed"
> > >
> > > Tried all types of registrations.
> > >
> > > Seems to be some sort of ODBC problem since I can attach to the
database
> > > remotely from access.
> > >
> > > Any suggestions short of starting from scratch?
> > >
> > >
> >
> >
>

Enterprise manger won't connect

Wednesday, March 21, 2012

Enterprise Manager version

Hello,
I noticed that the version of my Entrprise Manager does not reflect service pack 3a. When I right click on Microsoft SQL Servers below the Console Root tree and I select About Sql Server Entrprise Manager, it shows version 8.00.194. When I check Query An
alyzer in the Help Menu, I get the correct version of service pack 3a which is 8.00.760. I tried re-applying the service pack and rebooting and it still shows the incorrect version. Because of this, I am getting incorrect info through Taskpad View for the
correct table sizes in my database. Any ideas?
Thanks,
Nupee
> I noticed that the version of my Entrprise Manager does not reflect
service pack 3a. When I right click on Microsoft SQL Servers below the
Console Root tree and I select About Sql Server Entrprise Manager, it shows
version 8.00.194.
I only see Version 8.0, no .194 suffix.

> I am getting incorrect info through Taskpad View for the correct table
sizes in my database.
Why do you think this is because of your version? Try updating statistics
for the database.
http://www.aspfaq.com/
(Reverse address to reply.)
|||I forgot to mention that this is through my SQL Server 2000 client addition on my desktop. There is nothing wrong with the actual SQL Server. I seem to be the only one in my group experiencing this problem. I am currently using Windows XP professional. Da
tabase statistics have been updated and the result is the same.
"Aaron [SQL Server MVP]" wrote:

> service pack 3a. When I right click on Microsoft SQL Servers below the
> Console Root tree and I select About Sql Server Entrprise Manager, it shows
> version 8.00.194.
> I only see Version 8.0, no .194 suffix.
> sizes in my database.
> Why do you think this is because of your version? Try updating statistics
> for the database.
> --
> http://www.aspfaq.com/
> (Reverse address to reply.)
>
>
|||Then you need to apply SP3 to your machine! But I still don't think that
will produce inaccurate table size results in the taskpad view. This is
because the statistics are out of date.
http://www.aspfaq.com/
(Reverse address to reply.)
"nupee" <nupee@.discussions.microsoft.com> wrote in message
news:D1FEBDD3-9DB0-446D-800B-622E44145AF2@.microsoft.com...
> I forgot to mention that this is through my SQL Server 2000 client
addition on my desktop. There is nothing wrong with the actual SQL Server. I
seem to be the only one in my group experiencing this problem. I am
currently using Windows XP professional. Database statistics have been
updated and the result is the same.
|||I have applied SP3 several times. Don't forget even without using Taskpad, when I check the version of my Entrprise Manager addition, it still does not reflect the SP3 being applied. I don't think this is a database issue. I think it's a SQL Client issue.
"Aaron [SQL Server MVP]" wrote:

> Then you need to apply SP3 to your machine! But I still don't think that
> will produce inaccurate table size results in the taskpad view. This is
> because the statistics are out of date.
> --
> http://www.aspfaq.com/
> (Reverse address to reply.)
>
>
> "nupee" <nupee@.discussions.microsoft.com> wrote in message
> news:D1FEBDD3-9DB0-446D-800B-622E44145AF2@.microsoft.com...
> addition on my desktop. There is nothing wrong with the actual SQL Server. I
> seem to be the only one in my group experiencing this problem. I am
> currently using Windows XP professional. Database statistics have been
> updated and the result is the same.
>
>
|||> I have applied SP3 several times.
<sigh>
Is the client tools installation the *ONLY* instance of SQL Server you have
installed?
|||Yes that is the only instance. However, I do have reporting services loaded as well.
"Aaron [SQL Server MVP]" wrote:

> <sigh>
> Is the client tools installation the *ONLY* instance of SQL Server you have
> installed?
>
>
|||Just as an F.Y.I......I was able to resolve this problem by re-applying sp 3a using a dos prompt and running the setup.bat file. When I tried to apply the sp 3a through the setup.exe it didnot work. Strange Huh !!...Thanks away for your help.
"nupee" wrote:
[vbcol=seagreen]
> Yes that is the only instance. However, I do have reporting services loaded as well.
> "Aaron [SQL Server MVP]" wrote:

Enterprise Manager version

Hello,
I noticed that the version of my Entrprise Manager does not reflect service
pack 3a. When I right click on Microsoft SQL Servers below the Console Root
tree and I select About Sql Server Entrprise Manager, it shows version 8.00
.194. When I check Query An
alyzer in the Help Menu, I get the correct version of service pack 3a which
is 8.00.760. I tried re-applying the service pack and rebooting and it still
shows the incorrect version. Because of this, I am getting incorrect info t
hrough Taskpad View for the
correct table sizes in my database. Any ideas'
Thanks,
Nupee> I noticed that the version of my Entrprise Manager does not reflect
service pack 3a. When I right click on Microsoft SQL Servers below the
Console Root tree and I select About Sql Server Entrprise Manager, it shows
version 8.00.194.
I only see Version 8.0, no .194 suffix.

> I am getting incorrect info through Taskpad View for the correct table
sizes in my database.
Why do you think this is because of your version? Try updating statistics
for the database.
http://www.aspfaq.com/
(Reverse address to reply.)|||I forgot to mention that this is through my SQL Server 2000 client addition
on my desktop. There is nothing wrong with the actual SQL Server. I seem to
be the only one in my group experiencing this problem. I am currently using
Windows XP professional. Da
tabase statistics have been updated and the result is the same.
"Aaron [SQL Server MVP]" wrote:

> service pack 3a. When I right click on Microsoft SQL Servers below the
> Console Root tree and I select About Sql Server Entrprise Manager, it sho
ws
> version 8.00.194.
> I only see Version 8.0, no .194 suffix.
>
> sizes in my database.
> Why do you think this is because of your version? Try updating statistics
> for the database.
> --
> http://www.aspfaq.com/
> (Reverse address to reply.)
>
>|||Then you need to apply SP3 to your machine! But I still don't think that
will produce inaccurate table size results in the taskpad view. This is
because the statistics are out of date.
http://www.aspfaq.com/
(Reverse address to reply.)
"nupee" <nupee@.discussions.microsoft.com> wrote in message
news:D1FEBDD3-9DB0-446D-800B-622E44145AF2@.microsoft.com...
> I forgot to mention that this is through my SQL Server 2000 client
addition on my desktop. There is nothing wrong with the actual SQL Server. I
seem to be the only one in my group experiencing this problem. I am
currently using Windows XP professional. Database statistics have been
updated and the result is the same.|||I have applied SP3 several times. Don't forget even without using Taskpad, w
hen I check the version of my Entrprise Manager addition, it still does not
reflect the SP3 being applied. I don't think this is a database issue. I thi
nk it's a SQL Client issue.
"Aaron [SQL Server MVP]" wrote:

> Then you need to apply SP3 to your machine! But I still don't think that
> will produce inaccurate table size results in the taskpad view. This is
> because the statistics are out of date.
> --
> http://www.aspfaq.com/
> (Reverse address to reply.)
>
>
> "nupee" <nupee@.discussions.microsoft.com> wrote in message
> news:D1FEBDD3-9DB0-446D-800B-622E44145AF2@.microsoft.com...
> addition on my desktop. There is nothing wrong with the actual SQL Server.
I
> seem to be the only one in my group experiencing this problem. I am
> currently using Windows XP professional. Database statistics have been
> updated and the result is the same.
>
>|||> I have applied SP3 several times.
<sigh>
Is the client tools installation the *ONLY* instance of SQL Server you have
installed?|||Yes that is the only instance. However, I do have reporting services loaded
as well.
"Aaron [SQL Server MVP]" wrote:

> <sigh>
> Is the client tools installation the *ONLY* instance of SQL Server you hav
e
> installed?
>
>|||Just as an F.Y.I......I was able to resolve this problem by re-applying sp
3a using a dos prompt and running the setup.bat file. When I tried to apply
the sp 3a through the setup.exe it didnot work. Strange Huh !!...Thanks aw
ay for your help.
"nupee" wrote:
[vbcol=seagreen]
> Yes that is the only instance. However, I do have reporting services loade
d as well.
> "Aaron [SQL Server MVP]" wrote:
>

Enterprise Manager unloading by itself

This is strange. My Enterprise Manager is unloading every
20 minutes by itself. This only after I modified the
MSSQLSERVER service to use an Administrator account
instead of Local System account so that I could use the
Debugger.
SQL2000 in SBS2000, all the latest patches.
Anyone else have this issue?
Thanx
SteveHi Steve,
What do you mean by "unloading"? If you mean crashing, you may want to see if you are hitting this issue
BUG: SQLBrowseConnect May Cause an Access Violation in the Client ID: 814064.KB.EN-US
http://support.microsoft.com/?id=814064
Sincerely,
Yih-Yoon Lee [Microsoft]
Microsoft SQL Server Support
This posting is provided "AS IS" with no warranties, and confers no rights. Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.
--
| Content-Class: urn:content-classes:message
| From: "Steve Sklar" <stevesklar@.hotmail.com>
| Sender: "Steve Sklar" <stevesklar@.hotmail.com>
| Subject: Enterprise Manager unloading by itself
| Date: Thu, 25 Sep 2003 10:10:45 -0700
| Lines: 11
| Message-ID: <042201c38387$f52608c0$a301280a@.phx.gbl>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="iso-8859-1"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
| Thread-Index: AcODh/UmCZPVXZcvRz6L79DbvkMDmA==| Newsgroups: microsoft.public.sqlserver.server
| Path: cpmsftngxa06.phx.gbl
| Xref: cpmsftngxa06.phx.gbl microsoft.public.sqlserver.server:308347
| NNTP-Posting-Host: TK2MSFTNGXA11 10.40.1.163
| X-Tomcat-NG: microsoft.public.sqlserver.server
|
| This is strange. My Enterprise Manager is unloading every
| 20 minutes by itself. This only after I modified the
| MSSQLSERVER service to use an Administrator account
| instead of Local System account so that I could use the
| Debugger.
|
| SQL2000 in SBS2000, all the latest patches.
| Anyone else have this issue?
|
| Thanx
| Steve
|sql

Enterprise Manager table property consistency

I have one table in my SQL server 2000 (w2k server up to date service packs) where when I right click 'properties' of the table in Enterprise Manager I get 13316 records. But if I open the table in enterprise manager and SELECT count(*) I get 13315 recor
ds. However, using the same table in Query Analyzer, Select count(*) results in 13315 records and Select *
results in 13315 rows showing in the lower right of the Query pane.
It seems to be occuring in just this one table using Enterprise Manager.
Probably no big deal. Anyone know what may be causing this?
TIA
Ken,
Refer DBCC UPDATEUSAGE in BooksOnLine.
Dinesh
SQL Server MVP
--
SQL Server FAQ at
http://www.tkdinesh.com
"Ken" <anonymous@.discussions.microsoft.com> wrote in message
news:53400F61-A8C3-4423-BCCA-B14A84E7FDBD@.microsoft.com...
> I have one table in my SQL server 2000 (w2k server up to date service
packs) where when I right click 'properties' of the table in Enterprise
Manager I get 13316 records. But if I open the table in enterprise manager
and SELECT count(*) I get 13315 records. However, using the same table in
Query Analyzer, Select count(*) results in 13315 records and Select *
> results in 13315 rows showing in the lower right of the Query pane.
> It seems to be occuring in just this one table using Enterprise Manager.
> Probably no big deal. Anyone know what may be causing this?
> TIA
|||In addition to Dinesh's response, both counts and table/index sizes are
numbers that are NOT updated for each insert, update or delete. They are
periodically updated, so they will be close most of the time , but not
exact...
The command that Dinesh showed you will update the information.
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Ken" <anonymous@.discussions.microsoft.com> wrote in message
news:53400F61-A8C3-4423-BCCA-B14A84E7FDBD@.microsoft.com...
> I have one table in my SQL server 2000 (w2k server up to date service
packs) where when I right click 'properties' of the table in Enterprise
Manager I get 13316 records. But if I open the table in enterprise manager
and SELECT count(*) I get 13315 records. However, using the same table in
Query Analyzer, Select count(*) results in 13315 records and Select *
> results in 13315 rows showing in the lower right of the Query pane.
> It seems to be occuring in just this one table using Enterprise Manager.
> Probably no big deal. Anyone know what may be causing this?
> TIA

Enterprise Manager table property consistency

I have one table in my SQL server 2000 (w2k server up to date service packs)
where when I right click 'properties' of the table in Enterprise Manager I
get 13316 records. But if I open the table in enterprise manager and SELECT
count(*) I get 13315 recor
ds. However, using the same table in Query Analyzer, Select count(*) result
s in 13315 records and Select *
results in 13315 rows showing in the lower right of the Query pane.
It seems to be occuring in just this one table using Enterprise Manager.
Probably no big deal. Anyone know what may be causing this?
TIAKen,
Refer DBCC UPDATEUSAGE in BooksOnLine.
Dinesh
SQL Server MVP
--
--
SQL Server FAQ at
http://www.tkdinesh.com
"Ken" <anonymous@.discussions.microsoft.com> wrote in message
news:53400F61-A8C3-4423-BCCA-B14A84E7FDBD@.microsoft.com...
> I have one table in my SQL server 2000 (w2k server up to date service
packs) where when I right click 'properties' of the table in Enterprise
Manager I get 13316 records. But if I open the table in enterprise manager
and SELECT count(*) I get 13315 records. However, using the same table in
Query Analyzer, Select count(*) results in 13315 records and Select *
> results in 13315 rows showing in the lower right of the Query pane.
> It seems to be occuring in just this one table using Enterprise Manager.
> Probably no big deal. Anyone know what may be causing this?
> TIA|||In addition to Dinesh's response, both counts and table/index sizes are
numbers that are NOT updated for each insert, update or delete. They are
periodically updated, so they will be close most of the time , but not
exact...
The command that Dinesh showed you will update the information.
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Ken" <anonymous@.discussions.microsoft.com> wrote in message
news:53400F61-A8C3-4423-BCCA-B14A84E7FDBD@.microsoft.com...
> I have one table in my SQL server 2000 (w2k server up to date service
packs) where when I right click 'properties' of the table in Enterprise
Manager I get 13316 records. But if I open the table in enterprise manager
and SELECT count(*) I get 13315 records. However, using the same table in
Query Analyzer, Select count(*) results in 13315 records and Select *
> results in 13315 rows showing in the lower right of the Query pane.
> It seems to be occuring in just this one table using Enterprise Manager.
> Probably no big deal. Anyone know what may be causing this?
> TIAsql

Enterprise Manager table property consistency

I have one table in my SQL server 2000 (w2k server up to date service packs) where when I right click 'properties' of the table in Enterprise Manager I get 13316 records. But if I open the table in enterprise manager and SELECT count(*) I get 13315 records. However, using the same table in Query Analyzer, Select count(*) results in 13315 records and Select
results in 13315 rows showing in the lower right of the Query pane
It seems to be occuring in just this one table using Enterprise Manager
Probably no big deal. Anyone know what may be causing this
TIAKen,
Refer DBCC UPDATEUSAGE in BooksOnLine.
--
Dinesh
SQL Server MVP
--
--
SQL Server FAQ at
http://www.tkdinesh.com
"Ken" <anonymous@.discussions.microsoft.com> wrote in message
news:53400F61-A8C3-4423-BCCA-B14A84E7FDBD@.microsoft.com...
> I have one table in my SQL server 2000 (w2k server up to date service
packs) where when I right click 'properties' of the table in Enterprise
Manager I get 13316 records. But if I open the table in enterprise manager
and SELECT count(*) I get 13315 records. However, using the same table in
Query Analyzer, Select count(*) results in 13315 records and Select *
> results in 13315 rows showing in the lower right of the Query pane.
> It seems to be occuring in just this one table using Enterprise Manager.
> Probably no big deal. Anyone know what may be causing this?
> TIA|||In addition to Dinesh's response, both counts and table/index sizes are
numbers that are NOT updated for each insert, update or delete. They are
periodically updated, so they will be close most of the time , but not
exact...
The command that Dinesh showed you will update the information.
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Ken" <anonymous@.discussions.microsoft.com> wrote in message
news:53400F61-A8C3-4423-BCCA-B14A84E7FDBD@.microsoft.com...
> I have one table in my SQL server 2000 (w2k server up to date service
packs) where when I right click 'properties' of the table in Enterprise
Manager I get 13316 records. But if I open the table in enterprise manager
and SELECT count(*) I get 13315 records. However, using the same table in
Query Analyzer, Select count(*) results in 13315 records and Select *
> results in 13315 rows showing in the lower right of the Query pane.
> It seems to be occuring in just this one table using Enterprise Manager.
> Probably no big deal. Anyone know what may be causing this?
> TIA

Monday, March 19, 2012

Enterprise manager reporting Free Space

I 'm running sql server 2k, with service pak3a, Win2k with lastest service
pak. We have a database that shows as being 9gig, with 0.00 MB free when
looking at the properties of it in Enterprise manager. The hdisk where that
database resides has 45gig free, with no disk quotes. Also, the database is
set to auto grow by 10%, both the tran log and data file. I have no idea why
it's not seeing more the 0.00mb free...any thoughts or ideas would be
greatly appreciated..
-BobThat reports the space free in the MDF file, not on the drive.
--
http://www.aspfaq.com/
(Reverse address to reply.)
"BobJones1967" <BobJones1967@.discussions.microsoft.com> wrote in message
news:BEAF570A-FE36-4BCA-8B16-A980D0621926@.microsoft.com...
> I 'm running sql server 2k, with service pak3a, Win2k with lastest service
> pak. We have a database that shows as being 9gig, with 0.00 MB free when
> looking at the properties of it in Enterprise manager. The hdisk where
that
> database resides has 45gig free, with no disk quotes. Also, the database
is
> set to auto grow by 10%, both the tran log and data file. I have no idea
why
> it's not seeing more the 0.00mb free...any thoughts or ideas would be
> greatly appreciated..
> -Bob|||how can I increase that space...do i need to?
"Aaron [SQL Server MVP]" wrote:
> That reports the space free in the MDF file, not on the drive.
> --
> http://www.aspfaq.com/
> (Reverse address to reply.)
>
>
> "BobJones1967" <BobJones1967@.discussions.microsoft.com> wrote in message
> news:BEAF570A-FE36-4BCA-8B16-A980D0621926@.microsoft.com...
> > I 'm running sql server 2k, with service pak3a, Win2k with lastest service
> > pak. We have a database that shows as being 9gig, with 0.00 MB free when
> > looking at the properties of it in Enterprise manager. The hdisk where
> that
> > database resides has 45gig free, with no disk quotes. Also, the database
> is
> > set to auto grow by 10%, both the tran log and data file. I have no idea
> why
> > it's not seeing more the 0.00mb free...any thoughts or ideas would be
> > greatly appreciated..
> >
> > -Bob
>
>|||If you have it set to autogrow, it will increase the space when it needs to.
--
http://www.aspfaq.com/
(Reverse address to reply.)
"BobJones1967" <BobJones1967@.discussions.microsoft.com> wrote in message
news:8C9B48B3-4737-4A2C-A21F-A7A9095154DC@.microsoft.com...
> how can I increase that space...do i need to?
> "Aaron [SQL Server MVP]" wrote:
> > That reports the space free in the MDF file, not on the drive.
> >
> > --
> > http://www.aspfaq.com/
> > (Reverse address to reply.)
> >
> >
> >
> >
> > "BobJones1967" <BobJones1967@.discussions.microsoft.com> wrote in message
> > news:BEAF570A-FE36-4BCA-8B16-A980D0621926@.microsoft.com...
> > > I 'm running sql server 2k, with service pak3a, Win2k with lastest
service
> > > pak. We have a database that shows as being 9gig, with 0.00 MB free
when
> > > looking at the properties of it in Enterprise manager. The hdisk where
> > that
> > > database resides has 45gig free, with no disk quotes. Also, the
database
> > is
> > > set to auto grow by 10%, both the tran log and data file. I have no
idea
> > why
> > > it's not seeing more the 0.00mb free...any thoughts or ideas would be
> > > greatly appreciated..
> > >
> > > -Bob
> >
> >
> >

Sunday, March 11, 2012

Enterprise Manager not in programs list

Hi There,
I have SQL 2000 running on my 2003 server. The service is running in my
system tray, but when I go to start-programs, my MS SQL-enterprise manager
has disappeared. It has been there in the past and I have done a re-boot.
Where has it gone? Is there another way to get to enterprise manager? Maybe
the executible?
Please help!Bruce,
Are you loged in with the same account?
Might try creating a shortcut using:
C:\WINDOWS\system32\mmc.exe /s "C:\Program Files\Microsoft SQL
Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC"
Be sure to check the paths for your system.
HTH
Jerry
"BruceS" <BruceS@.discussions.microsoft.com> wrote in message
news:330D03F1-28AE-4E8E-96E8-38AFD0A4DC59@.microsoft.com...
> Hi There,
> I have SQL 2000 running on my 2003 server. The service is running in my
> system tray, but when I go to start-programs, my MS SQL-enterprise manager
> has disappeared. It has been there in the past and I have done a re-boot.
> Where has it gone? Is there another way to get to enterprise manager?
> Maybe
> the executible?
> Please help!|||Hey Jerry,
Thanks for the quick response!
It seems that this file "SQL Server Enterprise Manager.MSC" is missing. I
don't see it in the path you mentioned, or anywhere else. Can I re-create
this?
"Jerry Spivey" wrote:
> Bruce,
> Are you loged in with the same account?
> Might try creating a shortcut using:
> C:\WINDOWS\system32\mmc.exe /s "C:\Program Files\Microsoft SQL
> Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC"
> Be sure to check the paths for your system.
> HTH
> Jerry
> "BruceS" <BruceS@.discussions.microsoft.com> wrote in message
> news:330D03F1-28AE-4E8E-96E8-38AFD0A4DC59@.microsoft.com...
> > Hi There,
> >
> > I have SQL 2000 running on my 2003 server. The service is running in my
> > system tray, but when I go to start-programs, my MS SQL-enterprise manager
> > has disappeared. It has been there in the past and I have done a re-boot.
> > Where has it gone? Is there another way to get to enterprise manager?
> > Maybe
> > the executible?
> >
> > Please help!
>
>|||Hmmm...not sure. Maybe copy it from a diffent system? Yeah the path may
be different depending on your installation. EM is a snap-in to the
Microsoft Management Console (MMC) so you could just create a new MMC and
then add in the EM snap-in. This approach also allows you to add in
additional useful snap-ins.
You can create one by Start-->Run and typing in MMC and pressing OK.
You can see a picture of this in the System Administration chapter of the
SQL Server 2000 Operations Guide I wrote a while back at:
http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/sqlops4.mspx
HTH
Jerry
"BruceS" <BruceS@.discussions.microsoft.com> wrote in message
news:5D9E729F-0511-4180-90CD-9C8CF5D8BF64@.microsoft.com...
> Hey Jerry,
> Thanks for the quick response!
> It seems that this file "SQL Server Enterprise Manager.MSC" is missing. I
> don't see it in the path you mentioned, or anywhere else. Can I re-create
> this?
> "Jerry Spivey" wrote:
>> Bruce,
>> Are you loged in with the same account?
>> Might try creating a shortcut using:
>> C:\WINDOWS\system32\mmc.exe /s "C:\Program Files\Microsoft SQL
>> Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC"
>> Be sure to check the paths for your system.
>> HTH
>> Jerry
>> "BruceS" <BruceS@.discussions.microsoft.com> wrote in message
>> news:330D03F1-28AE-4E8E-96E8-38AFD0A4DC59@.microsoft.com...
>> > Hi There,
>> >
>> > I have SQL 2000 running on my 2003 server. The service is running in my
>> > system tray, but when I go to start-programs, my MS SQL-enterprise
>> > manager
>> > has disappeared. It has been there in the past and I have done a
>> > re-boot.
>> > Where has it gone? Is there another way to get to enterprise manager?
>> > Maybe
>> > the executible?
>> >
>> > Please help!
>>

Friday, March 9, 2012

Enterprise Manager Hangs....

1. SQL Server 2K with Service Pack 3.x.

Steps to generate error in Enterprise Manager.

Right click on Database node, select All Tasks and Restore Database... Hourglass appears for ever.

All Tasks--> Backup Database... and All Tasks--> Attach Database... works fine.

Installed the SP4 and reinstalled the Enterprise Manager component. No help. Still the same hourglass at this stage.

2. When the above steps are repeated from other PC(Enterprise Manager), the hour glass appears. Irrespective from which EM (different PC) I run the above steps the EM hangs.

What would be the cause and remedy.

Thank you for your thoughts.

Smith

Here is the update on this issue...

Restore database window appears after long wait.... more than an hour.........

It never use to be so earlier.

What got changed recently?

SQL Server was writing the backup files(full backup, differential backup and transactional backup on UNC path) to Windows 2K Server and lately started writing to Windows Server 2003.

When the restore is selected it will list all the backup set files and its path. Is the EM taking longtime to read this list? Does the new file system is delaying the read?

Any thoughts?

Thank you,

|||

Run a trace and see what commands, statements are being executed when it hangs. That should give you more to figure out the issue.

-Sue

Enterprise Manager Hangs....

1. SQL Server 2K with Service Pack 3.x.

Steps to generate error in Enterprise Manager.

Right click on Database node, select All Tasks and Restore Database... Hourglass appears for ever.

All Tasks--> Backup Database... and All Tasks--> Attach Database... works fine.

Installed the SP4 and reinstalled the Enterprise Manager component. No help. Still the same hourglass at this stage.

2. When the above steps are repeated from other PC(Enterprise Manager), the hour glass appears. Irrespective from which EM (different PC) I run the above steps the EM hangs.

What would be the cause and remedy.

Thank you for your thoughts.

Smith

Here is the update on this issue...

Restore database window appears after long wait.... more than an hour.........

It never use to be so earlier.

What got changed recently?

SQL Server was writing the backup files(full backup, differential backup and transactional backup on UNC path) to Windows 2K Server and lately started writing to Windows Server 2003.

When the restore is selected it will list all the backup set files and its path. Is the EM taking longtime to read this list? Does the new file system is delaying the read?

Any thoughts?

Thank you,

|||

Run a trace and see what commands, statements are being executed when it hangs. That should give you more to figure out the issue.

-Sue

Wednesday, March 7, 2012

Enterprise Manager Hangs

Hi,
I'm using a Windows 2003 server with SQL Server 2000 with Service Pack 3a.
When I go to enterprise manager and click on (local) under server groups,
enterprise manager hangs and once that happens, all connections (query
analyzer or web SQL connect) fails. I have to end the tasks: mmc.exe and
sqlsvr.exe and then start the server again using the Service Manager. (If I
try to stop the server after ending mmc.exe, the status of the Server just
stays as "Stopping").
If I don't go to Enterprise Manager, everything works fine. Also, just in
case you're wondering, I DO NOT have tracing enabled.
I used ProcExp from www.sysinternals.com and after clicking on (local)
with enterprise manager, I get the following data:
2 new events:
\BaseNamedObjects\Crypt32LogOff
\$SERVER$MSSQLSERVER(2427)_C_READPOSTED
when i look at the threads, i get the following:
RPCRT4.DLLNdrRangeUnmarshall
msvcrt.dll!end thread
Any thoughts/suggestions would be appreciated. Thanks.
(a) stop usng Enterprise Manager :-)
(b) see if a post-SP3 hotfix cures it. See http://www.aspfaq.com/2160 for a
list...
http://www.aspfaq.com/
(Reverse address to reply.)
"JB" <JB@.discussions.microsoft.com> wrote in message
news:53BD8E18-825F-4AEA-B9ED-E6A5F383D772@.microsoft.com...
> Hi,
> I'm using a Windows 2003 server with SQL Server 2000 with Service Pack
3a.
> When I go to enterprise manager and click on (local) under server groups,
> enterprise manager hangs and once that happens, all connections (query
> analyzer or web SQL connect) fails. I have to end the tasks: mmc.exe and
> sqlsvr.exe and then start the server again using the Service Manager. (If
I
> try to stop the server after ending mmc.exe, the status of the Server just
> stays as "Stopping").
> If I don't go to Enterprise Manager, everything works fine. Also, just
in
> case you're wondering, I DO NOT have tracing enabled.
> I used ProcExp from www.sysinternals.com and after clicking on (local)
> with enterprise manager, I get the following data:
> 2 new events:
> \BaseNamedObjects\Crypt32LogOff
> \$SERVER$MSSQLSERVER(2427)_C_READPOSTED
> when i look at the threads, i get the following:
> RPCRT4.DLLNdrRangeUnmarshall
> msvcrt.dll!end thread
> Any thoughts/suggestions would be appreciated. Thanks.
|||Thanks for the link and the advice... =)
Anyway, I have a few more details about the problem:
When I click on the (local) in the server groups in enterprise manager, I
hear a beep and the status bar msg is "Establishing connection to SQL Server
and Checking Windows Security".
Also, I reinstalled SQL Server 2000 Service Pack 3a but it didn't help.
"Aaron [SQL Server MVP]" wrote:

> (a) stop usng Enterprise Manager :-)
> (b) see if a post-SP3 hotfix cures it. See http://www.aspfaq.com/2160 for a
> list...
> --
> http://www.aspfaq.com/
> (Reverse address to reply.)
>
>
> "JB" <JB@.discussions.microsoft.com> wrote in message
> news:53BD8E18-825F-4AEA-B9ED-E6A5F383D772@.microsoft.com...
> 3a.
> I
> in
>
>

Enterprise Manager Hangs

Hi,
I'm using a Windows 2003 server with SQL Server 2000 with Service Pack 3a.
When I go to enterprise manager and click on (local) under server groups,
enterprise manager hangs and once that happens, all connections (query
analyzer or web SQL connect) fails. I have to end the tasks: mmc.exe and
sqlsvr.exe and then start the server again using the Service Manager. (If I
try to stop the server after ending mmc.exe, the status of the Server just
stays as "Stopping").
If I don't go to Enterprise Manager, everything works fine. Also, just in
case you're wondering, I DO NOT have tracing enabled.
I used ProcExp from www.sysinternals.com and after clicking on (local)
with enterprise manager, I get the following data:
2 new events:
\BaseNamedObjects\Crypt32LogOff
\$SERVER$MSSQLSERVER(2427)_C_READPOSTED
when i look at the threads, i get the following:
RPCRT4.DLLNdrRangeUnmarshall
msvcrt.dll!end thread
Any thoughts/suggestions would be appreciated. Thanks.(a) stop usng Enterprise Manager :-)
(b) see if a post-SP3 hotfix cures it. See http://www.aspfaq.com/2160 for a
list...
http://www.aspfaq.com/
(Reverse address to reply.)
"JB" <JB@.discussions.microsoft.com> wrote in message
news:53BD8E18-825F-4AEA-B9ED-E6A5F383D772@.microsoft.com...
> Hi,
> I'm using a Windows 2003 server with SQL Server 2000 with Service Pack
3a.
> When I go to enterprise manager and click on (local) under server groups,
> enterprise manager hangs and once that happens, all connections (query
> analyzer or web SQL connect) fails. I have to end the tasks: mmc.exe and
> sqlsvr.exe and then start the server again using the Service Manager. (If
I
> try to stop the server after ending mmc.exe, the status of the Server just
> stays as "Stopping").
> If I don't go to Enterprise Manager, everything works fine. Also, just
in
> case you're wondering, I DO NOT have tracing enabled.
> I used ProcExp from www.sysinternals.com and after clicking on (local)
> with enterprise manager, I get the following data:
> 2 new events:
> \BaseNamedObjects\Crypt32LogOff
> \$SERVER$MSSQLSERVER(2427)_C_READPOSTED
> when i look at the threads, i get the following:
> RPCRT4.DLLNdrRangeUnmarshall
> msvcrt.dll!end thread
> Any thoughts/suggestions would be appreciated. Thanks.|||Thanks for the link and the advice... =)
Anyway, I have a few more details about the problem:
When I click on the (local) in the server groups in enterprise manager, I
hear a beep and the status bar msg is "Establishing connection to SQL Server
and Checking Windows Security".
Also, I reinstalled SQL Server 2000 Service Pack 3a but it didn't help.
"Aaron [SQL Server MVP]" wrote:

> (a) stop usng Enterprise Manager :-)
> (b) see if a post-SP3 hotfix cures it. See http://www.aspfaq.com/2160 for
a
> list...
> --
> http://www.aspfaq.com/
> (Reverse address to reply.)
>
>
> "JB" <JB@.discussions.microsoft.com> wrote in message
> news:53BD8E18-825F-4AEA-B9ED-E6A5F383D772@.microsoft.com...
> 3a.
> I
> in
>
>

Enterprise Manager Hangs

Hi,
I'm using a Windows 2003 server with SQL Server 2000 with Service Pack 3a.
When I go to enterprise manager and click on (local) under server groups,
enterprise manager hangs and once that happens, all connections (query
analyzer or web SQL connect) fails. I have to end the tasks: mmc.exe and
sqlsvr.exe and then start the server again using the Service Manager. (If I
try to stop the server after ending mmc.exe, the status of the Server just
stays as "Stopping").
If I don't go to Enterprise Manager, everything works fine. Also, just in
case you're wondering, I DO NOT have tracing enabled.
I used ProcExp from www.sysinternals.com and after clicking on (local)
with enterprise manager, I get the following data:
2 new events:
\BaseNamedObjects\Crypt32LogOff
\$SERVER$MSSQLSERVER(2427)_C_READPOSTED
when i look at the threads, i get the following:
RPCRT4.DLLNdrRangeUnmarshall
msvcrt.dll!end thread
Any thoughts/suggestions would be appreciated. Thanks.(a) stop usng Enterprise Manager :-)
(b) see if a post-SP3 hotfix cures it. See http://www.aspfaq.com/2160 for a
list...
--
http://www.aspfaq.com/
(Reverse address to reply.)
"JB" <JB@.discussions.microsoft.com> wrote in message
news:53BD8E18-825F-4AEA-B9ED-E6A5F383D772@.microsoft.com...
> Hi,
> I'm using a Windows 2003 server with SQL Server 2000 with Service Pack
3a.
> When I go to enterprise manager and click on (local) under server groups,
> enterprise manager hangs and once that happens, all connections (query
> analyzer or web SQL connect) fails. I have to end the tasks: mmc.exe and
> sqlsvr.exe and then start the server again using the Service Manager. (If
I
> try to stop the server after ending mmc.exe, the status of the Server just
> stays as "Stopping").
> If I don't go to Enterprise Manager, everything works fine. Also, just
in
> case you're wondering, I DO NOT have tracing enabled.
> I used ProcExp from www.sysinternals.com and after clicking on (local)
> with enterprise manager, I get the following data:
> 2 new events:
> \BaseNamedObjects\Crypt32LogOff
> \$SERVER$MSSQLSERVER(2427)_C_READPOSTED
> when i look at the threads, i get the following:
> RPCRT4.DLLNdrRangeUnmarshall
> msvcrt.dll!end thread
> Any thoughts/suggestions would be appreciated. Thanks.|||Thanks for the link and the advice... =)
Anyway, I have a few more details about the problem:
When I click on the (local) in the server groups in enterprise manager, I
hear a beep and the status bar msg is "Establishing connection to SQL Server
and Checking Windows Security".
Also, I reinstalled SQL Server 2000 Service Pack 3a but it didn't help.
"Aaron [SQL Server MVP]" wrote:
> (a) stop usng Enterprise Manager :-)
> (b) see if a post-SP3 hotfix cures it. See http://www.aspfaq.com/2160 for a
> list...
> --
> http://www.aspfaq.com/
> (Reverse address to reply.)
>
>
> "JB" <JB@.discussions.microsoft.com> wrote in message
> news:53BD8E18-825F-4AEA-B9ED-E6A5F383D772@.microsoft.com...
> > Hi,
> > I'm using a Windows 2003 server with SQL Server 2000 with Service Pack
> 3a.
> > When I go to enterprise manager and click on (local) under server groups,
> > enterprise manager hangs and once that happens, all connections (query
> > analyzer or web SQL connect) fails. I have to end the tasks: mmc.exe and
> > sqlsvr.exe and then start the server again using the Service Manager. (If
> I
> > try to stop the server after ending mmc.exe, the status of the Server just
> > stays as "Stopping").
> > If I don't go to Enterprise Manager, everything works fine. Also, just
> in
> > case you're wondering, I DO NOT have tracing enabled.
> >
> > I used ProcExp from www.sysinternals.com and after clicking on (local)
> > with enterprise manager, I get the following data:
> >
> > 2 new events:
> > \BaseNamedObjects\Crypt32LogOff
> > \$SERVER$MSSQLSERVER(2427)_C_READPOSTED
> >
> > when i look at the threads, i get the following:
> > RPCRT4.DLLNdrRangeUnmarshall
> > msvcrt.dll!end thread
> >
> > Any thoughts/suggestions would be appreciated. Thanks.
>
>

Sunday, February 26, 2012

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

Thursday, March 22, 2012

Enterprise manger won't connect

Enterprise manger won't connect

Wednesday, March 21, 2012

Enterprise Manager version

Enterprise Manager version

Enterprise Manager unloading by itself

Enterprise Manager table property consistency

Enterprise Manager table property consistency

Enterprise Manager table property consistency

Monday, March 19, 2012

Enterprise manager reporting Free Space

Enterprise manager reporting Free Space

Sunday, March 11, 2012

Enterprise Manager not in programs list

Enterprise Manager not in programs list

Friday, March 9, 2012

Enterprise Manager Hangs....

Enterprise Manager Hangs....

Wednesday, March 7, 2012

Enterprise Manager Hangs

Enterprise Manager Hangs

Enterprise Manager Hangs

Sunday, February 26, 2012

enterprise manager cost?

enterprise manager cost?

enterprise manager cost?

Sql Enterprise Edition

Blog Archive

About Me