How to connect a C# windows form to a SQL Server database on another computer?

Question

I was wondering why I can't connect my application (C# Form from another pc) to my SQL Server?

I have followed these links, and use Virtual Box as my VM.

https://www.youtube.com/watch?v=aIovZluNmNs

How to connect to SQL Server from a C# program on another computer

Connecting to SQL server from another computer

Enable TCP/IP from the Configuration Manager
Use TCP Port 1433 (IPALL)
Restart SQL Server from the Configuration Manager
Added TCP Port from the Firewall (also UDP Port 1434, and SQLServer.exe), both server and VM
From my VM, I can ping my server ip (192.168.1.10)

But I still get this error

A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: TCP Provider, error: 0 - No such host is known.)

Connection strings that I have tried are:

Data Source=ip_address,1433; Initial Catalog=inventory; Integrated Security=True
Data Source=server_name,1433; Initial Catalog=inventory; Integrated Security=True
Data Source=ip_address,1433; Initial Catalog=inventory; Integrated Security=False
Data Source=server_name,1433; Initial Catalog=inventory; Integrated Security=False

You need to add username and password to the connection string for a user that can access the sql — 3dd
– 3dd, Commented Apr 7, 2018 at 10:25
Are both computers on the same Domain? That is - is there a domain controller on the network? If not, you need to refer to the comment by @3dd — Grantly
– Grantly, Commented Apr 7, 2018 at 10:28
@Jepher you can use Integrated Security=True if you are calling database from another computer, you will have to do SQL Authentication instead of windows. — Abdul Qayyum
– Abdul Qayyum, Commented Apr 7, 2018 at 10:30

JC Cabili · Accepted Answer · 2018-04-07 10:35:43Z

0

First add a new user to login your credentials. Your connection string should be look like this Data Source=(server);Initial Catalog=(server);User ID=(username);Password=(password)

Next open your Windows Firewall with advanced security on your server.

Add new rule.
Select TCP and set on specific local port 1433.
Allow the connection.

and restart your server and try to connect again.

answered Apr 7, 2018 at 10:35

JC Cabili

161 bronze badge

Sign up to request clarification or add additional context in comments.

3 Comments

Jepher Over a year ago

i have created a new login credentials. but im encountering this error "The database inventory is not accessible. (ObjectExplorer)". resolve the issue by setting the created user to be sysadmin.

Jepher Over a year ago

but i have found out also in this link a solution "msdn.microsoft.com/en-us/library/ms188236(v=sql.110).aspx" but im lost on the procedures. i dont know how can i get to SQL Server advanced Properties, and where is the command prompt in the sql server?

JC Cabili Over a year ago

On your Login Property>User Mapping select your database and set role membership to owner.

Collectives™ on Stack Overflow

How to connect a C# windows form to a SQL Server database on another computer?

1 Answer 1

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related