Dotnet logo

The .NET Tools Blog

Essential productivity kit for .NET developers


Configuring SQL Server 2017 for Rider

Rider is not only a great .NET IDE, it also is a wonderful tool for working with databases that are associated with .NET Core solutions. Many .NET Core developers use Microsoft SQL Server on their laptops; more specifically, the Developer edition of the database server tool. Let’s start a series of blog posts about Rider’s database tools (powered by DataGrip)!

Before you can start using Rider with a SQL Server database, you may discover that you must configure SQL Server 2017 to allow Rider to connect through a TCP port which is not set up at install. In this post, let’s look at configuring SQL Server 2017 Developer Edition to allow Rider to work with the server and databases.

This post is part of a series around working with databases and data in Rider:

Enabling SQL Server TCP/IP connections support

SQL Server Configuration Manager is the tool that manages the services that SQL Server uses for network connectivity and protocols. You will need to start this tool from a command line. The manager will not show in the app list in Windows since it is a snap-in for the Microsoft Management Console program and not a stand-alone app. Run the command C:\Windows\SysWOW64\SQLServerManager14.msc for SQL Server 2017.

Note: If you are running SQL Server 2016 or 2014 run the commands C:\Windows\SysWOW64\SQLServerManager13.msc and C:\Windows\SysWOW64\SQLServerManager12.msc respectfully.

You will then see the SQL Server Configuration Manager. We will need to work in the SQL Server Network Configuration section so expand and select Protocols for <Server Instance Name>. For the developer edition, you will have Shared Memory, Named Pipes and TCP/IP protocols. The only protocol enabled will be Shared Memory.

SQL Server Configuration Manage

The first thing we need to do is enable the TCP/IP protocol. Double-click the TCP/IP protocol in the list of protocols listed for the installed server to show the TCP/IP Property dialog. In the Protocol tab, enable TCP/IP through the Enabled property.

SQL Server Configuration Manage TCPIP Properties

In the IP addresses tab, you will locate a set of different IP settings. Go to the end and find the IPAll set of properties. If the TCP Dynamic Ports property for TCP/IP in IPAll is 0 this means no ports have been assigned and you will need to clear the property. In the TCP Port property add the port number you want to use. I will use the default number 1433 for my local SQL Server 2017 instance. After setting both properties and confirming with OK, you may get a prompt notifying you that you need to restart the SQL Server service.

SQL Server Configuration Manage TCP Ports Set

Finally, you will need to restart your SQL Server service in order to have the TCP/IP protocol and port to be enabled and listening. In the SQL Server Configuration Manager, select the SQL Server service from the list to the right, right click on that service and select Restart.


You should now be able to use Rider to connect to your local instance of SQL Server 2017, create Data Sources and work with the databases located on the SQL Server. In our next post, we’ll start doing just that. Stay tuned!

Download Rider and give it a try! We’d love to hear your feedback!

Comments below can no longer be edited.

7 Responses to Configuring SQL Server 2017 for Rider

  1. Avatar

    Andrey Berezniker says:

    March 15, 2018

    That’s great and very useful feature!
    But please fix the issue with missing “explain plan” menu option. Bug is still present at latest nightly build #RD-181.4035.375,

    • Avatar

      Chris Woodruff says:

      March 15, 2018

      Thanks Andrey for the comment about the post. Hope you enjoy the remaining posts in the series. Regarding the bug in Rider, we are looking into it right now. I appreciate you bringing it to my attention and I will keep you updated on it.

  2. Avatar

    Stefan says:

    May 16, 2018

    How can i do this on ubuntu 18.04 using terminal? Is it possible to do that?

    • Avatar

      Chris Woodruff says:

      May 16, 2018

      Stephan —

      That is a great suggestion for a future blog post! Thanks!


  3. Avatar

    Bradley Hayes says:

    June 27, 2018

    The only reason I dont use rider atm is 3 days trying to get it to run an mvc project with iis and sql and it just wont do it.

    I know it can do it.
    If I create a new .net MVC project in rider it runs without any configuration. Just detects and launches iis express etc. But if I download a repo or a starter project It alwasy wants me to configure it when I hit run.

    Wants me to enter paths for EVERYTHING even tho it just ran iis and dotnet 10 minutes ago in its own starter template.

    And then it just says “no projects to run” even tho when I open the folder it knows what kind of project it is an creates a sln file etc.

    Ive been using PHP storm for years and it so painful going to visual studio. I have resharper but even when you choose intellij shortcuts it doesnt have the same shortcuts that im used to at all like ctrl+shift+z does some weird sht instead of redo. Double shift doesnt exist. Ctrl+N is now dowble shift when it should be search class objects ahh!

    But in Visual studio running projects and adding sql databases always works without any problem so unfortunately have to put up with bad file searching and annoying intelisense popups that require escape key to get out of it before you hit return for a new line. UGH

    Please fix rider so it can run projects it didn’t create so I can ditch VS.

    • Avatar

      Jura Gorohovsky says:

      June 27, 2018

      “when I open the folder it knows what kind of project it is an creates a sln file etc.”
      Bradley, it looks like this is the culprit.

      Instead of opening the project folder, can you open the solution file (.sln) instead? Select File | Open | Solution or Project and choose the solution file. Will the project run in this case? Let us know.

  4. Avatar

    Wilson says:

    October 29, 2019

    Ola estou usando o ubuntu 19.10 como configuro

Discover more