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

  • How to disable Username and Password in Network pc
    1. Click Start 2. Control Panel 3. Network and Internet 4. Network and Sharing Center 5. Click Choose homegroup and sharing options...
  • How to Surf Privately in Google Chrome
    First open the Google Chrome  Click on Customize and Control Google Chrome at Right hand top as below Now Click on New incognito W...
  • How to run a simple PHP web server
    # php -S localhost:8000 -t /path/to/folder/directory Above command give output like below PHP 5.6.4-4ubuntu6 Development Server started...

Copyright © THE IT IDEAS | Powered by Blogger