Can not Access SQL SERVER 2005(64-Bit) from Windows Vista(32-Bit)

• 08-06-2008 9:16 PM

  Nilesh Mandani Joined on 08-06-2008 Posts 2

  Can not Access SQL SERVER 2005(64-Bit) from Windows Vista(32-Bit) Reply Contact Hi All, 1) Installed Windows Server 2008 2) Installed & Update Windows Server 2008 with latest hot fixes 3) Install SQL SERVER 2005 ( 64-bit ) Now, Client with Windows Vista ( 32-bit ) couldn't get access to SQL SERVER 2005. License file is not having correct format ( Resolved by giving the license ). After giving the correct license file. It shows the database. By selecting the database, it throws error of cannot access the SQL SERVER 2005.

  Tags: Dynamics NAV, Microsoft Nav

• 08-27-2008 12:55 AM

  In reply to

  Larsro [MS] Joined on 08-27-2008 Posts 1

  Re: Can not Access SQL SERVER 2005(64-Bit) from Windows Vista(32-Bit) Reply Contact Hi Nilesh, NAV needs a stored procedure to function correctly, so you might want to check if you installed the 32-bit or the 64-bit stored procedure. You can find the stored procedure in SQL Server Managment studio, by going to Databases>System Databases>Programmability>Ext. Stored Procedures. There you should have two procedures both starting with xp_ndo_enum, right click one of them and select properties. Make sure that it is pointing to the 64-bit version of the dll (should be named something like xp_ndo_x64.dll) /Lars

• 11-12-2008 3:44 AM

  In reply to

  Pascal van der Heiden Joined on 11-11-2008 Posts 3

  Re: Can not Access SQL SERVER 2005(64-Bit) from Windows Vista(32-Bit) Reply Contact Hi Nilesh, Not accessing the database hasn't anything to do with the fact that you have a 32-bit vista and 64-bit SQL server. This issue has more to do with your security privileges on the SQL server. The fact that you can see the databases, tells me you have logon rights on the server, and not accessing means the SQL user isn't mapped with your NAV database. Check your rights in SQL Server, tab mapping. Give yourself db_owner right on the NAV database and you will probably be able to access. After this you might get the message that SQL server is missing 2 stored procedures, than follow the reply of Lars. I hope this puts you in the right direction. Pascal

• 11-13-2008 10:13 PM

  In reply to

  Nilesh Mandani Joined on 08-06-2008 Posts 2	Re: Re: Can not Access SQL SERVER 2005(64-Bit) from Windows Vista(32-Bit) Reply Contact Yes, Thank you for your valuable comments. After giving db_owner it resolve this issue. Regards, Nilesh Mandani