Results 1 to 5 of 5
  1. #1
    Join Date
    Nov 2002
    Location
    Colchester, England
    Posts
    8

    Unhappy Unanswered: Linked Server Language Problem

    Hi,
    I have got a problem with two sql 2000 linked servers,

    On Server A it has the SA account and Developer account, which both have the British English Language Setting.
    On Server B you have the same accounts but SA has us_english Language.

    The problem is that when running a stored procedure from Server A to the Linked Server B it fails on the Datetime Conversion, using the developer login but passes on SA, when you run the SP directly on Server B, the SA login Fails to run the SP and the Developer Login run's correctly.

    This means that some where between the two servers the language setting is getting thrown off and swapping so instead of mapping
    Developer British English to Developer British English it is changing to us_English. and visa versa for the Sa Account.

    What i need to know is where its going wrong and why. I have checked all of the Servers Language settings and they are fine. I have been unable to replicate the problem on any other servers. And am ready to pull my hair out.


    Thanks in advance

    Pete

  2. #2
    Join Date
    Feb 2003
    Location
    Montreal, Canada
    Posts
    117

    Re: Linked Server Language Problem

    Hi Pete,

    First, check the collation for both servers and/or databases . If it's different then go to
    Linked Server Properties - Server Option - Collation Name (in the Linked Server Pane) and change it accordingly.

    Originally posted by pgolne
    Hi,
    I have got a problem with two sql 2000 linked servers,

    On Server A it has the SA account and Developer account, which both have the British English Language Setting.
    On Server B you have the same accounts but SA has us_english Language.

    The problem is that when running a stored procedure from Server A to the Linked Server B it fails on the Datetime Conversion, using the developer login but passes on SA, when you run the SP directly on Server B, the SA login Fails to run the SP and the Developer Login run's correctly.

    This means that some where between the two servers the language setting is getting thrown off and swapping so instead of mapping
    Developer British English to Developer British English it is changing to us_English. and visa versa for the Sa Account.

    What i need to know is where its going wrong and why. I have checked all of the Servers Language settings and they are fine. I have been unable to replicate the problem on any other servers. And am ready to pull my hair out.


    Thanks in advance

    Pete
    Steve

  3. #3
    Join Date
    Nov 2002
    Location
    Colchester, England
    Posts
    8

    Re: Linked Server Language Problem

    Steve,
    Thanks for the response, but the problem is nothing to do with collation, as it is set up identically on both machines, it appears that the mapping of the languages through the linked server is going haywire!

    Cheers

    Pete

  4. #4
    Join Date
    Feb 2003
    Location
    Montreal, Canada
    Posts
    117

    Re: Linked Server Language Problem

    Did you try to change the language for SA account on B to British?

    EXEC sp_defaultlanguage 'SA','British'
    Steve

  5. #5
    Join Date
    Nov 2002
    Location
    Colchester, England
    Posts
    8

    Re: Linked Server Language Problem

    Yes and it failed as expected. but when the query is run on the destination machine it works perfectly. Pointing to the fact that the Linked server login alias is failing.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •