Skip to main content

SqlException: Login failed for user 'IIS APPPOOL\

This issue is related with the permission for application pool to connect with the sql.
We can create login user with the name as specified in the exception IIS APPPOOL\<name>
and grant permission to the database.
We can create new login user by opening the SSMS(Sql server management studio) navigate to Security>Login 
Then Add the user by right clicking Login and selecting new login
While creating user Navigate to UserMapping and tick the database for the specific user.

This process will create the new user and gran permission to the user.



Another Work Around
Yet another simple way will be to change the application pool Identity property To LocalSystem by navigating to the application pool and then advance setting.

Labels:

Comments

Post a Comment

Popular posts from this blog

Using SqlDataAdapter to fill DataTable in c#

public DataTable List(string sql)         {             SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString);             SqlCommand cmd = new SqlCommand(sql, con);             DataTable dt = new DataTable();             SqlDataAdapter da = new SqlDataAdapter(cmd);             try             {                              con.Open();                 da.Fill(dt);             }             finally             {                 con.Close();             }             return dt;         }
Post a Comment
Read more

Pivot in Oracle for Dynamic Columns

Pivot in SQL refers to the change of rows into columns based on specific constraints. An example of pivot could be the transpose of matrix. Example: a matrix containing day as 1st row and sales as 2nd row for  specific day sun    10 mon  20 tue    30 The transpose of the above matrix would be sun mon tue 10  20  30 This is an example scenario of pivot in sql. Now, Lets get on to the actual tables in database and see how we can use pivot . Starting with a fictional scenario, assume a table which contains two columns DAYS and SALES. CREATE TABLE TEST.DAILY_SALES (   DAYS   VARCHAR2(10),   SALES  NUMBER ) insert into DAILY_SALES('SUN',10); insert into DAILY_SALES('MON',20); insert into DAILY_SALES('TUE',15); insert into DAILY_SALES('WED',25); insert into DAILY_SALES('THU',10); insert into DAILY_SALES('FRI',30); insert into DAILY_SALES('SAT',5); Now when we execute the following select statement se
Post a Comment
Read more