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

    what is the error?

    Sathiya

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

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

    Sathiya

    R 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

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

      stil i get the error like "login failed"

      S 1 Reply Last reply
      0
      • 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