If you are looking for help on how to get your Microsoft Access database working in more of a web based or cloud based methodology you have come to the right place.
On the Options tab in the SSMS connection window, you will also need to explicitly enter the databaseName value in the Database field to successfully connect.Welcome to RPT Software - Microsoft Access Cloud To connect in SSMS, you will need to append the domain name suffix, such as if you are in Azure public cloud. Note that LCS shows the server and database in the following format: serverName\databaseName. You can now use tools like SQL Server Management Studio (SSMS) to connect to the database, using the accounts from LCS and the IP address that you enabled. When the page is refreshed, the database account will be shown with its expiry time. Enter a short reason description and then select Request access. The available options include read or read-write access.
You also need to enter which type of access you require in the Database Accounts section. This includes operations such as database refresh or database import. This firewall entry will expire after 8 hours or it will be lost after the database is replaced by a database movement operation (whichever comes first). However, it is still possible to access the database.įrom the environment details page for your sandbox environment, select Maintain > Enable access, and then in the dialog box, add the IP address of your source environment. The self-service environment type has never had Remote Desktop Protocol (RDP) access or static database accounts. On the Options tab in the SSMS connection window, you will also need to explicitly enter the databaseName value in the Database field to successfully connect.
It also will be lost after the database is replaced by a database movement operation, such as database refresh or database import. This entry will expire, with the expire date shown alongside the IP address you entered. This leaves just the database accounts section, as shown in the following screenshot.įrom the environment details page for your sandbox environment, select Maintain > Enable access, and then in the dialog box, add the IP address of your source environment.
When RDP is removed from an environment, the machine credentials section of the environment details page is removed. If you no longer have Remote Desktop Protocol (RDP) access to your sandbox, you can add your IP address to the allow-list in a self-service manner from Lifecycle Services (LCS). Microsoft-managed environments without RDP access For more information about the available environment types, see Deployment overview. This process is available for both self-service as well as Microsoft-managed sandbox acceptance test environments.
This is useful if access to the database is required for various troubleshooting efforts, running unplanned queries, or data upgrade problem solving. This topic provides the steps necessary to enable database access using a just-in-time (JIT) fashion.