how to change url of an application in SQL Server DB

Question

Hi,

We have an application accessing SQL Server Database using some url, the user now requested to change the url

How can I do it from the backend in the database?

Regards

Answer 1

Can you clarify what you mean please? You say the application is accessing SQL via some url, by which I assume you mean the address for the SQL server in the connection string? And the user now wants to change that url?

If the url you're talking about is indeed the connection string, then that would be changed in the application not in SQL, and generally only if you were moving to a different server. If that's not what you mean by url then I'm not sure what you're referring to unless you're talking about the url used to access the application, and again that wouldn't be done in SQL.

Answer 2

Hi,

yes, i mean the url used to access the application.

I want to know which table have the details of urls?

Regards

Answer 3

In that case the application itself would most likely be controlled via IIS, and that then connects to SQL. In which case it's IIS that you need to adjust, SQL wouldn't have details of the url you'd use to access the application since SQL doesn't connect to the application at any point. You need to look in IIS and adjust the host headers for the application if you want it to run on a different url.