Recently made a system in c #, the system connection is SQL database, run on your computer is normal, the main data source in the connection string is local, now I want to run on other computer system is not because I can't access the database, is there a way to let other computer database to access my computer?

CodePudding user response:

Look at this thread a try, https://bbs.csdn.net/topics/340257564

CodePudding user response:

Configure IP port in all set a new 11111

Then write IP in the connection string, 11111.

CodePudding user response:

The database on the server

CodePudding user response:

Database address to you the address of the machine, don't 127.0.0.1. Pay attention to the opening of the firewall,

CodePudding user response:

Computer, you need to add in the firewall to allow SQL server running
SQL server to allow remote connections

CodePudding user response:

I would like to, on the server on the server

CodePudding user response:

Their database on the server, the system after the release of deployment to the same server, the connect to the database in the configuration file to modify address modification for connecting to the database,

CodePudding user response:

First, you need to realize is that in the local area network (LAN) through the IP access, visitors to the server (in computer network) can be access in computer network, basic can Ping, in order to realize the Ping, there may be a firewall Settings, IP Settings, and so on, the purpose is to let two computers connected via TCP, program, the need to connect the visitor's location in the string database Settings for the server IP information,
After implementation in the wan IP access, realization method of the same local area network (LAN), the only extra operation, may be the realization of Ping, may be more than the router Settings, switch Settings, etc.,
Wan is actually a bigger complex LAN, you understand the LAN, wan also nothing,

CodePudding user response:

refer to 7th floor sxty0220 response:

their database on the server, the system after the release of deployed on the same server, the connect to the database in the configuration file to modify address modification for connecting to the database,

What's recommended server

CodePudding user response:

The

reference - 9 floor? ???? Response:

Quote: refer to 7th floor sxty0220 response:

their database on the server, the system after the release of deployed on the same server, the connect to the database in the configuration file to modify address modification for connecting to the database,

What's recommendation of server

If a simple application, literally a common office computer can do server.
If the server and computer to access the database is a local area network (LAN), that as long as the firewall on the server system for database access port Settings, your program in the SQL connection address into a server IP address.

CodePudding user response:

The

references to the tenth floor jlennonxzy response:

Quote: - references 9 floor? ???? Response:

Quote: refer to 7th floor sxty0220 response:

their database on the server, the system after the release of deployed on the same server, the connect to the database in the configuration file to modify address modification for connecting to the database,

What's recommendation of server

If a simple application, literally a common office computer can do server.
If the server and computer to access the database is a local area network (LAN), that as long as the firewall on the server system for database access port Settings, your program in the SQL connection address into a server IP address.

Ok, thank you... I rented and tencent cloud service is used for a look