Microsoft MS-SQL Server 2005 | 2008

[Faronnia]

# Guide

// =============================
# Credits
- Alexandre (me)
- Tyler (MS-SQL 2008)
- Coderz Factory (Original guide)
- Microsoft (Software)

x64 = 64 bit
x86 = 32 bit

// =============================
# MS-SQL Server 2005
# by Microsoft
# Release

The setup and configurations are almost the same as MS-SQL Server 2000. Anyone who can use a computer can easily setup v2005 without any problems. Here is a release of all which you need.

This is an Official Free Public Release from Microsoft. None of this software is pirated.


# Downloads
MS-SQL Server 2005 Express Edition
MS-SQL 2005 Express Agent
MS-SQL Server 2005 Client Tools
MS-SQL Server Shield



- Why Express Edition?
Because the Entreprise Edition is not free! Must pay for it. The express edition works just fine. Give it a try, you will love it.

- How to connect?
Use your local system account. Then use the Agent and the Tools to manage the MS-SQL Server.

- What is MS-SQL Server Shield?
This can be used with v2000 and v2005.
If you have, for example, a website on one host and the SQL Server running on a different host, networks differing from eachother, and your website interacts with the SQL Server lets say by using PHP. This means there is traffic. Data packets being sent. The Server Shield software basically boosts the encryption strenght of these packets, hence assuring more secure operations. You need to activate this with a key, which you purchase online for real money.



I am sure this will come in handy for many of you.
Enjoy it and have a nice day!

Kind regards,
~ Alexandre and the CzF Staff Team


// =============================
# MS-SQL Server 2008
# by Microsoft
# Release

MSSQL 2008 is optimized for servers, rather than desktops, but what is the difference between the authentication? It's the same T-SQL language, and the SQLClient Class works the same with 2005 and 2008.

Requirements
In my use of both MSSQL 2005 and 2008, 2008 is more server ready, and 2005 is more computer ready. What I mean is, the requirements for 2008 are included on a Windows Server 2008 installation, while they're not on Windows XP, Vista or RC7. However, if you do wish to use MSSQL 2008 on your computer, you will need to download the following two items:

Powershell 1.0 (Requires Restart): http://www.microsoft.com/windowsserv.../download.mspx
Note: If you're not sure which one to download, then you shouldn't be installing it.


Windows Installer 4.5 should automatically install when you open the MSSQL 2008 installer, however, should it not you can install it manually.

Windows Installer 4.5: http://www.microsoft.com/downloads/d...displaylang=en
Note: Again, if you're not sure which to download, don't download.

I suggest that you just download and install Windows Installer 4.5 before you install MSSQL, because it's easier.



Installation and Versions
Download here: http://www.microsoft.com/express/sql/download/
There are 4 different installation types. These are as follows:

SQL Server 2008 Express with Tools: This edition is free, and comes with the database engine itself and also contains the visual database studio, much like Navicat or SQLYog for MySQL. I recommend this, as it is basic and comes with the core necessary tools you need.

SQL Server 2008 Express with Advanced Services: This has what the SQL2k8E with Tools has, plus two new features. It allows for Full-Text Search and Reporting Services. This is usually good for a business wanting a report of how many customers they have or other things. Good, if you know how to use Reporting Services in ASP.NET/C#/VB.

SQL Server 2008 (Runtime Only): This is just the database engine, and nothing else. Recommended if you like to use T-SQL to manage your database, which is archaic.

SQL Server 2008 Management Studio Express: This is the management studio standalone. Doesn't contain the database engine at all.

Once you have chosen your edition, download it and install. You should be able to configure the instance yourself. Once you have done so, use the management studio to create databases and create tables etc.

[MentaL]

[RapMu-Admin]

good guide thy

[kNetZz]

how i make an account for SQL 2005 Express Edition

[DarkOur]

i need mu maker for 2005 sql

[Yubinz46]

Erm, after all setup using SQL 2005 express.... I receive this error when opening dataserver. 'GSDB Set Connect Fail '

Erm, please do not tell me to open my ODBC... or whatever... because i have done a test on MySQL 2000, it work perfectly fine, but when i tried to re-setup using MS 2005 instead of 2000, i received this error..

[KREATOR]

Erm, after all setup using SQL 2005 express.... I receive this error when opening dataserver. 'GSDB Set Connect Fail '

Erm, please do not tell me to open my ODBC... or whatever... because i have done a test on MySQL 2000, it work perfectly fine, but when i tried to re-setup using MS 2005 instead of 2000, i received this error..

for sql 2000 you use (local) for ODBC connection.. for sql 2005 use your server's name (the one used when you open the management studio, there is a name selected, use that instead of (local) and doing the ODBC's manually is better )

[DisarmerBR]

How about the MuMaker ?

[KREATOR]

How about the MuMaker ?

unfortunately mu maker doesnt work with the express editions... you have to buy sql either 2005 or 2008 to get mumaker working... If you really want to use mumaker and dont have money just get sql 2000

[RatsU]

How do i get SQL2000 to work with my Vista home premium?? I keep getting error when i'm at the Autorun screen saying compatibility issue.

When i right click on the file to run in Windows XP SP2 mode. I manage to get to a later screen but ended up with a fatal error.

anyone can help? Someone told me to d/l SQL2000 OFC? what does it mean?

[DisarmerBR]

Just leave the incompatibility message and proceed.

[RatsU]

1) Yea, and i get a Fatal error which shuts down the installation.

2) After which i cannot re-install again as it say i have pre-installation failes and need to restart my PC.

3) Then another problem occurs, i restart my computer and Item 2 Repeats again.

[DisarmerBR]

1) Yea, and i get a Fatal error which shuts down the installation.

2) After which i cannot re-install again as it say i have pre-installation failes and need to restart my PC.

3) Then another problem occurs, i restart my computer and Item 2 Repeats again.

Can you post us the error's screenshot ?

[RatsU]

I will do so when i reach home, i have buy parts to set up another computer purely to run independant Server from my main Vista computer. I will install XP on that new computer instead. This should solve my problem.

someone has posted a guide on how to get sql2000 to work with vista by editing the .bat file compatibility. Many thanks to him!

[KREATOR]

I will do so when i reach home, i have buy parts to set up another computer purely to run independant Server from my main Vista computer. I will install XP on that new computer instead. This should solve my problem.

someone has posted a guide on how to get sql2000 to work with vista by editing the .bat file compatibility. Many thanks to him!

I believe you can't install sql 2005/2008 on XP... only 2000 on XP

[DisarmerBR]

unfortunately mu maker doesnt work with the express editions... you have to buy sql either 2005 or 2008 to get mumaker working... If you really want to use mumaker and dont have money just get sql 2000

I got the SQL 2008, it's working perfect. But, i'm still can't use the mumaker. I keep getting the error 40. What's the problem now ?