April 16, 2014 at 1:21 am
Hi,
When i tried to use my database it is saying as
cannot open database requested in login login fails
when i login without database name it alows me to login and when i issue the
use mydb_name
go
Could not locate entry in sysdatabases for database 'mydb_name'. No entry
found with that name. Make sure that the name is entered correctly.
when i see in sysobjects in osql mydatabase is not listed.
where as in query analysier it is listed 🙁 🙁
how to resolve this ?
April 16, 2014 at 3:25 am
Looks like permission issue. Do you have permission to access this database?
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
April 17, 2014 at 1:37 am
Yes i am accessing the database via Enterprise manager and Query analysier.
April 17, 2014 at 2:50 am
How are you connecting to Enterprise Manager and Query Analyzer? Please will you post the command you use to invoke OSQL?
John
April 17, 2014 at 2:52 am
If you can connect without specifying the dbname what result do get from the following query:
SELECT name FROM sysdatabases ORDER BY name;
GO
Joie Andrew
"Since 1982"
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply