Ver Mensaje Individual
  #2 (permalink)  
Antiguo 01/04/2009, 13:03
Avatar de Triby
Triby
Mod on free time
 
Fecha de Ingreso: agosto-2008
Ubicación: $MX->Gto['León'];
Mensajes: 10.106
Antigüedad: 15 años, 9 meses
Puntos: 2237
Respuesta: no puedo conectarme a sql server 2005

Una solucion en ingles esta en: http://mx.php.net/function.mssql-connect

Cita:
Iniciado por php.net
Using Apache on a windows machine to connect to a networked SQL Server I was getting the following error:

Warning: mssql_connect() [function.mssql-connect]: message: Login failed for user 'DomainName\MachineName$'. (severity 14)

This occurred regardless of the username and the password that I passed to mssql_connect()

Apparently the username and password parameters are ignored when connecting to SQL Server with trusted connections. Instead it attempts to connect using the Web Server username and password instead. Under windows the default webserver account is the machine name (which is probably not set up as being a windows user).

This can be solved by configuring Apache to log on as a designated user.
- Open Control Panels
- Double click administrative tools
- Double click services
- Right click on Apache and choose properties
- Under the "Log On" tab choose "This Account" and type in a valid domain user account & password
- Restart the Apache service
__________________
- León, Guanajuato
- GV-Foto