[Guide] Setup for SQL Server 2008(32&64bit)

[KaliKid]

I decided to make a quick little guide for setting up SQLExpress 2008 following my last guide, seeing as there is no support for this on the forums already. This will cover installation and configuration for MSSQL2008 for 32 and 64bit. Windows 7 64bit Windows XP 32bit were tested for this.

First you will need 2 things:
1) (if you don't already have it installed)
2)
*If you want detailed instructions or visual demonstrations you can use my or .

Installation
This will be a brief guide to installation as it's essentially the same as MSSQL 2k5

1) Run the setup for MSSQL Server 2008
2) Instance Name screen – Change Named Instance to Default Instance and click Next.
3) Registration Information screen - Uncheck Hide advanced config options.
4) Feature Selection screen – Enable everything to install and click Next.
5) Authentication Mode screen – Select Mixed Mode and enter your User name and password(i.e. “Shaiya” and “Shaiya123”)
6) Configuration Option screen – Check “Add user to SQL Server Admin Role” and uncheck “Enable User Instances” and click next.
7) At Setup Programs screen make sure everything is green checked and finish installation.
*Any other pages you come across leave alone and continue installing.

Configuration

1) Start\All Programs\Microsoft SQL Server 2008\Configuration Tools\SQL Server Configuration Manager
2) SQL Server Network Configuration. Click Protocols for SQLEXPRESS and Enable everything on the right side of the screen.
3) Right click TCP/IP, in the TCP/IP Properties window click the IP Addresses tab. Make sure Active is Yes and Enabled is Yes. Set your IP address to 127.0.0.1 and click Apply and OK.
4) SQL Native Client 10.0 Configuration(if you are running a 64bit OS and installed SQL 2k8 64bit you will get two options for this => 32bit and 64 which is not labeled, make changes to both). Click Client Protocols and Enable everything on the right side of the screen.

Remote Access

1)In SQL Server Configuration Manager select SQL Server Services.
2)SQL Server(SQLEXPRESS) needs to be Running and the Start Mode should be Automatic. If not, right click SQL Server(SQLEXPRESS) and select Properties. In the Properties window, select the Service Tab. Select Start Mode and change it to Automatic, then click Apply and OK. Right click SQL Server(SQLExpress) again and select Start.
3)SQL Server Browser also needs to be Running and set to Automatic. Follow the same instructions as 2nd Step to get it running.
*Note: Enabling these two services may require you to restart before they can run properly.

When everything has been done, close SQL Server Configuration Manager and Restart for it to take effect. Installing Management Studio 2k8 is self explanatory. Run it to make sure your log in works using Windows Authentication.

[[ADM]Destroyer]

Maybe Add Some SS would be great to understand.

[JohnHeatz]

That is not going to happen, check on the date of the thread, as well as on the last activity registered for the account.

[Cosmin6294]

i have a problem with SQL 2008 R2 , when i try open table i have this error ==> Ms visual database tools
how i can fix this error?

[Autrux]

#moved

[Shaiya Galaxy]

t

[[DEV]Wandersson]

TRASH YOU NEED TO TAKE SS