SQL SERVER 2008 has been released for some time and I have got numerous request about how to install SQL Server 2008. I have created this step by step guide Installation Guide. Images are used to explain the process easier.
SQL Server 2008 is a major improvement from SQL Server 2005. Honestly, I still see lots of people still using SQL Server 2000. I would like to say it is time to upgrade and move to the next version of SQL Server. In SQL Server 2000, DBA had to use two different tools to maintain the database as well as the query database, specifically SQL Server Enterprise Manager and SQL Server Query Analyzer. With the release of SQL Server 2005 both of these tools are combined into one tool: SQL Server Management Studio. For a while DBA who were fans of Query Analyzer requested to bring it back, but as they keep on using SQL Server Management Studio (SSMS) they realized that it was much more convenient if every task related to SQL Server could be accomplished using SSMS. With the release of SQL Server 2008 Microsoft has upgraded SSMS with many new features as well as added tons of new functionalities requested by DBAs for long time.
Reference : Pinal Dave (https://blog.sqlauthority.com)
402 Comments. Leave new
it was nyc it helped me a lot
thanks @Satish. I am glad that it helped you.
nice effort..but how someone can understand the cause of any problem without any description?
I didn’t get your question @Ammar
hello sir, my name is Anji Reddy. tell me In real time how to get data in ssis,ssrs,ssas projects.
Hi Anji Reddy – You need to have a data source to get the data.
yes
Then you can use SQL provider and provide data source details in connection string.
sir when i was register database with i was found like that
TITLE: New Server Registration
——————————
Testing the registered server failed. Verify the server name, login credentials, and database, and then click Test again.
——————————
ADDITIONAL INFORMATION:
A connection was successfully established with the server, but then an error occurred during the login process. (provider: Shared Memory Provider, error: 0 – No process is on the other end of the pipe.) (Microsoft SQL Server, Error: 233)
For help, click:
——————————
BUTTONS:
OK
——————————
whats wrong with my sql server?
thank you and sorry for bad english
regards
Error message says that SQL was not able to connect to SQL. Could be because of various reasons. Service not running, port blocked
You should check Errorlog also.
hi , i have installed SQL 2008 but it is showing Sql sever managment studio 2008 in program list…pls help me..
Guys after installation perfectly SQL Server 2008 always view program list ….
great helpful to me… :) :) :)
please write the short step to install SQL server 2008
I have windows7 64 bit OS on my system. I hv installed sql server 2008 successfully on my system bt at the time of using and opening sql sever 2008 application via all programs menu; i dont get right option as u hv mentioned in ur doc… plz help to findout the issue
i need a download link for sql server 2008.Please share.
i have installed sql server 2008 but a network related or instance specific error occured……
what kind of Sql server that suitable for win7 x64 pro? i tried to installed sql server 2012 sp1, the “database engine services” always failed. could u please gimme a hand?
hello
i can folllow this steps
but i can’t connect live server using IP i can start tcp ip on network configuration
but i can not show any service on server configuration on select sql server service
and how can i install this services???
Thank you so much it is really helpful
Thanks @Ramesh
Thank you very much it was a great help
really appreciate your efforts
Regards from Egypt
Thanks @Hamada
Thank its very usefull while installing i had an error at the time of server configuration the error is invalid credentials in SQL server agent and SQL server analysis service
@Yoga – what was the exact error? Did you find solution?
Hi, I need to download SQL Server (along with Management Studio) on my PC for practising. I ended up downloading some Express Version and I couldn’t find Management Studio in it. Can you please suggest me which version is to be installed and how to?
Thanks in advance!
Hi, if we face any error while installing the sql server setup and in the same time it showing some error so where i can check the complete error message , what is the location of error log.
hi sir ,nice this help full .
Excellent