Monday, January 8, 2018

Installing SQL Server 2014 Step by Step Tutorial

Installing SQL Server 2014 Step by Step Tutorial


According to TechNet
https://social.technet.microsoft.com/wiki/contents/articles/23878.installing-sql-server-2014-step-by-step-tutorial.aspx

Installing SQL Server 2014 Step by Step Tutorial


Introduction

This article provides a step-by-step procedure for installing a new instance of SQL Server 2014, using the SQL Server setup installation wizard. The SQL Server Installation Center provides a single feature tree for installation of all SQL Server components, so that you do not have to install them individually.
In this tutorial, we will show the default installation of all the features available in the SQL Server Enterprise version. You may find that in your version you don't have all those features available. It is highly recommend to read all the comments in this article before you start the installation.
* Before you start, it's highly recommend to check hardware and software requirements for Installing SQL Server 2014 (here  ).

Preparation

 For local installations, you must run Setup as an administrator. If you install SQL Server from a remote share, you must use a domain account that has read and execute permissions on the remote share.
It is best to install the server from a DVD or from a mounted ISO file which behaves as a CD/DVD. In this case, once you double click the DISK icon the autorun.inf file is used by the AutoRun and AutoPlay components of Microsoft Windows operating systems. This will start the installation using the configuration in the autorun.inf file. If  AutoRun is disabled on your server, you may double click setup.exe to start the installation. To install from a network share, locate the proper folder on the share, and then double-click setup.exe.

Installation, Step By Step

1. Upon starting the installation, you will get this window:
1
We will discuss the Planning and Installation sections of the setup program.
* It is highly recommended to go over the documentation and guides in the Planning section:
  • Hardware and Software Requiremen  t
  • Security Documentation 
  • Online Release Notes
  • How to Get SQL Server Data Tools
  • System Configuration Checker
  • Install Upgrade Advisor
  • Online Installation Help
  • How to Get Started With SQL Server 2014 Failover Clustering
  • How to Get Started With PowerPivot for SharePoint Standalone Server Installation
2. Choose the Installation section in order to start the installation:
2
3. Enter the product key and click Next:
3
4. You have to accept the license term in order to continue. It is highly recommend NOT to ask in the forum a question regarding Licensing. The MSDN forum interface is not for this, and good people that want to help you, can make mistakes with Licensing. It is recommend to use the direct phone number to reach the people that can give you the official answer :-)
Licensing questions: call 1-800-426-9400, Monday through Friday, 6:00 A.M. to 6:00 P.M. (Pacific Time) to speak directly to a Microsoft licensing specialist.
4
5. Mark the check box in order to use Microsoft Update to check for an update after you finished the installation, and then click Next.
5
6. The SQL Server installation program checks your machine to make sure it meets the hardware and software requirements to install SQL Server. If you get any Errors in the results, please use the link in the error message to get more information. 
Do not move to the next step if you get any errors in this report!
6
7. Choose the first option in order to install SQL Server, and then select which features to install. We are going to choose our features manually in the next step. Click Next to continue:
7
8. In this step, you can choose what features to install. It is highly recommend NOT to choose all the features on a production server if you don't need them. Choose only the features that you need or might need. Conversely you might want to select all using a development server in order to give you more flexibility in your development environment. Once you choose to use another feature you will be able to add it in production later on.
8
9. SQL Server allows you to install multiple instances of the same version or different versions of the server. Make sure you choose a name that will help you in the future to recognize the instance which you are working with. Theoretically you can use any instance name that you want.
* Remember the name of the instance!

You will need to use this name every time that you want to connect to the server.
9
10.  Security is important for every product and every business. By following simple best practices, you can avoid many security vulnerabilities. SQL Server works as a group of services in the background. In this step you can select the service accounts for the SQL Server actions. Each service in SQL Server represents a process or a set of processes to manage authentication of SQL Server operations with Windows. Each service can be configured to use its own service account. For more information you can read this article  . Once you configure this step move to the collation tab!
10
11. SQL Server supports several collations. A collation encodes the rules governing the proper use of characters for either a language, such as Hebrew or Polish, or an alphabet, such as Latin1_General (the Latin alphabet used by western European languages). Typically, you should choose a SQL Server collation that supports most languages commonly used by users at your organization. Select the collation and press next.
11
12. SQL Server can operate in one of two security (authentication) modes: (a) Windows Authentication mode which allowed a user to connect through an operating system user account. or (b) Mixed Mode which allowed users to connect to an instance of SQL Server using either Windows Authentication or SQL Server Authentication.
12
13. By default SQL Server uses the system operation disk  Thus it is highly recommended to use the best practice according to your specific system and usage. Separating the LOG files from the data files can improve performance significantly. The system database tempDB is used extensively by SQL Server. This database is rebuilt each time the server is restarted. (See this article for details about TempDB Understanding Logging in Tempdb. Is Tempdb Recreated or Rebuilt after SQL Server Starts?)  It is highly recommended to use a fast disk for this database. It is best practice to separate data, transaction logs, and tempdb for environments where you can guarantee that separation. There are important points to considerate and this article is not covering them at the moment. For small systems you can use the default configuration and later on change as needed.
13
14. FILESTREAM enables SQL Server-based applications to store unstructured data, such as documents and images, on the file system. FILESTREAM integrates the SQL Server Database Engine with an NTFS file system by storing varbinary(max) binary large object (BLOB) data as files on the file system.
14
15. An instance of Analysis Services is a copy of the msmdsrv.exe executable that runs as an operating system service. Each instance is fully independent of other instances on the same server, having its own configuration settings, permissions, ports, startup accounts, file storage, and server mode properties. Server mode is a server property that determines which storage and memory architecture is used for that instance. In this step you can add windows users in order to give them administrative permissions for the Analysis Service. It is highly recommended to add the machine Administrator as well as other users who will need to manage this service. You can get more information in this link  . Move to the Data Directories for next step.
15
16. As mentioned in step 13 the data directories can have significant influence on the server performance. You can get more information on this issue in this forum discussion  . Press Next to continue the installation configuration.
16
17. Choose if you want to install and configure the Reporting Service or just Install, which mean you will need to configure it later on.
17
18. Before you install and use the Microsoft SQL Server Distributed Replay feature, you should review the important security information in this link  .
18
19. When installing the Microsoft SQL Server Distributed Replay features, consider the following:
  • You can install the administration tool on the same computer as the Distributed Replay controller, or on different computers.
  • There can only be one controller in each Distributed Replay environment.
  • You can install the client service on up to 16 (physical or virtual) computers.
  • Only one instance of the client service can be installed on the Distributed Replay controller computer. If your Distributed Replay environment will have more than one client, we do not recommend installing the client service on the same computer as the controller. Doing so may decrease the overall speed of the distributed replay.
  • For performance testing scenarios, we do not recommend installing the administration tool, Distributed Replay controller service, or client service on the target instance of SQL Server. Installing all of these features on the target server should be limited to functional testing for application compatibility.
  • After installation, the controller service, SQL Server Distributed Replay controller, must be running before you start the Distributed Replay client service on the clients.
  • Make sure that the computers that you want to use meet the requirements that are described in the topic Distributed Replay Requirements.
  • Before you begin this procedure, you create the domain user accounts that the controller and client services will run under. We recommend that these accounts are not members of the Windows Administrators group. For more information, see the User and Service Accounts section in the Distributed Replay Security topic.
* This information copied from here 
19
20. That is all :-) The SQL Server Installation program will show us a report of all our configuration (steps 1-19). Once you select Next, the installation will start.
20
Hopefully everything went well and you should get a final report which indicates the successful completion of each installed service.
You are now ready to connect to the server :-)

Connecting to the Server

Open the new SSMS application which we have just installed (in step 8 we choose which features to install, If you have chosen Management Tools it includes the SQL Server Management Studio).
21
During step 9 we choose an instance name for our new installation. We told you to Remember the name of the instance. Now it is time to use it.
Start the SSMS application and use the information as shown in the image above in order to connect the server. You should replace the "XXX" text with the instance name that you choose.
* For any question regarding the installation you can use the MSDN forums (English Forum  , Hebrew Forum).

Resources & More Information

See Also

Sunday, January 7, 2018

Configuring Azure AD Connect

Configuring Azure AD Connect, fine tuning

Azure AD Connect sync: Enable AD recycle bin

https://docs.microsoft.com/en-us/azure/active-directory/connect/active-directory-aadconnectsync-recycle-bin


How to set up hybrid devices joined to Azure Active Directory. 
Comment configurer des appareils hybrides joints à Azure Active Directory. 

https://docs.microsoft.com/fr-ca/azure/active-directory/device-management-hybrid-azuread-joined-devices-setup


Installing user CALS / RDS CALS on Windows Server 2012

Installing user CALS / RDS CALS on Windows Server 2012

Open License
Need the:
Authorization Number:
License Number:

On server
Run licmgr.exe

Call and give prodicu ID

Sunday, December 31, 2017

Cat 5e Cat 6 Cat6e Cat 7 T568A and T568B Wiring Schemes

Cat 5e Cat 6 Cat6e Cat 7 T568A and T568B Wiring Schemes


Based on TIA/EIA-568-B.1-2001, the T568A and T568B wiring schemes define the pinout, or order of connections, for wires in eight-pin modular connector plugs and jacks.
The only difference between T568A and T568B is that pairs 2 and 3 (orange and green) are swapped. Both configurations wire the pins "straight through", i.e., pins 1 through 8 on one end are connected to pins 1 through 8 on the other end, and the same sets of pins are paired in both configurations: pins 1 and 2 form a pair, as do 3 and 6, 4 and 5 and 7 and 8.
Cables that are terminated with differing standards on each end will not function normally, however mixing T568A-terminated patch cords with T568B-terminated horizontal cables (or the reverse) will not produce pinout problems in a facility, although it may slightly degrade signal quality, This effect is marginal and certainly no greater than that produced by mixing cable brands in-channel.

T568 A or T568 B- Which One Should I Use?

  • If the installation is residential, choose T568A unless other conditions apply (see below).
  • If there is pre-existing voice/data wiring (remodel, moves, adds, changes), duplicate this wiring scheme on any new connection.
  • If project specifications are available, use the specified wiring configuration.
  • If components used within the project are internally wired either T568A or T568B, duplicate this wiring scheme.

T568A and T568B Wiring Assignments:

T568A and T568B Wiring Assignments
Wiring Standards
Pin #T568BT568A
1White/OrangeWhite/Green
2OrangeGreen
3White/GreenWhite/Orange
4BlueBlue
5White/BlueWhite/Blue
6GreenOrange
7White/BrownWhite/Brown
8BrownBrown

Download Windows Operating Systems and Free Software

Windows Operating Systems
Download Free software
getintopc.com

Saturday, December 9, 2017

HP ProLiant DL360 Gen9 Server Maintenance and Service Guide

HP ProLiant DL360 Gen9 Server Maintenance and Service Guide

http://h20628.www2.hp.com/km-ext/kmcsdirect/emr_na-c04566802-3.pdf

How to make bootable iso usb dvd

How to make bootable iso usb dvd

Windows USB/DVD Download Tool

https://www.microsoft.com/en-us/download/windows-usb-dvd-download-tool
http://wudt.codeplex.com/
or

imgburn
magiciso
winiso
http://www.poweriso.com/order.htm

Wednesday, November 15, 2017

Office 365 mail client settings / configuration

Office 365 mail client settings / configuration

POP et IMAP settings

Use the settings on this page if you want to use the POP or IMAP protocol to connect your mailbox

POP settings
Server name: outlook.office365.com
Port: 995
Encryption method: TLS

IMAP settings
Server name: outlook.office365.com
Port: 993
Encryption method: TLS

SMTP settings
Server name: smtp.office365.com
Port: 587
Encryption method: STARTTLS




*** Français

Office 365

Paramètres POP et IMAP

Utilisez les paramètres de cette page si vous souhaitez employer le protocole POP ou IMAP pour connecter votre boîte au lettre. 

Paramètres POP
Nom de serveur : outlook.office365.com
Port : 995
Méthode de chiffrement : TLS

Paramètres IMAP
Nom de serveur : outlook.office365.com
Port : 993
Méthode de chiffrement : TLS

Paramètres SMTP
Nom de serveur : smtp.office365.com
Port : 587
Méthode de chiffrement : STARTTLS


Need assistance?  http://inCOREporation.com

Wednesday, October 4, 2017

Ring.com vs 360° SMART HOME CAMERA

Ring.com

  • is there storage on the ring products?
  • can we store video?
  • Because the device has no memory in and of itself, the recordings and video processing are performed via streaming and recording in the cloud. It is not possible to store videos locally, to other Cloud services, or in any other way besides our proprietary Cloud subscription. If the videos were stored locally, such as on a phone or PC, customers would be unable to download or share them from the app or our site, ring.com. For this reason, we chose to use Cloud storage for the best customer experience. Although videos are not stored locally, please keep in mind that you could always download any video that you would like to keep as long as you have an active Cloud subscription. This way, you'll have access to footage while offline and for as long as you like. These can be downloaded via the mobile app, the Mac or Windows 10 app, or via ring.com/activity

  • where do we find the cloud storage?
  • Did you have any other questions for me today?
  • cloud subscription
  • You can find more information here https://ring.com/protect-plans
  • thank you
  • You’re welcome; I am happy to help! Did you have any other questions for me today? 🙂
  • the link is not working
  • https://ring.com/protect-plans
  • What country are you in?
  • Canada
  • https://ring.com/ at the top you should see video recording, or it will be under all products. They just changed the US site so that link is not working for Canada at the moment


  • ok great i see it now 

    https://ring.com/video-recording
  • do you offer a partner / affiliate program, i would like to implement ring solutions

  • 💰 The Referral Program is used like a promo code. 💰 Just provide the other person with your unique code found here https://ring.com/account and ask them to enter it at checkout from purchases made at our website. 💰 This will provide both the referee and referrer with 6 months of free Cloud service automatically. 💰 The referrer can accumulate up to 5 years free Cloud service (10 referrals). ⚠️Please note this only applies to purchases of Ring camera devices and not accessories.
  • We don't have a partner/affiliate program but we do have the referral program

https://ring.com/account
(dandynetworks.com)

Similar products


360° SMART HOME CAMERA
Affiliate

https://secure.mymobile-gear.com?rfsn=801113.88606&utm_source=refersion&utm_medium=influencers&utm_campaign=801113.88606

(https://secure.mymobile-gear.com/products/360-smart-home-camera?variant=50781921748)


https://ondemanddealz.com/products/360-smart-home-camera?variant=46724406920



Friday, September 29, 2017

Hosting Enterprise apps on your own Domain

Hosting Enterprise apps on your own Domain



How to publish an Enterprise app with MobileAppDev platform.

How to publish an Enterprise app with MobileAppDev platform.

Even though it is possible to publish Enterprise apps with MobileAppDev platform, the option to do so does not present itself when publishing your app to the store. In order to make sure that your app is published to the store as an Enterprise app you can contact support@incoreporation.com regarding the publication of your app. Please mention your app’s name and number, found in the App Vitals section on your app’s "App Summary" page.

In order to publish your app as an Enterprise app, the following licenses are required:
  • Apple Developer Enterprise license 
  • Google Play Developer license 

An Apple Developer Enterprise license is required to create the certificates to package and distribute your app. Registering an Apple Developer Enterprise license can be done here.

A Google Play developer license is required in order to create API and push notification keys used by your app. More information regarding the registration of a Google Play developer license can be found here.

http://incoreporation.com       https://ca.incoreporation.com       http://wwebservices.ca  

Trusting an Enterprise Developer app on iOS devices

Trusting an Enterprise Developer app on iOS devices

If the enterprise app you've built is the first one you've developed and downloaded on your iOS device you will need to "trust" the developer of the app.
To do this:
  • Go to Settings > General > Profile or Device Management (this depends on the iOS 9 version you have installed on the device)
  • In this screen you can trust your enterprise account.

Google Analytics - Application

Google Analytics




Twitter API keys

Twitter API keys

The following information describes the process for obtaining a Twitter API key for your AppMachine app. This key allows you to make authorized requests for data. Each API key can only be used for one app. If you have several MobileAppDev platform apps that you want to publish, you'll have to go through this process for each of those apps that use Twitter.

1. Go to https://apps.twitter.com/ and log in using your twitter account. If you don't have a Twitter account, create one at https://twitter.com/signup
2. Fill in the "Create an application" form, enter the CAPTCHA at the bottom (if applicable), and click on "Create your Twitter application." Use the information under your app's "Publish" tab to complete this form.
3. Click on "Create my access token" to generate your token. You may have to refresh your browser if it doesn't appear after a while.
 Clipboard02.jpg
4. Copy the following keys from your Twitter app
- Consumer key
- Consumer secret
- Access token
- Access token secret
Clipboard03.jpg 
5. Go to http://design.MobileAppDev.com and log into your MobileAppDev platform account. Select the app you want to publish and got to the "Publish" tab. Towards the bottom of the screen you'll see the "Advanced" section. Click on "Twitter" and you'll find the fields to enter your data. Enter your newly acquired Twitter details here. 
 Clipboard04.jpg
6. Make sure you save these details once you've entered them.


http://incoreporation.com       https://ca.incoreporation.com       http://wwebservices.ca 

Create a Facebook App ID + App Secret

Create a Facebook App ID + App Secret

To use the Facebook tools, like the Facebook registration tool, you need to create a Facebook App. When you make a Facebook App, that app will have an App ID and an App Secret. With the App ID, you can send several requests to Facebook for data. The Facebook App Secret will be used to decode the encrypted messages from Facebook, so that sensitive information remains protected.
How to: Facebook App ID + App Secret
To complete the following steps you will need to have access to a Facebook account. If you don't have a Facebook account, you can create one here: https://www.facebook.com/
Step 1: Go to http://developers.facebook.com and login with your Facebook account. (Go to Step 3 if you already have a Facebook developer account.)
Step 2: If you don't already have a Facebook Developer account, click on the "Apps" button in the top title bar of the web page. Follow the steps in the wizard to register as a Facebook developer.
Step 3: Once you're registered as a Facebook developer, click on the "Apps"  button in the top title bar of the web page. Click on the "Create New App" button in the drop down menu to create a new Facebook app.
Step 4: Enter a "Display Name," "Contact Email," and choose a "Category" for your app. When completed, click on "Create App ID"
Step 5: You will be redirected to a "Product Setup" page. In the left vertical menu, click on "Dashboard"

Step 6: Your App ID and App Secret are available in this page. Click on the "Show" button and enter your Facebook account's password to get the App Secret.




Step 7: Once the Facebook app has successfully been created, you still need to set the app live before the necessary key (App ID and App Secret) can be used by your MobileAppDev platform app. You can set the app live in the "App Review" page of the app. 

Transfer your app from one Google Play developer account to another

Transfer your app from one Google Play developer account to another

Requirements:
Gather the required information to fill out the transfer request form. You can fill the information out on the form as you progress through the steps below.
Steps:
  1. Obtain the name and package name of your app.
      1. Login on https://play.google.com/apps/publish/ with the original Google Play developer account login information.
      2. Select your app from the app list.
      3. On the following page you will find the name of your app in the top of the screen. Right below the app name you will find the package name, typically written as “com.example.app”.
  2. Obtain the transaction ID for the original account’s developer console registration.
      1. Login on https://wallet.google.com/manage/ with the original Google Play developer account login information.
      2. In the “Transactions” section, locate and click the transaction titled “Google - Google Play”.
      3. A receipt will slide in from the right side. You will find the transaction ID of your purchase on the bottom of this receipt.
  3. Obtain the transaction ID for the target account’s developer console registration.
    1. Repeat step ‘2.2’, only this time make sure to login with the target Google Play developer login information.

  4. Obtain the developer name for your target account.
      1. Login on https://play.google.com/apps/publish/ with the target Google Play developer account login information.
      2. From the left side menu, navigate to the “Settings” page.
      3. At the top of the Settings page, you will find the “Developer name”.

  5. Complete the form by providing the email addresses of the original and target Google Play developer accounts.

After filling out all the fields with the data gathered in the above steps, you will be able to submit your transfer request. Transfer requests are typically processed by Google within 48 hours.

Please don’t forget to update your Google Play developer license information in MobileAppDev platform with the new developer credentials of the target account of your Android app. 

http://incoreporation.com       https://ca.incoreporation.com       http://wwebservices.ca 

Transfer your app from one Apple developer account to another

Transfer your app from one Apple developer account to another

Requirements:
  • Original Apple developer account login information.
  • Target Apple developer account login information.
  • Target Apple developer account Team ID.
Please note that the Apple developer accounts used to transfer the app have to have the Agent role. You can find out who the (Team) Agent of your Apple developer account is by logging in on the following page: https://developer.apple.com/account/#/membership
Initiate the app transfer:
  1. Obtain the Team ID of the target Apple developer account. You will find this in the membership section of the Apple Developer Portal on https://developer.apple.com/account/#/membership.
  2. On this same page, also obtain the (Team) Agent email address. 
  3. Logout of the Apple Developer Portal. Navigate to iTunes Connect (https://itunesconnect.apple.com/), and login with the original Apple developer account. The account from which you want to transfer the app.
  4. Open the “My Apps” section, and select the app you wish to transfer.
  5. On the bottom of the App Information page, you will find a “Transfer App” link. Click this link to start the transfer process.
  6. Enter the Recipient's Team Agent Apple ID. This is the Agent email address you’ve obtained in step 2.
  7. Enter the Recipient's Team ID. This is the Team ID you’ve obtained in step 1.
  8. Agree to the terms and agreements to request the transfer.

Accept and complete the app transfer:
  1. Navigate to iTunes Connect (https://itunesconnect.apple.com/), and login with the target Apple developer account. The account to which you’ve transferred the app.
  2. After logging in, open the Agreements, Tax, and Banking section. 
  3. In the Transfer Agreements section, locate the pending app transfer in the Contracts In Process section and click Review.
  4. Enter the new metadata for your app, which exists of the following fields:
    - Support URL.
    - Marketing URL (only required if the app previously had a marketing URL entered).
    - Privacy policy URL (only required if the app previously had a privacy policy URL entered).
    - App Review contact information.
    - App Store contact information.

    You can copy the above information from the iTunes Connect account from which you’ve transferred the app, or from the publish page of your app in AppMachine.
  5. Lastly, agree to the contract terms and complete the app transfer.
After completing all the steps above, the app is now being transferred to the target account. The process can take up to two business days, but usually does not take more than a few hours.

When you’ve completed a transfer, please do not forget to update your Apple developer license information in MobileAppDev platform.

http://incoreporation.com       https://ca.incoreporation.com       http://wwebservices.ca 

Featured Posts

Exchange Online Limits - Office 365 Distribution group limits

Exchange Online Limits - Office 365 Distribution group limits What are Exchange Online Limits What are Office 365 Distribution group limi...