StrataFrame Forum
Back
Login
Login
Home
»
.NET Forums
»
General .NET Discussion
»
Unusual Stored Procedure Behavior...
Unusual Stored Procedure Behavior...
Post Reply
Like
0
Unusual Stored Procedure Behavior...
View
Flat Ascending
Flat Descending
Threaded
Options
Subscribe to topic
Print This Topic
RSS Feed
Goto Topics Forum
Author
Message
StarkMike
StarkMike
posted 18 Years Ago
ANSWER
Topic Details
Share Topic
Group: Forum Members
Posts: 436,
Visits: 944
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
Reply
Like
0
Replies
StarkMike
StarkMike
posted 18 Years Ago
ANSWER
Post Details
Share Post
Group: Forum Members
Posts: 436,
Visits: 944
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?
Reply
Like
0
Trent Taylor
Trent Taylor
posted 18 Years Ago
ANSWER
Post Details
Share Post
Group: StrataFrame Developers
Posts: 6.6K,
Visits: 7K
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
Reply
Like
0
GO
Merge Selected
Merge into selected topic...
Merge into merge target...
Merge into a specific topic ID...
Open Merge
Threaded View
Threaded View
Unusual Stored Procedure Behavior...
StarkMike
-
18 Years Ago
Here is another clue... when i was trying to log in using Windows...
StarkMike
-
18 Years Ago
It sounds like you are fighting strictly a permissions issue. When you...
Trent L. Taylor
-
18 Years Ago
This was that .01% of the time... it was a problem hidden in T-SQL....
StarkMike
-
18 Years Ago
[quote]Question: How do I get the last two days of my life back? LOL!...
Trent L. Taylor
-
18 Years Ago
[quote]How do I get the last two days of my life back? LOL!...
Ivan George Borges
-
18 Years Ago
LOL...yeah...when he made the earth go backwards or something :D
Trent L. Taylor
-
18 Years Ago
Post Reply
Like
0
Similar Topics
Post Quoted Reply
Reading This Topic
Login
Login
Remember Me
Reset Password
Resend Validation Email
Login
Explore
Messages
Mentions
Search