Feel like an idiot at the moment!

Yes, that was the problem. IT Support installed SSMS and must have got it wrong!

Fixed. Thanks

Merry XMas 😀

Thanks for the feedback sturner. That just may be the problem. As soon as i have some time, im gonna check that out.

SuperJB 😎

First off, thank you all for the replies.

My security options are IDENTICAL in machine A and B and IDENTICAL in Instance A and B. I have the same exact Logins...

Thanks... i was thinking of that but wanted to know if there was some other way...

Gianluca Sartori,

Thanks, your solution helped me finally figure out how to solve the problem! I didn't use the method exactly as you explained, but i based my solution on yours...

Thanks...

Hall of Fame, my example would be something like this:

SELECT

col1,

col2,

col3,

...

...

COUNT(CASE WHEN PersonsAge...

Gonna try out our code... check back soon

Thanks

OK guys... i've been reading up on this whole PERMISSION issue. I appreciate all the feedback that I've received on the matter... I'll try my best 😀

SuperJB 😎

Well, i guess my connection string would not require user or pass so that any given user could access the data. Of course, somewhere along the way between the actual...

Hiring a DBA is out of the question at my company! I'm the next best thing :p

I understood what you said and that's the approach i was thinking of, create...

Hello once again...

Thanks again for your reply... I understand what your trying to say. The problem is, my system is gonna be "audited", therefore i'm gonna have SQL recording every...

First off, thanks for the reply.

I gotta be honest though, i have no idea how that all works out! I'm good at anything that has to do with t-sql but...

OK, i figured out the problem... but not the solution (yet) :p

This project is integrated in a Clustered Service. The SQL SMSS Instance and the SQL Server Agent are runnig...

SQL 2005

Windows Server 2003

Tried restarting SQL Agent, still have the same problem 🙁

It simply doesn't execute at the scheduled time.

SQL Agent is running.

The JOB is Enabled.

If I manually execute the JOB (right click on JOB -> "Start JOB at Step..."), it works....