If you need to copy or move your database to a new server, there are some steps required to setup the IntranetConnections login access.
By default, the Intranet Connections web application connects to the database server using a SQL login named "IntranetConnections". Your SQL server must have this login mapped to a user in the database IntranetConnections as a "db_owner" role.
- Create a SQL login called "IntranetConnections" and make note of the password
- Restore your IntranetConnections database to the new server
- Open a New Query window connected to the restored database
- Execute the following command to re-associate the login with the user in the database: exec sp_change_users_login 'auto_fix','intranetconnections';
Once the login/user mapping has been successfully configured, you should see something similar to this if you look at the login properties for "IntranetConnections":