Setting up sql2005 express

First of all, this guide is for users who would like to experience the beauty of sql2005 express edition(not the trial,trial sucks) and for those who experience problems in sql2000...

This is tested on winxp sp2...

Step 1:Download

SQLEXPR.exe here
sqlserver2005_SSMSEE.exehere

U need this two files...its total of 93.3mb...just short...

Step 2:Installing SQL express


1.From the autorun dialog, click Run the SQL Server Installation Wizard.

2.On the End User License Agreement page, read the license agreement, and then select the check box to accept the licensing terms and conditions. Accepting the license agreement activates the Next button. To continue, click Next. To end Setup, click Cancel.

3.On the SQL Server Component Update page, Setup installs software required for SQL Server 2005. For more information about component requirements, click the Help button at the bottom of the page. To begin the component update process, click Install. To continue after the update completes, click Finish.

4.On the Welcome page of the SQL Server Installation Wizard, click Next to continue.

5.On the System Configuration Check (SCC) page, the installation computer is scanned for conditions that may block Setup. For information about configuration check items, click Help at the bottom of the page or see Check Parameters for the System Configuration Checker. To interrupt the scan, click Stop. To display a list of check items grouped by result, click the Filter button and then select a category from the drop-down list. To view a report of SCC results, click the Report button and then select an option from the drop-down list. Options include viewing the report, saving the report to a file, copying the report to the Clipboard, and sending the report as e-mail. To proceed with Setup after the SCC scan completes, click Continue.

6.On the Registration Information page, enter information in the Name and Company text boxes. To continue, click Next.

7.On the Components to Install page, select the components for your installation. A description for each component group appears in the Components to be Installed pane when you select it. You can select any combination of check boxes. When you select SQL Server or Analysis Services, if Setup detects that you are installing to a virtual server, the Install as a Virtual Server check box is enabled.

*To install individual components, click Advanced. Otherwise, click Next to continue.

8.If you clicked Advanced on the previous page, the Feature Selection page is displayed. On the Feature Selection page, select the program features to install using the drop-down boxes. To install components to a custom directory, select the feature and then click Browse. For more information about the functionality of this page, click Help. To continue when your feature selections are complete, click Next.

9.On the Instance Name page, select default instance for installation. If a default or named instance is already installed, and you select the existing instance for your installation, Setup upgrades it and provides you the option to install additional components. To install a new default instance, there must not be a default instance on the computer. To install a new named instance, click Named Instance and then type a unique instance name in the space provided.

10.On the Service Account page, check use local system account for SQL Server service accounts. You can use one account for all of the services.

11.Optionally, you can specify an individual account for each service. To specify an individual account for each service, select Customize for each service account, select a service name from the drop-down box, and then provide login credentials for the service. To proceed, click Next.

12.If you selected Reporting Services as a feature to install, the Report Server Installation Options page is displayed. Use the radio buttons to select whether to configure the report server with default values. If the requirements for installing Reporting Services in the default configuration are not satisfied, you must choose the Install but do not configure the server installation option. To view installation details for this page, click the Details button. For more information, click Help at the bottom of the page. To proceed, click Next.

13.On the Error Reporting page, optionally clear the check box to disable error reporting. For more information about error reporting functionality, click Help at the bottom of the page. To proceed, click Next.

14.On the Ready to Install page, review the summary of features and components for your SQL Server installation. To proceed, click Install.

15.On the Installation Progress page, you can monitor installation progress as Setup proceeds. To view the log file for a component during installation, click the product or status name on the Installation Progress page.

16.On the Completing the Microsoft SQL Server Installation Wizard page, you can view the Setup summary log by clicking the link provided on this page. To exit the SQL Server Installation Wizard, click Finish.

*If you are instructed to restart the computer, do so now. It is important to read the message from the Setup program when you are done with installation. Failure to restart the computer may cause failures when you run the Setup program in the future.

Step 3: Installing SQL server management studio express

Run SQL_SSMSEE setup and click next 3 times.
CLICK install.. then follow what is said.....just like in sql2000...

Step 4: Creating and restoring database...

go to START>All programs>microsoft sql server 2005>sql server management studio express CTP.

Put ur sa and password...

then right click databases and select create new database.....create MuOnline and Ranking..then click OK... for restoring, right click to MuOnline/Ranking select tasks>restore>database...select from devices and browse for the backup files...then on options tab, select overwrite existing databases and check the file names to restore.....

Step 5:Creating a server

Read guides on how to create a server...BUT! for the ODBC.reg use this:

THATS IT!

Thanks a lot

that with complete tools? with jobs and import?

nice thanks

great thx ^^

is there any guides on how to make mu server in sql2005 with screenies?

thx..

Reeeeeaaaaally nice, tnx ^^

Very Thanks Man! GOOOD POST!

how about ODBC,there is some errors and server will not work.
Why im not using the 2k backs and something? Becose the 2k backs in frienzmu files is so buged... heh,i need a help,somebody?

Express SQL 2005 need install in to a 2k SQL? ore need delete the 2k?

by sql server 2000 you first have to start the server up with anylizer or something
(little program where you ahve press the play button)
you have to do that with sql server 2005? and what is the name of it ?

Thanks ..

eh need img :)

need IMG or video plz

hmz
Step 5:Creating a server

Read guides on how to create a server...BUT! for the ODBC.reg use this:

i cant saw that specifed files ... can you upload it .. ;(

I can't start my server. Dataserver error's (3 :P):
sql3.PNG | Fotki, Zdjêcia, Obrazki Fotosik.pl
sql2.PNG | Fotki, Zdjêcia, Obrazki Fotosik.pl
sql1.PNG | Fotki, Zdjêcia, Obrazki Fotosik.pl

ODBC Don't work ;/

Need help.

yes but i can connect on the sql and i change the password on user: sa i put 13579 and no work ... :( can help me please ?

You need to setup your server into mixed mode

SQL 2005 Express has a problem with MuEditor's. You need to setup your SQL correctly or they will not work, and remember to enable several protocols: Named Pieps, TCP/IP...

Connection with SQL Server With Odbc failed!
Please check if odbc MuOnline exist or db user and password are okey.

I get this problem all the time when i example try to enter web.

Quote:

---

Originally Posted by heptameron07

You need to setup your server into mixed mode

---

WTF dude look at the question when it has been posted .. omfg.. don't bump old threads!!!!

@muisbest : idem

by the way don't use 2005.. it sucks... use 2000 , much better

Quote:

---

Originally Posted by Nocturnal

that with complete tools? with jobs and import?

---

wooo!!!
boss noc is here!!!
PROUD ZHYPERIAN HERE!!!



anyweiz,
my real reason for posting here is this...
could you just tell us which ones to click?
like "next"
rather than "if you think you are done... blah blah blah... click next"
i'm sorry if i sound kinda aggressive...
i'm just a bit frustrated cuz i've been trying to put up my server for a LONG time...
and i've never succeeded...
anyweiz i think that would be easier to understand...

I have problems with named pipes and something about that sql server does not allow remote connections.

When installing i get auto restart then when it restarted it just restarting itself im Windows XP Prof Service Pack 2

can some an help me pelase!
how can i make a account for:
SQL Server Management Studio Express 2005
how can i make a login?
and how to puse in my server name help me!
send an email to: marvincod1@hotmail.com
or typ here! pelase help me

I love beating dead horses...

Great guide you made great things possible!

I have been messing around with all sorts of things, and got SQL Express 2008 to run an mu server, don't ask for help, jsut trust me... but the ONLY error I get is one from the client which is a universal "wrong account name or password" and the JS gives me an error which I can't read fully, refer to http://forum.ragezone.com/f193/your-...is-mic-636249/ For more information on my troubles.

SQL2005 is great and hustle free.... I'm running MU and ran server with same PC..

nice guide :)

i know this is an old thread but i am currently using

this on my win 2003 sp2, i am having troubles

with my connection from the SERVER it seems

that it can't connect on the SQL 2005 server :-?

but i completely did what this guide said ,, :-?

any more GUIDE to make this work on win 2003 sp2 ?

I am having problems installing this sql2005 on my winxp sp2. It stops at the middle of the installation, then restarts the computer infinitely.

freshly installed windows? did you see any sexy error messages? you have Micro$oft .NET framework 3.5 or over installed? also before reinstalling it remove all its data directories before try again
also do not download sql2005 from any other place than Micro$oft website(guess why :D)

ask me in YM when you wake up as i have installed it alot times and got similar problems aswell

can anyone post a link here where i can make an private MU Server using SQL 2005? thanks....

Get the designated SQL 2005 For SPX . Like SQL 2005 SP3 .

Is this compatible in window 7 32bit? or someone tell me a link tutorial on how to run Mu server in window 7 32bit?

I think it is ^^

can you give us link for win2003 x64? x86 doesn't work on my OS :( thank you

Rock on!

thank;s i'm looking for it :D