Microsoft KB Archive/244124

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

Article ID: 244124

Article Last Modified on 10/29/2003

-

APPLIES TO


 * Microsoft SQL Server 7.0 Standard Edition
 * Microsoft SQL Server 2000 Standard Edition

-



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

Keywords: kbbug kbpending KB244124

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.