Hello everyone, welcome to my ArcGIS Tutorial. Today I am going to connect ArcGIS to SQL Server Database. As you know, SQL Server supports spatial database which means we can store our spatial datasets to the SQL Server. ArcGIS supports several databases such as Oracle, SQL Server, Spatialite and some others. I hope I can discuss all those database types in this blog. Before we can connect to SQL Server, you will need some information from the SQL Server.
Requirements
- SQL Server instance. You can build a low cost SQL Server database using Docker.
- User name and password to connect to the server/database
Connect ArcGIS to SQL Server
After you have a working SQL Server instance, now open Arc Map. In this case, I am using ArcGIS/ArcMap version 10.6.
- Open the Catalog window
- Scroll down and expand the Database Connections
- Double-click Add Database Connections
- Select SQL Server from the database platform
- Enter your SQL Server credentials
- Select the database/schema
- Hit OK
I also create a short video showing a step by step to create a new SQL Server connection on ArcGIS 10.6.
Thanks for reading this article, I hope it useful for you who wants to learn ArcGIS software. If you have any questions, please do not hesitate to contact me. Or simply leave your comments below. Cheers.