In Windows Server 2012 R2, IP Address Management (IPAM) supported to store the data to an "External database" which is installed SQL Server 2008 R2 or SQL Server 2012. On "Provision the IPAM server", administrators can select to use "Windows Internal Database (WID)" or "Microsoft SQL Server".
In this lab, I'm going to select "Microsoft SQL Server" option to store the IPAM data.
Goal
- Use Microsoft SQL Server to store the data of Windows Server 2012 R2 IPAM Server
Lab environment
- 1 IPAM server named IPAM01 which is installed Windows Server 2012 R2 with IPAM
- 1 database server named DB03 which is installed Windows Server 2012 R2 and SQL Server 2012 Enterprise edition
- Both servers are joined test.tls1.lab domain
Prerequisites
- Installing IP Address Management (IPAM) Server on IPAM01
Lab
Symptom
When you select "Microsoft SQL Server" option in an IPAM server, you get the following error message.
IPAM Deployment failed with the following error.
Login to database failed.
You can restart this provisioning wizard from the IPAM overview page.
Cause
The IPAM server isn't granted right permission on a SQL server or Administrators selected "SQL credentials".
Resolution
1. On DB03, log in as SQL's administrator.
2. Launch "Microsoft SQL Server Management Studio".
3. Connect to DB03.
4. On "Microsoft SQL Server Management Studio" console, expand "Security".
5. Right-click "Logins", select "New Login".
6. On "Login - New" window, next to "Login name", enter "<Domain NetBIOS name\IPAM Server name$>".
In my lab environment, I entered "TLS1Test\IPAM01$".
7. On left pane, select "Server Roles".
8. Next to "Server roles", check "dbcreator" and "securityadmin".
9. Click "OK".
10. Run "Provision the IPAM server" with "IPAM server credentials" option in IPAM01.
As a result, the database was created on DB03 successfully.
Remark: IPAM doesn't support standard edition of SQL server.
This posting is provided “AS IS” with no warranties, and confers no rights!
