sqlhelp Posted February 6, 2019 Report Posted February 6, 2019 Hello.. SSRS 2008 R2 version Data source connection string ni edit cheyagletama through gui? We are migrating from one db server to other, one of the data source is hard coded with server name adi change cheyali. Help! Quote
Katti_Ramdas Posted February 6, 2019 Report Posted February 6, 2019 new datasource add cheyadame.. it will not allow to edit it. delete the current one and add new Quote
Quickgun_murugan Posted February 6, 2019 Report Posted February 6, 2019 7 minutes ago, sqlhelp said: Hello.. SSRS 2008 R2 version Data source connection string ni edit cheyagletama through gui? We are migrating from one db server to other, one of the data source is hard coded with server name adi change cheyali. Help! Yes man change cheyyochu connection string lo ... go to data source properties and change there Quote
Spartan Posted February 6, 2019 Report Posted February 6, 2019 To modify a shared data source in the web portal In the web portal, navigate to the shared data source. Select the ellipsis (...) in the upper-right corner of the shared data source > Manage. The Properties page opens. Modify the data source, and then click Apply. Quote
sqlhelp Posted February 6, 2019 Author Report Posted February 6, 2019 11 hours ago, Katti_Ramdas said: new datasource add cheyadame.. it will not allow to edit it. delete the current one and add new Ala chesthe existing reports ani data source marchali kada? Quote
sqlhelp Posted February 6, 2019 Author Report Posted February 6, 2019 11 hours ago, Quickgun_murugan said: Yes man change cheyyochu connection string lo ... go to data source properties and change there This is 2008 R2 version so naku data source properties ekada access cheyalo telitle boss Quote
sqlhelp Posted February 6, 2019 Author Report Posted February 6, 2019 11 hours ago, Spartan said: To modify a shared data source in the web portal In the web portal, navigate to the shared data source. Select the ellipsis (...) in the upper-right corner of the shared data source > Manage. The Properties page opens. Modify the data source, and then click Apply. Check chesa but web portal ante ekada access cheyali? I am new in reporting Quote
Katti_Ramdas Posted February 6, 2019 Report Posted February 6, 2019 14 minutes ago, sqlhelp said: Check chesa but web portal ante ekada access cheyali? I am new in reporting i misread your first post.. but spartan cheppanatlu cheyachu.. daniki reporting server ni web url through access chestam where we usually upload our rdl files to.. akkada datasource option kanipitadi.. try getting the web url first Quote
Quickgun_murugan Posted February 6, 2019 Report Posted February 6, 2019 29 minutes ago, sqlhelp said: This is 2008 R2 version so naku data source properties ekada access cheyalo telitle boss dude normally http://yourservername/Reports is the url to access report manager... andulo report name side ki chinna black triangle untadi dani meeda click cheste you will have data sources/datasets/security/Snapshots options.. click on the datasource and try to change the data source... if required provide the username n password credentials and check save credentials option Quote
tvda Posted February 7, 2019 Report Posted February 7, 2019 Sql/ssis/ssra developer positions emana unte chepandi bro Quote
sqlhelp Posted February 7, 2019 Author Report Posted February 7, 2019 20 hours ago, Katti_Ramdas said: i misread your first post.. but spartan cheppanatlu cheyachu.. daniki reporting server ni web url through access chestam where we usually upload our rdl files to.. akkada datasource option kanipitadi.. try getting the web url first I am in web url now, inka vere emaina portal undi emo ani confuse aina. Ah steps lo mention chesinatu I don't see an ellipsis just Data Sources ni select chesthe xml version config file open aythundi and ah data source details motham unayi Quote
sqlhelp Posted February 7, 2019 Author Report Posted February 7, 2019 20 hours ago, Quickgun_murugan said: dude normally http://yourservername/Reports is the url to access report manager... andulo report name side ki chinna black triangle untadi dani meeda click cheste you will have data sources/datasets/security/Snapshots options.. click on the datasource and try to change the data source... if required provide the username n password credentials and check save credentials option Naku ee option regular reports ki undi but not for data source wonder if it is a permissions issue Quote
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.