How-to-simply...
Sign in
Existing users
Nick or E-mail:
Password:
Create account
Forgot password?
Nick:
E-mail:
Password:
Sign in
Your E-mail:
Add IIS 7 AppPool Identities as SQL Server Logons
1
In SQL Server Management Studio
2
CREATE LOGIN [IIS APPPOOL\YourAppPoolName] FROM WINDOWS WITH DEFAULT_DATABASE=[YourDatabase]
USE [YourDatabase]
CREATE USER [IIS APPPOOL\YourAppPoolName] FOR LOGIN [IIS APPPOOL\YourAppPoolName]
3
In SSMS refresh YourDatabase\Security\Users doubleclick on the newly created account
4
Set permitions
N
IUSR should have read write acces to your database mdf file
References
http://www.xdan.com/2010/03/iis-7-applicationpoolidentity-and-sql-server/
http://stackoverflow.com/questions/1933134/add-iis-7-apppool-identities-as-sql-server-logons
advertise here
Install CA Root PEM certificate --BEGIN CERT on Rocky/RHEL/CentOS
Flash ISO image to USB Drive or SD Card with dd command on Linux
Install .NET 8 SDK and NodeJS 14 on TeamCity Windows Server 2008 R2
Git ignore file permissions
Change WIN password in RDP session when Ctrl+Alt+Del captured by host
Print SHA256 hash for all RDP server certificates with PowerShell on Windows
Append yyyyMMdd-HHmmss datetime to the filename on Linux
Fix TeamCity GC heap initialization failed with error 0x8007000E on WIN net70
Show inner exception details on mouse hover when debugging C# application
Get Remote Desktop SHA1 certificate hash on Windows with PowerShell
Get Base58 alphabet
Switch to Colemak keyboard layout on Linux with localectl
Show Applications Task Bar at bottom of the screen on CentOS/RHEL/Rocky 9
Fix USB stor sense invalidCDB mounting Flash Drive on CentOS/RHEL/Rocky 9
Remap ALT+TAB keybinding with GNOME dconf to use ALT+TAB in xfreerdp session
Make REST API call with BasicAuth header from PowerShell on Windows
Set GNOME task view to NeverCombine
Set First Day of Week to Monday in GNOME Calendar
Get Windows 10 ReleaseId Current Version Not Build Number in PowerShell
Fix IDW10201: Neither scope or roles claim was found in the bearer token
Fix IIS Express SSL
Verify changed RDP certificate on Windows Server to prevent MITM
Fix application menu search box missing in GNOME on CentOS 7
Fix Postfix premature end-of-input on private/policyd-spf on Rocky/RHEL 8
Fix Postfix HELO command rejected need fully-qualified hostname from .NET Client
Connect to VPN automatically with NetworkManager GUI
Increase message list font size in Thunderbird
Add vertical guides to vim text editor at 80 and 120 characters
Automatically check all IMAP folders for new mail in Thunderbird
Get display screen model and serial number on Linux with edid-decode
Increase sudo password timeout for specific user on Linux
Clear log file on Linux
Resize/Extend LVM2 logical volume from unallocated space on RHEL/Rocky
Enable hardware random number generator on Rarpberry PI 3b Plus (Centos 7)
Add Colemak (Czech) keyboard layout to CentOS/RHEL/Rocky linux
Fix dotnet couldn't find a valid ICU package installed on the system
Prevent Firefox from trashing SSD drive or SD card
Fix not found error when running shell script from Dockerfile
Fix ERR CONNECTION RESET while debugging ASP.NET site in VisualStudio
Fix NewExpression with a constructor declared on an abstract class with Autofac
Fix debugger could not locate the source file in VisualStudio
Move Off Screen Window back to the viewport on Windows
Reset forgotten Windows password with osk.exe
Fix IIS HTTP Error 500.30 - ASP.NET Core app failed to start after publish
Find the process listening on some port on Linux
Fix ADO.NET slow query performance while the same query runs fast in SSMS
Sort Git branches by recent change date
Fix No Caching mode page found during boot on CentOS 7
Fix teamcity error NU1202: Package not compatible with net50
Fix VisualStudio breakpoints not being hit
Filter comments from config file with grep on Linux
Create bootable Windows 10 USB stick on Centos 8
Reset root password by editing shadow file on Linux
Find out which process or application is blocked by Windows Firewall
Fix FAT32 partition on FLASH drive and remove IsDirty bit on CentOS 8
Inspect any image layer created from Dockerfile
Exclude or filter values missing in the other column with except in Excel
Fix error pinging docker registry (no such host)
Fix Standard_init_linux.go exec user process caused no such file In Container
Visualize stack vs heap and boxing with SharpLab
Debug with Release config when Cannot obtain value optimized away
Attach database from YourDbName.mdf without ldf file on SQL Server
Convert NodaTime Instant stored as BIGINT in SQL field to human-readable Date
Fix keyboard repeat delay / blink speed settings in Windows 10 hidden
Prolong free Windows trial
Fix python-heal-selection.py missing on CentOS7
Switch to the old Win7 Alt+Tab dialog behavior in Windows 10
Fix 'Another git process seems to be running in this repository'
Remove old kernels in CentOS 7
Restore SQL Server database
Microsoft.ACE.OLEDB.12.0 provider is not registered on local machine LinqToExcel
Connect to RDP with rdesktop from command line
Setup Windows host to CentOS guest network in VirtualBox
Disable spell checking and grammar marking in Office Word 2013
Reset Id (identity column) to start counting from one in SQL Server
Revert to a previous Git commit
Fix missing SCP on CentOS 6 Minimal Install
Fix device ethX doesn't seem to be present after cloning virtualbox CentOS image
Survive SQL Timeout Exception
Get approximate count of rows (fast) in SQL Server
Download, compile, and install CMake on Linux
Run as different user missing on Windows 7
Fix 0x80070842
Get hostname from Url in C#
Install VirtualBox on CentOS 6.5
Add guidlines to the editor in Visual Studio
Detect TypeScript references in Visual Studio
Auto-Load File Changes in Visual Studio
Format USB drive in CentOS
Create bootable USB drive from CentOS ISO image in CentOS
Add IIS 7 AppPool Identities as SQL Server Logons
Setup private virtual network between multiple VMs in VMWare Player
Allow user to connect over SSH
Mount home partition on startup after reinstall in CentOS
Another MySQL daemon already running with the same unix socket
Echo text with new lines to file on RHEL
Fix pk-gtk-module error on CentOS 6.5
Write regexp to add missing sentence dots in exception messages
Remove double empty lines in Visual Studio 2012
Assign SSL certificate to IIS 7 site from command prompt