Windows 2012 Hosting - MVC 6 and SQL 2014 BLOG

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

Free SQL Server Hosting :: How to Handle Error : 1326 Cannot connect to Database Server Error: 40 – Could not open a connection to SQL Server

clock January 21, 2014 05:19 by author Ben

If you are receiving following error:

TITLE: Connect to Server
Cannot connect to Database Server.
ADDITIONAL INFORMATION:
An error has occurred while establishing a connection to the server.  When connecting to SQL Server 2008, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 – Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 1326)


Now if
SQL Server can be connected perfectly from local system but can not be connected from remote system, in that case firewall of the server where SQL Server is installed can be issue.

Follow instructions of this article to fix the issue.

Go to control panel >> Firewall Settings >> Add SQL Server’s Port to Exception List.



Click Add Port and fill this :


Now try to connect to SQL Server again. It will allow you to connect to server successfully.

About the Company
ASPHostPortal.com is a hosting company that best support in Windows and ASP.NET-based hosting. Services  include shared hosting, reseller hosting, and sharepoint hosting, with specialty in ASP.NET, SQL Server,  and architecting highly scalable solutions. As a leading small to mid-sized business web hosting  provider, ASPHostPortal.com strive to offer the most technologically advanced hosting solutions available to  all customers across the world.
Come to the website to know more details.

 



Free, Best and Reliable Entity Framework 6 Hosting with ASPHostPortal.com

clock December 10, 2013 06:57 by author Ben

Entity Framework is actively developed by the Entity Framework team which is assigned to the Microsoft Open Tech Hub and in collaboration with a community of open source developers. Together we are dedicated to creating the best possible data access experience for .NET developers.
The Entity Framework version 6 Release Candidate is now available to developers for immediate download. The open source object-relational mapper is designed to enable .NET developers to work with relational data using domain-specific objects. Entity Framework allows programmers to create a model by writing code or using boxes and lines in the EF Designer. Both of these approaches can be used to target an existing database or create a new database.


There are The Top features of Entity Framework 6 :

  • Connection Resiliency - enables automatic recovery from transient connection failures.
  • Async Query and Save - dds support for the task-based asynchronous patterns that were introduced in .NET 4.5. With .NET 4.5 Microsoft introduced async and await keywords but in EF 5 Microsoft didn't have time to add support for async query and save but now with EF6 it is supported.
  • Code-Based Configuration - gives you the option of performing configuration - that was traditionally performed in a config file - in code.
  • Dependency Resolution - introduces support for the Service Locator pattern and we’ve factored out some pieces of functionality that can be replaced with custom implementations.
  • Interception/SQL logging - provides low-level building blocks for interception of EF operations with simple SQL logging built on top.
  • Testability improvements - make it easier to create test doubles for DbContext and DbSet.
  • Features that come for free - These are capabilities that are part of the core. You don’t even have to know they’re there to benefit from them, much less learn any new coding. This group includes features such as performance gains brought by a rewritten view-generation engine and query compilation modifications, stability granted by the ability of DbContext to use an already open connection, and a changed database setting for SQL Server databases created by Entity Framework.
  • DbContext can now be created with a DbConnection that is already opened - which enables scenarios where it would be helpful if the connection could be open when creating the context (such as sharing a connection between components where you can not guarantee the state of the connection).


Top Reasons To Choose Entity Framework 6 Hosting

  • Fast and Secure Server - Our powerfull servers are especially optimized and ensure the best Entity Framework 6 performance. We have best data centers on three continent, unique account isolation for security, and 24/7 proactive uptime monitoring.
  • Best and Friendly Support - Our support team is extremely fast and can help you with setting up and using Entity Framework 6 on your account. Our customer support will help you 24 hours a day, 7 days a week and 365 days a year.
  • Dedicated Application Pool - With us, your site will be hosted using isolated application pool in order to meet maximum security standard and reliability.
  • Uptime & Support Guarantees - We are so confident in our hosting services we will not only provide you with a 30 days money back guarantee, but also we give you a 99.9% uptime guarantee.
  • World Class Control Panel - We use World Class Plesk Control Panel that support one-click installation.

So, you'll get the best, cheap and reliable Entity Framework 6 hosting with us. Why wait longer?



Free Windows Server 2012 Hosting - ASPHostPortal.com :: New Powershell v3 with Windows Server 2012

clock December 7, 2013 06:25 by author Ben

PowerShell v3.0 is the version included with Server 2012. A great place for PowerShell newbies to get started is with PowerShell's IntelliSense. This feature will help you learn and create the proper PowerShell. As you type in a PowerShell command, you'll see a list of possible syntaxes to go with the command.

 


For example, you may want to install a feature through PowerShell, but are unsure of the proper syntax or exact feature name. Features can be installed through PowerShell with the command instaW-windowsfeature-name. If you go into the Windows PowВ­erShell ISE (integrated scripting engine) and start typing Install . You'll see a dropВ­down menu of all the possible commands that can be used with Install (image 1).

Image 1 - PowerShell IIntelliSense

Image 1 - that you also have a list of modules to scroll through to find the available cmdlets in PowerShell. PowerShell in Server 2012 provides command-line management , and with IntelliSense, also teaches you how to use correct PowerShell syntax at the same time.

WHile there are numerous new capabilities in PowerShell, another significant new feaВ­ture that many of you will want to get acquainted with is Windows PowerShell  Web Access. This feature allows you to manage remote machines using PowerShell through a web browser.


To set up this feature, follow these steps:

1. From Server Manager 's dashboard, click "Add roles and features." Click Next and select "Role-based or feature-based installation." Click Next. Select the server for installation. Click Next again. In the "Select server roles" window, click Features from the left-side menu. Scroll through the features until you see "Windows PowВ­erShell (Installed)." Expand this feature, and Windows PowerShell Web Access  is listed.



2. Select Windows PowerShell Web Access and click Add Features. Click Next three times and then click Install.

3. To automatically configure Windows PowerShell Web Access to use default settings, run Install-PswaWebApplication as an administrator in PowerShell.
After installation, you will see IIS listed in the Server Manager dashboard. The next step in setting up PowerShell Web Access is to configure IIS. In this example, you'll set up PowerShell Web Access in an IIS subfolder:


a. From Server Manager, click Tools and then IIS Manager. Now you need to create an application pool, which is done by expanding the IIS server name, right-clicking on Application Pools, and then selecting Add Application Pools.

b. Name the PowerShell Web Access application pool and click OK.

 

 



c. Right-click the Sites Folder under Default Web Site in the left hand IIS Manager pane. Select Add Application.

d. Enter an alias for the application and browse to select the application pool created in PowerShell Web Access. Also enter the physical path to PowerShell Web Access, which is file:///c:windowswebpowershellwebaccesswwwroot"C:WindowsWebPowerShellWebAccesswwwroot Configure and check authentication by using the "Connect as" and "Test settings" buttons. Click OK.

You can remotely use PowerShell Web Access through a browser by entering the name of the computer PowerShell Web Access is installed on and the name of the PowerShell Web Access Application as a URL in a browser.

SO, for this example, the machine name is DC1 and the PowerShell Web Access Application name is PSWA. After entering the URL http://dc1/pswa > Http://DC1/PSWA , We get the logon screen shown.



Windows Server 2012 Hosting - ASPHostPortal.com :: Import IP Address with IPAM into Windows Server 2012

clock November 21, 2013 07:17 by author Ben

IPAM leverages an intuitive point- and-click web interface to allow you to Easily investigate the IP address space issues . By scanning the network , IPAM maintains a dynamic list of IP addresses and Allows engineers to plan for network growth , Ensure IP space usage meets corporate standards , and reduce IP conflicts .

IPAM is an entirely new feature in Windows Server 2012 that provides highly customizable administrative and monitoring capabilities for the IP address on a corporate network infrastructure or IPAM is the new framework for finding , monitoring and managing it on a network .

IPAM is a feature of Windows Server 2012 and must be installed as such , either by using the Add Roles and Features Wizard or through PowerShell 3.0 and poorly documented in my opinion , making a useful feature harder to use and understand than it should be .

Even without formal organization IPAM applications keep track of their IP address information somehow - most typically in spreadsheets . IPAM lets you view IP address availability and configuration from a database perspective , enabling you to use your addresses more efficiently . IPAM features such as IP reconciliation and automation can Eliminate the need to use spreadsheets for tracking addresses .

IPAM is performed on a Microsoft network by an installable feature of Windows Server 2012 that you run on a domain member server to " watch and centrally manage " the other servers on your network that are actually doing the work . IPAM manages the functionality of the following Windows servers :

  • DHCP Service
  • DNS Server
  • Network Policy Server ( NPS )
  • Active Directory Domain Controller ( DC )


To do import IPAM , IPAM log on to your server and open Server Manager :

  • Click IPAM in far left pane of Server Manager .
  • In the IPAM client , select IP Address Blocks under IP ADDRESS SPACE , and the make sure that Current view is set to IP Addresses in the drop - down menu .
  • If you look along the top window , you will see the IP address listed along the top fields , such as IP Address and IP Address State . You can add or remove fields by right-clicking on one of the existing fields .


If you want to import and Assignment Type yhis information , you need to add these fields to the first line of your import file , without spaces , as shown below :

IPAddress , IPAddressState , AssignmentType , ManagedByService , ServiceInstance , AssetTag

10.160.50.12 , In - Use , Static , IPAM , localhost , BR12

10.160.50.13 , In - Use , Static , IPAM , localhost , BR13

10.160.50.14 , In - Use , Static , IPAM , localhost , BR14

10.160.50.15 , In - Use , Static , IPAM , localhost , BR15

Alternatively , you can keep the spaces in the field names and enclose with quotation marks , for example , " IP Address" and " IP Address State " . The actual IP address of the data should then follow , comma delimited in the same order that you specified the fields as shown above .

Some fields , such as IP Address State , will require you to look and see what the options are valid input . To find out what the possible options are :

Click Tasks in the far right corner of this client and select Add IP Address from the menu .

Select the drop - down menu by the side of the field to see the possible options. For instance , the field can be set to In - Use , Inactive or Reserved .

Now we need to change the status of any discovered servers to Managed . To do this , right click a server in the Server Inventory screen and select Edit Server from the menu .

In the Add or Edit Server window , change the Manageability status to Managed and click OK . Right click the server again , and select Retrieve All Data Server from the menu . Repeat this procedure for all discovered servers . Now you are ready to add the IP addresses , ranges and blocks to IPAM .



Visual Studio 2010 Hosting :: Deploying a WPF Application Using Click-Once Deployment Technology in Microsoft Visual C# 2010 Express

clock November 14, 2013 05:07 by author Ben

Click -Once Enables Web - style application deployment for non - web applications. Applications are published to and deployed from a web or file servers . Although Click Once does not support the full range of features that client applications installed by the Windows Installer does , it does support a subset that includes the following :

  1. Integration with the Start menu and Programs Control Panel .
  2. Versioning , rollback , and Uninstallation .
  3. Online install mode , that always launches an application from the deployment location .
  4. Automatic updating when new versions are released.
  5. Registration of file extensions .

Before proceeding for the deployment , Ensure that your application has been built properly and ready for the deployment . Explains this article with respect to Game in a WPF and the game name is Mr . Gunner .

1.
In Solution Explorer, right-click the project name and select "Properties" as shown in the following snapshot.



2. After clicking on Properties a Publishing Window will open and it has various options, such as Application, Built, Security, Publish and so on. as you can see in the following snapshot.



3. To set an icon for your application, browse for the suitable icon for your application. To set the icon, click on the application and browse the icon (the icon should be a .ico file) , if you don't want to set an icon  for the application then it will be deployed with a default icon in your application as I highlighted with red circles in the following snapshot.



4: Then click on "Publish". Here select the publishing location nothing but browse the folder where you want keep the setup file and other application files and after selecting the publish location then click on the "Publish Wizard" to proceed as shown in the highlighted red circles.



5. After clicking "Publish" a wizard window will open, then click on the "Next" button as shown in the following snapshot:



6.  After selecting CD-ROM or DVD then click "Next" to proceed as shown in the following snapshot:



7. After selecting "Updates" Click "Next" to proceed to the final step as shown in the following snapshot.



8. Now, finally click on the "Finish" button to complete the Publish Wizard as shown in the following snapshot.



Finally, a setup file has been created on the selected folder. Now you can install the application on your system by clicking on the setup file. Have fun working with the installed application.



Windows Server 2012 Hosting - How to set up an Internal SMTP Service for Windows Server 2012 Essentials

clock October 31, 2013 07:26 by author Mike

Windows Server 2012 Essentials does not come with Microsoft Exchange Server as its predecessor Small Business Server 2011 did. However, many small businesses still use a copier or multifunction device that has the ability to scan to email. Some units also allow a fax to email forwarding service. Unfortunately, many of these devices rely on some form of internal SMTP service to enable them to relay emails to recipients.

 

 

Fortunately, you can enable a SMTP service that is built into the core operating system for Windows Server 2012. Here how to do this.


Install the SMTP Service

  1. Launch the Server Manager. From the Search charm, type in Server Manager to find it.

     

  2. From the Dashboard, Add Roles and Features. The Add Roles and Features Wizard will begin. Click Next on the first screen.

     

  3. Select Role-based or feature-based installation.

     

  4. Select the Essentials Server (which should be highlighted by default).

     

  5. Click Next to bypass the Roles selections.

     

  6. Scroll down the list and tick the SMTP Server feature.

     

  7. A new window will pop up to inform you that some other services will also be installed. Click Add Features to confirm and continue. Click Next to continue past the features selection screen.

     

  8. Click Install to complete the Installation.

     

  9. Click Close when the installation has completed.

     

Configure the SMTP Service

  1. From the Search charm, type IIS. Hover your mouse over one of the selections, and run the Internet Information Services (IIS) 6.0 Manager.

     

  2. Click Yes to the UAC Prompt.

     

  3. Expand to SMTP Virtual Server #1, right click and select Properties.

     

  4. General Tab: Set the IP Address to the server’s IP address.

    Note: You can also enable logging is required.

     

  5. Access Tab: Set the IP for the internal devices in the connection button.

     

    Add the same IP to the Relay list.

     

  6. Delivery Tab: Set an external domain – you can use the free customised domain from Microsoft, and you can also optionally add a Smart host, if required. Tick the Attempt direct delivery box, if you want the server to attempt to deliver the email directly first before trying the Smart host.

     

  7. From the Search charm, type Firewall to locate and run the Windows Firewall with Advanced Security console.

     

  8. Add a new Inbound Rule. (Right Click on Inbound Rule, and select New Rule)

     

  9. Select Port.

     

  10. Type in 25 as the local port.

     

  11. Click Next (Allow the Connection).

     

  12. Uncheck Public. (Prevents external access to the server)

     

  13. Give the rule a name, and click Finish to create the rule.

     

  14. You should now see a new rule enabled in the firewall management console.

     

  15. Restart the SMTP Service and set the service for Automatic Start. Open up the Services Management Console. Double Click on the Simple Mail Transfer Protocol service. Stop and then Start the service. Set the Startup type to Automatic.

That’s it. The service is ready and waiting.



How To Enable .CSHTML Support In Windows Server 2012

clock October 24, 2013 12:25 by author andry

C# ("C sharp")is  HTML webpage file used by Razor, an ASP.NET view engine used for generating Web pages for a user's Web browser; similar to a standard ASP.NET webpage (.ASP or .ASPX file), but uses a slightly different syntax; runs on a Web server, which generates the HTML for the client Web browser; can be programmed with syntax highlighting.

If we build a website that contains .cshtml file, we must enable .cshtml file. At the below, there is an error message if we don’t enable .cshml file.

To enable .cshtml file on windows Server 2012, There are steps to solve that problem. Open your IIS.

Expand “server”-> “sites” and choose “domain”.  Then click on Handler Mapping.

You can't find .cshtml. After that, choose “Revert to Parent” on right tab.

Select "Yes" and Look,what the difference with the previous image.

.cshtml file are enable and available. Now browse the domain. If you still can not access and have an error. You should check the .NET version. Remember that .Cshtml file can only be run on .NET version 4 and above.

To check the .Net version, select "application pools" -> right click on "domain_name" -> "Basic settings" -> choose .Net 4 version -> "Ok".

Now you can browse your domain with .cshtml file. Here is screenshot.



Windows Hosting - ASPHostPortal.com :: Assign IP Automatically and Manually to Client Machine

clock October 9, 2013 10:08 by author Ben

TCP / IP (which stands for Transmission Control Protocol / Internet Protocol ) is a data communications standard used by the Internet community in the process of exchanging data from one computer to another computer on the network Internet . This protocol can not stand alone , because this protocol is a set of protocols ( protocol suite ) . This protocol is the most widely used protocol today . Data are implemented in software ( software ) in the operating system . The term given to this software is the TCP / IP stack

TCP / IP was developed in the late 1970s and early 1980s as a standard protocol for connecting computers and networks to form a vast network ( WAN ) . TCP / IP is an open network standard that is independent of physical network transport mechanism that is used , so it can be used anywhere . This protocol uses a simple addressing scheme known as IP address ( IP Address) that allows up to several hundred million computers to be able to relate to each other on the Internet . This protocol is routable, which means that the protocol is suitable for connecting different systems ( such as Microsoft Windows and UNIX family ) to establish a heterogeneous network .


TCP / IP has always evolved over time , given the increasing demand for computer networks and the Internet . Development is done by several agencies , such as the Internet Society ( ISOC ) , the Internet Architecture Board ( IAB ) and the Internet Engineering Task Force ( IETF ) . Various protocol that runs on top of TCP / IP addressing scheme , and the concept of TCP / IP defined in documents called Request for Comments ( RFC ) issued by the IETF .

And now I wanna tell you
how to assign an IP automatically and manually to a client machineon windows.

1. open "Network and sharing Center" by clicking on the "Net Connection" Icon shown at the Task Bar.
2. Now your Control Panel window will be opened. Here in this window you will find an option for "Change Adapter Settings" that is on the extreme left hand side of the window. Click on this option.
3. Now your "Local Area Connection" will be opened. Right-click on this connection and click on "Properties".
4. Now the Property window for Local Area Connections will be opened. Here first you must select the "Internet Protocol Version 4" and then click on it's "Properties."

5. The Properties window of Internet Protocol Version 4 is the area where we will provide the IP Address either Automatically or Manually. For getting the IP Address Automatically click on the "Obtain IP Address Automatically and Obtain DNS Server Address Automatically" and then click on the "OK" Button.
But remember one thing; You can only provide the Automatic IP Address only if your Organization has a DHCP Server otherwise the Automatic option will not work.

6. In the previous step we obtain the IP Address Automatically but now we will provide the IP Address Manually. For this click on "Use the following IP Address and  Use the following DNS Server Address".



Now provide the IP Address, Default Gateway, Preferred DNS Server and Alternate DNS Server. The Subnet Mask will automatically appear after providing the IP Address. And Click OK.

 



Free ASP.NET hosting - ASPHostPortal.com :: ASPHostPortal.com Proudly Announces Free Trial Windows ASP.NET Hosting

clock October 3, 2013 10:28 by author Ben

ASPHostPortal.com is a premier Windows and ASP.NET Web hosting company that specializes in Windows and ASP.NET-based hosting. We proudly announces 7 Day Free Trial Windows and ASP.NET Hosting to all new customers. The intention of this FREE TRIAL service is to give our customers a "feel and touch" of our system. This free trial is offered for the next 7 days and at anytime, our customers can always cancel the service.

 

The 7 Day Free Trial is available with the following features:

- Unlimited Domains
- 5 GB Disk Space
- 60 GB of Bandwidth
- 2 MS SQL Database
- Unlimited Email Account
- Support ASP.NET 4.5
- Support MVC 4.0
- Support SQL Server 2012
- Free Installations of ASP.NET And PHP Applications

ASPHostPortal.com believes that all customers should be given a free trial before buying into a service and with such approach, customers are confident that the product / service that they choose is not faulty or wrong. Even we provide free trial service for 7 days, we always provide superior 24/7 customer service, 99,9% uptime guarantee on our world class data center. On this free trial service, our customer still can choose from our three different data centre locations, namely Singapore, United States and Amsterdam (The Netherlands)

Anyone is welcome to come and try us before they decide whether or not they want to buy. If the service does not meet your expectations, our customer can simply cancel before the end of the free trial period.

For all the details of packages available visit ASPHostPortal.com

About ASPHostPortal.com:

ASPHostPortal.com is a hosting company that best support in Windows and ASP.NET-based hosting. Services include shared hosting, reseller hosting, and sharepoint hosting, with specialty in ASP.NET, SQL Server, and architecting highly scalable solutions. As a leading small to mid-sized business web hosting provider, ASPHostPortal strive to offer the most technologically advanced hosting solutions available to all customers across the world. Security, reliability, and performance are at the core of hosting operations to ensure each site and/or application hosted is highly secured and performs at optimum level.



Windows 2012 Hosting :: Introduction Dynamic Access Control 2012

clock September 2, 2013 12:09 by author Ben

Do you know what is Dynamic Access Control??
Microsoft Dynamic Access Control (DAC) is a data governance tool in Windows Server 2012 that lets administrators control access settings. DAC uses centralized policies to let administrators review who has access to individual files. Files can be manually or automatically classified.

Windows Server 2012 Dynamic Access Control basically organize information automatically on file servers in order to meet business needs and regulatory requirements .

With the use of technology in the DAC classification , organization or company can identify or provide " tags " or labels to files on the file server . This capability to control access to files that were tagged through centralized access policies , perform audits and related reporting events related to access or attempts to access , use RMS ( Rights Management Services ) to encrypt Office documents so that the documents safe when the data out of the file server .

A number of the features found in Windows Server 2012 that are beneficial to the administrator in this regard :

  •     File owner , or the owner can directly provide information " tags " or labels to their own information , so do not need to be done by the administrator .
  •     Apply to the central access policy files ( information ) that has been in the " tag " or label given
  •     Provide " access denied remediation " when the user can not access the information .
  •     Configure the central audit trail records policies for information access ( access logs ) that can later be used for analysis and forensic needs .
  •     Protect certain sensitive information to the protection of the RMS automatically.


Label or tag used to identify the protected file can be used to classify files in logic . In Windows Server 2012 , this label can be applied in four ways :

  •     Based on location . When files are stored on a file server , the file inherits the label of its parent folder .
  •     Manually . Users and administrators can manually file labeling .
  •     Automatic . Files can be automatically labeled based on content or other characteristics .
  •     With the application , using the API for labeling file maintained by the application .

 



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

 photo ahp banner aspnet-01_zps87l92lcl.png

Author Link

Corporate Address (Location)

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

Sign in