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