How to link sro server site with web host and access the database?

karimwolf3 · 07/26/2013, 02:19

How to link sro server site with web host and access the database?
I bought a web host but couldn't link the hosted site with the database on dedicated server

鳳凰城 · 07/26/2013, 02:27

You'll buy a domain and relate the refferal link to your host ip, Install IIS, get website files, set the sql info and you're done.

karimwolf3 · 07/26/2013, 03:12

Quote:

Originally Posted by Phoenix 1337

You'll buy a domain and relate the refferal link to your host ip, Install IIS, get website files, set the sql info and you're done.

can you please please explain more ?

鳳凰城 · 07/26/2013, 03:30

karimwolf3 · 07/26/2013, 03:33

I already have domain and host bro .. but the problem now i can't link the webfiles to the host and allow this files to read the data from game database from the dedicated server ..

Zodiao · 07/26/2013, 04:23

1-Open SQL's port.
2-Open remote connection for SQL.
3-Use the IP instead of your SQL Instance.

Kape7 · 07/26/2013, 04:25

Quote:

Originally Posted by Sir*EviL

1-Open SQL's port and make a rule on the firewall for allow only website's IP address to access it.
2-Open remote connection for SQL.
3-Use the IP instead of your SQL Instance.

Fixed.

pushipu · 07/26/2013, 12:04

Some linux hosts doesn't have support to connect ms sql database, or like in my case some have default mssql port closed, you must contact first your hosting, after you must do what Sir*EviL say.

Haxor · 07/26/2013, 14:59

#moved

karimwolf3 · 07/26/2013, 22:36

i will tell you what i actually want .. i want the code in the config.php that would allow me to connect the site from WEB HOST to the game database on DEDICATED SERVER .. so i want a code that don't use servername="***\SQLEXPRESS" because i couldn't connect it with this server name ... please help

prezlee44 · 07/27/2013, 01:06

Ah so you are asking about the connection string...

Here is an example for that.

Code:

Data Source=190.190.200.100,1433;Network Library=DBMSSOCN;
Initial Catalog=myDataBase;User ID=myUsername;Password=myPassword;

DBMSSOCN=TCP/IP is how to use TCP/IP instead of Named Pipes. At the end of the Data Source is the port to use. 1433 is the default port for SQL Server. Read more

.

karimwolf3 · 07/28/2013, 15:55

guys i need help ?