installing the sample databases and documentation

There are two instances: SQL2005 and SQL2005Express on two different units. While there is Visual Studio 2005 Team Edition also installed on the units have not attempted these component installs through either yet. Have spent the better part of two days, following all the directions having searched help locally, online, technet,and applied their advice respectively. While I've taken out the old instances, downloaded updated ones in both my SQL Server instances they do not show as installed under Programs->SQL Server (whichever instance)->Tutorials ...However they do show installed in Control Panel and they can be found via Explorer (AdWorks DBCI+AdWorks BICI and Express instance on the other unit. Have also download SP2 and installed it, but this has proved of no help. @. My wits' end, any help will be appreciated.

Documentation and sample databases are an option during installation.

Books Online appears as an installed program in Add/Remove Programs but the sample databases do not.

If AdventureWorks was installed with 2005 but did not appear in Object Explorer you can attach it. Attach is on the right-click menu of Databases in Object Explorer.

|||

You can also find the SQL Server 2005 documentation available online at:

http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx

It has many great tutorials to get started.

Thanks,
Sam Lester (MSFT)

|||Thank you for your suggestion Lester, however before my initial post had already consulted books online, and downloaded the latest version to stay in sync with the software. Part of my frustration comes from following their directions but failing to achieve similar outcomes. Adventure Works databases are definitely resident on my computer, though not in the same directories in the Explorer file hierarchy indicated by the manuals/instructions. The directions have been exhaustively followed a number of times, replete with uninstalls then reinstalls - all to no avail. This is the case in both units, each with a different operating system and different version of SQL. Am still stymied.

Integrate SQL Server Management Studio with Sharepoint

Our IT production support team stores miscellaneous SQL scripts for support
items on a SharePoint server (WSS 3). However, to edit these scripts, the
user must save a local copy of the file, make the change and then re-upload
it, ensuring the name is the same. This triggers SharePoint to create a new
version of that script.
Is there an easier way to integrate the SQL 2005 Management Studio with
Sharepoint - maybe make it more like you are using SourceSafe, where you
have a project file with scripts in it and you can right click to Check Out,
Check In, etc?
Hi,
I noticed that you also have a post regarding this issue in
microsoft.public.sharepoint.windowsservices and our professional there will
assist you under that post. For further communications, please directly
reply to him.
Thanks for using Microsoft Managed Newsgroup. Have a nice day!
Best regards,
Charles Wang
Microsoft Online Community Support
================================================== ===
Get notification to my posts through email? Please refer to:
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications
If you are using Outlook Express, please make sure you clear the check box
"Tools/Options/Read: Get 300 headers at a time" to see your reply promptly.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.
================================================== ====
When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from this issue.
================================================== ====
This posting is provided "AS IS" with no warranties, and confers no rights.
================================================== ====

Installing SQL Server 2005

Dear All,

I want to Install Visual Studio Team Foundation Server Beta 3 Refresh. It requires

Windows 2003 Server

SQL 2005 Server (Database Services)

SQL 2005 Server (Analysis Services)

SQL 2005 Server (Reporting Services)

Shareportal Server

I installed Windows 2003 and Shareportal Server. When installing Windows 2003 Server, It also installed Sql Server 2000 (Microsoft SQL Server 2000 - 8.00.2039)

Named instance as W2K3\SHAREPORTAL.

Then I install SQL 2000 Server all service.

Problem -

Now I am going to upgrade all these services. Other then Database Service all upgraded but Database Service is not upgrade.

My Current System Configuration is

Server - W2K3

Operating Syatem - Microsoft Windows NT 5.2 (3790)
Plateform - NT INTEL X86

Memory - 512 MB

Please help me.

Did you try and Upgrade? What was the error that you got?|||

It dosen't give me any error message at all.

But when I am trying to install Team Foundation Server it saying Error 2600.

I think that Office 2K3 install a named instance of MSDE SQL2000 on machine. And it will not upgrade through SQL2005 Standard Edition.

Now I format my system and Install fresh all these components.

my problem is solved to installing TFSB3

Thanks

Installing SQL 2005 after Visual Studio 2005

WinXP Pro

Installed Visual Studio Team Suite

Installed Team Explorer

Installed SQL 2005 with all the features turned on (so everything installs)

Result: None of the SQL Management Studio tools show up.

I checked ARP and see all the entries for Microsoft SQL Server 2005.

I also checked the Services and see SQL Server (MSSQLSERVER).

I also see SQL Server (SQLEXPRESS) but don't see an ARP entry for it.

Any ideas on how to install the SQL 2005 Studio tools?

Thanks!

1. Have you try the setup.exe under ...\tools\setup.exe?

2. There will be only one entry for all SQL Server 2005 editions/instances. Go to ARP, and open SQL Server 2005 entry, select change, you can see all SQL Server 2005 editions/instances.

|||Thanks. I was able to see the sql express instance and uninstall it.