Solved

Query Analyzer on client machine

Posted on 2011-09-07
3
320 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:
faiga16 earned 500 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 28

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

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

New Windows 7 Installations take days for Windows-Updates to show up and install. This can easily be fixed. I have finally decided to write an article because this seems to get asked several times a day lately. This Article and the Links apply to…
Today, still in the boom of Apple, PC's and products, nearly 50% of the computer users use Windows as graphical operating systems. If you are among those users who love windows, but are grappling to keep the system's hard drive optimized, then you s…
In this Micro Tutorial viewers will learn how to use Boot Corrector from Paragon Rescue Kit Free to identify and fix the boot problems of Windows 7/8/2012R2 etc. As an example is used Windows 2012R2 which lost its active partition flag (often happen…
This Micro Tutorial will teach you how to the overview of Microsoft Security Essentials. This is a free anti-virus software that guards your PC against viruses, spyware, worms, and other malicious software. This will be demonstrated using Windows…

706 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

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now