Solved

Query Analyzer on client machine

Posted on 2011-09-07
3
323 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

VMware Disaster Recovery and Data Protection

In this expert guide, you’ll learn about the components of a Modern Data Center. You will use cases for the value-added capabilities of Veeam®, including combining backup and replication for VMware disaster recovery and using replication for data center migration.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
SQL Server 2012 r2 - Make Temp Table Query Faster 5 44
Drivers  Repository for Win 7 13 58
SSRS 2013 - Creating a summarized report 19 37
Osiris Ranswomware 23 18
In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
Windows 8 comes with a dramatically different user interface known as Metro. Notably missing from the new interface is a Start button and Start Menu. Many users do not like it, much preferring the interface of earlier versions — Windows 7, Windows X…
This Micro Tutorial will give you a basic overview of Windows Live Photo Gallery and show you various editing filters and touches to photos you can apply. This will be demonstrated using Windows Live Photo Gallery on Windows 7 operating system.

832 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