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

Related Posts:

  • How to enable default SQL server user and assign normal password First Login as Windows Authentication After open SQL Server double click on Security -> Logins -> Right click on sa user and open proper… Read More
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 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...
  • How to Use Python ‘SimpleHTTPServer’ to Serve Files Instantly
    How to Use Python ‘SimpleHTTPServer’ to Serve Files Instantly first check is python available or not. #python –V If command return version...
  • How to setup Network Configuration in Ubuntu Server 14.04
    Open Network Configuration file. #nano /etc/network/interface Then Add below mentioned lines and make changes as per your need. auto eth0 i...

Copyright © 2025 THE IT IDEAS | Powered by Blogger