How to connect SQL Server Mangement Console to Adventure Works

This may not be correct request but I have SQL Server Management Studio Express. How do I connect the Adventure Work Database to the console?

How do you use Access to connect to the SQL Server Express?

Thanks for your help.

To connect Management Studio Express to the AdventureWorks database, you need to have SQL Express (or another edition of SQL Server) installed and running that has the AdventureWorks database. You can then connect Management Studio Express to that SQL Server. Note, if you are trying to access SQL Server Express on a remote machine, it needs to be configured for remote access - you can search these forums to a link on a blog.

You can link tables from Access to AdventureWorks. Again, AdventureWorks needs to be running on a version of SQL Server, then you can link the tables using ODBC.

Thanks< MJ

|||Mark,

Thanks for replying but I need more details.

I have SQL 2005 Express. I have downloaded the AdventureWorks database.

I need the steps on how to connect the two together. When I open SQL Server Management Console it does not find Adventure Works. What do I need to do to connect to it.

Also I was able to create a ADP database with Access that resided on my SQL Express Server. At least I was able to see if when I opened the Server Management Console.

What I would like to be able to do is look at the AdventureWorks sample. Once they are connnectd shouldn't I be able to manpulate the data with Access?

Thanks for your help.
Regards,|||Follow the instructions available here to install the AdventureWorks database:
http://msdn2.microsoft.com/library/ms310325.aspx

Thanks< MJ|||

Mark,

Thanks for the reply. The instruction require that I have to use Visual Studio to connect. At this time, I do not want to use Visual Studio. There must be another way to connect AdventureWorks. Can't the SQL Server Management Console connect the AdventureWorks DB?

Thanks

|||

This should work:

1. Run the AdventureWorks installation, it will create two files - a MDF and LDF file.

2. Run SQL Server Management Studio and login to the SQL Express instance (".\SQLExpress" with no quotes should work).

3. In the Object Explorer in SSMS, right click on Databases and select Attach.

4. In the dialog that comes up, click the Add button and browse to the MDF file.

Database should be added and viewable in SSMS. Hope this works!

Thanks, MJ

|||

Hi Mark

I was struggling for 2 days to attach this sample databas i was getting error 602 but could not attach the databse on my local machine but i tried the .\sqlexpress and 2 minutes i had the sample database ready.

This was a great help .. Thanks millions..

Sweety

|||I keep getting a database not found error message.

1. Run the AdventureWorks installation, it will create two files - a MDF and LDF file.

Are these two files created here :

C:\ProgramFiles\MicrosoftSQLServer\MSSQL.\MSSQL\Data\AdventureWorks_Data.mdf

If so i'm missing the AdventureWorks_Data.mdf file ? Or am i?

i followed the instructions where : Http://msdn2.microsoft.com/enus/library/ms310325.aspx

but still the database was not found

|||

The right path to find MDF file c:\ Program Files\Microsoft SQL Server\MSSQL\Data

Note MSSQL not MSSQL.1

|||

Thanks alot Fairy !

They were named "AdventureWorks2000_Data.mdf" and AdventureWorks2000_log.ldf', and located in the folder you specified.

|||

thanks, thats one problem solved but i still have one other.

I've followed the instructions here : http://msdn2.microsoft.com/library/ms310325.aspx as before, and everything went well till.

"To configure AdventureWorks to work with Web server controls"

sqlcmd -E -S (local)\sqlexpress -Q "sp_grantlogin N'NT AUTHORITY\NETWORK SERVICE'"

My machine name is Leigh, i run win xp home edition, and MS SQL server 2005, so the above command in my case should be :

sqlcmd -E -S (local)\sqlexpress -Q "sp_grantlogin N' Leigh\ASPNET'" ? (which doesn't work i assume because not happens )

|||

Mark's instruction is working. Alternatively,

you can use the following script to attach AdventureWorks

database if you install it using default settings.

EXEC sp_attach_db @.dbname = N'AdventureWorks',
@.filename1 = N'c:\Program Files\Microsoft SQL Server
\MSSQL.1\MSSQL\Data\AdventureWorks_Data.mdf',
@.filename2 = N'c:\Program Files\Microsoft SQL Server
\MSSQL.1\MSSQL\Data\AdventureWorks_log.ldf' ;sql