Knowledge Base
MilesWeb / How-Tos, Windows Server

How to Fix Server Error in ‘/’ Application when ASP.NET is not Installed?

Approx. read time : 3 min

The Server Error in ‘/’ Application will often render your SQL server unusable for the session if ASP.NET is not installed. It will display a message- ” Unable to use SQL Server because either ASP.NET version 2.0 Session State is not installed on the SQL server, or ASP.NET does not have permission to run the dbo.

It will probably look like this:
Server Error in '/' Application where ASP.NET is not installed on the SQL Server
This issue can sometimes occur even when you have an advanced ASP.NET version like 4.0. There are a few reasons this error can occur and, we have discussed how to resolve them.

To Fix Server Error in ‘/’ Application Due to

Session Storing in Database

1. Restart the Wizard.

2. Choose the Remove option to remove all those tables from the database.

As you are probably using the aspnet_regsql.exe application, it starts a Wizard and then goes on to add various aspnet_* tables in your database tables.

3. Copy and Run the given command:

 

It will add the tables ASPStateTempApplications and ASPStateTempSessions to your database.

Moving on, you have to modify your web.config file.

4. Copy this configuration:

Note: This solution works only when a user wants to store the session within its applications database. On the other hand, you can run this command without the “-d” parameter. That is if you want to maintain the session database separately. The server will then create a new ASPState database having two tables, as mentioned earlier in the article. Finally, you can specify the name of this new database in your configuration.

Stored Procedures for ASP.NET Session State Mode Error of SQL Server

When your server session expires automatically within a few minutes, you may have to reconfigure the procedures.

You have to properly set up the stored procedures for the session to work like before.

Run this code:

The -ssadd option will add the necessary support for the session state of SQL Server mode.

Roles Configuration Issue

The server error in the ‘/’ application may occur after the user successfully installs the ASP.NET Session State and later tries to lock down the permissions of the SQL Server.

You need to carefully configure the new roles and then assign permissions to them.

Here’s a code that may help you with it:

 

Prasad Khartadkar
Prasad is a business grad specialized in Marketing. He has garnered experience as a technical content writer and a digital marketer that he brings out in his work. He likes reading classics and travel in his free time.