+ Post New Thread
Results 1 to 8 of 8
MIS Systems Thread, Just a little tired but... in Technical; I was helping out with a school to get them a backup SIMS server (I say server, it was running ...
  1. #1

    GREED's Avatar
    Join Date
    Mar 2008
    Location
    Portsmouth
    Posts
    3,289
    Thank Post
    406
    Thanked 418 Times in 338 Posts
    Blog Entries
    8
    Rep Power
    191

    Just a little tired but...

    I was helping out with a school to get them a backup SIMS server (I say server, it was running windows XP) so they had something to test with, play around with and, if all else fails, a temporary backup server.

    Been working most of yesterday on it, all installed but could not connect to the database. SIMS workstation all installed, using SQL express 2005, all updated fine and to the full, blank database installed to SQL. Connect.ini all fine and dandy.

    All I keep getting is, for the sysman username (password is the usual), is Username/Password incorrect or the likes. Just cannot get in.

    Hoping a fresh pair of eyes might help out! Very embarrassed as have done this a dozen times before!

  2. #2
    DMcCoy's Avatar
    Join Date
    Oct 2005
    Location
    Isle of Wight
    Posts
    3,505
    Thank Post
    10
    Thanked 508 Times in 445 Posts
    Rep Power
    116
    Added a firewall exception for sql port? Also, should it not be sql 2008 now?

  3. #3
    Sarconia's Avatar
    Join Date
    Mar 2010
    Location
    London
    Posts
    315
    Thank Post
    15
    Thanked 34 Times in 31 Posts
    Rep Power
    16
    I'd also check the .net framework installed on the machine as well as checking to see if any other users are connected to that machine externally as I know there is quite a low limit (I think 10? users) to the amount of external connections which can connect to any Windows XP machine.

    It's probably also worth running the usual utilities..

    exec sims.db_p_install
    exec sims.db_p_grant
    exec sims.db_p_reset_sysman_password

  4. #4

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,956
    Thank Post
    775
    Thanked 1,487 Times in 1,234 Posts
    Rep Power
    367
    That can happen if on wrong SQL. I've seen similar post migration when the connect points to the old 2005.
    Where is your blank from?
    In the good old days my friend Graham solved this for me with a detach + drop logins then reattach. I'll look up the help docs if you want

  5. #5

    GREED's Avatar
    Join Date
    Mar 2008
    Location
    Portsmouth
    Posts
    3,289
    Thank Post
    406
    Thanked 418 Times in 338 Posts
    Blog Entries
    8
    Rep Power
    191
    Quote Originally Posted by vikpaw View Post
    That can happen if on wrong SQL. I've seen similar post migration when the connect points to the old 2005.
    Where is your blank from?
    In the good old days my friend Graham solved this for me with a detach + drop logins then reattach. I'll look up the help docs if you want
    hahaha, awesome. I hear he is a really great guy, and dashing too! :P

    I tried all that, but I think wrong SQL is the key. I don't know why I was working with SQL 2005 (other than the fact it was preinstalled on the machine for me). the blank referred to is the newblankdatabase.mdf that gets installed as a new install. My guys wanted to have a play with setting up new school structures and the likes, and so am avoiding copying their existing database over just yet.

  6. #6

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,956
    Thank Post
    775
    Thanked 1,487 Times in 1,234 Posts
    Rep Power
    367
    What i was thinking was if you installed it from old installables, then it should work fine on 2005. Not sure what table changes occur in the migration.

  7. Thanks to vikpaw from:

    GREED (7th February 2011)

  8. #7

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,956
    Thank Post
    775
    Thanked 1,487 Times in 1,234 Posts
    Rep Power
    367
    Quote Originally Posted by GREED View Post
    hahaha, awesome. I hear he is a really great guy, and dashing too! :P
    Check your sources. Not sure about dashing, there may have been a hint of panache; but don't quote me on that!

  9. #8

    GREED's Avatar
    Join Date
    Mar 2008
    Location
    Portsmouth
    Posts
    3,289
    Thank Post
    406
    Thanked 418 Times in 338 Posts
    Blog Entries
    8
    Rep Power
    191
    Quote Originally Posted by vikpaw View Post
    Check your sources. Not sure about dashing, there may have been a hint of panache; but don't quote me on that!
    Depends who you ask, I can go from cool and patient to hot headed and stressful within 2 desk-lengths! lol

    Thanks for the talk-through, always helps to have confirmation of an idea!



SHARE:
+ Post New Thread

Similar Threads

  1. Tired!!
    By DSapseid in forum General Chat
    Replies: 11
    Last Post: 12th February 2009, 11:41 PM
  2. you know you're tired when...
    By contink in forum General Chat
    Replies: 10
    Last Post: 6th March 2008, 05:57 PM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Posting Permissions

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