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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

lieven.becue@gmail.com - 27 Oct 2006 18:03 GMT

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

Reply to this Message

Helmut Woess - 28 Oct 2006 11:27 GMT

Am 27 Oct 2006 10:03:55 -0700 schrieb lieven.becue@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.
[quoted text clipped - 7 lines]
>
> 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

Reply to this Message

jgeissman@socal.rr.com - 30 Oct 2006 05:53 GMT

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

Reply to this Message

Helmut Woess - 30 Oct 2006 08:07 GMT

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
[quoted text clipped - 6 lines]
> 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

Reply to this Message