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
- 262 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 992 SQL General
- 385 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
Moving NAV-SQL-DB to new Server - SQL Error 1088, 42000
svensk.tiger
Member Posts: 31
Hi All,
a bit mysterious
I recently set up a new SQL-Server, same OS and SQL-Versions like the old one: Win2008R2-64, Sql 2008R2-64, same patchlevel.
Same xp_ndo_x64.dll, same startup flags.
I restored a sql backup of a NAV-5 DB from the old one on the new server.
For a couple auf days, everything worked fine.
Then we got a new Object-Range and i created a new NAV-License file in VOICE. And I'm pretty shure, I claimed the ISV insert right.
From the time I've uploaded the new license file on the new server, some of the developers - all without dbo or sysadmin rights -cant create new fields in tables, they got this SQL error message:
I restored the old license file, but same Error.
Same user on the old server, no problem.
Upload new license file on old server, no problem.
The users rights on both servers are exacly the same. (Server Logins, DB users, roles)
The only difference, that can be seen, is in SQL management studio, Database properties, permissions, Effective user rights:
On the old server, it shows lots of ALTER rights, on the new one only CONNECT, DELETE, INSERT, SELECT and VIEW DB STATE.
What else may have influence on these effective rights?
a bit mysterious
I recently set up a new SQL-Server, same OS and SQL-Versions like the old one: Win2008R2-64, Sql 2008R2-64, same patchlevel.
Same xp_ndo_x64.dll, same startup flags.
I restored a sql backup of a NAV-5 DB from the old one on the new server.
For a couple auf days, everything worked fine.
Then we got a new Object-Range and i created a new NAV-License file in VOICE. And I'm pretty shure, I claimed the ISV insert right.
From the time I've uploaded the new license file on the new server, some of the developers - all without dbo or sysadmin rights -cant create new fields in tables, they got this SQL error message:
1088,"42000", ... Cannot find the object ... or you do not have permissions.
SQL:
ALTER TABLE "XXXX.dbo.YYY$zzzz ADD xxxx DECIMAL ....
I restored the old license file, but same Error.
Same user on the old server, no problem.
Upload new license file on old server, no problem.
The users rights on both servers are exacly the same. (Server Logins, DB users, roles)
The only difference, that can be seen, is in SQL management studio, Database properties, permissions, Effective user rights:
On the old server, it shows lots of ALTER rights, on the new one only CONNECT, DELETE, INSERT, SELECT and VIEW DB STATE.
What else may have influence on these effective rights?
Svensk.Tiger (Henning Möller)
PASS Multibank Solutions AG
(Kaum macht man was richtig, schon geht es. / Once you do it right, suddenly it works.)
PASS Multibank Solutions AG
(Kaum macht man was richtig, schon geht es. / Once you do it right, suddenly it works.)
0
Comments
To be more restrictive, you need ddladmin rights to alter the database definitions, like adding new fields.
http://mibuso.com/blogs/davidmachanick/