error 4060 and th single user database
-
Hi all,
ive got a big problem with one of my databases.
essentially its a grades entry database - at some point in time this has become a single user database, im not sure how (and believe my IT team may have been messing around) but essentially what it means is that i cant see any of my views or tables in the database, yet in the printing application the tables do show...
i cant see them in enterprise manager but my team mate (another dba) can, but he cant access the data as he gets an error 4060..... how can i revert this back to a normal db and ensure my access rights remain?
im more of a programmer/designer and have yet to take my sql server admin training so any ideas would be greatly appreciated!!!
cheers
greg
-
hi
r u sure that ur database is really in sinlge user mode? maybe somebody has (accidently) changed the access rights due to which u cannot access the database.
if it is in single user mode u can change it back to multi user mode or restricted user which ever mode was earlier by using the ALTER database command or use the enterprise manager to change the properties (right click on the database ,select properties and take the options tab ).
make sure that nobody else is accessing the database otherwise u will not be able to connect.
Hope this is what u want
"Keep Trying"
"Keep Trying"
-
you winner!
managed to log in as admin (even though im db admin im not the admin login?!?!?!) and change the ettings...
all is good- could offer a reason why this has happened?
greg
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply