Unable to connect the SQL Server Instance – 26 – Error Locating Server/Instance Specified

Problem\Issue: User is not able to connect the SQL Server Named Instance ServerName\InstanceName Additional Error Messages: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (Provider: SQL Network Interfaces, error: 26 – Error Locating Server/Instance Specified) (Microsoft SQL Server, Error: -1) Environment: SQL Server default single instance is running on

» Read more

SQL Server – How to read the SQL Server Error log files using TSQL

There is undocumented system stored procedure sp_readerrorlog which allows us to read the SQL Server error log files directly using T-SQL. This procedure has total 7 parameters as given below: Parameter Values First Parameter Value of error log file you want to read: 0 = current, 1 = Archive #1, 2 = Archive #2, etc. Second Parameter Log file type : 1 – Reads SQL Server error logs, 2 – Reads SQL Server Agent error logs Third Parameter Search string

» Read more

SQL Server – Enable SQL Server 2012 AlwaysOn Availability Groups

In the previous post  SQL Server – AlwaysOn Availability Groups, described enhancement to SQL Server 2014 AlwaysOn Availability Groups. In this post, we will see how to enable SQL Server 2012 AlwaysOn Availability Groups using UI and PowerShell. Using UI Go to SQL Server Configuration Manager >> Navigate to SQL Server Service >> Right Click to SQL Server Service and Click to Properties Navigate to AlwaysOn High Availability tab >> Check the “Enable AlwaysOn Availability Groups ” check Box Using

» Read more

SQL Server – Database mirroring vs Log Shipping

I would like to start this topic with very common question for database administrators. Question: What is difference between the Database Mirroring and Log Shipping? Which is preferable solution? Database Mirroring: Database mirroring is functionality in the SQL Server engine that reads from the transaction log and copies transactions from the principal server instance to the mirror server instance.  Database mirroring can operate synchronously or asynchronously. Database mirroring supports only one mirror for each principal database. Database mirroring also supports

» Read more

SQL Server – Log shipping for Disaster Recovery Solution

What is Log Shipping? Log Shipping is a basic level SQL Server high-availability technology. It is automated process to send the transaction log backups from a primary database on a primary server instance to one or more secondary databases on separate secondary server instances. The transaction log backups are applied to each of the secondary databases individually. How Log Shipping working? Log shipping involves copying a database backup and subsequent transaction log backups from the primary server and restoring the

» Read more

SQL Server – Backend version is not supported to design database diagrams or tables. (MS Visual Database Tools)

Error Messages : This backend version is not supported to design database diagrams or tables. (MS Visual Database Tools) Cause  : The database to which you are connected does not allow schema modification with the Visual Database Tools. Resolution : Be sure you are connected to the correct database or Use the correct version SQL Server Management tool.

» Read more

SQL Server – Unattended Installation of SQL Server 2012 Using Command Line

Many times we face a requirement to perform the unattended installation of SQL Server. In this post we will see the steps to perform the unattended installation of SQL Server 2012 using command line. There are two ways to install the unattended installation of SQL Server 2012 using command line. Specify each required parameter , you may take the parameter help Setup.exe /ACTION=Install /FEATURES=SQL /InstanceID=… /IACCEPTSQLSERVERLICENSETERMS /INDICATEPROGRESS Specify Configuration file that contains all the parameter require for installation : Setup.exe

» Read more

SQL Server – AlwaysOn Availability Groups

Introduction Microsoft introduced the AlwaysOn Availability Groups which is a high-availability and disaster-recovery solution that provides an enterprise-level solution in SQL Server 2012. Using Database Mirroring for local high availability and combining it with Log Shipping for a disaster recovery solution is popular deployment architecture prior to SQL Server 2012. With SQL Server 2012, the Database Mirroring and Log Shipping solution can be replaced with an Availability Group solution with multiple secondaries. AlwaysOn Availability Groups – Deployment Architecture The whitepaper

» Read more

SQL Server – How to restore the mirroring database

Now here we have question regarding the Mirroring Database: How can we recover the data from mirror database? How to restore the mirroring database? Here I would like to clear that we cannot restore a database that is involved in Mirroring without removing Mirroring. Removing the Mirroring using T-SQL ALTER DATABASE MirrorTest SET PARTNER OFF; Restore the Mirror Database RESTORE DATABASE MirrorTest WITH RECOVERY; For Database Mirroring Administration click here

» Read more

SQL Server – Database Mirroring for Disaster-Recovery Solution

What is Database Mirroring? Database mirroring is a solution for increasing the availability of a SQL Server database. But it has been gained popularity as a disaster-recovery option. How Database Mirroring Working. The principle server sends the active transaction log record to the mirrored server. The mirrored server applies the transaction log record one by one in sequence. Prerequisites The two partners, that is the principal server and mirror server, must be running the same edition of SQL Server. The

» Read more

How to – Create Read Only User in CollabNet Subversion Edge

After your installation of CollabNet Subversion Edge, once you will create user that gets the Read-Write Access to all the available repositories because by default Repository Access Rule is (as shown below) [/] * = rw That means Read-Write Access to all Users for all available repositories. You should Edit Repository Access Rule as [/]* = r varinder = rw That means Read-Only Access to all Users and Read Write Access to User “varinder” only. Hope this will be useful

» Read more

CollabNet Subversion Edge – Configuration

In the previous post, you have seen the complete installation of Subversion Edge. After Installation, once you will login the web-based console for configuration managing the server. You can see in the below screenshot, Your SVN Server is down yet. Now, first we see some important configuration parameter (Highlighted in Red) that we have to set as per our requirement before starting SVN Server. There are lots of other configuration parts that you may need to setup as per requirement

» Read more
1 2 3 23