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 -
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 !!!!