Click here to Skip to main content
16,012,759 members

Comments by TolgaKaradayi (Top 1 by date)

TolgaKaradayi 29-Dec-11 4:05am View    
Thank you for your interest SAKryukov.
Here is my stuation:
I have two windows applications.App A the main application and app B doing some stuf to to app A work properly.Both of them using same mssql instance and two databases mostly the sql server is working on a 2003 or 2008 r2 server.I have two services a web service working on a host on somewhere and a win service working on the same local server that sql instance runs.Win service listens TCP connections from app B and comminicates with web service and returns some data.But to do that win service must query data base that app A using.
The main problem is win service must find a way to read connection string to connect sql instance from somewhere on local server.
I have a setup that diploys both two applications, asking sql instance and database parameters and creating a data base for two applications.Win service set up is different.Two applications reading connection string from app A application config file.

So how can win service read connection string?
Note:Win service is runing under NT AUTHORITY\NETWORK SERVICE.