Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
bkelly1977
Starting Member
2 Posts |
 Posted - 2008-05-28 : 04:39:05
|
| 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. |
|
|
bkelly1977
Starting Member
2 Posts |
Posted - 2008-05-28 : 07:35:46
|
| 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. |
 |
|
|
|
|
|
SQL 2K5 not allowing connection from win service