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 : Locate/Find the place where MS SQL Server 2014 database file exists.
The path is = C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\Database_file_name. 
0 Comments