RE: [PHP-WIN] SQL SERVER TRUSTED CONNECTION HELP
| From: | Frank M. Kromann | Date: | Fri, 31 Jan 2003 03:27:07 +0000 |
| Subject: | RE: [PHP-WIN] SQL SERVER TRUSTED CONNECTION HELP | ||
| Groups: | php.windows | ||
| Request: | Send a blank email to php-windows+get-18260@lists.php.net to get a copy of this message | ||
If your SQL Server is configured with both SQL and Windows auth you shoule
be able to connect using a SQL user. You need to configure both Server and
client to use the same default protocol, or configure an alias at the
client using the protocol expected by the server.
These configurations are done with 'Server Network Utility' and 'Client
Network Utility'
When this configuration is correct (and tested with Query Analizer) you
can start using PHP. You might set
mssql.secure_connection = On
in your php.ini file. This will cause the MSSQL extension to use a trusted
Windows logon when connecting to the server. You still have to configure
the protocols though.
- Frank
> It is XP professional .. the scripts are running on a NT box on IIS 4
> and database on XP professional.
>
>
> Thanks for your reply.
>
>
> -----Mensaje original-----
> De: Bruce Barnes [mailto:bbarnes@mail.chicagonettech.com]
> Enviado el: jueves, 30 de enero de 2003 17:44
> Para: php-windows@lists.php.net
> Asunto: RE: [PHP-WIN] SQL SERVER TRUSTED CONNECTION HELP
>
> What version of XP are you running. If you are not running XP
> Professional
> and you have an Internet connection, it will NOT connect simultaneously
> to
> another computer or server.
>
> Bruce Barnes
> ChicagoNetTech / Rinella Internet Services
>
> -----Original Message-----
> From: Daniel Masson [mailto:dmasson@imagine.com.co]
> Sent: Thursday, January 30, 2003 16:27
> To: 'PHP-WIN'
> Subject: [PHP-WIN] SQL SERVER TRUSTED CONNECTION HELP
>
>
> Hello list.
>
> I know about sql server authentication (windows and sql) y installed
sql
> server 2000 on an win xp box, and my server already has "SQL and
windows
> authentication", and still my php script goes "Login failed for user
> 'myuser'. Reason: Not associated with a trusted SQL Server connection.
"
>
> Anyone got this before ??
>
> Scripts are in a NT4 box and sql server 2000 on a xp box.
>
> Thanks every1 any help would be very very appreciated.
>
>
> --
> PHP Windows Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
>
>
> --
> PHP Windows Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
> --
> PHP Windows Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>