May 28, 2008 at 2:24 am
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.
May 28, 2008 at 2:31 am
Can you please tell what account the service is running under. If it is running under different account then check if that account has permission on the database server.
Basit Ali Farooq
MCITP Database Administrator
Microsoft Certified Professional Developer (Web Applications)
Microsoft Certified Database Administrator
Microsoft Certified Systems Engineer
Microsoft Certified Systems Administrator
CIW Security Analyst
Cisco Certified Network Associate
May 28, 2008 at 2:59 am
Hi,
The service is running under the system account which has full access and admin privilliges to the database.
thanks.
May 28, 2008 at 3:07 am
Now my next question is what PORT you are using to connect to the database. I mean what port your SQL Server service is using. Check if you can telnet that PORT from the computer where this service is running.
Basit Ali Farooq
MCITP Database Administrator
Microsoft Certified Professional Developer (Web Applications)
Microsoft Certified Database Administrator
Microsoft Certified Systems Engineer
Microsoft Certified Systems Administrator
CIW Security Analyst
Cisco Certified Network Associate
May 28, 2008 at 3:42 am
Hi,
I have been able to telnet to the SQL Server port (2569). Although, the SQL Server and the service I have written are running on the same machine. I have also tried running the service from a different machine and still have the same problem.
Thanks.
May 28, 2008 at 5:34 am
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.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply