question

LowkeyMoriOugai-3263 avatar image
0 Votes"
LowkeyMoriOugai-3263 asked ErlandSommarskog commented

my Sql progrom refuses to work on other computers

ok so my question is how do i get my sql server to be displayed properly for other people computers it seems to not have been working when i set up the database with the local connection so i connected to a database i created in sql server manager and added the connection string that it had but still didnt work and gave me an error saying to make sure my instance name is correct and that I need to check if i have remote connections turned on and i do but it still doesnt work. it seems to not want to work when i type display_data(); on the form load on a button and doesnt want to display on the grid view. please help ive been working on this project for quite sum time and i dont want to discard it considering it would make me lose the drive to code.

the string im using is
(@"Data Source = DESKTOP - UH0ETGE\SQLEXPRESS; Initial Catalog = DB_Server2; Integrated Security = True");

sql-server-generalwindows-forms
5 |1600 characters needed characters left characters exceeded
Toggle Comment visibility. Current Visibility: Visible to all users

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

4 Answers

NaomiNNN avatar image
0 Votes"
NaomiNNN answered

You're using Windows Authentication, so only you can connect to your laptop and SQL Server Express

5 |1600 characters needed characters left characters exceeded
Toggle Comment visibility. Current Visibility: Visible to all users

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

ErlandSommarskog avatar image
0 Votes"
ErlandSommarskog answered ErlandSommarskog commented

Well, Data Source = DESKTOP - UH0ETGE\SQLEXPRESS, that refers to that particular machine. I assume that this is your laptop.

I don't know exactly what you mean with "other people computers", but presumably you want them to run against their own database, so they would need to install SQL Express on their machines. That part of the connection string should be changed to read Data Source = (localhost)\SQLEXPRESS.

If your intention is that people really should connect to your laptop, I urge you to think twice. You don't want that. If you want people to a central computer, you need to put that name in the connection string. If that is also in instance of SQL Server Express Edition, you will need to use SQL Server Configuration Manager to enable remote connections, as this is disabled by default for Express Edition. You may also have to open ports in firewalls.

· 3
5 |1600 characters needed characters left characters exceeded
Toggle Comment visibility. Current Visibility: Visible to all users

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

LowkeyMoriOugai-3263 avatar image LowkeyMoriOugai-3263 ·

My intention is to have one database others can access not make an application for others to use “their own” database.

0 Votes 0 ·
LowkeyMoriOugai-3263 avatar image LowkeyMoriOugai-3263 ·

No my intention is not to allow people to access my computer my intention is to have a sql database that people on other devices can look at the stored information on it by running the application. My intention is to have one database others can access not make an application for others to use “their own” database.

0 Votes0 · Reply More

0 Votes 0 ·
ErlandSommarskog avatar image ErlandSommarskog LowkeyMoriOugai-3263 ·

So where did you put this database? Do you have the name of that instance in the connection string?

0 Votes 0 ·
TiborKaraszi avatar image
0 Votes"
TiborKaraszi answered

If you want other computers to be able to access your SQL Server, you need to make it accessible to the network. You use the SQL Server Configuration Manager tool and enable the "TCP/IP" protocol. Now your SQL server listens to that protocol. Take a note on the port number (re-start your SQL Server and then check) and make sure that there is no firewall in between that block access to that port on your computer.

5 |1600 characters needed characters left characters exceeded
Toggle Comment visibility. Current Visibility: Visible to all users

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

AmeliaGu-msft avatar image
0 Votes"
AmeliaGu-msft answered

Hi LowkeyMoriOugai-3263,

In addition, for named instance, if the sql server is listening on the dynamic port, please make sure the SQL Server browser is running, and UDP 1434 is opened in the firewall. If sql server is listening on the specific port, please make sure you have added firewall rule for the port.
Please refer to https://docs.microsoft.com/en-us/sql/sql-server/install/configure-the-windows-firewall-to-allow-sql-server-access?view=sql-server-ver15 and https://docs.microsoft.com/en-us/sql/database-engine/configure-windows/configure-a-server-to-listen-on-a-specific-tcp-port?view=sql-server-ver15 which might be helpful.

Best Regards,
Amelia

5 |1600 characters needed characters left characters exceeded
Toggle Comment visibility. Current Visibility: Visible to all users

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.