E
E
Elena2016-03-04 09:36:04
ASP.NET
Elena, 2016-03-04 09:36:04

What settings need to be made on the server in order for the standard authorization of the asp.net mvc 4 Internet application to work??

There is an Internet application on ASP.NET MVC 4 with standard authorization. Authorization works locally, errors occur when publishing on the server. The web application is written in VS 2013. The connectionString has been tweaked for uploading to the server. Initially it was Data Source=(LocalDb)\v11.0;, and for the server it was Data Source=.\SQLEXPRESS;
connectionString="Data Source=.\SQLEXPRESS;
Initial Catalog=aspnet-Statistics-20150619091307;Integrated Security=SSPI;AttachDBFilename=|DataDirectory|\aspnet-Statistics-20150619091307.mdf"
The server gives an error:
System.Data.SqlClient.SqlException: Failed to generate user instance of SQL Server due to an error getting user application local data paths. Make sure the user has a local profile on this computer. The connection will be closed.
SqlLocalDB and Sql Express 2014 were installed on the server

Answer the question

In order to leave comments, you need to log in

1 answer(s)
D
Dmitry Kovalsky, 2016-03-04
@dmitryKovalskiy

1) What does "this authorization" mean? 2) What does "locally" mean? 3) How is automatic authorization implemented? If you are using a standard or custom implementation of membership, then study the authorization settings on local IIS and combat. If you have a handwritten craft - it can be anything.
UPD: MSSQL Express version is installed on your local machine and a suitable connection string is formed for it. And now my question to you - is a similar server installed on your combat server (required on the same machine) ??? And also specify that the "SYSTEM" user on your server has the ability to connect to the database server and generally interact with it somehow. Ideally, your database should have a user under which you connect to it. It must be given the necessary rights to interact with the database.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question