Using DOS batch file to change MSDE blank passwords

From: F_MIkey (anonymous_at_discussions.microsoft.com)
Date: 11/25/03 

Date: Tue, 25 Nov 2003 11:26:04 -0800

Hello.

I am attempting to write a batch file that will automatically logon and set the blank passwords on multiple users laptops to a password of IS Supports choosing. My scripting skills are very raw but here is what I have thus far:

osql -U sa -P
Exec sp_password NULL,'Test!01','sa'
go
exit

All I am able to accomplish is the following:

osql -U sa -P
1>

I don't want the users to have to do ANYTHING. Can someone help me accomplish this?

Relevant Pages

  • Re: Using DOS batch file to change MSDE blank passwords
    ... If you want osql to quit after it has run your commands, ... Jasper Smith (SQL Server MVP) ... the blank passwords on multiple users laptops to a password of IS Supports ... All I am able to accomplish is the following: ...
    (microsoft.public.sqlserver.security)
  • entering text w/o echoing
    ... i need the ability to accept keyboard input without echoing it back to ... the screen (passwords, etc.) and have not yet found anything that will ... accomplish that. ...
    (perl.beginners)
  • Re: no pwd prompt no ssh-agent
    ... > I know how to setup and use the SSH-AGENT so as not to need passwords ... > but I wondered if there is some other way to accomplish that. ... > and suspect there is a way to get no password login going thru keys ...
    (comp.security.ssh)
  • Re: no pwd prompt no ssh-agent
    ... > I know how to setup and use the SSH-AGENT so as not to need passwords ... > but I wondered if there is some other way to accomplish that. ... > I've seen talk of keys used in some tricky ways I didn't understand ... > and suspect there is a way to get no password login going thru keys ...
    (comp.security.ssh)
  • no pwd prompt no ssh-agent
    ... I know how to setup and use the SSH-AGENT so as not to need passwords ... but I wondered if there is some other way to accomplish that. ... I've seen talk of keys used in some tricky ways I didn't understand ...
    (comp.security.ssh)