Xbox Error Code 80150017 for Irish (& possibly UK) Customers

Burnout Paradise on XBox 360 was available for free this month for Xbox Gold customers. However, I could not download it no matter what I tried.

On Xbox 360, I would get the error message 80150017 – corrupted format or incorrect region – while using a website or Xbox One simply told me that “My purchase could not be completed. Please try again later”.

A call to Microsoft identified that while, I was registered as an Irish billing customer, my IP was showing to them as UK and as such I could not purchase Irish content from the UK.

So I checked my Vodafone Ireland IP address using different web resources – IPLocation.net and Speedtest.net identified me as in Ireland but findmyip.org identified me as in the UK while cmyip.com identified me as the UK Department of Work and Pensions !!!

I did switch my router off and on and got a different IP but the same problem remained :

51.37.233.209

51.37.233.210

This Vodafone Ireland community thread (https://community.vodafone.ie/t5/Technical-Support/Incorrect-IP/td-p/1) shows that I am not the only “UK Department of Work & Pensions” (The conspiracy theorist in me wonders whether that is a euphemism for UK GCHQ intelligence gathering in Ireland)

For a finish, I took my three.ie mobile phone down the road where I could get a decent 4G connection (which is terrible in and around my house) and was able to purchase Burnout Paradise through my smartphone using this other service provider’s IP address.

Advertisements

SQL Server Reporting Services not automatically starting after a reboot

I am surprised how often I get this alert from SCOM – “The Windows service for the Reporting Services instance MSSQLSERVER has stopped on computer XYZ”.

I have seen this more than a couple of times and thought it worth blogging about.

Check the Windows Event Logs (System) and look for “Service Control Manager” failures around the last reboot time with the error message “The SQL Server Reporting Services (MSSQLSERVER) service failed to start due to the following error: The service did not respond to the start or control request in a timely fashion”. There is usually a second failure nearby : “A timeout was reached (30000 milliseconds) while waiting for the SQL Server Reporting Services (MSSQLSERVER) service to connect.”

The solution is to increase the default service time-out as follows :

  • Open Regedit
  • Navigate to: KEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control
  • Create a new DWORD value called ServicesPipeTimeout
  • Modify it and ensure it is set to Decimal  and enter the value 60000
  • Close Regedit
  • Reboot the server
  • Confirm that SQL Reporting services satrted correctly

Be aware that this affects all windows services and not just Reporting Services. For safety, backup the registry before applying any changes.

Effective Indexing – Niall Flanagan – Belfast, May 15th 2014

This topic will cover the performance benefits and important considerations of good indexing design in SQL Server including

  • Considerations
  • Benefits & Concepts
  • Statistics
  • Table/Index Design
  • Clustered, Non-clustered, & Heap
  • Fragmentation
  • Why cheap hardware is not always the answer

About Niall:
Niall Flanagan is a Team Lead in a Database Services team that manages production Oracle, Sybase and SQL Server databases in a large Irish retail bank. Niall founded the SQL Server Ireland User Group in early 2006 and continues to lead it. In addition, he presents on SQL Server to various user groups and conferences throughout Ireland. Niall is a Microsoft SQL Server Most Valued Professional (MVP) since October 2006.

Venue:
Adelaide Exchange Belfast.

Registration: http://www.mtug.ie/events/event/effective-indexing-belast-sql-user-group/

When: May 15th, 2014 18:00 – 20:30

Getting the most from your SAN – File and Filegroup Layout – with Stephen Archbold

Synopsis: You’ve been given the task of optimising the File and Filegroup layout to get the most from your storage. Not sure where to start, or thinking you could get a more from your storage with a different design?

Are your SAN guys telling you your storage can process 2 GB/s but you’re only seeing 200 MB/s?

This session will dive into how to optimise your file and filegroup layout strategy to get the most from your I/O Subsytem, including a case study where we took a customers table scans from 500 MB/s to 1.2 GB/s with only a change in filegroup layout.

Topics covered include: – Layout for OLTP – Data Warehousing Fast Track Style – Data Warehousing on a SAN – Get data into your SSAS cubes faster (ProcessData) – Hidden options and “go faster” buttons – How to maximise performance in enterprise edition and master read ahead

Bio: Stephen is a SQL Consultant at Prodata Business Systems, with over 6 years experience working with SQL Server as a Production DBA. He has a focus on Performance Tuning and Consolidation to get the most from your investment in SQL Server.

Venue: Microsoft Atrium, Sandyford. Limited parking available accessible from the rear of the building.

Registration:

http://ssiug140107.eventbrite.ie

When January 7th, 2014 18:30 – 20:30

2013 in review

The WordPress.com stats helper monkeys prepared a 2013 annual report for this blog.

Here’s an excerpt:

A New York City subway train holds 1,200 people. This blog was viewed about 5,900 times in 2013. If it were a NYC subway train, it would take about 5 trips to carry that many people.

Click here to see the complete report.

Xmas with AppDynamics, DubJUG, ISDN and Dublin DevOps!

 

Date/Time Date(s) – 12/12/2013 6:00 pm – 9:00 pm

Location TCube

Join AppDynamics’ Pete Holditch, Irish Comedian Colm O’Regan and musician Greg Clifford for the final 2013 event of the Dublin Java User Group and the Irish Software Developers Network, which will see the launch of the Dublin DevOps User Group, and a chance to win a year’s Magnet broadband worth up to €1000*! (more…)

Monday, Sept 30 is the last chance for MSDN subscribers to win an Aston Martin

Do you have an MSDN subscription? If so, it includes monthly credit for using Windows Azure. Below is a link for activating the Azure benefit, NO CREDIT CARD required!
Use this link: http://bit.ly/140w35v

By the way, all Gold and Silver Microsoft Partners, all members of BizSpark, all companies that have an EA agreement have multiple free MSDN subscriptions. If you are not using those, this is another incentive to start.

The monthly credit is quite generous, more than enough to run your Dev and Test environments for even large application development projects.

As an added incentive to try out your free MSDN benefits, Microsoft is currently holding a special Aston Martin Sweepstake offer through Sept 30th. The lucky winner will win a 2013 Aston Martin V8 Vantage! (which is why I signed up today)

C Drive Full & guess where SQL Server was installed – Aargh!

It has been a while since I blogged on those “gotchas” that I come across as a SQL Server DBA.

I still acquire already installed & configured SQL Server database systems after an outage brings them to my attention. A more common scenario than desirable is the C Drive filling and impacting the SQL Server installation resident on this same drive. A colleague, James Donnelly, came up with the following script to help move the critical system databases to another drive. This example does assume a default instance rather than a named instance of SQL Server.

1 open command prompt & type the following

NET STOP MSSQLSERVER

2 once complete – start it up again with the /f /T3608
NET START MSSQLSERVER /f /T3608

3 open SQL connection to DB & run the following commands, This will identify where the current location of the mdf & ldf files are located. Open up an Explorer window to this location & verify that the files exist

SELECT name, physical_name AS CurrentLocation, state_desc
FROM sys.master_files

4 Execute the following scripts against the Master db.

— Master DB
ALTER DATABASE master MODIFY FILE( NAME = master , FILENAME = ‘E:\MSSQL\Data\master.mdf’ )
ALTER DATABASE master MODIFY FILE( NAME = mastlog , FILENAME = ‘E:\MSSQL\Log\mastlog.ldf’ )

— Model DB
ALTER DATABASE Model MODIFY FILE( NAME = modeldev , FILENAME = ‘E:\MSSQL\Data\model.mdf’ )
ALTER DATABASE Model MODIFY FILE( NAME = modellog , FILENAME = ‘E:\MSSQL\Log\modellog.ldf’ )

— MSDB DB
ALTER DATABASE MSDB MODIFY FILE( NAME = MSDBData , FILENAME = ‘E:\MSSQL\Data\MSDBData.mdf’ )
ALTER DATABASE MSDB MODIFY FILE( NAME = MSDBLog , FILENAME = ‘E:\MSSQL\Log\MSDBLog.ldf’ )

— TEMPDB
ALTER DATABASE TEMPDB MODIFY FILE( NAME = TempDev , FILENAME = ‘E:\MSSQL\Data\TEMPDB.mdf’ )
ALTER DATABASE TEMPDB MODIFY FILE( NAME = TempLog , FILENAME = ‘E:\MSSQL\Log\TEMPLog.ldf’ )

5 Open CMD prompt & run the following:-
NET STOP MSSQLSERVER

6 Move the following files from the location identified in 3 to the new locations identified in 4

7 Launch SQL Server Configuration Manager (Start-> Programs -> SQL 2012 ->Config Tools -> SQL Server Configuration Manager

Select SQL Server Services & right click on SQL Server (MSSQLSERVER) & select Properties

Select each of the above values for master.mdf & mastlog.ldf files & change them to be the location identified in 4
** Also change the ERRORLOG value to be the MSSQL\Log location.
Select Apply & then OK to close the properties window. Select OK to confirm changes will not take effect until server is restarted.

8 Go to CMD prompt again & type the following command
NET START MSSQLSERVER
** SQL Server should be started now.

9 Execute the following SQL to confirm that all the DB’s have moved
SELECT name, physical_name AS CurrentLocation, state_desc
FROM sys.master_files

New SQL Server Ireland User Group website

The SQL Server Ireland User Group now has it’s own user group blog at http://ssiug.wordpress.com

The first user group meeting details are now published there & I will continue to publish upcoming user group meetings, SQL Server notices, & other related news & events here.

I will continue to blog on other topics, including about SQL Server, here too.

%d bloggers like this: