NET application you’ll specify the provider name “”. ProviderName: Provider Name is used to specify the data provider for the application towards database.Local host entries, SQL Client Aliases, and DNS mappings will all report something other than the. See the User Id and Password in SQL Server in picture. Data Source / Server in Connection String servername. Password = ****: Set the password which you use to login into SQL server on your pc.User Id = sa: User id is the user id to login into SQL Server.
Here I’ve set the context class name = “StudentDatabase”. This topic explains options, variables, querying, and other options specific to the MS SQL data source.
Initial Catalog = StudentDatabase: Initial catalog is the name of the context class what you’ve created into your code classes. Grafana ships with a built-in Microsoft SQL Server (MS SQL) data source plugin that allows you to query and visualize data from any Microsoft SQL Server 2005 or newer, including Microsoft Azure SQL Database.For an example that walks you through the process of creating and connecting to a sample DB instance, see Creating a Microsoft SQL Server DB instance and connecting to it.