Forum Discussion
Old sql db is dropped. How to repoint the current data source to new db on the same sql server
Hi. Yes you need to add a new data source and if you want you can delete the old one. Regarding the "username" it depends on the authentication. For example the "basic" it's a sql server user like user= "sa" , but you can pick windows user or active directoy in case you have one of those connections.
After creating the new source just open a schedule refresh of one of the datasets connected and check gateway settings. The connection would be found automatically if you have input the data exactly as the Desktop dataset was published. If not, you need to map it in that menu.
You might need to schedule the refresh time for all the reports again. So you can check it there.I hope that helps,
Super UserHi. Yes you need to add a new data source and if you want you can delete the old one. Regarding the "username" it depends on the authentication. For example the "basic" it's a sql server user like user= "sa" , but you can pick windows user or active directoy in case you have one of those connections.
After creating the new source just open a schedule refresh of one of the datasets connected and check gateway settings. The connection would be found automatically if you have input the data exactly as the Desktop dataset was published. If not, you need to map it in that menu.
You might need to schedule the refresh time for all the reports again. So you can check it there.
I hope that helps,
hi ibarrau, your reply is so helpful. This is exactly what I am looking for. Many thanks