Hi, I have a stored procedure that will display an activity if the user enters the correct appref. This stored proceudre works fine on SQL management. However when i bind it to the gridview on my page it doesn't work on the internet, keep getting the error. Cannot open database "StatsExplorer" requested by the login. The login failed.
Login failed for user 'statsexplorer'.
My stored procedure is on the statsexplorer database and my connection string in my web config file is :
<add name="StatsExplorerConnectionString" connectionString="Data Source=DOE2008\DOE2008;Initial
Catalog=StatsExplorer;Persist Security Info=True;User Id=***********;Password=**********" providerName="System.Data.SqlClient"/>
Have no idea why im still getting this error.
Any help would be great