«

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

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

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


"ajit" <> wrote in message
news:46859B69-F1E7-4448-99D8-...
> how to configure .NET windows service to use windows authentication for
> SQL
> server

integrated security=SSPI;

add this to your web.config

"ajit" wrote:

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

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" <> wrote in message
news:9D38930F-6835-4985-BBF0-...
> integrated security=SSPI;
>
> add this to your web.config
>
> "ajit" wrote:
>
>> how to configure .NET windows service to use windows authentication for
>> SQL
>> server

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.



*** Sent via Developersdex http://www.developersdex.com ***