Database Permission Settings or Path Are Not Configured Properly

This typically happens when you move from one system to another system and the permissions need to be changed to work from the system.

If you are using Microsoft SQL Server, open you Web.config file and make changes to the database connection strings appropriately:

<add key="DatabaseNorthwind1"

value=" Provider=SQLOLEDB;

Data Source=localhost;

Database=Northwind;

Trusted_Connection=no;

User Id=sa;

Password=sasa"

Specifically pay attention to the Data Source, Trusted Connection and User Id and password.

If you can’t connect to the database using this connection string, try to remove Provider argument, i.e. use it as

<add key=”DatabaseNorthwind1

value=”Data Source=mssql03.discountasp.net;

Database=Northwind;

Trusted_Connection=no;

User Id=DB_228441_1_user;

Password=password”

Provider=SQLOLEDB is needed only to distinguish SQL server from Oracle.

If you are using Trusted Connection and do not see any data, please review these “How to’s” from Microsoft: