Posts: 10
Threads: 4
Joined: Mar 2015
Reputation:
0
Hello All,
Are there any instructions to move from a File based environment to an SQL based environment, I have tried it but have lost all the connection credentials. The credentials and connection are there, but no credentials on the connections.
Thanks,
Bill
Posts: 11,127
Threads: 100
Joined: Aug 2006
Reputation:
202
Which version are you using? And what did you try? Export all, create a new database environment, import all - then it should work for the logged on user...
Regards/Gruss
Oliver
Posts: 10
Threads: 4
Joined: Mar 2015
Reputation:
0
Version is 2017, 10.1.5713.0
I did the steps that you described.
Posts: 678
Threads: 34
Joined: Aug 2006
Reputation:
17
Hi Bill,
I think I know the effect. That was indeed a problem we fixed in ASG-RD2018 ! So the best would be to upgrade to the latest version to receive that update. However the credentials should be visible but they are not assigned. So you have to reassign them then the connect should work again like before.
Best regards,
Michael
best regards,
Michael -- michael.scholz@asg.com --
Posts: 10
Threads: 4
Joined: Mar 2015
Reputation:
0
Yes, upgraded to 2018 and the import worked
Posts: 678
Threads: 34
Joined: Aug 2006
Reputation:
17
Thanks for your quick and positive feedback :-)
best regards,
Michael -- michael.scholz@asg.com --
Posts: 10
Threads: 4
Joined: Mar 2015
Reputation:
0
Now that I have moved from File to SQL, how can I share that SQL file between a couple of my machines, currently it is using windows account integrated authentication with my local machine, I don't use a domain, all of my machine are connect to my Azure Active Directory.
What do I need to do to share the SQL between my other machines?
Posts: 678
Threads: 34
Joined: Aug 2006
Reputation:
17
Hi
the other machines simply need to setup a database environment with the same entry as yours and need an account that has access to the Database. If you right-click on the Azure environment entry in the Environment Manager and choose "copy" then you have the connection-information for the database. Copy that to the other machines and use it as "connection-string". But you have to make sure they use valid credentials that are allowed on that azure DB.
Hope that helps,
best regards,
Michael
best regards,
Michael -- michael.scholz@asg.com --