Hi all just a quick question, whats the best way to create an installation section of a site so when user go to admin section for the first time it will ask for sql server location, password and username, once provided it will trigger a .sql file which will create db on sql server.

 Your help would be very much appreciated

Thanks Conrad

Hi,

You can create Web Setup project and custom action to create new Database while installing. To do so, you need to create a text file that contains a SQL statement to create a database and need to know the connection string used to connect server and the user should have proper permission on server, and then you can execute SQL statement to create database in custom action.

For more information, see http://msdn.microsoft.com/en-us/library/49b92ztk.aspx and http://weblogs.asp.net/scottgu/archive/2007/06/15/tip-trick-creating-packaged-asp-net-setup-programs-with-vs-2005.aspx

 
I hope this helps.

Thank you very much... it sure helps