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 |
|
tll414
Starting Member
4 Posts |
 Posted - 2009-08-13 : 21:37:29
|
| My w2k3 server is part of a main domain (INSTRUC) and when I logon to SQL Server, I use Win Authentication (INSTRUC\tll414). My SS 2005 has a LinkServer to an MS Access .MDB file on the D:\ of w2k3 server and the connection works fine. But then all my fun started when I try to schedule jobs.With the above (INSTRUC\tll414) I am unable to run scheduled jobs (Error 15404). So I create a SS login of tll414Admin w\sysadmin rights and I can now exec schedule jobs, but tll414Admin can't connect to my LinkServer (error 7303).I've also tried creating tll414Admin on w2k3, w/admin rights, logged on SS 2005 w/SQL authentication but still get (Error 7303) on attempting to access LinkServer.My network people tell me this is a SQL Serv problem and they can't help... I noticed a service on w2k3, SQL ACTIVE DOMAIN HELPER, it is disabled. Would it help enabling this and would it be wise? Not sure why it is disabled. Any help appreciated.Tom |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2009-08-14 : 00:52:44
|
| SQL Agent service account needs permissions on mdb and share it lives on |
 |
|
|
|
|
|
SQL Serv 2005 login issues on w2k3