PROBLEM

Error: 18456, Severity: 14, State: 38
Login failed for user 'produser'. Reason:Failed to open the explicitly specified database. [CLIET: 192.168.10.10]
or
Error: 18456, Severity: 14, State: 16.
Login failed for user 'XXXXXX'. [CLIENT: xxx.xx.x.xxx]

This is one of the most frustrating login failure errors on SQL Server. It does not mention what database the login was trying to connect to. The windows event viewer logs do not give any further information.

SOLUTION

It seems that prior to SQL Server this meant the same as State 16. But in that case you would actually see the database name to which the login was trying to connect.
To troubleshoot state 38 you need to run a profiler trace and capture the following two events.

Errors and Warnings: User Error Message Security Audit: Audit Login Failed.

Make sure you select all the columns and run the trace while the login attempt is made.
For the event “User Error Message” you should see the database name to which the connection is being attempted. Verify the database exists and verify that the user has been created in the database and has the permission to connect to the database. You should also check if this is an orphaned user and fix it.

When you make a fresh installation of Drupal 7, your URL will look like the following:

http://localhost/~user/drupal7/?q=user

Information from Google's webmaster guidelines means that clean URLs are important: "If you decide to use dynamic pages (URL contains a "?" character), be aware that not every search engine spider crawls dynamic pages as well as static pages. It helps to keep the parameters short and the number of them few. This style of URLS can be hard to read and can prevent search engine indexing. If you want to avoid these types of URLs styles, you can use "Clean URL" feature of the Drupal. This will eliminate "?q=" from the URLs and will generate the clean URL.

Clean URL use the "mod_rewrite" feature of the Apache server which allow us to create a rules for rewriting the URLS for the all pages of the website.

Enabling clean url:
By default, when we install the Drupal, it check for compatibility with Clean URLs. If enviornment is found as compatible with Clean URLs, it will enable during the installation process. If we need to enable Clean URL after installation, we can manage this through admin section
1. Go to Configuration >> Search and Meta Data >> Clean URLs

2. Check the checkbox "Enable clean URLs" if this is not checked.
3. Click Save Configuration button in order to save your entry.

Sometimes you may face a case where you want to completely remove all tables, views & stored procedures in a MS SQL 2014 database without removing the system views, system tables,  and system stored procedures or without having to delete the database as a whole and recreating it.

You can right-click on each table one by one and try to delete them, only to find out that a foreign key constraint prevents you from doing so, at which time you have to try and figure out how each table relates to the other, and remove them in the correct sequence. If you have a few hundred or even thousand database objects this could take a long time! Finally, We found the solution. The script below will take care of this for you in one shot and give you a clean database to work with.

/* Drop all non-system stored procs */
DECLARE @name VARCHAR(128)
DECLARE @SQL VARCHAR(254)
SELECT @name = (SELECT TOP 1 [name]
FROM sysobjects WHERE [TYPE] = 'P' AND category = 0 ORDER BY [name])
WHILE @name IS NOT NULL
BEGIN
    SELECT @SQL = 'DROP PROCEDURE [dbo].[' + RTRIM(@name) +']'
    EXEC (@SQL)
    PRINT 'Dropped Procedure: ' + @name
    SELECT @name = (SELECT TOP 1 [name] FROM sysobjects WHERE [TYPE] = 'P' AND category = 0 AND [name] > @name ORDER BY [name])
END
GO

/* Drop all views */
DECLARE @name VARCHAR(128)
DECLARE @SQL VARCHAR(254)SELECT @name = (SELECT TOP 1 [name] FROM sysobjects WHERE [TYPE] = 'V' AND category = 0 ORDER BY [name])
WHILE @name IS NOT NULL
BEGINSELECT @SQL = 'DROP VIEW [dbo].[' + RTRIM(@name) +']'
EXEC (@SQL)    PRINT 'Dropped View: ' + @name
SELECT @name = (SELECT TOP 1 [name] FROM sysobjects WHERE [TYPE] = 'V' AND category = 0 AND [name] > @name ORDER BY [name])
END
GO

/* Drop all functions */
DECLARE @name VARCHAR(128)
DECLARE @SQL VARCHAR(254)
SELECT @name = (SELECT TOP 1 [name] FROM sysobjects WHERE [TYPE] IN (N'FN', N'IF', N'TF', N'FS', N'FT') AND category = 0 ORDER BY [name])
WHILE @name IS NOT NULL
BEGIN
    SELECT @SQL = 'DROP FUNCTION [dbo].[' + RTRIM(@name) +']'
    EXEC (@SQL)
    PRINT 'Dropped Function: ' + @name
    SELECT @name = (SELECT TOP 1 [name] FROM sysobjects WHERE [TYPE] IN (N'FN', N'IF', N'TF', N'FS', N'FT') AND category = 0 AND [name] > @name ORDER BY [name])
END
GO

/* Drop all Foreign Key constraints */
DECLARE @name VARCHAR(128)
DECLARE @CONSTRAINT VARCHAR(254)
DECLARE @SQL VARCHAR(254)
SELECT @name = (SELECT TOP 1 TABLE_NAME FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS WHERE constraint_catalog=DB_NAME() AND CONSTRAINT_TYPE = 'FOREIGN KEY' ORDER BY TABLE_NAME)
WHILE @name IS NOT NULL
BEGIN
 SELECT @CONSTRAINT = (SELECT TOP 1 CONSTRAINT_NAME FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS WHERE constraint_catalog=DB_NAME() AND CONSTRAINT_TYPE = 'FOREIGN KEY' AND TABLE_NAME = @name ORDER BY CONSTRAINT_NAME)    WHILE @CONSTRAINT IS NOT NULL
    BEGIN
        SELECT @SQL = 'ALTER TABLE [dbo].[' + RTRIM(@name) +'] DROP CONSTRAINT [' + RTRIM(@CONSTRAINT) +']'
        EXEC (@SQL)
        PRINT 'Dropped FK Constraint: ' + @CONSTRAINT + ' on ' + @name

        SELECT @CONSTRAINT = (SELECT TOP 1 CONSTRAINT_NAME FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS WHERE constraint_catalog=DB_NAME() AND CONSTRAINT_TYPE = 'FOREIGN KEY' AND CONSTRAINT_NAME <> @CONSTRAINT AND TABLE_NAME = @name ORDER BY CONSTRAINT_NAME)
    END
SELECT @name = (SELECT TOP 1 TABLE_NAME FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS WHERE constraint_catalog=DB_NAME() AND CONSTRAINT_TYPE = 'FOREIGN KEY' ORDER BY TABLE_NAME)
END
GO

/* Drop all Primary Key constraints */
DECLARE @name VARCHAR(128)
DECLARE @CONSTRAINT VARCHAR(254)
DECLARE @SQL VARCHAR(254)
SELECT @name = (SELECT TOP 1 TABLE_NAME FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS WHERE constraint_catalog=DB_NAME() AND CONSTRAINT_TYPE = 'PRIMARY KEY' ORDER BY TABLE_NAME)
WHILE @name IS NOT NULL
BEGIN
    SELECT @CONSTRAINT = (SELECT TOP 1 CONSTRAINT_NAME FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS WHERE constraint_catalog=DB_NAME() AND CONSTRAINT_TYPE = 'PRIMARY KEY' AND TABLE_NAME = @name ORDER BY CONSTRAINT_NAME)    WHILE @CONSTRAINT IS NOT NULL
    BEGIN
        SELECT @SQL = 'ALTER TABLE [dbo].[' + RTRIM(@name) +'] DROP CONSTRAINT [' + RTRIM(@CONSTRAINT)+']'
        EXEC (@SQL)
        PRINT 'Dropped PK Constraint: ' + @CONSTRAINT + ' on ' + @name
        SELECT @CONSTRAINT = (SELECT TOP 1 CONSTRAINT_NAME FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS WHERE constraint_catalog=DB_NAME() AND CONSTRAINT_TYPE = 'PRIMARY KEY' AND CONSTRAINT_NAME <> @CONSTRAINT AND TABLE_NAME = @name ORDER BY CONSTRAINT_NAME)
    END
SELECT @name = (SELECT TOP 1 TABLE_NAME FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS WHERE constraint_catalog=DB_NAME() AND CONSTRAINT_TYPE = 'PRIMARY KEY' ORDER BY TABLE_NAME)
END
GO
/* Drop all tables */

If you are sysadmin, Your default database set to one of the user database. If you decide to take offline for your default database before you set default to another database.  You will get the following error:

Cannot open user default database. Login failed. Login failed for user 'xx'

There are the steps below login to server to access master database and then you can set your default database.

PROBLEM           
1. Connected as a sysadmin (windows authentication domain\username)
2. Connect to database server
3. Take offline  your database DB_WH_Report
-- I connected
4. Disconnect to Server
When you try to connect back

ERROR
Cannot open user default database. Login failed. Login failed for user 'xx'

SOLUTION                          
1. Connect to Server
2. Click Option to expand  Connection Propertise
3. Connect to Database Type master
4. Click Connect button

HostForLIFE.eu proudly launches the support of WordPress 4.0 on all our newest Windows Server environment. On WordPress 4.0 hosted by HostForLIFE.eu, you can try our new and improved features that deliver extremely high levels of uptime and continuous site availability start from €3.00/month.

WordPress is a flexible platform which helps to create your new websites with the CMS (content management system). There are lots of benefits in using the WordPress blogging platform like quick installation, self updating, open source platform, lots of plug-ins on the database and more options for website themes and the latest version is 4.0 with lots of awesome features.

WordPress 4.0 was released in August 2014, which introduces a brand new, completely updated admin design: further improvements to the editor scrolling experience, especially when it comes to the second column of boxes, better handling of small screens in the media library modals, A separate bulk selection mode for the media library grid view, visual tweaks to plugin details and customizer panels and Improvements to the installation language selector.

HostForLIFE.eu is a popular online WordPress 4.0 hosting service provider catering to those people who face such issues. The company has managed to build a strong client base in a very short period of time. It is known for offering ultra-fast, fully-managed and secured services in the competitive market.

Another wonderful feature of WordPress 4.0 is that it uses vector-based icons in the admin dashboard. This eliminates the need for pixel-based icons. With vector-based icons, the admin dashboard loads faster and the icons look sharper. No matter what device you use, whether it’s a smartphone, tablet, or a laptop computer, the icons actually scale to fit your screen.

WordPress 4.0 is a great platform to build your web presence with. HostForLIFE.eu can help customize any web software that company wishes to utilize. Further information and the full range of features WordPress 4.0 Hosting can be viewed here http://hostforlife.eu/European-WordPress-4-Hosting

About Company
HostForLIFE.eu is European Windows Hosting Provider which focuses on Windows Platform only. We deliver on-demand hosting solutions including Shared hosting, Reseller Hosting, Cloud Hosting, Dedicated Servers, and IT as a Service for companies of all sizes.

Given the length of this review and the number of plans, it is unrealistic to compare everything of them one by one. As usual, the review focuses on price, features, uptime & speed as well as customer support. Before starting our detailed comparison, we’d like to share with you the overall ratings of the plans based on our first-hand hosting experience and large-sampled customer reviews.

Please refer to this table for more differences and similarities.

Conclusion
Both companies are able to provide brilliant Windows hosting service. If a choice has to be made, we recommend HostForLIFE.eu as your web host because the price is more reasonable, features more complete and the performance and our technical support are awesome.To learn more about HostForLIFE.eu web hosting, please visit http://www.hostforlife.eu

Moodle 2.7 has been released. The upgrade to the free and open source learning management system includes new themes with improved responsive design, a new accessibility-focused text editor and more. These are just the minimum supported versions. In addition to a number of bug fixes and small improvements, security vulnerabilities have been discovered and fixed.  We highly recommend that you upgrade your sites as soon as possible. Upgrading should be very straightforward. As per our usual policy, admins of all registered Moodle sites will be notified of security issue details directly via email and we'll publish details more widely in a week.

Moodle 2.7 brings a few headline feature improvements, including the replacement of the TinyMCE editor with ‘Atto’ and the continued emphasis on responsive design with ‘Clean’ the default theme and the new ‘More’ theme being released. Compared to a number of earlier Moodle releases though, some might question whether there is a compelling reason to upgrade to Moodle 2.7 (especially if you have only recently upgraded to Moodle 2.6).

And here’s Top new features of Moodle 2.7:

Clean and Responsive Design
Moodle 2.7 has two core themes; Clean and More.  Clean is the responsive bootstrap based theme which has now been made the default theme.  More is a completely new, customisable theme, created for the novice user or administrators who are unable to access theme files on the server.

New Text Editor, Atto
 In the latest release of Moodle, they have named the text editor ‘Atto’, the new Atto feature allows tighter integration with Moodle meaning there are enhancements to usability and accessibility like never before.

Mobile Notifications. This is possibly the most exciting new feature to enable ‘push’ learning to users on the go. The essential tool for Learning and Development professions in marketing the platform, this new feature will allow you to push notifications about new learning modules created within Moodle which your learners can take advantage of on the go.

Improved quiz reports and other general improvements to quizzes and question banks, such as the ability to duplicate a question with a single click, the ability to require an attachment for essay questions and the ability to save changes and continue editing;

Improved Scheduling System. Administrators can now schedule, more precisely routine tasks, by specifying the minute/hour/day or month the task is to be run.

First long term support release: 3 years until May 2017 for security and data loss bug fixes .

Easily create and manage Quiz & Question bank. As well as an updated question type selector, duplicating and moving questions is now easier, and there is an option to 'Save changes and continue editing'.

Install the new Moodle software manually

1. First, Move your old Moodle software program files to another location. Do NOT copy new files over the old files.
2. Then, Unzip or unpack the upgrade file so that all the new Moodle software program files are in the location the old files used to be in on the server. Moodle will adjust SQL and moodledata if it needs to in the upgrade.Copy your old config.php file back to the new Moodle directory.
3. As mentioned above, if you had installed any plugins on your site you should add them to the new code tree now. It is important to check that you get the correct version for your new version of Moodle. Be particularly careful that you do not overwrite any code in the new version of Moodle.
4. Do not forget to copy over your moodledata folder / directory. If you don't you will get a "fatal error $cfg- dataroot is not configured properly".

HostForLIFE.eu, a leading Windows web hosting provider with innovative technology solutions and a dedicated professional services team proudly announces New Data Center in London (UK) and Seattle (US) for all costumers. HostForLIFE’s new data center in London and Seattle will address strong demand from customers for excellent data center services in Europe and United States, as data consumption and hosting services experience continued growth in the global IT markets.

The new facility will provide customers and their end users with HostForLIFE.eu.com services that meet in-country data residency requirements. It will also complement the existing HostForLIFE.eu. The London and Seattle data center will offer the full range of HostForLIFE.eu.com web hosting infrastructure services, including bare metal servers, virtual servers, storage and networking.

"Our expansion into London and Seattle gives us a stronger European and American market presence as well as added proximity and access to our growing customer base in region. HostForLIFE.eu has been a leader in the dedicated Windows & ASP.NET Hosting industry for a number of years now and we are looking forward to bringing our level of service and reliability to the Windows market at an affordable price,” said Kevin Joseph, manager of HostForLIFE.eu, quoted in the company's press release.

The new data center will allow customers to replicate or integrate data between London and Seattle data centers with high transfer speeds and unmetered bandwidth (at no charge) between facilities. London and Seattle, itself, is a major center of business with a third of the world’s largest companies headquartered there, but it also boasts a large community of emerging technology startups, incubators, and entrepreneurs.

For more information about new data center in London and Seattle, please visit http://www.HostForLIFE.eu

About Company
HostForLIFE.eu is European Windows Hosting Provider which focuses on Windows Platform only. We deliver on-demand hosting solutions including Shared hosting, Reseller Hosting, Cloud Hosting, Dedicated Servers, and IT as a Service for companies of all sizes.

Most of SharePoint customers suffer no issues when integrating SQL Server Reporting Services 2012 (SSRS 2012)  with SharePoint 2010 (SP 2010), however we had quite a bit of trouble. So for those who may also be having some trouble, we would describe how to fix the error. You can following the steps bellow:

- First, you should install SQL Server with Reporting Services Add-in for SharePoint
- Install SharePoint on the Reporting Services Server and connect that server up to the farm (using Configuration Wizard)
- Install the rsSharePoint.msi file provided by Microsoft on all your front-end servers running SharePoint
- Run these two commands on all front-end servers running Sharepoint
- Run these two commands on all front-end servers running Sharepoint  

• Install-SPRSService
• Install-SPRSServiceProxy

- Navigate to Central Administration -> System Settings > Manage services on server.  Start the SQL Server Reporting Services Service
- Navigate to Central Administration -> Application Management > Manage Service Applications.  Create a new SQL Server Reporting Services Service Application

Problem 1:
"Install-SPRSService : The term 'Install-SPRSService' is not recognized as the name of a cmdlet, function, script file, or operable program. Check the spelling of the name, or if a path was included, verify that the path is correct and try again"

Solve:
You should install the Reporting Services SharePoint Add-In (Found on your SQL Server 2012 installation media) on every server running SharePoint. Please don't use the rsSharePoint.msi provided on Microsoft's website.

Problem 2:
"When we try to create a SQL Server Reporting Services Service Application under 'Manage Service Applications', we receive an error relating to permissions to a registry key"

Solve:
There's nothing wrong with your registry except that SharePoint is looking for files that don't exist.  This is because you most likely installed the Reporting Services SharePoint Add-In with the rsSharePoint.msi file that Microsoft provides on their website. That file is a cut-down version of what gets installed when you install the Add-In from the SQL Server 2012 installation media.  Uninstall it from Control Panel, and re-install it with the SQL Server 2012 installation media. 

Problem 3:
"we have created my SQL Server Reporting Services Service Application, but when we try to access any of the links inside it (system settings for instance), we are receiving a 503 unauthorised error message"

Solve:
This may vary from case to case, but for me it was because we ran these commands on every front end server:

• Install-SPRSService
• Install-SPRSServiceProxy

When in actual fact, depending on your scenario (SharePoint Standard Licensing we think is the cause), you should only run these scripts on the server that you wish to be running the Server Service. You will need to uninstall them by using the following scripts (remember to delete the application and stop the service  in Central Admin first)

• Install-SPRSServiceProxy –uninstall
• Install-SPRSService -uninstall

ASP.NET 4.5.2 European Shared Hosting with HostForLIFE.eu

Windows & ASP.NET 4.5.2 Shared Hosting refers to the type of hosting where there is server which hosts many different website that is a website does not individually have a dedicated server for its own purpose. Shared Web hosting is a type of web hosting that allows many websites on the same server. The different websites owned by different people that are present on this sever share the same IP address, the same connectivity, the same CPU time.

Simplicity and Cost-efficiency are the two main benefits. Sharing server space can be fairly cheap. The free add-ons, such as templates and website builders, also save the webmaster money. The host manages the resources and maintains the server, which makes things a lot easier on the site owners. For the technically challenged, this is the best solution, since no knowledge of programming, designing, or hosting is required.

HostForLIFE.eu ASP.NET 4.5.2 Shared Hosting Rich Feature and Cost Effective

HostForLIFE.eu offers five types of ASP.NET 4.5.2 shared hosting plans start from €1.29 per month. With all of the shared hosting plans you can host unlimited amount of domains. Its HostForLIFE.eu LITE Shared Hosting Plan starts at €1.29 /month, and include features like 1000MB Disk Space, 10GB Monthly Bandwidth, the latest stable technologies like Windows Server 2012, Internet Information Services 8.0 / 8.5, SQL 2014, SQL 2012, SQL 2008 R2, SQL 2008, ASP.NET 4.5, ASP.NET 4.5.2, ASP.NET MVC 5.2, Silverlight 5 and 100+ Free WebMatrix and PHP Applications.

HostForLIFE.eu European ASP.NET 4.5.2 Cloud Hosting is Affordable

Cloud Hosting systems are becoming more and more popular, because web hosts, basically Shared Hosting providers have to deal with a large amount of websites which require growing amount of resources. Cloud hosting can be useful for many companies for many reasons. Hosting in the cloud different technologies can be used together that can't be used together with regular hosting. For instance, with cloud hosting it is possible to use PHP and ASP files together and even in the same folder because it can draw the technologies needed from the cloud. This gives you better flexibility and the ability to use almost any type of technology you want to and know that it will mesh without a hitch.

Price and Technical Support in HostForLIFE.eu European ASP.NET 4.5.2 Cloud Hosting

HostForLIFE.eu is another hosting provider that has been known for offering fast and reliable servers.  HostForLIFE.eu lowest-priced ASP.NET Cloud Hosting called Bronze Plan has 1 GB Diskspace, 10 GB Bandwith, Guaranteed Conn 10Gb/s and Dedicated App Pool priced at €1.49 per month.

HostForLIFE.eu provides 24/7 customers support through its Helpdesk and Email support. Our Microsoft certificated technicians offer the most professional support to help our customers on ASP.NET issues effectively. Besides, customers can check our knowledgebase to diagnose issues by themselves.

ASP.NET 4.5.2 Reseller Hosting with HostForLIFE.eu

Reseller hosting is the web hosting program or service which re bundles the services that are available from the primary providers or the real web hosts. The reseller can sell space and bandwidth from a rented dedicated server. Alternatively, the reseller can get permission to sell space and bandwidth from shared server. This type of hosting is the most inexpensive method by which websites can be hosted on the internet.

Reseller hosting is the perfect solution for webmasters, designers, developers, internet consultants or anyone wanting to start a profitable online business. If you're looking to get into the reseller hosting business, Plesk Panel reseller hosting is the best option. Reseller web hosting is an ideal solution for those who already have a web site but maximum reliability, performance and uptime is critical to their business or e-commerce web site. A webmaster may require a network of websites under different domain names to serve different business plans, but all are hosted under a common reseller hosting account.

Why Choose us to be Your ASP.NET Reseller Hosting Partner?

HostForLIFE.eu Windows ASP.NET 4.5.2 Reseller Plans starts from €15.00/month allow our customer to re-brand our control panel, thus, we remain completely anonymous. We also offer private nameserver and this service is available upon request. With no contracts, the ability to cancel anytime, and a 30 day money back guarantee, our unlimited reseller hosting is completely risk free.

Some of the highlighting or standout features of HostForLIFE.eu’s Reseller Plan are 10 domains, 40GB Diskspace , 200 GB Bandwith 4GB RAM or higher, DAILY Server Monitoring and support the latest technology from Microsoft such as ASP.NET 4.5.2 Hosting, ASP.NET 5.2, SQL Server 2012/2014, Windows Server 2008/2012. HostForLIFE also provide free application download softwares like Joomla 3.3, WordPress 3.9, DotNetNuke, WebMatrix Application, Mambo, Joomla, phpBB, BlogEngine.NET,etc.