Sql Server 2014 Installation Process & Problems

Example : How to remove the following errors from MS SQL Server 2014.

“Network-related or instance-specific error occurred while establishing a connection to   SQL Server …“

 - Goto 'Run' - Type 'Services.msc' - search and right click on 'Sql Server(MSSQLSERVER)' - select and click 'Refresh' and then click on 'Start' - Restart/Reconnect Sql Server 2014.

Example : How to save or store data by modifying/editing tables in MS SQL Server 2014.

- Open Sql Server 2014 - Tools - Options - Select/click 'Designers' option from left pane area - Uncheck the 'Prevent   
  saving changes that require table re-creation' option - Ok.

Example : How to create SQL Server Script files as backups.

Open SQL Server 2014 - Right click on your created database file - Tasks - Generate scripts - Next - Next - Next - Next - Finish.

Example : How to import/add a database file in MS SQL Server 2014/2017?

If a file is .mdf, paste it into "C:\Program Files (x86)\Microsoft SQL Server\MSSQL12 or MSSQL 14.MSSQLSERVER \MSSQL\DATA" folder where all created databases exist.

OR 

If a file is script.sql, first of all create a new database file after opening SQL server 2014/2017 successfully with certain name(say StudentDb) - File - Open - File - Now choose/select the created and saved script server file (say script.sql) - now the script will open in a new query window - Now, at the top-left of the query window(left of execute), select the required/created database(say StudentDb) from the database dropdown list(by default master) - click 'Execute'  or press F5 - Now, SQL Server will execute the statements and create the tables, views, stored procedures, and insert records contained in the script - See the database(say StudentDb) with all created tables as in script.sql file.

Example : Locate/Find the place where the MS SQL Server 2014/ 2017 database file exists or is stored from where we can copy as a Backup.

In MS SQL Server 2014 = C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\Database_file_name.

OR

In MS SQL Server 2014 = C:\Program Files (x86)\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\DATA\Your Database_file_name.

In MS SQL Server 2017 = C:\Program Files (x86)\Microsoft SQL Server\MSSQL14.MSSQLSERVER\MSSQL\DATA\Your Database_file_name.