Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

SQL Server 2000 SP 3: What's New in Security Expand / Collapse
Author
Message
Posted Wednesday, August 27, 2003 12:21 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: 2 days ago @ 4:31 PM
Points: 233, Visits: 171
Great article. I have a question about SP3a. Since I have applied it, everytime I go into Security, logins in EM and add database roles to a user, I am prompted for the password. I have not change the password and was wondering if this is a new feature in SP3a?

Thanks again and keep up the good work.


Glenn Thompson, Aspen, Colorado




Post #52484
Posted Wednesday, August 27, 2003 12:22 PM


Keeper of the Duck

Keeper of the Duck

Group: Moderators
Last Login: 2 days ago @ 8:57 AM
Points: 6,634, Visits: 1,872
Have you applied any other hotfixes to SQL Server after applying SP3a?


K. Brian Kelley
http://www.truthsolutions.com/
Author: Start to Finish Guide to SQL Server Performance Monitoring
http://www.netimpress.com/


K. Brian Kelley, CISA, MCSE, Security+, MVP - SQL Server
Regular Columnist (Security), SQLServerCentral.com
Author of Introduction to SQL Server: Basic Skills for Any SQL Server User
| Professional Development blog | Technical Blog | LinkedIn | Twitter
Post #52485
Posted Wednesday, August 27, 2003 12:27 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: 2 days ago @ 4:31 PM
Points: 233, Visits: 171
No. My version is 8.00.760


Glenn




Post #52486
Posted Wednesday, August 27, 2003 12:32 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: 2 days ago @ 4:31 PM
Points: 233, Visits: 171
Brian, the really strange thing is when I put in the confirming password (I know it is correct), EM tells me it is wrong. So I have to put it in twice.

gt




Post #52487
Posted Wednesday, August 27, 2003 12:40 PM


Keeper of the Duck

Keeper of the Duck

Group: Moderators
Last Login: 2 days ago @ 8:57 AM
Points: 6,634, Visits: 1,872
Hrm. I thought I saw something similar... it might have been here. I'll take a look.


K. Brian Kelley
http://www.truthsolutions.com/
Author: Start to Finish Guide to SQL Server Performance Monitoring
http://www.netimpress.com/


K. Brian Kelley, CISA, MCSE, Security+, MVP - SQL Server
Regular Columnist (Security), SQLServerCentral.com
Author of Introduction to SQL Server: Basic Skills for Any SQL Server User
| Professional Development blog | Technical Blog | LinkedIn | Twitter
Post #52488
Posted Wednesday, August 27, 2003 12:42 PM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Wednesday, November 2, 2005 11:49 AM
Points: 2,611, Visits: 1
Check this fix http://support.microsoft.com/default.aspx?scid=kb;en-us;826161




Post #52489
Posted Wednesday, August 27, 2003 12:47 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: 2 days ago @ 4:31 PM
Points: 233, Visits: 171
It almost seems like the initial password for the login is blank. And (I'm not really saying this) the passwords haven't been modified in a long time.

gt




Post #52490
Posted Wednesday, August 27, 2003 12:58 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: 2 days ago @ 4:31 PM
Points: 233, Visits: 171
Allen, thanks that fixed my problem.


glenn





Post #52491
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse