Error 26 When Trying to Connect / Create a Database

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.
42naAsked:
Who is Participating?
 
assystConnect With a Mentor Commented:
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.

S
0
 
SQL_SERVER_DBAConnect With a Mentor Commented:
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.
0
 
42naAuthor Commented:
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.
0
 
42naAuthor Commented:
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.
0
 
42naAuthor Commented:
The problem was that the SQLExpress did not get fully deleted off my computer.  Thanks for your help.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.