How do I connect my vb.form to an sqlexpress on different machine?

Question

0.00/5 (No votes)

See more:

I can already connect remote desktop with other laptop and now I wanna connect my vb.form to SQLEXPRESS on the different machines.

connstr = "Provider = sqloledb;Data Source=192.168.178.##,1433;Initial Catalog=Expenses;"

But it gives me an error that it cannot find it.
"

Invalid connection string attribute

"
I have SQL EXPRESS 2019

What I have tried:

I already checked the Firewall and followed these steps How do I remotely connect to my MSSQL Express Server? - Applied Innovations Public Knowledgebase[^]
but still wont work.

Posted 30-Jul-20 8:01am

Member 13410460

Updated 30-Jul-20 8:25am

v2

Add a Solution

1 solution

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)

Sandeep Mewara · Accepted Answer · 2020-07-30T08:25:00

Answer quuoted from here: Enable remote connections for SQL Server Express 2012 - Stack Overflow[^]

Quote:
The solution I finally discovered was here:

How do I configure SQL Server Express to allow remote tcp/ip connections on port 1433[^]?

Run SQL Server Configuration Manager.
Go to SQL Server Network Configuration > Protocols for SQLEXPRESS.
Make sure TCP/IP is enabled.

So far, so good, and entirely expected. But then:

Right-click on TCP/IP and select Properties.
Verify that, under IP2, the IP Address is set to the computer's IP address on the local subnet.
Scroll down to IPAll.
Make sure that TCP Dynamic Ports is blank. (Mine was set to some 5-digit port number.)
Make sure that TCP Port is set to 1433. (Mine was blank.)

(Also, if you follow these steps, it's not necessary to enable SQL Server Browser, and you only need to allow port 1433, not 1434.)

These extra five steps are something I can't remember ever having had to do in a previous version of SQL Server, Express or otherwise. They appear to have been necessary because I'm using a named instance (myservername\SQLEXPRESS) on the server instead of a default instance. See here:

Configure a Server to Listen on a Specific TCP Port (SQL Server Configuration Manager)[^]