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

[lieven.becue]

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

[Helmut Woess]

Am 27 Oct 2006 10:03:55 -0700 schrieb li**********@gmail.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

[jgeissman]

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

[Helmut Woess]

Am 29 Oct 2006 20:53:43 -0800 schrieb jg*******@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