Go To Databases -> "account, billing, cash, character" -> Right Click -> Properties -> Permission Click All Of Them On User "account" *If You Get An Error "User "account" Already Existed" Then Go To "account, billing, cash, character" -> Users And Delete The User "account" That Should Be There. In Permit In Database Role Click On "db_owner" For Each Of The 4 Databases -> Click OK Go To Tab Database Access -> Click On Database "account, billing, cash, character" Use "account" As Password -> Choose "master" As Default Database Put Name "account" -> Click Dot In SQL Server Authentication Go To Security -> Login -> Right Click -> New Login Console Root -> Microsoft SQL Servers -> SQL server Group -> Press OK To Import The Database (Do This For All 4 Databases) Make Sure The Path Of The MDF And LDF Files Is Set To "C:\" (Example: C:\account.ldf) Click Dot In "Force Restore Over Existing Database" Press OK 2 Times To Continue, And Then Press The Options Tab Click Add And Then Choose The Destination Of The Backups To Restore Into SQL Click On "From Device" And Then Click On "Select Devices" After That, Right Click On "account" Database -> All Tasks -> Restore Database Create A New Database, Name It "account" (Do This Again For "billing", "cash", And "character") Click Dot In Use SQL Server Authentication -> Login Name (That You Gave At The Install) -> Leave Pass Empty -> Click Dot In Always Prompt For Login Name And Password *Then Add The Login And Pass That You Gave At The Install And Go To Databases Right Click (local) (windows) -> Edit SQL Server Registration Properties Open Enterprise Manager (Start -> Programs -> Microsoft SQL Server -> Enterprise Manager) When Installed Restart PC So Server Starts When Install Is Done Run SQL 2000 Service Pack 4 Installer (Not Making Guide On How To Install, Its Straight Forward) Click Dot In "Mixed Mode.” Enter Password And Confirm Password Remember It, Username Is ALWAYS "sa" (Server Admin) Click Dot In "Use The Local System Account" Click Next Click Dot In "Use The Same Account For Each Service. Click Dot In Default At Top And Click Next Click Dot In Server And Client Tools And Click Next Click Dot In "Create A New Instance of SQL Server, Or Install Client Tools"
0 Comments
Leave a Reply. |