Tell me more ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.
up vote 2 down vote favorite

When I attempt to create new login in MSSQL Server 2008, I get the following errors:

error1 error2

I have tried everything I know, but I can't get it to work.

What should I do and how I can solve these issues?

share|improve this question
Can you please show us the script that was generated for your action? Click the Script button in the New Login window. – Marian Nov 7 '11 at 12:45

2 Answers

up vote 4 down vote

Open the Window again to create a new login. Use the "Search" button to find the Windows login you wish to create an account for. Then you can click the "Script To" button at the top and get the actual T/SQL Script. It should look something like

CREATE LOGIN [KAWMIN-PC\Classic .NET AppPool] FROM WINDOWS

The UI doesn't always work correct for creating logins with spaces or other reserved characters.

Once you have the T/SQL script correct any issues and run the script and the login should be created. If there is an error post the error message to the site.

share|improve this answer
you are wrong, for why heels on this world you recommending add new user to the Native OS, that against all known good rulles, never donw-voter then +1 – mKorbel Nov 6 '11 at 19:47
1  
Denny's answer is NOT suggesting to add a new user to the Native OS. That is a SQL Server create login syntax.... – Mike Walsh Nov 6 '11 at 21:34
@Mike Walsh 1) local user 2) AD or LDAP (or other WinXxxDomain), not packages – mKorbel Nov 6 '11 at 23:30
@mKorbel can you explain your first comment? I'm not sure what you are saying in that comment. – mrdenny♦ Nov 7 '11 at 6:50
up vote 2 down vote

I would verify that that is a true account you are trying to add. The second error message seems to indicate you may not have the proper account name. I would use the search button and find the local or AD account that way.

The first error appears to say you didn't type a login name in when trying that approach.

You could verify that you are in mixed mode authenticate as mKorbel describes but I think it is more a case of not finding that login or not typing a login name for the other message. The proper place you'd want to go is SSMS --> Right click at the instance level --> Properties --> Security and then you would select SQL and Windows if not selected. My guess is you probably already have that and just need to verify the logins you are using.

share|improve this answer
i already had it.But it's still error occurring like above. – GoldenMM Nov 5 '11 at 18:00
"I already had it" --> what did you already have? Mixed mode authentication? Have you verified that you are using the right login? I really suspect you are likely just typing the login instead of using the search? – Mike Walsh Nov 5 '11 at 18:13
yes!.I had mixed mode.But it's still error like before. – GoldenMM Nov 6 '11 at 14:16

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.