/Jonas

Hi,

I have a similar issue and was wondering if you resolved what needed changing in the config file when moving it Sql Server 2005, I get the following error when attempting to login. This instance is setup to allow remote connections and is happily running other applications so I think this generic error is not really telling the story. I suspect the issue is with the default Express version of the Web.config and I am not experienced enough at the  moment to determine what, so my getting started experience has come to an abrupt stop.

Server Error in '/' Application.

---

An error has occurred while establishing a connection to the server.  When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: An error has occurred while establishing a connection to the server.  When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)

Thanks

Kim

Open "SQL Server Surface Area Configuration"

then opne the "Surface Area Configuartion for Services and Connections "

Under the Remote connection u have to enable the "Using both TCP/IP and Named  Pipes "

then It will work..

I have a similar problem. I have everything working locally and have copied a published version to a hosting server from GoDaddy. I get an error similar to the one above

... (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)

I was looking on line and tried some suggestions but none worked. Here's what I have under my web.config file:

    <connectionStrings>
        <add name="vsItemsConnectionString" connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\vsItems.mdf;Integrated Security=True;User Instance=True"
         providerName="System.Data.SqlClient" />
    </connectionStrings>

Then I have added the following lines under <system.web> which I copied from the website as the suggestion:

       <membership>

      <providers>
         <remove name="AspNetSqlMembershipProvider" />
         <add name="AspNetSqlMembershipProvider"
           type="System.Web.Security.SqlMembershipProvider,
           System.Web, Version=2.0.0.0, Culture=neutral,                                
           PublicKeyToken=b03f5f7f11d50a3a"
           connectionStringName="vsItemsConnectionString"
           enablePasswordRetrieval="false"
           enablePasswordReset="true"
           requiresQuestionAndAnswer="true"
           applicationName="/"
           requiresUniqueEmail="false"
           passwordFormat="Hashed"
           maxInvalidPasswordAttempts="5"
           minRequiredPasswordLength="7"
           minRequiredNonalphanumericCharacters="1"
           passwordAttemptWindow="10"
           passwordStrengthRegularExpression="" />
       </providers>

   </membership>

   <profile>
       <providers>
          <remove name="AspNetSqlProfileProvider" />
          <add name="AspNetSqlProfileProvider"
             connectionStringName="vsItemsConnectionString"                           
             applicationName="/"
             type="System.Web.Profile.SqlProfileProvider,
             System.Web, Version=2.0.0.0, Culture=neutral,                   
             PublicKeyToken=b03f5f7f11d50a3a" />
        </providers>   
   </profile>

   <roleManager>
        <providers>
          <remove name="AspNetSqlRoleProvider" />
          <add name="AspNetSqlRoleProvider"
             connectionStringName="vsItemsConnectionString"
             applicationName="/"
             type="System.Web.Security.SqlRoleProvider,
             System.Web, Version=2.0.0.0, Culture=neutral,                               
             PublicKeyToken=b03f5f7f11d50a3a" />
        </providers>
   </roleManager>

I still get the same error. By the way I am using SQL Express which is built-in to .NET

Any idea how to go about fixing this? Any help would be appreciated.

Thank you.
 

Try to set Data Source= "serverName" in you connectionString

Data Source=.\SQLEXPRESS will work only on local m/c, It will not work if you host your site

Tryst:

How do I change these to work with SQL Server 2005?

Hi,

When using this starter kit with Sql Server 2005, this worked for me.

Set Try to set Data Source = "Server name" in connection string

Open "SQL Server Surface Area Configuration"

then opne the "Surface Area Configuartion for Services and Connections "

Under the Remote connection u have to enable the "Using both TCP/IP and Named  Pipes "

then It will work..

Try to set Data Source= "serverName" in you connectionString

Data Source=.\SQLEXPRESS will work only on local m/c, It will not work if you host your site

Check in web.config for connectionString, configure it according to your server name, password etc.

In Time Tracking System, it uses inbuild Membership classes for user creation, updation etc..

You have to register your DB with ASP.NET Membership classes by executing the command line utility in VS prompt

aspnet_regsql, it will open one window, where you  have to configure DB.

Hope it will help you, let me know.

Have you tried my solution

What is the status of your post

Have you solved your problem

i am the same connection errors but i do not have SQLEXPRESS in my config file. I connect to two sql servers without issues from my local machine (running developer edition).

I DO notice that the asp.net properties on IIS6 holds data source=./SQLEXPRESS;Integrated Security=SSPI;AttachDBFilename=|DataDirectory|aspnetdb.mdf;User Instance=true

 Could this be the issue and why is it there?
 

Change in connectionString User Instance = false

<connectionStrings>
  <add name="aspnet_staterKits_TimeTracker" connectionString="Data Source=RELSEC_FE\SQLServer2005;Integrated Security=True;AttachDBFilename=|DataDirectory|TimeTracker.mdf;User Instance=false"/>
  <remove name="LocalSqlServer"/>
  <add name="LocalSqlServer" connectionString="Data Source=RELSEC_FE\SQLServer2005;Integrated Security=True;AttachDBFilename=|DataDirectory|TimeTracker.mdf;User Instance=false"/>
 </connectionStrings>

 This is the error i am getting. This is the first time i have published an app to the web using ASP.net. I used the copy website feaure in VS2008, this is all i have done so far and i receive this error.

Server Error in '/' Application.

---

An error has occurred while establishing a connection to the server.  When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)

Line 11:         if (Roles.Enabled)
Line 12:         {
Line 13:             if (!Roles.RoleExists("ProjectAdministrator"))
Line 14:             {
Line 15:                 Roles.CreateRole("ProjectAdministrator");

This is my config file:

You have to register your DB with ASP.NET Membership classes by executing the command line utility in VS prompt

aspnet_regsql, it will open one window, where you  have to configure DB.

Add the following lines under <system.web>

       <membership>

      <providers>
         <remove name="AspNetSqlMembershipProvider" />
         <add name="AspNetSqlMembershipProvider"
           type="System.Web.Security.SqlMembershipProvider,
           System.Web, Version=2.0.0.0, Culture=neutral,                                
           PublicKeyToken=b03f5f7f11d50a3a"
           connectionStringName="vsItemsConnectionString"
           enablePasswordRetrieval="false"
           enablePasswordReset="true"
           requiresQuestionAndAnswer="true"
           applicationName="/"
           requiresUniqueEmail="false"
           passwordFormat="Hashed"
           maxInvalidPasswordAttempts="5"
           minRequiredPasswordLength="7"
           minRequiredNonalphanumericCharacters="1"
           passwordAttemptWindow="10"
           passwordStrengthRegularExpression="" />
       </providers>

   </membership>

   <profile>
       <providers>
          <remove name="AspNetSqlProfileProvider" />
          <add name="AspNetSqlProfileProvider"
             connectionStringName="vsItemsConnectionString"                           
             applicationName="/"
             type="System.Web.Profile.SqlProfileProvider,
             System.Web, Version=2.0.0.0, Culture=neutral,                   
             PublicKeyToken=b03f5f7f11d50a3a" />
        </providers>   
   </profile>

   <roleManager>
        <providers>
          <remove name="AspNetSqlRoleProvider" />
          <add name="AspNetSqlRoleProvider"
             connectionStringName="vsItemsConnectionString"
             applicationName="/"
             type="System.Web.Security.SqlRoleProvider,
             System.Web, Version=2.0.0.0, Culture=neutral,                               
             PublicKeyToken=b03f5f7f11d50a3a" />
        </providers>
   </roleManager>

 Hi All thanks for your Answers.

sorry for not replying

but my problem is solved without changing the code.

i have to change my hosting sevices.

my earlier host has not yet refunded my money and neither released my domain name till now.

but with new hosting servie i had registered a new domain name.

thanks all for your help/contribution.