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
No comments:
Post a Comment