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
when i run my project of .net
this is error what i get all the time …
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)
what to do guys??
how to outo backup data in sql 2008R2
Nice Artical.Helps a lot.God bless you. :-)
i installed SQLserver 2008 with instance name SQLEXPRESS. But after connecting to a small db named DB20032013, it is showing error when i execute below query.
select * from mas_user.
but when i changed that to
select * from DB20032013.mas_user i got result
can you tell me why?
Very nice document, suggestion : should have little explanation at the bottom of each if there are option if any one can consider
This is the most helpful for any SQL Server 2008 Installation and is 100% sure this is correct
Thnks man, u really helped me alot
wait it is instaliing
thanks .this really helped me.yes it has installed
i just renamed the file in regedit and that worked.
olny problem was showing for windows powershell installation.
nice page.thanks
Is it the same way when installing in windows 8.1 ?
thanks for help
Sir It Help me But there is no server name in Sql ….
SQL installation error “attempted to perform an unauthorized operation”
Hi
I want to install SQL Server 2008 in win8
but disply the fallowing errror:
SQL Server Setup failure:
“the system cannot open the device or file specified “
problem solved install vb 2008 error mysql in windows 8.1 SLn:( help.
i have windows 8 64-bit on my system, i installed sql server 2008 it installed successfully, but now i’m unable to open server management studio, it is showing error like “provider:named pipes provider, error:40- could not open a connection to sql server microsoft sql
server, error:2” and in configuration manager there is nothing under “sql server services and sql server network configuration”kindly help me to fix this problem
heyyy Pinal it`s become so easy through this images
Thanks …
Whenever doing installation of SQL server 2008 in my windows PC it encounters an error “Couldn’t find file ‘C:\Users\Administrator\AppData\Local\Temp\2\frlnw8gq.dll.”
Please suggest what to do and where I” can get this file???
I can make a guess that this file came from SQL media because the file names are obfuscated on media. Where did you get media from? Did you download ISO and extract it? What was the software used for extraction?
You can try choosing different software for media extraction or post on MSDN forums to get more help.
Good day,Please after installing sql server 2008..its showing me failed to load or not connected to server
What is the exact error you are getting?
Such A Useful Post…………….Nice One
Hello,
When trying to install Sql server 2008 on my windows server 2012 , I get the following error:
SQL Server 2008 R2 setup100.exe and setuppatch.exe cannot be run in this mode. If you are running setup100.exe, start setup.exe instead. If you are running setuppatch.exe, run it from the command prompt, as the user interface is not supported for this action.
Error Code : 0*84B20001
@Tarun – Which is the exe you are running?
setup100.exe in the x64 folder.
@Tarun,
You are suppose to run setup.exe from the root. The exe which you are running would be called automatically. Error message also says same thing.