Results 1 to 2 of 2

Thread: reset config in SQLE 2005

  1. Jan 13th, 2007, 12:58 AM #1
    lorenzonunez
    lorenzonunez is offline

    Thread Starter
    Member
    Join Date
    Sep 2006
    Posts
    34

    reset config in SQLE 2005

    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.
    Reply With Quote Reply With Quote
  2. Jan 13th, 2007, 08:42 AM #2
    szlamany
    szlamany is offline
    MS SQL Powerposter szlamany's Avatar
    Join Date
    Mar 2004
    Location
    Connecticut
    Posts
    18,263

    Re: reset config in SQLE 2005

    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.

    *** Read the sticky in the DB forum about how to get your question answered quickly!! ***

    Please remember to rate posts! Rate any post you find helpful - even in old threads! Use the link to the left - "Rate this Post".

    Some Informative Links:     [ SQL Rules to Live By ] [ Reserved SQL keywords ] [ When to use INDEX HINTS! ] [ Passing Multi-item Parameters to STORED PROCEDURES ]
    [ Solution to non-domain Windows Authentication ] [ Crazy things we do to shrink log files ] [ SQL 2005 Features ] [ Loading Pictures from DB ]

    MS MVP 2006, 2007, 2008
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width