SQL Server ejecutando en HyperV despliega el siguiente error Virtual machine could not be started because the hypervisor is not running. Boot Configuration Data.

Si por alguna razón usted edita el Boot Configuration Data debe ejecutar el siguiente comando después de la edición:

bcdedit /set hypervisorlaunchtype auto

Si no lo hace cuando intente levantar la máquina virtual de SQL SERVER  se desplegará el siguiente error “virtual machine could not be started because the hypervisor is not running”.

 

Saludos,

 

Ing. Eduardo Castro Martínez, PhD – Microsoft SQL Server MVP

http://mswindowscr.org

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

http://mswindowscr.org/blogs/sql/default.aspx

http://citicr.org/blogs/noticias/default.aspx

http://sqlserverpedia.blogspot.com/

SQL Server running in HyperV displays error: Virtual machine could not be started because the hypervisor is not running. Boot Configuration Data.

If for any reason you edit the Boot Configuration Data be sure to run the following command after the edit:

bcdedit /set hypervisorlaunchtype auto

If you don’t do it you will run into an error saying that your SQL Server virtual machine could not be started because the hypervisor is not running and then you will be presented with three possible errors, usually the main cause is where changes have been made to the Boot Configuration Data or BCD. This can also happen if you had sysprep'ed images with Hyper-V.

 

Regards,

 

Ing. Eduardo Castro Martínez, PhD – Microsoft SQL Server MVP

http://mswindowscr.org

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

http://mswindowscr.org/blogs/sql/default.aspx

http://citicr.org/blogs/noticias/default.aspx

http://sqlserverpedia.blogspot.com/

SQL Server Machine Fails to Boot

If you have a SQL Machine that fails to boot with the following message:

 

“The boot selection failed because a required device is inaccessible”

 

You are facing the 0xc000000f error code, also you cannot boot into the system even at subsequent attempts of restarting the system. To solve this error follow these steps:

 

Insert Windows 2008 or Windows 2008 R2 installation disc into the computer and boot the system

Choose to boot from DVD

You need to then select the time, language and currency and the desired input method

On the Windows Installation Screen choose Repair Windows Installations

Click 'Next' and select 'Repair your computer' option

The 'System Recovery Options' dialog box appears, at which you need to select the Windows installation you need to repair, if you have more than one installation you must choose the correct one. Click 'Next'.

Choose to open the Command Prompt.

Run 'Bootrec.exe' with the option

bootrec /RebuildBcd

 

There are other possible problems, you can check this article http://support.microsoft.com/kb/927392 for more details about the bootrec command

 

Regards,

Ing. Eduardo Castro Martínez, PhD – Microsoft SQL Server MVP

http://mswindowscr.org

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

http://mswindowscr.org/blogs/sql/default.aspx

http://citicr.org/blogs/noticias/default.aspx

http://sqlserverpedia.blogspot.com/

SQL Server 2008 Security Overview

In the following Power Point we try to present the main security features in SQL Server 2008, we have ommited the account management, store procedure encryption and other security features that will be covered in future presentations.

 

Sql Server 2008 Security Enhanments

View more presentations from Eduardo Castro.

 

Regards,

 

Ing. Eduardo Castro Martínez, PhD – Microsoft SQL Server MVP

http://mswindowscr.org

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

http://mswindowscr.org/blogs/sql/default.aspx

http://citicr.org/blogs/noticias/default.aspx

http://sqlserverpedia.blogspot.com/

Note: Cross posted from Eduardo Castro.

Permalink

Free SQL Server Training

If you are looking for some introductory free SQL Server Training check out this link https://www.microsoftelearning.com/eLearning/offerDetail.aspx?offerPriceId=139087 it gives you access for one year to Microsoft SQL Server 2008 Clinics, these are the main topics:

 

• What's New in SQL Server 2008 for Enterprise Data Platform
• What's New in SQL Server 2008 for Business Intelligence
• What's New in SQL Server 2008 for Database Development

 

Regards,

 

Ing. Eduardo Castro Martínez, PhD – Microsoft SQL Server MVP

http://mswindowscr.org

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

http://mswindowscr.org/blogs/sql/default.aspx

http://citicr.org/blogs/noticias/default.aspx

http://sqlserverpedia.blogspot.com/

Microsoft Security Day

The Microsoft Security was held today at Pueblo Antiguo, in this event we reviewed different Microsoft Products from the Security Perspective, among these products were Windows Server 2008 R2, SQL Server, Azure, Sharepoint and Visual Studio.

The material of the presentation can be downloaded from http://cid-bf30da8b3fc2e667.skydrive.live.com/browse.aspx/Comunidad%20Windows%20Costa%20Rica/Microsoft%20Security%20Day?uc=12&isFromRichUpload=1&lc=1033

If you want the Power Point Presentation you can downloaded from http://www.slideshare.net/ecastrom/windows-server-2008-security-overview-short-3533161

View more presentations from Eduardo Castro.

 

Regards,

 

Ing. Eduardo Castro Martínez, PhD – Microsoft SQL Server MVP

http://mswindowscr.org

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

http://mswindowscr.org/blogs/sql/default.aspx

http://citicr.org/blogs/noticias/default.aspx

http://sqlserverpedia.blogspot.com/

Converted SCSI Physical SQL Server to VHD does not boot

Recently I did converted one Physical SQL Server to VHD, but the physical machine does had SCSI drives, so after the convertion the newly virtual machine did not boot and I got the a blue screen during  boot, to solve this issue I followed these instructions http://social.technet.microsoft.com/Forums/en/winserverhyperv/thread/ef8c12f7-c45d-442e-9a30-c43cd87df3b3, keep this reference, it can be usefull.

 

Regards,

Ing. Eduardo Castro Martínez, PhD – Microsoft SQL Server MVP

http://mswindowscr.org

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

http://mswindowscr.org/blogs/sql/default.aspx

http://citicr.org/blogs/noticias/default.aspx

http://sqlserverpedia.blogspot.com/

Note: Cross posted from Eduardo Castro.

Permalink

Convert Physical SQL Server Machine to Virtual Machine

To do physical SQL Server Machine to virtual convertion you can use System Center, but if you don’t have it and you only want to a raw disk convertion you can use the Disk2VHD Tool from SysInternals, the VHD disk that this tool creates can be used as a VM for either Microsoft Virtual PC or Hyper-V.  You can download the tool from http://technet.microsoft.com/en-nz/sysinternals/ee656415%28en-us%29.aspx

 

Regards,

 

Ing. Eduardo Castro Martínez, PhD – Microsoft SQL Server MVP

http://mswindowscr.org

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

http://mswindowscr.org/blogs/sql/default.aspx

http://citicr.org/blogs/noticias/default.aspx

http://sqlserverpedia.blogspot.com/

Note: Cross posted from Eduardo Castro.

Permalink

Query Active Directory from SQL Server

If you need to access some Active Directory information from SQL Server you can use the openquery command with the ADSI provider, below is an example for doing that

 

select *

from openquery(adsi, '

select            displayName

from    ''LDAP://dc=comunidadwindows,dc=org''

where   objectCategory = ''Person''

        and

        objectClass = ''user''

        and sAMAccountName = ''useraccountname''

')

 

You also must consider the segurity required inside Active Directory to allow the SQL Server Service account access to the corresponding OU, you can do it with Active Directory Users and Computers with Advance Features Enable and choosing the Security menu as show in the following figure:

 

 

You must give read access to the SQL Server Service Account.

 

Regards,

 

Ing. Eduardo Castro Martínez, PhD – Microsoft SQL Server MVP

http://mswindowscr.org

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

http://mswindowscr.org/blogs/sql/default.aspx

http://citicr.org/blogs/noticias/default.aspx

http://sqlserverpedia.blogspot.com/

Note: Cross posted from Eduardo Castro.

Permalink

SQL Azure FAQ

SQL Azure es SQL SQL Server en la nube, para aquellos que inician con SQL Azure estas son las respuestas a las FAQ más comunes:

1. El tamaño máximo de las bases de datos es 1GB o 10GB, dependiendo de su suscripción, si necesita almacenar más datos deberá crear Shards http://en.wikipedia.org/wiki/Shard_%28database_architecture%29
2. Se pueden crear todas las bases de datos que desee, pero no necesariamente estarán en el mismo servidor, esto debido al modelo de balance de carga de SQL Azure
3. No se pueden hacer consultas entre base de datos ni entre servidores
4. No hay Transparent Data Encryption
5. Soporta un subconjunto muy completo de T-SQL pero no todos, http://blogs.msdn.com/ssds/archive/2009/07/07/9823115.aspx
6. Soporta un subconjunto de SQL Types pero no todos, http://blogs.msdn.com/ssds/archive/2009/07/07/9823115.aspx

 

For those who are starting with SQL Azure, these are the answers to most common FAQ:

 

Database maximum size is 1GB or 10GB based on your price plan, if you need to handle larger databases you must use Shards

    http://en.wikipedia.org/wiki/Shard_%28database_architecture%29

Unlimited number of databases, but they may not be on the same server, this is because the SQL Azure Balancing Mode

Currently you cannot do cross-database querying

There is no TDE in SQL Azure 

It supports a subset of SQL Server’s T-SQL commands, more detail in http://blogs.msdn.com/ssds/archive/2009/07/07/9823115.aspx

It supports a subset of SQL Server’s datatypes, more detail in http://blogs.msdn.com/ssds/archive/2009/07/07/9823115.aspx

 

Saludos,

Ing. Eduardo Castro Martínez, PhD – Microsoft SQL Server MVP

http://mswindowscr.org

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

http://mswindowscr.org/blogs/sql/default.aspx

http://citicr.org/blogs/noticias/default.aspx

http://sqlserverpedia.blogspot.com/