GREED Posted February 6, 2011 Posted February 6, 2011 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!
DMcCoy Posted February 6, 2011 Posted February 6, 2011 Added a firewall exception for sql port? Also, should it not be sql 2008 now?
Sarconia Posted February 6, 2011 Posted February 6, 2011 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
vikpaw Posted February 7, 2011 Posted February 7, 2011 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
GREED Posted February 7, 2011 Author Posted February 7, 2011 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! 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.
vikpaw Posted February 7, 2011 Posted February 7, 2011 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. 1
vikpaw Posted February 7, 2011 Posted February 7, 2011 hahaha, awesome. I hear he is a really great guy, and dashing too! Check your sources. Not sure about dashing, there may have been a hint of panache; but don't quote me on that!
GREED Posted February 7, 2011 Author Posted February 7, 2011 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!
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now