BackupDirectory is not available

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » SQL Server 2005 General Discussion » BackupDirectory is not available

BackupDirectory is not available

Rate Topic

Display Mode

Topic Options

Author

Message

eica

Posted Wednesday, February 01, 2006 12:09 AM

SSC Rookie

Group: General Forum Members
Last Login: Wednesday, May 04, 2011 3:54 AM
Points: 25, Visits: 44

Hi, has anyone meet with this problem ?
Yeasterday I have installed a new SQL Server 2005 side by side with SQL Server 2000.
The installation worked fine, but as I wish to make a backup of a database running on old 2000 Server through new SQL Server Management Studio this error message appeared:

Property BackupDirectory is not available for Settings 'Microsoft.SqlServer.Management.Smo.Settings'. This property may not exist for this object, or may not be retrievable due to insufficient access rights. (Microsoft.SqlServer.Smo)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.PropertyCannotBeRetrievedExceptionText&EvtID=BackupDirectory&LinkId=20476

To be sure, on that link was no help to solve problem !!!!
I have just connected into the old SQL Server 2000 using domain login and with the sa login too, the situation was the same !

Then I tryed to use the old Enterprise Manager, but I was not able to open them, because :

Snapin failed to initialize.
Name: - not available -
CLSID: {00100100-1816-11D0-8EF5-00AA0062C58F}

And my last question is:
Is there any option to set other installation folder at the sql server 2005 setup ? As I tryed change in advanced options to store the instalation files on other fixed disk, after install process has finished all files was placed in C:\Program Files\Microsoft SQL Server\ with DATA folder too !!!
Stupid Microsoft !!!!

Post #254856

eica

Posted Wednesday, February 01, 2006 1:49 AM

SSC Rookie

Group: General Forum Members
Last Login: Wednesday, May 04, 2011 3:54 AM
Points: 25, Visits: 44

I did it !
It is very simple
SQL 2005 installation has removed key from
HKEY_CLASSES_ROOT\CLSID\00100100-1816-11D0-8EF5-00AA0062C58F
I placed them back, and it works ! (Enterprise Manager)

Windows Registry Editor Version 5.00

[HKEY_CLASSES_ROOT\CLSID\{00100100-1816-11d0-8EF5-00AA0062C58F}]
@="Microsoft SQL Enterprise Manager SnapIn"

[HKEY_CLASSES_ROOT\CLSID\{00100100-1816-11d0-8EF5-00AA0062C58F}\InProcServer32]
@="C:\\Program Files\\Microsoft SQL Server\\80\\Tools\\Binn\\sqlmmc.dll"
"ThreadingModel"="Both"

[HKEY_CLASSES_ROOT\CLSID\{00100100-1816-11d0-8EF5-00AA0062C58F}\ProgID]
@="SQLMMC.1"

[HKEY_CLASSES_ROOT\CLSID\{00100100-1816-11d0-8EF5-00AA0062C58F}\VersionIndependentProgID]
@="SQLMMC"

Post #254868

« Prev Topic | Next Topic »

Permissions