Thanks! :)
Craig.
-----Original Message----- From: IMail_Forum-owner@list.ipswitch.com [mailto:IMail_Forum-owner@list.ipswitch.com]On Behalf Of Jeff Vanzella Sent: Thursday, March 15, 2001 3:43 PM To: IMail_Forum@list.ipswitch.com Subject: RE: [IMail Forum] SQL query
I've run into this before. I think you have to start it from the command line:
sqlservr -f -m
You should then be able to get in and change to password in the start up account.
I hope this helps.
Jeff
___________________________ Jeff Vanzella Systems Admin Web-Business-Services.com
Jeff@Snowboards.com
(604) 938-0590
________________________________________________________ Join the World's Largest Snowboard Community for FREE!!! www.Snowboard.com
-----Original Message----- From: IMail_Forum-owner@list.ipswitch.com [mailto:IMail_Forum-owner@list.ipswitch.com]On Behalf Of J.R. Dobyns Sent: Thursday, March 15, 2001 11:20 AM To: IMail_Forum@list.ipswitch.com Subject: RE: [IMail Forum] SQL query
Find the machine in the Server Enterprise manager, right click and click on properties, go to Security, at the bottom there should be a place to set start acc. Change this to the Administrator and its new password and it should work fine!
-----Original Message----- From: IMail_Forum-owner@list.ipswitch.com [mailto:IMail_Forum-owner@list.ipswitch.com]On Behalf Of Craig Gittens Sent: Thursday, March 15, 2001 12:15 PM To: IMail_Forum@list. ipswitch. com Subject: [IMail Forum] SQL query
OT, I am having some trouble with SQL and was wondering if anyone would help. When I installed SQL, I chose NT auth. I want to change the administrator password, but when I do, SQL service won't start. Anyone can help me with instructions on how to go about fixing this?
Thanks,
Craig Gittens