MSSQL Server

[tkoh]

So far ive struggled but got running vm with CentOs and the server runs on it

problem is i cant properly configure the database so it connects or w/e it needs to do with the cabal server

http://forum.ragezone.com/f460/how-t...xpress-431889/
tried this but i still cant figure it out

is there an extended tutorial about configuring and
linking the database with the cabal server on CentOS

v-v i know im close but i never did databases (mysql and php for sites only)
i dont want to give up yet. :

[MentaL]

[striker1010]

If you are having trouble I would say use SQL 2000, its the best way to go with. I tried with 2005, got so many different issues so I went with 2000 plus there are a heck of a lot more guides on 2000 and even video tutorials.

[chumpywumpy]

2005 is actually very easy too but the things that people miss is that a default install os 2005 express won't work as it both installs as a named instance and also has remote connections disabled.

I actually started with 2005 express and only went back to 2000 to maintain database compatibility. I can keep the dbs in 2005 using 2000 compatibility mode but i can guarantee i'll accidentally convert them to 2005 format and end up giving them to people. Given the choice i would actually rather run 2005.

[tkoh]

a few questions that are kinda dumb but id like answered

are there sample databases? (link to a SQL05 compatible one with centos then)
is there another way to avoid using SQL on Windows?

how to set all that stuff too...<_<

i wish chumpy would make a video tutorial, his 2.0 set up one was great aid (even though i did it differently)

[chumpywumpy]

The sample databases are the cabal ones. Other databases would be useless for testing as Cabal wouldn't be able to do anything with it. There are sample databases for working with SQL and the ones used on the official MSSQL courses are called AdventureWorks and Outlander, both are a free download if you google them.

There is no way of avoiding using Windows as MSSQL won't run on linux even through things like WINE. Other db types won't work either.

The reason i didn't do a video tutorial is because when we had nothing but video tutorials people used to complain a lot that either the text was too small/fuzzy to read, people didn't use pause and it was just a nightmare. On top of that video guides are much bigger and creating a really good one takes far longer. I started with guides in posts to get around this but ran into the forum limit on how many images i could use and eventually went for PDFs.