hi all,
I created a new sql server 2005 database name wsat_demo in the
(lESSQL1)\sql2k5 enterprise server
in the default website properties i added a connection string named WSAT1 to wsat_demo database using aspnet_user account with SA priveledge
i modified the machine.config to use WSAT1 connection string
Then i run the WSAT (website admin tools) to create users.
this error appears. "Could not find stored procedure 'dbo.aspnet_CheckSchemaVersion'. "
i've tried attaching the database created by the asp.net project located at app_data folder named it App_data1 database
do the same configuration as stated above. Viola! the WSAT connects to it.
After comprehensive investigation, App_data1 database shows that it contains many security objects builtin to it by asp.net 2 application.
QUESTION: How can I have WSAT_demo database to have the same object as App_data1 given the fact that my connection is enjoying SA priviledge?
thanks,
joeydj
Pareng joey...musta na buhay natin?
Are you creating a database that will store user profiles? If you are, you might wanna start by creating a blank SQL Server database. Then, run the aspnet_regsql.exe and point to this blank database you just created. This is a wizard that creates all these database objects in SQL Server(whether it's 2000 or 2005). Then you can point your ASP.NET 2.0 web app to this database in your web.config. But before you can do this, make sure you override the settings in th machine.config. For a complete step-by-step guide on this, check out Scott Guthrie's blog as this was my guide when I was working on a similar task using the Beta 2 version of Visual Studio 2005
|||okay lang. sounds like i'm at the
msforums it used to be msdn.ph
running the aspnet_regsql.exe is just like attaching the database
from the app_data on the remote server
|||
Hi,
How can i run or edit my ASP.NET 2.0/C# project in VS2005. I have source code files (including database) but it doesn't have .sln file. Please guide me how can i edit or run this in VS2005
