Getting error While connection

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

Getting error While connection

Author

Topic

neeraj.shukla
Starting Member

3 Posts

Posted - 2011-01-09 : 21:42:19

Hi i Installed sql server 2005 in my system. operating system is window xp sp2. its not getting connected. i checked all the solution but when i am tring to open sql server surface area configuration then i am getting error as "No SQL Server 2005 components were found on the specified computer. Either no components are installed, or you are not an administrator on this computer."

Please try to help me..
Thanks in Advance

Neeraj Shukla

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2011-01-09 : 22:43:50

What edition did you install?

By the way, it sounds like the engine didn't get installed. XP has limited engine possibilities, such as Express or Developer editions.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

Lumbago
Norsk Yak Master

3271 Posts

Posted - 2011-01-10 : 04:05:55

Can you open up the services (click Run and then type "services.msc") on your xp-machine and see if you find any sql server services? If you don't then there is no database engine that you can connect to... if there is then post the name of the service here.

- Lumbago

My blog (yes, I have a blog now! just not that much content yet)
-> www.thefirstsql.com

neeraj.shukla
Starting Member

3 Posts

Posted - 2011-01-10 : 20:59:41

Hi installed expressed edition..and i think database engin has not been installed. what is the procedure for it?

Thanks for reply.
Neeraj

quote:
Originally posted by tkizer

What edition did you install?

By the way, it sounds like the engine didn't get installed. XP has limited engine possibilities, such as Express or Developer editions.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

neeraj.shukla
Starting Member

3 Posts

Posted - 2011-01-10 : 21:16:32

Hi
There is no sql service in services.misc.
so please tell me the solution.

Thanks for the reply
Neeraj

quote:
Originally posted by Lumbago

Can you open up the services (click Run and then type "services.msc") on your xp-machine and see if you find any sql server services? If you don't then there is no database engine that you can connect to... if there is then post the name of the service here.

- Lumbago

My blog (yes, I have a blog now! just not that much content yet)
-> www.thefirstsql.com

MIK_2008
Master Smack Fu Yak Hacker

1054 Posts

Posted - 2011-01-11 : 01:29:45

In order to install the SQL server engine, you must select this component during installation wizard.

Lumbago
Norsk Yak Master

3271 Posts

Posted - 2011-01-11 : 02:56:49

You need to download and install the database. If you don't have access to any installation media you can download the 2008R2 Express version here: http://www.microsoft.com/express/Database/

- Lumbago

My blog (yes, I have a blog now! just not that much content yet)
-> www.thefirstsql.com

sachinsql
Starting Member

1 Post

Posted - 2012-01-19 : 13:23:12

no sql server 2005 components were found on the specified computer surface area configuration

sachin

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources