text:
Even more good news!
"Last night Sony made a big point of its no-DRM policies for PlayStation 4 -- including putting up a playful video featuring two of its executives, Adam Boyes and Shuhei Yoshida, which you can see above.
SCEA CEO Jack Tretton's announcement of its DRM-free policies elicited a big cheer at its press conference last night."


text:
Joe Barksdale, left, and LSU teammate Kelvin Sheppard carry the Cotton Bowl trophy after beating Texas A&M, 41-24, in January.
- Filed Under
Joe Barksdale has had the date circled on his calendar from the minute the Oakland Raiders drafted him in the third round: Dec. 18, when the Detroit native plays his first game against his hometown Lions.
"I'm looking forward to it," Barksdale said last week at the Sound Mind, Sound Body football camp at Southfield High. "Anytime you get to be on the same field as a team that you grew up watching, it's always a pleasure."
Barksdale, who starred at Detroit Cass Tech before playing at LSU, said he already has his strategy figured out for all the ticket requests he expects that week. ...

subset: commoncrawl


text:
|Caryophyllaceae (kar-ree-oh-fil-AY-see-ee) (Info)
|Dianthus (dy-AN-thus) (Info)
|Elation White
|Additional cultivar information:
|(Elation Series)
This plant is attractive to bees, butterflies and/or birds
Flowers are fragrant
Average Water Needs; Water regularly; do not overwater
12-18 in. (30-45 cm)
15-18 in. (38-45 cm)
USDA Zone 7a: to -17.7 �C (0 �F)
USDA Zone 7b: to -14.9 �C (5 �F)
USDA Zone 8a: to -12.2 �C (10 �F)
USDA Zone 8b: to -9.4 �C (15 �F)
USDA Zone 9a: to -6.6 �C (20 �F)
USDA Zone 9b: to -3.8 �C (25 �F)
USDA Zone 10a: to -1.1 �C (30 �F)
USDA Zone 10b: to 1.7 �C (35 �F)
Full Sun
Sun to Partial Shade
Parts of plant are poisonous if ingested
White/Near White
Late Winter/Early Spring
Mid Spring
Late Spring/Early Summer
Mid Summer
Late Summer/Early Fall
Mid Fall
Late Fall/Early Winter
Blooms repeatedly
6.1 to 6.5 (mildly acidic)
6.6 to 7.5 (neutral)
7.6 to 7.8 (mildly alkaline)
From seed; sow indoors before last frost
From seed; direct sow after last frost
Allow seedheads to dry on plants; remove and collect seeds
N/A: plant does not set seed, flowers are sterile, or plants will not come true from seed
This plant has been said to grow in the following regions:
Richmond, Texas
No details have been posted.


text:
About 20 anti-abortion activists protested outside a new clinic yesterday, some holding signs equating the procedure to killing children.
Protesters would like to see MetroWest Women's Health Services closed, but "in the meantime, the worst thing would simply be to allow them to continue to kill in tranquility," said protester Bill Cotter, president of the anti-abortion organization Operation Rescue: Boston.
Cotter said Dr. Marcus Gordon opened the Natick facility, his fourth location in Massachusetts. Yesterday was the protesters' second gathering in Natick.
A woman who answered the phone at MetroWest Women's Health Services said the facility performs abortions in Natick, but referred comment to an office manager who did not return a message.
The business, whose website lists birth control, pregnancy tests and other services in addition to abortions, is located in a condominium building at the same Union Street address as MetroWest Medical Center's Natick campus.
The hospital does not own that building, and the new business is not affiliated with it, hospital officials said.
Megan Amundson, executive director of NARAL Pro-Choice Massachusetts, said the new clinic could help low-income women who do not have the ability to travel into Boston for services.
"We're very pleased that a new clinic has opened up that serves the basic reproductive health of women in that community," Amundson said. "I think there aren't enough clinics that serve basic reproductive health."
Amundson said she had spoken with Gordon about his new clinic opening in Natick.
Protester Joseph Hamel of Natick said he hoped to convince doctors in the condominium building to oppose Gordon's practice.
"We feel sorry for the baby. We feel love for the mother and even for the abortionist," said Hamel, 74. "It's not hate. It's love."
Cotter acknowledged it will be difficult to close the facility. But protesters are committed to making the issue known and plan to protest again next Tuesday.
"It's admittedly an uphill battle because he does own the property and abortion is legal," Cotter said.
On Thursday afternoon, the center's staff issued the following press release regarding the protest:
"Our new clinic that opened in Natick is committed to serving the reproductive health needs of women through a variety of services including birth control counseling, annual exams, STI testing, and abortion care. Though we understand abortion care is a controversial topic and can inspire protests like the one mentioned, we believe in the fundamental right of women to make their own medical choices. We respect everyone's right to their own opinion but will continue to serve the needs of our patients."
Page 2 of 2 - (Brian Benson can be reached at 508-626-3964 or email@example.com.)
Comments are currently unavailable on this article
Location, ST | website.com


text:
Ben Stiller On Set
Like us on Facebook
The hardest working comedian is set to work overtime in 2006. According to imdb (not the most reliable source) he has 4 movies in the works. One now includes Ricky Gervais from The Office. Here are some pics of Ben working on a film in Central Park.
2 more so


text:
Jon Excell
The Engineer
Crossrail trains deal "shot in the arm" for UK rail sector
The Department for Transport's 2013 decision to award the £1.6bn Thameslink trains contract to Siemens was widely viewed as something of a disaster for Bombardier, the UK's last remaining train manufacturer.
In truth, the Derby firm had been all but ruled out of the bidding process as early as 2011 when Siemens was awarded preferred bidder status. And despite being hailed by then transport secretary Theresa Villiers as representing "the best value for money for taxpayers" the decision pushed Bombardier's historic Litchurch lane works to the brink, led directly to the loss of 1,400 jobs, and prompted wider questions about whether government procurement practices were letting down British industry.
Yesterday's announcement from Transport For London that Bombardier has won the £1bn contract to build the Crossrail fleet, is therefore a welcome shot in the arm for both the Canadian-owned train manufacturer, Derby and the UK's fragile rail sector in general. A failure to award the contract to the British firm would also have been hugely embarrassing to a government that has repeatedly pledged to put manufacturing at the heart of a rebalanced UK economy.
Having beaten off stiff competition from Japan's Hitachi and Spanish firm CAF, the Derby firm will - assuming the 10 day standstill period passes without any hiccups - supply, deliver and maintain 65 trains as well as build a new maintenance depot at Old Oak common in North West London. The deal is expected to support over 1000 jobs and around 100 apprenticeships, and with Bombardier claiming that around three quarters of the contract spend will remain in the UK economy, it represents great news for the firm's supply chain.
Beyond this, the deal also arguably broadens the impact and national relevance of Crossrail, and - with the hand-wringing over HS2 continuing - provides a timely reminder of the kind of spin-off economic benefits that can be generated through sustained investment in infrastructure.
With Crossrail expected to begin operating towards the end of 2018, Derby's skilled rail engineers look set for an exceptionally busy time, and we look forward to covering this British manufacturing success story in detail over the coming months and years.
Readers' comments (3)
Excellent news all round and an example of how things should be done. An excellent project, long term vision that supports our industries and is good for the economy.
What a pity that we no longer have a British OWNED train design and manufacture business, then the profit would be here, and could be re-invested in British Industry. Yes, it is good in the short-term, but we do hope to be around for a long time! Had APT not been cancelled, things could have been SO different.
Very welcome news for the UK, I just hope that there are enough Engineers and skilled manufacturing personnel left in the east midlands to fill the needs of Bombardier - after all JCB, Toyota and a host of other prime and internationally respected firms are already working profitably in the area. Mind you it is a beautiful place to live, and there is loads of room for people to move to - I have never regretted it :)
My saved stories (Empty)
You have no saved stories


text:
Join Now
Join ePHOTOzine, the friendliest photography community.
Upload photos, chat with photographers, win prizes and much more for free!
Get the new ON1 Photo 10 and Save $100 Today. Use Code: GetPhoto10 View Offer
perhaps for this bird the weather became a bit too much of a challenge and decided to
get onshore; this image is a rather hefty crop from a scan of a slide and in suppressing
the excessive grain the image acquired a bit of a painting feel which I do rather
like. Talking about challenge: yesterday watched the docudrama "Touching the Void",
a very impressive story and portrayed equally impressive.
thanks for looking & being here
|the story of challenge
|3 Nov 2013 - 12:03 PM
|General, Wildlife / nature
|VS Mode Rating
101 (66.67% won)
These stats show the percentage of wins and the rating score that your photo has achieved. You can go to the VS Mode by clicking on this icon.
Signup to PlusBecome a plus member to see which photo this has won or lost against in the vs mode
There are no comments here! Be the first!
- Original Poster Comments
- Your Posts
Add a Comment
ePHOTOzine, the web's friendliest photography community.
Upload photos, chat with photographers, win prizes and much more.


text:
February 12, 2015
My Olympus sz-15 died in the middle of my trip to Tanzania. I was photographing giraffes when it started to flicker and quit every time I tried to turn it on. It was less than 2 years old.
April 28, 2014
I don't know why all these people are leaving bad reviews evaluate this is the best camera I have ever had! I love it SOOOOO much it takes the best pictures! I went to Disney last week and took so many picture and they all turned out wonderful! The camera had great flash amazing settings take fantastic pictures and il never leave this camera behind it shall be my buddy!!
April 16, 2014
Have to hold breath & shoot. Good pictures of Alaska. Glaciers from our truck, far away & up close, all look good. I couldn't believe the distance. I had an Olympus before and liked it, but only 3x zoom. This 24x is great! Pictures of clouds & moose. Thank you. Couldn't get a second battery for it though.
February 01, 2014
I had very high hopes for this camera based on my very positive experiences with two previous Olympus cameras, but in the end was very disappointed. Auto focus was inconsistent leaving pictures without good definition. Colors were washed out compared to scenes being photographed. Video focus was constantly hunting, resulting in playback that was sometimes very sharp, and others almost unrecognizable. It has lots of great functions for taking photos, but unfortunately, that functionality didn't result in good pictures on many occasions. On the other hand, some pictures came out great and were real keepers, but the inconsistency drove me crazy. I'm not a professional photographer, but I do enjoy photography and have been engaged in the hobby for a long time. This camera was not going to allow me to enjoy my avocation. I returned it for a refund after three weeks and many disappointing photos while on vacation.
January 14, 2014
I got this camera to use on my daily walks, I like the range of the zoom, As I see various wildlife. Also the super macro for photographing insects and flowers, along the roadside. It fits in my shirt pocket, in cold weather able to keep it warm. Missing out on photo ops will not be a problem.
January 07, 2014
My first my son got me for Christmas, was overjoyed! It sucks, I have tried and tried, blurry pictures, it zooms in and out on its own and by the time it stops doing its thing is too late to take a picture then comes out blurry. Love my sons Sony Syber shot that is ancient and love how crisp and clear the pictures and videos are. Took one or 2 videos with this and can hear the shutter noise and if you try to zoom it goes all blurry same as when I try to take a picture, just hate he spent all that money on this camera and how the heck to you tell someone after all that trouble that this camera sucks!!! He was so proud of it bought the case too.
December 26, 2013
Got the camera and got blurry photos and videos that were not synched with the audio. Returned it and got a replacement of the same camera and the same result. This is a bad camera and
I have lost Circus and Christmas photos and videos due to this defective product. Memories that I cannot redo in photos and videos of the grandchildren.
December 17, 2013
I bought this Camera a few weeks ago. This camera meets all my needs for a novice photographer. The zoom works very well and the quality of the photos even in low light are great. I would recommend this camera to everyone.
December 12, 2013
Am not impressed with photo quality especially with flash. My 8 year old Sony Cyber Shot takes much better pics. The control button is a bit erratic and doesn't seem to respond properly. When taking video the sound of the lens adjusting is heard in the audio. Advertised as "wide angle" but doesn't seem to take a wider shot than my Sony Cyber Shot. Separate battery charger is a bit expensive.
November 09, 2013
11-9-13...just got this camera......I have noticed that I have to take multiple photos JUST to get the right quality...the first one might be blurry, the next one might be too dark...the flash doesn't flash every time....the auto mode is not good to me......when I want it to flash it does not.......i am using a 64mb memory card....when I the movie mode it is constantly trying to focus so as I am watching the movie I taped it is constantly going in and out of blurriness......Teresa in Florida


text:
Advanced simulation techniques to address the inflation challenge and gold-based investments
There is a rich seam to be mined in the provision of tools to calculate counterparty credit risk. Clive Davidson looks at what's on offer so far, and what could be coming on to the market.
TORONTO - Canadian risk management software company Algorithmics said in October that Denmark-based Danske Bank had licensed its Algo Collateral software system to manage their over-the-counter deri...
More Mark-to-future articles
A treacherous credit environment and growing awareness of the danger of credit and market risk correlation have convinced financial institutions that they need to evaluate these exposures together. ...
Risk management software suppliers will need to improve their products to meet the demands of Basel II.
This whitepaper reviews the fundamental changes of Liquidity Risk Management under Basel III. It discusses how institutions can meet the regulatory requirements on liquidity risk management by enhancing their liquidity risk analytics, funds transfer pricing methodologies, liquidity stress testing frameworks, and enterprise risk management platforms.


text:
May 23, 2013
Chris Yerga, engineering director of Android, speaks about Google Play Music at Google I/O 2013 in San Francisco, Wednesday, May 15, 2013. (AP Photo/Jeff Chiu)
Stories this photo appears in:
Review: Google music plan solid, serendipitous
Thursday, May 23rd, 2013 1:16 a.m.
Google Inc.'s new music service offers a lot of eye candy to go with the tunes. The song selection of around 18 million tracks is comparable to popular services such as Spotify and Rhapsody, and a myriad of playlists curated along different genres provides a big playground for music lovers.


text:
Sarkozy innocent till proven guilty - HollandeComment on this story
Paris -
French President Francois Hollande said on Wednesday that his predecessor Nicolas Sarkozy should be seen as innocent until proven guilty after being charged with corruption and influence peddling.
In a cabinet session, Hollande insisted to ministers on "the independence of the judiciary... and the presumption of innocence," government spokesman Stephane Le Foll said. - Sapa-AFP
Comment Guidelines
- Please read our comment guidelines.
- Login and register, if you haven' t already.
- Write your comment in the block below and click (Post As)
- Has a comment offended you? Hover your mouse over the comment and wait until a small triangle appears on the right-hand side. Click triangle () and select "Flag as inappropriate". Our moderators will take action if need be.
- Verified email addresses: All users on Independent Media news sites are now required to have a verified email address before being allowed to comment on articles. You are only required to verify your email address once to have full access to commenting on articles. For more information please read our comment guidelines


text:
All hotels in Gallup, New Mexico, United States of America
1 room, 2 adults
3010 E Historic Highway 66, Gallup, NM, 87301, United States of America, 855-238-1590
Days Inn And Suites Red Rock-Gallup
Lowest price$50
Best Price Guarantee
City-center Gallup hotel with indoor pool
- Free continental breakfast, free WiFi, and free parking
A great choice for a stay in Gallup, Days Inn And Suites Red Rock-Gallup features a free airport shuttle. You can get a morning swim in at the indoor pool, and the spa tub makes for a relaxing end to the day. Flat-screen TVs, refrigerators, and free WiFi are offered in all rooms.
Main amenities
- 75 guestrooms
- Indoor pool
- Free airport shuttle
- 24-hour business center
- 24-hour front desk
- Coffee/tea in the lobby
- Air conditioning
- Daily housekeeping
- Computer station
- Front desk safe
- Self-serve laundry
- Multilingual staff
What's around
- Heart of Gallup
- Gallup Cultural Center (2.9 mi / 4.6 km)
- Fire Rock Navajo Casino (3.6 mi / 5.7 km)
- Red Rock State Park (5.2 mi / 8.4 km)
Perfect for a one nighter. Large pool!
Room was great..
TripAdvisor Traveller Rating: 3
From 281 reviews
Enter dates to check prices
Hotel Info: 866-539-8117from $50
- Room, 1 King Bed, Refrigerator
- Room, 2 Queen Beds, Accessible
- Suite, 1 King Bed, Balcony
- Deluxe one therapeutic king smoking
- Suite
- Suite, 2 Queen Beds
- Standard Room, 2 Queen Beds, Smoking
- Deluxe Room, 2 Queen Beds
- Standard Room, 2 Queen Beds
- Suite, 1 King Bed
- Deluxe Room, 1 King Bed
- Standard Room, 1 King Bed
Also popular with travelers from the USA
At a glance
Key facts
Hotel size
- This hotel has 75 rooms
- This hotel is arranged over 2 floors
- Check-in time starts at 3:00 PM
- Check-out time is 11:00 AM
- Express check-out
Required at check in
- Credit card or cash deposit required
- Government-issued photo ID required
Travelling with others
- Pets allowed *
- Free WiFi in public areas
- Free WiFi in rooms
- Free airport shuttle
- Free self parking
- Accessible parking
- Free RV/bus/truck parking
- Free casino shuttle
In the hotel
Food and drink
- Free continental breakfast daily
- Coffee/tea in the lobby
Things to do
- Indoor pool
- Spa tub
Working away
- 24-hour business center
- Computer station
- 24-hour front desk
- Laundry facilities
- Free newspapers in lobby
- Year Built 1990
- Safe-deposit box at front desk
- Designated smoking areas
- Television in common areas
- Disabled parking
- Accessible path of travel
- Braille or raised signage
- Accessibility equipment for the deaf
- Accessible bathroom
- In-room accessibility
In the room
Home comforts
- Climate control
- Air conditioning
- Coffee/tea maker
- Iron/ironing board
Sleep well
- Blackout drapes/curtains
Freshen up
- Shower/tub combination
- Free toiletries
- Hair dryer
Be entertained
- 32-inch flat-screen TV
- Pay movies
- Premium TV channels
Stay connected
- Free weekday newspaper
- Free WiFi
- Free local calls
Food and drink
- Refrigerator
- Daily housekeeping
Days Inn And Suites Red Rock-Gallup's small print
Also known as
- Days Inn Red
- Days Inn Red Hotel
- Days Inn Red Hotel Rock-Gallup
- Days Inn Red Rock-Gallup
Optional extras
Rollaway beds are available for USD 10.00 per day
TV service is available for an extra charge of USD 2.00 per night
Pets are allowed for an extra charge of USD 10.00 per pet, per night
We have included all charges provided to us by this hotel. However, charges can vary, for example, based on length of stay or the room you book.


text:
February 22, 2011
Angie Machado
One of the highest rated prospects in the 2010 class was linebacker Shaydon Akuna from Kapolei, Hawai'i. The four-star athlete was courted by some of the top programs in the Nation and on signing day announced that he would be a Beaver.Akuna entered fall camp ready, although it was evident that he would most likely redshirt in order to spend a year in the weight room. He was bothered by injury throughout part of fall camp, but you could tell that he was a fast, athletic linebacker that the Beaver defense has relied upon for so many years. ...More... To continue reading this article you must be a member. Sign Up Now!
Already a member? Click here to sign in


text:
Sign in now to view, license and download this image or contact us to see this image without a watermark. Want to embed this image on a non-commercial website or blog? Learn more.
Similar imagesView all
A Rare Species Of Lionfish On The Sandy Bottom Of Suruga Bay Stock PhotoAnimal Fin,Animals In The Wild,Aquatic,Bay of Water,Blurred Motion,Close-up,Color Image,Honshu,Horizontal,Izu Peninsula,Japan,Lionfish,Nature,No People,Ocean Floor,One Animal,Photography,Rear View,Sea Life,Suruga Bay,Swimming,Underwater,WaterPhotographer Brian J. SkerryCollection: National Geographic Izu Peninsula, Honshu, Japan.


text:
International Flower Shops
Australian & worldwide flower delivery from Flower Petals online flower store. Same day & next day Delivery on arrangements, bouquets, roses & gift baskets for Mothers Day & Valentines Day
Florist that deliver flowers direct to London and nationwide UK direct next day. Order flowers online, send flowers made by our florists and delivered direct.
Buy, order and send flowers online throughout the UK. Select from our exclusive range of fresh flower hand tied bouquets, chocolates, champagne and fruit baskets


text:
SQL Server Maintenance Plans bring an easy way to DBAs to quickly setup routine maintenance activities in the database. Starting SQL Server 2005 maintenance plans are created as SQL Server Integration Services packages and could be executed in the same way as any other SSIS package:
In the case I want to discuss now I was trying to run a maintenance plan package using the dtExec.exe utility. My goal was to execute a backup task using this maintenance plan and running this from command prompt did not show any error but did not perform any backup either. This was the syntax I was using and the results:
C:\>dtexec /SQL "Maintenance Plans\Backup MP" /Server SQL2005\YUKON Microsoft (R) SQL Server Execute Package Utility Version 9.00.3042.00 for 32-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved.
Started: 15:21:20 DTExec: The package execution returned DTSER_SUCCESS (0). Started: 15:21:20 Finished: 15:21:51 Elapsed: 31.046 seconds
My first thought was, "do I need to have SSIS service running in order to execute this maintenance plan package"? but Microsoft Knowledge Base article KB942176 clearly states that SSIS service is not required for this:
"If you only want to design and to execute SSIS packages, you do not have to start the SSIS service. When the SSIS service is stopped, you can run SSIS packages by using the following utilities: - The SQL Server Import and Export Wizard - The SSIS designer - The Execute Package utility (DTExecUI.exe) - The DTExec.exe command prompt utility"
"If you only want to design and to execute SSIS packages, you do not have to start the SSIS service. When the SSIS service is stopped, you can run SSIS packages by using the following utilities:
- The SQL Server Import and Export Wizard - The SSIS designer - The Execute Package utility (DTExecUI.exe) - The DTExec.exe command prompt utility"
When you create a maintenance plan using SQL Server Management Studio you will see that the corresponding task or tasks associated with that maintenance plan are created as a SQL Server Agent job:
You can easily find what specific dtexec.exe parameters are provided on the maintenance plan just by looking into the SQL Server Agent job properties, on the "Command line" option for the subplan definition:
I checked that by running this sentence as the dtexec.exe parameter successfully run the backup job, in my case this is the command prompt instruction I used:
DTEXEC.EXE /SQL "Maintenance Plans\Backup MP" /Server SQL2005\YUKON /SET "\Package\Subplan_1.Disable";false
The "tricky" part here refers to the /SET switch. As you can find in the maintenance plan GUI each maintenance plan has one or more subplans associated and this/theses are disabled by default so you need to enable them by issuing the "false" option for the "Disable" property of this subplan. Remember that each subplan defined in the maintenance plan creates a job under SQL Server Agent.
We can perform the same action right-into the SSIS package associated to the maintenance plan using SQL Server Business Intelligence Development Studio (BIDS):
- Open BIDS - Create a new empty SSIS project - Add the existing maintenance plan package to the Project files list by using Solution Explorer; the maintenance plan will be added as a new SSIS Package - Modify the "Disable" property of the subplan so it is equal to "false" - Save the SSIS package as a maintenance plan in SQL Server - Run the maintenance plan without the need of specifying the /SET "\Package\Subplan_1.Disable";false switch
Here again I am trying to shed some light on another SQL Server 2005 setup error that you may encounter during your Service Pack or Hotfix deployment.
As you may know, one of the differences between installing a SQL Server instance on a standalone server vs. a cluster server is the service accounts required to run the different SQL Server services. While we are free to use local Windows accounts to run a non-clustered SQL Server instance, we are required to use a Windows Domain account to run a clustered SQL Server instance. This is better explained in the following KB article (KB910708, You must specify the domain groups for the clustered SQL Server services when you install a SQL Server failover cluster):
When you install a stand-alone instance of SQL Server, the SQL Server Installation Wizard creates a set of local groups. The wizard also adds service accounts to the groups. When you install a SQL Server failover cluster, SQL Server requires domain accounts to start the services. The domain accounts must be added to a domain group.
When you install a stand-alone instance of SQL Server, the SQL Server Installation Wizard creates a set of local groups. The wizard also adds service accounts to the groups. When you install a SQL Server failover cluster, SQL Server requires domain accounts to start the services. The domain accounts must be added to a domain group.
So it is not only important to have domain accounts in place to run the different SQL Server services but also to have a Domain group where these accounts are placed. It is also highly recommended to do not use this group to store other application's accounts.
In this case the domain group and accounts were already in place but the installation of SQL Server 2005 Service Pack 3 (SP3) was failing with the following error message on the Summary.txt setup log file:
Product : Database Services (MSSQLSERVER) Product Version (Previous): 4035 Product Version (Final) : Status : Failure Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\SQL9_Hotfix_KB955706_sqlrun_sql.msp.log Error Number : 28130 Error Description : MSP Error: 28130 A domain group is missing for one or more services. To install SQL Server 2005 as a failover cluster, domain groups must be specified for all the clustered services being installed .To proceed, enter the missing domain group information. The domain group cannot be validated for the service SQL Server.
What was wrong then? To better understand this issue we need to take into account what information for these groups is stored on Windows registry. The setup program writes this information in the registry during the initial SQL Server installation, here you can find a description of these keys, found under HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.X\Setup:
As you can see, there are three different registry keys called AGTGroup, FTSGroup and SQLGroup that store the SID information for the SQL Server Agent, Fulltext Search and SQL Server groups in Active Directory respectively. These entries are used by the SQL Server setup during subsequent Hotfix or Service Pack updates.
In our case we could verify that these three registry keys were missing in both cluster nodes.
Ok, so I just need to add the missing registry keys for the Domain group but, how can I get the SQL Server group SID? You can use different techniques to get this information but in my case I found getsid.exe utility to be extremely easy to use. You can get getsid.exe on the Windows Support Tools; after downloading the tool you just need to type the following instruction on any server or PC that belongs to the same domain:
getsid.exe \\localhost CONTOSO\SQLGroup \\localhost CONSOTSO\SQLGroup
Where CONTOSO refers to the Windows Domain name and SQLGroup refers to the group used to store the SQL Server service accounts. You should get an output similar to the following one:
getsid \\localhost CONTOSO\SQLGROUP \\localhost CONTOSO\SQLGROUP The SID for account CONTOSO\SQLGROUP matches account CONTOSO\SQLGROUP The SID for account CONTOSO\SQLGROUP is S-1-5-21-3321254763-463695806-1538882281-2787112 The SID for account CONTOSO\SQLGROUP is S-1-5-21-3321254763-463695806-1538882281-2787112
Sysinternals PsGetSid will be also of help if you cannot make getsid running for some reason. After you get this information, you can add the missing registry keys into HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.X\Setup as follows:
[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.1\Setup] "AGTGroup"="S-1-5-21-2777104479-2157580501-946951792-1110" "SQLGroup"="S-1-5-21-2777104479-2157580501-946951792-1110" "FTSGroup"="S-1-5-21-2777104479-2157580501-946951792-1110" ...
Important: You probably do not want to end up with your cluster down just because you incorrectly tampered the registry to fix a setup problem right? Please, take extra-ordinary caution when modifying the registry and always make sure you have a backup of it in place. For more information please, refer to KB310516.
Note: If your server is a 64-bits server you do not need to take into account any registry below HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node.
Another Note: The registry information for these keys is not replicated during cluster failover so you will need to add the same information on each one of the clustered nodes.
Disclaimer Remainder: Please, be aware that according to Microsoft Knowledge Base article KB925976 the recommended workaround to fix this issue is to reinstall the clustered instance of SQL Server 2005. The information described here is provided with no warranty and it may not work on your environment.
I think it could be interesting to share this SQL Server 2005 setup error since the message written in the setup logs was not clearly exposing the root-cause of the issue.
In this case my customer was trying to update to Service Pack 3 (SP3) a SQL Server 2005 clustered instance. The error that we could see on the Hotfix.log SP3 setup log:
10/20/2009 12:05:18.655 MSP Error: 29527 The setup has encountered an unexpected error in datastore. The action is RestoreSetupParams. The error is : Source File Name: datastore\cachedpropertycollection.cpp Compiler Timestamp: Mon Nov 17 17:05:55 2008 Function Name: CachedPropertyCollection::findProperty Source Line Number: 130 ---------------------------------------------------------- Failed to find property "OwningGroup" {"VirtualServerInfo", "", "CONTOSOSQL"} in cache Source File Name: datastore\clusterinfocollector.cpp Compiler Timestamp: Mon Nov 17 17:05:55 2008 Function Name: ClusterInfoCollector::collectClusterVSInfo Source Line Number: 888 ---------------------------------------------------------- Failed to detect VS info due to datastore exception. Source File Name: datastore\clustergroupsproperties.cpp Compiler Timestamp: Mon Nov 17 17:05:55 2008 Function Name: ClusterGroupScope.SharedDisks Source Line Number: 56 ---------------------------------------------------------- Failed to fin 10/20/2009 12:05:18.843 Attempting to continue the 32 bit ngen queue 10/20/2009 12:05:18.905 Attempting to continue the 64 bit ngen queue
Please, pay attention to the button of the log highlighted in blue color; as you can see the latest paragraph seems to be incomplete. You can find this situation with some error messages in setup log files and the best option it to look up the same error on the Application Event Log, where we will usually see the complete message; in our case this was the error:
Failed to find property "OwningGroup" {"VirtualServerInfo", "", "CENSVXISQL"} in cache Source File Name: datastore\clusterinfocollector.cpp Compiler Timestamp: Mon Nov 17 17:05:55 2008 Function Name: ClusterInfoCollector::collectClusterVSInfo Source Line Number: 888 ---------------------------------------------------------- Failed to detect VS info due to datastore exception. Source File Name: datastore\clustergroupsproperties.cpp Compiler Timestamp: Mon Nov 17 17:05:55 2008 Function Name: ClusterGroupScope.SharedDisks Source Line Number: 56 ---------------------------------------------------------- Failed to find a cluster group that owned shared disk: D:
Clearly, the next step was to check what was wrong with server's D: drive. In our case this drive was a clustered shared disk, not a local one and it was part of the SQL Server 2005 cluster group. At first sight, everything was fine with this resource, but looking in more detail into the cluster configuration we could see what was wrong:
Resource: --------- Disk D: { Physical Disk } +(1)-----Depends On-> SQL Server Fulltext { Generic Service }
For some reason, the SQL Server Fulltext Search service (FTS) was configured as a dependency for "Disk D:" resource. This is not correct, as you can verify on one of my previous post and in Microsoft Knowledge Base article KB835185, Failover cluster resource dependencies in SQL Server:
The SQL IP address resource and the physical disk resources do not depend on any resources
The SQL IP address resource and the physical disk resources do not depend on any resources
After eliminating this dependency on cluster resource "Disk D:" we were able to successfully install SQL Server 2005 SP3.
This case taught me a very useful lesson about how impersonation works when executing a SQL Server Job using a linked server. If this scenario is new for you too, I hope you enjoy learning as much as I did.
In this case my customer was trying to run a stored procedure using a linked server from a local SQL Server 2005 instance to a remote SQL Server 2000. The stored procedure ran just fine when executed from SQL Server Management Studio (SSMS) but failed when ran as a SQL Server Agent Job.
These kind of mistakes are common in SQL Server when the SQL Server Agent account does not have enough permissions to execute the required Job. For example, when running a T-SQL statement that performs some kind of action on a remote server's share, the credentials used to logon on the remote share are the ones of the user that opens SSMS; in other words, the user we have used to logon in our Windows session. However, when the statement is executed within a SQL Server Job, the credentials being used are the ones for the SQL Server Agent account, which is the account in charge of running jobs. This can be found on the following link:
[…] if you create a job that requires a drive letter or a universal naming convention (UNC) path, the job may run under your Microsoft Windows NT® 4.0 or Windows® 2000 user account while testing it. When SQL Server Agent then runs the job, it may not have the necessary permissions, drive letter configurations, or access to the required drive to execute the job.
[…] if you create a job that requires a drive letter or a universal naming convention (UNC) path, the job may run under your Microsoft Windows NT® 4.0 or Windows® 2000 user account while testing it. When SQL Server Agent then runs the job, it may not have the necessary permissions, drive letter configurations, or access to the required drive to execute the job.
There is additional information that needs to be taken into account when running a statement in SQL Server Management Studio vs. running the T-SQL code within a SQL Server Agent Job, this is described in Knowledge Base article KB269074:
The security context in which the job is run is determined by the owner of the job […] If the job is owned by an account (either a SQL Server login or a Windows NT authenticated login) that is a member of the Sysadmin role, the SQL Agent job runs under the context of the account used to start the SQL Agent service.
The security context in which the job is run is determined by the owner of the job […] If the job is owned by an account (either a SQL Server login or a Windows NT authenticated login) that is a member of the Sysadmin role, the SQL Agent job runs under the context of the account used to start the SQL Agent service.
When the job is not owned by an account with sysadmin privileges, we can find a problem similar to the following one when running the job:
Remote access not allowed for Windows NT user activated by SETUSER. [SQLSTATE 42000] (Error 7410). The step failed.
Remote access not allowed for Windows NT user activated by SETUSER. [SQLSTATE 42000] (Error 7410). The step failed.
There is a Knowledge Base article that explains how to workaround this error (see KB811031). In our case, the error was quite different though:
Error: 7416, Severity: 16, State: 1 Access to the remote server is denied because no login-mapping exists
Error: 7416, Severity: 16, State: 1 Access to the remote server is denied because no login-mapping exists
I did a basic review to understand what was the configuration of both the SQL Server Agent Job and Linked Server, in our case this was what we had:
Concerning the linked server security configuration, my customer only had the "elearning" login on the security properties for the Linked Server, any other login attempt was denied:
In this case we discovered that adding the SQL Server Agent account to the list of authorized users in the linked server security properties allowed us to run the job successfully. This makes sense because the SQL Server Account credentials are the ones used to execute the job in this case however, this lead to a security problem since a non-authorized user on the remote server could use the linked server connection to perform actions he has no rights to perform by default. In other words, having the SQL Server Agent account as authorized on the linked server allows the use of that linked server connection by any job where the owner is part of the sysadmin group.
My first thought was to use a SQL Server Agent Proxy account to work around the issue but T-SQL statements cannot make use of Proxies:
Job steps that execute Transact-SQL do not use SQL Server Agent proxies. Transact-SQL job steps run in the security context of the owner of the job.
Job steps that execute Transact-SQL do not use SQL Server Agent proxies. Transact-SQL job steps run in the security context of the owner of the job.
In our case the job owner was sa account so the Job was being run under the credentials of SQL Server Agent account however, the linked server only granted remote access to the "elearning" login. In addition to this, when configuring the advanced Job step properties using SSMS, the GUI does not allow to specify an alternate SQL Server login, only allows to specify an alternate SQL Server user:
However, the EXECUTE AS documentation clearly states that using both SLQ Server user accounts and logins are a valid approach:
SQL Server 2005 supports the ability to impersonate another principal either explicitly by using the stand-alone EXECUTE AS statement […]. The stand-alone EXECUTE AS statement can be used to impersonate server-level principals, or logins, by using the EXECUTE AS LOGIN statement. The stand-alone EXECUTE AS statement can also be used to impersonate database level principals, or users, by using the EXECUTE AS USER statement.
SQL Server 2005 supports the ability to impersonate another principal either explicitly by using the stand-alone EXECUTE AS statement […]. The stand-alone EXECUTE AS statement can be used to impersonate server-level principals, or logins, by using the EXECUTE AS LOGIN statement. The stand-alone EXECUTE AS statement can also be used to impersonate database level principals, or users, by using the EXECUTE AS USER statement.
The solution for the customer's requirements was as easy as using the EXECUTE AS LOGIN instruction in the T-SQL code for the stored procedure:
How the SQL Server Agent and linked server security work is not difficult once you make sense of all the pieces in the puzzle. Knowing where these pieces fit will help you to better asset your SQL Server's security.
Some weeks ago I received a call from one of our customers concerning the SP3 installation on SQL Server 2005. The customer was choosing to install the Service Pack from Microsoft Update (as you probably know, Microsoft Update is a superset of Windows Update that takes care of updating not only Windows OS components but other Microsoft software as Office or SQL Server) and the installation completed successfully as far as he can see however, Windows Update site was still reporting SP3 for SQL Server as a required update. No matter how many times he tried to install SP3, the installation from Microsoft Update always completed successfully but always offered SP3 as required afterwards.
In our case the original SQL Server build was on SP2 (build 2005.90.3042) so it was clear that the error was not on the Microsoft Update detection engine. I asked the customer to download the SP3 from the Microsoft Download site and check what were the results in this case, installing the SP this way we have more control on each one of the steps performed by the setup. The customer reported that again the SP installation completed without errors but the SQL Server version was still build 3042.
We looked into the Service Pack summary.txt installation file, located by default under the C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\Log directory, and found the following information:
Products Detected Language Level Patch Level Platform Edition Setup Support Files ENU 9.3.4035 x86 SQL Server Native Client ENU 9.00.4035.00 x86 MSXML 6.0 Parser ENU x86 SQLXML4 ENU 9.00.4035.00 x86 Microsoft SQL Server VSS Writer ENU 9.00.4035.00 x86
As you may have noticed there is a missing component on this list: Database Services. The SQL Server number that we can see in SQL Server Management Studio or by querying the built-in function @@version corresponds with the version of this component (the same version shown by the sqlservr.exe executable under the SQL Server program directory). The SP3 (build 4035) setup was therefore reporting a correct installation for all the shared SQL Server components, that were the only components detected in our case were.
Running a Process Monitor while executing the SP3 setup process we discovered several ACCESS DENIED processes that I could not reproduce on my test environment, most of this events were related to the Wmiprvse.exe component. We decided to check the different WMI (Windows Management Instrumentation) repositories status with the help of WMI Diagnostics Utility WMIDiag; as expected, WMIDiag reported several errors with the WMI service configuration:
34153 10:34:38 (0) ** WMIDiag v2.0 started on dinsdag 21 juli 2009 at 10:25. 34154 10:34:38 (0) ** 34155 10:34:38 (0) ** Copyright (c) Microsoft Corporation. All rights reserved - January 2007. [...] 35235 10:34:39 (0) ** DCOM security warning(s) detected: ........... 0. 35236 10:34:39 (0) ** DCOM security error(s) detected: ............. 2. 35237 10:34:39 (0) ** WMI security warning(s) detected: ............ 0. 35238 10:34:39 (0) ** WMI security error(s) detected: .............. 52. 35239 10:34:39 (0) ** 35240 10:34:39 (1) !! ERROR: Overall DCOM security status: ......... ERROR! 35241 10:34:39 (1) !! ERROR: Overall WMI security status: .......... ERROR! [...] 35401 10:34:39 (0) ** ERROR: WMIDiag detected issues that could prevent WMI to work properly!. Check 'C:\DOCUMENTS AND SETTINGS\ADMINISTRATOR\LOCAL SETTINGS\TEMP\WMIDIAG-V2.0_2003_.SRV.RTM.32_NF04_2009.07.21_10.24.40.LOG' for details. 35402 10:34:39 (0) ** 35403 10:34:39 (0) ** WMIDiag v2.0 ended on dinsdag 21 juli 2009 at 10:34 (W:181 E:57 S:1).
At this point we were pretty sure the error was in the WMI service configuration. Thanks to the help of Carlos Carrolo from the Microsoft Platform Support Team we were able to trace down the problem to a known issue in SQL Server:
KB941823, Some or all SQL Server 2005 services are not listed in SQL Server Configuration Manager, or you receive a "No SQL Server 2005 components were found" error message when you perform operations in SQL Server 2005 Surface Area Configuration
The fact that none of the SQL Server service components was listed under the SQL Server Configuration Manager console confirmed our finding (this is described as one of the Symptoms on the KB).
This Knowledge Base article did not mention our setup scenario, but the workaround provided worked in our case. This KB goes very specific explaining the root-cause of the issue: during the very beginning of the Service Pack setup process, the existing SQL Server services are discovered via WMI queries by the means of Wmiprvse.exe process; without the proper permissions, the process will fail to discover the installed components. This is further discussed at the end of this Knowledge Base article:
[…] These tools iterate through the services collection to obtain the information about the SQL Server 2005 services. When these tools iterate through the services collection, these tools generate the following Windows Management Instrumentation (WMI) queries: SELECT * FROM RegServices SELECT * FROM SqlService When these tools generate the WMI queries, the SQL Server Web-Based Enterprise Management (WBEM) provider (Sqlmgmprovider.dll) is loaded into the Wmiprvse.exe process. Then, the SQL Server WBEM provider extracts and processes the information about the services of every instance of SQL Server 2005. […] The Wmiprvse.exe process in which the Sqlmgmprovider.dll file is loaded runs under the security context of the NETWORK SERVICE account. […]
[…] These tools iterate through the services collection to obtain the information about the SQL Server 2005 services. When these tools iterate through the services collection, these tools generate the following Windows Management Instrumentation (WMI) queries: SELECT * FROM RegServices SELECT * FROM SqlService When these tools generate the WMI queries, the SQL Server Web-Based Enterprise Management (WBEM) provider (Sqlmgmprovider.dll) is loaded into the Wmiprvse.exe process. Then, the SQL Server WBEM provider extracts and processes the information about the services of every instance of SQL Server 2005. […] The Wmiprvse.exe process in which the Sqlmgmprovider.dll file is loaded runs under the security context of the NETWORK SERVICE account. […]
It seemed that at some point after the SQL Server SP2 installation, the server was updated with a new Security Policy that broke the Discretionary Access Control List (DACL) for SQL Server leading to a broken WMI detection mechanism.
After installing a new SQL Server 2008 instance on my Windows 7 laptop I find myself unable to logon locally into the instance by using SQL Server Management Studio (SSMS). I know that due to the changes introduced in Windows Server 2008 and Windows Vista Firewall this was possibly due to an open port missing.
The Configuring the Windows Firewall to Allow SQL Server Access Books Online entry contains the information to open the required ports in Windows Firewall for each one of the SQL Server services. However, I recently discover a much easier way to open the required Windows Firewall ports for SQL Server on the following Knowledge Base Article (KB968872):
This article includes the Microsoft "Fix it" troubleshooter that allows to quickly fix the related problem using an easy-to-follow setup. The "Fix it" button is designed for Windows Server 2008 but the script that is executed by the setup is included on the same KB article and can be executed on Windows Vista or Windows 7 as well:
@echo ========= SQL Server Ports =================== @echo Enabling SQLServer default instance port 1433 netsh firewall set portopening TCP 1433 "SQLServer" @echo Enabling Dedicated Admin Connection port 1434 netsh firewall set portopening TCP 1434 "SQL Admin Connection" @echo Enabling conventional SQL Server Service Broker port 4022 netsh firewall set portopening TCP 4022 "SQL Service Broker" @echo Enabling Transact-SQL Debugger/RPC port 135 netsh firewall set portopening TCP 135 "SQL Debugger/RPC" @echo ========= Analysis Services Ports ============== @echo Enabling SSAS Default Instance port 2383 netsh firewall set portopening TCP 2383 "Analysis Services" @echo Enabling SQL Server Browser Service port 2382 netsh firewall set portopening TCP 2382 "SQL Browser" @echo ========= Misc Applications ============== @echo Enabling HTTP port 80 netsh firewall set portopening TCP 80 "HTTP" @echo Enabling SSL port 443 netsh firewall set portopening TCP 443 "SSL" @echo Enabling port for SQL Server Browser Service's 'Browse' Button netsh firewall set portopening UDP 1434 "SQL Browser" @echo Allowing multicast broadcast response on UDP (Browser Service Enumerations OK) netsh firewall set multicastbroadcastresponse ENABLE
Executing this on Windows 7 will show several warnings since the netsh firewall command in deprecated on this Windows version (netsh advfirewall firewall is the recommended method) but the script will perform its function nevertheless.
Kudos for the Microsoft "Fix it" team!
You probably have heard about Cluster Server Recovery Utility before, a nice Windows utility that alleviate some of the burden associated with Cluster changes (restoring checkpoint files, changing disk signatures, storage migration, etc.).
The Microsoft download page clearly states this utility is not suited for Windows Server 64-bits systems but I have recently found several SQL Server issues that are caused by the use of the utility on 64-bits SQL Server clustered installations.
Using this tool on 64-bits SQL Server clustered installations could potentially lead to hard-to-fix and time-consuming troubleshooting scenarios. For this reason I think it is worth the time to highlight here the importance of not using this tool on 64-bits.
Some of the SQL Server errors that can result from the use of Cluster Server Recovery Utility under 64-bits are:
SQLBrowser service was unable to establish SQL instance and connectivity discovery (Application Event Log)
2009-05-13 08:11:13.04 Server Error: 17182, Severity: 16, State: 1. 2009-05-13 08:11:13.04 Server TDSSNIClient initialization failed with error 0x2, status code 0x35. (SQL Server Errorlog)
Please, keep in mind these errors could have a different root-cause, not necessarily Cluster Server Recovery.
You will see that one ore more entries like this are created under the Wow6432Node registry entry:
[HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\Microsoft SQL Server\MSSQL.x]
Fixing these errors requires several registry changes and it is not a straightforward process. Please, contact Microsoft PSS for help on this case.
I worked last day on an very tricky SQL Server 2008 setup problem and think it is worth the time sharing here what I discovered. In this case my customer was trying to install SQL Server 2008 on a Windows XP SP3 computer to support a locally installed ERP software package.
The SQL Server 2008 setup was working fine at the beginning but failing in the middle of the process with the following error message:
SQLBrowser start request failed. Click Retry to retry the failed action, or click Cancel to cancel this action and continue setup
SQLBrowser start request failed. Click Retry to retry the failed action, or click Cancel to cancel this action and continue setup
Clicking on the Retry button did retry the start operation but failed again with the same error so we had no other option but cancel the setup process.
Checking the Windows System Event log did not provide any hint about the root-cause of the problem so I decide to check for the SQL Server 2008 setup log that can be found in C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log folder; there are different files included in this folder and each one of them provide information about each one of the components installed (SSIS, AS, Engine, Client Tools, etc.). The Detail.txt log file, as the name implies, includes very detailed information of the the overall setup process and it is usually the first thing I look into when dealing with setup issues; here is what we found in our case:
2009-05-13 17:25:13 SQLBrowser: The last attempted operation: Starting the SQL Server Browser service 'SQLBrowser', and waiting for up to '900' seconds for the process to complete. 2009-05-13 17:25:13 Slp: Prompting user if they want to retry this action due to the following failure: 2009-05-13 17:25:13 Slp: -------------------------------------- 2009-05-13 17:25:13 Slp: The following is an exception stack listing the exceptions in outermost to innermost order 2009-05-13 17:25:13 Slp: Inner exceptions are being indented 2009-05-13 17:25:13 Slp: 2009-05-13 17:25:13 Slp: Exception type: Microsoft.SqlServer.Configuration.Sco.ScoException 2009-05-13 17:25:13 Slp: Message: 2009-05-13 17:25:13 Slp: Service 'SQLBrowser' start request failed. 2009-05-13 17:25:13 Slp: Data: 2009-05-13 17:25:13 Slp: Feature = SQL_Browser_Redist_SqlBrowser_Cpu32 2009-05-13 17:25:13 Slp: Timing = Startup 2009-05-13 17:25:13 Slp: DisableRetry = true
So I could see that indeed the SQLBrowser service was being created but could not be started for some reason. I decided then to check the Summary.txt setup log file for a more comprehensive list of what components were and were not installed successfully; this file can be also located under the \LOG folder and contains a brief summary of the actions performed by the SQL Server setup. Interestingly enough, the error on this summary setup log file was not pointing to the Browser service but to MSXML 6.0 (Microsoft XML engine):
Detailed results: Feature: Database Services Status: Failure MSI status: Failure MSI error code: 0x5EBE5729 MSI log file location: C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20090514_170659\Msxml6_Cpu32_1.log
So I looked up into this setup log file (Msxml6_Cpu32_1.log):
MSI (s) (30:58) [17:22:37:661]: Note: 1: 1708 MSI (s) (30:58) [17:22:37:661]: Product: MSXML 6.0 Parser (KB933579) – Installation error.
MSI (s) (30:58) [17:22:37:661]: Windows Installer installed the product. Product Name: MSXML 6.0 Parser (KB933579). Product Version: 6.10.1200.0. Product Language: 3082. Installation success or error status: 1603.
MSI (s) (30:58) [17:22:37:661]: Cleaning up uninstalled install packages, if any exist MSI (s) (30:58) [17:22:37:661]: MainEngineThread is returning 1603 MSI (s) (30:68) [17:22:37:770]: No System Restore sequence number for this installation.
As you can see, SQL Server Browser was not the only component failing during the setup, the MSXML 6.0 engine was failing too. Comparing time from both Detail.txt and Msxml6_Cpu32_1.log files I could see the later was newer; in other words, the MSXML setup error was happening before the SQL Server Browser error. I went back to the Detail.txt file to confirm this point:
2009-05-13 17:22:36 Slp: Running Action: Install_Msxml6_Cpu32_Action 2009-05-13 17:22:36 Slp: Target package: "D:\x86\setup\x86\msxml6.msi" 2009-05-13 17:22:37 Slp: InstallPackage: MsiInstallProduct returned the result code 1603. 2009-05-13 17:22:38 Slp: Sco: Attempting to write hklm registry key SOFTWARE\Microsoft\Microsoft SQL Server to file C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20090514_170659\Registry_SOFTWARE_Microsoft_Microsoft SQL Server.reg_ 2009-05-13 17:22:38 Slp: Sco: Attempting to write hklm registry key SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall to file C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20090514_170659\Registry_SOFTWARE_Microsoft_Windows_CurrentVersion_Uninstall.reg_ 2009-05-13 17:22:38 Slp: Sco: Attempting to write hklm registry key SOFTWARE\Microsoft\MSSQLServer to file C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20090514_170659\Registry_SOFTWARE_Microsoft_MSSQLServer.reg_ 2009-05-13 17:22:43 Slp: 2009-05-13 17:22:43 Slp: Watson bucket for Msi based failure has been created 2009-05-13 17:22:43 Slp: No retry-able MSI return code detected. 2009-05-13 17:22:43 Slp: Checkpoint: INSTALL_MSXML6_CPU32_ACTION 2009-05-13 17:22:43 Slp: Completed Action: Install_Msxml6_Cpu32_Action, returned False 2009-05-13 17:22:43 Slp: Error: Action "Install_Msxml6_Cpu32_Action" failed during execution.
Checking into Add/Remove Programs in Control Panel I could see the MSXML 6.0 engine listed as an installed. This is one of the shared component installed by SQL Server 2008 but in my case the customer was unsure if this component was previously installed on the Windows XP computer. I decided to remove the MSXML 6.0 engine from the PC using the Add/Remove Programs Control Panel applet and try the SQL Server 2008 setup again. This time the installation completed with no errors.
In this case the initial SQL Server Browser error was misleading because it was the first error that was shown by the Setup GUI. Only by looking inside the SQL Server setup log files we were able to discover the MSXML 6.0 installation issue the took place before.
Another possible way of tracing down this error is by looking into the Watson Bucket log file that exists on the same setup "Log" directory:
In our case this was the content of this file:
Watson bucket data: Bucket param 1: 10.0.1600.22 Bucket param 2: 6.10.1200.0 Bucket param 3: msxml6.msi Bucket param 4: 0x2D2816FE Bucket param 5: 0x5EBE5729 Bucket param 6: Install_Msxml6_Cpu32_Action Bucket param 7: Bucket param 8: Bucket param 9: Bucket param 10:
I have reviewed the SQL Server 2008 SP1 notes and this issue has been solved there so another way to avoid this problem would be by installing a slipstreamed SQL Server 2008 media, slipstreaming is a new SQL Server functionality that allows the database administrator to integrate Service Packs into the installation media.
Working at Microsoft Customer Support Services (CSS), we are frequently asked by our customers to check their SQL Server cluster configuration. Event though the task of installing and configuring a SQL Server cluster have been simplified every new Windows Server version, it is not strange to find clusters with non-optimal configurations. Part of this problem relies on the amount of settings the IT professional has to take into account when setting up a new cluster. Fortunately, Windows Server 2008 has introduced significant changes into the cluster setup, configuration and maintenance with the aim of simplifying most of the hard work for the IT professional.
The goal of this post is to provide a quick guide for checking for some of the most common mistakes when configuring SQL Server on a Windows Server 2003 failover cluster. For this task we will use the CLUSMPS.EXE utility included in MPSReports.
Microsoft Product Support's Reporting Tools (aka MPSReports) is probably one of the most popular tools among Microsoft Support professionals. This tool is used in most of the support incidents to gather SQL Server and general Windows logs and settings, including the failover cluster ones. When executing MPSReports (for SQL Server you will have to download and run MPSRPT_SQL.exe executable file) we are actually executing a group of scripts and executables behind the scenes; one of these executables, CLUSMPS.EXE, will dump the SQL Server cluster configuration to a text file in the form of SERVERNAME_CLUSTER_MPS_INFORMATION.txt.
The setup of MPSReports is pretty straightforward but is always recommended you check the ReadMe.txt file to have a better understanding of what test are performed and what log files are generated. You can find this ReadMe.txt here and additional information about this tool here.
After running this tool we will find the cluster configuration file into the resultant CAB file in the MPSReports folder (default path for this folder is %WINDIR%\MPSReports\). We can optionally execute CLUSMPS.EXE directly by opening a Command Prompt windows on the active cluster node and running the tool from %WINDIR%\MPSReports\SQLServer\BIN\x86 path. The following picture describes the command-line options available:
It is important to note that neither CLUSMPS.EXE nor the rest of the tests performed by MPSReports will change the Windows or SQL Server configuration in any way.
The first section of the resultant SERVERNAME_CLUSTER_MPS_INFORMATION.txt file provides a general overview of what nodes are part of the cluster and what cluster groups and resources are located on these nodes. This is an at-a-glance view of the information we can find by using Windows Cluster Administrator (cluadmin.exe) tool.
This section includes Nodes Information, Group and Resource Information, which will be useful if you need to dig deep for cluster events into cluster.log, (see my previous post for more information on this) and Resource to Guid Information.
The Network Configuration section includes Cluster Networks Information, Cluster Networks Priority, Network Interfaces, and Network Interfaces Binding Order. It is important to do not overlook these settings. In most of the cases not configuring network settings correctly will cause your SQL Server instance to do not perform optimally.
Cluster Networks Information will show a list of the networks recognized by Microsoft Cluster Services (MCS). On a typical cluster configuration, each one of the cluster nodes will include at least two Network Interface Cards (NICs): One is used for internal cluster communications between nodes (commonly referred as "Heartbeat" network) and the other is used for external communications ("public" network).
Pay attention to the Network Role column, by default you will see that both the Heartbeat and Public network are configured to support All Communications ("All Comm") but it is a best practice to modify the Heartbeat configuration so it listens to Internal Communications only. To do so open the Heartbeat network properties on the Cluster Administrator utility (cluadmin.exe) and select the option Internal Cluster Communications Only (Private Network):
Cluster Networks Priority shows the priority of each one of this networks. As a best practice, ensure that the private network is listed with the highest priority. This setting can be changed by accessing the cluster properties on Cluster Administrator utility:
The Network Interfaces Binding Order determines how each network protocol is bound to each services that make use of it. As a general rule, the most-used protocols should be listed first. The recommended binding order for a Windows cluster is as follows:
Network bindings can be configured using the Advanced > Advanced Settings option in Control Panel > Network and Dial-up Connections.
The following Knowledge Base article provides specific guidelines to configure network components on a Windows cluster: Recommended private "Heartbeat" configuration on a cluster server, Server Clusters: Network Configuration Best Practices for Windows 2000 and Windows Server 2003.
You can also find best practices to configure the different network components on a cluster on the following TechNet link: Network Configuration Best Practices for Windows 2000 and Windows Server 2003.
On each one of the cluster groups, it is frequent to find resources that depend on others to function properly. These dependencies are depicted on the Dependency Tree List and Dependency List sections of the SERVERNAME_CLUSTER_MPS_INFORMATION.txt file. We usually do not need to take SQL Server cluster dependencies into account, these are automatically configured at setup time and should not be changed from defaults but it is worth the time to check our current dependencies tree against the recommended settings. You can find this information and other special considerations on Knowledge Base article KB835185.
Here you can find default dependencies for the SQL Server 2000 failover cluster components:
SQL Server (SHILOH) { SQL Server } +(1)-----Depends On-> SQL Network Name(SQL2000) { Network Name } +(2)-----Depends On-> SQL IP Address1(SQL2000) { IP Address } +(1)-----Depends On-> Disk S: { Physical Disk }
SQL Server Fulltext (SHILOH) { Microsoft Search Service Instance } +(1)-----Depends On-> SQL Server (SHILOH) { SQL Server } +(2)-----Depends On-> SQL Network Name(SQL2000) { Network Name } +(3)-----Depends On-> SQL IP Address1(SQL2000) { IP Address } +(2)-----Depends On-> Disk S: { Physical Disk }
And here are the default dependencies for the SQL Server 2005 failover cluster components:
SQL Server (YUKON) { SQL Server } +(1)-----Depends On-> Disk Y: { Physical Disk } +(1)-----Depends On-> SQL Network Name (SQL2005) { Network Name } +(2)-----Depends On-> SQL IP Address 1 (SQL2005) { IP Address }
SQL Server Agent (YUKON) { SQL Server Agent } +(1)-----Depends On-> SQL Server (YUKON) { SQL Server } +(2)-----Depends On-> Disk Y: { Physical Disk } +(2)-----Depends On-> SQL Network Name (SQL2005) { Network Name } +(3)-----Depends On-> SQL IP Address 1 (SQL2005) { IP Address }
SQL Server Fulltext (YUKON) { Generic Service } +(1)-----Depends On-> Disk Y: { Physical Disk }
The Account Privileges section includes a list of the different right required by the Microsoft Cluster Service account as well as any missing permissions. The following example illustrates an scenario where two of the permissions are missing for this account:
_____________________________________________ |/////////////////////////////////////////////| |// Current Effective Rights //| |/////////////////////////////////////////////|
Act as part of the operating system. Back up files and directories. Restore files and directories. Adjust memory quotas for a process. Increase scheduling priority. Log on as Service. Debug programs. Manage auditing and security log. Access this computer from the network.
_____________________________________________ |/////////////////////////////////////////////| |// Missing Current Effective Rights //| |/////////////////////////////////////////////|
Load and unload device drivers. Impersonate a client after authentication.
The required permissions should be configured on each one of the cluster nodes. Failure in configuring proper rights for the Cluster Services account will cause you SQL Server cluster to show permissions error message or to fail completely during startup or failover operations. For a list of what permissions are required by this account in Windows Server 2003 please, refer to the Knowledge Base article KB269229.
If you plan to make use of Distributed Transaction Services within SQL Server you should plan way ahead how to install the Microsoft Distributed Transaction Coordinator (MSDTC) cluster resource. The Knowledge Base article How to configure Microsoft Distributed Transaction Coordinator on a Windows Server 2003 cluster is the best place to start. In case you need to revert or modify an existing MSDTC clustered installation so it can be used by SQL Server, refer to this link.
For a more in-depth analysis of the general SQL Server cluster does and don'ts I highly recommended to check the following Microsoft Knowledge Base article: Clustered SQL Server do's, don'ts, and basic warnings.
The following TechNet link contains a quick reference guide to install and configuring new Microsoft cluster in Windows Server 2003: Quick Start Guide for Server Clusters. For specific SQL Server guidelines refer to SQL Server Books Online.
During this post I have tried to summarize the key points to look for when checking SQL Server cluster configuration on Windows Server 2003. This is not a complete checklist and working over the different links provided in the post will give you a more complete information. The new Cluster Validation Wizard introduced in Windows Server 2008 cluster simplifies and reduced significantly the overhead associated with cluster configuration in previous Windows versions. If you haven't had the opportunity to work with Server 2008 cluster, I encourage you to setup your lab and get familiar with this new cluster model.
During a recent work with one of our customers I did notice that it is not always clear what tools are available and required to copy SQL Server database objects, understanding "object" as a whole database or only part of it (table, view, user, etc.)
As part of this work, my customer was trying to copy several databases between two different SQL Server instances but after several tests he was finding that although the tables were correctly copied, other objects as views and primary keys were not correctly transferred. It come to my attention that he was using the SQL Server Import Export Wizard to transfer the databases between one instance and another. Import Export Wizard can be launched from within SQL Server Management Studio (SSMS) or directly from a command prompt window typing DTSWizard.exe (further information about how to start Import Export Wizard can be found on this MSDN link)
As indicated on the startup page on the Import Export Wizard, this tool can be used to copy data between different data sources and we have the option to recreate the destination database and tables, however this is not the right tool to use if we want to copy the whole database (not only tables, but all other objects) from one instance to another. The following Books Online link tries to clarify this difference:
The purpose of the SQL Server Import and Export Wizard is to copy data from a source to a destination. The wizard can also create a destination database and destination tables for you. However, if you have to copy multiple databases or tables, or other kinds of database objects, you should use the Copy Database Wizard instead
The purpose of the SQL Server Import and Export Wizard is to copy data from a source to a destination. The wizard can also create a destination database and destination tables for you. However, if you have to copy multiple databases or tables, or other kinds of database objects, you should use the Copy Database Wizard instead
Copy Database Wizard will allow you to copy entire databases from one SQL Server instance into another (or the same, if you desire to do so) retaining the full database structure and objects. You can use two different methods to copy the databases and it is possible to keep the source database online while the copy is taking place, the following image shows these options:
You can launch Copy Database Wizard directly from SSMS right-clicking on any database > Tasks > Copy database. You will see that this option (red) is side-by-side with the Import Export Wizard (green):
Copy Database Wizard support the copy of databases between SQL Server 2000 and SQL Server 2005 providing an effective and simple way of upgrading databases between these two versions. For this wizard to work, SQL Server 2005 Service Pack 2 should be installed not only on the server where we are executing the tool but also on the destination server. For more information about this option please, refer to SQL Server Books Online.
In summary, if you want to copy entire databases between different SQL Server instances, Copy Database Wizard is your tool. If you want to export data or import data from/into SQL Server or other data sources or just want to copy some tables, use Import Export Wizard. If you need to copy data and perform modifications during this process with a fine-grain control you will find a better solution by building and Integration Services package in Business Intelligence Development Studio.


text:
New User:
Forgot your password?
Stock Market & Financial Investment News
News Breaks
December 11, 2012
United Natural Foods responds to Teamsters Local 117
United Natural Foods said that it is surprised and disappointed that Teamsters Local 117 has decided to strike at its Auburn, Wash., distribution center. UNFI offered to return to the bargaining table as recently as yesterday, yet the Union elected to go out on strike. The Union's claims that UNFI has engaged in unfair labor practices are entirely baseless and without merit. To date, the National Labor Relations Board has not found any instances of UNFI committing unfair labor practices, although the NLRB did find that the Union threatened UNFI's employees with loss of employment if they crossed the Union's picket line. The Union continues to misrepresent the situation and undertake a smear campaign in an effort to damage UNFI's reputation.
News For UNFI From The Last 14 Days
Sign up for a free trial
to see the rest of the stories you've been missing.
There are no results for UNFI
Sign up for a free trial
to see the rest of the stories you've been missing.
I agree to the theflyonthewall.com
disclaimer & terms of use


text:
Arsenal v Everton
Arsenal's four-match winning run ended with a goalless draw against Everton, a result that did neither side much good in their Champions League quest.
The Toffees, who were fortunate not to have Darron Gibson sent off, started brightly and went close through Steven Pienaar and the lively Ross Barkley.
Olivier Giroud was wasteful for Arsenal, now two points clear of fifth-placed Spurs having played a game more.
Giroud was denied by Seamus Coleman's clearance as Everton secured a point.
The Toffees thoroughly deserved a draw in what was a fiercely contested encounter, and are now unbeaten in six league games.
But David Moyes' side, now within two points of fourth-placed Chelsea but having played two games more, were unable to find the goal that would have really improved their prospects of playing in next season's Champions League.
Nor is Arsenal's own top-four place by any means guaranteed and they will need to start more quickly when Manchester United visit on 28 April than in their last two matches at the Emirates Stadium.
Darron Gibson should definitely have been sent off. That's a rugby challenge. He got it very wrong but he's a lucky boy to be still on the pitch
The Gunners conspicuously failed to carry on where they had left off in their previous match, when Arsene Wenger's men scored three goals in the final five minutes to secure a 3-1 victory over Norwich.
Former Toffees midfielder Mikel Arteta, Aaron Ramsey and Jack Wilshere struggled to get a grip in midfield as the visitors' Pienaar skied a glorious chance from Coleman's excellent seventh-minute pass.
Everton boss Moyes opted to start 19-year-old Barkley in place of injured England midfielder Leon Osman for this crucial game and the teenager typified his team's battling first-half display, playing with a maturity beyond his years.
In a bruising encounter, Wilshere was left clutching a sore ankle after falling awkwardly following a fair challenge with Barkley.
Everton midfielder Gibson was then fortunate to escape a red card when he was penalised for a cynical foul on Theo Walcott shortly after he had been booked for bringing down the England international.
Arsenal, chasing a seventh win in eight top-flight games, struggled to hurt their opponents, and were restricted to just a couple of chances in the first half, full-back Kieran Gibbs failing to take advantage of Marouane Fellaini's 24th-minute botched clearance, and Giroud missing from close range after a fine pass by Ramsey.
Wenger's side improved after the interval but still could not find the breakthrough, although Santi Cazorla forced a fine save from Tim Howard with a powerful attempt after Gibbs had nodded the ball into his path.
In an end-to-end game, the tireless Barkley went close with a curling right-foot attempt before Coleman stopped Giroud from sliding the Gunners into a late lead following a surging run by Alex Oxlade-Chamberlain.
Arsenal manager Arsene Wenger:
"We should have won the game, but it still keeps us in a strong position in the race for the top four.
"I felt that in the first half the referee didn't deal at all well with the intimidating physical challenges, but that we responded well to the physicality.
"It was detrimental to the fluency of our game, but we kept going, had good concentration.
"You have to respect the effort Everton put in. They decided to make it very physical for us to disturb our game and sometimes went a little bit over the edge, but the referee had to make the right decision."
Everton manager David Moyes:
"We went to try and win it. We knew if we got three points we would have a real chance (of the top four), but a point keeps us ticking along.
"I think the result suits Spurs more than anybody, but I don't think we are out of place where we are.
"I would take it (the Europa League), but I am going to try and get the Champions League - if we are still getting that mention in mid-April, then it is not bad for Everton."
Lineup, Bookings (5) & Substitutions (6)
- 01 Szczesny
- 03 Sagna
- 04 Mertesacker
- 06 Koscielny
- 28 Gibbs (Monreal - 90' Booked )
- 08 Arteta Booked
- 10 Wilshere (Oxlade-Chamberlain - 68' )
- 14 Walcott (Podolski - 69' )
- 16 Ramsey
- 19 Cazorla
- 12 Giroud
- 24 Mannone
- 05 Vermaelen
- 17 Monreal
- 07 Rosicky
- 15 Oxlade-Chamberlain
- 09 Podolski
- 27 Gervinho
- 24 Howard
- 03 Baines
- 06 Jagielka
- 15 Distin
- 23 Coleman
- 04 Gibson Booked
- 20 Barkley Booked (Jelavic - 76' )
- 22 Pienaar Booked
- 25 Fellaini
- 11 Mirallas (Oviedo - 90' )
- 28 Anichebe (Naismith - 90' )
- 01 Mucha
- 05 Heitinga
- 18 Neville
- 08 Oviedo
- 16 Hitzlsperger
- 07 Jelavic
- 14 Naismith
Match Stats
On target
Live Text Commentary
Full Time The referee ends the match.90:00 +3:41
Bacary Sagna takes the direct free kick.90:00 +3:41 Substitution
Substitution Bryan Oviedo replaces Kevin Mirallas.90:00 +3:41
Steven Pienaar concedes a free kick for a foul on Alex Oxlade-Chamberlain.90:00 +3:14
Darron Gibson takes the free kick.90:00 +3:14 Booking
Booking Nacho Monreal is booked.90:00 +2:59
Steven Naismith fouled by Nacho Monreal, the ref awards a free kick.90:00 +1:10 Substitution
Substitution Victor Anichebe leaves the field to be replaced by Steven Naismith.90:00 +1:10
Effort by Victor Anichebe from a long way out goes over the target.89:27
The free kick is swung in right-footed by Santi Cazorla, Marouane Fellaini makes a clearance.89:27 Substitution
Substitution Nacho Monreal joins the action as a substitute, replacing Kieran Gibbs.89:27
Free kick awarded for an unfair challenge on Alex Oxlade-Chamberlain by Leighton Baines.86:42
Kieran Gibbs gives away a free kick for an unfair challenge on Kevin Mirallas. Direct free kick taken by Phil Jagielka.86:22
Lukas Podolski takes a shot. Blocked by Phil Jagielka.85:21
Inswinging corner taken by Santi Cazorla, Marouane Fellaini manages to make a clearance.83:50
The referee blows for offside. Kieran Gibbs restarts play with the free kick.83:09
Marouane Fellaini fouled by Aaron Ramsey, the ref awards a free kick. Tim Howard takes the direct free kick.81:17
Corner taken by Santi Cazorla from the left by-line to the near post.79:01
Shot by Olivier Giroud from inside the six-yard box clear the bar.76:38
Olivier Giroud takes a shot. Comfortable save by Tim Howard.
Outswinging corner taken right-footed by Santi Cazorla from the right by-line to the near post, Phil Jagielka makes a clearance.74:15 Substitution
Substitution (Everton) makes a substitution, with Nikica Jelavic coming on for Ross Barkley.74:15
Olivier Giroud takes a shot. Sylvain Distin gets a block in.72:43
Corner taken by Santi Cazorla from the left by-line, Aaron Ramsey takes a shot. Blocked by Sylvain Distin. Inswinging corner taken from the left by-line by Santi Cazorla. Unfair challenge on Alex Oxlade-Chamberlain by Leighton Baines results in a free kick. Direct free kick taken by Bacary Sagna.72:12
Foul by Steven Pienaar on Bacary Sagna, free kick awarded. The free kick is delivered right-footed by Mikel Arteta from right wing, clearance made by Phil Jagielka.69:13
Direct free kick taken by Mikel Arteta.69:13 Booking
Booking Ross Barkley goes into the book.69:02
Ross Barkley gives away a free kick for an unfair challenge on Aaron Ramsey.67:49 Substitution
Substitution Lukas Podolski comes on in place of Theo Walcott.67:49 Substitution
Substitution Alex Oxlade-Chamberlain joins the action as a substitute, replacing Jack Wilshere.64:56
Shot from just outside the box by Ross Barkley misses to the right of the target.63:40
Leighton Baines takes a inswinging corner from the right by-line played to the near post, clearance made by Aaron Ramsey.63:01
Foul by Victor Anichebe on Kieran Gibbs, free kick awarded. Kieran Gibbs takes the free kick.58:04
Ross Barkley produces a left-footed shot from outside the box and misses left.56:51
Santi Cazorla takes a inswinging corner from the left by-line to the near post.55:26
Shot on goal comes in from Leighton Baines from the free kick. Leighton Baines takes a shot. Blocked by Mikel Arteta.55:26 Booking
Booking Mikel Arteta booked for unsporting behaviour.55:18
Mikel Arteta gives away a free kick for an unfair challenge on Steven Pienaar.52:48
Jack Wilshere gives away a free kick for an unfair challenge on Kevin Mirallas. A cross is delivered by Leighton Baines, Victor Anichebe has a headed effort at goal from close in which goes wide right of the target.51:37
Corner taken by Jack Wilshere from the right by-line, clearance made by Marouane Fellaini.51:04
Olivier Giroud produces a left-footed shot from just outside the penalty area that goes harmlessly over the target.48:37
Drilled right-footed shot by Santi Cazorla. Save by Tim Howard. Santi Cazorla takes a inswinging corner from the left by-line to the near post, clearance by Sylvain Distin.46:10
Kevin Mirallas takes a shot. Save made by Wojciech Szczesny.45:01
The match restarts for the second half.45:00 +2:10 Half time
Half Time The whistle is blown to end the first half.45:00 +0:12
Mikel Arteta gives away a free kick for an unfair challenge on Steven Pienaar. Darron Gibson takes the free kick.43:28
Santi Cazorla takes a shot. Blocked by Leighton Baines.41:06
Shot from close range by Olivier Giroud misses to the right of the target.39:28
Victor Anichebe takes a shot. Wojciech Szczesny makes a comfortable save.38:47
Kieran Gibbs gives away a free kick for an unfair challenge on Seamus Coleman. Direct free kick taken by Phil Jagielka.38:22
Shot from 25 yards by Ross Barkley. Save by Wojciech Szczesny.37:28
Free kick awarded for a foul by Bacary Sagna on Steven Pienaar. Leighton Baines restarts play with the free kick.34:34
Santi Cazorla crosses the ball from the free kick right-footed from right wing, clearance made by Sylvain Distin.34:34 Booking
Booking Steven Pienaar receives a caution.34:18
Free kick awarded for an unfair challenge on Theo Walcott by Steven Pienaar.32:55
Foul by Darron Gibson on Theo Walcott, free kick awarded. Bacary Sagna takes the free kick.31:05
The official flags Kevin Mirallas offside. Wojciech Szczesny takes the indirect free kick.28:17
Seamus Coleman fouled by Laurent Koscielny, the ref awards a free kick. Phil Jagielka takes the free kick.27:17
Free kick crossed by Jack Wilshere, Marouane Fellaini manages to make a clearance.27:17 Booking
Booking Darron Gibson is given a yellow card.26:44
Free kick awarded for an unfair challenge on Theo Walcott by Darron Gibson.23:35
Shot from just outside the box by Kieran Gibbs goes over the bar.19:37
Olivier Giroud challenges Seamus Coleman unfairly and gives away a free kick. Direct free kick taken by Phil Jagielka.12:15
Foul by Aaron Ramsey on Ross Barkley, free kick awarded. Free kick taken by Darron Gibson.8:59
Marouane Fellaini gives away a free kick for an unfair challenge on Aaron Ramsey. Mikel Arteta takes the free kick.7:09
Free kick awarded for an unfair challenge on Jack Wilshere by Marouane Fellaini. Mikel Arteta takes the free kick.5:54
Steven Pienaar produces a right-footed shot from inside the area that clears the bar.3:59
The referee blows for offside. Phil Jagielka takes the indirect free kick.1:56
Free kick awarded for a foul by Marouane Fellaini on Mikel Arteta. Free kick taken by Mikel Arteta.0:00
The referee starts the match.
Live data and text provided by our data suppliers
Comment number 655. Posted by 00Mike26on 18 Apr 2013 20:05
Dave #607.
Please go and watch that 'tackle' by Kyrgiakos again. One player stays on his feet, the other launches all of his weight behind a two-footed tackle which could only ever injure someone in the way of it.
Either you're a Liverpool fan or you haven't remembered that incident properly.
Or you don't understand football.
Comment number 654. Posted by 00Mike26on 18 Apr 2013 19:53
Having missed the first 653 comments I guess I'ma bit late and everything's been covered, but I can't not say this:
The 'foul' that Gibson was booked for was committed by Mirallas, so he wasn't lucky to stay on the pitch.
Also, Arsenal fans appealing for everything influenced the ref, this included, a number of times, them appealing for handball when it hit Everton defenders' feet!
Comment number 653. Posted by ronnieboy1on 18 Apr 2013 16:46
#637 i would support arsenal if they won nothing in 100 years as long as they tried to win things.....this present shower does not get my support because they cant be bothered half the time...thats the differance.#648 well if your happy with the way things are...fine... if you want to go through next season exactly the same as this season fine....for me wenger is a disgrace.
Comment number 652. Posted by Williamswron 18 Apr 2013 15:36
Wenger was wrong to criticise Everton's style of play for to compete with Arsenal the the away team have to play to their strengths. Everton might well have returned to Goodson with the 3 points had they taken their goal scoring opportunities. Barkley is a fine prospect and I hope that he stays with Everton and I believe he will become a star of the England side. Jagielka was magnificent .
Comment number 651. Posted by chelskikoviteson 18 Apr 2013 11:15
650 Maybe an admission, but definitely profit driven. Arsenal are little more than Tesco now (being kind there, didn't say Woolworths).
Comment number 650. Posted by Fergies_Hammeron 18 Apr 2013 08:12
History proves that Fergie can still compete. He had the sense to sell Ronaldo to a Spanish team and not a domestic rival.
Given the history between Utd & Ars I was surprised you sold your best player to us. It does seem to be an admission that you no longer see yourselves as genuine rivals and a threat to the title.
Comment number 649. Posted by Daveon 18 Apr 2013 05:44
Sensei - when you refer to MU fans smug "expert" analysis I do hope you don't mean ESG?
ESG is incredibly knowledgable about all football matters, including Arsenal, about whom he's actually wrote a blog!
He also says "facepalm" to express exasperation.
What more do you need to know?!
He's clearly a football intellectual and certainly NOT some kind of bewildered halfwit.
Comment number 648. Posted by The Tin Hat Of Copernicuson 18 Apr 2013 00:25
Well I can't speak for the crowd, but if you look through the comments on this article (save Ronnieboy1) all the detractors are actually Man Utd supporters who pass through here with a smug-on attitude trying to pass their distasteful garbage off as expert analysis.
In actual fact most Gooners (certainly the ones I speak to and see) are more than happy with life since our move to The Emirates :)
Comment number 647. Posted by Doors_of_perceptionon 17 Apr 2013 23:04
Why is it fans of the biggest and best teams are also the biggest moaners. As a Forest fan all I do is try to stay positive and hope this season will be the one, and it never is. I never saw us win the European cup, yet I did see us become the first European cup winning team to be relegated to the third tier of football, however, all that did was make me get behind my team even more!!
Comment number 646. Posted by The Tin Hat Of Copernicuson 17 Apr 2013 21:51
644 So Fergie selling Ronaldo to Real Madrid was basically them admitting that they will never be able to compete with them in future?
I don't buy into that logic. Players come and go for a variety of reasons. Selling van Persie was more a case of the players ambitions, rather than the clubs.
In the same was as Utd selling Ronaldo was more about the player's ambitions ambition than of Utd.
You must sign in to rate comments


text:
David Ortiz Injury UpdateUp to the minute news and rumors on David Ortiz's injury
Popular Topics
Cowboys News & Notes: Dallas Currently Holds No. 4 Overall Draft Pick
The Miami Dolphins are down but not yet out
Giants at Redskins: Geoff Schwartz, John Jerry to switch sides
Cardinals vs. 49ers final injury report: Deone Bucannon clears concussion protocol, Floyd good to go
Lupica: The late Frank Gifford and price of being tough
Lions Saturday open thread
Seattle Seahawks activate CB Jeremy Lane, release RB Bryce Brown
The Westchester Knicks have reacquired Jimmer Fredette
Quick, authoritative ball movement is the Boston Celtics' recipe for success
Golden State Warriors set franchise record with 17th consecutive win
Kobe Bryant calls Damian Lillard 'one of the best players in the league'
Cavaliers vs. Nets: Game preview, start time, TV information
Planned Parenthood shooting leaves 3 dead, 9 wounded in Colorado Springs; gunman ID'd
LeBron James' shot keeps Cavaliers perfect at home: Joe Vardon's instant analysis
Kuzma: Canucks prospect Demko's hip to the future
Umass Lowell win first annual Belfast Beanpot tournament. Yep, it's happening next year!
Sunday Habs Headlines: Carey Price to undergo further tests for knee injury
Leafs' Holland keeps up post-benching hot streak
Dustin Tokarski and Christian Thomas recalled from St. John's
Callahan Provides Overtime Heroics in 3-2 Win
Recap: Geno Magic Not Enough. Pens Fall 3-2 in SO
No. 8 Ohio State 42, No. 12 Michigan 13: Ezekiel Elliott, Buckeyes run over Wolverines
Sunday thoughts // Rutgers season review
Big Ten football | Michigan State trounces Penn State en route to conference title game
College football | Big Ten standings
Mizzou bowl status unclear but Pinkel is done
Maryland vs Cleveland State final score, with 3 things to know from the Terps' 80 to 63 win
Planned Parenthood shooting leaves 3 dead, 9 wounded in Colorado Springs; gunman ID'd
- More
- Fantasy football
- Fantasy baseball
- Fantasy basketball
- Fantasy hockey
- Sports news by city
- All sports topics
- © 2015 SPORTSOVERDOSE.COM All rights reserved.


text:
The Silkie (sometimes alternatively spelled Silky) is a breed of chicken named for its atypically fluffy plumage, which is said to feel like silk. Silkies are considered an ideal pet and are the most docile of chickens. H Silkie chickens are extremely affordable pets to own, especially when considering the benefits of keeping them such as access to fresh eggs, pest control, and companionship.
A family-owned pygmy goat breeder committed to producing high-quality African pygmy goats for show, breeding, and pet purposes since 1982. With "quality is better than quantity" as their motto, founders Debbie and Jim Hosley pride themselves on raising pygmy goats that are highly sought after the world over. Amber Waves continues to gain industry acclaim as its animals have recently been featured on television and purchased by international dignitaries.
We are a small, family friendly farm located in Norco, CA striving to continue with the quality lineage of the French Black Copper Marans breeding line. All of our chicks are hand raised in our home and are guaranteed a good healthy start. Famed for their dark chocolate brown eggs, the Marans originate from France. They are rare and extremely popular dual purpose breed. They are fast growing and hardy.
The Pyrenean Mountain Dog, known as the Great Pyrenees in North America, is a large breed of dog used as a livestock guardian dog. It should not be confused with the Pyrenean Mastiff. WikipediaThe Great Pyrenees is a capable and imposing guardian, devoted to its family and somewhat wary of strangers — human or canine. When not provoked, it is calm, well-mannered and somewhat serious. It is very gentle with its family and children. This breed was developed to guard flocks on steep mountain slopes and so must combine strength with agility.
The Nigerian Dwarf is a miniature goat of West African Origin. Any color or combination of colors is acceptable. The most commonly asked question about Dwarf goats is: What is the difference between these and Pygmy goats? Although they have similar origins, they are separate and distinct breeds. Pygmies are bred to be "cobby" and heavy boned. (The best pygmies look like beer kegs with legs.) Dwarves are bred to have the length of body and structure, in proportion, of a dairy goat. Color is one of the BIG factors that makes breeding Dwarves so popular. Dwarf goats are gentle and loveable. Even breeding bucks are handled easily. They make wonderful pets and great animal projects for young children in 4-H.


text:
The liberal equivalent of teabagging. I.e., when the liberal element in the Democratic party challenges Democratic politicians from the Left, especially in primaries.
The Democrats sure gave Joe Lieberman a salad tossing when they gave the nomination to Ned Lamont.
লিখেছেন- Tamburlaine2k 18 de মে de 2010
When you spread another man's ass-cheeks apart and then bury your face in his hairy,sweaty ass-crackthen you lick & tongue-fuck his tight,twitching ass-hole
"want your salad tossed?","toss my salad you muther-fuckin' ass-licker!","You salad tossing faggot!"
লিখেছেন- Titokf3 6 de মার্চ de 2008
eating out a shitty asshole with ranch dressing
লিখেছেন- Anonymous 29 de মার্চ de 2003
Liz dreams of tossing my salad daily.
লিখেছেন- Madison 12 de অগাস্ট de 2004


text:
Forget password?
Remember Me
California Nights is a brighter, more sparkly, more sophisticated, more psychedelic Best Coast album across the board, embodying the rich lightness and stinging darkness of a California state of mind. The love stories Bethany spins on California Nights all detail the highs and the lows of relationships, similar to the juxtaposition of a the band's native Los Angeles – a place tinted by candy-colored palm trees and pale blue skies while existing within the loneliness and desperation of waterless place. More than that, there is a literal...


text:
My Nonprofit Reviews
Review for Matthew Kelly Foundation, Cincinnati, OH, USA
TMKF has an amazing ability to connect with audiences of all ages and backgrounds. Whether one is looking for a quick pick me up, a life changing journey or anything in between, TMKF has it. From grade schools to nursing homes. Two words: relevant and powerful.
More Feedback
What I've enjoyed the most about my experience with this nonprofit is...
...the relevance of their message. Timely and so very easy to to digest and implement.
The kinds of staff and volunteers that I met were...
...upbeat, down to earth, and caring.
If this organization had 10 million bucks, it could...
...change the world FASTER than it already is. More staff reaching more people in more age groups in more countries.
How frequently have you been involved with the organization?
About every six months
When was your last experience with this nonprofit?


text:
You are using an outdated browser. Please upgrade your browser to improve your ReverbNation experience.
Before the Fire consists of five individuals, each coming from other local bands of the Lee County area sharing a common goal. That goal is to make music that not only pleases themselves but pleasing the ear of every individual ear that hears it. With lyrics pulled from the soul and the music to back it, Before the Fire promises to be a force that is to be heard.


text:
Rangers Photos
Photos: Nellie goes yard; Derek Holland dominates; Rangers celebrate shut out win in Oakland
Photo: Thearon W. Henderson/Getty Images
OAKLAND, CA - AUGUST 04: Ian Kinsler #5 of the Texas Rangers gets his throw off to complete the double-play as Brandon Moss #37 of the Oakland Athletics slides into second base in the ninth inning at O.co Coliseum on August 4, 2013 in Oakland, California. The double-play ended the game with the Rangers winning 4-0. (Photo by Thearon W. Henderson/Getty Images)
To post a comment, log into your chosen social network and then add your comment below. Your comments are subject to our Terms of Service and the privacy policy and terms of service of your social network. If you do not want to comment with a social network, please consider writing a letter to the editor.