Config ASP 2.0 NET to run SQL 2005

  • http://weblogs.asp.net/scottgu/archive/2005/08/25/423703.aspx

    Can someone explain how to  go about doing the first step such as creating a blank instance

    Thanks

    Newbie

  • I believe that means you should create a new database on the SQL Server in question.  There are various ways of doing this (right-click on the database folder in Management Studio and select New Database or using T-SQL) but I'd suggest you look at Books Online if you need to.

  • Management Studio? i have SQL2005 Express ....which program is that

  • I see,

    I haven't use SQL2005 Express but doesn't that come with something called SQL Express Manager?  It's a cut-down version of Management Studio from where you can create a database as I explained above.  right-click on the Database folder and select "New Database".

    Or open a query window and use the T-SQL "CREATE DATABASE" command.

  • If you just want to use the default providers in SQL Express you can just run the web app.  The Provider will take care of creating the database on the first call.

    You only need to create the Database if you don't want to use the File based data source.

    (Management Studio doesn't come with the base install of SQL Express.  You can download it separately or as part of the SQL Server Express with Advanced Services bundle from the MS site: http://msdn.microsoft.com/vstudio/express/sql/download/.


    wayne

  • Ok guys thanks i'll give it a shot

  • The aspnet, northwind,  pub, is missing from the  default box

    What is the problem why everything other things shows up

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply