How do I connect to my MSSQL database?

This article applies to Windows Shared Hosting accounts.

Use the following script to connect to your MSSQL database:

You will need to update the following lines inside your web.config file with your database information.

<appSettings>

<add key="ConnectionString" value="Server=ATLAS-SQL-03; Database=testdatbase_556294_db1; User Id= usertest_0001; Password=??????" />

</appSettings>

Next, you must change the following information in the above scrip in order to connect to your MSSQL database:

  • Server: Also known as database hostname or database server.
  • Database: Also known as database name or db name.
  • User Id: The user name you received when you created the database via the Webfusion control panel.
  • Password: The password you set for your account when you created the database via the Webfusion control panel.

If you haven’t yet created a MSSQL database via the Webfusion control pane, click here to learn how to create a new MSSQL database.

Answer options

Your feedback was successfully added.

Answer tracking

Track

Watch the content of this article for changes.