Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Query Analyzer on client machine

Posted on 2011-09-07
3
Medium Priority
?
335 Views
Last Modified: 2012-05-12
Hello:

I need someone to make this easy for me.  I have a windows 7 client machine that I want to be able to run queries on a SQL Server 2008 database.

I don't know what product I need to download and install on my client machine.  Basically, I want to be able to run Query analyzer on my client machine against the networked 2008 SQL server.

There are just too many products/possible solutions for me to sift thorough.

Please let me know which one I need to download and general instructions would be appreciated.

Thank you!  
0
Comment
Question by:MeowserM
3 Comments
 
LVL 15

Accepted Solution

by:
Faiga Diegel earned 2000 total points
ID: 36496991
Install the SQL client tool with the SQL Server Management Studio. When you have this installed on your machine, you can connect to different DB servers (of course there are some settings on the SQL server that you want to connect to for remote connections, firewall settings, security, etc)
0
 
LVL 29

Expert Comment

by:sammySeltzer
ID: 36496997
You can use sql server web admin.

That's what I use. Install it on your PC, point to your remote db and vavoom, you are working without having to get into sql server db.

http://www.microsoft.com/download/en/details.aspx?languageid=f49e8428-7071-4979-8a67-3cffcb0c2524&displaylang=en&id=10299

0
 

Author Closing Comment

by:MeowserM
ID: 36519109
Thank you.  I installed 2008 management studio
0

Featured Post

[Webinar] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

OfficeMate Freezes on login or does not load after login credentials are input.
The Windows functions GetTickCount and timeGetTime retrieve the number of milliseconds since the system was started. However, the value is stored in a DWORD, which means that it wraps around to zero every 49.7 days. This article shows how to solve t…
This Micro Tutorial will go in depth within Systems and Security in Windows 7 and will go into detail regarding Action Center, Windows Firewall, System, etc. This will be demonstrated using Windows 7 operating system.
The Task Scheduler is a powerful tool that is built into Windows. It allows you to schedule tasks (actions) on a recurring basis, such as hourly, daily, weekly, monthly, at log on, at startup, on idle, etc. This video Micro Tutorial is a brief intro…

564 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question