Grant login to SqlServer after users have changed domain
When user accounts are changed, i.e. when assigned to a new Windows domain, previous login to SqlServer do not work any more. The new domain makes all old Windows login invalid and previous login to SqlServer unusable. We suggest to add a user group, i.e. the BUILTIN\Users group, to the sysadmin role. Thus all users as well as IIS can have full access to the local database. NB! This will not exclude any login from the database so it is not an advise for a production server.
Follow instructions in the linked article to make SqlServer accept Windows login.
Related articles