I wanted to test CREATE LOGIN script which was generated for creating a login on another SQL Instance. I'm receiving an error: CREATE LOGIN [ACCOUNTNAME] WITH PASSWORD = 0x01005CD1F6C15FC43A1F66EF350878DF58313F438372F3AD366C HASHED, SID = 0x019F68B303BCFC43B092FB603A134136, DEFAULT_DATABASE = [master], CHECK_POLICY = OFF, CHECK_EXPIRATION = OFF I can run the CREATE login on a different SQL Server just fine but on my new SQL Instance this does not work. Any ideas why this would work on one SQL instance but not another? This is a SQL account and the SQL Server that it is failing on is part of a workgroup until we migrate databases. I'm just trying to test the script prior to project start time.
Are both instances SQL 2008R2 and both in the same workgroup? If one is in workgroup and it is working, but not on a server that may be in a domain, it is probably related to the password complexity requirements of the instance in the domain. If that is not the case, do both instances support SQL authentication?