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. problem with IIS

problem with IIS

Scheduled Pinned Locked Moved ASP.NET
databasehelpquestioncsharpsysadmin
14 Posts 9 Posters 1 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.
  • A amin_behzadi

    Hi dears, I want to test my website on my workgroup network . Then I created a virtual directory in IIS and could brows website from another pc correctly. but it has a big problem . the website is not enable to connect to SQL database. How can I fix it ? thx a lot,

    www.behzadi.net

    S Offline
    S Offline
    Saksida Bojan
    wrote on last edited by
    #2

    furza_milan wrote:

    How can I fix it ?

    Did you add grant permision for user asp.net

    1 Reply Last reply
    0
    • A amin_behzadi

      Hi dears, I want to test my website on my workgroup network . Then I created a virtual directory in IIS and could brows website from another pc correctly. but it has a big problem . the website is not enable to connect to SQL database. How can I fix it ? thx a lot,

      www.behzadi.net

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

      We have no idea. If IIS is serving the page, then the only thing that should matter is that the server can see SQL Server, the computer you use to browse the site should be irrelevant. I suspect you need to provide more details of what's happening, errors you see, etc. If you see an error telling you to change your settings so you can see detailed errors, please just do that first, don't post it.

      Christian Graus - Microsoft MVP - C++ "also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )

      A 1 Reply Last reply
      0
      • C Christian Graus

        We have no idea. If IIS is serving the page, then the only thing that should matter is that the server can see SQL Server, the computer you use to browse the site should be irrelevant. I suspect you need to provide more details of what's happening, errors you see, etc. If you see an error telling you to change your settings so you can see detailed errors, please just do that first, don't post it.

        Christian Graus - Microsoft MVP - C++ "also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )

        A Offline
        A Offline
        amin_behzadi
        wrote on last edited by
        #4

        if I catch the error no message occured but when I do not catch the code I just see "the page can not be displayed...!" message.

        www.behzadi.net

        S G 2 Replies Last reply
        0
        • A amin_behzadi

          if I catch the error no message occured but when I do not catch the code I just see "the page can not be displayed...!" message.

          www.behzadi.net

          S Offline
          S Offline
          Sonia Gupta
          wrote on last edited by
          #5

          did u run the aspnet_regiis -i in the vs 2005 command prompt

          Soniagupta1@yahoo.co.in Yahoo Messenger Id = soniagupta1

          A I 2 Replies Last reply
          0
          • S Sonia Gupta

            did u run the aspnet_regiis -i in the vs 2005 command prompt

            Soniagupta1@yahoo.co.in Yahoo Messenger Id = soniagupta1

            A Offline
            A Offline
            amin_behzadi
            wrote on last edited by
            #6

            of course I did run aspnet_regiis.exe I can brows website and can see my page layout but no data from database shown in webpage...

            www.behzadi.net

            1 Reply Last reply
            0
            • S Sonia Gupta

              did u run the aspnet_regiis -i in the vs 2005 command prompt

              Soniagupta1@yahoo.co.in Yahoo Messenger Id = soniagupta1

              I Offline
              I Offline
              InsDev
              wrote on last edited by
              #7

              how it is possible that u r giving the solution to other. Do u think so sonia. Not do again. Devjit Das.

              S 1 Reply Last reply
              0
              • I InsDev

                how it is possible that u r giving the solution to other. Do u think so sonia. Not do again. Devjit Das.

                S Offline
                S Offline
                Sonia Gupta
                wrote on last edited by
                #8

                Sir, just trying to do it.It's all ur knowledge , which i share with others

                Soniagupta1@yahoo.co.in Yahoo Messenger Id = soniagupta1

                1 Reply Last reply
                0
                • A amin_behzadi

                  if I catch the error no message occured but when I do not catch the code I just see "the page can not be displayed...!" message.

                  www.behzadi.net

                  G Offline
                  G Offline
                  Guffa
                  wrote on last edited by
                  #9

                  Disable "show friendly http error messages" in the settings in your browser, so that you see the real error message that the server sends.

                  --- "Anything that is in the world when you're born is normal and ordinary and is just a natural part of the way the world works. Anything that's invented between when you're fifteen and thirty-five is new and exciting and revolutionary and you can probably get a career in it. Anything invented after you're thirty-five is against the natural order of things." -- Douglas Adams

                  A 1 Reply Last reply
                  0
                  • A amin_behzadi

                    Hi dears, I want to test my website on my workgroup network . Then I created a virtual directory in IIS and could brows website from another pc correctly. but it has a big problem . the website is not enable to connect to SQL database. How can I fix it ? thx a lot,

                    www.behzadi.net

                    U Offline
                    U Offline
                    Unknown Ajanabi
                    wrote on last edited by
                    #10

                    u can try 2 rule may be solve 1. u create ip address of your system and domain and then acscess another pc through Ip address like http://192.168.1.45/\[directoryname\]/default.aspx no knowledge in .net

                    1 Reply Last reply
                    0
                    • A amin_behzadi

                      Hi dears, I want to test my website on my workgroup network . Then I created a virtual directory in IIS and could brows website from another pc correctly. but it has a big problem . the website is not enable to connect to SQL database. How can I fix it ? thx a lot,

                      www.behzadi.net

                      P Offline
                      P Offline
                      Paul Conrad
                      wrote on last edited by
                      #11

                      furza_milan wrote:

                      the website is not enable to connect to SQL database

                      Can you be more specific? What error is coming up?

                      "Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon

                      1 Reply Last reply
                      0
                      • A amin_behzadi

                        Hi dears, I want to test my website on my workgroup network . Then I created a virtual directory in IIS and could brows website from another pc correctly. but it has a big problem . the website is not enable to connect to SQL database. How can I fix it ? thx a lot,

                        www.behzadi.net

                        B Offline
                        B Offline
                        Braulio Dez
                        wrote on last edited by
                        #12

                        Mmmm... maybe this sounds a bit silly but... are you trying to connect to the database using Windows Authentication or SQL Server Authentication? For a web app I would use a custom SQL Server login (more info: http://www.connectionstrings.com). HTH

                        /// -------------------------      Braulio Díez      tipsdotnet.com /// -------------------------

                        1 Reply Last reply
                        0
                        • G Guffa

                          Disable "show friendly http error messages" in the settings in your browser, so that you see the real error message that the server sends.

                          --- "Anything that is in the world when you're born is normal and ordinary and is just a natural part of the way the world works. Anything that's invented between when you're fifteen and thirty-five is new and exciting and revolutionary and you can probably get a career in it. Anything invented after you're thirty-five is against the natural order of things." -- Douglas Adams

                          A Offline
                          A Offline
                          amin_behzadi
                          wrote on last edited by
                          #13

                          I did it , and the error "Login failed for user 'myName\ASPNET' " appeared, I did grant full permissions to ASPNET user for website directory and tested both "windows integrity" and "SQL Server integrity" settings in IIS . but still the error is shown ...

                          www.behzadi.net

                          G 1 Reply Last reply
                          0
                          • A amin_behzadi

                            I did it , and the error "Login failed for user 'myName\ASPNET' " appeared, I did grant full permissions to ASPNET user for website directory and tested both "windows integrity" and "SQL Server integrity" settings in IIS . but still the error is shown ...

                            www.behzadi.net

                            G Offline
                            G Offline
                            Guffa
                            wrote on last edited by
                            #14

                            For integrated authentication to work, you have to add the ASPNET user in the database server, so that the database server knows about the ASPNET user account. Alternatively, you can use SQL Server authentication instead.

                            Experience is the sum of all the mistakes you have done.

                            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