SQL Management Studio - Roaming Profile

# SQL Management Studio - Roaming Profile

• Monday, February 27, 2012 10:54 AM

Hello

I tell all to, the problem: I have the SQL installed Management Studio in a machine to which the users accede to execute the application. The users have redireccionada the folder " My Documents " to a route that is for example \\ servidor\recurso\$\nombreusuario. The problem is that the first time that the SQL starts Management Studio this believes a few folders of configuration in the folder " My Documents " of the user, on having tried to guard any thing (project, script sql, etc) gives me denied access.

Verifying with the FileMon.exe I see that the problem is in that it is trying to write "something" in the route \\ servidor\recurso\$ on that logically, the user does not have permissions. It has the permissions in \\ servidor\recurso\$\nombreusuario. If one takes the redirection of folders this one works correctly, since he guards eses information in " documents and settings ".

Certainly, there is some key of registry that indicates that the application executed for the first time? I say it because the structure of folders inside " My Documents " does not manage to me to create.

Thanks

### All Replies

• Wednesday, February 29, 2012 2:56 AM
Moderator

Hi AlexandreJusto,

>> the user does not have permissions. It has the permissions in \\ servidor\recurso\$\nombreusuario. If one takes the redirection of folders this one works correctly

Regarding to the error message and your description, which seems the current user has no permissions on that folder since you change the location, which it worked. So please verify some issue as below:
• Check whether the location is correct.
• Check whether the location exists. If it does not exist, create it first.
• Check whether you have the necessary permissions to create in the target location. At least you need Read and Write permissions.

If all above is correct, please check User Account Control , which works by prompting you for permission when a task requires admin right. You can try to turn if off and then try again.
For more information, please refer to Turn User Account Control on or off

Meanwhile could you give more detail such as what exactly want to do?

Regards, Amber zhang

• Wednesday, February 29, 2012 8:57 AM

I tell you the situation.

I have installed in SQL Managagement Studio in a few virtual offices. The users who accede, have redirection the folder " my documents " to the route \\ folder\folder\$\user.domain. The users have writer's permissions and reading on this route but they do not have any permission in \\ folder\folder\$\.

The location is correct an exists and the user account control is disabled.

Thanks

• Wednesday, February 29, 2012 9:45 AM
Moderator

Hi AlexandreJusto,

Thank you for your update. As you mentioned you have writer permission on route of \\ folder\folder\$\user.domain, that does not mean you can have the same permission on \\ folder\folder\$ route.  Please try to give that user full control permission on \\ folder\folder\$ level.
For How to set, view, change, or remove special permissions for files and folders please refer to this KB:http://support.microsoft.com/kb/308419

Meanwhile what is the purpose of SQL Server Management Studio?
If you have any problem related to folder permission, please link to windows platform forum.

Regards, Amber zhang