BUG: Creating a View in Enterprise Manager Using a Domain Account May Fail

• Microsoft SQL Server version 7.0

SYMPTOMS

Creating a View in SQL Enterprise Manager (SEM) may fail when the server is registered using a domain account and Windows NT authentication. This may occur if the domain account is a member of a user-defined local group and the local group has been granted login permissions to the SQL Server.

The following error appears:

ODBC error [Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near '\'.

CAUSE

This error only occurs if the Windows NT domain account is a member of a local user-defined group; it is a specific permissions issue. If the Windows NT account is granted direct access to SQL Server, the view creation takes place. In addition, if the local group is a built-in Windows NT group (for example, administrators), the view can be created. The problem may also be avoided if the view creation is done using T-SQL instead of the Enterprise Manager.

WORKAROUND

Here are four ways to work around this problem:

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



• Create the tables through T-SQL.
  
  -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.

MORE INFORMATION

This is related to an issue where the creation of a table with the same security credentials may fail. For additional information on why table creation may fail, click the article number below to view the article in the Microsoft Knowledge Base:

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

Additional query words:

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