Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • World
  • Users
  • Groups
Skins
  • Light
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (No Skin)
  • No Skin
Collapse
Code Project
  1. Home
  2. Database & SysAdmin
  3. Database
  4. sample database in sql server 2005 developer

sample database in sql server 2005 developer

Scheduled Pinned Locked Moved Database
databasehelptutorialsql-serversysadmin
3 Posts 2 Posters 0 Views 1 Watching
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • L Offline
    L Offline
    lagumaster
    wrote on last edited by
    #1

    hi everyone, i'm trying to install the sample database AdventureWorks I followed the step-by-step in the tutorial book (installing after the setup). but i don't know why i cannot make a connection on it. Anyone here knows how to workaround this problem. I will appreciate any help!:doh:

    C 1 Reply Last reply
    0
    • L lagumaster

      hi everyone, i'm trying to install the sample database AdventureWorks I followed the step-by-step in the tutorial book (installing after the setup). but i don't know why i cannot make a connection on it. Anyone here knows how to workaround this problem. I will appreciate any help!:doh:

      C Offline
      C Offline
      Christian Graus
      wrote on last edited by
      #2

      lagumaster wrote: Anyone here knows how to workaround this problem. What problem ? You said this: 'I followed the instructions, but it didn't work'. You obviously did not follow the instructions, but without clear description of the sort of errors you're getting, it's impossible to work out how and where. Christian Graus - Microsoft MVP - C++

      L 1 Reply Last reply
      0
      • C Christian Graus

        lagumaster wrote: Anyone here knows how to workaround this problem. What problem ? You said this: 'I followed the instructions, but it didn't work'. You obviously did not follow the instructions, but without clear description of the sort of errors you're getting, it's impossible to work out how and where. Christian Graus - Microsoft MVP - C++

        L Offline
        L Offline
        lagumaster
        wrote on last edited by
        #3

        I believe I followed the instructions. I did the steps in: To install the sample databases and samples after Setup. But then when I tried to register the AdventureWorks Database, in the New Server Registration Dialog Box, I clicked on the AdventureWorks (in the Connect to Database listbox), then I clicked TEST button, I'm getting an error says: "Cannot open database requested in login...." So I thought it was installed but not attached, so what I did I used the ATTACH context menu in the Database, i looked for the .mdf file, but I'm still getting an error. But I was wondering why when I installed AdventureWorks it didn't go to this path: n:\Program Files\Microsoft SQL Server\MSSQL.n\MSSQL\Data. It when here: n:\Program Files\Microsoft SQL Server\90\Tools\Samples \AdventureWorks OLTP. And I'm getting an error when i'm trying to attach it:confused: hope this makes my problem clear and hope you can help me. Thanks!

        1 Reply Last reply
        0
        Reply
        • Reply as topic
        Log in to reply
        • Oldest to Newest
        • Newest to Oldest
        • Most Votes


        • Login

        • Don't have an account? Register

        • Login or register to search.
        • First post
          Last post
        0
        • Categories
        • Recent
        • Tags
        • Popular
        • World
        • Users
        • Groups