i tried that too

exec testproc dateadd(day, -2, getdate()),dateadd(day, -2, getdate()),'all'

but it gives me error at

that in corect syntax near day

what am i missing!!

hi my one server is on SP1 and other is on RTM does it matter!! Also. does both SQL server needs to be run under local account? also MSDTC on...

Hi Thanks,

But that did not work either.. I have MSDTC running on both services. and also have set no authentication required.

I tried reinstalling again as well.

Thanks

Paresh

I could also see this error in Event Viewer :

Failed to initialize the needed name objects. Error Specifics: d:t\com\complus\dtc\dtc\msdtcprx\src\dtcinit.cpp:457, Pid: 1372

No Callstack,

CmdLine: "C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\sqlservr.exe" -sMSSQLSERVER

What does this...

I have checked everything and it is correct!!

Where do you see that under:

general,Data sources, execution, history, security!!! i could not find any thing to set Autorefresh!!

note: I have SSRS 2005 Standard edition!!

Thanks

Pat

Hi,

do i need to set kerberos to both server or only through SSIS server?

Thanks

Pat

Hi thanks for the reply, how can i enable the SSIS for Delegation? also what do i need to do for Kerberos setup!? what part do i need to tell...

It runs under specifice id which is part of Admin group on the server!!

Hi,

I still get same error message!!

Thanks

user does have report builder role as well as publish role as well!! but still give same problem to user!!