Reply

Re: Connection string in WEB.CONFIG for SQL Server 2005

Feb 26, 2008 10:10 AM|LINK

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?

Reply

Re: Connection string in WEB.CONFIG for SQL Server 2005

Feb 27, 2008 02:37 AM|LINK

Change in connectionString User Instance = false

Chetan Sarode
Senior Software Engineer,
Approva Systems Pvt Ltd, Pune, India.

Reply

Geek-O

Member

11 Points

29 Posts

Re: Connection string in WEB.CONFIG for SQL Server 2005

Apr 28, 2008 12:24 PM|LINK

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)

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)

Source Error:

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

Source File: d:\hshome\voobiz\corp.voobon.net\Global.asax Line: 13

This is my config file:

<?xml version="1.0"?>
<configuration xmlns="http://schemas.microsoft.com/.NetConfiguration/v2.0">
<connectionStrings>
    <add name="aspnet_staterKits_TimeTracker" connectionString="Data Source=.\SQLExpress;Integrated Security=True;AttachDBFilename=|DataDirectory|TimeTracker.mdf;User Instance=true" />
    <remove name="LocalSqlServer"/>
    <add name="LocalSqlServer" connectionString="Data Source=.\SQLExpress;Integrated Security=True;AttachDBFilename=|DataDirectory|TimeTracker.mdf;User Instance=true" />
</connectionStrings>
<system.web>
    <siteMap defaultProvider="AspNetXmlSiteMapProvider" enabled="true">
      <providers>
        <clear />
        <add name="AspNetXmlSiteMapProvider"
                   type="System.Web.XmlSiteMapProvider, System.Web, Version=2.0.3600.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"
                   siteMapFile="web.sitemap"
                   securityTrimmingEnabled="true" />
      </providers>
    </siteMap>
    <authentication mode="Forms">
      <forms loginUrl="~/TimeTracker/login.aspx"/>
    </authentication>
    <compilation debug="true" />
    <customErrors mode="Off"/>
    <machineKey decryptionKey="AutoGenerate,IsolateApps"/>
    <roleManager enabled="true" />
</system.web>
</configuration>

http://accessbit.com

Reply

chetan.sarod...

All-Star

65749 Points

11148 Posts

Re: Connection string in WEB.CONFIG for SQL Server 2005

Jun 19, 2008 03:27 AM|LINK

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>

Chetan Sarode
Senior Software Engineer,
Approva Systems Pvt Ltd, Pune, India.