Microsoft KB Archive/141667

{|
 * width="100%"|

BUG: Using SEM to Change Security Options Changes Space Syntax

 * }

Q141667

-

The information in this article applies to:


 * Microsoft SQL Server version 6.0

-

BUG# NT: 12762 (6.00)

SYMPTOMS
If you use SQL Enterprise Manager (SEM) to change security options, the key that is used to map the Windows NT space is actually not used when you stop and restart SQL Server.

WORAKAROUND
Use the SQL Setup program to change security options.

STATUS
Microsoft has confirmed this to be a problem in SQL Server version 6.0. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.

MORE INFORMATION
After installation, by default MAP$ indicates that the space character is mapped to the valid SQL Server dollar sign ($) character. If you do not change anything from SEM Security Options, all is well. If you now go into SEM and change the security options, or even if you do not change anything but click "OK" instead of "CANCEL" and then stop and restart SQL Server, MAP$ will not be used.

Similarly, if MAP# or MAP_ is changed to indicate space mapping, it will not be used after SQL Server is stopped and restarted. This can be verified by looking at the registry entries for MAP$, MAP_ and MAP# under HKEY_LOCAL_MACHINE/Software/Microsoft/MSSQLSERVER/MSSQLSERVER.

Additional query words: SQL6 winnt

Keywords : kbinterop kbsetup

Issue type : kbbug

Technology : kbSQLServSearch kbAudDeveloper kbSQLServ600