| Author |
 Topic  |
|
|
D3mon
Senior Member
United Kingdom
1685 Posts |
 Posted - 06 October 2003 : 17:04:55
|
Same remote server, but accessing two different databases each with their own login and password - is there no way to get them both listed in the panel on the left?
When I try it say that the server has already been registered and its a pain having to logout and login again entering the new accounts details every time...  |
Snitz 'Speedball' : Site Integration Mod : Friendly Registration Mod
"In war, the victorious strategist only seeks battle after the victory has been won" |
Edited by - ruirib on 06 October 2003 17:13:40 |
|
|
redbrad0
Advanced Member
USA
3725 Posts |
|
|
D3mon
Senior Member
United Kingdom
1685 Posts |
|
|
HuwR
Forum Admin
United Kingdom
20595 Posts |
Posted - 06 October 2003 : 17:52:38
|
Try this
In the SQL Client Network utility, create an alias for each of the two instances of the server, then in ent manager register the two aliases
(not sure if it will work) |
 |
|
|
D3mon
Senior Member
United Kingdom
1685 Posts |
Posted - 06 October 2003 : 17:59:53
|
| I've never used that util before but I'm assuming I'm creating an Alias of type TCP/IP and connection parameters of [mydbname].[hostservername] ? |
Snitz 'Speedball' : Site Integration Mod : Friendly Registration Mod
"In war, the victorious strategist only seeks battle after the victory has been won" |
|
|
|
D3mon
Senior Member
United Kingdom
1685 Posts |
|
|
D3mon
Senior Member
United Kingdom
1685 Posts |
|
|
HuwR
Forum Admin
United Kingdom
20595 Posts |
Posted - 06 October 2003 : 18:20:31
|
Congrats on the 1000 posts by the way. |
|
|
|
D3mon
Senior Member
United Kingdom
1685 Posts |
Posted - 06 October 2003 : 18:23:46
|
Thanks.
On a final note, is it possible to get it to show only a single DB, as opposed to all on that particular server? (I could be going a little too far here I guess) |
Snitz 'Speedball' : Site Integration Mod : Friendly Registration Mod
"In war, the victorious strategist only seeks battle after the victory has been won" |
|
|
|
D3mon
Senior Member
United Kingdom
1685 Posts |
|
|
HuwR
Forum Admin
United Kingdom
20595 Posts |
Posted - 06 October 2003 : 19:07:35
|
quote:
Originally posted by D3mon
Thanks.
On a final note, is it possible to get it to show only a single DB, as opposed to all on that particular server? (I could be going a little too far here I guess)
That I don't know, sorry, have never tried to hide them |
|
|
|
D3mon
Senior Member
United Kingdom
1685 Posts |
|
|
Gremlin
General Help Moderator
New Zealand
7528 Posts |
Posted - 07 October 2003 : 06:22:38
|
quote:
That I don't know, sorry, have never tried to hide them
I've looked around a bit to try and do that and so far no such luck :(. |
Kiwihosting.Net - The Forum Hosting Specialists
|
|
|
|
D3mon
Senior Member
United Kingdom
1685 Posts |
Posted - 07 October 2003 : 06:27:18
|
When I first got the DB, I was quite shocked to see everyone elses DB's listed there too.
I imagined some kind of 'drill-down' feature, like the directory path you put in when using FTP to get you straight to your root folder. |
Snitz 'Speedball' : Site Integration Mod : Friendly Registration Mod
"In war, the victorious strategist only seeks battle after the victory has been won" |
|
|
|
Doug G
Support Moderator
USA
6493 Posts |
Posted - 07 October 2003 : 13:37:54
|
As far as I know EM will always show all the DB's on a server. If you use Access as a front end you can skip the list of all the other DB's other than the one you specify in the project connection. I find myself using Access 2000 most of the time for server management tasks instead of EM.
|
======
Doug G
======
Computer history and help at www.dougscode.com |
|
|
| |
Topic |
|
Topic Locked
