Today I was trying to access the web page from and getting following error Error Message:Login failed for user . The user is not associated with a trusted SQL Server connection.Web server and database are on different server and I am using Virtual machines (VMWare) for my development and DB server.There can be problem in SQL server or IIS or application, so lets start with SQL Server.SQL Server Settings: The security should be set for SQL Serverand Windows Authentication.
The SQL server has the logins for authenticated users and has proper permissions as I also use development machine to maintain DB.
IIS: Open IIS and select properties and under directory security tab click edit button.
Uncheck Anonymous access and check integrated windows security; integrated windows security will enable users login to be used for authentication instead of IIS default user.
Now, lets put application web.config under microscope. I have custom error tag to redirect error to default page
Here is another tag identity. Ah! Impersonate is false and I want it false so I can have connection pooling.
So where is the problem, all the setting seems right, why the heck it does not work. I changes the identity impersonate tag to true and Voila! It works.J For the time being I can work but it’s not a solution. L Adding a login to SQL Server for IIS user of web server is also not going to work.
As many webmasters ask about where and how to choose one of the best ASP.NET hosting provider. In this post, we display the top 3 providers, including ASPHostPortal, HostForLIFE and DiscountService, which enjoy high reputation in this field.
Cheap ASP.NET Web Hosting 2016 Review and Comparison
Brief Introduction to the Criteria on Rating Best ASP.NET Web Host
Choosing a quality ASP.NET hosting provider is not an easy job for most users, especially those newbies. Therefore, our editors have done the hard work for you and finally named the companies above as the best ASP.NET web hosting companies. The major checkpoints that we have taken into consideration during this process are listed as below.
Offering the latest version of Windows OS – It is beyond no doubt that operating systems are of great importance for ASP.NET. All the companies above support the recommended versions of Windows OS, including 2012R2, 2012, and 2008R2.
Keeping update with the MS technologies – A quality hosting provider has to take advantage with the cutting-edge Microsoft technologies, such as the latest .NET framework, SQL Server, Silverlight, and MVC.
Easy to use – Since the management of hosting accounts and websites require some technical know-how, it is helpful for users to have access to easy-to-use control panels, such as Plesk and WebSitePanel.
Reasonable and affordable prices – Reputable companies are dedicated to providing hosting packages at affordable prices to help users narrow their budgets. Besides, they offer some discount to further benefit users in a real sense.
Reliable and fast hosting environment – Due to the utilizing of robust infrastructures and advanced technologies, all of the companies have the capability to ensure that users websites are accessible to their visitors in a stable and fast manner.
Responsive technical support – They support a wide range of communication channels to render users with timely and professional assistance at anytime and anyplace.
Excellent community reputation – With years of hosting experience, these companies have earned themselves a large user base. By comprehensive investigations, a considerable proportion of the users have assumed their satisfaction to the companies’ hosting services.
ASPHostPortal.com - Cost-effective ASP.NET Hosting Service Provider
ASPHostPortal.com was launched in 2008. They are one of the best Windows Hosting in United States is ASPHostPortal.com. This company currently supports Windows Server 2012 hosting with ASP.NET 4.5 / 4.5.1 / 4.5.2, MVC 5.1 / 5.1.1 / 5.1.2/6, Visual Studio 2012, WebSockets, IIS 8.5 and support the latest Microsoft technology. All of its Windows hosting services are 100% compatible with ASP.NET 5. The price of ASPHostPortal.com ASP.NET 5 hosting packages is quite competitive, especially the Host One which we may recommend most here. Going through this promotional link directly and you will get FREE DOMAIN or DOUBLE SQL SPACE, the Host One Windows hosting package is $5.00/mo. This company offers money back guarantee if any of the clients fail to get the desired results. If the company does not work up to the expectations in a certain month, and the valid refund period is 30 days. In addition, the customer service is based on US and the representatives are working 24/7.
HostForLIFE.eu - Premium ASP.NET Hosting Service Provider
HostForLIFE.eu specializing in offering affordable and manageable DotNetNuke 8 hosting services, releases three plans for the clients – Classic Plan, Budget Plan, Economy Plan and Business Plan regularly starting at €3.00/mo, €5.50/mo, €8.00/mo and €11.00/mo separately. And also, the 30-day money back guarantee is offered to the clients who wish to cancel their accounts and get a refund. HostForLIFE supports Windows 2012/2008, ASP.NET 2.0/3.5SP1/4.0/4.5.1/5 as well as IIS8.5/ IIS8. It offers various versions of Microsoft SQL Databases, including MS SQL 2014, MS SQL 2012, MS SQL 2012R2 and MS SQL 2008. Each database comes with at least 500MB disk space. Furthermore, the webmasters can install the software by using one-click app installer. Besides, it is worth mentioning that the webmasters can get a full control of their websites through the users-friendly. ASP.NET control panel of HostForLIFE. By using the top-level data center HostForLIFE delivers average 99.99% uptime to each hosted website.
DiscountService - A Superior ASP.NET Hosting Service Provider
DiscountService.biz is Microsoft Gold Partner, which means they are the first one to know the latest Microsoft technology and test Microsoft product before being released to the public. The engineers from DiscountService. fully understand the needs of Microsoft developer, when signing up their service, their customer could choose the version of platform to better support their application. IIS ASP.NET security from DiscountService. is also at FULL Trust level. The price of DiscountService is at $7.00/month.