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


The information in this article applies to:

  • Microsoft SQL Server 7.0
  • Microsoft SQL Server 2000 (all editions)
This article was previously published under Q244124
BUG #: 56563 (SQLBUG_70)

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 granting access through a local Windows NT group.

    -or-
  • Create the views 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 that this is a problem in the Microsoft products that are listed at the beginning of this article.

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:

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

Modification Type:MajorLast Reviewed:10/29/2003
Keywords:kbBug kbpending KB244124
©2003 Microsoft Corporation. All rights reserved.