i have a problem whit SQL i think i erase something... how can i reset de server.... it gives me fail to open login database... for login administrators.or how can i fix this
thanks in advance.
Printable View
i have a problem whit SQL i think i erase something... how can i reset de server.... it gives me fail to open login database... for login administrators.or how can i fix this
thanks in advance.
Download the free management tool from the MSDN site.
http://msdn.microsoft.com/vstudio/express/sql/download/
This should tell you what DB's and settings are in place.
Usually if your "default" database is one that can be dropped then you might get that message - but changing your "default" database (with the MANAGEMENT STUDIO tool) will correct this.