Can't find AdventureWorks in order to connect

I am working with SQL Server 2005 Express installed on my workstation under
XP SP2.
I am trying to work through the online tutorial. I am on
http://msdn2.microsoft.com/en-us/library/ms170681.aspx
I downloaded the AdventureWorksDB.msi and installed it. The files
AdventureWorks_Data and AdventureWorks_Log are in my C:\Program
File\Microsoft SQL Server\MSSQL.1\MSSQL\Data directory.
I am now trying to register the AdventureWorks server. Everything looks as
described in the tutorial until I get to the Connection Properties in Step 5.
There are no options for me to select. There are no databases other than
the initial system databases (no User Databases) when I try to browse.
Did I do something wrong? How do I locate the database so I can register it?Ensure you attached the AdventureWorks database to your SQL Server instance
which you choose in the New Server Registration window as the Server Name
editbox (e.g. EKREM-PC\test2)
If the AdventureWorks database is attached to your SQL Server instance and
if you type this SQL Server instance' s name in the Server Name editbox in
the New Server Registration, then you should be seeing the AdventureWorks
database in the combobox in Connection Properties tab in the New Server
Registration window.
--
Ekrem Ã?nsoy
"epignosis" <epignosis@.discussions.microsoft.com> wrote in message
news:C6DBA92F-A5A1-4333-993C-46E08CE8FCF8@.microsoft.com...
>I am working with SQL Server 2005 Express installed on my workstation under
> XP SP2.
> I am trying to work through the online tutorial. I am on
> http://msdn2.microsoft.com/en-us/library/ms170681.aspx
> I downloaded the AdventureWorksDB.msi and installed it. The files
> AdventureWorks_Data and AdventureWorks_Log are in my C:\Program
> File\Microsoft SQL Server\MSSQL.1\MSSQL\Data directory.
> I am now trying to register the AdventureWorks server. Everything looks
> as
> described in the tutorial until I get to the Connection Properties in Step
> 5.
> There are no options for me to select. There are no databases other than
> the initial system databases (no User Databases) when I try to browse.
> Did I do something wrong? How do I locate the database so I can register
> it?
>
>|||"Installing" from the MSI just extracts the database files. You then need
to run CREATE DATABASE ... FOR ATTACH. See Books Online for exact syntax.
"epignosis" <epignosis@.discussions.microsoft.com> wrote in message
news:C6DBA92F-A5A1-4333-993C-46E08CE8FCF8@.microsoft.com...
>I am working with SQL Server 2005 Express installed on my workstation under
> XP SP2.
> I am trying to work through the online tutorial. I am on
> http://msdn2.microsoft.com/en-us/library/ms170681.aspx
> I downloaded the AdventureWorksDB.msi and installed it. The files
> AdventureWorks_Data and AdventureWorks_Log are in my C:\Program
> File\Microsoft SQL Server\MSSQL.1\MSSQL\Data directory.
> I am now trying to register the AdventureWorks server. Everything looks
> as
> described in the tutorial until I get to the Connection Properties in Step
> 5.
> There are no options for me to select. There are no databases other than
> the initial system databases (no User Databases) when I try to browse.
> Did I do something wrong? How do I locate the database so I can register
> it?
>
>

Can't find AdventureWorks in order to connect

I am working with SQL Server 2005 Express installed on my workstation under
XP SP2.
I am trying to work through the online tutorial. I am on
http://msdn2.microsoft.com/en-us/library/ms170681.aspx
I downloaded the AdventureWorksDB.msi and installed it. The files
AdventureWorks_Data and AdventureWorks_Log are in my C:\Program
File\Microsoft SQL Server\MSSQL.1\MSSQL\Data directory.
I am now trying to register the AdventureWorks server. Everything looks as
described in the tutorial until I get to the Connection Properties in Step 5.
There are no options for me to select. There are no databases other than
the initial system databases (no User Databases) when I try to browse.
Did I do something wrong? How do I locate the database so I can register it?
Ensure you attached the AdventureWorks database to your SQL Server instance
which you choose in the New Server Registration window as the Server Name
editbox (e.g. EKREM-PC\test2)
If the AdventureWorks database is attached to your SQL Server instance and
if you type this SQL Server instance' s name in the Server Name editbox in
the New Server Registration, then you should be seeing the AdventureWorks
database in the combobox in Connection Properties tab in the New Server
Registration window.
Ekrem ?nsoy
"epignosis" <epignosis@.discussions.microsoft.com> wrote in message
news:C6DBA92F-A5A1-4333-993C-46E08CE8FCF8@.microsoft.com...
>I am working with SQL Server 2005 Express installed on my workstation under
> XP SP2.
> I am trying to work through the online tutorial. I am on
> http://msdn2.microsoft.com/en-us/library/ms170681.aspx
> I downloaded the AdventureWorksDB.msi and installed it. The files
> AdventureWorks_Data and AdventureWorks_Log are in my C:\Program
> File\Microsoft SQL Server\MSSQL.1\MSSQL\Data directory.
> I am now trying to register the AdventureWorks server. Everything looks
> as
> described in the tutorial until I get to the Connection Properties in Step
> 5.
> There are no options for me to select. There are no databases other than
> the initial system databases (no User Databases) when I try to browse.
> Did I do something wrong? How do I locate the database so I can register
> it?
>
>
|||"Installing" from the MSI just extracts the database files. You then need
to run CREATE DATABASE ... FOR ATTACH. See Books Online for exact syntax.
"epignosis" <epignosis@.discussions.microsoft.com> wrote in message
news:C6DBA92F-A5A1-4333-993C-46E08CE8FCF8@.microsoft.com...
>I am working with SQL Server 2005 Express installed on my workstation under
> XP SP2.
> I am trying to work through the online tutorial. I am on
> http://msdn2.microsoft.com/en-us/library/ms170681.aspx
> I downloaded the AdventureWorksDB.msi and installed it. The files
> AdventureWorks_Data and AdventureWorks_Log are in my C:\Program
> File\Microsoft SQL Server\MSSQL.1\MSSQL\Data directory.
> I am now trying to register the AdventureWorks server. Everything looks
> as
> described in the tutorial until I get to the Connection Properties in Step
> 5.
> There are no options for me to select. There are no databases other than
> the initial system databases (no User Databases) when I try to browse.
> Did I do something wrong? How do I locate the database so I can register
> it?
>
>
sql

Can't find AdventureWorks in order to connect

I am working with SQL Server 2005 Express installed on my workstation under
XP SP2.
I am trying to work through the online tutorial. I am on
http://msdn2.microsoft.com/en-us/library/ms170681.aspx
I downloaded the AdventureWorksDB.msi and installed it. The files
AdventureWorks_Data and AdventureWorks_Log are in my C:\Program
File\Microsoft SQL Server\MSSQL.1\MSSQL\Data directory.
I am now trying to register the AdventureWorks server. Everything looks as
described in the tutorial until I get to the Connection Properties in Step 5
.
There are no options for me to select. There are no databases other than
the initial system databases (no User Databases) when I try to browse.
Did I do something wrong? How do I locate the database so I can register it
?Ensure you attached the AdventureWorks database to your SQL Server instance
which you choose in the New Server Registration window as the Server Name
editbox (e.g. EKREM-PC\test2)
If the AdventureWorks database is attached to your SQL Server instance and
if you type this SQL Server instance' s name in the Server Name editbox in
the New Server Registration, then you should be seeing the AdventureWorks
database in the combobox in Connection Properties tab in the New Server
Registration window.
Ekrem ?nsoy
"epignosis" <epignosis@.discussions.microsoft.com> wrote in message
news:C6DBA92F-A5A1-4333-993C-46E08CE8FCF8@.microsoft.com...
>I am working with SQL Server 2005 Express installed on my workstation under
> XP SP2.
> I am trying to work through the online tutorial. I am on
> http://msdn2.microsoft.com/en-us/library/ms170681.aspx
> I downloaded the AdventureWorksDB.msi and installed it. The files
> AdventureWorks_Data and AdventureWorks_Log are in my C:\Program
> File\Microsoft SQL Server\MSSQL.1\MSSQL\Data directory.
> I am now trying to register the AdventureWorks server. Everything looks
> as
> described in the tutorial until I get to the Connection Properties in Step
> 5.
> There are no options for me to select. There are no databases other than
> the initial system databases (no User Databases) when I try to browse.
> Did I do something wrong? How do I locate the database so I can register
> it?
>
>|||"Installing" from the MSI just extracts the database files. You then need
to run CREATE DATABASE ... FOR ATTACH. See Books Online for exact syntax.
"epignosis" <epignosis@.discussions.microsoft.com> wrote in message
news:C6DBA92F-A5A1-4333-993C-46E08CE8FCF8@.microsoft.com...
>I am working with SQL Server 2005 Express installed on my workstation under
> XP SP2.
> I am trying to work through the online tutorial. I am on
> http://msdn2.microsoft.com/en-us/library/ms170681.aspx
> I downloaded the AdventureWorksDB.msi and installed it. The files
> AdventureWorks_Data and AdventureWorks_Log are in my C:\Program
> File\Microsoft SQL Server\MSSQL.1\MSSQL\Data directory.
> I am now trying to register the AdventureWorks server. Everything looks
> as
> described in the tutorial until I get to the Connection Properties in Step
> 5.
> There are no options for me to select. There are no databases other than
> the initial system databases (no User Databases) when I try to browse.
> Did I do something wrong? How do I locate the database so I can register
> it?
>
>

Can't create SSIS project in BIDS on workstation with Client tools only installed

I have the June CTP SQL 2005 client tools only installed on my workstation. All has gone well until I tried to create a SSIS project in BIDS.

I receive this message

TITLE: Microsoft Visual Studio

Error creating package

ADDITIONAL INFORMATION:

Failed to save package file "D:\Documents and Settings\SuzMSDN\Local Settings\Temp\tmp13E.tmp" with error 0x80040154 "Class not registered".

Failed to save package file "D:\Documents and Settings\SuzMSDN\Local Settings\Temp\tmp13E.tmp" with error 0x80040154 "Class not registered".

Tried registering DTSPipeline.dll per a post with no success.

I can log into the server where SQL is installed and use BIDS on the server without issue for an SSIS project.

Thoughts?

Susan

Does the dialog have "show technical details" button?
If yes, please post this information.

Thanks,
Michael.|||

Below are the technical Details ...thanks

Susan
===================================

Error creating package (Microsoft Visual Studio)

===================================

Failed to save package file "D:\Documents and Settings\SuzMSDN\Local Settings\Temp\tmp10.tmp" with error 0x80040154 "Class not registered".

Program Location:

at Microsoft.SqlServer.Dts.Runtime.Application.SaveToXml(String fileName, Package package, IDTSEvents events)
at Microsoft.DataTransformationServices.Wizards.Dts90WizardSaveNewTask.AddPackageToProject(Package package, String itemName)
at Microsoft.DataTransformationServices.Wizards.Dts90WizardSaveNewTask.CreateAndAddPackageToProject()
at Microsoft.DataTransformationServices.Wizards.Dts90WizardSaveNewTask.Execute(WizardInputs wizardInputs)

===================================

Failed to save package file "D:\Documents and Settings\SuzMSDN\Local Settings\Temp\tmp10.tmp" with error 0x80040154 "Class not registered".

Program Location:

at Microsoft.SqlServer.Dts.Runtime.Wrapper.ApplicationClass.SaveToXML(String FileName, IDTSPersist90 pPersistObj, IDTSEvents90 pEvents)
at Microsoft.SqlServer.Dts.Runtime.Application.SaveToXml(String fileName, Package package, IDTSEvents events)

|||Let's try this:

regsvr32 msxml3.dll
regsvr32 msxml4.dll
regsvr32 msxml6.dll|||Michael,

Thanks you. That did the trick. I had to unregister msxml6 in order to take the MS SQL 2005 elearning classes.

So to take class you unregister...to work you register. ; )

Hopefully corrected for elearning in the next release.

Thanks for your assistance.

Susan