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