I had some issues a couple years ago connecting to the MS SQL Server where I was employed at the time. I was probably just doing something wrong, but what I ended up using that worked for me was using the ADODB database abstraction layer. Helped me connect to MS SQL , Oracle and some other random data sources I had to from time to time. http://adodb.sourceforge.net/ Sorry I don't have time to look for good examples, but maybe the documentation will help out some and get you on the right path. -TG = = = Original 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? ___________________________________________________________ Sent by ePrompter, the premier email notification software. Free download at http://www.ePrompter.com. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
