Administrator Log On/Off?

You can't do anything in Administrator without knowing the SQL Server login and password, or being logged into Windows as an Administrator. There's no reason for cashiers to know the SQL Server login and if you're letting them use an Admin Windows account you've already lost the war.

Glenn, all I have to do to log in to admin is open the program, then goto file > connect and I'm in? I never set anything up...it's been like that since day one.

Vince when SQL server or MSDE was install, the sa login must have been set up without password protection. if during the setup, the sa password is left blank, any user can connect to the database through the admin program even with nothing entered for password.

to fix this use the stored procedure "sp_password". for example:

EXEC sp_password NULL, 'newpassword', 'sa'

this changes the password for the 'sa' user from NULL to 'newpassword'

hth kev> Glenn, all I have to do to log in to admin is open the program, then goto

I don't understand what you mean...is there another way to do this?

if you can connect to the database through administrator without the use of a password with your sa login id, that means that no password was set up for the system admin login when SQL server was installed. to remedy this, open administrator and connect to the database. open up a new query window, and type the following command:

EXEC sp_password NULL, 'newpassword', 'sa'

replace 'newpassword' with whatever you want for your sa password, keeping it in the single quotes

hth kevin

Thank You...I am going to give this a shot today. I appreciate the quick response. I'm not much of a programmer...at all, I know my way around, but that's pretty much it.

An easier way is to go File, Connect, then Database, Change Password. Less typing :)

Thank you Jason...much easier...the problem is that I did it the other way first, and found that I did not get a "warning" and nothing worked, except lucky for me Admin. I was able to do what you said, go into database and change it back to the old pass, where it works fine again. My question is how can I change all of the connections so that they work just fine when I change the password?

On each station, go in to Store Ops Administrator and then File, Configuration, change the password in there, and then click OK.

The File/Connect command just connects you to the database so that you can perform maintenance with the commands in the Database menu. The File/Configuration command is where you actually set the parameters that Store Operations POS and Manager use to connect to the database.

Jason, I will give it a shot...I appreciate the response. I actually started a new thread thinking no body would read this and respond. Thank you very much.