Login error open Sql Database

Posted on 2007-08-09
Medium Priority
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
  • 3
  • 2
LVL 11

Expert Comment

ID: 19663740
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

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

Accepted Solution

Swindle earned 1050 total points
ID: 19664056
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.
Get your Conversational Ransomware Defense e‑book

This e-book gives you an insight into the ransomware threat and reviews the fundamentals of top-notch ransomware preparedness and recovery. To help you protect yourself and your organization. The initial infection may be inevitable, so the best protection is to be fully prepared.


Author Comment

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

Assisted Solution

rsp1322 earned 450 total points
ID: 19715958
What operating system are you using? I know I had this problem on Vista due to UAC.

Author Comment

ID: 19728941
i using xp pro

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
This video shows how to quickly and easily deploy an email signature for all users in Office 365 and prevent it from being added to replies and forwards. (the resulting signature is applied on the server level in Exchange Online) The email signat…
Loops Section Overview

862 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