Calling Love India And Sql Experts

[150bryant]

[url="http://support.esri.com/cn/knowledgebase/techarticles/detail/29672"]http://support.esri.com/cn/knowledgebase/techarticles/detail/29672[/url]

[url="http://stackoverflow.com/questions/481954/sql-server-db-restored-login-failed-error"]http://stackoverflow.com/questions/481954/sql-server-db-restored-login-failed-error[/url]

this one has some valid info
[url="http://support.microsoft.com/kb/168001"]http://support.microsoft.com/kb/168001[/url]

u might want to link the users after restoring DB
[url="http://stackoverflow.com/questions/867986/linking-users-to-login-after-restoring-a-sql-server-2005-database"]http://stackoverflow.com/questions/867986/linking-users-to-login-after-restoring-a-sql-server-2005-database[/url]

this is for orphaned severs
[url="http://www.fileformat.info/tip/microsoft/sql_orphan_user.htm"]http://www.fileformat.info/tip/microsoft/sql_orphan_user.htm[/url]

[loveindia]

application might be using the MID(login).. see if they have that id has the super user permissions present.. or the user account u are using has valid permissions... dba vi naaku ekkuva telidu.. nenu aitey ivi chustaa.. [img]http://3.bp.blogspot.com/-tkaCHS80Z9Q/UZexbnBlmiI/AAAAAAAAFRw/v0QN-4X0__c/s1600/chiru1.gif[/img]

[distinct]

[quote name='MandhuMarbalaM' timestamp='1378868665' post='1304232884']
[url="http://support.esri.com/cn/knowledgebase/techarticles/detail/29672"]http://support.esri....es/detail/29672[/url]

[url="http://stackoverflow.com/questions/481954/sql-server-db-restored-login-failed-error"]http://stackoverflow...in-failed-error[/url]

this one has some valid info
[url="http://support.microsoft.com/kb/168001"]http://support.microsoft.com/kb/168001[/url]

u might want to link the users after restoring DB
[url="http://stackoverflow.com/questions/867986/linking-users-to-login-after-restoring-a-sql-server-2005-database"]http://stackoverflow...r-2005-database[/url]

this is for orphaned severs
[url="http://www.fileformat.info/tip/microsoft/sql_orphan_user.htm"]http://www.fileforma...orphan_user.htm[/url]
[/quote]
this server connection is different entirely
right now am not using restored database
this is a fresh database in another server
just wondering how database in this server also getting the same issue of log in problem

[distinct]

[quote name='loveindia' timestamp='1378869144' post='1304232913']
application might be using the MID(login).. see if they have that id has the super user permissions present.. or the user account u are using has valid permissions... dba vi naaku ekkuva telidu.. nenu aitey ivi chustaa.. [img]http://3.bp.blogspot.com/-tkaCHS80Z9Q/UZexbnBlmiI/AAAAAAAAFRw/v0QN-4X0__c/s1600/chiru1.gif[/img]
[/quote]
what is MID login
this user is the super user it was working previously.
it has everything even database has same credentials but could not log in
its not dba issue am guessing so

[loveindia]

[quote name='distinct' timestamp='1378870380' post='1304233013']
what is MID login
this user is the super user it was working previously.
it has everything even database has same credentials but could not log in
its not dba issue am guessing so
[/quote]

MID antey Managed ID used by applications.. Non-Person ID ani man... that user permissions check once and also check with the websphere (JAVA frontend) or application team to validate once...

[Power Star]

[distinct]

[quote name='loveindia' timestamp='1378873086' post='1304233259']

MID antey Managed ID used by applications.. Non-Person ID ani man... that user permissions check once and also check with the websphere (JAVA frontend) or application team to validate once...
[/quote]
account lock ayindi
how to unlock super role in db

[loveindia]

[quote name='distinct' timestamp='1378873750' post='1304233288']
account lock ayindi
how to unlock super role in db
[/quote]

account unlock cheydaniki use this
[code]ALTER LOGIN login_name WITH PASSWORD = 'password_here' UNLOCK[/code]

Super user is nothing but userid with SA (System Administrator) Permissions.

[distinct]

[quote name='loveindia' timestamp='1378874163' post='1304233309']

account unlock cheydaniki use this
[code][font="Consolas, Menlo, Monaco,"][color="#000000"]ALTER LOGIN login_name WITH PASSWORD = 'password_here' UNLOCK[/code][/color][/font]

Super user is nothing but userid with SA (System Administrator) Permissions.
[/quote]
SELECT LOGINPROPERTY[color=gray][font=inherit]([/font][/color][color=red][font=inherit]'SA'[/font][/color][color=gray][font=inherit],[/font][/color] [color=red][font=inherit]'IsLocked'[/font][/color][color=gray][font=inherit]);[/font][/color]

If the OUTPUT is: 0 -> account is UNLOCKED, 1 -> account is LOCKED.

ALTER [color=blue][font=inherit]LOGIN[/font][/color] SA [color=blue][font=inherit]WITH[/font][/color] PASSWORD [color=gray][font=inherit]=[/font][/color] [color=red][font=inherit]'Pass!123'[/font][/color] UNLOCK



i have got that query thu google
do i need to edit anything in that query

[ICANWIN]

i am not a DB expert but sometimes companies have common gateway which you should authenticate before accessing DB ...ala emanna undemo check chesuko...

[distinct]

[quote name='ICANWIN' timestamp='1378874252' post='1304233314']
i am not a DB expert but sometimes companies have common gateway which you should authenticate before accessing DB ...ala emanna undemo check chesuko...
[/quote]
few min varaku a prob ledhu
just ipudu vachindi

[distinct]

[quote name='loveindia' timestamp='1378874163' post='1304233309']
account unlock cheydaniki use this
[code]ALTER LOGIN login_name WITH PASSWORD = 'password_here' UNLOCK[/code]

Super user is nothing but userid with SA (System Administrator) Permissions.
[/quote]
login name lo email id laga unthadi @**.** ani

dot daggra error chupisthundi syntax error

[ICANWIN]

[quote name='distinct' timestamp='1378874438' post='1304233319']
few min varaku a prob ledhu
just ipudu vachindi
[/quote]
oh ok...ma last client ki authenticate chesina oka 10-15 times open connection ani sql developer lo click cheste kani open ayyedi kadu...


anyways hope some sql/dba expert answers ur question here

[distinct]

[quote name='ICANWIN' timestamp='1378874614' post='1304233330']
oh ok...ma last client ki authenticate chesina oka 10-15 times open connection ani sql developer lo click cheste kani open ayyedi kadu...


anyways hope some sql/dba expert answers ur question here
[/quote]
oh

[loveindia]

[quote name='distinct' timestamp='1378874602' post='1304233326']
login name lo email id laga unthadi @**.** ani

dot daggra error chupisthundi syntax error
[/quote]
Are you able to connect to the database using this user id and password through SSMS??? try that first...