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 Sep 11 '14 at 18:55
  • no, which parameter is that - host? – DonA Sep 11 '14 at 19:04
  • provider blank and host as localhost = invalid connection error – DonA Sep 11 '14 at 19:18
  • What database information is in your MSSQL server? – Erica Sep 11 '14 at 19:31
  • lat/long, address, plus other stuff i hope to be able to ignore – DonA Sep 11 '14 at 19:35

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 Sep 11 '14 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 – landocalrissian Sep 11 '14 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 Sep 11 '14 at 19:53
  • 1
    This is what a working one should look like i.imgur.com/8yc3x9G.png – Nathan W Sep 11 '14 at 22:32
  • 1
    @ChrisR can add the image to this answer. It was here first. – Nathan W Sep 12 '14 at 2:45

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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