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 «««1234

SQL Server 2005 Logins Expand / Collapse
Author
Message
Posted Friday, July 3, 2009 9:38 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, February 4, 2013 7:20 AM
Points: 1, Visits: 8
Hello
I have a Sql 2000 and I'd like to migrate to sql 2005. The problem I have it's that on the Sql 2000 I have the password of SA less than 8 characters, is it possible to maintain the same password on SQL 2005?

Thanks
Post #747040
Posted Thursday, October 1, 2009 7:32 PM


SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, November 18, 2014 7:19 AM
Points: 35, Visits: 909
If a program requires a login with the SYSADMIN role and rights to Master, will a login with the SYSADMIN role have rights to MASTER by default or does that have to be granted?


KU
Post #796723
Posted Friday, October 2, 2009 2:11 PM


Keeper of the Duck

Keeper of the Duck

Group: Moderators
Last Login: Friday, November 14, 2014 7:14 AM
Points: 6,625, Visits: 1,876
pclemares (7/3/2009)
Hello
I have a Sql 2000 and I'd like to migrate to sql 2005. The problem I have it's that on the Sql 2000 I have the password of SA less than 8 characters, is it possible to maintain the same password on SQL 2005?

Thanks


Yes, when you go to modify the sa account, toggle Password Policy Enforcement off. However, from a security perspective, you need to see about getting that SA account password to at least 8 characters.


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 #797203
Posted Friday, October 2, 2009 2:12 PM


Keeper of the Duck

Keeper of the Duck

Group: Moderators
Last Login: Friday, November 14, 2014 7:14 AM
Points: 6,625, Visits: 1,876
SequelDBA (10/1/2009)
If a program requires a login with the SYSADMIN role and rights to Master, will a login with the SYSADMIN role have rights to MASTER by default or does that have to be granted?


And login which is a member of the sysadmin role has all rights everywhere on a particular instance of SQL Server. Those rights are implicit. Basically, being a member of the sysadmin server role means the login ignores all security checks. So yes, it does.


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 #797205
Posted Monday, January 24, 2011 7:55 AM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Wednesday, November 12, 2014 4:32 AM
Points: 514, Visits: 1,739
is there a work around in SQL 2005, 2008, 2008 R2 that allows for ;

alter login [DomainGroupName] DISABLE;

thanks
Post #1052373
Posted Thursday, February 3, 2011 7:20 AM


Keeper of the Duck

Keeper of the Duck

Group: Moderators
Last Login: Friday, November 14, 2014 7:14 AM
Points: 6,625, Visits: 1,876
Geoff A (1/24/2011)
is there a work around in SQL 2005, 2008, 2008 R2 that allows for ;

alter login [DomainGroupName] DISABLE;

thanks


No, this behavior is by design. What you can do is:

DENY CONNECT SQL TO [DomainGroupName];



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 #1058071
« Prev Topic | Next Topic »

Add to briefcase «««1234

Permissions Expand / Collapse