problem connecting to sql ce database

Discussion in 'ASP.NET / ASP.NET Core' started by monkeybonkey, Jun 8, 2011.

  1. getting an error on my website when trying to connect to sql express db on the discountasp servers.

    A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)
     
  2. dmitri

    dmitri DiscountASP.NET Staff

    You are trying to connect to SQL Server instance that does not exist. We do not run SQL Server Express editions, and you cannot use your .mdf database file just by placing it to your web server. You need to have SQL Server database addon active on your account and you will need to use SQL Tools in your DiscountASP.NET control panel to attach your .mdf file to your database. Please see the following Knowledge Base article for the instructions on how to use SQL Tools in your control panel.

    From the name of your database file [aspnet.mdf], I can guess that it stores your ASP.NET Membership/Roles. If this is the case, please follow the steps in this Knowledge Base article to configure them.
     

Share This Page