Unable to connect to SQL Server 05 Express

Posted on 2009-12-28
Last Modified: 2012-05-08
This is a brand new installation. I re-formatted everything and started over and now i can't connect to my SQL Server 05 express edition.

I have checked Named Pipes/ TCP/IP , both are enabled in Server config manager. I have added an alias for port 1433 for TCP/IP like i used to.

I checked and confirmed i have Mixed Mode login, userpass works when i try SQL Authentication login from the server itself , remote login is enabled and uses TCP/IP and Named Pipes.

SQLServer and Browser in services.msc has been started and are on "Automatic".

Any help? The error message is:

"[DBNETLIB][Connection Open (Connect()).]SQL Server does not exist or access denied."
Question by:nerian
    LVL 57

    Expert Comment

    by:Raja Jegan R
    Kindly check whether you have enabled Remote connections in your Express instance as mentioned below:

    Also check whether your Express instance is up and running.
    If you have more than one instance in your machine, make sure you reference it correctly by providing servername\instancename or serverip\instancename

    Author Comment

    Already did that before i posted here.
    LVL 6

    Expert Comment

    Check if the server is listening on that port using the following command:
    netstat -ano | find "1433"

    Then check to see if the SQL Server process ID is the one who is "holding" that port (in the task manager you need to add a column in order to see process ID's)

    If you don't see the port / it's not the SQL Server which is holding that port then you know where your problem is. I would then verify that the TCP/IP is activated on the correct interface.

    If the SQL Server is listening on the correct interface on that port, then this is probably some kind of permission error, you try to connect with a user with no permissions, you try to connect with SA with empty password, etc.


    Author Comment

    When i do netstat -ano | find "1433" , nothing comes up. So i did a netstat -an and i could only see 1434.

    I googled and copied a batch file from Microsoft's site on opening port 1433 for SQL Servers on win 2008 server.

    This is the code:

    @echo =========  SQL Server Ports  ===================
    @echo Enabling SQLServer default instance port 1433
    netsh firewall set portopening TCP 1433 "SQLServer"
    @echo Enabling Dedicated Admin Connection port 1434
    netsh firewall set portopening TCP 1434 "SQL Admin Connection"
    @echo Enabling conventional SQL Server Service Broker port 4022  
    netsh firewall set portopening TCP 4022 "SQL Service Broker"
    @echo Enabling Transact-SQL Debugger/RPC port 135
    netsh firewall set portopening TCP 135 "SQL Debugger/RPC"
    @echo =========  Analysis Services Ports  ==============
    @echo Enabling SSAS Default Instance port 2383
    netsh firewall set portopening TCP 2383 "Analysis Services"
    @echo Enabling SQL Server Browser Service port 2382
    netsh firewall set portopening TCP 2382 "SQL Browser"
    @echo =========  Misc Applications  ==============
    @echo Enabling HTTP port 80
    netsh firewall set portopening TCP 80 "HTTP"
    @echo Enabling SSL port 443
    netsh firewall set portopening TCP 443 "SSL"
    @echo Enabling port for SQL Server Browser Service's 'Browse' Button
    netsh firewall set portopening UDP 1434 "SQL Browser"
    @echo Allowing multicast broadcast response on UDP (Browser Service Enumerations OK)
    netsh firewall set multicastbroadcastresponse ENABLE

    It's a batch file , i ran it and still no luck.

    Author Comment

    "netsh firewall show state" lists port 1433 as open on all network interfaces as well.
    LVL 6

    Accepted Solution

    Notice that on Windows 2008 there is the Advanced Firewall.

    Check this out:

    You need to configure the "Advanced firewall" and not the "old" firewall.
    LVL 57

    Expert Comment

    by:Raja Jegan R
    Can you try disabling your Windows Firewall once and check to confirm whether this is an issue with Firewall or not..

    Author Comment

    I'll ask my colleague when he gets back from his holiday, he solved it for me remotely from his home yesterday.

    Featured Post

    What Is Threat Intelligence?

    Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

    Join & Write a Comment

    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.
    In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
    Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
    Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

    732 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

    21 Experts available now in Live!

    Get 1:1 Help Now