Geek Answers Handbook

"The connection string indicates a local instance of Sql Server Express," except that it is not

I am trying to deploy an asp.net application to a server using an instance of SQL Server for the ApplicationServices membership database.

The problem is that I get an error message

The connection string indicates the local Sql Server Express instance using the location of the database in the App_Data application directory p>

I got this error when I first tried to deploy aspnetdb.mdfmyself with the application.

I got this error after I abandoned this plan and decided to convert web.configso that I use the Express database in Debug, but in Release the connection string is sent to SQL Server.

I got this error again when I decided, out of curiosity, to remove all links to the express database from the code, so there could be no possible way to find the Express database. Bad luck.

Does anyone have any ideas about this? I uninstalled and reinstalled the website in IIS every time, noting that there was no deployment of App_Data and no mention of the .mdf file in web.config - to no avail. He still thinks the connection string indicates a search for SQL Server Express database: /

Edit: Here is the connection string I am using. Pretty standard, I think, but I could always be wrong.

Data source=HERP;Initial Catalog=DERP;Integrated Security=True
+5
source share
2 answers

machine.config (LocalSqlServer)? , , :

Machine.config [...]:

<membership>
<providers>
<add name="AspNetSqlMembershipProvider" [...]
connectionStringName="LocalSqlServer" [...]

+6

connectionStrings:

<connectionStrings>
   <clear />
   <add name="LocalSqlServer" connectionString="Data Source=(local);Initial Catalog=aspnetdb;Integrated Security=True" providerName="System.Data.SqlClient"/> 
</connectionStrings>
+5

More articles:


All Articles