Can't connect to SQL Server 2008 from another PC

Posted on 2012-08-27
Last Modified: 2012-09-04
I can't connect to a SQL Server instance from other workstations.  I have enabled all communication protocols and rebooted, yet I still can't connect.  Windows Firewall is off.  What else can I do?  Thanks.
Question by:thomsone
    LVL 142

    Expert Comment

    by:Guy Hengel [angelIII / a3]
    you want to read this article:
    basic information is the error message ...
    LVL 8

    Expert Comment

    by:Narender Gakka
    LVL 2

    Expert Comment

    Make sure you're right-clicking and doing run as administrator for the management studio. If UAC is on and this is not done it will not allow you to connect

    Accepted Solution

    I got it going by starting the SQL Browser service.  Thanks for the suggestions.

    Author Closing Comment

    I found the specific cause and resolved the issue.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    SQL Server engine let you use a Windows account or a SQL Server account to connect to a SQL Server instance. This can be configured immediatly during the SQL Server installation or after in the Server Authentication section in the Server properties …
    Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
    Via a live example, show how to setup several different housekeeping processes for a SQL Server.
    Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

    760 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

    8 Experts available now in Live!

    Get 1:1 Help Now