Database Connection from RedHat Linux CentOS 8 RStudio Server to MS SQL Server Named Specific Instance

Tags: #<Tag:0x00007f5a964d7388> #<Tag:0x00007f5a964d70b8> #<Tag:0x00007f5a964d6ed8>

Hi Community,

I am trying to establish connection to MS SQL server Database Specific Names Instance from RedHat Linux CentOs 8 RStudio Server using Windows Authentication. The issue I am facing here is Unless I Have Access to Default Instance, I Am Unable to Connect to Specific Named Instance.

**We are using Kerberos Token and AD System to use Windows Authentication"

Example:
MS SQL Server: 111.111.111.111
Default Instance: DefaultInstance
Named Instance: NamedInstance

If I have Access on 111.111.111.111\DefaultInstance and 111.111.111.111\NamedInstance then, below code works

DBI::dbConnect(odbc::odbc(),
                           driver = "ODBC Driver 17 for SQL Server",
                           server = "11.111.111.111\NamedInstance",
                           port = "1433"
                           trusted_connection = "yes")

If the Access to 111.111.111.111\DefaultInstance is revoked, the above code throws error nanodbc/nanodbc.cpp:983: 00000: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Login failed for user XXXXXX. [Microsoft][ODBC Driver 17 for SQL Server]Invalid connection string attribute

Packages:
odbc 1.2.2
DBI 1.1.0
R Version 3.6.0

Is that a limitation to have access on default instance to access named instance on the same server? If not is there any other argument that I need to pass to connect directly to named instance even when I don’t have access on default instance?

Any help is really appreciated. Thank you in advance.