THE IT IDEAS

  • Home

Friday, 14 December 2012

How to enable default SQL server user and assign normal password

 THE IT IDEAS     13:13     sa password   

First Login as Windows Authentication



After open SQL Server double click on Security -> Logins -> Right click on sa user and open properties as below


 

By default property of SA user as Below  

 

Unclick Enforce Password policy and Enforce Password Expiration and enter any password which you wants to give (I given "sa" password for demonstrate purpose)

Now just disconnect or reopen the SQL SERVER and select SQL SERVER Authentication and user name will be :: "sa" and password is :: "sa" because i given the "sa" password for showing you all guys.

 



 Its done Enjoy !!!!! :)


  • Share This:  
  •  Facebook
  •  Twitter
  •  Google+
  •  Stumble
  •  Digg
Email ThisBlogThis!Share to XShare to Facebook
Newer Post Older Post Home

Like Us !!!

Recent Posts

Blog Archive

  • ►  2016 (1)
    • ►  April (1)
  • ►  2015 (12)
    • ►  August (1)
    • ►  May (2)
    • ►  April (8)
    • ►  March (1)
  • ►  2014 (23)
    • ►  December (8)
    • ►  November (12)
    • ►  April (2)
    • ►  March (1)
  • ►  2013 (7)
    • ►  December (1)
    • ►  April (1)
    • ►  March (1)
    • ►  February (1)
    • ►  January (3)
  • ▼  2012 (15)
    • ▼  December (6)
      • How to make Google Chrome Theme
      • How to open favorites website with one button
      • How to enable default SQL server user and assign n...
      • How do increase the connection limit for IIS in Wi...
      • Restart Computer Failed error in SQL SERVER
      • Keep up to date your Computer
    • ►  November (9)

Categories

apache2 EC2 error mysql php ubuntu aws aws rds browser github installation linux mount s3 AWS Bucket CentOS Computer DocumentRoot change How to Benchmarking Webserver IP LAMP Restart Computer SCP command SQL SERVER XRDP administrator amazon rds backup basic commands chat command line disable download drupal ec2.chroot environment external storage device fstab functions geoip gmail google home page iis instance internet java mod rewrite mongodb multiple login network password one password php5 php5-fpm php7 private browsing python repair filesystem repo reset password rhel sa password same computer script sftp share skype ssh tomcat ubuntu 16.04 ubuntu16 visudo windows 8 youtube
JobsMagBlogJobsMag.InThingsGuide

Popular Posts

  • Install MongoDB php driver in XAMPP/LAMPP
    To install the php driver for MongoDB Prerequisite :: #sudo apt-get install autoconf #export PHP_AUTOCONF=/usr/bin/autoconf #sudo apt...
  • How to Install PHP 7.0, Apache 2.4.18, & MySQL 5.7 on Ubuntu 16.04 LTS
    Update your repo list with below command $ sudo apt-get update -- > Install Apache 2.4.18 $ sudo apt-get install apac...
  • Share Internet from one PC to another PC
    Open Network Connections by clicking the Start button , clicking Control Panel , clicking Network and Internet , clicking Network and S...

Copyright © THE IT IDEAS | Powered by Blogger