Post reply

SQL Permissions

  • August 3, 2009 at 12:28 pm

    #209038

    Hi Sir,

    How could i assign SQL permissions to a folder because i was able to create database to C drive but when i create a database to My Documents i am getting Operating system 2 error i have everyone full control to the folder. Its SQL 2005 Express edition i using a database application call ACT to create the database. With its tool the SQL Permission check has failed so is there a way where we can assign permissions to that folder ???

    Thanks in advance 🙂

    Shyam

  • August 3, 2009 at 12:44 pm

    #1033836

    The service account needs permissions to create the database, not your log in account.

  • August 3, 2009 at 3:38 pm

    #1033954

    Thanks for your response I restarted the services as build in admin under the Login in service properties also we are logged in as build in admin also we were able to create the database under C drive

  • August 4, 2009 at 8:22 am

    #1034273

    Can you post the EXACT error message you are getting? There should be one in the event log and/or the SQL Server error log.

    Jack Corbett
    Consultant - Straight Path Solutions
    Check out these links on how to get faster and more accurate answers:
    Forum Etiquette: How to post data/code on a forum to get the best help
    Need an Answer? Actually, No ... You Need a Question

  • August 4, 2009 at 8:40 am

    #1034303

    You shouldn't need admin. Local Service, Network Service, or a domain user account with minimal rights is recommended.

    are you changing the service account with the SQL Configuration Manager or just in Services? The Configuration Manager assigns rights that will work. If you have a non-standard folder, just add those permissions.

  • August 4, 2009 at 12:16 pm

    #1034468

    "Operating system 2 error access denied to the path"

  • August 4, 2009 at 12:21 pm

    #1034472

    What OS (XP, Vista, Server 2003, Server 2008)?

    Jack Corbett
    Consultant - Straight Path Solutions
    Check out these links on how to get faster and more accurate answers:
    Forum Etiquette: How to post data/code on a forum to get the best help
    Need an Answer? Actually, No ... You Need a Question

  • August 4, 2009 at 12:25 pm

    #1034474

    I really appreciate your help in fixing my issue

    "are you changing the service account with the SQL Configuration Manager or just in Services? The Configuration Manager assigns rights that will work."

    I was changing just services ... I'm not very good in SQL can you tell me in Configuration manager how to assign right is it like going to instance properties > Log on then change it there ??

    "If you have a non-standard folder, just add those permissions."

    How to do that the another major problem is that software provider won't give the sa password so the instance so is there some like of Object what we add in that folder properties like "everyone" as such ?? Or we have to add the folder permission from the SQL Server Configuration Manager

  • August 4, 2009 at 12:26 pm

    #1034475

    Windows XP Pro SP 3

Viewing 9 posts - 1 through 9 (of 9 total)

You must be logged in to reply to this topic. Login to reply