BUG: Creating a Table in Enterprise Manager When Using a Domain Account May Cause Server AV

• Microsoft SQL Server version 7.0

SYMPTOMS

Creating a table in SQL Enterprise Manager (EM), where the server is registered using a domain account, may cause a server-side access violation (AV). For the AV to occur the domain account has to be a member of a user-defined local group and the local group has to be granted login permissions to the SQL Server.

CAUSE

The access violation occurs if the Windows NT domain account is a member of a local user-defined group. If the local group is a built-in Windows NT group (for example, administrators), the access violation does not occur. The problem may also be avoided if the very first table creation is done using T-SQL instead of the Enterprise Manager Graphical interface.

WORKAROUND

Here are a few ways to work around this behavior:

• Grant direct SQL Server access to the Windows NT domain account instead of granting access through a local Windows NT group.
  
  -or-



• Create the tables through T-SQL.
  
  -or-



• Using the original security credentials, where the Windows NT account is a member of a local group, create the first table through T-SQL instead of through SQL Enterprise Manager.
  
  -or-



• Use a SQL Server security login.
  
  -or-



• Add the Windows NT domain account to a local Windows NT built-in group (for example, Administrators).

STATUS

Microsoft has confirmed this to be a problem in SQL Server version 7.0.

Additional query words:

Keywords : SSrvEntMan SSrvSQL_Admin kbbug7.00 kbSQLServ700bug
Version : winnt:7.0
Platform : winnt
Issue type : kbbug