Connection problem with SQL Server

vyanku
vyanku Member Posts: 791
edited 2007-11-20 in NAV/Navision Classic Client
I create two databases on SQL server.
1.is on SQL server default database directory and 2. is on another location.
When I am trying to connect that 2. database from client it shows error server not found.
But on server it can be accessable. 1. database is also accessable form any where .
My server name is correct user ,password is correct, nettype is default.
Why it shows me this error?

Comments

  • kine
    kine Member Posts: 12,562
    1) Check the permissions on the folder, where the 2. DB is stored. Is the account, under the SQL server is running able to access the folder and files?

    2) Can you open the database from Enterprise management (Management Studio)?
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
  • vyanku
    vyanku Member Posts: 791
    1) Check the permissions on the folder, where the 2. DB is stored. Is the account, under the SQL server is running able to access the folder and files?

    2) Can you open the database from Enterprise management (Management Studio)?

    Yes .folder containing 2.db is accessable.
    Yes I can open the database form management studio.But from management studio also it shows many connection error meny times.
    Then I have to refresh the server again and again to get connected with that 2.db

    My SQL server also disconnected many times automatically.
    Is this problem of bad installation of SQL Server?o r database problem?

Categories