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

07/26/2013 02:19 karimwolf3#1

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 鳳凰城#2

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.

07/26/2013 03:12 karimwolf3#3

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 鳳凰城#4

[Only registered and activated users can see links. Click Here To Register...]

07/26/2013 03:33 karimwolf3#5

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 ..

07/26/2013 04:23 Zodiao#6

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

07/26/2013 04:25 Kape7#7

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.

07/26/2013 12:04 pushipu#8

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.

07/26/2013 14:59 Haxor#9

#moved

07/26/2013 22:36 karimwolf3#10

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="XXX\SQLEXPRESS" because i couldn't connect it with this server name ... please help

07/27/2013 01:06 prezlee44#11

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 [Only registered and activated users can see links. Click Here To Register...].

07/28/2013 15:55 karimwolf3#12

guys i need help ?