Unable to create new NAV db (sql server)

ajmalsherif

Hi

I would be grateful if someone could advise what i am doing wrong as i am trying to restore a db, but to do so i first need to create a db...

When i go File < DB < New i have 2 options either SQL Authentication or Windows. When i select SQL Authentication i get a message saying that 'The combination of user ID and password entered is invalid' - (this is a new install of NAV on the server which i didn't open previously).

When i select Windows authentication it allows me to start (though not finish) the process of creating a new DB but then i get a message:

"The extended store procedure xp_ndo enumusergroups inb the libraryfile xp_ndo.dll is not available on the ...server"

Earlier on I had a nessage about a Trace flag which i have added to the
SQL Server Start up parameter. I have also added the xp_ndo,dll file to the SQL Sever Binn (this was done by running the xp_ndo.exe file found in the NAV CD).


I am running SQL Express 2005 Management Studio which can connect to the server both as either SQL or Windows Authentictation.

Thanks in advance

kine

Try to register the extended stored procedures manually from the xp_ndo.dll as described in the readme.txt or in posts on this forum.

DenSter

Sounds like you started working on this without any guidance or getting any information. You'll need to do some reading

Look for a folder called 'Doc' on your product CD, this contains all the installation manuals. Find the one called 'w1w1isql.pdf', which is the one for SQL Server. Study this material, it will tell you everything you need to know to install a NAV database on SQL Server, including the trace flag, the extended stored procedures, which permissions you need to have to create a new database.

It would also not hurt to get a 'step by step' book about SQL Server administration.

ajmalsherif

Thanks to you both for your suggestions. Kamil - i got it to work after running stored procedures manually (eventhough i thought i had read the NAV automatically does this the first time it runs)

kine

ajmalsherif wrote:

Thanks to you both for your suggestions. Kamil - i got it to work after running stored procedures manually (eventhough i thought i had read the NAV automatically does this the first time it runs)

Yes, it should, but sometime it is not working or in many cases when NAV is connected first time, the .dll is not copied yet...

bbrown

Also on 64 bit it must be done manually.