locked
have no rights in sql 2005 express RRS feed

  • Question

  • Hallo,

    I have detached a database and now when i start Management Studio express
    connect to database: <default> i get the error "A connection was successfully established with the server, but then an error occurred during the login process. (provider: shared memory Provider, error: 0 - No process is on the other end of the pipe.) (Microsoft SQL server, error: 223)

    When i connect to dabase master (it's works) but i haven't rights to add a user or change something.

    I can't change anything. How can i fix this?

    Thanks in advance!

    Petrov

    Tuesday, October 19, 2010 5:20 PM

Answers

  • Found the solution: http://blog.sqlauthority.com/2009/02/10/sql-server-start-sql-server-instance-in-single-user-mode/

    TCP/IP en name pipe was enabled

     

    THX for you time!!

    Petrov

    • Marked as answer by petrov_be Thursday, October 21, 2010 12:07 PM
    Thursday, October 21, 2010 12:07 PM

All replies