Rodrigo Romano – MVP SharePoint Server

Registros de um Especialista SharePoint :)

Posts Tagged ‘Instalação

Windows 10 – Technical Preview

leave a comment »


Olá SharePointers,

Para quem não está muito antenado com as novidades, hoje (01/10) foi liberado para o público em geral os testes do Windows 10 – Technical Preview. Para quem quiser fazer o download, está disponível aqui: http://windows.microsoft.com/pt-br/windows/preview-download

ATENÇÃO: Para quem quiser instalar, lembre-se de fazer um backup e pontos de restauração para voltar a máquina ao estado original.

Como um “Early Adopter”, instalei em minha máquina…. Confiram o resultado:

A tela de instalação é semelhante à do Windows 8.1

image

Achei bem interessante à interligação com o OneDrive. Tudo nativo, sem instalar nenhum utilitário.

image

 

Esse é o seu desktop, logo após a instalação:

image

Menu Iniciar

image

 

image

Janelas sem bordas, menu iniciar expandido:

image

Suporte à multiplos desktops

image

E o mais importante…… kkkk CTRL+C e CTRL+V dentro do command e do powershell 😀

 

O que acharam?

Advertisements

Written by Rodrigo Romano

October 1, 2014 at 3:02 pm

Troubleshooting: Could not find stored procedure ‘sp_dboption’

leave a comment »


Olá SharePointers,

Hoje estava montando um ambiente para testes de migração e encontrei um problema ao instalar o SharePoint Server 2007 SP2 com SQL Server 2012.

O erro foi: Could not find stored procedure ‘sp_dboption’. Essa stored procedure foi descontinuada no SQL Server 2012 e, para que a instalação funcione, é necessário criá-la novamente, utilizando o código abaixo:

USE [master]
GO
/****** Object: StoredProcedure [sys].[sp_dboption] Script Date: 12/08/2013 21:22:10 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE procedure [sp_dboption] — 1999/08/09 18:25
@dbname sysname = NULL, — database name to change
@optname varchar(35) = NULL, — option name to turn on/off
@optvalue varchar(10) = NULL — true or false
as
set nocount on
declare @dbid int — dbid of the database
declare @catvalue int — number of category option
declare @optcount int — number of options like @optname
declare @allstatopts int — bit map off all options stored in sysdatqabases.status
— that can be set by sp_dboption.
declare @alloptopts int — bit map off all options stored in sysdatqabases.status
— that can be set by sp_dboption.
declare @allcatopts int — bit map off all options stored in sysdatqabases.category
— that can be set by sp_dboption.
declare @exec_stmt nvarchar(max)
declare @fulloptname varchar(35)
declare @alt_optname varchar(50)
declare @alt_optvalue varchar(30)
declare @optnameIn varchar(35)
select @optnameIn = @optname
,@optname = LOWER (@optname collate Latin1_General_CI_AS)
— If no @dbname given, just list the possible dboptions.
— Only certain status bits may be set or cleared by sp_dboption.
— Get bitmap of all options that can be set by sp_dboption.
select @allstatopts=number from master.dbo.spt_values where type = ‘D’
and name = ‘ALL SETTABLE OPTIONS’
select @allcatopts=number from master.dbo.spt_values where type = ‘DC’
and name = ‘ALL SETTABLE OPTIONS’
select @alloptopts=number from master.dbo.spt_values where type = ‘D2’
and name = ‘ALL SETTABLE OPTIONS’
if @dbname is null
begin
select ‘Settable database options:’ = name
from master.dbo.spt_values
where (type = ‘D’
and number & @allstatopts <> 0
and number not in (0,@allstatopts)) — Eliminate non-option entries
or (type = ‘DC’
and number & @allcatopts <> 0
and number not in (0,@allcatopts))
or (type = ‘D2’
and number & @alloptopts <> 0
and number not in (0,@alloptopts))
order by name
return (0)
end
— Verify the database name and get info
select @dbid = dbid
from master.dbo.sysdatabases
where name = @dbname
— If @dbname not found, say so and list the databases.
if @dbid is null
begin
raiserror(15010,-1,-1,@dbname)
print ‘ ‘
select ‘Available databases:’ = name
from master.dbo.sysdatabases
return (1)
end
— If no option was supplied, display current settings.
if @optname is null
begin
select ‘The following options are set:’ = v.name
from master.dbo.spt_values v, master.dbo.sysdatabases d
where d.name=@dbname
and ((number & @allstatopts <> 0
and number not in (-1,@allstatopts)
and v.type = ‘D’
and (v.number & d.status)=v.number)
or (number & @allcatopts <> 0
and number not in (-1,@allcatopts)
and v.type = ‘DC’
and d.category & v.number <> 0)
or (number & @alloptopts <> 0
and number not in (-1,@alloptopts)
and v.type = ‘D2’
and d.status2 & v.number <> 0))
return(0)
end
if @optvalue is not null and lower(@optvalue) not in (‘true’, ‘false’, ‘on’, ‘off’)
begin
raiserror(15241,-1,-1)
return (1)
end
— Use @optname and try to find the right option.
— If there isn’t just one, print appropriate diagnostics and return.
select @optcount = count(*) ,@fulloptname = min(name)
from master.dbo.spt_values
where lower(name collate Latin1_General_CI_AS) like ‘%’ + @optname + ‘%’
and ((type = ‘D’
and number & @allstatopts <> 0
and number not in (-1,@allstatopts))
or (type = ‘DC’
and number & @allcatopts <> 0
and number not in (-1,@allcatopts))
or (type = ‘D2’
and number & @alloptopts <> 0
and number not in (-1,@alloptopts)))
— If no option, show the user what the options are.
if @optcount = 0
begin
raiserror(15011,-1,-1,@optnameIn)
print ‘ ‘
select ‘Settable database options:’ = name
from master.dbo.spt_values
where (type = ‘D’
and number & @allstatopts <> 0
and number not in (-1,@allstatopts)) — Eliminate non-option entries
or (type = ‘DC’
and number & @allcatopts <> 0
and number not in (-1,@allcatopts))
or (type = ‘D2’
and number & @alloptopts <> 0
and number not in (-1,@alloptopts))
order by name
return (1)
end
— If more than one option like @optname, show the duplicates and return.
if @optcount > 1
begin
raiserror(15242,-1,-1,@optnameIn)
print ‘ ‘
select duplicate_options = name
from master.dbo.spt_values
where lower(name collate Latin1_General_CI_AS) like ‘%’ + @optname + ‘%’
and ((type = ‘D’
and number & @allstatopts <> 0
and number not in (-1,@allstatopts))
or (type = ‘DC’
and number & @allcatopts <> 0
and number not in (-1,@allcatopts))
or (type = ‘D2’
and number & @alloptopts <> 0
and number not in (-1,@alloptopts))
)
return (1)
end
— Just want to see current setting of specified option.
if @optvalue is null
begin
select OptionName = v.name,
CurrentSetting = (case
when ( ((v.number & d.status) = v.number
and v.type = ‘D’)
or (d.category & v.number <> 0
and v.type = ‘DC’)
or (d.status2 & v.number <> 0
and v.type = ‘D2’)
)
then ‘ON’
when not
( ((v.number & d.status) = v.number
and v.type = ‘D’)
or (d.category & v.number <> 0
and v.type = ‘DC’)
or (d.status2 & v.number <> 0
and v.type = ‘D2’)
)
then ‘OFF’
end)
from master.dbo.spt_values v, master.dbo.sysdatabases d
where d.name=@dbname
and ((v.number & @allstatopts <> 0
and v.number not in (-1,@allstatopts) — Eliminate non-option entries
and v.type = ‘D’)
or (v.number & @allcatopts <> 0
and v.number not in (-1,@allcatopts) — Eliminate non-option entries
and v.type = ‘DC’)
or (v.number & @alloptopts <> 0
and v.number not in (-1,@alloptopts) — Eliminate non-option entries
and v.type = ‘D2’)
)
and lower(v.name) = lower(@fulloptname)
return (0)
end
select @catvalue = 0
select @catvalue = number
from master.dbo.spt_values
where lower(name) = lower(@fulloptname)
and type = ‘DC’
— if setting replication option, call sp_replicationdboption directly
if (@catvalue <> 0)
begin
select @alt_optvalue = (case lower(@optvalue)
when ‘true’ then ‘true’
when ‘on’ then ‘true’
else ‘false’
end)
select @alt_optname = (case @catvalue
when 1 then ‘publish’
when 2 then ‘subscribe’
when 4 then ‘merge publish’
else quotename(@fulloptname, ””)
end)
select @exec_stmt = quotename(@dbname, ‘[‘) + ‘.dbo.sp_replicationdboption’
EXEC @exec_stmt @dbname, @alt_optname, @alt_optvalue
return (0)
end
— call Alter Database to set options
— set option value in alter database
select @alt_optvalue = (case lower(@optvalue)
when ‘true’ then ‘ON’
when ‘on’ then ‘ON’
else ‘OFF’
end)
— set option name in alter database
select @fulloptname = lower(@fulloptname)
select @alt_optname = (case @fulloptname
when ‘auto create statistics’ then ‘AUTO_CREATE_STATISTICS’
when ‘auto update statistics’ then ‘AUTO_UPDATE_STATISTICS’
when ‘autoclose’ then ‘AUTO_CLOSE’
when ‘autoshrink’ then ‘AUTO_SHRINK’
when ‘ansi padding’ then ‘ANSI_PADDING’
when ‘arithabort’ then ‘ARITHABORT’
when ‘numeric roundabort’ then ‘NUMERIC_ROUNDABORT’
when ‘ansi null default’ then ‘ANSI_NULL_DEFAULT’
when ‘ansi nulls’ then ‘ANSI_NULLS’
when ‘ansi warnings’ then ‘ANSI_WARNINGS’
when ‘concat null yields null’ then ‘CONCAT_NULL_YIELDS_NULL’
when ‘cursor close on commit’ then ‘CURSOR_CLOSE_ON_COMMIT’
when ‘torn page detection’ then ‘TORN_PAGE_DETECTION’
when ‘quoted identifier’ then ‘QUOTED_IDENTIFIER’
when ‘recursive triggers’ then ‘RECURSIVE_TRIGGERS’
when ‘default to local cursor’ then ‘CURSOR_DEFAULT’
when ‘offline’ then (case @alt_optvalue when ‘ON’ then ‘OFFLINE’ else ‘ONLINE’ end)
when ‘read only’ then (case @alt_optvalue when ‘ON’ then ‘READ_ONLY’ else ‘READ_WRITE’ end)
when ‘dbo use only’ then (case @alt_optvalue when ‘ON’ then ‘RESTRICTED_USER’ else ‘MULTI_USER’ end)
when ‘single user’ then (case @alt_optvalue when ‘ON’ then ‘SINGLE_USER’ else ‘MULTI_USER’ end)
when ‘select into/bulkcopy’ then ‘RECOVERY’
when ‘trunc. log on chkpt.’ then ‘RECOVERY’
when ‘db chaining’ then ‘DB_CHAINING’
else @alt_optname
end)
if @fulloptname = ‘dbo use only’
begin
if @alt_optvalue = ‘ON’
begin
if databaseproperty(@dbname, ‘IsSingleUser’) = 1
begin
raiserror(5066,-1,-1);
return (1)
end
end
else
begin
if databaseproperty(@dbname, ‘IsDBOOnly’) = 0
return (0)
end
end
if @fulloptname = ‘single user’
begin
if @alt_optvalue = ‘ON’
begin
if databaseproperty(@dbname, ‘ISDBOOnly’) = 1
begin
raiserror(5066,-1,-1);
return (1)
end
end
else
begin
if databaseproperty(@dbname, ‘IsSingleUser’) = 0
return (0)
end
end
select @alt_optvalue = (case @fulloptname
when ‘default to local cursor’ then (case @alt_optvalue when ‘ON’ then ‘LOCAL’ else ‘GLOBAL’ end)
when ‘offline’ then ”
when ‘read only’ then ”
when ‘dbo use only’ then ”
when ‘single user’ then ”
else @alt_optvalue
end)
if lower(@fulloptname) = ‘select into/bulkcopy’
begin
if @alt_optvalue = ‘ON’
begin
if databaseproperty(@dbname, ‘IsTrunclog’) = 1
select @alt_optvalue = ‘RECMODEL_70BACKCOMP’
else
select @alt_optvalue = ‘BULK_LOGGED’
end
else
begin
if databaseproperty(@dbname, ‘IsTrunclog’) = 1
select @alt_optvalue = ‘SIMPLE’
else
select @alt_optvalue = ‘FULL’
end
end
if lower(@fulloptname) = ‘trunc. log on chkpt.’
begin
if @alt_optvalue = ‘ON’
begin
if databaseproperty(@dbname, ‘IsBulkCopy’) = 1
select @alt_optvalue = ‘RECMODEL_70BACKCOMP’
else
select @alt_optvalue = ‘SIMPLE’
end
else
begin
if databaseproperty(@dbname, ‘IsBulkCopy’) = 1
select @alt_optvalue = ‘BULK_LOGGED’
else
select @alt_optvalue = ‘FULL’
end
end
— construct the ALTER DATABASE command string
select @exec_stmt = ‘ALTER DATABASE ‘ + quotename(@dbname) + ‘ SET ‘ + @alt_optname + ‘ ‘ + @alt_optvalue + ‘ WITH NO_WAIT’
EXEC (@exec_stmt)
if @@error <> 0
begin
raiserror(15627,-1,-1)
return (1)
end
return (0) — sp_dboption

 

Abraços! 😀

Written by Rodrigo Romano

July 3, 2014 at 10:35 am

SharePoint 2013: Atualizando o SharePoint

leave a comment »


Olá SharePointers,

Hoje fui atualizar o meu ambiente SharePoint 2013  (que estava com a versão RTM) e, sem pensar ou ler, baixei o último Cumulative Update – Dezembro/2013 fui instalar e… 

Captura de Tela 2014-03-08 às 17.26.55

 

Enfim, acontece que agora o Cumulative Update – Março/2013 é o baseline para todos os futuros updates, ou seja, para instalar qualquer update o de Março tem que ser instalado primeiro e depois pode instalar qualquer um.

Para uma lista de todos os updates do SharePoint 2013, acesse o link: http://technet.microsoft.com/en-us/sharepoint/jj891062.aspx.

 

Abraços 😀

Written by Rodrigo Romano

March 8, 2014 at 5:32 pm

Troubleshooting: CryptographicException: Os dados são inválidos

leave a comment »


Olá SharePointers,

Recentemente, estava instalando o SharePoint em uma máquina que já tinha SharePoint e deu o erro abaixo:

clip_image002

Para resolver, tive que rodar o seguinte comando com prompt elevado:

psconfig –cmd –configdb disconnect

image

e apagar os bancos de dados de configuração antigos da máquina em questão. Smiley de boca aberta

Written by Rodrigo Romano

February 20, 2014 at 10:59 am

Failed to initiate the upgrade sequence–SPUpgradeException–Erro ao atualizar do Microsoft SharePoint Foundation para o Microsoft SharePoint Server 2010 no Windows 7

leave a comment »


Olá SharePointers,

Hoje passei por um erro ao tentar atualizar a versão do SharePoint da máquina. Estava instalado o SharePoint Foundation e foi instalado o SharePoint Server 2010.

O erro que logava no Event Viewer era esse:

Failed to initiate the upgrade sequence.

An exception of type Microsoft.SharePoint.Upgrade.SPUpgradeException was thrown. Additional exception information: Exception of type Microsoft.SharePoint.Upgrade.SPUpgrade was thrown.

image

Pesquisando um pouco, achei a solução:

Abra o Regedit, vá em HKLM\Software\Microsoft\Shared Tools\Web Server Extensions\14.0\WSS e altere a chave SetupType de SKU2SKU_UPGRADE para CLEAN_INSTALL.

image 

Rode o Configuration Wizard novamente e aparecerá o erro abaixo:

An exception of type Microsoft.SharePoint.Upgrade.SPUpgradeException was thrown. Additional exception information: Failed to call GetTypes on assembly Microsoft.Office.Server.Search, Version=14.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c. Could not load file or assembly ‘System.Web.DataVisualization, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35’ or one of its dependencies. The system cannot find the file specified.

Microsoft.SharePoint.Upgrade.SPUpgradeException: Failed to call GetTypes on assembly Microsoft.Office.Server.Search, Version=14.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c. Could not load file or assembly ‘System.Web.DataVisualization, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35’ or one of its dependencies. The system cannot find the file specified.

at Microsoft.SharePoint.Upgrade.SPDelegateManager.RegisterAssembly(Dictionary`2 dictInitialType, Assembly asm, UInt32 nOrder)

at Microsoft.SharePoint.Upgrade.SPDelegateManager.get_InitialTypeDictionary()

at Microsoft.SharePoint.Upgrade.SPDelegateManager.GetDelegateTypes(Type tpObject)

at Microsoft.SharePoint.Upgrade.SPDelegateManager.GetDelegates(Object o)

at Microsoft.SharePoint.Upgrade.SPDelegateManager.GetUpgraders(Object o)

at Microsoft.SharePoint.Upgrade.SPUpgradeSession.NeedsUpgradeFalse(Object o)

at Microsoft.SharePoint.Administration.SPPersistedUpgradableObject.set_NeedsUpgrade(Boolean value)

at Microsoft.SharePoint.Administration.SPPersistedObject.BaseUpdate()

at Microsoft.Office.InfoPath.Server.Administration.FormsService.Update()

at Microsoft.SharePoint.PostSetupConfiguration.ServicesTask.InstallServiceInConfigDB(Boolean provisionTheServiceToo, String serviceRegistryKeyName)

at Microsoft.SharePoint.PostSetupConfiguration.ServicesTask.InstallServices(Boolean provisionTheServicesToo)

at Microsoft.SharePoint.PostSetupConfiguration.ServicesTask.Run()

at Microsoft.SharePoint.PostSetupConfiguration.TaskThread.ExecuteTask()

image

 

Isso significa que o MS Charts não está instalado em sua máquina e é necessário. Para instalá-lo, baixe aqui: http://www.microsoft.com/downloads/en/details.aspx?familyid=130F7986-BF49-4FE5-9CA8-910AE6EA442C&displaylang=en.

Depois de instalado, rode o Configuration Wizard novamente e Voilá!

 

Referência: http://blogs.msdn.com/b/sasohail/archive/2010/09/28/failed-to-initiate-the-upgrade-sequence-error-while-upgrading-from-microsoft-sharepoint-foundation-2010-to-microsoft-sharepoint-server-2010-in-windows-7.aspx

 

Fica a Dica! Alegre

Written by Rodrigo Romano

January 11, 2013 at 10:01 am

Instalando SharePoint 2013 no Windows Server 2012 RC

with 5 comments


Olá SharePointers,

Hoje vamos instalar o SharePoint Server 2013 Preview.

Para saber mais sobre os pré-requisitos de Hardware e Software, veja esse post do meu amigo MVP Fabian http://fabiangehrke.com.br/2012/07/17/sharepoint-2013requisitos-de-hardware-e-software/.

 

image

 

Instalando os Pré-Requisitos

image

image

image

 

Até aqui, nenhuma mudança. Além dos próprios pré-requisitos, elencados no post do Fabian, a ferramenta fez tudo automaticamente (Download, Instalação e Configuração), igual na versão anterior do SharePoint. So far, so good.

 

Instalando o SharePoint 2013

Antes de instalar o SharePoint, recomendo a leitura de alguns links disponíveis no TechNet:

Instalando e Configurando o SharePoint 2013 Preview: http://technet.microsoft.com/en-us/library/cc262957(v=office.15)

Instalando o SharePoint 2013: http://technet.microsoft.com/en-us/library/cc303424(v=office.15)

Planejando SharePoint 2013: http://technet.microsoft.com/en-us/library/cc261834(v=office.15)

 

Nesse artigo, estou utilizando a instalação “Single Server com SQL Server na mesma máquina

image

image

image

image

image

image

image

image

image

image

image

image

image

 

And Voiláa!! Vejam como ficou a nova Central Admin:

 

image

 

image

 

Vejam abaixo a lista dos serviços disponíveis:

 

image

 

Exemplo de um site (Template Team Project)

image

 

image

 

É isso aí pessoal, para quem quiser ver como o SharePoint ficou e navegar um pouco, podem usar esse link: http://romanosp2013.cloudapp.net.

 

Para testar colaboração, podem usar o seguinte usuário:

Usuário: CLOUD\colaborador

Senha: SharePoint2013

 

Abraços!

Written by Rodrigo Romano

July 18, 2012 at 11:54 am

Posted in SharePoint, SharePoint 2013

Tagged with

Como identifcar qual versão do SharePoint 2010 está instalada?

with 5 comments


Olá SharePointer,

Depois de ver muitas dúvidas a respeito, gostaria de compartilhar uma TIP. Como identificar a versão do SharePoint 2010 instalada? Standard ou Enterprise? Full ou Trial? Office Web Apps?

Bom, para responder a essas perguntas, vocês devem olhar no Registro do Windows.

Para isso, vá em Iniciar –> Executar –> Digite REGEDIT e clique em OK.

image

Caminhe até a chave abaixo:

HKLM\SOFTWARE\Microsoft\Shared Tools\Web Server Extensions\14.0\WSS\InstalledProducts\

image

 

Para referências, vejam a tabela abaixo:

GUID Produto
BEED1F75-C398-4447-AEF1-E66E1F0DF91E SharePoint Foundation 2010
1328E89E-7EC8-4F7E-809E-7E945796E511 Search Server Express 2010
B2C0B444-3914-4ACB-A0B8-7CF50A8F7AA0 SharePoint Server 2010 Standard Trial
3FDFBCC8-B3E4-4482-91FA-122C6432805C SharePoint Server 2010 Standard
88BED06D-8C6B-4E62-AB01-546D6005FE97 SharePoint Server 2010 Enterprise Trial
D5595F62-449B-4061-B0B2-0CBAD410BB51 SharePoint Server 2010 Enterprise
BC4C1C97-9013-4033-A0DD-9DC9E6D6C887 Search Server 2010 Trial
08460AA2-A176-442C-BDCA-26928704D80B Search Server 2010
84902853-59F6-4B20-BC7C-DE4F419FEFAD Project Server 2010 Trial
ED21638F-97FF-4A65-AD9B-6889B93065E2 Project Server 2010
926E4E17-087B-47D1-8BD7-91A394BC6196 Office Web Companions 2010

 

Caso prefiram, podem utilizar um programa para essa funcionalidade. Existe um exemplo no MSDN para essa funcionalidade: http://msdn.microsoft.com/en-us/library/ff721969.aspx

 

Abraços!

Written by Rodrigo Romano

October 21, 2010 at 11:28 pm