I am new QGIS, I was wondering what the parameters are for the New MSSQL Connection in the dialog window?

Provider/DNS: ? when local ? tried leaving empty

Host: ? when local ? tried my computer user name/server instance name

Database: full path to file I assume

Dialog Window



  • For host have you tried localhost?
    – artwork21
    Commented Sep 11, 2014 at 18:55
  • no, which parameter is that - host?
    – DonA
    Commented Sep 11, 2014 at 19:04
  • provider blank and host as localhost = invalid connection error
    – DonA
    Commented Sep 11, 2014 at 19:18
  • What database information is in your MSSQL server?
    – Erica
    Commented Sep 11, 2014 at 19:31
  • lat/long, address, plus other stuff i hope to be able to ignore
    – DonA
    Commented Sep 11, 2014 at 19:35

1 Answer 1


Looking at the QGIS help for another type of "New Database Connection" showed these

Name = A name to identify the connection settings.

Provider/DSN = The database server IP address or DNS name (not sure about this I got this from http://tinyurl.com/kjpqm6k)

Host = Name or IP address of the computer hosting the database server (leave blank for local connections)

Database = Name of the database (leave blank for default database on server).

Username = Database user name.

Password = Database password.

enter image description here

EDIT: In this question Mapperz says "Provider/DSN parameters not needed if you have a host."

  • My free version would not allow the help function.
    – DonA
    Commented Sep 11, 2014 at 19:47
  • I tried clicking the help for the MSSQL but it said there wasn't one written yet so I just got the help for another type. QGIS 2.4 Commented Sep 11, 2014 at 19:51
  • Still not sure what goes in the provider/DNS for a local Db, left host blank, and supplied the full file path
    – DonA
    Commented Sep 11, 2014 at 19:53
  • 1
    This is what a working one should look like i.imgur.com/8yc3x9G.png
    – Nathan W
    Commented Sep 11, 2014 at 22:32
  • 1
    @ChrisR can add the image to this answer. It was here first.
    – Nathan W
    Commented Sep 12, 2014 at 2:45

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.