SQL 2000 Help

[IceSlice]

Ok downloaded SQL 2000, iv been following this guide...

http://www.lomcn.co.uk/forum/showthread.php?t=54617&highlight=SQL+2000

Done all the first bit... then i get to this part...

"Once downloaded, install SQL Server 2000 by setting the system to "local" and the authentication mode to "mixed" and set a "sa" password."

Whats its mean by that.... how do i set what to local.

Heres a pic..

I need to know which one to start. I tried autorun btw the first time.

Oh and err im new to 2.3 so sorry.

 

[jewjewbee]

Try double clicking setup. That will start the install process.

 

[God33344]

in that screenie u see the one called auto run? click that and u will get a box that will bring up options of wutu wanna make , click the database and it will start the install process

 

[IceSlice]

Ok don that get to this part...

"Now go to Enterprise Manager>Local>Databases
Here you will find that there are already a few default databases. Right click and create a new database called "mir2"

Then right click on this new database and go to All Tasks>Restore Database
Here select the option of "From Device" and then select the location of the database which in this case is /DBServer/lom2restorethis In this case the DB provided is already in the *.bak format and hence need not be force restored. If it aint, then go to the second tab and tick the option - force restore and then click OK."


This is what it looks like so far.





i click ok and i get this...




anyoen help. yes i have tried different ways.

 

[jasper]

if your using the 2.3 files all in one, in the release section you need to restore the backup for sql2000 not sql2005

oneof them is called restore this, the other has 2000 in its title

 

[IceSlice]

let's make love ?


lol, thanks mate.

EDIT

Got it all done, just i get these errors on M2 ...





and DB...





cheers for help guys all appreciated.

 

[jasper]

in !setup and the dbsrv.ini you need to change the settings for the server to connect to sql looking at first post your db is called mir 2, not lom2 as im guessing it still says in those files.


erm, and im not sure your my type