Wednesday, March 21, 2012

Permissions Problem

I downloaded the SQL Server 2005 Trial and im using the SQL Server Manager. I have a question regarding network users. I can't add anyone on my network to the permissions list. Im adding the name right and yes, before you ask, I AM part of the network. I type in the network name, like "****-**\User" and nothing...I've even tried using the "Check names" and that doesn't work. Can anyone solve this please ?

In general SQL Server just uses the operating system to resolve the names.

So try this, go to some folder on your machine and right-click "Sharing and Security..." and select Share this folder and Add Users... to see if you can add users to a file share. If this does not work then most likely you machine is not trusted by the domain. Try removing the computer from the domain and adding it back to regain trust.

Note if your machine is NOT part of a domain, then you can only add local NT users, you can't add users from another machine.

No comments:

Post a Comment