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

Installation CollabNet Subversion Edge – Step by Step

CollabNet Subversion Edge is a Subversion server distribution that includes a complete software stack of Apache, Subversion and ViewVC as well as a powerful web-based console for managing the server. In this Post, we will see the intallation steps for CollabNet Subversion Edge. Go to URL : http://www.collab.net/downloads/subversion  and download latest version Subversion Edge and within minutes be up and running with a fully featured, web and cloud enabled Subversion (SVN) platform. Here we downloaded the Subversion Edge 4.0.6 (Windows

» Read more

Packt celebrates International Day Against DRM, May 6th 2014

Packt Publishing firmly believes that you should be able to read and interact with your content when you want, where you want, and how you want – to that end they have been advocates of DRM-free content since their very first eBook was published back in 2004. To show their continuing support for Day Against DRM, Packt Publishing is offering all its DRM-free content at $10 for 24 hours only on May 6th – that’s all 2000+ eBooks and Videos

» Read more

SQL Server 2012 – Installation of SSRS Reporting Services Native Mode Report Server (SSRS)

You will get the step by step tutorial to install the SQL Server with Full or Partial features. Many time people are looking specific feature that we need to install for Reporting service Native Mode Report Server. So the purpose if this post is give idea of feature required for SQL Server Reporting Service Installation as shown in given snapshot:

» Read more

Reviewer – Reporting with Microsoft SQL Server 2012

I pleased to announce that Reporting with Microsoft SQL Server 2012 has been published. Officially, I have reviewed this book. I would like to request you all to read this book and provide your valuable feedback on the content. Click here for more detail about Reporting with Microsoft SQL Server 2012

» Read more

SQL Server – Understanding of SQL Server Role and Database Role

SQL Server supports the two authentication mode as Windows authentication mode and Mixed authentication mode. Once the user is authenticated, SQL server will allow access to the user based on the permission that user has. All the user permissions are based on Server Role and Database Role. So let try to user understand the meaning of each server role and database role. Server Role: Role Name Permission user can have bulkadmin Can run the BULK INSERT statement. dbcreator Can create,

» Read more
1 2 3 4 26