George and Edogg, I really appreciate you guys for your help.. Thanks a lot

I believe you would have given file extension as '.csv' while configuring maintenance plan. Just remove that '.' and it should be fine.

Thanks

Thanks guys for your responses. Here are the specs of the server. Its dedicated to just one instance of SQL server.

OS NameMicrosoft(R) Windows(R) Server 2003 Enterprise x64 Edition,

Version5.2.3790 Service Pack...

I am still clueless on this. I would really appreciate any help..

NJ-DBA (4/22/2010)

---

I think Error: 0x2739, state: 1 is the key to finding the cause of this problem. Is there any additional information in the system or application event logs...

@NJ-DBA: I was able to login with same account on which sql services are running. Recycling my sql server could only resolve the issue.

@ps: SQL...

You can create a maintenance cleanup task and schedule it as per your requirement.

Thanks

Please share your ideas what can be the reason for this.

I am not sure about that but it doesn't sounds like that because my other instances are also running on the same user and i didn't faced any issue there....

FYI..

My instance is SQL 2005 (ver 9.00.3042.00),SP2 and Standard Edition. Its running on Microsoft Windows Server 2003, Enterprise Edition; Version5.2.3790 Service Pack 2 Build 3790.

On which server should we edit registry... ?

kgerde (8/28/2009)

---

I have called Microsoft on this issue and found that the following does work

open regedit

navigate to: HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\lanmanworkstation\parameters

Create a New DWORD value...