November 27, 2013 at 10:25 am
Hello, hope someone can help or point me in the right direction. I'm very new with SQL server.
Trying to setup a SQL Reporting services server, no sharepoint involved, we have:
1. sql 2008 R2 server with database engine installed, in Domain A, running on a custom port
2. sql 2012 server with just reporting services on it, in Domain B
I installed SSRS feature, I have the reporting services configuration wizard>Database>Change Database>Database server, but unable to connect to the existing DB, getting error "Login Failed for user".
What type of user do I need to configure and with what permissions, on the DB server if I select "Authentication Type: SQL Server Account"? Does that mean just a SQL User, or would an Domain user work?
From what I can tell the versions of SQL server and the 2 AD Domains doesn't matter.
Thank you,
Fred
November 27, 2013 at 4:02 pm
I figured out what works (for me at least)
Since these are trusted AD domains I used an account in the SSRS server's domain, added that account as an admin to the SSRS server and ran the config setup wizard as that user, and added the user as sysadmin on the database server.
Now on to the next problems 🙂
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply