Login error open Sql Database

Posted on 2007-08-09
Last Modified: 2013-11-26
I am confused. When i try to access a database in sqlserver express 2005 in my pc appears the error:
Cannot open database "test" requested by the login. The login failed.
Login failed for user 'RUI\Rui'.
The database was created in the visualstudio 2005. After, i tried attach the database with sqlservermanagement, but the error continues.
But if i try to access to a database created with sqlservermanagement, no problem, no error ocurs.
Question by:rflorencio
    LVL 11

    Expert Comment

    Is it possible that the user RUI has permission to access the server, but does not have adequate permissions on the database itself?

    Author Comment

    the user rui as administrator permissions. where can i change the database permissions in the sqlservermanagement
    LVL 11

    Accepted Solution

    That's odd, if it has administrator permissions to the server, it shouldn't have a problem with the database level permissions.  Is the database online?  Right click on the database in management studio and see if you have the option for "bring online" available.  If that's not available then you might try detaching it and reattaching it again and see if it does the same thing.

    Author Comment

    i can´t acccess to database. But why a older database created in the sqlservermanagement works fine?

    Assisted Solution

    What operating system are you using? I know I had this problem on Vista due to UAC.

    Author Comment

    i using xp pro

    Featured Post

    Better Security Awareness With Threat Intelligence

    See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

    Join & Write a Comment

    Data architecture is an important aspect in Software as a Service (SaaS) delivery model. This article is a study on the database of a single-tenant application that could be extended to support multiple tenants. The application is web-based develope…
    A long time ago (May 2011), I have written an article showing you how to create a DLL using Visual Studio 2005 to be hosted in SQL Server 2005. That was valid at that time and it is still valid if you are still using these versions. You can still re…
    how to add IIS SMTP to handle application/Scanner relays into office 365.
    Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.

    745 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    16 Experts available now in Live!

    Get 1:1 Help Now