Post reply

Help Needed

  • September 4, 2005 at 10:08 pm

    #168592

    Hi all,

    I have two servers running windows 2003 and both having sql server 2000.

    I want to establish a linked server between all of them.

    i created them . but now when accessing the data from those server the following error is being displayed

    Server: Msg 18452, Level 14, State 1, Line 1

    Login failed for user 'manoj'. Reason: Not associated with a trusted SQL Server connection.

    i have enabled mixed mode authentication.even then its not displaying the intended result.

    please respond is urgent.

    thanks.

  • September 4, 2005 at 11:45 pm

    #587503

    "i have enabled mixed mode authentication.even then its not displaying the intended result."

    So does this mean you can connect to the linked server and get results, but your query is wrong?

     

    --------------------
    Colt 45 - the original point and click interface

  • September 4, 2005 at 11:50 pm

    #587504

    no even then its showing the same error

  • September 4, 2005 at 11:55 pm

    #587505

    When defining the linked server what options/entries have you put on the Security tab?

     

    --------------------
    Colt 45 - the original point and click interface

  • September 5, 2005 at 12:35 am

    #587508

    I had tried with both options

    1)be made using the login's current security context

    2)be made using this security context

  • September 5, 2005 at 12:48 am

    #587509

    For the "made using this security context" option, did you use an SQL Login that has be defined on the remote server?

    You can setup a linked server easier using T-SQL in Query Analyzer,

    EXEC master..sp_dropserver '<<remote server name>>', 'droplogins'
GO
EXEC master..sp_addlinkedserver '<<remote server name>>', N'SQL Server'
GO
EXEC master..sp_addlinkedsrvlogin '<<remote server name>>', 'false', NULL, '<<username>>', '<<password>>'
GO
EXEC master..sp_linkedservers
GO

    Just replace the items indicated by <<>>

     

    --------------------
    Colt 45 - the original point and click interface

  • September 5, 2005 at 1:12 am

    #587515

    still it is showing the same error

  • September 5, 2005 at 1:19 am

    #587518

    Are both servers running mixed mode authentication?

     

    --------------------
    Colt 45 - the original point and click interface

  • September 5, 2005 at 1:41 am

    #587525

    yes for both servers in properties/security sqlserver and Windows Authentication is selected

  • September 5, 2005 at 1:47 am

    #587527

    Have you tried logging in to the remote server using Query Analyzer? Maybe the username and/or password are different on the remote server.

     

    --------------------
    Colt 45 - the original point and click interface

  • September 5, 2005 at 2:34 am

    #587530

    i logged into the remote server using remote desktop connection and then I fired a query

    select * from username

    where username is a tablename

    then it is displaying all the rows in the tables.

    but i dont know how to loggin through query analyser??

  • September 5, 2005 at 5:59 am

    #587556

    Open Query Analyzer on your machine, or the local server, and you should get a dialog prompting you for connection details. Put in the exact same details you are using when setting up the linked server.

    If you get the same error, then you've got the wrong username/password. I'd suggest changing them on the remote server and then trying again.

     

    --------------------
    Colt 45 - the original point and click interface

  • September 5, 2005 at 6:47 am

    #587571

    i am able to connect to other server and fire a query. its working fine.

    But its not working with Linked servers

  • September 5, 2005 at 9:45 am

    #587608

    That problem is solved .

    actually IPX/SPX protocol was not added to allowed protocol list.

    But now i am getting a different error when i am trying to execute a distributed transaction on these two server that are configured as linked servers.

    for example

    begin distributed tran

    insert into [INT-LINUX-SERVE].manoj.dbo.username values('MANOJ','INDIA');

    commit tran

    error shown is --

    Server: Msg 7391, Level 16, State 1, Line 2

    The operation could not be performed because the OLE DB provider 'SQLOLEDB' was unable to begin a distributed transaction.

    [OLE/DB provider returned message: New transaction cannot enlist in the specified transaction coordinator. ]

    thanks

  • September 6, 2005 at 5:53 am

    #587728

    Now why would you be using IPX/SPX ??

    There is a knowledgebase article on this the 7391 error. I don't have the time to hunt it down at the moment, but if you search on Google, or at the Microsoft website, you should be able to locate it.

     

    --------------------
    Colt 45 - the original point and click interface

Viewing 15 posts - 1 through 15 (of 16 total)

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