Hi Uday -
You'll probably have more luck in one of the following newsgroups:
microsoft.public.sqlserver.connect
microsoft.public.sqlserver.odbc
microsoft.public.sqlserver.programming
Or even one of the .net newsgroups.
This one is dedicated to SQL Server Notification Services.
--
Joe Webb
SQL Server MVP
~~~
Get up to speed quickly with SQLNS
http://www.amazon.com/exec/obidos/tg/detail/-/0972688811 I support PASS, the Professional Association for SQL Server.
(
www.sqlpass.org)
On Tue, 10 May 2005 03:50:06 -0700, "uday"
[quoted text, click to view] <uday@discussions.microsoft.com> wrote:
>> 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;");
