[Help] SQL 2005

Results 1 to 3 of 3
  1. #1
    Alpha Member Maxim.T is offline
    MemberRank
    Nov 2006 Join Date
    RussiaLocation
    1,834Posts

    [Help] SQL 2005

    Huh , i need some help over here... i have some problems on installing Database on SQL 2005 ... i mean i restored it , all good but DataServer & others can find or access it ? Could someone help me afap ( i mean as fast as possible) ?


  2. #2
    Alpha Member Maxim.T is offline
    MemberRank
    Nov 2006 Join Date
    RussiaLocation
    1,834Posts

    Re: [Help]SQL 2005

    Please ! I need help T_T

  3. #3
    Kingdom of Shadows [RCZ]ShadowKing is offline
    MemberRank
    Jul 2007 Join Date
    1,644Posts

    Re: [Help]SQL 2005

    ds and others can or cant access the database?You must use a version compatible or modified for mssql 2005 as luciano`s server files or SCF files and you need a special ODBC.reg.The mssql 2005 use another value,here is it:

    Windows Registry Editor Version 5.00

    [HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI]

    [HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\MU2003_EVENT_DB]
    "Driver"="C:\\WINDOWS\\System32\\SQLNCLI.dll "
    "Server"="(local)"
    "Database"="MU2003_EVENT_DATA"
    "LastUser"="sa"
    "Trusted_Connection"="Yes"

    [HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\RANKING_DATA]
    "Driver"="C:\\WINDOWS\\System32\\SQLNCLI.dll "
    "Server"="(local)"
    "Database"="Ranking"
    "LastUser"="sa"
    "Trusted_Connection"="Yes"

    [HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\MuOnline]
    "Driver"="C:\\WINDOWS\\System32\\SQLNCLI.dll "
    "Server"="(local)"
    "Database"="MuOnline"
    "LastUser"="sa"
    "Trusted_Connection"="Yes"

    [HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\MuOnlineJoinDB]
    "Driver"="C:\\WINDOWS\\System32\\SQLNCLI.dll "
    "Server"="(local)"
    "Database"="Me_MuOnline"
    "LastUser"="sa"
    "Trusted_Connection"="Yes"

    [HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\UseLog]
    "Driver"="C:\\WINDOWS\\System32\\SQLNCLI.dll "
    "Server"="(local)"
    "Database"="MuLog"
    "LastUser"="sa"
    "Trusted_Connection"="Yes"

    [HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\ODBC Data Sources]
    "MU2003_EVENT_DB"="SQL Server"
    "MuOnlineJoinDB"="SQL Server"
    "RANKING_DATA"="SQL Server"
    "MuOnline"="SQL Server"
    "UseLog"="SQL Server"

    [HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\ODBC File DSN]
    "DefaultDSNDir"="C:\\Program Files\\Common Files\\ODBC\\Data Sources"
    if you dont use UseLog or MuOnlineJoin or Me_MuOnline you can remove them from the script.



Advertisement