I am developing a application to manage sql databases, and i have a problem creating the database on my partition (C:) in any folder, but if i create it in partition (D:) for example it works. I am looking for a solution to this, maybe are the permissions for the sql user but i don't know how to change or add them. I am using开发者_运维技巧 the 'sa' user...
I am using Microsoft SQL
where in the process does it error? when it goes to save the .mdf file? or when you try to run a query? It could be a Windows permission issue, do you have write access to where you are trying to put the file? Right click the folder and choose properties, then go to the security tab, if your user-name is in the list click it and make sure you have write access.
精彩评论