Page 1 of 3 123 LastLast
Results 1 to 15 of 33

Thread: Here I go again

  1. #1
    Join Date
    Jul 2003
    Location
    The Dark Planet
    Posts
    1,401

    Post Unanswered: Here I go again

    Again am in a kinda mess ... am shifting from an old server to a new server with lots of disk space .... have migrated the jobs ... backup and restored the db's ... everything seems going fine until I come up to the Linked Servers .... there is one linked server that has been there for a long long time and nobody seems to know the remote login and password for that ...

    Can I simply move over the records for that server from sysservers and sysxlogins ...

    Is it advisable ???

    Are there any more tables I need to look into ...
    Get yourself a copy of the The Holy Book

    order has no physical Brett in The meaning of a Kaiser . -database data

  2. #2
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    I don't know if I'd mess with the system tables...

    How long does it take to build the new box...everything all scripted out?

    Doing a dump and restore ?

    How many linked servers do you have?

    Is any process even using the server?

    As part of this migration did you do any housekeeping (like getting rid of unused links)?
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  3. #3
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    And are you in the office?

    What the hell time is it over there?
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  4. #4
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,800
    Provided Answers: 11
    Can you clone the user on the remote system, with a new password? To me that would be easier. I have not played with linked servers, since they are such a pain to use. Especially when you try to move code from a QA server to a prod server. Too easy to hard code names in there.

  5. #5
    Join Date
    Jul 2003
    Location
    The Dark Planet
    Posts
    1,401
    Yup .. I am in the office .. time is just 3:21 AM ...

    And yes .. the linked server is being used for a table that is being transferred daily at 7 AM ...

    Right now ... nobody is around who can provide me with the password ...

    so any suggestions ???
    Get yourself a copy of the The Holy Book

    order has no physical Brett in The meaning of a Kaiser . -database data

  6. #6
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    -Usa -Pblank?

    -Usa -PServernme

    -Usa -PBoss's daughters name

    I'm suprised they're not all the same.....

    Do you know the other ones? Di d you try any of those?
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  7. #7
    Join Date
    Jul 2003
    Location
    The Dark Planet
    Posts
    1,401
    The Linked server is at a different location ... and its a oracle database ...

    The userid is system as i can make out from sysxlogins ...
    password
    Get yourself a copy of the The Holy Book

    order has no physical Brett in The meaning of a Kaiser . -database data

  8. #8
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    Wake them up!
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  9. #9
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Originally posted by blindman
    Wake them up!
    Certainly more helpful then my suggestions....

    Is this new box have to ready for the 7:00am dump?

    Or is the old box still handling the load?

    In other words did you cut over already?
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  10. #10
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,800
    Provided Answers: 11
    There may be a way, but it is very dangerous. I hope you have admin access to the SQL Server you are dealing with?

    Step one

    select password from sysxlogins where name = 'remote user's name'
    copy this result to the next query

    On the server you want to work

    exec sp_configure 'allow updates', 1
    reconfigure with override
    go
    update sysxlogins
    set password = 0x130270E06743495DE22414DAFA0CAA12
    where name = 'Remote User's name' -- <-- This is EXTREMELY IMPORTANT
    go
    exec sp_configure 'allow updates', 0
    reconfigure with override


    Forgive me for being a little emphatic about the where clause on that update query, but I know how I get at 3:00 in the morning.

    This depends on you being able to add the login in the first place, of course.

  11. #11
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    I'm LOL...mostly out of fear....

    TIMBER

    I'm going to go home and slip in to a margaritta...

    Good Luck Enigma...I'll logon from there to see how it's going....
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  12. #12
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,800
    Provided Answers: 11
    I agree, Brett. I would be nervous doing this myself, but it may be that Enigma has little to no choice. Unless he is able to wake up one of the guys he is workinig with. Hmm. 3 AM....Hong Kong, maybe?

  13. #13
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    Hong Kong? No, Enigma is what we Yanks call a "Red Coat".
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  14. #14
    Join Date
    Jul 2003
    Location
    The Dark Planet
    Posts
    1,401
    Did the following :
    Created a linked server from newserver to oldserver ...

    Code:
    exec sp_configure 'allow updates', 1
    reconfigure with override
    go
    update sysxlogins
    set password = (select distinct password from sysxlogins where lname ='SYSTEM') 
    where name = 'System'
    go
    exec sp_configure 'allow updates', 0
    reconfigure with override
    Didnt work out

    OLE DB provider 'MSDAORA' reported an error. Authentication failed.
    [OLE/DB provider returned message: ORA-01017: invalid username/password; logon denied
    ]
    OLE DB error trace [OLE/DB Provider 'MSDAORA' IDBInitialize::Initialize returned 0x80040e4d: Authentication failed.].
    Get yourself a copy of the The Holy Book

    order has no physical Brett in The meaning of a Kaiser . -database data

  15. #15
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    By the way, Enigma. Did you take your username from the famous code machine deciphered by Turing at Bletchley Park during WWII? Or are you just hard to figure out?
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

Posting Permissions

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