Eseguire le seguenti istruzioni per abilitare i protocolli TCP e Named Pipes.Execute the following statements to enable both the TCP and named pipes protocols.Sostituire <computer_name> con il nome del computer in cui è in esecuzione SQL ServerSQL Server.Replace <computer_name> with the name of the computer that is running SQL ServerSQL Server.Se si configura un'istanza denominata, sostituire MSSQLSERVER con il nome dell'istanza.If you are configuring a named instance, replace MSSQLSERVER with the instance name.

# Get a reference to the ManagedComputer class.
CD SQLSERVER:\SQL\<computer_name>
$Wmi = (get-item .).ManagedComputer
# Get a reference to the default instance of the Database Engine.
$DfltInstance = $Wmi.Services['MSSQLSERVER']
# Display the state of the service.
$DfltInstance
# Stop the service.
$DfltInstance.Stop();
# Wait until the service has time to stop.
# Refresh the cache.
$DfltInstance.Refresh();
# Display the state of the service.
$DfltInstance
# Start the service again.
$DfltInstance.Start();
# Wait until the service has time to start.
# Refresh the cache and display the state of the service.
$DfltInstance.Refresh(); $DfltInstance