I'm trying to connect to a database located on the hosts' server.
Few things to note out:
a) I transfered the database onto the host via Visual Studio's "include in project" and publish - to get away from auto-creation by server and more problems.
b ) I'm using a MVC architecture.
c) The database I created on my pc(and is published onto the website), is created by SQLEXPRESS, the server's SQL version is SQL Server 2005 non-express.
d) Am using the code first approach.
I've had an immense amount of different bugs from "database not found" issues to "login failures" and "application / failures" just too many to name.
It has all come down to these last more detailed errors, the last one being: :
Cannot open database "aspnetdb.mdf" requested by the login. The login failed. Login failed for user 'NT AUTHORITY\SYSTEM'.
Can anyone guide me through setting these website configs right, cause it has to be up tomorrow and I'm really itching it now.
PS. web.config strings:
<connectionStrings> <remove name="LocalSqlServer" /> <add name="LocalSqlServer" connectionString="Data Source=.;Initial Catalog=aspnetdb.mdf;User Id=******; Password=******!;Integrated Security=True;" providerName="System.Data.SqlClient"/>
<membership> <providers> <clear/> <add name="AspNetSqlMembershipProvider" type="System.Web.Security.SqlMembershipProvider" connectionStringName="LocalSqlServer" enablePasswordRetrieval="false" enablePasswordReset="true" requiresQuestionAndAnswer="false" requiresUniqueEmail="false" maxInvalidPasswordAttempts="5" minRequiredPasswordLength="6" minRequiredNonalphanumericCharacters="0" passwordAttemptWindow="10" applicationName="/" /> </providers> </membership>
alot of thanks to readers and posters alike.