Re: MSSQL 7 getting wrong username
| From: | Adam Voigt | Date: | Thu, 24 Apr 2003 17:09:21 +0000 |
| Subject: | Re: MSSQL 7 getting wrong username | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-145185@lists.php.net to get a copy of this message | ||
It sounds like your SQL server is only set to accept domain login's,
and not SQL-server specific login's.
On Thu, 2003-04-24 at 12:46, Chris Cameron wrote:
> I'm trying to use PHP 4.3.1 with MSSQL 7 on Win2k and I'm having issues
> with connecting to the database.
>
> A simple PHP file of:
> <?php
> mssql_connect("DEVELOPER", "wft_php", "pass");
> ?>
>
> Brings back:
> Warning: mssql_connect() [function.mssql-connect]: message: Login failed
> for user 'DEVELOPER\IUSR_NOAH-QZHC2JI0XV'. (severity 14) in
> c:\inetpub\wwwroot\index.php on line 2
>
> So, the thing I've noticed is, regardless of what username I put in the
> mssql_connect() function, the error message shows the user as
> "DEVELOPER\IUSR_NOAH-QZHC2JI0XV" (the name of the IIS user).
>
> Also, the PHP page for mssql_connect() mentions I should have a
> "interfaces" file, which I haven't been able to find anything about.
>
> Any ideas?
>
> Thanks,
> Chris
--
Adam Voigt (adam@cryptocomm.com)
Linux/Unix Network Administrator
The Cryptocomm Group