Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 .NET Inside SQL Server (2005)
 Stored Procedure migration and security

Author  Topic 

qman
Constraint Violating Yak Guru

442 Posts

Posted - 2008-04-30 : 10:57:26
I have an ASP page which is supposed to populate a dropdown based on values returned from a stored procedure. This ASP page is working on our old server. I recently moved all the pages, code, ect over to our new server including migrated to SQL Server 2005 (from 2000 I think), as you can tell, somthing broke...

I assume this is security related however, all the relevant security is set correctly as far as I can tell. I am granting "Execute" access for the stored procedure and "Select" access for all the referenced tables. Am I missing something? Is there another security setting which needs to be set?

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-04-30 : 22:03:32
Did you modify connection string in asp? Got any error?
Go to Top of Page
   

- Advertisement -