SQL Server 2008 & Navision 2009

myanilkumar

Hi All,

We had installed a SQL Server 2008 in Clustered Mode. We had added two nodes. I am trying to install NAV 2009 Classic Client with SQL Server option. I am getting this error.

Could not connect to the SQL database. (-2147024703 master ).

I am having administrator role (sysadmin) in SQL Server. Please help me on this.

Regards,
Anil

kriki

You don't give a lot of info.

Some questions:
Did you already install the client? Or did you receive the error while installing?
Where are you installing the client? On the server or another PC?

Some things to try:
Check if you enabled TCP/IP on the sql server.
Check if you selected TCP/IP on the client to connect to the server.
Do a ping from the client to the server to see if you can reach it.

myanilkumar

Hi,

Thanks for the reply. I am trying to install client on the server it self. This error i am getting when i am trying to install SQL Server option i.e. i need to add xp_ndo.dll in NAV 2009.

Please let me know on this.

Regards,
Anil

kriki

Installing the client should not create problems.

Before using a Windows login to connect, try first a DB-login to see if you can get there. If you can, then you can try the next step (=Windows logins).
For Windows logins, you need the xp_ndo.dll. You need to pay attention which one to take (there is a version for 32bit and 1 for 64bit). You can find them on the install-DVD.

myanilkumar

Hi,

I am getting this error when i am trying to install xp_ndo.dll. I am using exe under SQL database folder to install. That time i am getting this error. So, the exe will pick up the respective dll whether 32-bit or 64-bit. Database logins no issues.

The SQL is installed under Clustered mode in windows 2008 R2 OS.

Regards,
Anil

kriki

Take the files you need, and put them manually in the correct place.
This will help you to install them correctly : http://www.mibuso.com/forum/viewtopic.php?f=33&t=26076&hilit=+sp_addextendedproc+xp_ndo_enumusergroups+

myanilkumar

Hi,

Thanks for the reply. If i copy Manually Do i need to register the xp_ndo.dll?

Because at present I can't register.

Please let me know.

Regards,
Anil

kriki

Yes, you need to register them manually in SQL. The TSQL code you need is in the topic.