Enable 'Sa' account in SQL Server 2005

Yesterday night was almost ruined when I tried to connect my special c# project with Microsoft SQL Server 2005 in Vista operating system. Even after spending several hours in examining and understanding the error message I didn't find any perfect solution for my problem. But today again I put myself to solve the problem and this time I was bit lucky when I discovered that my 'Sa' account in SQL server 2005 is in disable mode. A small red color downwards arrow icon can be seen just in the left side of the 'Sa' account icon. Later I learned that the so called 'Sa' account is by default in disable mode in Microsoft SQL server 2005 standard and express edition. Only after enabling my 'Sa' account I was able to connect my dot net project to SQL server database using SQL server login authentication.

Command for Enabling and Disabling SQL server 2005 is - ALTER .For example : -
Enable 'sa' account -
ALTER LOGIN sa ENABLE
Disable 'sa' account -
ALTER LOGIN sa DISABLE

Note: Go to Query window -> enter the above Command -> execute the Query. To execute these commands from Command Prompt, use isql or osql utility.

Related information:How to change the name of 'sa'account ?If we want to give a extra top security to hackers or miscellaneous person then we have to change the name of the 'sa' account because many advance user or SQL database administrators adopts this very method to take security measures.

Command : ALTER LOGIN [sa] WITH NAME = [AdminUser]

Naimish R. Dave

Comments

.NET Core: Session Wrapper Design Pattern For ASP.NET Core

Here, we'll learn about Session Wrapper design pattern to ease the access of Session. We'll make our access of session "Typed". Also, we may apply any validation or constraint in this wrapper class. Step 1 - Create a Session Manager class In this example, we are going to store two items in Session (i.e. ID & LoginName). We are injecting IHttpContextAccessor so that we can access the Session variable. We are creating properties which are actually accessing Session variable and returning the data or writing the data to Session. We have added one helping property "IsLoggedIn" which is using other properties to make a decision. We may have more such helping/wrapper properties. using Microsoft.AspNetCore.Http; public class SessionManager { private readonly ISession _session; private const String ID_KEY = "_ID"; private const String LOGIN_KEY = "_LoginName"; publ

Facade Design Pattern

Facade Intent Provide a unified interface to a set of interfaces in a subsystem. Facade defines a higher-level interface that makes the subsystem easier to use. Motivation Structuring a system into subsystems helps reduce complexity. A common design goal is to minimize the communication and dependencies between subsystems. One way to achieve this goal is to introduce a facade object that provides a single, simplified interface to the more general facilities of a subsystem. Consider for example a programming environment that gives applications access to its compiler subsystem. This subsystem contains classes such as Scanner, Parser, ProgramNode, BytecodeStream, and ProgramNodeBuilder that implement the compiler. Some specialized applications might need to access these classes directly. But most clients of a compiler generally don't care about details like parsing and code generation; they merely want to compile some code. For them, the powerful but low-level

Tabla - An Indian classical instrument for Rythm

Tabla Indian music has fascinated the West for many years. The tabla in particular has attracted the attention of a number of American and European percussionists. It has been used in popular music as early as the 60's and is heard in the popular media even today. However, many percussionists shy away from this instrument. The reasons for not "getting into it" are varied. Sometimes it is the lack of instruments; sometimes lack of teachers; sometimes it is the belief that tabla is just too difficult. These are legitimate concerns but they are not insurmountable obstacles. This article will address the concerns of a musician just wishing to get started in tabla. We will discuss the theory of Indian music, how to purchase tabla, the basic technique, and compositional theory. All of this information should make the job of getting started much easier. We should first familiarize ourselves with the extensive theory of Indian music. Indian music is one of the oldest musical trad

How to make a Method Thread Safe?

In multi-threaded applications where multiple threads make calls to the methods of a single object, it is necessary that those calls be synchronized. If code is not synchronized, then one thread might interrupt another thread and the object could be left in an invalid state. A class whose members are protected from such interruptions is called thread-safe. Although, there is no rule that makes the code thread safe, the only thing you can do is make sure that your code will work no matter how many times is it being actively executed, each thread can be interrupted at any point, with each thread being in its own state/location , and this for each function (static or otherwise) that is accessing common objects. If a method (instance or static) only references variables scoped within that method then it is thread safe because each thread has its own stack: In this instance, multiple threads could call ThreadSafeMethod concurrently without issue. public class Thing { publ

Create VHD using DISKPART

Create Virtual Harddisk Using DISKPART Open the Elevated Command Prompt with Administrator Privileges and type the following commands: DISKPART CREATE VDISK FILE="c:\win7\win7.vhd" MAXIMUM=20000 SELECT VDISK FILE="c:\win7\win7.vhd" ATTACH VDISK CREATE PARTITION PRIMARY ASSIGN LETTER=X FORMAT QUICK LABEL=Windows7 EXIT This will create the VHD file of primary partition. You will see the newly attached disk in Disk Management with Drive Letter X: Attaching and Detaching VHD in Windows 7 Right Click on My Computer and Click ' Manage ' that will open up Computer Management , in that click on Disk Management . Just like previous part. Then Right Click on Disk Management and select 'Attach VHD'. This will open new windows 'Attach Virtual Hard Disk ' Click on OK and that will attach the existing Virtual Hard Disk. Now, if you don't want to make write anything on the VHD, we

You will definitely get it from here!

Search This Blog