What is my report manager username/password? How to find it out?

sql-server authentication reporting-services reportmanager
Pritesh picture Pritesh · Jun 9, 2012 · Viewed 8.1k times · Source

I have SQL Server 2008 with BIDS, I have installed sql server myself and i am administrator of machine. Now I am able to make reports using BIDS, I am also able to login(windows authentication) to report server using SSMS, but when i try to access report manager URL it asks me for Username/passowrd. I am not sure what to give there as till now from SSMS i could manage with windows authentication for database engine.

Answer

Stacia picture Stacia · Jun 10, 2012

SSRS always uses Windows authentication so your user name and password that you're seeing is your Windows login. There is no separate account just for Report Manager. If you're seeing a prompt, you might have UAC enabled and it's prompting you because of that. Or your browser is not enabled for Windows integrated security. You can add the Report Manager URL to trusted sites or Intranet sites if you're using IE.

Related questions

How to add Active Directory user group as login in SQL Server

I have a .net application which is connecting to the SQL Server using windows authentication. We cannot use SQL Server authentication in the application. We have lot of Active Directory users there for our project. So we have to create …

Read More
SQL Server 2008 can't login with newly created user

I'm using using Windows Vista and I'm having trouble logging in with a newly created user. I open SQL Server Management Studio. I create a new Login by right-clicking on Security->Logins. Check: SQL Server Authentication Login name: tester …

Read More
Database + Windows Authentication + Username/Password?

I have always thought that in order to connect to SQL server using windows authentication with explicitly specified credentials, you must LogonUser, Impersonate, then connect. It seems to me that this link suggests that it's possible to connect to SQL …

Read More