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

Oct 27 '06 #1

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

Oct 28 '06 #2

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

Oct 30 '06 #3

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

Oct 30 '06 #4