1. Home
  2. Point-Of-Sale Software
  3. SA password

SA password

Help me refresh my memory. I believe there is a method of changing the sa password.

Reply to
Bill Cunningham
Loading thread data ...

In SO Admin go to File>Connect. Connect to the db. Once connected go to Database > Change Password

Reply to
Andrew

Reply to
Bill Cunningham
Reply to
cptsoft

Send me an email an I will send yo a sql script

Afshin Alikhani - snipped-for-privacy@retailrealm.co.uk Retail Realm = = = = = = = = = "Bill Cunningham" wrote in message news: snipped-for-privacy@microsoft.com...

Reply to
Afshin

Reply to
Bill Cunningham

HOW TO CHANGE PASSWORD TO MSDE SERVER?

GO TO PROMPT WINDOW AND POINT TO C:\PROGRAM FILES\MICROSOFT SQL SERVER\

  1. We did the follwing:
  2. connected to sql server via osql:
  3. osql -S -E
  4. sp_password NULL, '','sa'
  5. go
  6. This changed password of sa and you were able to work with your application (mircosoft retail management software).

"Bill Cunningham" wrote in message news: snipped-for-privacy@microsoft.com...

Reply to
Sacha Favelevic

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.