iis - mssql server - remote connection help

Please help....

I am wondering how to remotely connect to my mysql database.

The database is sitting on a Windows 2000 Server machine, with IIS and MySQL 2000 Server.

I know the IP address, the server name, username, passwords. Yet I still can't connect. Is it a security issue, or am I using the wrong connection string.
Do I have to configure anything in IIS?
If anybody thinks they can help, I'll send you the connection info, and you can test it out.....

Thanks.

Aratbor, can you please give a few more details as to what you are trying to accomplish? Are you trying to have a web page connect to a sql server backend or are you trying to establish a connection from IIS to MSSQL for some other reason? If you are trying to query data for a dynamic webpage, please give a list of the technologies you are using and how you are currently trying to connect to the database. From there we should be able to help you out a bit more.

-- messorian

I am ultimately trying to display dynamic data on a web page using 'php'.
In the past, I have used a service provider who hosted my database. But now, I have my own windows 2000 server with MS SQL 2000 server.

This is how I usually connect.

$host = 'sql.hostname.com';
$username = 'username';
$password = 'password';
$dbname = 'databasename';
$Link = mysql_connect( $host, $username, $password );


When I configured my 'MS SQL server', I have a specific ServerName (apparently you can have multiple server instances)
I have called this server 'MYSERVER'

I hope this is descriptive enough.


Thanks again.

You are using the mysql functions, but since you have MSSQL you need to use those!
Take a look at the manual available at www.php.net
Also this article could be of some help at least in configuring your connection to db (http://www.devarticles.com/art/1/100)

As pabloj noted, you are using the wrong functions to connect to Microsoft Sql Server. You want to use mssql_pconnect(). To get the mssql functions to work take the following steps:
1) Open the php.ini file
2) Search for: ;extension=php_mssql.dll
3) Remove the semi-colon to uncomment the line
4) save the file
5) change your code to use the mssql_* functions.


Now, if you get an error at this point saying that it can not find the required dll, all you need to do is download the binary zip file for windows (not the installer). Now, hunt around in the zip file and you will find php_mssql.dll. Simply unzip the single file into your php directory and you should be all set.

-- messorian

Below is a link to the php documenation for mssql.
Accessing MSSQL from php

If you can use an ODBC connection, simply use the MS Client Network Utility to create a TCP/IP Alias. Give it a name and point it to the IP address of the server. Then, create an ODBC connection against that alias. Now you're connected to the remote SQL Server across the Internet.
-Dave