SQL Server 2005 installation?

23 Sep 2006 7:06 AM

Erland

Hello all,

I am new to installing Visual Studio 2005 and SQL Server 2005. I have
just installed a visual studio 2005 professional edition on my Windows
XP-Home SP 2 box. I suppose, SQL Server 2005 was installed with VS 2005
installation as I saw such option while installation but when I go to
Start-->All Programs-->Microsoft SQL Server 2005 I just see three
options, namely
-SQL Server Configuration Manager
-SQL Server Error and Usage Reporting
-SQL Server Surface Area configuration

now I have some experience of developing applications with SQL Server
2000, but I have no idea as to how to make SQL Server 2005 work and
what is required to start developing applications in VS 2005 and SQL
Server 2005. What else I am missing here? Do I have to install more of
a SQL server 2005, if so what I am missing here?

Any help will highly be appreciated,

Much thanks,
Erland

23 Sep 2006 2:09 PM

Dan Guzman

The SQL Server 2005 Express Edition included with VS doesn't include
graphical management tools, which I assume you are expecting. You can
download the express management tools from:

http://msdn.microsoft.com/vstudio/express/sql/download/

--
Hope this helps.

Dan Guzman
SQL Server MVP

Show quoteHide quote

"Erland" <Erland.Erik***@gmail.com> wrote in message
news:1158995215.466122.307750@i42g2000cwa.googlegroups.com...
> Hello all,
>
> I am new to installing Visual Studio 2005 and SQL Server 2005. I have
> just installed a visual studio 2005 professional edition on my Windows
> XP-Home SP 2 box. I suppose, SQL Server 2005 was installed with VS 2005
> installation as I saw such option while installation but when I go to
> Start-->All Programs-->Microsoft SQL Server 2005 I just see three
> options, namely
> -SQL Server Configuration Manager
> -SQL Server Error and Usage Reporting
> -SQL Server Surface Area configuration
>
> now I have some experience of developing applications with SQL Server
> 2000, but I have no idea as to how to make SQL Server 2005 work and
> what is required to start developing applications in VS 2005 and SQL
> Server 2005. What else I am missing here? Do I have to install more of
> a SQL server 2005, if so what I am missing here?
>
> Any help will highly be appreciated,
>
> Much thanks,
> Erland
>

23 Sep 2006 2:11 PM

Dave Patrick

You should have 'SQL Server (SQLEXPRESS)' service (2000 version was MSDE).
If you need more then I'd suggest you get SQL Server Developer edition.

http://www.microsoft.com/products/info/product.aspx?view=22&pcid=f544888c-2638-48ed-9f0f-d814e8b93ca0&type=ovr

--

Regards,

Dave Patrick ....Please no email replies - reply in newsgroup.
Microsoft Certified Professional
Microsoft MVP [Windows]
http://www.microsoft.com/protect

Show quoteHide quote

"Erland" wrote:
| Hello all,
|
| I am new to installing Visual Studio 2005 and SQL Server 2005. I have
| just installed a visual studio 2005 professional edition on my Windows
| XP-Home SP 2 box. I suppose, SQL Server 2005 was installed with VS 2005
| installation as I saw such option while installation but when I go to
| Start-->All Programs-->Microsoft SQL Server 2005 I just see three
| options, namely
| -SQL Server Configuration Manager
| -SQL Server Error and Usage Reporting
| -SQL Server Surface Area configuration
|
| now I have some experience of developing applications with SQL Server
| 2000, but I have no idea as to how to make SQL Server 2005 work and
| what is required to start developing applications in VS 2005 and SQL
| Server 2005. What else I am missing here? Do I have to install more of
| a SQL server 2005, if so what I am missing here?
|
| Any help will highly be appreciated,
|
| Much thanks,
| Erland
|

Thread options