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:[EMAIL PROTECTED]] > Enviado el: jueves, 30 de enero de 2003 17:44 > Para: [EMAIL PROTECTED] > 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:[EMAIL PROTECTED]] > 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 > > -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
