Windows 2012 Hosting - MVC 6 and SQL 2014 BLOG

Tutorial and Articles about Windows Hosting, SQL Hosting, MVC Hosting, and Silverlight Hosting

Windows 2008 Hosting - ASPHostPortal :: How to Fix - Failed to generate a user instance of SQL Server due to failure in retrieving the user's local application data path

clock November 24, 2011 06:53 by author Jervis

When you are trying to connect to a "user instance" of SQL Server from your Web application running on Windows 7 or Windows 2008 R2 and you’re getting a message that looks like this:



I will try to help you here.

Note: this error only happens if you have User Instance=true in your connection string. The IIS team made a change to the default identity of the worker process.   Starting with IIS 7.5, Application Pools run with a unique identity based on the Application Pool name, rather than NetworkService – the default identity for IIS6 and IIS7.  The primary reason for this change is to increase the security of IIS and Application Pools by default, providing a much better sandbox between Applications and other Windows services by default. 

Unfortunately, the new identity does not have a user profile, and as you can see from the error, this causes the SqlClient data stack to fail.  There are a few things you can do to "fix" this error: 

1) switch back to NetworkService
2) switch to a user account that has a local profile (like a real user / domain user account).  To do that, fire open IIS Manager and browse to Application Pools node for your computer.  Click on the AppPool for the application you are trying to run and select the “Advanced Settings” task (in yellow on right).  Select identity and choose NetworkService as a built-in account, or select “Custom account” and type in the user/password. 



If you’re a command-line person, you can do it this way (all on one line):

%windir%\system32\inetsrv\appcmd.exe set config 
-section:system.applicationHost/applicationPools /[name='YOUR_APPPPOOL_NAME_HERE'].processModel.identityType:"NetworkService" 
/commit:apphost



WebMatrix Hosting - ASPHostPortal :: WebMatrix and jQuery Mobile

clock November 18, 2011 07:22 by author Jervis

Recently I have seen a number of examples using ASP.NET MVC with jQuery Mobile for displaying a list of blog posts to mobile devices. I thought I would show you similar code for doing this with the ASP.NET Web Pages Framework and Razor View Engine via WebMatrix. I want to warn you up front that the solution will seem too easy. One page, and only 1 page of code and markup is all that we will need to write to create the solution ( besides our sample database, of course ).

First things first, we need a database. Let's create a simple SQL Server CE 4 database right within WebMatrix itself. The database tooling feels a lot like SQL Server Management Studio, which is fantastic for new developers as they can take these skills with them for managing other versions of SQL Server. Here is a quick snapshot of the database definition:



Once we have the database defined and add a bit of data that I pulled from my blog, I can go ahead and create a blank Razor Page with all the necessary stylesheets, JavaScript files, HTML markup, and Razor code. You can click on the image to see a more viewable version of the page, but even now it looks way too easy.



 In the example, we connect to the database, define a query, and then execute the query and return the results. In this case the results are posts from the database. Further down the page we iterate through each post, displaying the date the post was published as well as a clickable title that takes you to the post.

The bonus here is that if the needs of your application grow, you can easily convert this to ASP.NET MVC 3. The top-most code gets swallowed up into a controller or service per your strategy for separating the concerns, leaving the HTML and Razor markup the same in the rest of the page.

Now here is the best part - click Run :)



You have a quick list of posts that give you a wonderful user experience on your mobile phone or tablet.



Visual Studio 2010 Hosting - ASPHostPortal :: How to Define data in LightSwitch Application

clock November 17, 2011 07:46 by author Jervis

VisualStudio LightSwitch is a new development tool designed especially for rapid application development (RAD) techniques in line of business application development. Data centric application can be easily developed by simply designing data structures and related UI.

We can easily define the data in Visual Studio LightSwitch.

1. Create a new LightSwitch application in Visual Studio 2010.



2. Click on create new table.



3. Change the table name to company and add the attribute name and their corresponding types.



4. By clicking on data sources add another table and change its name to employee add the attributes and their datatypes.



5. By clicking on data sources add another table and change its name to joining add the attributes and their datatypes.



6. Define the relationship Between employees and joining as many to one by click on relationship tab.



7. By clicking on data sources add another table and change its name to salarydetails add the attributes and their datatypes.



8. Define the relationship Between employees and salarydetails as many to one by click on relationship tab.



Visual Studio LightSwitch Hosting - ASPHostPortal :: Benefits Using Visual Studio LightSwitch

clock November 10, 2011 06:33 by author Jervis

In this article, I will discuss the benefits of using Visual Studio LightSwitch. Ok, lets see this point below:

1. Build business applications like they were created by a professional designer Visual Studio LightSwitch 2011 comes with an extensible set of pre-built Application Shells that can give your application the familiar feel of popular Microsoft software.

2. Build a better application faster Visual Studio LightSwitch 2011 includes templates for the most common types of business applications. It also contains predefined data types for commonly used fields, like phone numbers and e-mail addresses.

3. Simplify development The intuitive Visual Studio LightSwitch 2011 development environment simplifies the development experience and provides assistance when you need it – displaying tools specific to the task at hand. In this environment, you can access the tools you need, when you need them.

4. Evolve your application as business needs change The pre-built templates and components in Visual Studio LightSwitch 2011 are fully extensible, so adding additional features to your application as needed is fast and easy.

5. Quickly add user-friendly features Visual Studio LightSwitch 2011 applications support exporting data to Microsoft Office Excel for easy sharing and reporting, without requiring additional work on your end.Use the asynchronous data loading routines in Visual Studio LightSwitch 2011 to build applications that remain responsive while loading data.

6. Easily add powerful authentication features Built-in authentication models make it simple to provide different users with varying degrees of access and authorization. Visual Studio LightSwitch 2011 automatically generates the administration console for you, giving the administrator a simple, intuitive way to set user roles and permissions.

7. Create a custom application for the way you do business Build your application to do exactly what you need it to. Visual Studio LightSwitch lets you create custom business logic and rules that are unique to your particular business and users. Visual Studio LightSwitch 2011 makes it easy to collect, analyze and reuse information from a variety of data sources including Microsoft SQL Server, Microsoft SQL Azure, Microsoft SharePoint and other 3rd party databases, helping you get the most of your business information.

8. Customize using extensions Custom extensions such as Money and Phone Number business types are included in LightSwitch. Picture and Text layout extensions provide new ways to present data on screen. You can use shell extensions and theme extensions to change the appearance and behavior of an application by changing just one setting.

9. Visual Studio LightSwitch 2011 is a companion to Visual Studio Professional, Premium and Ultimate Visual Studio LightSwitch 2011 works seamlessly with Visual Studio Professional, Premium or Ultimate giving you the best of both. LightSwitch uses the same project templates as Visual Studio Professional making it easy to carry applications into that IDE. If your application evolves to the point where you need to access the tools and features of a more powerful development environment – just upgrade.

10. Speed Deployment and Updates With Visual Studio LightSwitch 2011, you can create one application that can be deployed to desktop clients, browser clients or through the cloud. You can choose the best deployment method based on how and where people work.

Reasons why you must trust ASPHostPortal.com

Every provider will tell you how they treat their support, uptime, expertise, guarantees, etc., are. Take a close look. What they’re really offering you is nothing close to what ASPHostPortal does. You will be treated with respect and provided the courtesy and service you would expect from a world-class web hosting business.


You’ll have highly trained, skilled professional technical support people ready, willing, and wanting to help you 24 hours a day. Your web hosting account servers are monitored from three monitoring points, with two alert points, every minute, 24 hours a day, 7 days a week, 365 days a year. The followings are the list of other added- benefits you can find when hosting with us:

- DELL Hardware
Dell hardware is engineered to keep critical enterprise applications running around the clock with clustered solutions fully tested and certified by Dell and other leading operating system and application providers.
- Recovery Systems
Recovery becomes easy and seamless with our fully managed backup services. We monitor your server to ensure your data is properly backed up and recoverable so when the time comes, you can easily repair or recover your data.
- Control Panel
We provide one of the most comprehensive customer control panels available. Providing maximum control and ease of use, our Control Panel serves as the central management point for your ASPHostPortal account. You’ll use a flexible, powerful hosting control panel that will give you direct control over your web hosting account. Our control panel and systems configuration is fully automated and this means your settings are configured automatically and instantly.
- Excellent Expertise in Technology
The reason we can provide you with a great amount of power, flexibility, and simplicity at such a discounted price is due to incredible efficiencies within our business. We have not just been providing hosting for many clients for years, we have also been researching, developing, and innovating every aspect of our operations, systems, procedures, strategy, management, and teams. Our operations are based on a continual improvement program where we review thousands of systems, operational and management metrics in real-time, to fine-tune every aspect of our operation and activities. We continually train and retrain all people in our teams. We provide all people in our teams with the time, space, and inspiration to research, understand, and explore the Internet in search of greater knowledge. We do this while providing you with the best hosting services for the lowest possible price.
- Data Center
ASPHostPortal modular Tier-3 data center was specifically designed to be a world-class web hosting facility totally dedicated to uncompromised performance and security
- Monitoring Services
From the moment your server is connected to our network it is monitored for connectivity, disk, memory and CPU utilization – as well as hardware failures. Our engineers are alerted to potential issues before they become critical.
- Network
ASPHostPortal has architected its network like no other hosting company. Every facet of our network infrastructure scales to gigabit speeds with no single point of failure.
- Security
Network security and the security of your server are ASPHostPortal’s top priorities. Our security team is constantly monitoring the entire network for unusual or suspicious behavior so that when it is detected we can address the issue before our network or your server is affected.
- Support Services
Engineers staff our data center 24 hours a day, 7 days a week, 365 days a year to manage the network infrastructure and oversee top-of-the-line servers that host our clients’ critical sites and services.



About ASPHostPortal.com

We’re a company that works differently to most. Value is what we output and help our customers achieve, not how much money we put in the bank. It’s not because we are altruistic. It’s based on an even simpler principle. "Do good things, and good things will come to you".

Success for us is something that is continually experienced, not something that is reached. For us it is all about the experience – more than the journey. Life is a continual experience. We see the Internet as being an incredible amplifier to the experience of life for all of us. It can help humanity come together to explode in knowledge exploration and discussion. It is continual enlightenment of new ideas, experiences, and passions


Author Link


Corporate Address (Location)

ASPHostPortal
170 W 56th Street, Suite 121
New York, NY 10019
United States

Sign in