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
 How to install SQL Server on windows XP?

Author  Topic 

newer
Starting Member

12 Posts
Posted - 2007-06-26 : 12:01:39
i am truing to install SQL Server from microsoft site on my windows xp. The installation proces goes fine but i dont see it installed on start--->all programs or even in add/ remove program list. what is happening with it? can anybody tell me hoe to install sql server please.

khtan
In (Som, Ni, Yak)

17689 Posts
Posted - 2007-06-26 : 12:03:47
What edition of SQL Server did you installed ? You can only install the developer edition on WinXP

KH
[spoiler]Time is always against us[/spoiler]
Go to Top of Page

newer
Starting Member

12 Posts
Posted - 2007-06-26 : 12:10:15
I tried to install "SQL Server 2005 Trial Software" from here
http://technet.microsoft.com/en-us/sqlserver/bb462637.aspx

Can you give me a link where i can download SQL server developer edition.
Go to Top of Page

khtan
In (Som, Ni, Yak)

17689 Posts
Posted - 2007-06-26 : 12:15:33
you have to purchase it. It is not that expensive.

KH
[spoiler]Time is always against us[/spoiler]
Go to Top of Page

Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)

7020 Posts
Posted - 2007-06-26 : 12:15:54
You can purchase SQL Server 2005 Developer Edition from Amazon.com for about $50 US, or less.



CODO ERGO SUM
Go to Top of Page

khtan
In (Som, Ni, Yak)

17689 Posts
Posted - 2007-06-26 : 12:15:56
or use the SQL 2005 Express edition

KH
[spoiler]Time is always against us[/spoiler]
Go to Top of Page

rmiao
Master Smack Fu Yak Hacker

7266 Posts
Posted - 2007-06-26 : 13:23:22
and it's free.
Go to Top of Page

newer
Starting Member

12 Posts
Posted - 2007-06-26 : 13:48:48
Thank you all for replying. Just one more question.

Microsoft site suggeests that i download "Windows Installer 3.1." and For 32-bit platforms, install the "32-bit version of Microsoft .NET Framework 2.0." before installing SQL Server Express.Link for that page

http://www.microsoft.com/downloads/details.aspx?FamilyID=220549b5-0b07-4448-8848-dcc397514b41&displaylang=en

My question is is it necessary to install windows installer 3.1 and "32-bit version of Microsoft .NET Framework 2.0." or can i skip that and directly install SQL Server Express.
Go to Top of Page

rmiao
Master Smack Fu Yak Hacker

7266 Posts
Posted - 2007-06-26 : 14:03:02
You can skip those, but .net 2.0 gives you new features.
Go to Top of Page

newer
Starting Member

12 Posts
Posted - 2007-06-26 : 15:03:29
I installed SQl Server Express without installing "Windows Installer 3.1." and "32-bit version of Microsoft .NET Framework 2.0.".

After clicking on "run" it extracted file to a location to c:\ccf7eab....(which i am not able to find even after doing a search for that file) and got a message saying "there is no Microsoft .Net framework 2.0. Please install it before running set up". In the "Add/Remove program" list,i see "Microsoft .NET Framework 1.1"

I don't know where to find set up file. And i don't see anything new installed on "Start--->All programs". Sorry if my questions sound too basic. I am new to this. Can anybody give me detailed information or guide me through the installation process please.
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts
Posted - 2007-06-26 : 15:11:04
Just like the error says, you need to install .NET Framework 2.0. Go to the MS site to download it.

Tara Kizer
http://weblogs.sqlteam.com/tarad/
Go to Top of Page

newer
Starting Member

12 Posts
Posted - 2007-06-26 : 15:17:35
Do i need to uninstall "Microsoft .NET Framework 1.1" before installing "Microsoft .NET Framework 2.0"
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts
Posted - 2007-06-26 : 15:18:41
No. If you do, you will have issues with applications that utilize .NET Framework 1.1.

Tara Kizer
http://weblogs.sqlteam.com/tarad/
Go to Top of Page

newer
Starting Member

12 Posts
Posted - 2007-06-26 : 15:44:02
i installed "Microsoft .NET Framework 2.0". How do i complete the installation of SQL Server now. As i mentioned before while installing SQL Server, after clicking on "run" it extracted file to a location to c:\ccf7eab....(which i am not able to find even after doing a search for that file)
I don't know where to find set up file. And i don't see anything new installed on "Start--->All programs". How do i procede now.

And can i have oracle and SQL Server both on the same system.
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts
Posted - 2007-06-26 : 15:49:03
Why not save the downloaded file to your machine, use Winzip or some other tool to extract the files, then run the setup executable (whatever it is named)?

The installations that I have don't do this, so I've never installed SQL Server this way.

Tara Kizer
http://weblogs.sqlteam.com/tarad/
Go to Top of Page

newer
Starting Member

12 Posts
Posted - 2007-06-26 : 15:59:10
I did save it on to my machine.An application file named "SQLEXPR" got saved. when i run that file, as i mentioned before,it extracted file to a location to c:\ccf7eab....(which i am not able to find even after doing a search for that file) and got a message saying "there is no Microsoft .Net framework 2.0. Please install it before running set up". Nothing happens after that message, no short cut created, nothing on Start--->All programs or no more messages.

I am downloading SQL Server Express Edition from here

http://www.microsoft.com/downloads/details.aspx?FamilyID=220549b5-0b07-4448-8848-dcc397514b41&displaylang=en
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts
Posted - 2007-06-26 : 16:01:04
According to the error you just posted, you still don't have .NET Framework 2.0 installed.

Tara Kizer
http://weblogs.sqlteam.com/tarad/
Go to Top of Page

newer
Starting Member

12 Posts
Posted - 2007-06-26 : 16:18:32
o.k i ran "SQLEXPR" again and went through the installation wizard with one warning message about "minimum system requirement". Now in "authentication mode " window, should i choose

* windows authentication mode or
* mixed mode(windows authentication and SQl Server Authentication"

If i choose mixed mode, i need to enter password for "sa" log on. What is the password for "sa" logon.
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts
Posted - 2007-06-26 : 16:27:25
You get to pick the password, not us.

Deciding which authentication mode to use is a security thing. Do you even understand the difference between the two?

Tara Kizer
http://weblogs.sqlteam.com/tarad/
Go to Top of Page

newer
Starting Member

12 Posts
Posted - 2007-06-26 : 16:41:28
actually, i don't know the difference. i am new to this. i am installing it on my pc and planning to learn SQl. I thought if i choose "mixed mode(windows authentication and SQl Server Authentication", giving a easy password which i use regularly would be easy for me to remember. But as i am installing it just for learning purpose, i don't know whether to choose,

* windows authentication mode or
* mixed mode(windows authentication and SQl Server Authentication"

can you give a link to the document which explains this or can you tell which option to choose considering that i am using it only for learning purpose and no valuable data is going to be stored. Sorry for very basic questions, i am still trying to figure it out.
Go to Top of Page

rmiao
Master Smack Fu Yak Hacker

7266 Posts
Posted - 2007-06-26 : 16:52:03
In this case, I'd like choose mixed authentication so you can try all those features.
Go to Top of Page
    Next Page

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources

Articles

Forums

Blogs

Contact Us

About the Site