Results 1 to 2 of 2
  1. #1
    Join Date
    May 2008
    Posts
    2

    Red face Unanswered: SQL Server 2005 not allowing connection from windows service

    Hi All,

    I have written a windows service using VB.NET that connects to a database and performs several tasks. The service is working correctly and has been fully tested against SQL Server 2000. I have recently moved to SQL Server 2005 and now, the service will not connect to the database.

    I have setup and tried several different users, but none work, I get the following message:

    Login failed for user 'OEESYSTEMS'

    The server instance, username and password I specify are all correct.

    The service is running on the same server as SQL Server. I can connect through a web application, and through ODBC. The server is set to use SQL server and windows authentication, and is setup and successfully allows remote connections.

    It looks like SQL server sees that a windows service is trying to connect and does not allow it.

    For the love of god, can anyone help with this issue.

    Thank you.

  2. #2
    Join Date
    May 2008
    Posts
    2

    Smile

    Hi All,

    Apparently, several updates where installed on the server overnight, after it was restarted, everything worked fine.

    I appreciate the time people have taken to look at this issue.

    Thank you.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •