SQL Authetication in windows service

Discussion in 'ASP .Net Security' started by ajit, Feb 4, 2005.

  1. ajit

    ajit Guest

    how to configure .NET windows service to use windows authentication for SQL
    server
    ajit, Feb 4, 2005
    #1
    1. Advertising

  2. Daniel Fisher\(lennybacon\), Feb 4, 2005
    #2
    1. Advertising

  3. ajit

    Peng Jie Guest

    integrated security=SSPI;

    add this to your web.config

    "ajit" wrote:

    > how to configure .NET windows service to use windows authentication for SQL
    > server
    Peng Jie, Feb 6, 2005
    #3
  4. ajit

    Khan Imran Guest

    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:...
    > 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, Feb 9, 2005
    #4
  5. ajit

    Dave Smith Guest

    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 ***
    Dave Smith, Nov 9, 2005
    #5
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Replies:
    3
    Views:
    235
    Roger Upole
    Dec 20, 2006
  2. =?Utf-8?B?ZGF2aWQ=?=
    Replies:
    4
    Views:
    307
    =?Utf-8?B?ZGF2aWQ=?=
    Aug 17, 2007
  3. rodrigo
    Replies:
    1
    Views:
    103
    rodrigo
    Aug 21, 2003
  4. Andy

    ASP.NET windows authetication

    Andy, Dec 1, 2004, in forum: ASP .Net Security
    Replies:
    6
    Views:
    129
    Paul Clement
    Dec 14, 2004
  5. omar
    Replies:
    0
    Views:
    112
Loading...

Share This Page