Nimesh Madhavan
Reputation: 6318
Run aspnet_regsql on an SQL Server Express database in APP_DATA
When I run the aspnet_regsql command in wizard mode, there is no way to select an SQL Sever Express database file even after specifying ".\SQLEXPRESS" in the database server name. How can I work around this?
Upvotes: 1
Views: 1801
Answers (1)
Nimesh Madhavan
Reputation: 6318
Found the answer here.
This can not be done from the wizard interface. The command line parameter to do this is:
aspnet_regsql -A all -C "Data Source=.\SQLEXPRESS;Integrated Security=True;User Instance=True" -d "C:\MyProject\APP_DATA\aspnetdb.mdf"
Upvotes: 4
Related Questions
- aspnet_regsql - Creating the Application Services Database for mysql or postgresql database
- SqlMembershipProvider With Aspnet_regsql.exe And Web.Config Configurations
- Unexpected error message from aspnet_regsql
- aspnet_regsql and deployment to Azure
- Adding tables/stored procedures with aspnet_regsql
- Running aspnet_regsql.exe error
- ASP.NET: How can I introduce Aspnet_regsql to Login Controls
- ASP.NET MVC newbie: can't get aspnet_regsql.exe to work
- How to enable membership provider for sql server express database
- Can I call ASP.NET RegSQL from code?