|
Home > Archive > MS SQL Server ODBC > June 2005 > sql server remote connection
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
sql server remote connection
|
|
|
| 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;Ne
twork Library=DBMSSOCN;Dat
a Source=PMP3,1433;Ini
tial
> Catalog=PMP_V3_0;Int
egrated Security=SSPI";
>
> strConnection = _T("Driver={SQL Server};Server=MySer
verName;"
> " Trusted_Connection=y
es;"
> " Database=MyDatabaseN
ame;");
| |
| Srik Raghavan 2005-06-22, 3:23 am |
| 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@microso
ft.com...
> i am trying to connect to sql server in a remote database by using windows
>
|
|
|
|
|