martes, 28 de julio de 2009

jueves, 23 de julio de 2009

Error: SQL Server Setup could not connect to the database service for server configuration

 

El siguiente error se puede presentar cuando intentas instalar una nueva instancia de SQL Server y te intentas conectar desde un cliente

SQL Server Setup could not connect to the database service for server configuration. The error was: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified Refer to server error logs and setup logs for more information. For details on how to view setup logs, see "How to View Setup Log Files" in SQL Server Books Online.

Para solucionarlo lo que tiene que realizar es registrar nuevamente un DLL con el siguiente comando:

regsvr32.exe sqldmo.dll

Saludos,

Eduardo Castro – Microsoft SQL Server MVP

http://comunidadwindows.org

Costa Rica

Technorati Tags: SQL Server

LiveJournal Tags: SQL Server

del.icio.us Tags: SQL Server

http://ecastrom.blogspot.com

http://ecastrom.wordpress.com

http://ecastrom.spaces.live.com

http://universosql.blogspot.com

http://todosobresql.blogspot.com

http://todosobresqlserver.wordpress.com

martes, 21 de julio de 2009

SQL Server La longitud de los datos LOB (2200100) que se van a replicar excede el máximo configurado 65536.

 

Cuando se tiene configurada la replicación el tamaño por default para los campos binarios e images es de 65536 y genera el siguiente error durante la replicación:

Error: 7139, Severity: 16, State: 1

La longitud de los datos LOB (2200100) que se van a replicar excede el máximo configurado 65536.

Length of text, ntext, or image data (x) to be replicated exceeds configured maximum 65536

Para solucionarlo hay que cambiar el tamaño permitido para la replicación lo pueden hacer con los siguientes comandos:

 

print 'Tamano Anterior' 
exec sp_configure 'max text repl size'

print ' Nuevo valor maximo de replicacion por ejemplo 300 mil bytes'
exec sp_configure 'max text repl size', 300000

print 'Forzar la reconfiguracion'
RECONFIGURE WITH OVERRIDE

print 'Verificar que se cambio el tamaño'
exec sp_configure 'max text repl size'



 



Saludos,



Eduardo Castro – Microsoft SQL Server MVP



http://comunidadwindows.org



Costa Rica



Technorati Tags: SQL Server



LiveJournal Tags: SQL Server



del.icio.us Tags: SQL Server



http://ecastrom.blogspot.com



http://ecastrom.wordpress.com



http://ecastrom.spaces.live.com



http://universosql.blogspot.com



http://todosobresql.blogspot.com



http://todosobresqlserver.wordpress.com

Disponible el Cumulative update package 1 for SQL Server 2008

Ya puedes bajar el Cumulative update package 1 for SQL Server 2008 en esta dirección http://support.microsoft.com/kb/956717/en-us

Dentro de los errores que se corrigen están los siguientes:

SQL Hotfix bug number
Knowledge Base article number
Description

50003171
When you use a SAP client computer to view a SQL Server database, the database may be smaller than expected

50003196
957810 (http://support.microsoft.com/kb/957810/ )
FIX: In SQL Server 2008, a query returns incorrect results for the Date data type when you run the query on a partitioned table that uses data compression on only one of the partitions

50003200
957375 (http://support.microsoft.com/kb/957375/ )
FIX: A mirror server cannot fail over to a principal server in a SQL Server 2008 failover cluster

50003202
957811 (http://support.microsoft.com/kb/957811/ )
FIX: You receive an error message that states that the broker GUIDs do not match when you try to establish database mirroring in SQL Server 2008 or in SQL Server 2005

50003203
957205 (http://support.microsoft.com/kb/957205/ )
FIX: An XML query that contains the @Table variable or the @XML variable takes a long time to complete in SQL Server 2008

50003224
926292 (http://support.microsoft.com/kb/926292/ )
FIX: When you query through a view that uses the ORDER BY clause in SQL Server 2008, the result is still returned in random order

50003238
957814 (http://support.microsoft.com/kb/957814/ )
FIX: The result for the Sum or Count function returns an empty value when you query a SQL Server 2008 Analysis Services cube

50003241
957101 (http://support.microsoft.com/kb/957101/ )
FIX: Some lists that use visibility toggles may not work as expected when you upgrade to SQL Server 2008 Reporting Services

50003242
955719 (http://support.microsoft.com/kb/955719/ )
FIX: Some text characters are displayed as square glyphs in a report that you design or view by using SQL Server 2008 Reporting Services

50003243
958745 (http://support.microsoft.com/kb/958745/ )
FIX: Error message when you try to run or preview a very large report in Microsoft SQL Server 2008 Reporting Services: "Exception of type System.OutOfMemoryException was thrown"

50003244
957103 (http://support.microsoft.com/kb/957103/ )
FIX: Error message when you try to view a report in SQL Server 2008 Reporting Services: "Object reference not set to an instance of an object. (rsRuntimeErrorInExpression)"

50003245
FIX: SQL Server 2008 Reporting Services stops responding when you try to render a report in the Image format

50003246
957104 (http://support.microsoft.com/kb/957104/ )
FIX: When you try to run a report that has recursive hierarchy and that uses toggles in the hierarchy, you may receive unpredictable results in SQL Server 2008 Reporting Services

50003247
957107 (http://support.microsoft.com/kb/957107/ )
FIX: A dump file may be generated in the Reporting Services Logfiles folder and you may receive an error message when you try to render a report in SQL Server 2008 Reporting Services

50003248
957108 (http://support.microsoft.com/kb/957108/ )
FIX: The Gauge report item uses only one point after you add multiple points to the item in SQL Server 2008 Reporting Services

50003249
FIX: Some items are split over two pages when you export a report to a PDF in SQL Server 2008 Reporting Services and you set the KeepTogether property

50003250
The embedded Tablix row and column size is not 100% for cells that contain data when a Tablix is embedded inside another Tablix in SQL Server 2008 Reporting Services

50003251
FIX: An image that is nested in a Tablix cell in SQL Server 2008 Reporting Services is displayed incorrectly when the Sizing property of the image is set to AutoSize

50003252
957118 (http://support.microsoft.com/kb/957118/ )
FIX: Images in rows are not displayed correctly for static Tablix members in a SQL Server 2008 Reporting Services report

50003253
957111 (http://support.microsoft.com/kb/957111/ )
FIX: You receive an error message when you use the LoadReportDefinition API to view a drillthrough report or a subreport report in Report Builder in SQL Server 2008 Reporting Services

50003254
957120 (http://support.microsoft.com/kb/957120/ )
FIX: SQL Server 2008 Reporting Services interprets the Slant property as a positive slope

50003255
957112 (http://support.microsoft.com/kb/957112/ )
FIX: SQL Server 2008 Reporting Services may stop responding when you move a history snapshot or a linked report to a new folder location

50003256
957113 (http://support.microsoft.com/kb/957113/ )
FIX: Error message when you try to create a query against a Hyperion Essbase cube database: "OLAP error (1260046): Unknown Member PARENT_UNIQUE_NAME used in query"

50003315
956039 (http://support.microsoft.com/kb/956039/ )
FIX: Error message when you run an MDX query that uses the CREATE GLOBAL CUBE statement to create a local cube in SQL Server 2008 Analysis Services or in SQL Server 2005 Analysis Services: "The syntax for '<MDXFunctionName>' is incorrect"

50003316
956376 (http://support.microsoft.com/kb/956376/ )
FIX: The SQL Server 2005 Distribution Agent and the SQL Server 2008 Distribution Agent do not skip error 20598 when you configure a SQL Server 2000 transactional publication to skip error 20598

50003320
954831 (http://support.microsoft.com/kb/954831/ )
FIX: In SQL Server 2008 or in SQL Server 2005, the session that runs the TRUNCATE TABLE statement may stop responding, and you cannot end the session

50003325
955896 (http://support.microsoft.com/kb/955896/ )
FIX: You cannot edit a component that has multiple inputs in a SQL Server 2008 or SQL Server 2005 Integration Services package

50003330
955372 (http://support.microsoft.com/kb/955372/ )
FIX: An incorrect aggregate value is returned when you run an MDX query against a parent/child dimension that has the HideMemberIf property set to ParentIsBlankSelfOrMissing in SQL Server 2008 or in SQL Server 2005

50003334
FIX: Error message when you run an INSERT statement in SQL Server: "Cannot insert an explicit value into a timestamp column"

50003336
FIX: You cannot view calculated members in an Excel 2007 pivot table that references an OLAP table in SQL Server 2005 Analysis Services Service Pack 2 or in SQL Server 2008 Analysis Services

50003339
FIX: Error message when you run an MDX query in SQL Server 2008 Analysis Services: "The MDX function failed because the coordinate for the '<AttributeName>' attribute contains a set"

50003341
955975 (http://support.microsoft.com/kb/955975/ )
FIX: Error message when you update a table at the subscriber in a transactional replication in SQL Server 2008: "Updateable Subscriptions: Rows do not match between Publisher and Subscriber"

50003342
955958 (http://support.microsoft.com/kb/955958/ )
FIX: No rows are returned when you use the sp_replqueuemonitor stored procedure to list the queued messages for a queue-updating subscription in SQL Server

50003344
957872
FIX: When you update rows by using a cursor in SQL Server 2008, the update may take a long time to finish

50003345
956036 (http://support.microsoft.com/kb/956036/ )
FIX: Error message when you process a partition from SQL Server 2005 Analysis Services Cumulative Update 7 or from the release version of SQL Server 2008 Analysis Services: "Detected inconsistency between User define slice and detected slice of partition"

50003346
FIX: You receive a "Current session is no longer valid" error message or an access violation occurs when you process a cube in SQL Server 2008 Analysis Services

50003349
FIX: Error message when you run an UPDATE statement against a table that has a DML trigger in SQL Server 2008: "An inconsistency was detected during an internal operation"

50003350
Analysis Services may stop responding when a NonEmpty clause causes many cell errors

50003351
957819 (http://support.microsoft.com/kb/957819/ )
FIX: A SQL Server 2008 Analysis Services server may stop responding when you try to run an MDX query that uses cell security

50003352
957820 (http://support.microsoft.com/kb/957820/ )
FIX: The mining model opens a blank task editor window when you try to deploy the Data Mining Model Training task in a SQL Server 2008 Integration Services project in Business Intelligence Development Studio

50003360
956718 (http://support.microsoft.com/kb/956718/ )
FIX: A MERGE statement may not enforce a foreign key constraint when the statement updates a unique key column that is not part of a clustering key and there is a single row as the update source in SQL Server 2008

50003364
957277 (http://support.microsoft.com/kb/957277/ )
FIX: The IntelliSense feature does not work correctly for a database that uses the Turkish collation and that uses the case-insensitive collation sort order in SQL Server 2008

50003365
956218 (http://support.microsoft.com/kb/956218/ )
FIX: A NullReferenceException error for T-SQL Debugger occurs when you use the SET SHOWPLAN_XML ON option in a Transact-SQL statement on an instance of SQL Server 2008

50003367
957278 (http://support.microsoft.com/kb/957278/ )
FIX: The IntelliSense feature incorrectly completes the logical operators in the CASE WHEN clause in SQL Server 2008

50003368
957239 (http://support.microsoft.com/kb/957239/ )
FIX: You receive an error message when you click the View Single Column Profile By Column button in the Data Profile Viewer in SQL Server 2008: "Unhandled Exception"

50003369
957279 (http://support.microsoft.com/kb/957279/ )
FIX: The IntelliSense feature stops working when you type a query that has a specific lexical combination in SQL Server Management Studio in SQL Server 2008

50003371
957803 (http://support.microsoft.com/kb/957803/ )
FIX: You cannot start the Data Profile Viewer (DataProfileViewer.exe) in SQL Server 2008

50003373
957281 (http://support.microsoft.com/kb/957281/ )
FIX: In SQL Server 2008, the IntelliSense feature may become unavailable when you type Transact-SQL statements in the Query Editor in SQL Server Management Studio

50003382
FIX: Error message when you start the SQL Server 2008 Reporting Services Configuration Manager: "Invalid namespace"

50003383
FIX: The SimSun font is not displayed correctly when you view a SQL Server 2008 Report Services report

50003386
957330 (http://support.microsoft.com/kb/957330/ )
FIX: Clients cannot connect to the Report Server Web service in SQL Server 2008 Reporting Services

50003387
FIX: Error message when you render a report in SQL Server 2008 Reporting Services: "A generic error occurred in GDI+"

50003388
957332 (http://support.microsoft.com/kb/957332/ )
FIX: Data disappears from a report that contains an inner group that is set to an initial state of "Hidden" in SQL Server 2008 Reporting Services

50003389
957333 (http://support.microsoft.com/kb/957333/ )
FIX: A SQL Server 2008 Reporting Services report may repaginate continually and consume 100% of CPU resources

50003391
957387 (http://support.microsoft.com/kb/957387/ )
FIX: No records may be returned when you call the SQLExecute function to execute a prepared statement and you use the SQL Native Client ODBC Driver in SQL Server 2008

50003393
955814 (http://support.microsoft.com/kb/955814/ )
FIX: Error message when you install SQL Server 2008 Express edition on a domain controller that is running Windows Server 2003 SP2 or Windows Small Business Server 2003 SP1: "Exception has been thrown by the target of invocation"

50003399
956138 (http://support.microsoft.com/kb/956138/ )
You cannot upgrade a non-English instance of SQL Server 2000 Reporting Services to SQL Server 2008 Reporting Services

50003400
957805 (http://support.microsoft.com/kb/957805/ )
FIX: When you try to run SQL Server 2008 database engine repair from a DVD, the repair fails, and you may receive error messages

50003401
957453 (http://support.microsoft.com/kb/957453/ )
FIX: When you install SQL Server 2008, the installation fails, and the "Attributes do not match" error message is logged in the Summary.txt file

50003402
957804 (http://support.microsoft.com/kb/957804/ )
FIX: SQL Server Setup does not use the instance name that you provide in the modified Config.ini file when you try to install SQL Server 2008 Express

50003407
Data warehousing may stop collecting data when many time-outs occur

50003409
You receive a memory error message when you try to run SQL Server Setup from a network resource

50003410
You may be unable to uninstall a prepared instance of SQL Server 2008

50003411
955949 (http://support.microsoft.com/kb/955949/ )
FIX: Cluster upgrade to SQL Server 2008 fails when SQL Server 2005 cluster nodes have different installed features

50003412
955948 (http://support.microsoft.com/kb/955948/ )
FIX: When you install a clustered instance of SQL Server 2008, account validation fails even though you have specified the correct domain account and password

50003414
957806 (http://support.microsoft.com/kb/957806/ )
FIX: The CompleteFailoverCluster action does not detect the correct SKU that is prepared by using the PrepareFailoverCluster action in SQL Server 2008

50003415
957459 (http://support.microsoft.com/kb/957459/ )
FIX: Error message when you try to add a second node to a SQL Server 2008 failover cluster: "The current SKU is invalid"

50003419
957357 (http://support.microsoft.com/kb/957357/ )
FIX: You receive an error message that the file is being used by another process when you try to rename or move an output file from a job in SQL Server Agent in SQL Server 2008

50003427
957807 (http://support.microsoft.com/kb/957807/ )
FIX: A new node is not added to a SQL Server 2008 Analysis Services cluster or a SQL Server 2008 Reporting Services cluster if the SQL Server 2008 Database Engine is not installed

50003452
957809 (http://support.microsoft.com/kb/957809/ )
FIX: Event ID 7904 is logged, and the SQL Server 2008 database is corrupted when you restore a SQL Server 2008 database from a sequence of transaction log backups

50003453
When you programmatically retrieve data from a SQL Server 2008 database, the data in memory may be overwritten

50003454
The Service Broker connections between endpoints may experience a deadlock condition when the initiator queues contain many messages

50003456
957823 (http://support.microsoft.com/kb/957823/ )
FIX: The clustered index table may take longer than you expect to be rebuilt when you use the ALTER INDEX REBUILD statement in SQL Server 2008

50003458
957816 (http://support.microsoft.com/kb/957816/ )
FIX: The Database Mirroring feature does not work on a SQL Server 2008-based mirror server when you perform a rolling upgrade on the mirror server

50003460
FIX: Extended Events session produces an empty value for data captured for certain actions

50003467
955943 (http://support.microsoft.com/kb/955943/ )
FIX: The Processes pane in the Activity Monitor incorrectly shows sessions as head blockers in SQL Server 2008

50003468
When a SQL Server 2008 policy file executes a WMI query, the policy always executes the query against the local server regardless of the intended target

50003469
957817 (http://support.microsoft.com/kb/957817/ )
FIX: You cannot expand the Facets node under the Policy Management node in SQL Server Management Studio in a non-English version of SQL Server 2008

 

 

Saludos,

Eduardo Castro – Microsoft SQL Server MVP

http://comunidadwindows.org

Costa Rica

Technorati Tags: SQL Server

LiveJournal Tags: SQL Server

del.icio.us Tags: SQL Server

http://ecastrom.blogspot.com

http://ecastrom.wordpress.com

http://ecastrom.spaces.live.com

http://universosql.blogspot.com

http://todosobresql.blogspot.com

http://todosobresqlserver.wordpress.com

Permisos necesarios para SQL Server FullText Search en un cluster

Si en un cluster se presentan los siguientes errores:

Event ID:1069
Source:Clussvc
Description: SQL Cluster Resource "Full Text" failed.

Warning: 6/18/2001 10:14:25 PM 2 3 3055 Microsoft Search N/A VIRTUALSQL10 The Gatherer property mapping file cannot be opened.
Error: 80070002. The default values are being used. You may have to copy the property mapping file from the setup CD, or reinstall the application.
Error: 6/18/2001 10:14:25 PM 1 3 3058 Microsoft Search N/A VIRTUALSQL10 The application [SQLServer] cannot be initialized.
Error: 80070002 - The system cannot find the file specified.

 

Se debe principalmente a que las cuentas del Cluster Service, el SQL Service y el SYSTEM no tienen derechos de Full Control sobre la carpeta MSSQL\FTdata y subfolders, también necesitan Full Control sobre esta entrada del registry HKLM\Software\Microsoft\Search\1.0

Saludos,

Eduardo Castro – Microsoft SQL Server MVP

http://comunidadwindows.org

Costa Rica

Technorati Tags: SQL Server

LiveJournal Tags: SQL Server

del.icio.us Tags: SQL Server

http://ecastrom.blogspot.com

http://ecastrom.wordpress.com

http://ecastrom.spaces.live.com

http://universosql.blogspot.com

http://todosobresql.blogspot.com

http://todosobresqlserver.wordpress.com

SQL Server FullText Search no puede iniciarse en un cluster

Si tienes un cluster de SQL Server 2005 en Windows 2008 puede ser que cuando se termina de instalar el servicio de FullText Search falla al iniciar y genera el siguiente error en el Event Viewer

 

The SQL Server FullText Search (SQLInst2) service depends the following service: NTLMSSP. This service might not be installed.

La solución recomendada es instalar como mínimo el SP2 de SQL Server o el SP3 tal y como se menciona en List of known issues when you install SQL Server 2005 on Windows Server 2008. También puede ser necesario editar el Registry

HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\msftesql$SQLInstancia\DependOnService

En esa llave se muestran las dependiencias por default muestra RPCSS, NTMLSSP tambien es necesario remover la entrada correspondiente a NTMLSSP

 

Saludos,

Eduardo Castro – Microsoft SQL Server MVP

http://comunidadwindows.org

Costa Rica

Technorati Tags: SQL Server

LiveJournal Tags: SQL Server

del.icio.us Tags: SQL Server

http://ecastrom.blogspot.com

http://ecastrom.wordpress.com

http://ecastrom.spaces.live.com

http://universosql.blogspot.com

http://todosobresql.blogspot.com

http://todosobresqlserver.wordpress.com

lunes, 20 de julio de 2009

SQL Server 2005 Cluster Error

 

Si durante la actualización de SQL Server Standart a SQL Server Enterprise, o durante la aplicación de un Service Pack recibes el siguiente mensaje

the setup has encountred an unexpected error while completing commit.
The error is: the cluster resource cannot be made dependent on the specified resource because it is already dependent

Tienes que a los recursos del cluster y remover las dependencias, de esa forma el instalador creará las dependencias nuevamente y no dará el error.

 

Saludos,

Eduardo Castro – Microsoft SQL Server MVP

http://comunidadwindows.org

Costa Rica

Technorati Tags: SQL Server

LiveJournal Tags: SQL Server

del.icio.us Tags: SQL Server

http://ecastrom.blogspot.com

http://ecastrom.wordpress.com

http://ecastrom.spaces.live.com

http://universosql.blogspot.com

http://todosobresql.blogspot.com

http://todosobresqlserver.wordpress.com

SQL Server Error Hotfix 3024 for SQL Server Database Services 2005 ENU (KB000000) cannot be installed or removed

Si durante una actualización de parches de seguridad o un upgrade de SQL Server Standar Edition se presenta el siguiente error en los logs de la instalación:

Hotfix 3024 for SQL Server Database Services 2005 ENU (KB000000) cannot be installed or removed

Tienes que seguir el siguiente procedimiento para corregirlo:

Instalar el SP3 de SQL Server

Instalar el Cumulative Update 1 del SQL Server 2005 SP3 http://support.microsoft.com/Default.aspx?kbid=959195

 

Saludos,

Eduardo Castro – Microsoft SQL Server MVP

http://comunidadwindows.org

Costa Rica

Technorati Tags: SQL Server

LiveJournal Tags: SQL Server

del.icio.us Tags: SQL Server

http://ecastrom.blogspot.com

http://ecastrom.wordpress.com

http://ecastrom.spaces.live.com

http://universosql.blogspot.com

http://todosobresql.blogspot.com

http://todosobresqlserver.wordpress.com

Actualizacion para el SP3

Esta disponible el Cumulative Update 1 para el SP3 de SQL Server 2005, este parche es necesario para actualizar las instancias de SQL 2005, pueden solicitarlo en la siguiente dirección.

http://support.microsoft.com/Default.aspx?kbid=959195

Cuando se presenta un error en la actualización de parches de windows o de un cluster es necesario instalar el update mencionado anteriormente.

Saludos,

Eduardo Castro – Microsoft SQL Server MVP


http://comunidadwindows.org

Costa Rica

Technorati Tags: SQL Server

LiveJournal Tags: SQL Server

del.icio.us Tags: SQL Server

http://ecastrom.blogspot.com

http://ecastrom.wordpress.com

http://ecastrom.spaces.live.com

http://universosql.blogspot.com

http://todosobresql.blogspot.com

http://todosobresqlserver.wordpress.com

Technorati Tags: ,,,,,,,,,,,,,

Windows Live Tags: Actualizacion,Esta,Cumulative,Update,Server,Default,Cuando,error,Saludos,Eduardo,Castro,Microsoft,para,necesario

WordPress Tags: Actualizacion,Esta,Cumulative,Update,Server,Default,Cuando,error,Saludos,Eduardo,Castro,Microsoft,para,necesario

viernes, 17 de julio de 2009

Actualizar SQL Express a Standard o Enterprise

Para poder actualizar SQL Express hacia una versión de SQL Server Standard o Enterprise se debe ejecutar el instalador de SQL Server Standard o Enterprise y desde la linea de comando ejecutar setup.exe SKUUPGRADE=1

Despues de eso el instalador nos permitirá realizar la actualización.

 

 

Saludos,

Eduardo Castro – Microsoft SQL Server MVP

http://comunidadwindows.org

Costa Rica

Technorati Tags: SQL Server

LiveJournal Tags: SQL Server

del.icio.us Tags: SQL Server

http://ecastrom.blogspot.com

http://ecastrom.wordpress.com

http://ecastrom.spaces.live.com

http://universosql.blogspot.com

http://todosobresql.blogspot.com

http://todosobresqlserver.wordpress.com

Technorati Tags: ,,,,,,,,,,,,,,,,,,,

Windows Live Tags: Actualizar,Standard,Enterprise,Para,Server,setup,SKUUPGRADE,,Eduardo,Castro,Microsoft,Costa,Rica,Technorati,Tags,LiveJournal,ejecutar,instalador,ecastrom,blogspot

WordPress Tags: Actualizar,Standard,Enterprise,Para,Server,setup,SKUUPGRADE,,Eduardo,Castro,Microsoft,Costa,Rica,Technorati,Tags,LiveJournal,ejecutar,instalador,ecastrom,blogspot

Blogger Labels: Actualizar,Standard,Enterprise,Para,Server,setup,SKUUPGRADE,,Eduardo,Castro,Microsoft,Costa,Rica,Technorati,Tags,LiveJournal,ejecutar,instalador,ecastrom,blogspot

Service Pack 2 de SQL Server 2005 Genera Error en Portfolio Server

Cuando se instala el Service Pack 2 de SQL Server 2005 la configuración de reporting services requerida por Portfolio Server se daña. En el Event Viewer se muestra el siguiente error:

 

“An attempt has been made to use a data extension 'PPSExtension' that is not registered for this report server.”

 

image

 

Para solucionar este error se debe editar el archivo Rsreportserver.config que se encuentra en el directorio C:\Program Files\Microsoft SQL Server\MSSQL.X\Reporting Services\ReportServer. Antes de editar este archivo debes detener el servicio de Reporting Services.

En la sección de extensiones debes incluir lo siguiente:

<Extension Name="PPSExtension" Type="Microsoft.Office.Project.PortfolioServer.Reporting.PPSConnection,Microsoft.Office.Project.PortfolioServer.Reporting"> <Configuration> <Key Name="Binaries" Value="C:\Inetpub\PortfolioServer\PortfolioServer\bin\"/> <Key Name="Config" Value="C:\Inetpub\PortfolioServer\PortfolioServer\Web.config"/> </Configuration> </Extension>

 

Saludos,

Eduardo Castro – Microsoft SQL Server MVP

http://comunidadwindows.org

Costa Rica

Technorati Tags: SQL Server

LiveJournal Tags: SQL Server

del.icio.us Tags: SQL Server

http://ecastrom.blogspot.com

http://ecastrom.wordpress.com

http://ecastrom.spaces.live.com

http://universosql.blogspot.com

http://todosobresql.blogspot.com

http://todosobresqlserver.wordpress.com

martes, 14 de julio de 2009

SQL SERVER BACKUP LOG WITH Truncate_only

 

La opción WITH TRUNCATE_ONLY ya no está soportada en SQL Server 2008, para liberar el espacio del LOG tienes que hacer un respaldo FULL o cambiar el modo de recuperación temporalmente a SIMPLE. Después de realizar esto debes hacer un Shrink del archivo LOG lo puede hacer desde el Management Studio o por medio de script.

El siguiente es un ejemplo de lo que no está soportado en SQL 2008

BACKUP LOG Test with Truncate_only
'Truncate_Only' is not a recognized BACKUP option.

Para hacer el Shrink puedes pobrar

 

dbcc shrinkfile ([DBName])

 

Saludos,

Eduardo Castro – Microsoft SQL Server MVP

http://comunidadwindows.org

Costa Rica

Technorati Tags: SQL Server

LiveJournal Tags: SQL Server

del.icio.us Tags: SQL Server

http://ecastrom.blogspot.com

http://ecastrom.wordpress.com

http://ecastrom.spaces.live.com

http://universosql.blogspot.com

http://todosobresql.blogspot.com

http://todosobresqlserver.wordpress.com

j7cx9kgd6t

j7cx9kgd6t

lunes, 13 de julio de 2009

SQL 2008 Error al restaurar la bd MSDB de una instancia a otra

Si haces un respaldo de la base de datos MSDB y la recuperas en otra instancia puede que se presente este error cuando alguien con pocos privilegios intenta ver los paquetes de jobs en el Management Studio

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
The EXECUTE permission was denied on the object 'xp_sqlagent_enum_jobs', database 'mssqlsystemresource', schema 'sys'. (Microsoft SQL Server, Error: 229)

 

Para solucionarlo MS recomienda ejecutar el siguiente script

use msdb
go
-- Backup the Agent certificate from the remote server to a file
BACKUP CERTIFICATE [##MS_AgentSigningCertificate##] TO FILE = 'MS_AgentSigningCertificate.remote_server.cer'
go
use master
go
-- re-create the agent certificate on master
-- Note: Because we are making these changes using a regular user and not as part of setup, the name
-- cannot include the ## token.
-- Creating a regular certificate in this case should be the equivalent as we only need it to derive a SID

CREATE CERTIFICATE [MS_AgentSigningCertificate.remote_server] FROM FILE = 'MS_AgentSigningCertificate.remote_server.cer'
go
-- Recreate the user mapped to the cert and grant the same permissions that the regular certificate needs.
CREATE USER [MS_AgentSigningCertificate.remote_server] FROM CERTIFICATE [MS_AgentSigningCertificate.remote_server]
go
GRANT EXECUTE TO [MS_AgentSigningCertificate.remote_server]
go

http://support.microsoft.com/default.aspx?scid=kb;en-us;2000274&sd=rss&spid=13165

Saludos,

Eduardo Castro – Microsoft SQL Server MVP

http://comunidadwindows.org

Costa Rica

Technorati Tags: SQL Server

LiveJournal Tags: SQL Server

del.icio.us Tags: SQL Server

Cambios de una tabla con el Management Studio de SQL 2008 no se pueden guardar

En SQL Server 2008 Management Studio puede ser que presente el siguiente error cuando se intenta guardar los cambios realizados a una tabla por medio del diseñador o editor gráfico.

Saving Changes in not permitted. The changes you have made require the following tables to be dropped and re-created. You have either made changes to a table that can’t be re-created or enabled the option Prevent saving changes that require the table to be re-created

Esta es una advertencia que nos indica que será necesario borrar la tabla, borrar las referencias que existan a ellas y volver a crearlas, durante este proceso se crean tablas temporales con la nueva estructura, se pasan los datos y se crean las tablas nuevas con la nueva estructura. Esta es una operación que requiere muchos recursos del servidor, es por esta razón que no se permite por defecto. Para cambiar este comportamiento tiene que cambiar la opción en Menu >> Tools >> Options >> Designers >> Uncheck “Prevent Saving changes that require table re-creation”.

image

 

Saludos,

Eduardo Castro – Microsoft SQL Server

http://comunidadwindows.org

Costa Rica

Technorati Tags: SQL Server

LiveJournal Tags: SQL Server

del.icio.us Tags: SQL Server

Cambios de una tabla con el Management Studio de SQL 2008 no se pueden guardar

En SQL Server 2008 Management Studio puede ser que presente el siguiente error cuando se intenta guardar los cambios realizados a una tabla por medio del diseñador o editor gráfico.

Saving Changes in not permitted. The changes you have made require the following tables to be dropped and re-created. You have either made changes to a table that can’t be re-created or enabled the option Prevent saving changes that require the table to be re-created

Esta es una advertencia que nos indica que será necesario borrar la tabla, borrar las referencias que existan a ellas y volver a crearlas, durante este proceso se crean tablas temporales con la nueva estructura, se pasan los datos y se crean las tablas nuevas con la nueva estructura. Esta es una operación que requiere muchos recursos del servidor, es por esta razón que no se permite por defecto. Para cambiar este comportamiento tiene que cambiar la opción en Menu >> Tools >> Options >> Designers >> Uncheck “Prevent Saving changes that require table re-creation”.

image

 

Saludos,

Eduardo Castro – Microsoft SQL Server

http://comunidadwindows.org

Costa Rica

Technorati Tags: SQL Server

LiveJournal Tags: SQL Server

del.icio.us Tags: SQL Server

domingo, 5 de julio de 2009

MVP Award 2009

Les comparto que me han renovado el MVP para el año 2009, adjunto parte del mensaje recibido

 

MVPLogo

Estimado/a Eduardo Castro,

Enhorabuena. Nos complace presentarle el programa de nombramiento MVP de Microsoft® de 2009. Este nombramiento se concede a los líderes excepcionales de la comunidad técnica que comparten de forma activa su experiencia de alta calidad y de la vida real con otras personas. Le agradecemos especialmente la contribución que ha realizado en las comunidades técnicas en el área de SQL Server a lo largo del pasado año.

 

Saludos,

Eduardo Castro – Microsoft SQL Server

Costa Rica

http://comunidadwindows.org

viernes, 3 de julio de 2009

Cómo agregar a un usuario como sysadmin en SQL Server de forma forzada

Si por algún motivo no puedes tener acceso a una instancia de SQL Server 2005 o 2008 y tienes una cuenta que es administrador local del equipo puedes seguir los siguientes pasos para agregarlo al rol de sysadmin

1. Detenga el servicio de SQL Server

2. Habra un command prompt y vaya al directorio

 SQLInstall\Microsoft SQL Server\MSSQL.X\MSSQL\Binn

3. Inicie SQL Server, si es una instancia nombrada ejecute sqlservr.exe -sNombreInstancia -m –c

Si es la instancia por default ejecute

sqlservr.exe -m –c

4. Abra otro command prompt y digite

sqlcmd -SComputerName\NombreInstancia

o lo siguiente es la instancia por default

sqlcmd –SComputerName

5. Ejecute el siguiente comando

sp_addsrvrolemember '<Login>', 'sysadmin'
GO


 



6.Cierre todas las ventanas y reincie SQL Server.





Saludos,



Eduardo Castro – Microsoft SQL Server



http://comunidadwindows.org



Costa Rica



Technorati Tags: SQL Server



LiveJournal Tags: SQL Server



del.icio.us Tags: SQL Server