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. Web Development
  3. ASP.NET
  4. Trying to attach db's

Trying to attach db's

Scheduled Pinned Locked Moved ASP.NET
databasetutorialhelp
8 Posts 3 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.
  • B Offline
    B Offline
    bhattiprolu
    wrote on last edited by
    #1

    when i am tryibg to attach my database its showing the following error.. "An error occurred when attaching the database(s). Click the hyperlink in the Message column for details." can any body guide me how to solve this !!!!!!!!!

    P C 2 Replies Last reply
    0
    • B bhattiprolu

      when i am tryibg to attach my database its showing the following error.. "An error occurred when attaching the database(s). Click the hyperlink in the Message column for details." can any body guide me how to solve this !!!!!!!!!

      P Offline
      P Offline
      Paras Kaneriya
      wrote on last edited by
      #2

      bhattiprolu wrote:

      "An error occurred when attaching the database(s). Click the hyperlink in the Message column for details."

      what is the details?

      Paras Kaneriya
      The difference between genius and stupidity is that genius has its limits.

      B 1 Reply Last reply
      0
      • B bhattiprolu

        when i am tryibg to attach my database its showing the following error.. "An error occurred when attaching the database(s). Click the hyperlink in the Message column for details." can any body guide me how to solve this !!!!!!!!!

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

        bhattiprolu wrote:

        Click the hyperlink in the Message column for details

        Hmmm... seems the IDE is trying to guide you.

        Christian Graus - Microsoft MVP - C++ "I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )

        1 Reply Last reply
        0
        • P Paras Kaneriya

          bhattiprolu wrote:

          "An error occurred when attaching the database(s). Click the hyperlink in the Message column for details."

          what is the details?

          Paras Kaneriya
          The difference between genius and stupidity is that genius has its limits.

          B Offline
          B Offline
          bhattiprolu
          wrote on last edited by
          #4

          these are the details its providing... TITLE: Microsoft SQL Server Management Studio Express ------------------------------ Attach database failed for Server 'Server Name'. (Microsoft.SqlServer.Express.Smo) ------------------------------ ADDITIONAL INFORMATION: An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.Express.ConnectionInfo) ------------------------------ Unable to open the physical file "D:\mohan.bhattiprolu\Documents\Visual Studio 2005\WebSites\Prototype\App_Data\tempdb.mdf". Operating system error 5: "5(Access is denied.)". (Microsoft SQL Server, Error: 5120) For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.1399&EvtSrc=MSSQLServer&EvtID=5120&LinkId=20476

          C 1 Reply Last reply
          0
          • B bhattiprolu

            these are the details its providing... TITLE: Microsoft SQL Server Management Studio Express ------------------------------ Attach database failed for Server 'Server Name'. (Microsoft.SqlServer.Express.Smo) ------------------------------ ADDITIONAL INFORMATION: An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.Express.ConnectionInfo) ------------------------------ Unable to open the physical file "D:\mohan.bhattiprolu\Documents\Visual Studio 2005\WebSites\Prototype\App_Data\tempdb.mdf". Operating system error 5: "5(Access is denied.)". (Microsoft SQL Server, Error: 5120) For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.1399&EvtSrc=MSSQLServer&EvtID=5120&LinkId=20476

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

            You need to give the ASPNET user access to the file, in the file system.

            Christian Graus - Microsoft MVP - C++ "I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )

            B 1 Reply Last reply
            0
            • C Christian Graus

              You need to give the ASPNET user access to the file, in the file system.

              Christian Graus - Microsoft MVP - C++ "I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )

              B Offline
              B Offline
              bhattiprolu
              wrote on last edited by
              #6

              can you explain me in detail..

              C 1 Reply Last reply
              0
              • B bhattiprolu

                can you explain me in detail..

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

                Right click on the file in the file system. Choose properties. Go to the security tab. If you don't have one, then your general file system probably has the simple security option set, you need to find that and remove it. Now, click Add. Type ASPNET in the text box and click 'check names'. It should find it. Click OK. Now check 'full control'. Click OK.

                Christian Graus - Microsoft MVP - C++ "I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )

                B 1 Reply Last reply
                0
                • C Christian Graus

                  Right click on the file in the file system. Choose properties. Go to the security tab. If you don't have one, then your general file system probably has the simple security option set, you need to find that and remove it. Now, click Add. Type ASPNET in the text box and click 'check names'. It should find it. Click OK. Now check 'full control'. Click OK.

                  Christian Graus - Microsoft MVP - C++ "I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )

                  B Offline
                  B Offline
                  bhattiprolu
                  wrote on last edited by
                  #8

                  i have maded some changes in my connection string and i run my program i am getting this error.. "CREATE DATABASE permission denied in database 'master'. Cannot attach the file 'D:\mohan.bhattiprolu\Documents\Visual Studio 2005\WebSites\Prototype\App_Data\tempdb.mdf' as database 'tempdb.mdf'." wat is this error how to fix this one?

                  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