We are using Dynamics NAV 5.0 with SQL Server 2005. We are trying to use MS SQl Reporting Services to pull out some reports, mainly security and permissions related so that we can have those reports published in the Report Portal configured in MOSS 2007. The problem is when I opened the NAV database from SQL Management studio I found that there are only SIDs available in the 'Windows Login' Table. But when I open the same table using object designer I can see User ID as well as Name columns. Can anybody tell me how do I retrieve those fields from SQL Server as it is crucial for reporting.