Quesition about SQL Server

Question

0.00/5 (No votes)

See more:

SQL-Server-2008

Hi guys
Am working on my SQL server management studio 2008 r2 , OK ?
and I want to read a data from another PC which contains SQL server 2008 r2 too, How can I do that?
I want the answer in details (step by step....)
By the way My Server's operating system is Windows server 2008 r2 and the PC is Windows 7?

Posted 25-Jan-11 0:38am

Layth Rafea

Updated 25-Jan-11 0:48am

Henry Minute

v3

Add a Solution

Comments

Slacker007 25-Jan-11 6:43am

Don't bold your questions. You seem to be pretty demanding with your question; this won't go over well with the community.

justinonday 25-Jan-11 6:50am

datasourec = target Pc IP address....

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Dylan Morley · Accepted Answer · 2011-01-25T00:57:00

So the other PC has a SQL Server instance running on it & you want to be able to connect and work with the data on that machine, from within SQL management studio?

On the machine you want to connect to, you need to setup some credentials so you can connect to the instance

Security -> Logins -> New Login.

Are you using Windows Authentication? If so, then choose this option & add your login name. If not, setup a 'SQL Server authentication' type user id \ password

Choose a default database + server role. (if this is just development stuff in house, serveradmin or sysadmin is fine. Not for production though!)

Now from your machine, under object explorer choose Connect -> Database Engine. Enter the other PC name as server name + select the authetication type & credentials you just setup.

Click 'Connect', if all OK the instance will be added to your object explorer & you can now work with the databases on the machine