CODEWITHSUNDEEP
sqlsql-servervb.netvisual-studiowinforms
Cheddar
Cheddar

Reputation: 530

Set up SQL Server to be accessible by all computers on a network via program manipulation

I am testing a SQL Server for my company as an on-site database for manufacturing data and records. I have the SQL Server on my laptop and have set up permissions and downloaded SQL Server Management Studio on other computers in the company and managed to connect via SQL Server authentication.

However, I can't get Windows Authentication to work. I also have a Visual Basic program that I can run on my laptop that will communicate with the SQL Server that is locally on my machine but that program will not work on other computers in the company because they can not connect to the SQL Server.

How do I set up SQL Server to allow for Windows authentication on any company computers running that program? I opened a port on my Windows firewall on the computer that has SQL Server installed, and it seems to work with SQL Server authentication.

The connection string I am using in my Visual Basic program is as follows:

Dim connstring As String = "Data Source = Server; integrated security = true"

I assume I need to change something in my logins folder in my SQL Server?

My desired result would be for any computer running this application to be allowed to communicate with SQL Server and be able to read and write data.

Upvotes: 0

Views: 682

Answers (1)

David Browne - Microsoft
David Browne - Microsoft

Reputation: 89091

any computer running this application to be allowed to communicate with SQL Server

The normal configuration to enable this is:

1) The SQL Server must be running on a server joined to the domain.

2) The SQL Server is configured to use TCP/IP and listen on port 1433.

3) The other computers are also joined to the domain.

4) The users logged in on the other computers are added as Windows logins. in SQL Server, and mapped to users in the desired databases (can use groups instead of individual users).

See eg: How to add Active Directory user group as login in SQL Server

Upvotes: 3

Related Questions