Friday, June 26, 2020

Enable sa Login in sql server

sa user disabled or sa login failed or enable sa login or sa login enable

1.  Go to window login > right click > properties > enable window and sql server authentication
then ok



at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

When web application with sql server connection using sql client, working in visual studio but not working in localhost as in iis

Error:  The EXECUTE permission was denied on the object 'StoredProcedureTest1', database 'testDb1', schema 'dbo'.  C...

  • Custom Form Athentication MVC
    1. Customer Form Authentication Set on Controller 2. Set On Web config 3. Add Authentication Filter 4. Use Athentication Filter...
  • Java Script Event fire
     1. javascript event fire or Java Script Click Event fire,  var   tbl_item_detail_go  =  document . getElementById ( "tbl_item_detail_g...
  • Check lock in sql server
    set transaction isolation Level Repeatable read begin transaction select * from  [ Tran ] rollback transaction sp_lock select OBJ...