Database | Tech Stack Thinker

Challenge: One fine day I got a new machine. I was very happy and started installing all stus I needed to work. I installed MSSQL server and Management Studio. I tried to login but failed and got below alert message.

Cannot connect to xxxxxxxxxxxxxxx. Login failed. The login is from an untrusted domain and cannot be used with Windows authentication. (Microso SQL Server, Error: 18452)
It was then clear to me that every time we setup project or install soware needed to work we developers always face some minor and major issues, which is nothing but an opportunity to learn something 😊

Solution/Analysis: Here the hostname is showing 15 characters. When I checked the hostname in computer settings, it was 17 characters.

So, the actual hostname is of 17 characters but applications used to consider max 15 characters of hostname. I then realized there must be some standard limit for characters in hostname.

As per below link, max 15 characters for computer name is recommended.
https://support.microso.com/en-in/help/909264/naming-conventions-in-active-directory-forcomputers-domains-sites-and-ous

Since this was in my oicial system, I took help of my system admin to set 15 characters hostname. Then it started working. Login was successful.

Note: If you are still not able to login then reinstall SQL server and then try.
Hope this helps.

Good to read:

1.Open cmd with run as admin.
2.Run following command to take backup of database named analytics in mongodb.

mongodump –host XXX.XXX.XXX.XXX –port 27021 –db analytics –out E:\MongoDB\dumps

#mongodump –host <source host ip or hostname> –port <port at which mongodb is running> –db <database of which backup is required> –out <Directory path where backup would be taken>

Note this will create a folder named after your given database. It will create backup files consisting of bson and json files.

If face any issue like below.

‘mongodump’ is not recognized as an internal or external command, operable program or batch file.

Then please do provide following path or path where you have installed mongodb in Environment Variables. Provide bin folder path.

C:\Program Files\MongoDB\Server\3.0\bin

Or if you do not have time then Go to this folder from cmd as below.

cd C:\Program Files\MongoDB\Server\3.0\bin

Then run mongodump command.

3. Run following command to restore backup of database analytics.

mongorestore –host XXX.XXX.XXX.XXX –port 27021 –db analytics_new_db E:\MongoDB\dumps\analytics

#mongorestore –host <destination host ip or hostname> –port <port at which mongodb is running> –db <new or target database name> <Directory path containing bson and json files>

To confirm whether database is restored.Run following from cmd.

mongo <target hostname or hostip>:<port>
show dbs

You will see your new database. Now run following commands to see collections.

use analytics_new_db
show collections

You will see your collections of your database. Hope you enjoyed this.

Happy Database Backup and Restoring 🙂