i 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;");

Ensure that an SPN is registerd in active directory for the sqlserver
account. only kerberos will work in this case unless you use sql auth. for
kerberos to work the SPN associated with sqlserver must be registered in
active directory.

"uday" <uday@discussions.microsoft.com> wrote in message
news:C67F14FD-FEAB-415B-986F-A0107CD1C814@microsoft.com...
> i 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;");
>