Link to home
Start Free TrialLog in
Avatar of rp
rpFlag for Portugal

asked on

Login error open Sql Database

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.
Avatar of Swindle
Swindle
Flag of United States of America image

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

ASKER

the user rui as administrator permissions. where can i change the database permissions in the sqlservermanagement
ASKER CERTIFIED SOLUTION
Avatar of Swindle
Swindle
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of rp

ASKER

i can´t acccess to database. But why a older database created in the sqlservermanagement works fine?
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of rp

ASKER

i using xp pro