I would have to guess that I need to change the SA password to something else. Is there an easy way to go about doing this? It is not set to no password, but maybe it is an easy hack??? Can I change this easily? I am not really SQLServer intelligent, but I did change the password originally, but how can I change this again?
Thanks for the help! Sincerely, Grant Griffith, Vice President EI8HT LEGS Web Management Co., Inc. http://www.getafreewebsite.com 877-483-3393 ||-----Original Message----- ||From: [EMAIL PROTECTED] ||[mailto:[EMAIL PROTECTED]]On Behalf Of Royce Fessenden ||Sent: Thursday, December 13, 2001 4:50 PM ||To: [EMAIL PROTECTED] ||Subject: RE: [IMail Forum] OT: SQL Server Question! || || ||>> Microsoft SQLServer 7.0 SP2 installed. I just looked and saw ||that SP3 is ||out there. Maybe I need to install that. << || ||First thing I would check is the password for the SA user. Default is no ||password and it is often not changed after the initial ||install.(Or it is set ||to an easy hack.) After that it depends on whether you are using NT ||authentication or SQL authentication. I always turn on auditing ||and log all ||successful and failed logons. Surprising what you find. || ||There may be some patches that need to be installed. The easiest ||way is to ||check is with new Security CD from Microsoft. However, I have found that ||most problems result from a User/Password or permissions hole. || ||Royce Fessenden ||System Administrator || || ||Please visit http://www.ipswitch.com/support/mailing-lists.html ||to be removed from this list. || ||An Archive of this list is available at: ||http://www.mail-archive.com/imail_forum%40list.ipswitch.com/ || Please visit http://www.ipswitch.com/support/mailing-lists.html to be removed from this list. An Archive of this list is available at: http://www.mail-archive.com/imail_forum%40list.ipswitch.com/
