Hi,
I've got a problem connecting to a mssql server. mssql_connect seems to
ignore
the username I'm trying to contect as.
php seems correctly configured, extension directory set correctly,
php_mssql.dll
is set as an extension, ntwdblib.dll is in the system32 directory and
phpinfo
reports mssql correctly.
I'm using Metabase but I've added a line of debug prior to the call to
mssql_connect
i.e. :
echo "<p><b>connecting to $this->host as $this->user wiht a password
'$this->password'</b></p>";
if(($connection=mssql_connect($this->host,$this->user,$this->password))==0)
return($this->SetMSSQLError("Standalone query","Could not connect to
the Microsoft SQL server"));
This gives the following output:
connecting to guardian as vkirk with password ''
Warning: mssql_connect() [function.mssql-connect]: message: Login failed
for user 'GUARDIAN \IUSR_EPOTEST'. (severity 14) in
c:\Inetpub\wwwroot\skills\pod\metabase_mssql.php on line 58
Warning: mssql_connect() [function.mssql-connect]: Unable to connect to
server: guardian in c:\Inetpub\wwwroot\skills\pod\metabase_mssql.php on line
58
Could not install database: Could not connect to the Microsoft SQL server:
Login failed for user 'GUARDIAN\IUSR_EPOTEST'..
Any mssql or MS SQL experts know of anything. I'm using php version 4.3.1
under
IIS as cgi.
Thanks,
Vic
--
Victor Kirk
Analyst
Serco Integrated Transport
--
This message, including attachments, is intended only for the use by the
person(s) to whom it is addressed. It may contain information which is
privileged and confidential. Copying or use by anybody else is not
authorised. If you are not the intended recipient, please contact the sender
as soon as possible. The views expressed in this communication may not
necessarily be the views held by Serco Integrated Transport.
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
