HI Sue,

Thanks for your reply. I'm able to connect the server with the credentials from SSMS and don't see any issue.

And also there are lot of SQL...

Please advise how I can resolve this issue. Even tried to transfer the backup file (after zipped) through http://ftp..but still facing the same issue.

Thanks and Regards,

Ravi.

Thanks Gail Shaw.

The same backup is valid (Restore verifyonly..) when I checked in the SQLServer2008 R2X64 bit.

There are no thirdparty tool we use SQLjobs for backups.

Thanks and Regards,

Ravi.

Thanks for your prompt reply.

Both jobs are running in the same db server.

JOB 1 - > DB Backups are locating in L:\ --> it's connected from different storage server [...

Hi All,

Please ignore this post..as it's resoved.

http://sqlrx.wordpress.com/2011/07/13/remove-maintenance-plans-left-after-a-server-rename/

Thanks and Regards,

Ravi.

Thanks for your prompt reply.

Currently our DB Server applied with SQL Server 2005 Service Pack 4(9.00.5000.00).

I can see the below errors also in SQLServer Agent log.

"[298] SQLServer Error: 258, Unable...

Can someone please advise me on this issue ?

Thanks and Regards,

Ravi.

Thanks Anthony for your prompt reply.

Can't we apply the directly standard edition license key without uninstall the enterprise evaluation edition in SQLServer 2008 R2?

Earlier we have the SQLServer 2008 R2...

Thanks for your reply.

telnet xxxxx.outlook.com 587

220 xxxxx.outlook.com Microsoft ESMTP MAIL Service ready at Wed, 25 A

10:10:04 +0000

helo

250 xxxxx.outlook.com Hello [xx.xx.xx.xxx]

mail from:ravi.chandra@xxxxx.com

530 5.7.1 Client was not authenticated

Connection to host lost.

It's...

Thanks for your reply.

I have tried all the below settings,but still it's not working..throwing the below error

The mail could not be sent to the recipients because of the mail server...

Hi All,

Is there any compatibility issue like SSRS2005 reports can only be edited with BIDS2005, SSRS2008 – only with BIDS2008 ?

Please advise.

Thanks and Regards,

Ravi.

If I grant the alter, it will apply to all the objects but I need only for views.

GRANT ALTER TO db_viewcreator;

GO

Please advice me if I'm wrong.

Thanks and Regards,

Ravi.

Thanks for your reply.

I have tried this but still not able to create view/alter view...throwing the below errors

Cannot alter the view 'v_xxxxx', because it does not exist or you do...

Thanks Henrico for your help.

How to take the backup of SQLServer2005 SSRS before upgrading to SQLServer 2008 R2?

What are all the things needs to be take backup apart from...

Thanks Henrico for your information.

Please advise me on the below.

Can we apply one licence key for more than one SQLServer2008 R2 developer installation?

or

Can we apply one licence key for only...