| Haydar Tuna 2007-02-21, 3:57 am |
| 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@gmail.com> wrote in message
news:a16da1ff0612211052o69fe337bx454b567
89a348739@mail.gmail.com...
>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?
>
|