I'm new, I'm lost, I think I've installed the wrong this!

Hi folks

I've got experience of developing applications using relational databases, but I've never installed a database on my PC.

I've just downloaded and installed .NET Framework 2.0 without issues. I also did Visual C# Express with no problems and I've made a couple of example projects successfully.

What I wanted to do next was install SQL Server Express so I can design a database and then use Visual C# to create a GUI to do a simple add/edit/delete type scenario.

So, I have installed something called SQL Server 2005. I tried to install SQL Server Express, but for some reason it isn't called that on my list of programs.

When I open that up I have a choice of SQL Server Configuration Manager or SQL Server 2005 Surface Area Configuration. None of these look like what I was expecting - a nice Studio where I can create tables much like MS Access.

Perhaps I need to do something with one of these tools to get to where I want to be, or perhaps I am barking up the wrong tree and I need to do some uninstalling.

I wondered if someone could guide me? I feel so lost that I don't even know the right questions to ask to get the answers.

Thanks

Richard

The 'standard' installation for SQL Express does not include any 'client tools', i.e., "where I can create tables".

However, you can download and install the SQL Server Management Studio Express from:

SQL Server 2005 Express Books Online Express Edition
http://msdn2.microsoft.com/en-us/library/ms165706.aspx

SQL Server 2005 Express Edition (Advanced/SSMS)
http://msdn.microsoft.com/vstudio/express/sql/compare/default.aspx
http://msdn2.microsoft.com/en-us/library/ms365247.aspx
http://tinyurl.com/yelwr9

I included the url for Books Online -the definitive help source for SQL Server.

|||

Thank you kind sir.

I guessed there was another step to do but I just couldn't figure it out.

I'm downloading now, so if I have any issues with the installation I'll pop back for help. Or, I'll try the online book which looks like it'll be a great help.

Have a nice day.

I'm in deep s??

Got all excited all the new sql server 2005. Downloaded it, during
installation, it complained about requirement for uninstallation of previous
eval/CTP version. So, I obliged, however, the uninstallation were
incomplete. Now, The Remove Program couldn't uninstall SQL Server 2000
Reporting Service, it asked for a freaking version of .Net Framework.
Couldn't SQL Server 2005 installation package checking all previous
installation and automatically remove all of them?
WHAT TO DO? WHAT TO DO' I'm drowing!> WHAT TO DO? WHAT TO DO' I'm drowing!
I don't know what pre-release version you had installed but there is a build
uninstall wizard on the Sept. CTP media that will forcibly remove the
pre-release stuff. There is something similar for pre-release VS 2005 via
download.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"ImJoe" <ImJoe@.discussions.microsoft.com> wrote in message
news:4C7E4BB6-DFA5-4985-96B7-C71EF82EAD0D@.microsoft.com...
> Got all excited all the new sql server 2005. Downloaded it, during
> installation, it complained about requirement for uninstallation of
> previous
> eval/CTP version. So, I obliged, however, the uninstallation were
> incomplete. Now, The Remove Program couldn't uninstall SQL Server 2000
> Reporting Service, it asked for a freaking version of .Net Framework.
> Couldn't SQL Server 2005 installation package checking all previous
> installation and automatically remove all of them?
> WHAT TO DO? WHAT TO DO' I'm drowing!
>|||Dan,
Thanks for the follow-up. Problem resolved. Right after I posted the msg I
knocked myself in the head, what a fool I was. There could be others
experiencing the same problem, posted it and got answered, sure enough,
another thread has info on a patch workaround to clean up the mess. So, I've
now successfully installed sql server 2005.
Another question though, bear with me for not to post it separately,
is there a way to copy a database from Database Service to
Analysis Service?
Thanks.
"Dan Guzman" wrote:
> > WHAT TO DO? WHAT TO DO' I'm drowing!
> I don't know what pre-release version you had installed but there is a build
> uninstall wizard on the Sept. CTP media that will forcibly remove the
> e-release stuff. There is something similar for pre-release VS 2005 via
> download.
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "ImJoe" <ImJoe@.discussions.microsoft.com> wrote in message
> news:4C7E4BB6-DFA5-4985-96B7-C71EF82EAD0D@.microsoft.com...
> >
> > Got all excited all the new sql server 2005. Downloaded it, during
> > installation, it complained about requirement for uninstallation of
> > previous
> > eval/CTP version. So, I obliged, however, the uninstallation were
> > incomplete. Now, The Remove Program couldn't uninstall SQL Server 2000
> > Reporting Service, it asked for a freaking version of .Net Framework.
> >
> > Couldn't SQL Server 2005 installation package checking all previous
> > installation and automatically remove all of them?
> >
> > WHAT TO DO? WHAT TO DO' I'm drowing!
> >
>
>|||> Another question though, bear with me for not to post it separately,
> is there a way to copy a database from Database Service to
> Analysis Service?
Sorry, but what I don't know about SSAS is a lot. I suggest you post this
question to the OLAP forum.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"ImJoe" <ImJoe@.discussions.microsoft.com> wrote in message
news:21CC133A-63E6-4C75-B36B-22D8A4A847AD@.microsoft.com...
> Dan,
> Thanks for the follow-up. Problem resolved. Right after I posted the msg
> I
> knocked myself in the head, what a fool I was. There could be others
> experiencing the same problem, posted it and got answered, sure enough,
> another thread has info on a patch workaround to clean up the mess. So,
> I've
> now successfully installed sql server 2005.
> Another question though, bear with me for not to post it separately,
> is there a way to copy a database from Database Service to
> Analysis Service?
> Thanks.
> "Dan Guzman" wrote:
>> > WHAT TO DO? WHAT TO DO' I'm drowing!
>> I don't know what pre-release version you had installed but there is a
>> build
>> uninstall wizard on the Sept. CTP media that will forcibly remove the
>> e-release stuff. There is something similar for pre-release VS 2005 via
>> download.
>> --
>> Hope this helps.
>> Dan Guzman
>> SQL Server MVP
>> "ImJoe" <ImJoe@.discussions.microsoft.com> wrote in message
>> news:4C7E4BB6-DFA5-4985-96B7-C71EF82EAD0D@.microsoft.com...
>> >
>> > Got all excited all the new sql server 2005. Downloaded it, during
>> > installation, it complained about requirement for uninstallation of
>> > previous
>> > eval/CTP version. So, I obliged, however, the uninstallation were
>> > incomplete. Now, The Remove Program couldn't uninstall SQL Server 2000
>> > Reporting Service, it asked for a freaking version of .Net Framework.
>> >
>> > Couldn't SQL Server 2005 installation package checking all previous
>> > installation and automatically remove all of them?
>> >
>> > WHAT TO DO? WHAT TO DO' I'm drowing!
>> >
>>

I'm in deep s??

Got all excited all the new sql server 2005. Downloaded it, during
installation, it complained about requirement for uninstallation of previous
eval/CTP version. So, I obliged, however, the uninstallation were
incomplete. Now, The Remove Program couldn't uninstall SQL Server 2000
Reporting Service, it asked for a freaking version of .Net Framework.
Couldn't SQL Server 2005 installation package checking all previous
installation and automatically remove all of them?
WHAT TO DO? WHAT TO DO' I'm drowing!> WHAT TO DO? WHAT TO DO' I'm drowing!
I don't know what pre-release version you had installed but there is a build
uninstall wizard on the Sept. CTP media that will forcibly remove the
pre-release stuff. There is something similar for pre-release VS 2005 via
download.
Hope this helps.
Dan Guzman
SQL Server MVP
"ImJoe" <ImJoe@.discussions.microsoft.com> wrote in message
news:4C7E4BB6-DFA5-4985-96B7-C71EF82EAD0D@.microsoft.com...
> Got all excited all the new sql server 2005. Downloaded it, during
> installation, it complained about requirement for uninstallation of
> previous
> eval/CTP version. So, I obliged, however, the uninstallation were
> incomplete. Now, The Remove Program couldn't uninstall SQL Server 2000
> Reporting Service, it asked for a freaking version of .Net Framework.
> Couldn't SQL Server 2005 installation package checking all previous
> installation and automatically remove all of them?
> WHAT TO DO? WHAT TO DO' I'm drowing!
>|||Dan,
Thanks for the follow-up. Problem resolved. Right after I posted the msg I
knocked myself in the head, what a fool I was. There could be others
experiencing the same problem, posted it and got answered, sure enough,
another thread has info on a patch workaround to clean up the mess. So, I'v
e
now successfully installed sql server 2005.
Another question though, bear with me for not to post it separately,
is there a way to copy a database from Database Service to
Analysis Service?
Thanks.
"Dan Guzman" wrote:

> I don't know what pre-release version you had installed but there is a bui
ld
> uninstall wizard on the Sept. CTP media that will forcibly remove the
> e-release stuff. There is something similar for pre-release VS 2005 via
> download.
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "ImJoe" <ImJoe@.discussions.microsoft.com> wrote in message
> news:4C7E4BB6-DFA5-4985-96B7-C71EF82EAD0D@.microsoft.com...
>
>|||> Another question though, bear with me for not to post it separately,
> is there a way to copy a database from Database Service to
> Analysis Service?
Sorry, but what I don't know about SSAS is a lot. I suggest you post this
question to the OLAP forum.
Hope this helps.
Dan Guzman
SQL Server MVP
"ImJoe" <ImJoe@.discussions.microsoft.com> wrote in message
news:21CC133A-63E6-4C75-B36B-22D8A4A847AD@.microsoft.com...[vbcol=seagreen]
> Dan,
> Thanks for the follow-up. Problem resolved. Right after I posted the msg
> I
> knocked myself in the head, what a fool I was. There could be others
> experiencing the same problem, posted it and got answered, sure enough,
> another thread has info on a patch workaround to clean up the mess. So,
> I've
> now successfully installed sql server 2005.
> Another question though, bear with me for not to post it separately,
> is there a way to copy a database from Database Service to
> Analysis Service?
> Thanks.
> "Dan Guzman" wrote:
>

I'm in deep s??

Got all excited all the new sql server 2005. Downloaded it, during
installation, it complained about requirement for uninstallation of previous
eval/CTP version. So, I obliged, however, the uninstallation were
incomplete. Now, The Remove Program couldn't uninstall SQL Server 2000
Reporting Service, it asked for a freaking version of .Net Framework.
Couldn't SQL Server 2005 installation package checking all previous
installation and automatically remove all of them?
WHAT TO DO? WHAT TO DO? I'm drowing!
> WHAT TO DO? WHAT TO DO? I'm drowing!
I don't know what pre-release version you had installed but there is a build
uninstall wizard on the Sept. CTP media that will forcibly remove the
pre-release stuff. There is something similar for pre-release VS 2005 via
download.
Hope this helps.
Dan Guzman
SQL Server MVP
"ImJoe" <ImJoe@.discussions.microsoft.com> wrote in message
news:4C7E4BB6-DFA5-4985-96B7-C71EF82EAD0D@.microsoft.com...
> Got all excited all the new sql server 2005. Downloaded it, during
> installation, it complained about requirement for uninstallation of
> previous
> eval/CTP version. So, I obliged, however, the uninstallation were
> incomplete. Now, The Remove Program couldn't uninstall SQL Server 2000
> Reporting Service, it asked for a freaking version of .Net Framework.
> Couldn't SQL Server 2005 installation package checking all previous
> installation and automatically remove all of them?
> WHAT TO DO? WHAT TO DO? I'm drowing!
>
|||Dan,
Thanks for the follow-up. Problem resolved. Right after I posted the msg I
knocked myself in the head, what a fool I was. There could be others
experiencing the same problem, posted it and got answered, sure enough,
another thread has info on a patch workaround to clean up the mess. So, I've
now successfully installed sql server 2005.
Another question though, bear with me for not to post it separately,
is there a way to copy a database from Database Service to
Analysis Service?
Thanks.
"Dan Guzman" wrote:

> I don't know what pre-release version you had installed but there is a build
> uninstall wizard on the Sept. CTP media that will forcibly remove the
> e-release stuff. There is something similar for pre-release VS 2005 via
> download.
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "ImJoe" <ImJoe@.discussions.microsoft.com> wrote in message
> news:4C7E4BB6-DFA5-4985-96B7-C71EF82EAD0D@.microsoft.com...
>
>
|||> Another question though, bear with me for not to post it separately,
> is there a way to copy a database from Database Service to
> Analysis Service?
Sorry, but what I don't know about SSAS is a lot. I suggest you post this
question to the OLAP forum.
Hope this helps.
Dan Guzman
SQL Server MVP
"ImJoe" <ImJoe@.discussions.microsoft.com> wrote in message
news:21CC133A-63E6-4C75-B36B-22D8A4A847AD@.microsoft.com...[vbcol=seagreen]
> Dan,
> Thanks for the follow-up. Problem resolved. Right after I posted the msg
> I
> knocked myself in the head, what a fool I was. There could be others
> experiencing the same problem, posted it and got answered, sure enough,
> another thread has info on a patch workaround to clean up the mess. So,
> I've
> now successfully installed sql server 2005.
> Another question though, bear with me for not to post it separately,
> is there a way to copy a database from Database Service to
> Analysis Service?
> Thanks.
> "Dan Guzman" wrote: