VS.NET 2003 installation of local SQL

  • Hello,

    Visual Studio .NET 2003 is supposed to install personal SQL 2k on the machine during installation.  However, I had the personal version of SQL 7 on there beforehand.  The database that appears with the same name as my computer name still is SQL 7, and it appears after installing VS.NET 2003, that there was no upgrade or reinstall.  Why would that be?  Would it then install it under a different name, or do I have to install it specially on the machine (an option I may have missed during install)?

    Thanks,

    Brian

  • Try uninstalling SQL 7.0 first and then reinsatll .Net 2003.


    Kindest Regards,

  • .Net 2003 does not automatically install MSDE (local SQL). It points you to a link to download it and install. I recommend installing the NetSDK instance and not the VSDotNet instance since the >Net QuickStart tutorials (http://localhost/quickstart) are all coded with (local)\NetSDK. There are some known issues with 7.0 being installed.

    Install this way and you can look at MSDE_Setup.log for "Return value 3". Return value 3 will cause a fail or rollback of installation.

    setup.exe /qb+ INSTANCENAME=NetSDK DISABLENETWORKPROTOCOLS=1 SAPWD=password

    /L*v C:\MSDE_Setup.log

    Finally, go to C:\Program Files\Microsoft Visual Studio .NET 2003\SDK\v1.1\Samples\Setup and run ConfigSamples.exe, it will setup Northwind, Pubs, GrocerToGo and Portal databases under NetSDK. It will also setup the IIS virutal directories that the QuickStart uses (windows, asp.net and databases examples included.

    Here's the 7.0 related bug:

    http://support.microsoft.com/kb/275307/EN-US/

Viewing 3 posts - 1 through 2 (of 2 total)

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