Differences

This shows you the differences between two versions of the page.

--- software:microsoft:sqlserver [2018/07/02 20:09] – superwizard
+++ software:microsoft:sqlserver [2018/09/13 20:28] (current) – superwizard
@@ Line 1: / Line 1: @@
+====== I can't connect to my servers SQL database via an IP Address ======
+From: https://dba.stackexchange.com/questions/62165/i-cant-connect-to-my-servers-sql-database-via-an-ip-address
+<code>
+open SQL Server Configuration Manager;
+switch to the SQL Server Network Configuration | Protocols for SQLEXPRESS;
+double-click the TCP/IP protocol;
+select the Yes value in the Enabled field;
+switch to the IP Addresses tab;
+</code>
 ====== Backup with powershell ======
 <code>
 ps1 script
-Backup-SqlDatabase -ServerInstance Machine096\SSERVICES -Database IServices -BackupAction Database
+Backup-SqlDatabase -ServerInstance Machine096\SSERVICES -Database IServices -BackupAction Database -BackupFile "F:\MSSQL14.SSERVICES\MSSQL\Backup\Backup_Machine\InspectionServices.bak"
 Exit
 Cmd file
-powershell.exe -executionpolicy bypass -file BackupScheme.ps1 -Balanced
+powershell.exe -executionpolicy bypass
+               -file "C:\Users\Public\Downloads\SQLInspectionServicesBackup Script\BackupInspectionServices.ps1"
 </code>