BQE Knowledgebase



Microsoft SQL Server error 18470

Problem: When trying to connect to an existing database in ArchiOffice/EngineerOffice, the login credentials fail though correct information is entered. User gets the Microsoft SQL Server Error: 18470.

Cause: This may happen if the SA (System Administrator) user account is disabled in SQL Server. It can be verified by trying to log in to SQL Server Management Studio (SSMS) using the SA account.

Solution:

1. Go to SSMS > Server > Security > Logins.

ssms.png

2. Right-click and select Properties.
3. Log in using Windows Authentication to be able to make this change.
4. In the Login Properties screen, select Status on the left side.

login properties.png

5. Change the Login option from Disabled to Enabled. Click OK. 



Related Articles

Attachments

No attachments were found.

Visitor Comments

Article Details

Last Updated
9th of October, 2013

Product
ArchiOffice, EngineerOffice

Would you like to...

Print this page  Print this page

Email this page  Email this page

Post a comment  Post a comment

 Subscribe me

Subscribe me  Add to favorites

Remove Highlighting Remove Highlighting

Edit this Article

Quick Edit

Export to PDF


User Opinions

100% thumbs up 0% thumbs down (1 vote)

How would you rate this answer?




Thank you for rating this answer.

Continue