Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.7K Microsoft Dynamics NAV
- 18.7K 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
- 326 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 994 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.6K General
- 1.1K General Chat
- 1.6K Website
- 79 Testing
- 1.2K Download section
- 23 How Tos section
- 260 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
User ID and Password invalid when try to open a database
rfigueiredo
Member Posts: 8
Hi guys
i have
Windows Vista SP1
SQL Server 2008 Standard
Dynanics Nav 5.0 SP1
and i have the following issue:
"User ID and password are invalid" -> with Windows Authentication and SQL Authentication ( user sa)
First of all gives me the error :
The extended stored procedure xp_ndo_enumusersids in the library file xp_ndo.dll, is not available on the XXXXX server. Until this procedure and library have been added, it will not be possible to connect to this server from Microsoft Dynamics NAV with Windows Authentication, but you will still be able to connect with Database Server Authentication. You can read more about adding this extended stored procedure in the help pages on the product CD. Follow the hyperlink to the readme.txt file on the Servers page under the Documentation section of SQL Server.
With the help of this http://dynamicsuser.net/blogs/navdev/archive/2008/11/05/basic-sql-creating-extended-stored-procedure-xp-ndo-dll.aspx i solve this issue
but now neither the sa user or the windows user are able to open the database.
On the SQL i make the both db_owners.
Can you help me figure it what is wrong?
Thanks in advance.
Best Regards,
Rui Figueiredo
i have
Windows Vista SP1
SQL Server 2008 Standard
Dynanics Nav 5.0 SP1
and i have the following issue:
"User ID and password are invalid" -> with Windows Authentication and SQL Authentication ( user sa)
First of all gives me the error :
The extended stored procedure xp_ndo_enumusersids in the library file xp_ndo.dll, is not available on the XXXXX server. Until this procedure and library have been added, it will not be possible to connect to this server from Microsoft Dynamics NAV with Windows Authentication, but you will still be able to connect with Database Server Authentication. You can read more about adding this extended stored procedure in the help pages on the product CD. Follow the hyperlink to the readme.txt file on the Servers page under the Documentation section of SQL Server.
With the help of this http://dynamicsuser.net/blogs/navdev/archive/2008/11/05/basic-sql-creating-extended-stored-procedure-xp-ndo-dll.aspx i solve this issue
but now neither the sa user or the windows user are able to open the database.
On the SQL i make the both db_owners.
Can you help me figure it what is wrong?
Thanks in advance.
Best Regards,
Rui Figueiredo
0
Comments
you should be able to login with sa login and setup the security.
Independent Consultant/Developer
blog: https://dynamicsuser.net/nav/b/ara3n
Do you mean:
Open the SQL MAnagement Studio
Enter the on my database and find the tables that you mention?
The exact table name is User and Windows Login
Independent Consultant/Developer
blog: https://dynamicsuser.net/nav/b/ara3n
it works thanks!
I delete on my database all the users that were on the tables Users and Windows Login, and know i can enter the sa user.
I read the instructions of the Dynamics Nav documentation and it seems that "Windows Authentication" does not work on Windows Vista, only on the Windows2000 and 2003 software.
RIS Plus, LLC
I read the document
Installation System Management Microsoft Business Solutions Navision SQL Server Option.
With the SQL Server Option for Navision, you can use Windows authentication to
connect to SQL Server. This is only possible when the server’s operating system is
Windows XP, Windows 2000 Server or Windows Server 2003.
Independent Consultant/Developer
blog: https://dynamicsuser.net/nav/b/ara3n