SQL Server TCP/IP Protocol | Windows Powershell

Опубликовано: 30 Октябрь 2024
на канале: How To 365
206
5

Learn How to Enable SQL SERVER TCP/IP Protocol using Windows Powershell. This command will help you solve one of the mysteries of SQL Server network Related errors.

-------- S O L U T I O N S

✔️ Using Windows PowerShell to enable it

-------- P R E V I O U S V I D E O

⏮️ FIX SQL SERVER CONNECTION ERROR

🔗    • Incorrect Syntax near 'Go' Fix | C# |...  

-------- S U B S C R I B E

❤️ DON'T forget to LIKE, COMMENT your IDEA, and SUBSCRIBE

🔗 https://bit.ly/3Pakd48

-------- I N S T A G R A M

📷   / atrin_noori  

--------- S Q L S E R V E R E P I S O D E 7 ---------

00:00 - ENABLE SQL SERVER TCP PROTOCOL using WINDOWS POWERSHELL
00:05 - FIX SQL SERVER CONNECTION ERROR
00:11 - SQL TCP PROTOCOL POWERSHELL ENABLE COMMAND
01:01 - SQL SERVER Instance Name
01:40 - SQL TCP PROTOCOL POWERSHELL COMMAND
02:07 - SQL Server Service Name
02:25 - SQL Server TCP/IP Protocol Enable Check
02:46 - How to Save a file as a POWERSHELL file
03:05 - End Screen

--------- A B O U T S E C T I O N ---------

🙍 About Microsoft SQL Server:
Microsoft SQL Server is a relational database management system developed by Microsoft. As a database server, it is a software product with the primary function of storing and retrieving data as requested by other software applications—which may run either on the same computer or on another computer across a network

🙍 About SQL:
Structured Query Language, abbreviated as SQL, is a domain-specific language used in programming and designed for managing data held in a relational database management system, or for stream processing in a relational data stream management system

🙍 About Microsoft Windows:
Windows is a group of several proprietary graphical operating system families developed and marketed by Microsoft. Each family caters to a certain sector of the computing industry. For example, Windows NT for consumers, Windows Server for servers, and Windows IoT for embedded systems

🙍 About Windows Management Instrumentation (WMI):
The WMI Provider for Server Events lets you use the Windows Management Instrumentation (WMI) to monitor events in SQL Server. The provider works by turning SQL Server into a managed WMI object. Any event that can generate an event notification in SQL Server can be leveraged by the WMI by using this provider.

🙍 About Windows PowerShell:
PowerShell is a task automation and configuration management program from Microsoft, consisting of a command-line shell and the associated scripting language.