How to create a User and SQL server authentication

SQL Server Authentication is a default mechanism to connect to MS SQL Server, but there are times that you need to use SQL Server Authentication to connect to the server, like when you have to connect to an MS SQL Server Database on a different network or when you have an SSPI problem. In order to use SQL Server Authentication, you need to create a SQL Server Authentication Login ID first. we will create a new SQL Server account. Run Microsoft SQL Server Management Studio. with local windows Authentication    Expand the Security folder,…

Read More

How To Restart/Start/Stop/Pause/ SQL Server Service

Just open SQL Server Configuration Manager, we could start, stop, pause or restart SQL Server Service. Step 1: On the Start menu, point to All Programs, point to Microsoft SQL Server, point to Configuration Tools, and then click SQL Server Configuration Manager.   Step 2: click on SQL Server Services Step 2:select any instance of SQL Server such as SQL Server (SQLEXPRESS). Right-click any instance of SQL Server such as SQL Server (SQLEXPRESS), and then click Stop, Pause, Start orRestart.  buttons on toolbar, meaning Start, Pause, Stop and Restart.

Read More

How to Install SQL Server 2012

In this post I am going to show you how to install SQL Server 2012 Express Edition or  on Windows Server 2008 r2, I have included Create screen shots of step by step to make things to follow. If you haven’t already downloaded SQL Server 2012 Express, you can get it from Microsoft here.   Step 1. To begin, launch the install program and go to Installation tab.   Step 2. launch the install program and choose the top option to install a new stand-alone installation.   Step 3. SQL…

Read More