10/15/2019 11:57 AM | |
Joined: 6/12/2012 Last visit: 2/8/2024 Posts: 165 Rating: (7) |
Hi! I do not know how, but the Desigo has changed te SQL server instance name for the one that you can see on the document. I have tried to run sqlcmd in command line, but it gives the error that you can see on the second picture. How can I change it back to (local)\GMS_HDB_EXPRESS? AttachmentSQL instance name change.docx (475 Downloads) |
Thanks, |
|
10/15/2019 2:08 PM | |
Joined: 6/12/2012 Last visit: 2/8/2024 Posts: 165 Rating: (7) |
The problem is on the computer name that is wrong. How can I change from DESKTOP_... to SVR-GTCAVAC? I tried to unlink the HDB, but the icon backgroung goes gray and does not unlink it.
AttachmentDesktop.zip (417 Downloads) |
Thanks, |
|
10/15/2019 6:55 PM | |
Joined: 11/8/2017 Last visit: 10/11/2024 Posts: 338 Rating: (190) |
Hi, The commands that are mentioned in the tool-tip pop up (sp_dropserver etc) - from memory these need to be run from within SQL Server Management Studio, rather than from the DOS prompt. You'll probably need to download the SSMS and install it (as it's not installed by default), have a look HERE. Also - see HERE for more info on the commands that are required. On your screen shot, what happens when you click the Fix button at the top right hand corner? Where are you trying to Unlink the HDB? Are you trying to click the tick-box that's in the screen shot? Or are you going up a level to History Infrastructure, and clicking the Unlink button? Regards, |
This contribution was helpful to1 thankful Users |
10/15/2019 7:06 PM | |
Joined: 11/8/2017 Last visit: 10/11/2024 Posts: 338 Rating: (190) |
Hi, Bearing in mind the specific commands shown in your SMC screen shot. Example videos below showing the steps to take when using the SSMS. How to Rename SQL Server Instance Name Regards, |
This contribution was helpful to1 thankful Users |
Follow us on