PDA

View Full Version : unable to connect to SQL server using SQL Query Analyzer


imported_Bruce
06-10-2003, 03:02 PM
Try to use SQL query analyzer received following error message

Server: Msg 229, Level 14, State 5
[Microsoft][ODBC SQL Server Driver][SQL Server]SELECT permission denied on object 'spt_values', database 'master'.
owner 'dbo'

same error message is displayed in SQL Server Enterprise Manager.

Cannot access any user database.
Any Solution ? Help will be appreciated
Thanx

gish
06-10-2003, 04:19 PM
do you as a user defined in the database security settings have sufficient rights to this DB/Tables?


make sure Insert, Select, Update or Delete is allowed for you.