[msfdisk]

I think I have everything all correct in my connection, however Do I have to have a user name and password to connect to the db on the web server? The DBA just told me to use windows auth. that works with my local machine connecting to the local db but not on the web server.

Here is what I have for connection:

$host = "SQLEXPRESS";
$database = "mydatabasename";
$dbUser = "";
$dbPass = "";

//connect
$connect = mssql_connect("$host", "$dbUser", "$dbPass") or die("could not connect to server");

[knight_47]

Yes you do need a username and password that connects to your Database. Also, not only do you have to create a username, with a pass, you have to ADD that to the database, with full permissions. You should be able to do this in your Hostings Control Panel.

I'm not very good with Databases right now, but check out this link for more info:

http://www.phpfreaks.com/tutorials/142/0.php

[Gibbs]

For host you would use a domain (www.domain.com), localhost (localhost or 127.0.0.1) or an IP address.

The user/pass is usually the username/password provided/used by your host.

If your running the server locally (on your PC at home) you should use "root" for testing and if you haven't set a password then there most likely won't be one.

Are to trying to connect to a remote database (one that's not on your computer)?