We have a server which contains a local NT group called
SERVER\SQLAccess. In SQL Server this local group has been
given full access and sysadmin rights to all databases. I
have a domain user (lets call his domain username
DOMAIN\jimmy), who has been added to the above local NT
group. This should mean that this user now has full
permissions to all databases, right?
When the user (through Enterprise Manager, using NT
authentication) tries to create a new table on one of the
dbs, he gets the following error:
Unable to create table.
ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]
Specified owner name 'DOMAIN\jimmy' either does not exist
or you do not have permission to use it.
WHY IS THIS???
**BOL is slightly ambiguous. I have found mention of local
groups created in SQL needing to be called BUILTIN rather
than the server name, also the guest account needing to be
enabled if named pipes is being used, or the fact that the
table will be created under the NT account name and not
the group name - are any of these the reason for this