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 |
|
rikleo2001
Posting Yak Master
185 Posts |
 Posted - 2009-08-06 : 11:05:49
|
| Hi Guys I need your help.Here is situation.Application server Windows service run as domain account zyz\test ODBC connection with windows authentication Database Server zyz\test is system admin on sql server.If I log on to app server using zyz\test, and start windows service, it work perfectly fine.Here is my question.When I configure application server ODBC connection to use sql account test1 (existin in sql server with system admin) and start this service (service look for odbc connection) at that point service won't start, it come up with login failed..Not sure how can I connect to database using sql account via ODBC connection.Any suggestions please?Thanks in advance.SKR |
|
|
|
|
|
ODBC connection with SQL account