web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Season of Giving Solutions is Here!
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / Can not Access SQL SER...
Microsoft Dynamics NAV (Archived)

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

(0) ShareShare
ReportReport
Posted on by Nilesh Mandani 295

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.

*This post is locked for comments

I have the same question (0)
  • Larsro Profile Picture
    Larsro on at

    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

     

  • Community Member Profile Picture
    Community Member on at

    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 

  • Nilesh Mandani Profile Picture
    Nilesh Mandani 295 on at

    Yes,

    Thank you for your valuable comments. After giving db_owner it resolve this issue.

    Regards,
    Nilesh Mandani

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Season of Giving Solutions is Here!

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics NAV (Archived)

#1
HoangNam Profile Picture

HoangNam 7

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans