Connection problem with SQL Server

vyankuvyanku Member Posts: 791
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

  • kinekine 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.
  • vyankuvyanku 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?
Sign In or Register to comment.