Problem with connection of R studio with SQL Server

Question

Problem with connection of R studio with SQL Server

Solomon P Obode 0

I am trying to connect my R studio to SQL server but this error shows up, could someone assist on what I am missing or how to go about it? User's image

Erland Sommarskog 121.8K Reputation points MVP Volunteer Moderator

2023-10-24T21:37:42.1966667+00:00

There should be something after the colon in the error message. Can you share it?

Solomon P Obode 0

Error: nanodbc/nanodbc.cpp:1135: 01000: [Microsoft][ODBC SQL Server Driver][Shared Memory]SQL Server does not exist or access denied.  [Microsoft][ODBC SQL Server Driver][Shared Memory]ConnectionOpen (Connect()).

1 answer

Your answer

Erland Sommarskog 121.8K Reputation points MVP Volunteer Moderator

2023-10-24T21:37:42.1966667+00:00

There should be something after the colon in the error message. Can you share it?
Solomon P Obode 0 Reputation points

2023-10-25T14:39:28.53+00:00

Error: nanodbc/nanodbc.cpp:1135: 01000: [Microsoft][ODBC SQL Server Driver][Shared Memory]SQL Server does not exist or access denied. [Microsoft][ODBC SQL Server Driver][Shared Memory]ConnectionOpen (Connect()).

Answer 1

That error means that you did not reach the SQL Server instance you were trying to access. I see that you are trying to access a local default instance. Possible reasons for the failure:

SQL Server is not running.
You don't have any local SQL Server instance at all.
You have an instance, but it is a named instance. For instance, SQL Express by default installs a named instance, SQLEXPRESS, to which you would connect as .\SQLEXPRESS
For some reason the protocol Shared Memory is disabled for the instance. You can check this in the SQL Server Configuration Manager.

Since we don't know your environment, we cannot pinpoint exactly what's wrong.

Share via

Problem with connection of R studio with SQL Server

1 answer

Your answer