Or use the mssql.secure_connection = On in php.ini to allow the system to use the current user account for authentication. - Frank > Hello, > If you can change the SQL Server Authentication to the Mixed Mode > (Windows and Remote User), your problem will be fixed. If you use the Unix > like Operating System, you can install FreeTDS package to connect MSSQL > Server.:) > > > > -- > Haydar TUNA > Republic Of Turkey - Ministry of National Education > Education Technology Department Ankara / TURKEY > Web: http://www.haydartuna.net > > ""Dan Shirah"" <mrsquash2@xxxxxxxxx> wrote in message > news:a16da1ff0612211052o69fe337bx454b56789a348739@xxxxxxxxxxxxxxxxx > >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? > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
