Can't connect to SQLServer db via Enterprise manager on another PC

Posted on 2005-04-22
Last Modified: 2013-12-03
I have a new server with sql server db on it - it also has a web site that will eventually access that db, but right now is little more than a dummy place holder.

I can use SQL locally on the server, but can not connect to it via remoe pc using enterprise manager.

Some people can ping my server ip, some can not.. All can get into my web site, none can conenct to my sql server

In the sql server logs it does not say it is scanning the external ip for commands, ony the internal ( and local ( ips.

From my remote laptop, I can use enterprise manager and get into many other databases across the country - just not this one.

Have been fighting this for 3 days now

Question by:paulfryer
    LVL 18

    Accepted Solution

    Hi paulfryer,

    Is the SQL Server set up to use integrated security?  Or users explicitly defined for the database, or both?  Could be that this one instance of SQL Server is set up to use Windows security and since you'd be outside of it's domain, it won't let you in?

    LVL 21

    Expert Comment

    What is the O/S of the SQL Server?
    Is SP3 installed?
    What is the exact error message?
    Are you local to the SQL Server (same LAN)?

    If Win2K3 and no sp3, that may very well be it....TCP communications are blocked until after sp3 install.  Just a wild guess until I see the error message :-)

    LVL 5

    Expert Comment

    Have you ran a port scanner? Is the port 3306 open or is there a firewall in the way?
    LVL 5

    Expert Comment

    Oops 3306 is the MySQL port. MSSQL uses TCP 1433, 1434 and others

    With PHP:
    mssql_connect in version 4.2.1 seems to insist on using named pipes to connect to the SQL Server. This is not secure as it requires netbios browsing (tcp/udp ports 137, 139, and 445 (with windows2000)).

    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

    This is my first ever Article on EE or elsewhere; therefore, please bear with me if I have some discrepancies in my writing. I read many articles and questions related to "how to pass values to SSIS packages at run-time?"  Hence, this common ques…
    When you hear the word proxy, you may become apprehensive. This article will help you to understand Proxy and when it is useful. Let's talk Proxy for SQL Server. (Not in terms of Internet access.) Typically, you'll run into this type of problem w…
    This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
    Via a live example, show how to setup several different housekeeping processes for a SQL Server.

    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

    14 Experts available now in Live!

    Get 1:1 Help Now