Post reply

Check that I am a db Administrator in SQL Server 2005 + SSRS + Grant DB Access

  • October 19, 2007 at 9:05 am

    #126292

    I am working on an automation task to add reports to SharePoint. Each day I run into a number of issues with this project. Right now I want to check that I am a db Administrator on SQL Server 2005. Which db roles do I select to make sure my Windows login is given complete control. Right now I am unable to grant database access in reporting services from Central Administration; it returns an error "Unable to log on with the given username and password".

  • October 19, 2007 at 10:00 am

    #743692

    You are having a login issue, not a permissions issue. First you should determine if you need to send a name/pwd. If you are using SQL authentication, you would, but you do not use your network (Active Directory) name and password. You need this set up separately in SQL Server.

    You can use a trusted connection, which will use your network credentials, but you set that in the connection string.

    If you want to grant rights in a database to others, you can set the db_securityadmin role to your account.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply