General discussion
-
CreatorTopic
-
December 7, 2001 at 3:30 am #2130862
SQL 2000 managed from workstation
Lockedby wb7nqm · about 20 years, 5 months ago
Group,
We are running SQL Server 2000 for our document imaging database and, as admin, I need to run queries on a regular basis. Does SQL have a client version I can install on my workstation to run Enterprise Manager/Query Analyzer? Our server is situated such that I have to stand while working and that can get uncomfortable quickly. I searched MSKB but did not find anything (perhaps used the wrong search criteria). Any info would be greatly appreciated.Thank you in advance, Carolyn
Topic is locked -
CreatorTopic
All Comments
-
AuthorReplies
-
-
December 7, 2001 at 3:42 am #3546251
SQL 2000 managed from workstation
by ann777 · about 20 years, 5 months ago
In reply to SQL 2000 managed from workstation
No, it doesn’t.
The only way you could do this (without moving the server to a desk), is to install remote comtrol software (like PC Anywhere or Remote Control, etc.) and setup your server to wait as a host (PASSWORD PROTECT IT) and your workstation with the ability to network into it as needed.
-
December 7, 2001 at 9:31 am #3546804
SQL 2000 managed from workstation
by wb7nqm · about 20 years, 5 months ago
In reply to SQL 2000 managed from workstation
As I said before, I knew PCAnywhere would work but did not want to leave the server Listening. Also, I wish there was a “somewhat helpful” choice as, if I hadn’t know about PCA, this would have been a helpful answer.
Thanks for responding quickly, tho’.
Happy Holidays, Carolyn
-
-
December 7, 2001 at 4:38 am #3546214
SQL 2000 managed from workstation
by maxwell edison · about 20 years, 5 months ago
In reply to SQL 2000 managed from workstation
Greetings,
There are ? maybe – some common SQL database tasks that could be remotely managed.
See the following link to an article titled, ?Remote Management of an SQL Server Database with Access 2000?.
http://support.activeisp.nl/application/sql/sql-access.asp
(REMOVE SPACES if any snuck into the pasted URL.)
This sounds like a ?some? but not ?all? access to SQL management ability. But it may lead you in the direction you?re looking for.
Maxwell
-
December 7, 2001 at 4:46 am #3546210
SQL 2000 managed from workstation
by maxwell edison · about 20 years, 5 months ago
In reply to SQL 2000 managed from workstation
.
.
More information:The following link takes you to an article titled:
?Data Management: SQL Remote Database Access?
http://www.opengroup.org/products/publications/catalog/c307.htm
The following link takes you to an SQL Magazine article titled:
?Scripts for Remote Management?
An excerpt from the article:
??have access to all the management features on the servers, such as Enterprise Manager or Internet Service Manager ??
http://www.sqlmag.com/Articles/Index.cfm?ArticleID=8239
(Don?t forget to REMOVE those pesky SPACES.)
Good luck,
Maxwell
-
December 7, 2001 at 4:57 am #3546205
SQL 2000 managed from workstation
by maxwell edison · about 20 years, 5 months ago
In reply to SQL 2000 managed from workstation
.
.
Another possibility would involve a third-party solution (I don’t know the price).“Database Administrators Can Access, Manage and Control SQL Server Databases from Anywhere, Anytime With Web DBA? for Microsoft SQL Server.”
” BMC Software, Inc., [Nasdaq: BMCS], the leading provider of e-business systems management, today announced Web DBA for SQL Server, the latest version of the the company’s Web-based interactive database solution. Web DBA? for SQL Server requires only a standard Internet browser to address the daily database management tasks faced by today’s database administrators (DBA) and developers. Generally available in January, Web DBA for SQL Server enables developers and DBAs to manage and control their SQL Server databases from anywhere, anytime.”
A link to the full article:
Regards,
Maxwell
-
December 7, 2001 at 9:31 am #3546805
SQL 2000 managed from workstation
by wb7nqm · about 20 years, 5 months ago
In reply to SQL 2000 managed from workstation
Actually, the rating is wrong as I did not know about running the database remotely on Access. That was very interesting although it pulled the first 10K records (all from 1999) so my dated queries failed!
So, sorry about the rating but there isn’t a “helped some” choice!
Happy Holidays, Carolyn
-
-
December 7, 2001 at 6:08 am #3546166
SQL 2000 managed from workstation
by stillatit · about 20 years, 5 months ago
In reply to SQL 2000 managed from workstation
If 2000 is anything like 7, take the installation CD, put it on your workstation, and run the install. It will tell you that it cannot install the SQL server on a workstation, and offer to install the utilities for you.
Good luck.
-
December 7, 2001 at 9:31 am #3546806
SQL 2000 managed from workstation
by wb7nqm · about 20 years, 5 months ago
In reply to SQL 2000 managed from workstation
Thank you for this suggestion (actually for being the first one, as there was another about an hour later). I now have it installed and working on my Win2K workstation. SO much better on my back and hip!
Happy Holidays
-
-
December 7, 2001 at 7:31 am #3546866
SQL 2000 managed from workstation
by joseph moore · about 20 years, 5 months ago
In reply to SQL 2000 managed from workstation
Yes, you can run SQL Enterprise Manager, Query Analyzier and all of that from a NT/2000 workstation. I have these tools installed on my workstation right now.
Put the SQL 2000 cd in the cd drive on your Workstation. Start the install.
Click SQL Server 2000 Components
Click Install Database Server
You will then get an error box saying “Microsoft SQL Server 2000 server component is not supported on this operating system. Only client components will be available for installation.”
Click OK onthe error box.
Start the wizard.
You will get to an option to install Client Tools. That is what you want. Run the wizard from there.Hope this helps.
-
December 7, 2001 at 9:31 am #3546807
SQL 2000 managed from workstation
by wb7nqm · about 20 years, 5 months ago
In reply to SQL 2000 managed from workstation
Thank you for this suggestion (actually for being the second one, as there was another about an hour earlier). I wish I could divide the points between two answers as they both had good information.
Happy Holidays, Carolyn
-
-
December 7, 2001 at 9:31 am #3546803
SQL 2000 managed from workstation
by wb7nqm · about 20 years, 5 months ago
In reply to SQL 2000 managed from workstation
This question was closed by the author
-
-
AuthorReplies