Not able to connect Sqlserver database which is installed in another system by using SqlServer Management studio

Posted on 2011-10-13
Last Modified: 2012-05-12
Hi Experts,

I have installed SqlServer 2008 R2  in my laptop and have installed SqlServer 2008 R2 in another system (LAN). I want to access/view  Sqlserver database from my laptop.

 I want to view all databases, Sqlserver tables which is in another system by using Sqlserver management studio R2 Express which is in my laptop.

Can you help me step by step.

Question by:Tapan Pattanaik
    LVL 15

    Accepted Solution

    Assuming both the servers are installed in same domain

    Enable TCP/IP on both servers -  Go to SQL Server configuration Manager(you can find this in start-> program files-> SQL Server 2008 R2), Expand SQL Server network configuration , Click Protocols for MSSQLSERVER , then enable TCP/IP on the right side tab. like wise you need to do the same for  SQL Server native client configuration also.
    Do this at both the servers.

    Allow Remote Connections.
    run this at both servers
    sp_configure 'remote access',1

    Once the above steps are done, Connect to the server from your laptop using an account that have permission on the server. This account can be either windows account or sql account.

    LVL 25

    Assisted Solution

    LVL 9

    Assisted Solution

    LVL 20

    Author Comment

    by:Tapan Pattanaik
    I have solved this issue by using this link. This link has actual answer to my question.

    I want to give points to experts.

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Join & Write a Comment

    Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
    It was really hard time for me to get the understanding of Delegates in C#. I went through many websites and articles but I found them very clumsy. After going through those sites, I noted down the points in a easy way so here I am sharing that unde…
    Viewers will learn how the fundamental information of how to create a table.
    Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

    745 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

    16 Experts available now in Live!

    Get 1:1 Help Now