May 11, 2012 at 4:11 pm
I want to add a new database to an existing sql server 2008 r2 instance. I then want to write report builder 3.0 reports to access the database by using a shared datasource.
My problem is I setup the database using ssis 2008 r2 manager and let the database be created with all the defaults. Now when I write a report builder 3.0, the data source does not know who I am. The database only knows me as the dbo. It will not let me add and/or change any user roles.
Thus can you tell me how to setup a new database with the appropriate persmissions so a report builder 3.0 report will know who I am?
May 11, 2012 at 4:15 pm
Wendy,
You paint a very confusing picture.
You created a database. Defaults of not I doubt you did anything wrong there.
I am guessing you created it as a user with sysadmin server role.
If you are connecting to the server using integrated or trusted security you have access.
I'm guessing you are trying to come in as a SQL Login..
Can you tell us what error you are getting specifically?
CEWII
May 11, 2012 at 10:19 pm
My problem on the database that I setup, is when I take all the defaults, the new database thinks I am dbo. I can not assign myself to any other roles. I want to be able to assign myself to other roles so I can be the user of the report builder.
Thus so I can generate the report builder report, is there something I can do to make myself not the dbo on this database? If so, how would I solve this problem?
If not, do I need to create a new database? If so, how can I change the roles so I am not the dbo? Who should I assign the dbo role to if this is required?
I basically created the database using the following links:
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply