How to connect SQL Server Mangement Console to Adventure Works

How to connect SQL Server Mangement Console to Adventure Works

• Or Mintz

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

  Note MSSQL not MSSQL.1

  
  
  

• Vighnesh Prabhudesai

  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 )

   

   

   

  
  

• Elisabeth Boonin

  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

   

  
  

• walter wu

  Thanks alot Fairy !

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

  

  
  

• cliff2006

  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' ;
  

• XMLHacker

  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

  
  

• Mark Redman

  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,
  
  

• greekTowner

  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

  
  
  

• Pardasani

  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

  
  
  

• iestudi

  Follow the instructions available here to install the AdventureWorks database:
  http://msdn2.microsoft.com/library/ms310325.aspx
  
  Thanks< MJ
  
  

• elfranko

  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

  
  
  
• How to connect SQL Server Mangement Console to Adventure Works