Adiga (11/1/2010)

---

When I schedule it, it shows that the job will run at x time (let's say 7:45), the job takes about 15 minutes so it should get done at...

BTW - I found this documentation about the job schedule:

[ @freq_subday_interval = ] freq_subday_interval

The number of freq_subday_type periods to occur between each execution of a job. freq_subday_intervalis int, with a...

No.

My first thought was because the stored procedure...

John Rowan (10/22/2010)

---

Your problem is that you've chosen to use the Execute SQL task in combination with an object type variable. Not good. To get the data into...

Alvin Ramard (10/22/2010)

---

gregory.anderson (10/22/2010)

---

I've read quite a few websites and still haven't found a nice walkthrough on how to output my data to a flat file.

Here's were I am:

Created a...

Just to give you an update on this. I met with our DBA and our AD guy this morning and we got this working. Although we did not use the...

Sorry, the section called "Trusted for Delegation" is what jumped out at me...

Matthew Clifford (10/12/2010)

---

I would be willing to put lunch on it that it is a kerberos issue.

That link that I sent you helped me with SSRS and using pass...

Matthew Clifford (10/12/2010)

---

If you want to check your Keberos for a web server I found this utility great for troubleshooting my problems.

http://www.iis.net/community/default.aspx?tabid=34&g=6&i=1887%5B/quote%5D

Unfortunately, I am running IIS 5.0...

Matthew Clifford (10/12/2010)

---

Is this a web application?

Does the SQL Server you are trying to reach on the server or is it on another server?

If it is on another server...

Hey, I'm back. I started a new topic on this next question I have, but forgot that I had this post going already, basically the same problem.

I've now gotten the...

I'd like to bring this topic back up because I don't quite understand the last post.

My background:

Application running on Windows 2003 server

ApplicationPool username is 'dotnetsysadmin'

My application opens a web browser...

Thanks all!

Lowell (10/8/2010)

---

the piece you seem to be missing is the second part of my example...sp_addlinkedsrvlogin , which adding a link between you/yourlogin and what will be used on...

Hi Lowell, I haven't read through all of your response yet, but I got it to work. The problem was starting from domain A. I went to the Sql Server...