Wsus 3.0 como ter acesso ao banco SQL

"How to connect to WSUS SQL SERVER"

Como acessar o banco de dados do Windows Internal Database com o Management Tools

Otimizando banco de dados do WSUS ou Otimizando o WSUS

Como otimizar e limpar o banco de dados. ( se for servidor de produção lembre de fazer backup do banco ( HOW TO BACKUP MS SQL SERVER )

Acesse o banco de dados (HOW TO ) abra uma query.

Gerar um report de TOP Tables,



Escolha as que tenham mais # Records, abra a tabela, com mais records, clique com o direito e clique rebuild ALL ou reorganize ALL se for a segunda vez que estiver executando este procedimento.

Feito pode acompanha o processo que pode demorar muito (depende do servidor) mas o banco SQL 2005 é lento mesmo.

Escolha indexes que vai iniciar o rebuild e de OK, execute este procedimento em todas as tabelas, limpe as logs do banco para finalizar.

Ou outra opção para executar um re index global , por Query copie e execute.

DECLARE @TableName VARCHAR(255) DECLARE @sql NVARCHAR(500) DECLARE @fillfactor INT SET @fillfactor = 80 DECLARE TableCursor CURSOR FOR SELECT OBJECT_SCHEMA_NAME([object_id])+'.'+name AS TableName FROM sys.tables OPEN TableCursor FETCH NEXT FROM TableCursor INTO @TableName WHILE @@FETCH_STATUS = 0 BEGIN SET @sql = 'ALTER INDEX ALL ON ' + @TableName +' REBUILD WITH (FILLFACTOR = ' + CONVERT(VARCHAR(3),@fillfactor) + ')' EXEC (@sql) FETCH NEXT FROM TableCursor INTO @TableName END CLOSE TableCursor DEALLOCATE TableCursor GO

Enquanto executa o servidor pode travar ou não responder, aguarde observando o gerenciador de tarefas, ou abaixo da Query, vide figura abaixo.

Default settings for Exchange virtual directories

With you have problems on IIS permissions at Web configuration of Microsoft Exchange 2010, just see the technet website, show the original configurations.

 

https://technet.microsoft.com/pt-br/library/gg247612%28v=exchg.150%29.aspx

 

Default Client Access server IIS authentication and SSL settings

Virtual directory	Authentication method	SSL settings	Management method
Default website	Anonymous	Required	IIS management console
aspnet_client	Anonymous authentication	SSL required Requires 128-bit encryption	IIS management console
Autodiscover	Anonymous authentication Basic authentication Windows authentication	SSL required Requires 128-bit encryption	Exchange Management Shell (Shell)
ecp	Anonymous authentication Basic authentication	SSL required Requires 128-bit encryption	Exchange admin center (EAC) or Shell
EWS	Anonymous authentication Windows authentication	SSL required Requires 128-bit encryption	Shell
Microsoft-Server-ActiveSync	Basic authentication	SSL required Requires 128-bit encryption	EAC or Shell
OAB	Windows authentication	Not required	EAC or Shell
owa	Basic authentication	SSL required Requires 128-bit encryption	EAC or Shell
PowerShell	Anonymous authentication	Not required	Shell
Rpc	Basic authentication Windows authentication	SSL required Requires 128-bit encryption	Shell
RpcWithCert	By default, all authentication methods are disabled.	Required

Mailbox server

The following table lists the default settings on a stand-alone Exchange 2013 Mailbox server.

Default Mailbox server IIS authentication and SSL settings

Virtual directory	Authentication method	SSL settings	Management method
Default website	Anonymous authentication	SSL required Requires 128-bit encryption	This virtual directory can’t be configured by the user.
PowerShell	Anonymous authentication	Not required	Shell