Re: [PHP] [Linux] PHP and SQL Server

Le Tue, 22 May 2007 14:18:31 +0200,
Tijnema <tijnema@xxxxxxxxx> a écrit :

On 5/22/07, David BERCOT <david.bercot@xxxxxxxxxx> wrote:
Hi Mike,

And thank you for your help...

Le Mon, 21 May 2007 13:21:35 -0400,
"Mike Smith" <mikeosmith@xxxxxxxxx> a écrit :
On 5/21/07, David BERCOT <david.bercot@xxxxxxxxxx> wrote:
Hi Mike,

Le Mon, 21 May 2007 10:24:52 -0400,
"Mike Smith" <mikeosmith@xxxxxxxxx> a écrit :
David,

Is MSDE running in mixed mode authentication? I believe by
default it only uses Windows authentication. If you're not
sure you can readup on how to check (and change if necessary):

http://support.microsoft.com/kb/325022

I've just had a look and MSDE is in mixed mode (2 !) :-(

Thank you.

David.
I vaguely remember having to add :1433 to the freetds.conf on one
Debian server. A quick google turns up this, but I think I put the
server:port on one line (i.e. 192.168.1.11:1433):

http://lists.evolt.org/archive/Week-of-Mon-20030915/148291.html

I've tried some modifications and I've searched for others ideas
with Google, but nothing's right !!!
I don't know at all what to do...

May be a miracle if someone can help me ?

Thank you very much.

David.

Is the SQL server and the PHP script running on the same machine? If
so, you should specify 127.0.0.1 or localhost for the server, and not
the IP.

No. SQL Server is under Windows XP and the PHP script is under
Debian !!!

David.
.

Relevant Pages

  • Re: Credentials not being passed with remote access
    ... allowed windows authentication to work, ... I had assumed johnx was a domain user rather than a local Windows account. ... johnx was set up as a local login on sql server. ...
    (microsoft.public.sqlserver.security)
  • Re: Regarding setup for SharePoint Services 2.0...
    ... But after installation, all WSS functionality will ... continue to work if you switch back to Mixed Mode. ... like) that get real flaky if you are not running in Windows Only SQL Server ... advantages to Microsoft from a security perspective moving to a Windows Only ...
    (microsoft.public.sharepoint.windowsservices)
  • Re: asp.net sql trusted connections between machines
    ... > connect to a remote SQL Server instance w/ Read-Write permissions. ... > connection string in the web.config. ... > Windows Authentication setting for access via IIS doesn't seem pass the ... is this impersonation behavior with IIS and Windows Authentication ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Very basic login question
    ... In order to use Windows Authentication the two computers have to be members of the same domain or trusted domains. ... you should have a login at the SQL Server on the XP Pro workstation. ...
    (microsoft.public.sqlserver.security)
  • Re: How to install and configure SQL Server 2005 on Net work and s
    ... database to backend and then link all table from front Access database to ... we never allowed user can login to sql server to do any thing, ... Each user they required Windows Authentication when they open they won ... install the sql server. ...
    (microsoft.public.sqlserver.security)