Re: MS SQL connect
| From: | Peter Vereshagin | Date: | Thu, 28 Mar 2002 14:14:21 +0000 |
| Subject: | Re: MS SQL connect | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-17996@lists.php.net to get a copy of this message | ||
On Thu, 28 Mar 2002 14:44:23 +0200, Cid <calin@grafoprint.ro> wrote:
> I'm trying to connect to an MS SQL Server but I'll receive permanetly
> this message:
>
> Warning: MS SQL message: Login failed for user 'mirela'. Reason: Not
> associated with a trusted SQL Server connection. (severity 14) in
> d:\inetpub\wwwroot\roslocal\registrums.php on line 24
>
> Warning: MS SQL: Unable to connect to server: aserver in
> d:\inetpub\wwwroot\roslocal\registrums.php on line 24
> Nu am reusit sa ma conectez
>
>
> If I run an ASP code it works fine.
>
seems your SQL Server accepts only trusted login requests (the 'Windows authentication').
It's not quite perfectly works in PHP. You would either set up your MSSQL on 'SQL
authentication' too or try to get the FreeTDS (if your PHP MSSQL extension compiled with it)
connect via this authentication. As far as I read their mailing list it is not impossible, I
didn't try myself though.
Seems your ASP web server able to connect via those "trusted sockets" What the database
interface of your choice for them? ODBC? ADO? else? perhaps PHP can handle them?