How can I use Navision to connect SQL SERVER 2000

kevin.7710
kevin.7710 Member Posts: 40
edited 2007-11-22 in SQL General
I want to use Navision to connect SQL server 2000, Now I use the Navision database. When I create database for SQL SERVER, I must use "Windows Authentication" to create database, I don't use "Database server Authentication" to Create database,Why?
When I use "Database server Authentication" to create database, I imput the user id i"sa"and password, the message tell me it cann't connect sql server.

Comments

  • sendoh
    sendoh Member Posts: 207
    what nav version are you using?
    Sendoh
    be smart before being a clever.
  • kevin.7710
    kevin.7710 Member Posts: 40
    Navision 4.0 SP2
  • kriki
    kriki Member, Moderator Posts: 9,121
    Probably because your SQL-server does not allow those connections. Check the properties of your SQL-server to allow for it (Server authentication => SQL Server and windows authentication mode).
    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!

  • kriki
    kriki Member, Moderator Posts: 9,121
    [Topic moved from Navision forum to SQL General forum]
    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!

Categories