Need Help Setting Up Sql Server

AMDSIGMA · Post by **AMDSIGMA** » Sat May 28, 2005 10:38 pm

Hey guys, dont know if some of you remember me, but i am from HB-ZioN, used to be part of HBX. Im trying to see if i can put up a server with these SQL files, ive used Binary's Info and i seem to be making some progress. When i Click on the Blue Check to check the WS1.sql file it gives me an error message:
Server: Msg 911, Level 16, State 1, Line 2
Could not locate entry in sysdatabases for database 'ws1'. No entry found with that name. Make sure that the name is entered correctly.

Thats also with the other file.

Then, i configured the ODBC and stuff. When i try to open the MainLserver, it says INT FAIL or something like that. Can anyone give me any recommendations or thoughts of what i did wrong?

molo · Post by **molo** » Mon May 30, 2005 2:01 pm

AMDSIGMA wrote: Hey guys, dont know if some of you remember me, but i am from HB-ZioN, used to be part of HBX. Im trying to see if i can put up a server with these SQL files, ive used Binary's Info and i seem to be making some progress. When i Click on the Blue Check to check the WS1.sql file it gives me an error message:
Server: Msg 911, Level 16, State 1, Line 2
Could not locate entry in sysdatabases for database 'ws1'. No entry found with that name. Make sure that the name is entered correctly.

Thats also with the other file.

Then, i configured the ODBC and stuff. When i try to open the MainLserver, it says INT FAIL or something like that. Can anyone give me any recommendations or thoughts of what i did wrong?

yeah...
i have same problem too but i dont think any one going tohelp us

asdfd · Post by **asdfd** » Mon May 30, 2005 3:26 pm

Yea, I got the same problem, I didnt use the crack for cdwriters guide.. because there is no dl.. could this be the problem? When it says to click the blue checkmark after opening ws1 i get the same msg.. someone help us noobs xD

asdfd · Post by **asdfd** » Mon May 30, 2005 3:28 pm

BTW: to those wondering, we're using SQLEVAL and we're getting stuck at the start of the guide..

4. After all above is done lets open the MSsql Enterprise Manager, This is assuming u started the Mssql from control panel/Administrative tools/Services. If not go there now and open up services looking for Mssql and start it .. Now goto Tools / SQL Query Analyzer above when the Windows opens make sure master is set - top middle of the window -, Now click on the Open folder and browse to your 361HB directory inside the folder called SQLsetupFiles click on Nicksws1.sql when it opens click the Blue check mark or (Ctrl+F5) u should get a (The command(s) completed successfully.) in the results list. Now click Run green arrow next to the Blue check mark or press f5 it should finish completed. after this hit the save command and open the next file called Nicksmainlog.sql and do the exact same thing. MSSQL Bases COMPLETE.

holpp
EDIT:

2. Next we need to setup MSsql db witch i have included here with the reg crack..first run SQLEVAL.exe and place the files in a directory somewhere does not matter where or witch Drive.. after this goto where u extraced the files and hit the autorun.exe and install MSsql DB to your c:\program files\.....Make sure when installing u use MIXED Mode. Add a password and make sure u write that down. then open SQL Crack.zip and copy the crack file to where u installed MSsql DB , mine is C:\Program Files\Microsoft SQL Server\MSSQL\Binn place the crack here and Crack the MSsql DB.

I guess maybe it's because we haven't cracked the database? <_< Does anyone have the crack for this? I got all the files cleaned up and put together finally and went through posts all night getting rdy to do this.. so the database is all thats holding be back

jmh · Post by **jmh** » Mon May 30, 2005 3:36 pm

dont worry about the error, just hit ctrl+f5 then click the blue check and your done.

sigma message me on msn and ill help you, pimpn4candy@hotmail.com

asdfd · Post by **asdfd** » Mon May 30, 2005 3:37 pm

We get the error after we press ctrl f5/ bluecheck

jmh · Post by **jmh** » Mon May 30, 2005 3:39 pm

i think everyone gets that error, go check and see if the tables where setup.

asdfd · Post by **asdfd** » Mon May 30, 2005 3:40 pm

EDITED: I got it fixed.. I just reinstalled everything and followed exact instructions without screwing around. More problems to come

Stik · Post by **Stik** » Mon May 30, 2005 6:29 pm

Yep that error is teling you that the database was not already on the server.
If in doubt press F5 a second time to execute the query and there wont be an error