Problems with Connecting to the ASPNET database after installing SQL Server Express



    I am having problems connecting to the database.  I am trying to use Membership API and for some reason it will no longer connect to the database.  I previously had Visual Studio 2005 Standard Edition and it worked just fine, until I tried to install MS SQL Express.  I have tried the aspnet_regsql and sqlcmd InstallCommon.sql and both times I received a named pipe error.  I look at the configuration and it said named pipes enabled.


    I eventually gave up after trying for two days and removed MS SQL Express, but now I am still getting the same error.  I tried to uninstall all of the SQL editions and reinstall the MSDE that comes with VS 2005, but I am getting the same error.


    When checking the ASP.NET Web Application and testing the provider I receive the following error:

    Could not establish a connection to the database.
    If you have not yet created the SQL Server database, exit the Web Site Administration tool, use the aspnet_regsql command-line utility to create and configure the database, and then return to this tool to set the provider.


    The security tab gives you the following error:

    There is a problem with your selected data store. This can be caused by an invalid server name or credentials, or by insufficient permission. It can also be caused by the role manager feature not being enabled. Click the button below to be redirected to a page where you can choose a new data store.

    The following message may help in diagnosing the problem: Unable to connect to SQL Server database.


    Running the sqlcmd in the command prompt I receive the following error:

    Sqlcmd: Error: Connection failure. SQL Native Client is not installed correctly.  To correct this, run SQL Server Setup.


    I just Visual Studio to work correctly again.




    Friday, November 02, 2007 9:14 PM