Connection fail to SQL Server after a database restore

Scenario.

Restore SQL Server database X.
Try to conenct using the usual connection string. Conenction fail.

Yes
Yes
Delete the user in “Security” of SQL Server.
Delete the user from the “Users” of the database.
Create a new user in Server/Securit6y/Logins:
– User name: seelct a user that exists in the machine, ex.: \user
– leave everything unchaged
Create a user in the database in database/Security/Users:
– Login namne: seelct <achine\
– User name: select \
No
Todo
> Yes
< Do you use an IP address in the connection string?

in the database:
– User name: select / using hhe selector
– Login name:
– Default schema:
> No
Yes
Check the user defined in the Application Pool of the current web site
> No
Todo
> No
Todo

Advertisements