>> Is it necessary to generate separate .sql file for ASPNETDB.MDF also?
Yes, you need to script them using the Publishing Wizard as well, as explained in the book.
>> From where I got user id and password.
This is something your host should give you.
Once you have the databases in place, you need to update the LocalSqlServer connection string or reconfigure the membership provider as explained in Appendix B.
Last edited by Imar; October 23rd, 2011 at 10:19 PM..