I am trying to connect to a SQL Server instance in ArcGIS for desktop to create a geodatabase.

I have installed the ArcGIS for desktop 10.8 version, but when I try to connect to the database server to create a geodatabase.

I get this error:

The server library could not be loaded

Any help on this issue, I have tried different tutorials but no help so far.

CodePudding user response：

If you get an error message indicating the server library could not be loaded, confirm that the correct SQL Server instance was enabled to store geodatabases. Sometimes, the wrong instance will result in this type of errors.

Also follow the below steps to create a geodatabase.

1. In the Catalog tree, right-click the database server on which you want to create a geodatabase.
2. Click New Geodatabase.
3. Type Osokopf in the Geodatabase name text box. The name must begin with a letter, cannot contain spaces or special characters (such as *, &, !, %, ., , or -), and has a maximum length of 31 characters when combined with your server name.
4. If you want to change the database file location, specify the new location in the Geodatabase file text box by clicking the ellipsis button (...) and browsing to the location. The location you use to store the geodatabase file must be on the same computer as the SQL Server Express instance. In this case, use the default location.
5. You can specify the initial size of the geodatabase in megabytes (MB) or gigabytes (GB). For this geodatabase, change the initial size by typing 30 in the Initial Size text box and choosing MB from the Units drop-down menu. When determining the initial size of the database, you should take into account the size of the data you plan to load into it and the amount of editing you anticipate doing. If you make the initial size too small, the database will grow to accommodate the data. However, increasing the database file size uses extra resources, which could slow down database performance. If you make it too large, you needlessly use up storage space on your computer. Since you will only be loading a small amount of data and doing a few edits for this tutorial, 30 MB will suffice.
6. Click OK.