Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.7K Microsoft Dynamics NAV
- 18.4K 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
- 317 Dynamics CRM
- 110 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 993 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
SQL Server Collation Problem
prassl
Member Posts: 24
Good morning everybody...
I am in trouble with my Navision SQL Server Installation, and I m really curious if someone of you knows the cause for that specific error...
Ok, these things in advance, I m using a SQL Server for hosting my database, Standard Edition, on a NT 5.2 SP3 Operating System, the client I m using is a NAV 4.0 SP 1...
The SQL Server sorting option is set to : Latin1_General_CI_AS..
However, I ll include a few screenshots to maybe give you a better idea of what causes the error (Assume that the settings, DB Connection, DB name and user authentication are correct, just had to blacken it out...)
On a standard DB, one that s been automatically generated during installation, the properties show the following sorting option:
http://www.e-prassl.at/manu/images/SQL_Server_Enterprise_Manager_TestDB_Properties.JPG
On my own DB, though the settings have been set also, the system doesn t save them properly, resulting in this:
http://www.e-prassl.at/manu/images/SQL_Server_Enterprise_Manager_DB_Properties.JPG
With that problem, the SQL Server returns the following error message on Navision Connect:
http://www.e-prassl.at/manu/images/Nav.Starting_Error.jpg
German though, the error message says that "The collation "?" is not supported by MBS Navision"
Restoring a backup didn t help, nor creating a new DB and importing data + objects...
Question now, please, how to solve this ?
Any help would be greatly appreciated
many thanks in advance
cheers,
PM
I am in trouble with my Navision SQL Server Installation, and I m really curious if someone of you knows the cause for that specific error...
Ok, these things in advance, I m using a SQL Server for hosting my database, Standard Edition, on a NT 5.2 SP3 Operating System, the client I m using is a NAV 4.0 SP 1...
The SQL Server sorting option is set to : Latin1_General_CI_AS..
However, I ll include a few screenshots to maybe give you a better idea of what causes the error (Assume that the settings, DB Connection, DB name and user authentication are correct, just had to blacken it out...)
On a standard DB, one that s been automatically generated during installation, the properties show the following sorting option:
http://www.e-prassl.at/manu/images/SQL_Server_Enterprise_Manager_TestDB_Properties.JPG
On my own DB, though the settings have been set also, the system doesn t save them properly, resulting in this:
http://www.e-prassl.at/manu/images/SQL_Server_Enterprise_Manager_DB_Properties.JPG
With that problem, the SQL Server returns the following error message on Navision Connect:
http://www.e-prassl.at/manu/images/Nav.Starting_Error.jpg
German though, the error message says that "The collation "?" is not supported by MBS Navision"
Restoring a backup didn t help, nor creating a new DB and importing data + objects...
Question now, please, how to solve this ?
Any help would be greatly appreciated
many thanks in advance
cheers,
PM
... I am not a programmer, I just write code.
0
Comments
if the enterprise manager on the sql server is being executed, one can connect, if not, one cannot...
help, please ](*,)