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. General Programming
  3. Visual Studio
  4. Visual Studio 2005,SQL Data source configuration problem

Visual Studio 2005,SQL Data source configuration problem

Scheduled Pinned Locked Moved Visual Studio
databasehelpcsharpsql-servervisual-studio
12 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.
  • A amit2011

    I am using Visual Studio 2005 and SQL Server 2005+SQL Server MAnagement Studio 2005.i m using Windows Vista home. when in "SQL Data source" i configure it ,then after selecting "NewConnection", i select "Sql Client". then select the Server (.). But then in the "Database" Dropdownlist,I couldnt find any of the databases i had made SQL Server MAnagement Studio 2005. i am new to SQL Server 2005.Please help me out... thanx in advance

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

    You may want to check and see if the SQL Server Browser service is running or not. If it is, check firewalls, etc.

    "The clue train passed his station without stopping." - John Simmons / outlaw programmer "Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon "Not only do you continue to babble nonsense, you can't even correctly remember the nonsense you babbled just minutes ago." - Rob Graham

    A 1 Reply Last reply
    0
    • P Paul Conrad

      You may want to check and see if the SQL Server Browser service is running or not. If it is, check firewalls, etc.

      "The clue train passed his station without stopping." - John Simmons / outlaw programmer "Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon "Not only do you continue to babble nonsense, you can't even correctly remember the nonsense you babbled just minutes ago." - Rob Graham

      A Offline
      A Offline
      amit2011
      wrote on last edited by
      #3

      How to check that SQL Server Browser service is running or not.please explain it in detail m a bit new to it..thanx

      P 1 Reply Last reply
      0
      • A amit2011

        How to check that SQL Server Browser service is running or not.please explain it in detail m a bit new to it..thanx

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

        Go into Adminstrative Tools in the Control Panel, click on the Services icon.

        "The clue train passed his station without stopping." - John Simmons / outlaw programmer "Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon "Not only do you continue to babble nonsense, you can't even correctly remember the nonsense you babbled just minutes ago." - Rob Graham

        A 1 Reply Last reply
        0
        • P Paul Conrad

          Go into Adminstrative Tools in the Control Panel, click on the Services icon.

          "The clue train passed his station without stopping." - John Simmons / outlaw programmer "Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon "Not only do you continue to babble nonsense, you can't even correctly remember the nonsense you babbled just minutes ago." - Rob Graham

          A Offline
          A Offline
          amit2011
          wrote on last edited by
          #5

          hey paul ..i cant find it in Control panel.please tell me in detail..sorry for the trouble,but i really need it..

          P 1 Reply Last reply
          0
          • A amit2011

            hey paul ..i cant find it in Control panel.please tell me in detail..sorry for the trouble,but i really need it..

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

            amit2011 wrote:

            i cant find it in Control panel

            :wtf: It is one of the first things you should see. Are you in classic view for Control Panel? If not so, you need to switch to it.

            "The clue train passed his station without stopping." - John Simmons / outlaw programmer "Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon "Not only do you continue to babble nonsense, you can't even correctly remember the nonsense you babbled just minutes ago." - Rob Graham

            A 1 Reply Last reply
            0
            • P Paul Conrad

              amit2011 wrote:

              i cant find it in Control panel

              :wtf: It is one of the first things you should see. Are you in classic view for Control Panel? If not so, you need to switch to it.

              "The clue train passed his station without stopping." - John Simmons / outlaw programmer "Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon "Not only do you continue to babble nonsense, you can't even correctly remember the nonsense you babbled just minutes ago." - Rob Graham

              A Offline
              A Offline
              amit2011
              wrote on last edited by
              #7

              i am using windows Vista home..i am in Control Panel,but there is on Option for "Services"..??

              P 1 Reply Last reply
              0
              • A amit2011

                i am using windows Vista home..i am in Control Panel,but there is on Option for "Services"..??

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

                amit2011 wrote:

                in Control Panel,but there is on Option for "Services"..?? Quote Selected Text

                Services is in the option called Administrative Tools. All versions of Vista have it.

                "The clue train passed his station without stopping." - John Simmons / outlaw programmer "Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon "Not only do you continue to babble nonsense, you can't even correctly remember the nonsense you babbled just minutes ago." - Rob Graham

                A 1 Reply Last reply
                0
                • P Paul Conrad

                  amit2011 wrote:

                  in Control Panel,but there is on Option for "Services"..?? Quote Selected Text

                  Services is in the option called Administrative Tools. All versions of Vista have it.

                  "The clue train passed his station without stopping." - John Simmons / outlaw programmer "Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon "Not only do you continue to babble nonsense, you can't even correctly remember the nonsense you babbled just minutes ago." - Rob Graham

                  A Offline
                  A Offline
                  amit2011
                  wrote on last edited by
                  #9

                  ya i found it..tell me if i have to set the"SQL SErver Browser " to Automatic..?? thanx

                  P 1 Reply Last reply
                  0
                  • A amit2011

                    ya i found it..tell me if i have to set the"SQL SErver Browser " to Automatic..?? thanx

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

                    You need to open up the properties for it and take it from there. I would suggest setting to automatic.

                    "The clue train passed his station without stopping." - John Simmons / outlaw programmer "Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon "Not only do you continue to babble nonsense, you can't even correctly remember the nonsense you babbled just minutes ago." - Rob Graham

                    A 1 Reply Last reply
                    0
                    • P Paul Conrad

                      You need to open up the properties for it and take it from there. I would suggest setting to automatic.

                      "The clue train passed his station without stopping." - John Simmons / outlaw programmer "Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon "Not only do you continue to babble nonsense, you can't even correctly remember the nonsense you babbled just minutes ago." - Rob Graham

                      A Offline
                      A Offline
                      amit2011
                      wrote on last edited by
                      #11

                      i did that as well..but i still cant find the databases in that DropdownList of "Databases"..?? please help..

                      A 1 Reply Last reply
                      0
                      • A amit2011

                        i did that as well..but i still cant find the databases in that DropdownList of "Databases"..?? please help..

                        A Offline
                        A Offline
                        amit2011
                        wrote on last edited by
                        #12

                        after what u told..i am able to get in the "ServerName", (PC_Name\SQLEXPRESS).. when i select it i am able to get the Databases. Initialy in Sql Server 2000, i uesd to set "ServerName" as (.)dot. can i use the (PC_Name\SQLEXPRESS) as my servername? how will it effect my funtionalities..? thanx

                        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