MSSQL Server
| From: | Dan Shirah | Date: | Thu, 21 Dec 2006 18:52:40 +0000 |
| Subject: | MSSQL Server | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-42840@lists.php.net to get a copy of this message | ||
I cannot connect to my MSSQL server.
I use the following connection string:
php:
------------------------------
$connection = mssql_connect <http://php.net/mssql_connect>('server','user',
'password') or die ('server connection failed');
$database = mssql_select_db <http://php.net/mssql_select_db>("database_name"
, $connection) or die ('DB selection failed');
?>
------------------------------
The MSSQL server is setup to use Windows and Server Authentication. I have a
*local* dummy account setup for testing and when using this account I can
connect with no problems, but when I try and use my domain/network account I
cannot connect at all. (my network account has full access to the server,
database and tables) I can even login to the SQL Management Studio using
Windows Authentication and my network account, but still cannot connect
using PHP.
Any ideas?