SQL Authetication in windows service

[ajit]

how to configure .NET windows service to use windows authentication for SQL
server

[Daniel Fisher\(lennybacon\)]

just create a connectionstring that uses WinAuth ...
[url]http://www.connectionstrings.com/[/url]

--
Daniel Fisher(lennybacon)
MCP ASP.NET C#
Blog: [url]http://www.lennybacon.com/[/url]


"ajit" <ajit@discussions.microsoft.com> wrote in message
news:46859B69-F1E7-4448-99D8-9306080DBD29@microsoft.com...

> how to configure .NET windows service to use windows authentication for
> SQL
> server

[Peng Jie]

integrated security=SSPI;

add this to your web.config

"ajit" wrote:

> how to configure .NET windows service to use windows authentication for SQL
> server

[Khan Imran]

try this

myConnection = new
SqlConnection("server=localhost;trusted_connection =true;database=xxxxx");
myconnection= new SqlConnection("data source=server address;initial
catalog=xxxx; Trusted_Connection=yes")

Khan Imran
"Peng Jie" <PengJie@discussions.microsoft.com> wrote in message
news:9D38930F-6835-4985-BBF0-4EBC1E8BF7C7@microsoft.com...

> integrated security=SSPI;
>
> add this to your web.config
>
> "ajit" wrote:
>

>> how to configure .NET windows service to use windows authentication for
>> SQL
>> server