1

I want to add database connection to SQL Server from ArcMap.

But, I don't know what to write as 'instance'. I've tried 'NT Service\MSSQLSERVER' but it doesn't work.

enter image description here

  • 1
    Worth searching the ESRI knowledge base articles, I found this? – Hornbydd Feb 22 '18 at 15:02
  • @Hornbydd It says 'Failure to access the DBMS server' – fatmasen Feb 22 '18 at 15:17
  • 1
    Once all connections were Direct Connect, the "sde:rdbmskey:" was eliminated in favor of a picklist and an RDBMS-dependent parameter string. – Vince Feb 23 '18 at 3:19
  • Here is the doc for your specific question. There's syntax instructions and an image example. – ORA-55378 Feb 24 '18 at 3:27
2

If you installed SQL server with default instance on your computer, then just write ".\". It means localhost.

You can find instance name from services in windows:

Go to windows services => find SQL Server.The default instance name is MSSQLSERVER.

Other instance names also are between parentheses.

enter image description here

enter image description here

If SQL server installed on a server and you want to connect to this, you should use server IP (You may need a VPN). In the below image you can see an IP and an instance name (not default instance).You maybe need to use a port for connecting to a server like this: (192.0.0.0:2222\instancename)

enter image description here

| improve this answer | |
  • I installed with default instance on my computer. I tried the first choice you mentioned, it says 'The user's default database is a system database; automatic connections to system databases are not allowed. Please provide a different database for connection.' – fatmasen Mar 2 '18 at 10:30
  • Try to connect with "sa" user or windows authentication. – BBG_GIS Mar 2 '18 at 12:06
  • @fatmasen How to get the "sa" password? – zakaria mouqcit Sep 18 at 14:33
0

I my connections to SQL Server I put the server IP address or the server name in the Instance parameter, but I'm using Database Authentication as Authentication Type.

| improve this answer | |
  • 1
    It's not quite just server name or IP -- If it's a named instance, then that custom instance name would be appended, with a backslash between them. – Vince Feb 23 '18 at 3:16
0

I guess it depends on how the servers/instances are set up. Check with whoever has control on that. At our place we use server name along the lines of this:

Database COnnction dialog

The database instance, databases and users are set up by out IT contractor.

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.