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?
0
Comments
2) Can you open the database from Enterprise management (Management Studio)?
MVP - Dynamics NAV
My BLOG
NAVERTICA a.s.
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?