Error 26 When Trying to Connect / Create a Database

Posted on 2007-10-03
Last Modified: 2013-11-27
Hi all,

I am a new user to Visual Studio.  I reached my limits with Access and I'm trying to move on.  

Being new to this I need some help getting off the ground.  When I try to create a new SQL server Database I keep getting an Error: An error has occurred while establishing a connection to the server.....(provider: SQL Network Interfaces, error 26 - Error Locating Server / Instance Specified).

I'm trying to use my computer as the host for right now to learn how to use the Studio.  I've tried looking online for a solution to this, but the solutions are a little over my head since I've never used this.  

Is this the right way to create a new database or is there another way?

I've updated my my Remote Connection to use TCP/IP only.

Any help getting started would be appreciated.
Question by:42na
    LVL 16

    Assisted Solution

    In a word, the reason that we get this error message is the client stack could not receive SSRP response UDP packet from SQL Browser. It's easy to isolate the issue. Here are the steps:
    1) Make sure your server name is correct, e.g., no typo on the name.
    2) Make sure your instance name is correct and there is actually such an instance on your target machine.
    3) Make sure the server machine is reachable, e.g, DNS can be resolve correctly, you are able to ping the server (not always true).
    4) Make sure SQL Browser service is running on the server.
    5) If firewall is enabled on the server, you need to put sqlbrowser.exe and/or UDP port 1434 into exception.

    Once you are done the steps, you should not see this error message anymore. You may still fail to connect your SQL server, but error message should be different and you have a different issue now.

    Author Comment

    Okay now I'm getting error 25 Connection String Not Valid.  I know this isn't the same problem but if this is a quick answer I'd appreciate it without a repost.

    Author Comment

    Hi Again,  I'm guessing my Server name is incorrect.  I can access it in VB Studio Manager and create databases.  When I test the connection in VB SM it works fine.  When I try to connect to that databaser in VB Studio it gives me that error, even when I go and select the mdf file I'm trying to connect to.

    My Server name is SDN-046682.  Is this a valid name?

    Also, the connection wizard keeps defaulting to SQLExpress.  I use to have that installed on my computer.  I thought I totally uninstalled that app.  I now have the full version of SQL Server.  Could this be one of the problems?

    Thanks again for your help.  If you'd like me to post this in a new post please let me know.
    LVL 7

    Accepted Solution

    I guess that it is tring to connect to SQLExpress. Go to SQL Server Configuration Manager and stop the SQLExpress DB engine [SQL Server (SQLExpress). Also check whether you have any instance name in bracket after the name, for eg: SQL Server(Dev05). If you have so, then the servername should be given as <ComputerName>\Dev05.

    Have a nice day.


    Author Comment

    The problem was that the SQLExpress did not get fully deleted off my computer.  Thanks for your help.

    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

    Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed. Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…
    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.
    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 set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.

    779 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

    13 Experts available now in Live!

    Get 1:1 Help Now