sql server remote connection
- From: "uday" <uday@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Tue, 10 May 2005 03:50:01 -0700
> 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;");
.
- Prev by Date: sql server remote connection
- Next by Date: Re: Batch File.
- Previous by thread: sql server remote connection
- Next by thread: Every 2 seconds hiting.
- Index(es):
Relevant Pages
|
