How do I connect to my database via .NET?

A website built using .NET can be connected to databases of different types: MSSQL, and Access databases.

You need to use a specific connection string to connect to each database type:

MSSQL

  • Server=myServerAddress;Database=myDataBase;User Id=myUsername;Password=myPassword;

 

As long as the placeholders in the above are replaced with your actual database connection details, it should allow a connection to the database.

  • 0 Users Found This Useful
Was this answer helpful?

Related Articles

How do I manage my Microsoft SQL database?

We recommend using SQL Server Management Studio (SSMS) for managing your Microsoft SQL databases....

What’s the MSSQL database size limit?

At UmbHost, each MSSQL database can store up to 5120 MB (5 GB) of data, and you can store up to...

Can I set my database hostname as ‘localhost’?

No, you would need to set the database hostname as the server that it's on at UmbHost. You can...

Can my database be restored from a bacpac file?

We will happily restore your database from a bacpac file. Please open a support ticket to...

Where do I find my MSSQL Database information?

The MSSQL Database details can be found under the "Additional Information" tab on the affected...