SQL2005 - don't see my database when I use VPN-connection

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • lieven.becue@gmail.com
    #1

    SQL2005 - don't see my database when I use VPN-connection

    Situation: at work we have a windows 2003 server with MS sql server
    2005 express. With my pc at work, I can see my own database I created.
    At home. I can connect with VPN to the network. With extern desktop I
    can see the database and do everything. Now I want to create a login
    with visual web developer 2005 express. But when I try to login with
    sql server authentication I don't see any database. When I try windows
    authentication, I have connection with the master, model, msdb and
    tempdb but not my own database. I am very sure at work I could create
    the login and the permissions were OK.

    Thanks

    Tags: None
    • Helmut Woess
      #2
      Re: SQL2005 - don't see my database when I use VPN-connection

      Am 27 Oct 2006 10:03:55 -0700 schrieb lieven.becue@gm ail.com:
      Situation: at work we have a windows 2003 server with MS sql server
      2005 express. With my pc at work, I can see my own database I created.
      At home. I can connect with VPN to the network. With extern desktop I
      can see the database and do everything. Now I want to create a login
      with visual web developer 2005 express. But when I try to login with
      sql server authentication I don't see any database. When I try windows
      authentication, I have connection with the master, model, msdb and
      tempdb but not my own database. I am very sure at work I could create
      the login and the permissions were OK.
      >
      Thanks
      As i know this is one of the restrictions in Express Editions - you can
      connect to local or remote servers, but with the tools in Express versions
      you can only manage local databases.

      bye,
      Helmut

        Comment

        • jgeissman@socal.rr.com
          #3
          Re: SQL2005 - don't see my database when I use VPN-connection

          I installed 2005 clients a few months ago (using servers on
          my employer's network through VPN), and just recently
          installed Express on my home machine. Should I expect
          any issues using that? So far, I haven't had any problems
          connecting Management Studio to either servers on the
          network, or to the local Express installation. Will any
          limitations on SQL Express cause problems?

          Thanks,
          Jim

            Comment

            • Helmut Woess
              #4
              Re: SQL2005 - don't see my database when I use VPN-connection

              Am 29 Oct 2006 20:53:43 -0800 schrieb jgeissman@socal .rr.com:
              I installed 2005 clients a few months ago (using servers on
              my employer's network through VPN), and just recently
              installed Express on my home machine. Should I expect
              any issues using that? So far, I haven't had any problems
              connecting Management Studio to either servers on the
              network, or to the local Express installation. Will any
              limitations on SQL Express cause problems?
              >
              Thanks,
              Jim
              The limitations are in Visual Web Developer Express and have nothing to do
              with your local SQL Express or Management Studio. If you want to manage a
              remore server from within Web Developer you have to buy Web Developer Pro.

              bye,
              Helmut

                Comment

                Previous template Next
                Working...