467,920 Members | 1,225 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 467,920 developers. It's quick & easy.

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

Oct 27 '06 #1
  • viewed: 1609
Share:
3 Replies
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
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
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

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

9 posts views Thread by Nemisis | last post: by
reply views Thread by barbara.plume | last post: by
2 posts views Thread by Ryan Langton | last post: by
4 posts views Thread by =?Utf-8?B?U1VOTlk=?= | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.