Problem creating new user

• Mark Sheridan

  Newbie

  Points: 1

  More actions

  December 12, 2006 at 10:30 am

  #115525

  Hi all

  I'm trying to setup de[ployment scripts for a new database and I'm adding a new database login as follows

  CREATE login [username] WITH PASSWORD=N'password', DEFAULT_DATABASE=[master], CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF

  and I get the following error

  Msg 170, Level 15, State 1, Line 1

  Line 1: Incorrect syntax near 'login'.

  I know this works as I've used it on other servers, so I'm not sure what I'm missing. I'm running a local version SS2005 on a Windows XP Professional PC, and I'm connected as the sa user.

  This is slowly driving me insane, so if any one get throw any light my way it would be appreciated

  Thanks in advance

  Mark

• Adam Wilbur

  SSCertifiable

  Points: 7001

  More actions

  December 12, 2006 at 1:23 pm

  #677610

  It works for me, also running on XP pro.  Is this part of a larger script?  Are you maybe missing a "Go" or ";" somewhere?

  
  
  A.J.
  DBA with an attitude

• MohammedU

  SSCoach

  Points: 19644

  More actions

  December 12, 2006 at 1:42 pm

  #677615

  It is working on windows2000, xp also...

  Check your batch terminator...

  MohammedU
  Microsoft SQL Server MVP