Upgrading to SQL Server 2005

MarkD33

Hi all:

We have a client who is upgrading to SQL 2005. Our SQL guru is in Hawaii on his honeymoon and the client is running into space issues on their server running SQL 2000. So, that leaves me, the somewhat pointy-haired boss type trying to do the migration.

The client uses Windows authentication so I ran into that annoying extended stored procedure error:

---

The extended stored procedure xp_ndo_enumusergroups in the library
file xp_ndo.dll, is not available on the SQL server.

The extended stored procedure has not been added and you will not be able to use Windows authentication to connect to SQL Server. You will still be able to connect to the server with Database Server Authentication.

---

So, I copied the xp_ndo.dll file to the BINN directory. I added the xp_ndo_enumusergroups stored proc to the Master DB, granted Public execute rights, rebooted the server, and then retarted the SQL Server Service just to be safe.

Now, I'm getting the following message when trying to access the app with Windows login.

---

Microsoft Business Solutions-Navision

---

The following SQL Server error(s) occurred:

17750,"42000",[Microsoft][ODBC SQL Server Driver][SQL Server]Could not load the DLL \Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\xp_ndo.dll, or one of the DLLs it references. Reason: 193(%1 is not a valid Win32 application.).

SQL:
INSERT INTO [#$ndo$groups] {CALL [master]..[xp_ndo_enumusergroups](?,?)}

---

Any suggestions would be greatly appreciated.

Regards,
Mark

MarkD33

I searched the forum for this secondary error that I'm receiving but couldn't find anything about it. If I've posted a dupliate topic, please accept my apologies.

Mark

MarkD33

Client IT manager just came in and told that the server is running a 64-bit OS. That would have been good information to know earlier.

](*,)

Switched to the xp_ndo_x64.dll and all is good in the world.