Re: Effective Permissions Error with Domain User

Scott
Did you get these database from SQL Server 2000 by using a RESTORE command?

What is the compatibilty level of both databases?


"Scott Eguires" <ScottEguires@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:870F7328-15EF-40E5-B7ED-7F9262C46DD7@xxxxxxxxxxxxxxxx
If I create a new Login at the server level for a domain group :i.e.,

MyDomain\Domain Users

Then I go add a user tied into this new Login to my database i.e.,
Northwind
or pubs to add a user tied to this login.


Why is it then when I go to Database Properties -> Permissions and select
Effective Permissions on this new user I get the following error:


TITLE: Microsoft SQL Server Management Studio

------------------------------

Cannot show requested dialog.

------------------------------
ADDITIONAL INFORMATION:

An exception occurred while executing a Transact-SQL statement or batch.
(Microsoft.SqlServer.ConnectionInfo)

------------------------------

Cannot execute as the server principal because the principal
"EGUIRES\Domain
Users" does not exist, this type of principal cannot be impersonated, or
you
do not have permission. (Microsoft SQL Server, Error: 15406)

For help, click:
http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.1399&EvtSrc=MSSQLServer&EvtID=15406&LinkId=20476

------------------------------

BUTTONS:

OK


The guest account seems fine for this but any manual entries I try that is
linked to my domain gets this error.





I would appreciate any light you can shed on this



Scott Eguires




.