Setting up MSSQL (with PHP)

[oohoohoohooh]

Hi, I followed the following tutorial to setup IIS with MS SQL Server DE here:

http://www.geekpedia.com/prog_ttrls.php?id=57

I also installed the web data administrator fine. Finally I removed the ; before extension=php_mssql.dll in the PHP config file.

Until now everything seems to be working fine but my problem lies with connecting to the database. What is the servername parameter you pass in mssql_connect? Also what is the username and password? I managed to add a database ok using the web data administrator but when I clicked create new user (in the users section of my database) it only gave me the option to put the username which I thought was strange but I entered the username and clicked submit but it returned an asp error.

I assumed the server might be the server indicated in the SQL Server Service Manager. I also put the username as dbo (since that user already existed - I noticed it from the web data administrator) and left the password blank since no password was indicated but again no luck.

I'd appreciate if someone could help. Thanks

Note: I did post this in the PHP forum but they told me to post it here. Thanks

 

[mrdenny]

The server name parameter will be what ever name the web server needs to use to talk to the SQL Server. Either the machine name or the full FQDN (server.domain.com).

The username and password will be what ever accout you setup on the SQL Server and gave access to the database you want to access. In Enterprise Manager you'll see the accounts under the Server > Security > Logins.

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

(Not quite so old any more.)