<div>
you need to give password complusory. see the following code,<br />

<pre><code id="code-937410">CREATE LOGIN [PRIC_1_TEST] WITH password = 'Test123533', DEFAULT_DATABASE=[TRACKER]
</code></pre>
</div>


you need to give password complusory. see the following code,


CREATE LOGIN [PRIC_1_TEST] WITH password = 'Test123533', DEFAULT_DATABASE=[TRACKER]


<div>
I guess I can't post fast enough. :) I didn't meant o post the same as everyone else, I'm just too slow... :)<br />

</div>


I guess I can't post fast enough. :) I didn't meant o post the same as everyone else, I'm just too slow... :)


<div>
helped. thanks very much,experts.
</div>


<div>
<div class="content wysiwyg-content">
when trying to create a login, <br />
CREATE LOGIN [PRIC_1_TEST] WITH DEFAULT_DATABASE=[TRACKER]<wbr /><br />
i get the error<br />
Msg 102, Level 15, State 1, Line 2<br />
Incorrect syntax near 'TRACKER'.<br />
<br />
what else is needed to create a login?<br />
<br />
thanks
</div>
</div>


when trying to create a login, 
CREATE LOGIN [PRIC_1_TEST] WITH DEFAULT_DATABASE=[TRACKER]
i get the error
Msg 102, Level 15, State 1, Line 2
Incorrect syntax near 'TRACKER'.

what else is needed to create a login?

thanks

CREATE LOGIN syntax error

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.