Home | Site Map | Cisco How ToNet How To | Wireless |Search | Forums | Services | Donations | Careers | About Us | Contact Us|

Examples of changing SQL user login

Network Sharing , TCP/IP, Internet, Wireless, Exchange, IIS, ISA and Print

Examples of changing SQL user login

Postby blin » Wed Feb 07, 2018 10:50 am

A. Enabling a disabled login username blin

Run this command:
ALTER LOGIN blin ENABLE;

B. Changing the password of a login username blin

Run this command:
ALTER LOGIN blin WITH PASSWORD = 'Pa$$w0rd';

C. Changing the name of a login username from blin to boblin

Run this command
ALTER LOGIN blin WITH NAME = boblin;

D. Unlocking a login blin
replacing **** with the desired account password.

Run this command:
ALTER LOGIN blin WITH PASSWORD = Pa$$w0rd UNLOCK ;
How to Configure and Troubleshoot Cisco
http://www.howtocisco.com

Tablet and Smartphone Setup Guide
http://www.quicksetupguide.com
blin
Site Admin
 
Posts: 3686
Joined: Wed Dec 31, 1969 7:00 pm
Location: Chicago, USA

Return to Networking

Your Ad Here

Who is online

Users browsing this forum: Google [Bot] and 8 guests