StrataFrame Forum

Unusual Stored Procedure Behavior...

http://forum.strataframe.net/Topic10008.aspx

By StarkMike - 7/5/2007

When I logged into SQL Server 2005 using windows authentication to execute a stored procedure it worked fine.



HOWEVER when I logged into SQL Server 2005 using SQL Server Authentication (the sa account) and executed the SAME stored procedure I got no results.



I have no idea why that would make ANY difference. Any advice?



Thanks
By StarkMike - 7/5/2007

Here is another clue... when i was trying to log in using Windows Authentication I was using my username (mmurphy) ... so i tried another user through windows authentication and I got this error:

Login failed for user 'Domain\WShuey'

Could that be part of the same problem?

By Trent L. Taylor - 7/6/2007

It sounds like you are fighting strictly a permissions issue.  When you start having behavior like you are describing, in my experience, it is security permissions 99.99% of the time.  Of course, this could be that .01% of the time....but probably not BigGrin
By StarkMike - 7/6/2007

This was that .01% of the time... it was a problem hidden in T-SQL.



Question: How do I get the last two days of my life back? LOL! w00t
By Trent L. Taylor - 7/6/2007

Question: How do I get the last two days of my life back? LOL!

Well I don't know how to get your last two days back...but I know for a fact you will know where to look next time BigGrin

By Ivan George Borges - 7/6/2007

How do I get the last two days of my life back? LOL! w00t

I think Superman has done this before, hasn't he?

By Trent L. Taylor - 7/6/2007

LOL...yeah...when he made the earth go backwards or something BigGrin