asp.net - Login and account registration broken on MVC application -


hello i'm new mvc , have been looking solution problem last couple days no avail.

i've created simple blog engine using asp.net mvc, after installing on iis on local pc, realized needed database login service work.

so elected use localdb on pc plan use server. moved files on pc , installed needed. installed sqlexpress localdb , reset site, working perfectly. however, noticed minor typos on section of site that's not edited. stupidly, reinstalled website entirely new build instead of updating view needed correction smart person do.

now every time attempt login excising account or create new 1 error

cannot attach file 'c:\inetpub\wwwroot\app_data\aspnet-facetblog-20161020065352.mdf' database 'aspnet-facetblog-20161020065352'.

from i've learned, it's localdb instance, fixes i've found online seem have no effect.

admittingly, i'm pretty naive comes sql, fix simple. if i've failed provide vital information please tell me , i'll update question. additionally, explanation of went wrong appreciated. thank time.

when reinstalling site, had deleted database file aspnet-facetblog-20161020065352.mdf in database directory. since deleting mdf file doesn't affect registered sql express instance, sql express thinks database still exists , trying connect failed.

first, try attach db using ssms query this:

exec sp_attach_db @dbname=n'aspnet-facetblog-20161020065352.mdf', @filename1=n'app_data\aspnet-facetblog-20161020065352.mdf', @filename2=n'app_data\aspnet-facetblog-20161020065352.ldf'

nb: assumed mdf file location stands in app_data directory, change actual database directory.

if attempt attach query doesn't work, try these steps:

  1. stop iis/iis express pool if still running.
  2. open windows powershell instance on server pc (install first if doesn't exist).

  3. run following command:

    sqllocaldb.exe stop v11.0 sqllocaldb.exe delete v11.0 sqllocaldb.exe start v11.0

  4. recreate db instance on project, including data connection in server explorer (remove create).

  5. re-run project in development machine, copy required files server pc. database instance should (re-)generated @ time.
  6. restart iis/iis express pool on server pc.

additionally may run update-database command package manager console ensure database integrity.

if solutions still won't work altogether, rename database files , attach on project, verify connection string retry step (5) , (6) above.

related problems:

ef5: cannot attach file ‘{0}' database '{1}'

cannot attach file ".mdf" database "aspnet-"

delete .mdf file app_data causes exception cannot attach file database

cannot attach file 'c:\inetpub\wwwroot\mvcapplication10\app_data\aspnet-mvcapplication10-20130909002323.mdf' database 'aspnet-mvcapplication10-20130909002323'


-

Comments

Post a Comment

Popular posts from this blog

java - SSE Emitter : Manage timeouts and complete() -

i writing web app multiple listeners(evcentsource sse clients js) connected server . want store sse emitter per connected listener : can done in memory or other means assigning id each client able achieve far now question ; how send response/event specific client connected web app ? while doing sseemmiters stored either getting completed or timed out. how prevent ? how keep sseemmiter available open infinite time (till client closes) , send events selectively .
Read more

jquery - uncaught exception: DataTables Editor - remote hosting of code not allowed -

i'm trying implement crud operation using datatableseditor using datatables.but i'm getting error messages: 1)uncaught exception: datatables editor - remote hosting of code not allowed. please see http://editor.datatables.net details on how purchase editor license 2)typeerror: a.editor undefined 3) $.fn.datatable.editor not constructor" what reason? here configuration: <%@ page language="java" contenttype="text/html; charset=iso-8859-1" pageencoding="iso-8859-1"%> <!doctype html public "-//w3c//dtd html 4.01 transitional//en" "http://www.w3.org/tr/html4/loose.dtd"> <html> <head> <meta http-equiv="content-type" content="text/html; charset=iso-8859-1"> <title>insert title here</title> <link rel="stylesheet" type="text/css" href="//cdn.datatables.net/1.10.12/css/jquery.datatables.min.css"> <link re...
Read more

java - How to resolve error - package com.squareup.okhttp3 doesn't exist? -

i trying convert json java object use of gson in maven, following youtube video guidance - https://www.youtube.com/watch?v=vqgghm9pwe0 , theres error occurs when in main class error - package com.squareup.okhttp3 doesn't exist. code below: java package com.codebeasty.json; import com.squareup.okhttp3.okhttpclient; public class main { private static okhttpclient client = new okhttpclient(); public static void main (string [] args) { } } i put in dependency in pom.xml: <dependencies> <dependency> <groupid>com.squareup.okhttp3</groupid> <artifactid>okhttp</artifactid> <version>3.4.2</version> </dependency> <dependency> <groupid>com.google.code.gson</groupid> <artifactid>gson</artifactid> <version>2.8.0</version> </dependency> </dependencies> i dont understand why doesn't recognize com.squareup. there may need download? have downl...
Read more