Please start any new threads on our new
site at
https://forums.sqlteam.com
. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Hi, i just installed SQL 2005, and to get started im trying to follow the reporting service tutorial the Creating a Basic Report'whehave to do is n im at lesson 3 i have to 'setting up connection information' i have to create a new dataset, called adventure works when im trying to add it i get the following error: 'a connection cannot be made to the database set and test the connection suesttring'additional information: Cannot open database 'Adventureworks'requested by the login. The login failed. Login failed for user 'SRVDBTEST\Administrator'. (microsoft SQL Server, Error: 4060)how can i solve this problem?Thx in advance!
my server instance is mixed mode, i tried to give my sa account all possible rights by using the sql server management studio but when i check logins i see the users and their is a red arrow @ 'sa'account and when im trying to change anything it says 'create failed for user 'sa'. (an exception occured while executing a transact-SQL statement or batch (microsoft.sqlserver.connectioninfo) -> Cannot use the special principal 'sa'. (Microsoft SQL Server, Error: 15405
