Lgoin

Question

Lgoin

Nita Reddy

SSCarpal Tunnel

Points: 4177
More actions
March 28, 2008 at 11:44 am

#120610

I have created AD login called App_Login and my SQL server is in Mixed mode
I log in through my credentials RNita
When I log into SQL server using SQL Authentication login name App_login and passing the password I am getting login failed for user app_login error 18456
With my credenticials I cannot use this Login Id or do I need to add this APP_Login in group and associate with my login ID

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

Mohan Kumar SSCertifiable Points: 5365 More actions · Answer 1

By default, Windows domain password policy enforcement for SQL authenticated logins is enabled unless you explicitly set the CHECK_POLICY clause of the CREATE LOGIN statement to OFF when you create a given login. Did you consider this while creating login?

Please verify and take corrective action using either of following command:

For a new SQL Server login

CREATE LOGIN , CHECK_POLICY = OFF

For an existing SQL Server login

ALTER LOGIN with CHECK_POLICY = OFF

[font="Verdana"]--www.sqlvillage.com[/size][/font]

Nita Reddy SSCarpal Tunnel Points: 4177 More actions · Answer 2

The AD account was created

I went to SQL server and through Management studio I went to Security and created a New Login through which was already created through Windows Atutentication.

I was in the impression I can login through SQL Authentication even it was windows acct was created.

I have Domain\App_login was already created when I did

ALTER LOGIN [Domain\App_login] with CHECK_POLICY = OFF

Msg 15080, Level 16, State 1, Line 1

Cannot use parameter CHECK_POLICY for a Windows login.

K. Brian Kelley SSC Guru Points: 114572 More actions · Answer 3

Nita Reddy (3/28/2008)
The AD account was created
I went to SQL server and through Management studio I went to Security and created a New Login through which was already created through Windows Atutentication.
I was in the impression I can login through SQL Authentication even it was windows acct was created.
I have Domain\App_login was already created when I did
ALTER LOGIN [Domain\App_login] with CHECK_POLICY = OFF
Msg 15080, Level 16, State 1, Line 1
Cannot use parameter CHECK_POLICY for a Windows login.

No, you cannot use a Windows login to connect via SQL Authentication. What you can do is this:

Start | Run | runas /user: Domain\App_login sqlwb

You shouldn't have a space between the : and the D, but unfortunately, on the forum it's translating to a smiley face. You'll be prompted for a password for that account. This will start SQL Server Management Studio as Domain\App_login. Another way to do this is to hold down the Shift key and right-click on the SSMS icon. You'll see an option for Run As. This allows you to specify an account to run the program under that's different from the user logged on to the machine.

K. Brian Kelley
@kbriankelley

Nita Reddy SSCarpal Tunnel Points: 4177 More actions · Answer 4

Nita Reddy

SSCarpal Tunnel

Points: 4177

March 28, 2008 at 12:47 pm

#795406

Thanks

That solve my problem

Nita:D

Nita Reddy SSCarpal Tunnel Points: 4177 More actions · Answer 5

Sorry I got this error below when I did run AS USER Demon\App_login then password

---------------------------

C:\Program Files\Microsoft SQL Server\90\Tools\Binn\VSShell\Common7\IDE\SqlWb.exe

---------------------------

C:\Program Files\Microsoft SQL Server\90\Tools\Binn\VSShell\Common7\IDE\SqlWb.exe

The directory name is invalid.

---------------------------

OK

---------------------------

K. Brian Kelley SSC Guru Points: 114572 More actions · Answer 6

That sounds possibly like a permissions issue at one of the folder levels. You may have one of your admins take a look.

K. Brian Kelley
@kbriankelley

Ignacio A. Salom Rangel SSC-Insane Points: 20443 More actions · Answer 7

You can also right click on th Management Studio Icon and select the run as option. Then you can select the second option (the lower one) The following user and the you type the domainname\username. That should do the trick.

My blog