Click here to Skip to main content
15,890,123 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
i have web config below..


XML
<?xml version="1.0"?>
<!--
  For more information on how to configure your ASP.NET application, please visit
  http://go.microsoft.com/fwlink/?LinkId=169433
  -->
<configuration>
    <connectionStrings>
    <remove name="connectionstr" />
    <add name="connectionstr" connectionString="Data Source=servername;Initial Catalog=dbname;Persist Security Info=True;User ID=userid;Password=Password; providerName="System.Data.SqlClient"/>
  </connectionStrings>
    <system.web>
    <!--<authentication mode="Windows"></authentication>-->
        <customErrors mode="Off"/>
        <compilation debug="true" targetFramework="4.0">
        </compilation>
        <pages controlRenderingCompatibilityVersion="3.5" clientIDMode="AutoID"/></system.web>

    <system.web>
    <authorization>
      <allow users="?" />
      <allow roles="admin" />
    </authorization>
    <roleManager enabled="true" />
    <authentication mode="Forms" />
        <anonymousIdentification enabled="true"/>
        <profile enabled="true">
            <properties>
                <add name="MyCart" serializeAs="Binary" type="cart.Cart" allowAnonymous="true"/>
            </properties>
        </profile>
    </system.web>

    <system.webServer>
        <httpErrors errorMode="Detailed"/>
        <asp scriptErrorSentToBrowser="true"/>
    </system.webServer>
</configuration>


When I upload to server
i am getting Error related to database

"The SSE Provider did not find the database file specified in the connection string. At the configured trust level (below High trust level), the SSE provider cannot automatically create the database file."
Posted
Updated 7-Jun-13 0:59am
v2
Comments
CHill60 7-Jun-13 7:00am    
There is no instance of dbname on the server servername - create the database and your problem should go away

As the error message states it can't find the database that you have stated in your configuration string.

Can you connect to the database using SQL Server Management studio?
 
Share this answer
 
Comments
Ashwin Ganvir 7-Jun-13 7:15am    
yes..
Simon_Whale 7-Jun-13 7:23am    
is the database on a remote machine from the website? can you connect remotely? I would also check to make sure that you have spelt the database name and the servername correctly.
Ashwin Ganvir 7-Jun-13 7:24am    
i am able to connect my database through SQL Server Management studio..
But the issue is When anonymousidentification enabled="false then my website works properly, and i am not able to create cart...
Simon_Whale 7-Jun-13 7:26am    
Sounds like you have table permission problems, make sure that the account you use has permissions to select, insert, delete and update the cart tables
Ashwin Ganvir 7-Jun-13 7:34am    
i want to use that authorization, role maneger, and anonymousidentification enabled="true" for my cart page only... is it posible ... Now the condition is when i make anonymousidentification enabled="true" I get the error as mention and if i make
anonymousidentification enabled="false" then website goes fine but my cart control does not work.. please help me how to give seperate anonymousidentification to other pages and for my cart control... For better work of my Cart control i need anonymousidentification enabled="true"..

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900