I have build a Web Site with Membership and User Login (Visual Studio) http://msdn2.microsoft.com/en-us/library/879kf95c(VS.80).aspx.
I did not use the ASPNET.MDF, but used a SQL Server data base, created by executing aspnet_regsql.exe. I am using SA + password to authenticate into the database. I refered to this below link and my config file is similar. http://forums.asp.net/899888/ShowPost.aspx Everything worked great from my local computer, but now that I've deployed it to the development server, it is blowing up at first login with an Error: Login failed for user 'Comanyname\developmentservername$'. System.Data.SqlClient.SqlException: Login failed for user 'company\developmentsevername I have enabled permissions on the content directory for user 'company\developmentsevername so, that looks to be ok. I don't understand what's wrong. I have even tried adding company\developmentsevername to the project as a user but no luck. Here is a parred down version of my top level config file <appSettings/> <connectionStrings> <remove name="LocalSqlServer" /> <add name="LocalSqlServer" connectionString="data source=liveDBName;Integrated Security=SSPI;Initial Catalog=dbname; User ID=sa;Password=xxx" providerName="System.Data.SqlClient" /> </connectionStrings> <system.web> <roleManager enabled="true" /> <membership defaultProvider="portal_insProvider"> <providers> <add name="portal_insProvider" type="System.Web.Security.SqlMembershipProvider, System.Web, Version=2.0.0.0, Culture=neutral, PublicKeyToken=blah" connectionStringName="LocalSqlServer" /> </providers> </membership> <authentication mode="Forms"> <forms loginUrl="~/Login.aspx" defaultUrl="~/LoginView.aspx" /> </authentication> </system.web> thanks
