Share via

SSRS 2019 Add New Data Source an error has occurred. something went wrong

John Abel 211 Reputation points
2020-09-16T21:11:37.69+00:00

Trying to add a new data source, and as soon as I click "new, data source" an error box pops up "an error has occurred. something went wrong. please try again" If I click OK under properties and name in the text box to add the datasource name it has highlighted in red, "required/ cannot contain any of the following characters: / @ $ & * + = < > : ' " , ? | . that is all it gives me. ran a profiler trace, its making the connection to the database fine no errors. looked at the time I attempt this. Not sure where to look/what to do next. I am running Windows server 2016 standard ed, using SSRS 2019, a sql server 2014 instance on the same machine. Have configured SSRS to use an ad account through reporting services configuration manager.

Any suggestions would be appreciated.

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
3,061 questions
Accepted answer
  1. John Abel 211 Reputation points
    2020-09-17T18:40:23.263+00:00

    We have multiple IP addresses assigned on this server. The web service url was set to "all assigned" in reporting services configuration manager, and this was apparently causing the issue as when we set up a dedicated IP address for this report server web service url and the portal, the error went away and I can now add a data source

    0 comments

2 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Joyzhao-MSFT 15,631 Reputation points
    2020-09-17T02:11:36.423+00:00

    Hi @John Abel ,
    You could try using Report Builder or VS studio to create the datasource and deploy it.
    Any other question is, what are the versions of your apps? Did you have both license for SQL2019 and SQL2014?
    The next debug step is , you could look at the SSRS trace log , to check at that time what happened.
    Regards,
    Joy

    If the answer is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

  2. Shoeb Shabibi 0 Reputation points
    2023-01-27T12:42:29.8866667+00:00

    This issue is resolved as mentioned in the article:

    Use the same procedure documented The strange case of Data source can’t be created with Reporting Services 2016 in Azure VM .

    The summary of instructions are

    1. Add a new DWORD value in the registry path HKEY_LOCAL_MACHINE\System\CurrentControlSet\Services\LanmanServer\Parameters

    Value name: DisableStrictNameChecking
    Data type: REG_DWORD
    Base: Decimal
    Value: 1

    1. Add a new Multi-String value in the registry path HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Lsa\MSV1_0

    Value name: BackConnectionHostNames
    Data type: Multi-String
    Value: Here you mention the fully qualified domain name like 'ssrs.it.internal'

    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.