How to Enable/Configure sa User in SQL Server 2005

First of all, SQL Server Log In is to be enabled.
# Right click on sa or other user you want to enable and click on Properties.

# In the left Pane select General, change and confirm Password in Right Pane for User if it requires.

# Select Status in Left Pane and check Enable under Login in Right Pane.

# Press OK and restart the SQL Server.

Thanks
A Rahim Khan

Advertisements
  1. December 12th, 2009

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: