Remote Mssql connection

[Johnny]

Alright i think i almost got it working though. i used this to get mssql to allow the connection:

To view the content, you need to sign in or register

and here is my register scipt before i started editing it:

$mssql_server = "\SQLEXPRESS"; //MSSQL server name or IP
$mssql_username = ""; //MSSQL username
$mssql_password = ""; //MSSQL password
$mssql_account_db = "ACCOUNT_DBF"; //MSSQL account database name
$mssql_character_01_db = "CHARACTER_01_DBF"; //MSSQL character database name
$mssql_account_table = "account_tbl"; //MSSQL account table name
$mssql_username_column = "account"; //MSSQL username column in account table
$mssql_password_column = "password"; //MSSQL password column in account table
$hash = "sdfgsdfhhh"; //Hash code
$random_text_text = "123454"; //Random text they must enter to register

$con = mssql_connect("myip:1433","username","password"); 
//$mssql_server = "\SQLEXPRESS"; //MSSQL server name or IP
//$mssql_username = ""; //MSSQL username
//$mssql_password = ""; //MSSQL password
$mssql_account_db = "ACCOUNT_DBF"; //MSSQL account database name
$mssql_character_01_db = "CHARACTER_01_DBF"; //MSSQL character database name
$mssql_account_table = "account_tbl"; //MSSQL account table name
$mssql_username_column = "account"; //MSSQL username column in account table
$mssql_password_column = "password"; //MSSQL password column in account table
$hash = "sdfgsdfhhh"; //Hash code
$random_text_text = "123454"; //Random text they must enter to register
$random_text_text = "123454"; //Random text they must enter to register

I'm stuck on this part. do i use $con = mssql_connect("myip:1433","username","password");

or do keep the script the same and use:
$mssql_server = "\SQLEXPRESS"; //MSSQL server name or IP

cuz i see where it says IP >.>

 

[ShadowDragon]

keep the script how it was, and change the $mssql_server, username, and password values. you don't need to connect externally (which would mean your internal/external IP), you can just use localhost or 127.0.0.1 (ie. "localhost\SQLEXPRESS")

 

[Johnny]

im trying to move it to my webhost. I have the script working on the localhost where the server is hosted. I want to move it to my webhost and have mssql connect remotely its safer and more webhost site will always be up

 

[ShadowDragon]

ah, I see. I guess I missed the title lol and you didn't mention that in the post.

firstly, I need to know the setup for where the mssql server is. OS and whether or not you have a router should be enough.

 

[Johnny]

well where the mssql is its windows server 2008 r2 : P and the webhost is hostgator. I did ask them about it they said that they allow remote mssql.

 

[ShadowDragon]

ok, I see. Make sure that the firewall is allowing incoming connections on port 1433 (unless you changed the default port).

In the php script, change the mssql_server variable to "IPport)\InstanceName"
the port number is optional, because it defaults to 1433. The instance name is whatever you named the SQL installation. If you went with the default instance, the name is "SQLEXPRESS"

If you're able to log into it from SQL Server Management Studio, it's easy to find the instance name.
It would be in one of the blurred areas on the left of my image.

 

[Johnny]

$mssql_server = "xx.xxx.xxx.xxx:1433\SQLEXPRESS"; //MSSQL server name or IP
$mssql_username = "sa"; //MSSQL username
$mssql_password = "adfdfghjhfg"; //MSSQL password
$mssql_account_db = "ACCOUNT_DBF"; //MSSQL account database name
$mssql_character_01_db = "CHARACTER_01_DBF"; //MSSQL character database name
$mssql_account_table = "account_tbl"; //MSSQL account table name
$mssql_username_column = "account"; //MSSQL username column in account table
$mssql_password_column = "password"; //MSSQL password column in account table

i have the port open with those setting i know that mssql is setup to get the connection. am i missing something? ima so make a guide for this If i get this working

 

[ShadowDragon]

does your webhost allow external mssql databases? lol only thing I can think of
when I went looking around for web hosts a while back, I only found support for MySQL

 

[Langstra]

I am sure, but you just said it had to be like xxx.xxx.xxx.xxx1413) and Johnny just missed the () around the port number, not sure if that gives the problem.
Johnny said his host supported mssql external connections so it should support it.

 

[ShadowDragon]

I am sure, but you just said it had to be like xxx.xxx.xxx.xxx1413) and Johnny just missed the () around the port number, not sure if that gives the problem.
Johnny said his host supported mssql external connections so it should support it.

Oh, I guess I grazed over the part about MSSQL being supported.

And no, the () would only make it worse lol I put it in parenthesis because the port number is optional.

I got a couple more ideas though. Are you sure you got the SQL Instance Name (the name after the \ in those places in the image I posted) type PERFECTLY? Any slight difference, even in capitalization could be a problem.

Here's the other one. Are you sure you restarted the sql service after enabling remote connections?

Other than that, I believe we've gone over everything. Btw, if you put SQL Server Management Studio on your local computer (you can do so without having any SQL instances running, which would waste resources), then you can attempt to log into it to see if remote connections are truly enabled. If you can log in through there but not the website, then you might have some other problem.

 

[Johnny]

i'll play with it more hopefully i get it. tired of using xampp. lols

 

[ShadowDragon]

xampp blows lol

 

[caja]

If you are going to host on windows, at least use a decent webserver.

 

[Johnny]

Any suggestions Caja?