| Author |
 Topic  |
|
prescottw
Junior Member
189 Posts |
 Posted - 13 September 2005 : 21:11:49
|
I'm trying to figure out how to run more than one database on Enterprise manager.
But I can only work on one then delete it, register the other then work. Delete that registration then work on the other. Any Ideas?
I am on a shared SQL server.
Thanks,
-prescottw |
What day is it anyway? |
|
|
StephenD
Senior Member
Australia
1044 Posts |
Posted - 13 September 2005 : 22:07:46
|
| I'd be interested in this too. |
 |
|
|
Doug G
Support Moderator
USA
6493 Posts |
Posted - 14 September 2005 : 00:25:09
|
You are probably seeing some restriction from your hosting company, if you run your own sql server there is no problem creating multiple databases.
|
======
Doug G
======
Computer history and help at www.dougscode.com |
|
|
|
StephenD
Senior Member
Australia
1044 Posts |
Posted - 14 September 2005 : 00:45:24
|
| My issue and I apologise if I'm hijacking this topic is that I can only register a connection to one db on my host in EM at a time. If I want to register a connection to another db on the same host say db2 I need to delete the existing registration to db1 and do the registration wizard for db2. |
|
|
|
Podge
Support Moderator
Ireland
3776 Posts |
|
|
StephenD
Senior Member
Australia
1044 Posts |
Posted - 14 September 2005 : 04:40:03
|
| Podge, Podge, Podge, bluddy brilliant! Works man.. thank you! |
|
|
|
Podge
Support Moderator
Ireland
3776 Posts |
|
|
Doug G
Support Moderator
USA
6493 Posts |
Posted - 14 September 2005 : 20:38:35
|
If you're trying to set up two registrations to the same server, you can set up aliases using the client network tool as another approach. I've never seen a problem with multiple registrations in the same server group with different servers but I haven't seen that many sql servers either :).
|
======
Doug G
======
Computer history and help at www.dougscode.com |
|
|
|
prescottw
Junior Member
189 Posts |
Posted - 15 September 2005 : 00:58:10
|
quote:
Originally posted by StephenD
My issue and I apologise if I'm hijacking this topic is that I can only register a connection to one db on my host in EM at a time. If I want to register a connection to another db on the same host say db2 I need to delete the existing registration to db1 and do the registration wizard for db2.
Quite Allright my eyes are fried. In 35 hours I've been on the computer for 28...
Anyway I couldn't get the EM to allow the same server name even with a different server group. But it's not really a BIG problem. Just a
added amount of time when tending to db related stuff.
Thank you both. Podge and StephanD.
-prescottw
|
What day is it anyway? |
|
|
|
StephenD
Senior Member
Australia
1044 Posts |
Posted - 16 September 2005 : 04:51:55
|
Since my reformat and reinstallation of EM, I can't for the life of me add multiple dbs on the same Host in EM. I set each as a top level group but EM keeps saying the SQL Server with that name already exists.
How do setup aliases with cliconfig to get around this? |
|
|
|
pdrg
Support Moderator
United Kingdom
2897 Posts |
Posted - 16 September 2005 : 06:10:16
|
| EM is about registering a server - a server can have multiple DB's |
|
|
|
StephenD
Senior Member
Australia
1044 Posts |
Posted - 16 September 2005 : 06:19:29
|
| Yes, thats ok if you have the sa login. Unfortunately, I've got 6 seperate logins one for each of my dbs on my Hosts server. |
|
|
|
pdrg
Support Moderator
United Kingdom
2897 Posts |
Posted - 16 September 2005 : 06:30:41
|
Oh bless them!
In that case, I'm not sure EM can help you...however it's not all bad news! This will mean you start to use Query Analyser (isql.exe) more, which will improve your SQL HEAPS, and you'll feel like you're getting to know SQL Server itself, as opposed to some UI tool added by the marketing department ;-) |
|
|
|
Podge
Support Moderator
Ireland
3776 Posts |
|
|
StephenD
Senior Member
Australia
1044 Posts |
Posted - 16 September 2005 : 07:14:50
|
I've got table editor somewhere, yes that could be an option.
I've only started using Query Analyser (I think it was pdrg who got me hooked on that recently) and I really like it.
OK I can connect to 2 of my dbs using the Server name for one registration and the IP address for the other registration ... so there must be a way of setting it up in cliconfig somehow or perhaps use UDLs. |
|
|
|
pdrg
Support Moderator
United Kingdom
2897 Posts |
Posted - 16 September 2005 : 07:40:55
|
OK - got it!
Using Client Network Utility - alias tab - set an alias (db1, db2, etc) and use TCP/IP - set the server IP in the server name box
Now in EM, select the alias (db1, db2, etc) as the server and enter the SQL Authentication u:p for that instance of the db
give it a try, then repeat for the other instances
hope this fixes it (ps, you were right, client network thingy was the answer!) |
|
|
|
Topic |
|
Topic Locked
