PRB: Install Path w/ Spaces Causes SQLOLE Errors When Using Client Tools

ID: Q217118

The information in this article applies to:

Microsoft SQL Server versions 6.0, 6.5

SYMPTOMS

After installing SQL Server Client Tools into a path or folder that contains a space, for instance "Program Files", the installation will complete without error. However, the icons for the program group resolve to the 'Unknown' Windows type and will not reflect the correct application icon. Attempts to change the icon, through the shortcut properties or using client tools that access Registry information, result in the following error message:

The SQLOLE OLE object could not be registered. Class not registered (80040154)

NOTE: If the SQL Server is also being installed on a computer, the Setup program receives the following error messages from the Registry Editor and Setup then fails.

Cannot import D:\Program: Error opening the file. There may be a disk or file system error.
Cannot import Files\MSSQL\BINN\MSDTC.REG: Error opening the file. there may be a disk or file system error.

WORKAROUND

When specifying a path, do not use a path name with spaces. Then re-run SQL Server setup and either perform a full Setup or upgrade to ensure that all the Registry entries are properly made.

MORE INFORMATION

Additional query words:

Keywords : SSrvInst kbSQLServ600 kbSQLServ650
Version : winnt:6.0,6.5
Platform : winnt
Issue type : kbprb