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
- 271 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 993 SQL General
- 384 SQL Performance
- 34 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
SQL Error 916,"08004"
rainer.g
Member Posts: 3
Hi,
has anyone a idea ?
I have created a view on a SQL 2000 Server.
On the "German" DB the data of the "UK" DB table shown here.
I have caused a new DB roll which I have assigned to the user for the access (selct for view object in German and select on table object in UK DB).
If I call this view table in Navision now, I get the following error message:
<<916,"08004",[Microsoft][ODBC SQL Server Driver][SQL Server]Server user xxx is not a valid user in databsae UK>>
But if i use the SQL Query Analyzer -> login with the same user and write a select to this table, it works.
So thus not enough, if I give the User xxx the databse role "db_owner", then it works too with Navision.
Regards,
Rainer
has anyone a idea ?
I have created a view on a SQL 2000 Server.
On the "German" DB the data of the "UK" DB table shown here.
I have caused a new DB roll which I have assigned to the user for the access (selct for view object in German and select on table object in UK DB).
If I call this view table in Navision now, I get the following error message:
<<916,"08004",[Microsoft][ODBC SQL Server Driver][SQL Server]Server user xxx is not a valid user in databsae UK>>
But if i use the SQL Query Analyzer -> login with the same user and write a select to this table, it works.
So thus not enough, if I give the User xxx the databse role "db_owner", then it works too with Navision.
Regards,
Rainer
0
Comments
http://msdn.microsoft.com/library/defau ... y_5c37.asp
Hope this helps...
Or may be problem is that Navision is using Application roles to access data, and this App. role has only rights to the actual database... there is no same App. role for the connected DB and it is why you get this error...
MVP - Dynamics NAV
My BLOG
NAVERTICA a.s.
thank's for your answers.
I have changed the "Cross DB Ownership Chaining" to 1 now and get the same error message. In addition, the User already is member of both databases. I therfore not think this is a access problem, i have then got other error's.
Kine,
what you exactly mean with it ?
Is it this it two different country versions are ?
Regards,
Rainer