Installing and Configuring SQL Server 2008

Download and Install
Make sure you download the Runtime with Management Tools from the Microsoft Express Edition Site.  This contains all the database engine, database management tools and Management Studio Express. You will need about 1 GB for the install so make sure you have plenty of space.

Configuring port 1433
By default TCP is not enabled on SQL Server. Managment Studio Express talks to the database via memory sharing. To enable listening on port 1433 goto the  "Programs" and select Microsoft SQL Server 2008 -> Configuration Tools -> SQL Server Configuration Manager. Now select SQL Server Configuration -> Protocols for SQLExpress and click on TCP/IP. Now in the Protocol tab set enabled to yes and and in the IP Adresses tab scroll down to IPAll and set the Port to 1433. Now restart the SQL Server (SQLEXPRESS) under SQL Server Services.

Finally open a prompt and telnet to the port. It should connect!

3 comments:

martha said...

I recently came accross your blog and have been reading along. I thought I would leave my first comment. I dont know what to say except that I have enjoyed reading. Nice blog. I will keep visiting this blog very often.


Susan

http://8080proxy.com

tolerance said...

Good article, thanks. Many people have written petition for Puma / Nike shoes act. There are many people over the world protested. Chaussures Sport,tennis rackets,cosplay costumes,ed hardy clothing,Cheap Polo Shirts,The North Face Jackets,cheap ugg boots,tn requin,ed hardy online store,Nike Chaussures Hommes,discount Ugg boots,Chaussures Requin tn

Naviya Nair said...

Very interesting and good Explanation
ASP NET Training
ASP NET Training
ASP NET Online Training
C-Sharp Training
Dot Net Training in Chennai
Online .Net Training


MVC Training
WCF Training
Web-API Training
LINQ Training
Entity Framework
Training

Dot Net Interview Questions