| Author |
Topic |
|
AAbdi
Starting Member
10 Posts |
 Posted - 2009-01-08 : 15:10:34
|
| Greetings to all,I have problem with maintenance plan: I have a SQL Server 2005; mssql is using local service account and mssql agent is using a domain service account. The domain service account has all the necessary permissions. In my maintenance plan I can do backup on local drive but not an the remote drive. I have given the service account full permission to the remote drive but when I typed \\server\share, I receive the following error:"The database engine service could not resolve the specified folder location. Either the location doesn't exist, or the current login account does not have access to it. Verify that the folder exists, and that the login account has permission on it." I can access the drive through windows but not through SQL Server. Obviously I am missing something. Please help. Thank you in advance. |
|
|
tosscrosby
Aged Yak Warrior
676 Posts |
Posted - 2009-01-08 : 16:30:54
|
quote:
Originally posted by AAbdi
Greetings to all,"The database engine service could not resolve the specified folder location. Either the location doesn't exist, or the current login account does not have access to it. Verify that the folder exists, and that the login account has permission on it." I can access the drive through windows but not through SQL Server.
AAbdi, either you misspelled the server name or share or the service account access is not adequate. The error is pretty direct. Whatever account is running the agent, needs at a minimum, write rights, obviously more than that if you also do backup file cleanup. Accessing via windows means your domain account, not necessarily the service account, has appropriate rights. Maybe get a network admin involved to help resolve potential security issues?Terry-- Procrastinate now! |
 |
|
|
AAbdi
Starting Member
10 Posts |
Posted - 2009-01-08 : 17:41:06
|
| Thank you for fast response Terry. I will check try to make sure I spelled correct and go through the permissions over again. Thank you very much. |
|
|
|
AAbdi
Starting Member
10 Posts |
Posted - 2009-01-08 : 18:30:17
|
| The service account has full share and NTFS permission, the account name is spelled correct and also retyped the password both on the service console and active directory. Nothing seems to work for me. I logged on to the sql server with the service account and I can browse the folder. But SQL doesn't connect. Any hint will help, thanks again. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
AAbdi
Starting Member
10 Posts |
Posted - 2009-01-08 : 23:20:22
|
| Dear Tara,When I tried manual backup I received access denied error. That was a good test but I don't know why access denied. I gave the service account full access everywhere but I don't understand why access denied. Thank you for your help. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
AAbdi
Starting Member
10 Posts |
Posted - 2009-01-09 : 11:41:11
|
| It gave the service account full permission everywhere but I can't figure it why access is denied. Thank you. |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-01-09 : 12:24:28
|
| Why MSSQL Services is running in Local Service account? Both SQL and SQL agent should run in domain service accounts. |
|
|
|
AAbdi
Starting Member
10 Posts |
Posted - 2009-01-09 : 13:49:53
|
| It was setup with local system account and I just changed the sql agent account to domain account. I will change mssql server also and try it tonight. Thank you. |
|
|
|
AAbdi
Starting Member
10 Posts |
Posted - 2009-01-10 : 11:43:22
|
| I did that but that didn't work. I am sure it is not permission problem but something is wrong in sql server. I see a hammer with red handle on the maintenance plan. I created a maintenane plan that works on local drive but that one also have a hammer with red handle. Thanks. |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-01-10 : 11:47:43
|
| Did you migrate from SQL 2000 to SQL 2005?Then see this:http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=98114 |
|
|
|
AAbdi
Starting Member
10 Posts |
Posted - 2009-01-10 : 12:08:23
|
| No, it is fresh install. Thank you. |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-01-10 : 12:13:44
|
| What edition of SQL Server is it? It means domain account doesn't have permission to access share folder. You should talk with Network admin. |
|
|
|
AAbdi
Starting Member
10 Posts |
Posted - 2009-01-10 : 12:22:03
|
| Actully I used the domain admin user account, I gave the service account full permission on the remote folder I also added the service account to the administrators group on the remote machine. Nothing seems to fix the problem. I built another server with exactly the same setup as the one with problem but the new server connected without any problem. Something is wrong within sql server I can't figure out. Thank you. |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-01-11 : 07:15:54
|
| Hopefully this will give you idea:http://support.microsoft.com/kb/207187 |
|
|
|
AAbdi
Starting Member
10 Posts |
Posted - 2009-01-12 : 16:28:39
|
| Thanks to all who supported me. My problem was that after applying SQL 2005 SP2, access was denied. I had to change mssql service account to domain account and assign it all the permissions and finally it worked. Again thank you for all your help. |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-01-12 : 23:29:55
|
| Good to know that. Thanks but why SP2? SP3 is already in market. |
|
|
|
|
SQL 2005 Maintenance Plan