sql server remote connection

am trying to connect to sql server in a remote database by using windows
authentication. I tried to connect using php and cgi. The apache service
under which i am running my cgi or php is under localsystem account. If i
change it to administrator account, i am able to connect to remote sql server
using windows authentication. But due to some limitations i want the apache
server/service to be run only on localsystem account, but to connect to
remote sql database using windows authentication. ( I dont want to use mixed
mode in SQL)Is it possible to connect using cgo or php?If it is possible what
is the connection string to be used? Or is SQLAuthenticatin compulsary be
used in connectng to remote sql server?.
the connection string that i am using are given below:

"Provider=sqloledb;Network Library=DBMSSOCN;Data Source=PMP3,1433;Initial
Catalog=PMP_V3_0;Integrated Security=SSPI";

strConnection = _T("Driver={SQL Server};Server=MyServerName;"
"Trusted_Connection=yes;"
"Database=MyDatabaseName;");

.

Relevant Pages

  • Re: Windows Authentication in asp.net 2005 to SQL Server?
    ... If the domains do not trust each other, Windows authentication is not going ... Basic authentication sometimes makes the need for Kerberos delegation go ... generic account to do the backend data stuff on our SQL Server. ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • Re: Remote connection failed
    ... If you are going over a remote connection or are not logging ... into the domain where SQL Server is then no, Windows ... authentication won't work. ...
    (microsoft.public.sqlserver.connect)
  • Re: Changing passwords / Blocking SA login attempts
    ... I went into the Server Config properties and changed to Windows ... My login for Start and Run SQL server was in this format. ... I am supposing this was an SQL authentication, ...
    (microsoft.public.sqlserver.security)
  • Windows Authentication with IIS on separate machines
    ... Yes, setting Basic Authentication in IIS works, but the ... >in SQL server but doesn't work if user account was ... >imported from a Windows account. ...
    (microsoft.public.sqlserver.security)
  • Re: server authentication & ASP authentication
    ... on to the client workstation with an authorized Windows account. ... SQL Server with Windows authentication. ...
    (microsoft.public.sqlserver.security)
Loading