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 ...
http://www.connectionstrings.com/

 

[Peng Jie]

integrated security=SSPI;

add this to your web.config

 

[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

 

[Dave Smith]

This does not work for me. I receive an Sql exception with the
following message: "Login failed for user '\'." Any thoughts on this?
There is no web.config. This is a windows service.