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"
MS SQL Server: 184.108.40.206
Default Instance: DefaultInstance
Named Instance: NamedInstance
If I have Access on 220.127.116.11\DefaultInstance and 18.104.22.168\NamedInstance then, below code works
DBI::dbConnect(odbc::odbc(), driver = "ODBC Driver 17 for SQL Server", server = "22.214.171.124\NamedInstance", port = "1433" trusted_connection = "yes")
If the Access to 126.96.36.199\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
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.