Cannot connect to Local SQL Server

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Mark Lewis
    #1

    Cannot connect to Local SQL Server

    I am having trouble connecting to my local sql server from either the Server
    Explorer or vb.net code. The problem is connected to the Norton Internet
    Security 2005 Firewall as when I disable Norton everything works and if
    Norton is enabled but the PC is not plugged into the network it also works.

    When I am connected to the network the Firewall does pop up asking whether
    or not I want to allow my vb.net program to access a DNS. I have tried using
    localhost, the hardcoded IP of my machine, and my machine name (the usual
    method) without any success. It is as if Visual Studio always tries to
    resolve the machine name and cannot. VB6 programs ,dbArtisan, and SQL
    Enterprise Manager all work fine at the same time Visual Studio/VB.Net does
    not.

    Any ideas?

    Thanks,

    Mark Lewis
    mdlewis@mdlewis .com

    P.S I am using the latest production/old Visual Studio and SQL Server on XP
    with all SP applied.


    Tags: None
    • Nick Malik [Microsoft]
      #2
      Re: Cannot connect to Local SQL Server

      here's an idea: configure the Norton product so that your machine can access
      DNS.

      --
      --- Nick Malik [Microsoft]
      MCSD, CFPS, Certified Scrummaster
      http://blogs.msdn.com/nickmalik

      Disclaimer: Opinions expressed in this forum are my own, and not
      representative of my employer.
      I do not answer questions on behalf of my employer. I'm just a
      programmer helping programmers.
      --
      "Mark Lewis" <mdlewis@mdlewi s.com> wrote in message
      news:u$P2swmHFH A.3336@TK2MSFTN GP10.phx.gbl...[color=blue]
      >I am having trouble connecting to my local sql server from either the
      >Server Explorer or vb.net code. The problem is connected to the Norton
      >Internet Security 2005 Firewall as when I disable Norton everything works
      >and if Norton is enabled but the PC is not plugged into the network it also
      >works.
      >
      > When I am connected to the network the Firewall does pop up asking whether
      > or not I want to allow my vb.net program to access a DNS. I have tried
      > using localhost, the hardcoded IP of my machine, and my machine name (the
      > usual method) without any success. It is as if Visual Studio always tries
      > to resolve the machine name and cannot. VB6 programs ,dbArtisan, and SQL
      > Enterprise Manager all work fine at the same time Visual Studio/VB.Net
      > does not.
      >
      > Any ideas?
      >
      > Thanks,
      >
      > Mark Lewis
      > mdlewis@mdlewis .com
      >
      > P.S I am using the latest production/old Visual Studio and SQL Server on
      > XP with all SP applied.
      >[/color]


        Comment

        • Mark Lewis
          #3
          Re: Cannot connect to Local SQL Server

          Resubmitting this with my new MSDN Alias.

          Thanks,

          Mark Lewis
          mdlewis@mdlewis .com
          "Mark Lewis" <mdlewis@mdlewi s.com> wrote in message
          news:u$P2swmHFH A.3336@TK2MSFTN GP10.phx.gbl...[color=blue]
          >I am having trouble connecting to my local sql server from either the
          >Server Explorer or vb.net code. The problem is connected to the Norton
          >Internet Security 2005 Firewall as when I disable Norton everything works
          >and if Norton is enabled but the PC is not plugged into the network it also
          >works.
          >
          > When I am connected to the network the Firewall does pop up asking whether
          > or not I want to allow my vb.net program to access a DNS. I have tried
          > using localhost, the hardcoded IP of my machine, and my machine name (the
          > usual method) without any success. It is as if Visual Studio always tries
          > to resolve the machine name and cannot. VB6 programs ,dbArtisan, and SQL
          > Enterprise Manager all work fine at the same time Visual Studio/VB.Net
          > does not.
          >
          > Any ideas?
          >
          > Thanks,
          >
          > Mark Lewis
          > mdlewis@mdlewis .com
          >
          > P.S I am using the latest production/old Visual Studio and SQL Server on
          > XP with all SP applied.
          >[/color]


            Comment

            • Mark Lewis
              #4
              Re: Cannot connect to Local SQL Server

              Resubmitting this with my new MSDN Alias to qualify for support.

              Thanks and sorry about the double post,

              Mark Lewis
              mdlewis@mdlewis .com
              "Mark Lewis" <mdlewis@mdlewi s.com> wrote in message
              news:u$P2swmHFH A.3336@TK2MSFTN GP10.phx.gbl...[color=blue]
              >I am having trouble connecting to my local sql server from either the
              >Server Explorer or vb.net code. The problem is connected to the Norton
              >Internet Security 2005 Firewall as when I disable Norton everything works
              >and if Norton is enabled but the PC is not plugged into the network it also
              >works.
              >
              > When I am connected to the network the Firewall does pop up asking whether
              > or not I want to allow my vb.net program to access a DNS. I have tried
              > using localhost, the hardcoded IP of my machine, and my machine name (the
              > usual method) without any success. It is as if Visual Studio always tries
              > to resolve the machine name and cannot. VB6 programs ,dbArtisan, and SQL
              > Enterprise Manager all work fine at the same time Visual Studio/VB.Net
              > does not.
              >
              > Any ideas?
              >
              > Thanks,
              >
              > Mark Lewis
              > mdlewis@mdlewis .com
              >
              > P.S I am using the latest production/old Visual Studio and SQL Server on
              > XP with all SP applied.
              >[/color]


                Comment

                Previous template Next
                Working...