Posts

Showing posts from June, 2017

Drop Down width increases automatically in IE 11

Add the onmousedown attribute and have it focus on the select dropdown so that it loses focus from the input box. For some reason focus on the input before accessing that select causes this error. <select onmousedown="$(this).focus()">

Cannot open database "" requested by the login. The login failed. Login failed for user 'IIS APPPOOL\'. after hosting on IIS

Image
Looks like it's failing trying to open a connection to SQL Server. You need to add a login to SQL Server for  IIS APPPOOL\ASP.NET v4.0  and grant permissions to the database. In SSMS, under the server, expand Security, then right click Logins and select "New Login...". In the New Login dialog, enter the app pool as the login name and click "OK". If you are using some custom app pool then give your app pool name.

Cannot open database "" requested by the login. The login fled. Login failed for user 'NT AUTHORITY\SYSTEM'. in mvc

Finally  I set the pool identity on LocalSystem and thought why it might be preventing "NT AUTHRITY\SYSTEM" from opening a connection to my database. I opened up SQL Server Management Studio as the user "Administrator" and checked out the  Server Roles  for NT AUTHORITY\SYSTEM under "logins" section. The default server role for this user was  public  by default.  I also checked sysadmin  and refreshed my web application form.