Connecting Role Tailored Client to the SQL Server Database

braveheart

In Classic client everything is working fine.
I am able to connect to my SQL server database using sa with password.

But not able to view a report in RTC after designing in classic client using following command.
dynamicsnav:////runreport?report=<reportid>

error message:
The Microsoft Dynamics NAV server cannot connect the change listener to SQL server due to the following error:
Cannot open database "Demo Database NAV (6-0)" requested by the login. The Login failed. The Login failed for user 'NT AUTHORITY\NETWORK SERVICE'.

After this i tried altering the 'CustomSettings.config' file but didn't worked.
So i tried selecting server name as 'supermannb/supermannb' in Select Server and Company window of RTC.

error message:
A server was not found at
"net.[url=tcp://supermannb:7046/supermannb/Service]tcp://supermannb:7046/supermannb/Service[/url]".Either the URL is incorrect or the server is currently not available.

Everything is installed on single system
Windows 7, Firewall enabled, SQL Server 2008 R2, Dynamics NAV 2009
Database created using Classic client and then backup file (fbk) restored and sa added to the Database users with super.

How can i access SQL database from RTC. Please help. ](*,)

deV.ch

"NT AUTHORITY\NETWORK SERVICE" must be added as windows-user in sql server and needs to have rights on that database

braveheart

"NT AUTHORITY\NETWORK SERVICE" already existing in SQL Server > Security > Logins
with public and sysadmin Server Roles.

Also it is existing in database > Security > Users with
Schemas:
$ndo$navlistener
db_owner
db_securityadmin

and database roles
db_owner
db_securityadmin