Can't connect to SQL Server(SQL Express) in VS 2005

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • danofweaver@googlemail.com

    Can't connect to SQL Server(SQL Express) in VS 2005


    In SQL Server Configuration Manager I apparantly have a server named
    SQL Server(SQL Express) running - however, in VS 2005 when I try to
    'add conection' (right click in server explorer) I cant see it- I
    would like to see it so I can create a new SQL server database.

    Any help much appreciated- trying to learn web programming using
    vb.net, asp, html, vbscript and SQL server.

    D

  • David Browne

    #2
    Re: Can't connect to SQL Server(SQL Express) in VS 2005



    <danofweaver@go oglemail.comwro te in message
    news:1171043799 .150848.68200@v 45g2000cwv.goog legroups.com...
    >
    In SQL Server Configuration Manager I apparantly have a server named
    SQL Server(SQL Express) running - however, in VS 2005 when I try to
    'add conection' (right click in server explorer) I cant see it- I
    would like to see it so I can create a new SQL server database.
    >
    Any help much appreciated- trying to learn web programming using
    vb.net, asp, html, vbscript and SQL server.
    >
    Type

    (local)\sqlexpr ess

    in the "Server name" box on the "Add Connection" dialog.

    David

    Comment

    • Tiago Salgado

      #3
      Re: Can't connect to SQL Server(SQL Express) in VS 2005

      Check if SQL Services are running.

      --

      Tiago Salgado



      Website da comunidade Portugal-a-Programar, a comunidade portuguesa de programação. Fórum de discussão de temas relacionados com programação e informática em geral, Portal de Downloads, Blogs, Wiki e Revista Programar.

      Portal da Revista PROGRAMAR, a revista portuguesa de programação


      "David Browne" <davidbaxterbro wne no potted meat@hotmail.co mwrote in
      message news:%23Uk8O4HT HHA.2212@TK2MSF TNGP02.phx.gbl. ..
      >
      >
      <danofweaver@go oglemail.comwro te in message
      news:1171043799 .150848.68200@v 45g2000cwv.goog legroups.com...
      >>
      >In SQL Server Configuration Manager I apparantly have a server named
      >SQL Server(SQL Express) running - however, in VS 2005 when I try to
      >'add conection' (right click in server explorer) I cant see it- I
      >would like to see it so I can create a new SQL server database.
      >>
      >Any help much appreciated- trying to learn web programming using
      >vb.net, asp, html, vbscript and SQL server.
      >>
      >
      Type
      >
      (local)\sqlexpr ess
      >
      in the "Server name" box on the "Add Connection" dialog.
      >
      David
      >

      Comment

      • punjab_tom

        #4
        Re: Can't connect to SQL Server(SQL Express) in VS 2005

        sorry bud

        Microsoft killed VB so you WON'T be using VbScript to say the least :)

        I do not know why your SQL Server won't work.
        my laptop won't install SQL 2005 Express because those dipshits didn't
        think that it was important to include support for transmeta

        kinda laughable in my opinion

        I mean; the Xbox portable is built using Transmeta chips.. right??

        Comment

        • punjab_tom

          #5
          Re: Can't connect to SQL Server(SQL Express) in VS 2005

          sorry bud
          did you really name your server 'sql server'?

          I would really avoid putting a space in the machine name; I would try
          127.0.0.1\sqlex press instead

          Microsoft killed VB so you WON'T be using VbScript to say the least :)

          I do not know why your SQL Server won't work.
          my laptop won't install SQL 2005 Express because those dipshits didn't
          think that it was important to include support for transmeta

          kinda laughable in my opinion

          I mean; the Xbox portable is built using Transmeta chips.. right??

          Comment

          • Bruce W. Darby

            #6
            Re: Can't connect to SQL Server(SQL Express) in VS 2005

            So MS is supposed to support YOUR laptop? And you are??? Oh, yeah, Aaron
            Kempf... that's right.... I've heard of you... ain't you the fellow that
            programs in Access, but can't stand using a standard Access database format?

            Bruce

            "punjab_tom " <punjab_tom@hot mail.comwrote in message
            news:1171071293 .848321.185810@ m58g2000cwm.goo glegroups.com.. .
            sorry bud
            >
            Microsoft killed VB so you WON'T be using VbScript to say the least :)
            >
            I do not know why your SQL Server won't work.
            my laptop won't install SQL 2005 Express because those dipshits didn't
            think that it was important to include support for transmeta
            >
            kinda laughable in my opinion
            >
            I mean; the Xbox portable is built using Transmeta chips.. right??
            >

            Comment

            • Bruce W. Darby

              #7
              Re: Can't connect to SQL Server(SQL Express) in VS 2005

              Hmmm...
              Microsoft killed VB so you WON'T be using VbScript to say the least :)
              When did they kill it Aaron???? When they fired you??? Or was it when you
              figured out that you can't tell the difference between VB Classic and
              VB.Net?


              Comment

              • RobinS

                #8
                Re: Can't connect to SQL Server(SQL Express) in VS 2005

                Bruce,

                I don't want to be critical, but you actually think he *programs* in
                Access? All he does is link up datatables and tell his users to write their
                own queries. Have you started drinking yet? ;-)

                Robin S.
                King of Russia
                ---------------------------------------------------
                "Bruce W. Darby" <kracorat@atcom cast.netwrote in message
                news:F62dnUxM3c NrtVDYnZ2dnUVZ_ vCknZ2d@comcast .com...
                So MS is supposed to support YOUR laptop? And you are??? Oh, yeah, Aaron
                Kempf... that's right.... I've heard of you... ain't you the fellow that
                programs in Access, but can't stand using a standard Access database
                format?
                >
                Bruce
                >
                "punjab_tom " <punjab_tom@hot mail.comwrote in message
                news:1171071293 .848321.185810@ m58g2000cwm.goo glegroups.com.. .
                >sorry bud
                >>
                >Microsoft killed VB so you WON'T be using VbScript to say the least :)
                >>
                >I do not know why your SQL Server won't work.
                >my laptop won't install SQL 2005 Express because those dipshits didn't
                >think that it was important to include support for transmeta
                >>
                >kinda laughable in my opinion
                >>
                >I mean; the Xbox portable is built using Transmeta chips.. right??
                >>
                >
                >

                Comment

                • RobinS

                  #9
                  Re: Can't connect to SQL Server(SQL Express) in VS 2005


                  "Bruce W. Darby" <kracorat@atcom cast.netwrote in message
                  news:fMednT0ddP TmtFDYnZ2dnUVZ_ silnZ2d@comcast .com...
                  Hmmm...
                  >
                  >Microsoft killed VB so you WON'T be using VbScript to say the least :)
                  >
                  When did they kill it Aaron???? When they fired you??? Or was it when you
                  figured out that you can't tell the difference between VB Classic and
                  VB.Net?
                  >
                  >
                  It was when they figured out he couldn't tell the difference between VB6,
                  VBA, and VBScript!

                  ROFL.

                  Robin S.
                  (King of Russia)


                  Comment

                  • Bruce W. Darby

                    #10
                    Re: Can't connect to SQL Server(SQL Express) in VS 2005

                    His words, not mine. :)
                    And I'm thinking seriously of doing so. LOL

                    "RobinS" <RobinS@NoSpam. yah.nonewrote in message
                    news:F_udnYQuHd se-FDYnZ2dnUVZ_q-vnZ2d@comcast.c om...
                    Bruce,
                    >
                    I don't want to be critical, but you actually think he *programs* in
                    Access? All he does is link up datatables and tell his users to write
                    their own queries. Have you started drinking yet? ;-)
                    >
                    Robin S.
                    King of Russia
                    ---------------------------------------------------
                    "Bruce W. Darby" <kracorat@atcom cast.netwrote in message
                    news:F62dnUxM3c NrtVDYnZ2dnUVZ_ vCknZ2d@comcast .com...
                    >So MS is supposed to support YOUR laptop? And you are??? Oh, yeah, Aaron
                    >Kempf... that's right.... I've heard of you... ain't you the fellow that
                    >programs in Access, but can't stand using a standard Access database
                    >format?
                    >>
                    >Bruce
                    >>
                    >"punjab_tom " <punjab_tom@hot mail.comwrote in message
                    >news:117107129 3.848321.185810 @m58g2000cwm.go oglegroups.com. ..
                    >>sorry bud
                    >>>
                    >>Microsoft killed VB so you WON'T be using VbScript to say the least :)
                    >>>
                    >>I do not know why your SQL Server won't work.
                    >>my laptop won't install SQL 2005 Express because those dipshits didn't
                    >>think that it was important to include support for transmeta
                    >>>
                    >>kinda laughable in my opinion
                    >>>
                    >>I mean; the Xbox portable is built using Transmeta chips.. right??
                    >>>
                    >>
                    >>
                    >
                    >

                    Comment

                    • danofweaver@googlemail.com

                      #11
                      Re: Can't connect to SQL Server(SQL Express) in VS 2005

                      On Feb 9, 2:11 pm, "David Browne" <davidbaxterbro wne no potted
                      m...@hotmail.co mwrote:
                      <danofwea...@go oglemail.comwro te in message
                      >
                      news:1171043799 .150848.68200@v 45g2000cwv.goog legroups.com...
                      >
                      >
                      >
                      In SQL Server Configuration Manager I apparantly have a server named
                      SQL Server(SQL Express) running - however, in VS 2005 when I try to
                      'add conection' (right click in server explorer) I cant see it- I
                      would like to see it so I can create a new SQL server database.
                      >
                      Any help much appreciated- trying to learn web programming using
                      vb.net, asp, html, vbscript and SQL server.
                      >
                      Type
                      >
                      (local)\sqlexpr ess
                      >
                      in the "Server name" box on the "Add Connection" dialog.
                      >
                      David

                      Thanks all for an entertaining and (sometimes informative!-)
                      discussion.
                      ..\SQLEXPRESS in add data (after right clicking server explorer for new
                      connection) worked a treat.

                      Thanks again,

                      Dan

                      Comment

                      Working...