SQL Server connection problem

jimmyf
jimmyf Member Posts: 104
edited 2009-04-08 in SQL General
I have a Nav4 sp3 sql server database which all of a sudden does not allow navision sql clients to access it. When trying to connect (using database authentication) the following error is shown. The SQL Server cannot be found.
This has been working fine for months.
Any ideas? The server can be successfully pinged it is just Nav that cannot access the server!

Comments

  • NL4385
    NL4385 Member Posts: 12
    Which version of SQL Server do you use? We had a simmilar problem with SQL Server 2008. The solution was to enable TCP/IP.
  • jimmyf
    jimmyf Member Posts: 104
    We are using SQL 2005
  • idiot
    idiot Member Posts: 651
    Check that your SQL Server 2005 is running & look for any errors in the Event Log
    NAV - Norton Anti Virus

    ERP Consultant (not just Navision) & Navision challenger
  • kriki
    kriki Member, Moderator Posts: 9,121
    Did you try using the TCP/IP address in the server name instead of the name. It could be that there is a problem resolving the name.

    [Topic moved from 'NAV/Navision' forum to 'SQL General' forum]
    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!

Categories