cook155 (4/11/2014)
Yes, it was in fact the first solution i tried because the same thing was recommended to my by someone else. I tried all impersonation methods and was wondering if i had to go into the manager part of SQL server to fix all of this?
Can you show a screen shot of when you are exactly getting the issue, I mean when you do what you are seeing this.
Good Luck 🙂 .. Visit www.sqlsaga.com for more t-sql code snippets and BI related how to articles.