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. Data base connectivity

Data base connectivity

Scheduled Pinned Locked Moved ASP.NET
databasecsharpasp-netsql-serversysadmin
23 Posts 5 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.
  • S Sathiyaraj Ganesan

    Data Source=(Server Name/IP/PC Name);Initial Catalog=(DB Name);Integrated Security=True

    Sathiya

    R Offline
    R Offline
    Reethika
    wrote on last edited by
    #8

    am getting the error like "only elements are allowed"

    1 Reply Last reply
    0
    • S SathyaSiva

      Use like this Server=SERVER;Database=ABC;Uid=sa; PWD=12; Connect Timeout=360; pooling=true; Max Pool Size=200

      Sathya

      S Offline
      S Offline
      Sathiyaraj Ganesan
      wrote on last edited by
      #9

      Understand the question first dear... If it's "Windows Authentication". There'll be no Uid/pwd. Setting -"Integrated Secruity" to "True/SSPI" will solve the problem.

      Sathiya

      1 Reply Last reply
      0
      • R Reethika

        stil i get the error like "login failed"

        S Offline
        S Offline
        Sathiyaraj Ganesan
        wrote on last edited by
        #10

        Now Start->SQLserver Mgmt Studio-> Login using Windows Authentication. Check whether you can able to connect.

        Sathiya

        1 Reply Last reply
        0
        • R Reethika

          My sql server is connected thro windows authentication, how to connect these DB in asp.net

          A Offline
          A Offline
          Arindam Tewary
          wrote on last edited by
          #11

          Someone shoud be invited to your place so that you can get it done ... otherwise seems connecting to DB is too hard for you .... LOL !! You should have known whats Sql Server authentication and Windows Authentication ..... if you dont read or gather any knowledge ... 1000 posts will be null and void !!!! :-D Try to read something at least ....

          Thanks, Arindam D Tewary

          S R 2 Replies Last reply
          0
          • A Arindam Tewary

            Someone shoud be invited to your place so that you can get it done ... otherwise seems connecting to DB is too hard for you .... LOL !! You should have known whats Sql Server authentication and Windows Authentication ..... if you dont read or gather any knowledge ... 1000 posts will be null and void !!!! :-D Try to read something at least ....

            Thanks, Arindam D Tewary

            S Offline
            S Offline
            Sathiyaraj Ganesan
            wrote on last edited by
            #12

            Don't degrade others. If they are learning phase.

            Sathiya

            R 1 Reply Last reply
            0
            • A Arindam Tewary

              Someone shoud be invited to your place so that you can get it done ... otherwise seems connecting to DB is too hard for you .... LOL !! You should have known whats Sql Server authentication and Windows Authentication ..... if you dont read or gather any knowledge ... 1000 posts will be null and void !!!! :-D Try to read something at least ....

              Thanks, Arindam D Tewary

              R Offline
              R Offline
              Reethika
              wrote on last edited by
              #13

              i know the diff between both, I doesn't need any of ur advice.

              S A 2 Replies Last reply
              0
              • S Sathiyaraj Ganesan

                Don't degrade others. If they are learning phase.

                Sathiya

                R Offline
                R Offline
                Reethika
                wrote on last edited by
                #14

                Thank u very much for ur words

                S 1 Reply Last reply
                0
                • R Reethika

                  Thank u very much for ur words

                  S Offline
                  S Offline
                  Sathiyaraj Ganesan
                  wrote on last edited by
                  #15

                  Problem is solved or not.

                  Sathiya

                  1 Reply Last reply
                  0
                  • R Reethika

                    i know the diff between both, I doesn't need any of ur advice.

                    S Offline
                    S Offline
                    SathyaSiva
                    wrote on last edited by
                    #16

                    Rathi don't get tension try surly u will solve the problem

                    Sathya

                    A 1 Reply Last reply
                    0
                    • R Reethika

                      i know the diff between both, I doesn't need any of ur advice.

                      A Offline
                      A Offline
                      Arindam Tewary
                      wrote on last edited by
                      #17

                      It does't make any differece if you dont use your knowledge while working. and specilly if question reflects other thing !! Anyway ... happy coding and posting ..... you can again ignore this advice also .. :laugh:

                      Thanks, Arindam D Tewary

                      1 Reply Last reply
                      0
                      • R Reethika

                        My sql server is connected thro windows authentication, how to connect these DB in asp.net

                        A Offline
                        A Offline
                        Abhijit Jana
                        wrote on last edited by
                        #18

                        Hi Reethika, before posting such questuions and spamming the sites try to search google or read some book. please have a look How To: Connect to SQL Server Using Windows Authentication in ASP.NET 2.0[^]

                        Best Regards ----------------- Abhijit Jana Check Out My Latest Article Java.NET : Integration of Java and .NET[^] "Success is Journey it's not a destination"

                        1 Reply Last reply
                        0
                        • S SathyaSiva

                          Rathi don't get tension try surly u will solve the problem

                          Sathya

                          A Offline
                          A Offline
                          Abhijit Jana
                          wrote on last edited by
                          #19

                          SathyaSiva wrote:

                          Rathi don't get tension try surly u will solve the problem

                          This is not a Chat Forum.

                          Best Regards ----------------- Abhijit Jana Check Out My Latest Article Java.NET : Integration of Java and .NET[^] "Success is Journey it's not a destination"

                          S 1 Reply Last reply
                          0
                          • A Abhijit Jana

                            SathyaSiva wrote:

                            Rathi don't get tension try surly u will solve the problem

                            This is not a Chat Forum.

                            Best Regards ----------------- Abhijit Jana Check Out My Latest Article Java.NET : Integration of Java and .NET[^] "Success is Journey it's not a destination"

                            S Offline
                            S Offline
                            SathyaSiva
                            wrote on last edited by
                            #20

                            u also use this like chat

                            Sathya

                            A A 3 Replies Last reply
                            0
                            • S SathyaSiva

                              u also use this like chat

                              Sathya

                              A Offline
                              A Offline
                              Abhijit Jana
                              wrote on last edited by
                              #21

                              Please Dont spam this site.

                              Best Regards ----------------- Abhijit Jana Check Out My Latest Article Java.NET : Integration of Java and .NET[^] "Success is Journey it's not a destination"

                              1 Reply Last reply
                              0
                              • S SathyaSiva

                                u also use this like chat

                                Sathya

                                A Offline
                                A Offline
                                Arindam Tewary
                                wrote on last edited by
                                #22

                                Awesome !!! :-\ :confused::~:confused::confused:

                                Thanks, Arindam D Tewary

                                1 Reply Last reply
                                0
                                • S SathyaSiva

                                  u also use this like chat

                                  Sathya

                                  A Offline
                                  A Offline
                                  Arindam Tewary
                                  wrote on last edited by
                                  #23

                                  Please dont misuse a good and healthy forum for your sick mentality. Its annoying that you want to chat here.:mad::mad:

                                  Thanks, Arindam D Tewary

                                  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