Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.5K Microsoft Dynamics NAV
- 18.5K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 115 Navision DOS
- 854 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 615 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 269 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 992 SQL General
- 384 SQL Performance
- 33 SQL Tips & Tricks
- 34 Design Patterns (General & Best Practices)
- Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.7K General
- 1.1K General Chat
- 1.6K Website
- 79 Testing
- 1.2K Download section
- 23 How Tos section
- 259 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Options
Windows Login ID in SQL Server
najja
Member Posts: 67
Hello There,
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.
Regards
Naja
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.
Regards
Naja
0
Comments
No PM,please use the forum. || May the <SOLVED>-attribute be in your title!
Just check the output of this SQL statement:
8)
MVP - Dynamics NAV
My BLOG
NAVERTICA a.s.
Could you please tell me a little more how do I get the user id using this.
Right now I am able to get the User ID by querying to the AD using LDAP by configuring AD as a linled server. But this is quote comlicated and thought I am able to get the user ID I am not sure how I am gonna use it.
And sorry, I found out that the stored procedure shows you just SIDs of group which the actual users is member of, not list of all possible sids in the system. It means that connecting to the AD will be much better way.
MVP - Dynamics NAV
My BLOG
NAVERTICA a.s.