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"" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
>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
