User ID and Password invalid when try to open a database

rfigueiredo

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

ara3n

from SQL SMS run table Database User and windows users. delete all the records,
you should be able to login with sa login and setup the security.

rfigueiredo

Where is the table databaseUser and Windows users?

Do you mean:


Open the SQL MAnagement Studio
Enter the on my database and find the tables that you mention?

ara3n

Yes open SQL management studio.

The exact table name is User and Windows Login

rfigueiredo

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.

DenSter

rfigueiredo wrote:

I read the instructions of the Dynamics Nav documentation and it seems that "Windows Authentication" does not work on Windows Vista

That is not true, Windows Authentication works just fine on Vista. I would like to know where you got this "nav documentation".

rfigueiredo

It works on my Vista too.

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.

ara3n

edit