I have setup an ASP.NET 3.5 web app on DiscountAsp.Net. It uses the database side of the ASP.NET Security, Membership, and Roles. There are two functions I am having an issue with - creating and deleting users who can log onto the web app and utilize it. The SQL stored procedures function OK in SQL Server Management Studio. In a query window, I can successfully add and delete users. I wish to note I have a stored procedure UserSave which calls (executes) stored procedure aspnet_Membership_CreateUser which in turn calls (executes) stored procedure aspnet_Users_CreateUser amongst other stored procedures. However, using SQLCommand in ASP.NET (code behind), the two stored procedures fail to complete. They die on the aspnet_Users table; no error is returned. I have traced the failure to the stored procedure aspnet_Users_CreateUser that the stored procedure aspnet_Membership_CreateUser calls; it fails only when UserSave is called from the web app (using SQLCommand), not from SQL Server Management Studio. With the stored procedure UserSave failing only when called by the web app, might that point at the Web.Config file? What suggestions do you have for troubleshooting? Any assistance would be appreciated.
