We have a new server with SQL server 2016 installed. I would like to relocate our Software Factory to the new location. Simultaneously I would like to rename the database.
I was able to backup and restore the iam_ont and sf database to the new server. However, I cannot seem to rename the iam_ont database. When I do, the application wants me to login to the 'old name' iam_ont. All logins fail because the 'old name' database no longer exists.
Is there a way to do this?
Solved
Renaming / relocating the IAM_ont database
+12- Superhero
- 136 replies
Best answer by Anne Buit
Hi Hugo,
Can you run the following queries on the renamed IAM_ONT database:
This returns the server and database for the IAM itself. These should always return current_server and current_database.
If these are correct, you should be able to access IAM and update the server and database of the Software Factory application accordingly.
View originalCan you run the following queries on the renamed IAM_ONT database:
code:
select db_name
from gui_appl
where project_id = 'SQLSERVER_IAM'
select s.server_address
from server s
join gui_appl g
on g.server_id = s.server_id
where g.project_id = 'SQLSERVER_IAM'
This returns the server and database for the IAM itself. These should always return current_server and current_database.
If these are correct, you should be able to access IAM and update the server and database of the Software Factory application accordingly.
This topic has been closed for comments
+5Hi Hugo,
Can you run the following queries on the renamed IAM_ONT database:
This returns the server and database for the IAM itself. These should always return current_server and current_database.
If these are correct, you should be able to access IAM and update the server and database of the Software Factory application accordingly.
Can you run the following queries on the renamed IAM_ONT database:
code:
select db_name
from gui_appl
where project_id = 'SQLSERVER_IAM'
select s.server_address
from server s
join gui_appl g
on g.server_id = s.server_id
where g.project_id = 'SQLSERVER_IAM'
This returns the server and database for the IAM itself. These should always return current_server and current_database.
If these are correct, you should be able to access IAM and update the server and database of the Software Factory application accordingly.
1 person likes this
+12- Superhero
- 136 replies
Hi Anne,
It returns the name of the original database itself, not current_database. It does return current_server.
Can I simply change the name to current_database using the SSMS?
It returns the name of the original database itself, not current_database. It does return current_server.
Can I simply change the name to current_database using the SSMS?
+5Yes, feel free to do so. This should resolve the problem.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.