HCBBS Forum (English)
Submit Chemical Projects / Find Solutions
Amplify Your Requirements on a Broader Chemical Platform *Engineering · Technology · Equipment · Solutions*
Submit Request

Database cannot be connected

2018-04-30View Original

Thread Content

I searched online for solutions to the problem that the Aspen database could not be connected, and used SQL Management Studio to restore the three databases. However, when I did the register step in Database Manager, it showed that there was no corresponding database in the server. :'(I really followed the method step by step. Why does this happen? Netizens please give me some pointers. (My aspen is version 8.4, and sql is version 2012)
Reply #22018-04-30
What I use is the following method: First open sql server management studio, a connection window will appear, log in with windows identity first. After entering the database, the location indicated by the arrow. Using your mouse, click the right mouse button. Go into server properties. Select Security in the properties interface. Select SQL Server and Windows Authentication Mode on the right. Just click OK. Open security on the SQL Server main page, and you will see the login name on the right. Double-click sa within the login name. Enter the properties of sa. Reset sa's password in the sa attribute. After setting the password, click OK. At this time, minimize the SQL Server window. The point is: Remember the sa password and open sql management studio, select sql identity, click Connect, you can see all the databases on this machine. Right-click on the database label, select restore database, ignore the target database, directly select the source device, point the location to C:/ProgramData/AspenTech/Aped, fill in APV84 in the file name, and then confirm. The target database can then select APV84. Okay, let's restore it. The same goes for the other two FACTV84 and NISTV84. The location is the same as APV84. Just change it when filling in the file name. At this time, the database has been loaded correctly. 4 This step is mainly set in the DatabaseManager in aspen properties. Right-click register database, and a dialog box will appear. Server name fills in the database name, such as boss\sqlserver (the server name on your own machine) login name: sa password: The password set in the second step will appear. Three databases APV84, FACTV84, and NISTV84 will be loaded.

Submit a Project

**Looking for Chemical Technology, Equipment & Solutions?** No Registration Required Broader Platform Exposure | Global Chemical Service Provider Connections

Submit Request — Free Consultation

Disclaimer

This is an automated machine translation of the original thread. Some technical terms may have inaccuracies; the original text shall prevail. Click "View Original" at the top right to access the source page, which supports IP-based automatic real-time language translation. Please watch out for contact details and sales inducements to prevent fraud. All content and translations are for reference only, representing solely the poster's personal views. For enquiries, email service@hcbbs.com.