Rank: Newbie
Groups: Member
Joined: 8/17/2010
Posts: 2
Points: 6
Location: London
|
Just installed and configured versaSRS but when I tried to connect from Internet Explorer I got the following:
System Error
The following error has occurred:
.Net SqlClient Data Provider - Cannot open database "versasrs" requested by the login. The login failed. Login failed for user 'D002426\ASPNET'.
Tried searching the site for "cannot open database" but did not find anything.
Am sure that this is something trivial so can someone point me in the right direction.
Thanks
Using:
Windows XP Professional
IE 8
SQLServer Express 2008 R2
Visual Studio Express 2008 SP1
|
Rank: Administration
Groups: Administration
, Member
Joined: 11/20/2008
Posts: 46
Points: 41
Location: Australia
|
It seems like a step has been missed or gone wrong during the installation. If you check the permission_output.txt file (C:\Program Files\VersaDev\versaSRS\Setup\SQLScripts) it should show if there was an error.
You can fix this by running the GrantPermissions_ForLocal.sql (C:\Program Files\VersaDev\versaSRS\Setup\SQLScripts) file against the versasrs database. You will need to edit the script to replace the tags to include your machine name (D002426) and the database name (versasrs). See below example (You could in fact copy and paste the below into SQL and run it).
-- ===============================================
-- versaSRS DATABASE
-- Grant permissions for Local DB Install
--
-- Examples:
--
-- <TRUSTEDACCOUNT> = [D002426]\ASPNET
-- <TRUSTEDACCOUNT> = [MACHINENAME]\IWAM_[MACHINENAME]
-- <TRUSTEDACCOUNT> = NT AUTHORITY\NETWORK SERVICE
-- ===============================================
DECLARE @username sysname
SELECT @username = '<TRUSTEDACCOUNT>'
USE master
EXEC sp_grantlogin @username
USE [versasrs]
EXEC sp_grantdbaccess @username
EXEC sp_addrolemember N'db_owner', @username
|
Rank: Newbie
Groups: Member
Joined: 8/17/2010
Posts: 2
Points: 6
Location: London
|
Brilliant, just what I needed to know.
Application now up and running.
Thanks for the advice Phillip.
|
