HI,
specs: MSVS 2005, SLQ server 2005, asp.net 2.0, Ajax enabled site.
This is my setup before I add membership forms authentication aspnetdb.
My connection string to a SQL server 2005 database has User ID = MyUser;Pass =whatever, so I am not using windows authentication.
All actions between database and client asp.net project is via stored procedure. All Stored procedures are place as approved EXECUTE within a Database role called MYDataBaseProcs. The user name "MyUser" is assigned to this role. This works fine.
OK I am going to install aspnetdb within my existing database : like this
So I end up having all the tables and procs for aspnetdb within my project database.
Therefore I need to allocate all the running of aspnetdb stored procs to 'MyUser' ( ie user name in the connection strin ...
Go to the complete details ...