Vb.net SQL database connection error 26

Question

0.00/5 (No votes)

See more:

User had some test code connecting to a non production SQL Express database on a remote server, it was running fine but now they get a connection error 26

The connection string is fine

VB

Dim SQLstr As String = "server=testserver\SQLEXPRESS;uid=testuser;pwd=testpassword;database=test"

What I have tried:

After a lot of testing I've determined if the user is in the Domain Administrators group the code works as intended and the connection is made, I've even went as far as attaching the database to a new server with a new instance of SQL Express

Baffled with this one

Posted 25-Jan-18 10:21am

caffrey_1

Updated 25-Jan-18 20:24pm

Add a Solution

Comments

ZurdoDev 25-Jan-18 16:29pm

The full error should tell you what the problem is.

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Bryian Tan · Answer 1 · 2018-01-25T17:34:00

You should Google it. LMGTFY[^]

There are tons of resources out there, here are a few

Unable to connect to SQL Express "Error: 26-Error Locating Server/Instance Specified) - Stack Overflow[^]

Reasons of SQL Server Error 26 and know how to fix Error 26[^]

SQL Network Interfaces, error: 26 – Error Locating Server/Instance Specified – SQL Protocols[^]

caffrey_1 · Answer 2 · 2018-01-25T20:24:00

I have Googled it, like I said in OP it was running without issues and then it just stopped working, the code only works for Domain admins (The code runs for me) But not for domain users
I've tried removing GPO's to see if was a recent change but nothing, nothing was changed as far as I know on the SQL server instance.

I even tried a new server, maybe it's something to do with not being domain joined

Port query says everything is fine, all services are running - it's in mixed mode, TCPIP is enabled

No idea what it is, hence me posting here :)

Vb.net SQL database connection error 26

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0