hello guys
i know that many here they did that: mu server in my pc..but website of the server in another host..like a free web hosting
but how can i make the config file of website to communicate with my sql server?
hello guys
i know that many here they did that: mu server in my pc..but website of the server in another host..like a free web hosting
but how can i make the config file of website to communicate with my sql server?
You need MSSQL connection on the website.
My suggestion?
Buy some web hosting with mssql connection it's really cheap in USA
Greetings,
FunPeople.
Buy some web hosting with mssql connection, what does it mean??
anyway the answer is
1-buy a webhosting.
2-Make sure your sqlserver open remote connection(How to: Enable the TCP/IP Protocol for a Database Instance)-for 2005 also same all others.
3-change your sql port for securty(u can searc at google how to do it)
4-open your sql port (in firewall with expection, change settings to open connection only one ip and this IP would your hosting server ipfor securty reason close any other connection request ip)
5-if u use php connection string.
<?php
$dbconnect = mssql_connect("xxxxxxxx\sql instance name", $dbUser, $dbPass);
?>
6- if u wish use aspx connection string(i strongly recommended this, there is no even need explain this "php>MSSQL"(somekind of joke))
<connectionStrings>
<add name="sqlconn" connectionString="Data Source=xxxxxx ;Network Library=DBMSSOCN; Initial Catalog=MuOnline; User ID=sa;Password=xxxxxxx_;Integrated Security=SSPI;Trusted_Connection=False;Pooling=yes; min pool size=0; max pool size=100;" providerName="System.Data.SqlClient"/>
</connectionStrings>
7-well done best way to run a good server seperate web hosting and Gameserver.
