Member Avatar for nebyas
nebyas -2 Newbie Poster

Dear Friends,

I devloped a web application in ASP.NET/ Sql Server 2008 and tested in development pc. It is working fine. But when it is deployed in Server running windows 2003/ IIS 6/ Sql Server 2005 and 2008, it is giving access error. "Error 26. Cannot access the database".

I am forms authentication.
Hence need aspnetdb.mdf file and is stored in app_data/ aspnetdb.mdf.

My connection string is attached:

<add name="ASPNET_Connection" connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\ASPNETDB.MDF;Integrated Security=True;User Instance=True"
      providerName="System.Data.SqlClient" />

Please help me in this issue.
Thanking you in advance.

  • 1 Contributor
  • 0 Replies
  • 52 Views
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.