Sign in
 
Home20122008 R2200820052000LibraryForums
SQL Server >
> 
> 
Login Failed

Jawab Login Failed

  • Friday, May 25, 2012 10:05 AM
     
     
    Sign In to Vote
    0

    Friends,

    I have installed SQL2008 on a domain machine and also install another db on machine2 which is not register on domain.

    When i try to connect db of machine1 from machine2. Its giving me this error:

    sometime its also generating error untrusted domain. My target instance name as follow:

    H-ITG7-IRFA\TEST2

    Please do needful.

    Regards,

    Irfan Ahmad

     

All Replies

  • Friday, May 25, 2012 10:18 AM
     
     
    Sign In to Vote
    0

    Hi,

    You're either going to have to log in using SQL Server authentication, or join the domain.


    Thanks,

    Andrew Bainbridge
    SQL Server DBA

    Please click "Propose As Answer" if a post solves your problem, or "Vote As Helpful" if a post has been useful to you

     
  • Friday, May 25, 2012 10:22 AM
    Moderator
     
     
    Sign In to Vote
    0

    Hello,

    Your SQL Server is a 2008 R2 ( for 2008, the version would be 10.0, for 2008 R2, the version is 10.50 ).

    As the machine2 is not belonging to the domain, you cannot use Windows authentification , only SQL Server (mixed) authentification.

    http://msdn.microsoft.com/en-us/library/cc280744(SQL.105).aspx

    Don't hesitate to post again for more help or explanations.

    Have a nice day

    Mark Post as helpful if it provides any help.Otherwise,leave it as it is.

     
  • Friday, May 25, 2012 10:28 AM
     
     
    Sign In to Vote
    0

    After using SQL authentication getting this error i am entering correct password.

     
  • Friday, May 25, 2012 10:32 AM
     
     Answered
    Sign In to Vote
    1

    Hi,

    Please log on locally to machine 1 and review the SQL Server error log.  Along with the 18456 error, there will be other codesd which will tell us exactly what the cause of the login failure is.  Or, you can check for yourself at: http://sqlblog.com/blogs/aaron_bertrand/archive/2011/01/14/sql-server-v-next-denali-additional-states-for-error-18456.aspx

    My guess would be that you're probably getting the sa password wrong


    Thanks,

    Andrew Bainbridge
    SQL Server DBA

    Please click "Propose As Answer" if a post solves your problem, or "Vote As Helpful" if a post has been useful to you

     
  • Friday, May 25, 2012 11:32 AM
    Moderator
     
     
    Sign In to Vote
    0

    Hello,

    Your error is about a registered server.Have you created a registered server  ?

    See this link : http://msdn.microsoft.com/en-us/library/ms173574(SQL.105).aspx

    and especially :

    http://msdn.microsoft.com/en-us/library/ms175487(SQL.105).aspx

    http://msdn.microsoft.com/en-us/library/ms190792(SQL.105).aspx

    http://msdn.microsoft.com/en-us/library/ms177498(SQL.105).aspx

    http://msdn.microsoft.com/en-us/library/ms191167(SQL.105).aspx

    It is possible that you have already regisstered the other instance.I think that the best way is to delete the current registered server and to recreate a new one.

    Don't hesiate to post again for more help or explanations.

    Have a nice day

    PS : the Andrew's request is very important ( to read the SQL Server error log and to provide the full informations contained in it ) .Without them, it will be difficult to help you.

    Mark Post as helpful if it provides any help.Otherwise,leave it as it is.


     
  • Friday, May 25, 2012 11:44 AM
    Moderator
     
     Answered
    Sign In to Vote
    1

    Check the SQL Server error log (under the Management node in Object Explorer).  If the login failed message indicates the server is configured for Windows authentication only, right-click on the root server node in Object Explorer, select properties and change the authentication mode to SQL Server and Windows Authentication mode.

    Dan Guzman, SQL Server MVP, http://weblogs.sqlteam.com/dang/