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
thanks for the guidance and support
Thanx for the help :)
your welcome priyeshrawat!
is it possible to add local option without reinstalling?
I WANT TO INSTALL SQL SERVER 2008. I NEED TO GUIDE HOW TO I INSTALL THAT ONE PLS ANYONE CAN HELP ME
Good one
Thank you…
Very helpful. Thanks
Please give me the link to download the file
Also while installing the SSMS i didn’t able to server Configuration. I am not able to find SQL server Agent. Please help on this
thanks for the guidance and support
Thank you very much Pinal. I have installed using the above steps however I am getting this error when I try to login giving [computerNamesqlexpress] in Server name field. Can you please suggest to avoid this error.
A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 – Error Locating Server/Instance Specified) (Microsoft SQL Server, Error: -1)
Thank you very much.