Sql report server configuration for form authentication

  • Hi

    I am trying to deploy form authentication in reporting service. I have followed the steps given in http://www.codeproject.com/Articles/675943/SSRS-Forms-Authentication . I am stuck at a point of establishing connection to report server. And there are things I am not sure with report server. If I use normal window authentication I can access to report server via my report manager Url. And I can access from SSMS too. But, When I try to use form authentication( followed above mentioned article), I am having issue with connection to sql report server. I am getting "An error occurred while attempting to add the account. A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 25 - Connection string is not valid)" whenever I try to register a new user. At the same time, I am not allowed to access report server from SSMS too. I really don't understand this part. Why connection is unsuccessful? I am missing some part. But I don't know where exactly.

    I have tried a lot of methods but still no luck. Before that ,when I can log in to my usual report server, I did create user role to gain access to report server. But I couldn't use those when I changed to form authentication (of course I can't log in because it is now in different authentication).

    I searched all over the internet, but couldn't find the proper documentation for me to refer. I am totally new to this server configuration thing and have really no idea how to trace the error.

    Anyone have clearer insight on this matter, please educate me.

    Thank you.

Viewing 0 posts

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