Create login - domain name with '.'

• victorel

  SSC Journeyman

  Points: 76

  More actions

  September 19, 2012 at 3:14 pm

  #268005

  Hi

  I'm trying to create a simple script to allow Network Service accout to access my database

  DECLARE @user NVARCHAR(50)

  SET @user = ABC.COM\ABC105$'

  DECLARE @SQL NVARCHAR(4000);

  SET @SQL = 'CREATE LOGIN [' + @user + '] FROM WINDOWS WITH DEFAULT_DATABASE=[master]'

  EXECUTE(@SQL);

  SET @SQL = 'CREATE USER [' + @user + '] FOR LOGIN ['+@user+'] WITH DEFAULT_SCHEMA=[dbo]'

  EXECUTE(@SQL);

  EXEC sp_addrolemember 'db_owner', @user

  GO

  The script fails with the message:

  Msg 15401, Level 16, State 1, Line 1

  Windows NT user or group 'ABC.COM\ABC105$' not found. Check the name again.

  if I just execute

  CREATE LOGIN ABC.COM\ABC105$ FROM WINDOWS WITH DEFAULT_DATABASE=[master]

  it says

  Msg 102, Level 15, State 1, Line 1

  Incorrect syntax near '.'.

  How do I fix that?

  Thanks in advance

• victorel

  SSC Journeyman

  Points: 76

  More actions

  September 19, 2012 at 3:32 pm

  #1539826

  Hmmm I figured it out myself. The domain should not include the .com portion. Not clear why though

• Kenneth.Fisher

  SSC-Insane

  Points: 20396

  More actions

  September 19, 2012 at 11:03 pm

  #1539887

  Just out of curiosity give this a try:

  CREATE LOGIN [ABC.COM]\ABC105$ FROM WINDOWS WITH DEFAULT_DATABASE=[master]

  Kenneth FisherI was once offered a wizards hat but it got in the way of my dunce cap.--------------------------------------------------------------------------------For better, quicker answers on T-SQL questions, click on the following... http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]For better answers on performance questions, click on the following... http://www.sqlservercentral.com/articles/SQLServerCentral/66909/[/url]Link to my Blog Post --> www.SQLStudies.com[/url]