microsoft sql 2005 <.<

Results 1 to 14 of 14
  1. #1
    Apprentice CA28 is offline
    MemberRank
    Apr 2013 Join Date
    8Posts

    sad microsoft sql 2005 <.<

    yeah i was trying to set up a test server and only thing left to do is attach db but sql2005 i dont know how to do it, tried following the steps from a guide for sql2000..should of been similar but for whatever reason i cant seem to do it on the 2005
    Last edited by CA28; 03-04-13 at 08:57 PM.


  2. #2
    Apprentice CA28 is offline
    MemberRank
    Apr 2013 Join Date
    8Posts

    Re: microsoft sql 2005 <.<

    ok i got it attached and it's in the green but when i go to do the odbc i set it up like it says but it gives me this error........Microsoft SQL Server ODBC Driver Version 03.85.1132

    Running connectivity tests...


    Attempting connection
    [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]SQL Server does not exist or access denied.


    TESTS FAILED!

  3. #3
    Apprentice CA28 is offline
    MemberRank
    Apr 2013 Join Date
    8Posts

    Re: microsoft sql 2005 <.<

    went through all the settings and checked over everything ,it all checks out fine but still no go on odbc.... can someone plz help me ><

  4. #4
    Apprentice Trenton6 is offline
    MemberRank
    Jun 2012 Join Date
    Palominas, ArizLocation
    15Posts

    Re: microsoft sql 2005 <.<

    In the ODBC settings, make sure RMEBrain0 is stored in the system tab as well.

  5. #5
    Apprentice CA28 is offline
    MemberRank
    Apr 2013 Join Date
    8Posts

    Re: microsoft sql 2005 <.<

    i have it just in the system dsn,should i have it elsewhere to?

    i got it runing but when i go to connect with the loader it will load then exit right after it finishes

  6. #6
    Apprentice Xizor is offline
    MemberRank
    Apr 2013 Join Date
    5Posts

    Re: microsoft sql 2005 <.<

    Quote Originally Posted by CA28 View Post
    i have it just in the system dsn,should i have it elsewhere to?

    i got it runing but when i go to connect with the loader it will load then exit right after it finishes
    Add me to MSN, im gonna help u ;)
    DarkDreamm@gmail.com

  7. #7
    Apprentice CA28 is offline
    MemberRank
    Apr 2013 Join Date
    8Posts

    Re: microsoft sql 2005 <.<

    Quote Originally Posted by Xizor View Post
    Add me to MSN, im gonna help u ;)
    DarkDreamm@gmail.com
    you are on my msn :P

    i just cant connect svmapcenter or ipserver i can get 1stmapcenter up and 2nd svrmgr.exe going just fine, when i try svip and svmapcenter i get a socket binfing fail or it says cannot be created .

  8. #8
    Apprentice CA28 is offline
    MemberRank
    Apr 2013 Join Date
    8Posts

    Re: microsoft sql 2005 <.<

    i got it all runing now! just one last problem is when i go to logon into the game it will load then crash right after it, any suggestions on how to fix that?

  9. #9
    Novice wyndcrosser is offline
    MemberRank
    Apr 2013 Join Date
    4Posts

    Re: microsoft sql 2005 <.<

    CA28, are you still having issues? I've got Redmoon 3.8 server working on my Windows 7 machine right now. Are you able to select a login option before it crashes? you might be clicking the button to send you to the redmoon page which doesn't exist.

  10. #10
    Apprentice Jinxer is offline
    MemberRank
    Feb 2013 Join Date
    6Posts

    Re: microsoft sql 2005 <.<

    If I'm reading this correctly, wyndcrosser thinks Windows 7 and SQL 2005 are the same?

    CA28 What mode when setting up local DB did you use? Just because everything install's correctly, doesn't mean it is. If you have no idea what mode is, look inside your error report for SQL. Should give a shout back error.

    (I'm almost positive you did not install correctly)

    isql -E

    Instead of installing this mode, try....

    osql -E

  11. #11
    Novice wyndcrosser is offline
    MemberRank
    Apr 2013 Join Date
    4Posts

    Re: microsoft sql 2005 <.<

    what?!? No. You can use MSSQL on windows 7 to build you server. MSSQL was how we built them back in 2007. I would use that. Why the h would I think SQL and w7 are the same?

  12. #12
    Apprentice CA28 is offline
    MemberRank
    Apr 2013 Join Date
    8Posts

    Re: microsoft sql 2005 <.<

    it was set as mixed mode, i did get the server to launch every map went up fine . it's just the redmoon.exe will load but then crash right after it gets to login screen , could be a runtime error..it did prompt the windows error noise, i checked error log and it said it was cause of that.but what can i do to fix it??

  13. #13
    Member SCDragon is offline
    MemberRank
    Jan 2008 Join Date
    61Posts

    Re: microsoft sql 2005 <.<

    Are you sure client and server match?

  14. #14
    Apprentice fiveshop is offline
    MemberRank
    Dec 2013 Join Date
    21Posts

    Re: microsoft sql 2005 <.<

    My advice,Reinstall sql server,reinstall serverfiles(FRESHinstalleverything) restart all steps BE EXTRA ALERT. i had it up running in no time using win7 32bits with the sql2000, and later will be running win7 64 bit with 2008 r2 edition, its all the same i only think it wont unpack read ISQL no more but ill look that up later.

    PS: i know you dont want to but RESTART everything from 0, theres a minor problem you wont find it I cann tell you, the time it takes to go on forums etc blablablabla is more than 4x a reinstall.

    Repost after a fresh install if you still got problems i try help you out, im real n00b but i had it running in no time, its on for almost 36 Hours and had no problems with connections AT all xept for battle dimension, and a weird socket failure wich is my next problem, there are 20 accounts online ATM by wifi, and tomorrow me and a friend will test the gameplay.



Advertisement