That doesn't sound like the exact error. Try adding the userid you are trying to register with into the "OLAP Administrators" group. Make sure that all the *.dll files under...

Don't forget to take off the Read-Only properties from the file after copying onto the server. Otherwise, you may end up with Read-Only database....

No need for ActiveX script. T-SQL will do..........Following renames the backup file "DB1Oldname.BAK" to "DB1Newname.BAK" .

declare @rename varchar(255)

select @rename =

'ren "\\FTPSERVER\D$\SQLSERVER\BACKUP\MYDATABASE\DB1\DB1Oldname.BAK" '

+ 'DB1Newname'

+ '.BAK'

exec master..xp_cmdshell @rename

GO

How can you say 'SQL 2000 and 2005 expert'. SQL Server 2005 is NOT EVEN OUT YET..........................................