rp
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.
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.
Is it possible that the user RUI has permission to access the server, but does not have adequate permissions on the database itself?
ASKER
the user rui as administrator permissions. where can i change the database permissions in the sqlservermanagement
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
i can´t acccess to database. But why a older database created in the sqlservermanagement works fine?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
i using xp pro