MVC Published web application gives page error in transaction containing database!?

Question

MVC Published web application gives page error in transaction containing database!?

Zeynep BARAN 21

Hello,
I created a web application with ASP.NET Core MVC technology, where I created the database using Entity Framework and Sql Management Studio. In the most general sense, I created every stage of my project, which consists of a login page, admin page and user pages.
I Published my project using Web Deploy methods with IIS so that I can present it as a demo in the company.
I can see my project with a few problems. But when I perform operations on the Web Page that I need to connect to the Database, I get the following error.
When I look at the resources to fix the error, it says SQL> Security>login>new login to define the specified user and authorize the database. When I perform the steps, I still get the error I shared below. I'm using the local database I created via Migration and I've made the configuration settings.
How can I get it resolved. This is my first project, it is very important in terms of presentation. Please help.

Answer accepted by question author

1 additional answer

Your answer

Answer 1

AgaveJoe 30,411

BROADCAST\TEKNIK-PC1$ is a service account, correct? Be sure to set the IIS application pool identity to BROADCAST\TEKNIK-PC1$. Your connection string will use Trusted_Connection=True and the application pool identity (BROADCAST\TEKNIK-PC1$) will pass the service account to login. If you are still having issues then contact your AD account admin for assistance.

You are correct using the SA account is considered insecure. As a matter of fact, any security assessment will consider an active SA account an active security risk.

Zeynep BARAN 21 Reputation points

2021-09-03T09:54:26.407+00:00

Hi @AgaveJoe ,
II checked the link. As in the link, I made LocalSystem the identity of the repository my application is connected to. This time, I had to authorize on the SQL side, when I gave an error for NT AUTHORITY\SYSTEM, I gave my authorization at the SQL stage as in the pictures above. Now it gives an error like in the picture. But when I run the application on Visual Studio, I don't get an error. What can I do?
AgaveJoe 30,411 Reputation points

2021-09-03T11:27:35.543+00:00

The error is very clear. The SQL account does not have the authority to create a table. Assign the SQL user to an appropriate SQL role or grant proper access.
Zeynep BARAN 21 Reputation points

2021-09-03T14:16:09.347+00:00

Thank you @AgaveJoe I solve this problem... Thank you very much:)

Answer 2

Duane Arnold 3,216

IMO, the easiest thing to do is use the 'sa' account and password to logon to the database, which is the system administrator account for all MS SQL Server databases that on your development machine.

Then you can go to the appsettings.json file for the MVC project in Visual Stuido to use the SA and password on the connectionstring in the appsetttings.json file, which is a text file.

connetionString="Data Source=ServerName;
Initial Catalog=DatabaseName;User ID=UserName;Password=Password"

http://csharp.net-informations.com/data-providers/csharp-sql-server-connection.htm

Zeynep BARAN 21 Reputation points

2021-09-02T13:36:58.877+00:00

Hello @Duane Arnold ,
I did not use the sa user because it is said that it is not very safe to use during publishing. Is sa user safe? I will present this application because that's why I'm asking. I want to solve it without giving way to security vulnerability. And of course I don't know my sa password.
I converted a text file into a sql script, imported it into my MVC project and wrote the following command. It still gives the same error. How can i solve it.

USE EnvanterDb ;
GO
EXEC sp_change_users_login 'Auto_Fix', 'BROADCAST\TEKNIK-PC1$' ;
GO
Duane Arnold 3,216 Reputation points

2021-09-02T17:31:28.563+00:00

f 'SA' is being used on your local development machine for some demo that is doing database access that's on your local , then 'sa' is save to use.

Share via

MVC Published web application gives page error in transaction containing database!?

1 additional answer

Your answer