Enterprise Mgr - Register server with multiple logins?

How can I register the same SQL Server more than once in
Enterprise Manager, using multiple logins?
"A server with this name already exists."
I'd expect this to be a FAQ, but twenty minutes of
googling it has turned up precious little by way of
remedies. This should be a pretty garden-variety
situation: I need to access multiple databases on a single
SQL Server, some of which require a different login from
others. I've added a new server group for the additional
instance/connection/registration, but every attempt to
register the server returns "A server with this name
already exists."
This is a simple thing to accomplish in Query Analyzer,
but I need some of Enterprise Manager's functionality.
Obviously, I could keep deleting and re-registering every
time I need to change context, but that's a pretty tedious
kludge, or I wouldn't be writing this post, you know?
Anyways, is there a hack?
Thanks much.
Create an alias to the SQL Server within the Client Network Utility (within
the SQL Server program group) and then register that alias within Enterprise
Manager.
Keith
"Paul Smith" <paul.smith@.zurichna.com> wrote in message
news:18f301c4a648$0f3dc8e0$a601280a@.phx.gbl...
> How can I register the same SQL Server more than once in
> Enterprise Manager, using multiple logins?
> "A server with this name already exists."
> I'd expect this to be a FAQ, but twenty minutes of
> googling it has turned up precious little by way of
> remedies. This should be a pretty garden-variety
> situation: I need to access multiple databases on a single
> SQL Server, some of which require a different login from
> others. I've added a new server group for the additional
> instance/connection/registration, but every attempt to
> register the server returns "A server with this name
> already exists."
> This is a simple thing to accomplish in Query Analyzer,
> but I need some of Enterprise Manager's functionality.
> Obviously, I could keep deleting and re-registering every
> time I need to change context, but that's a pretty tedious
> kludge, or I wouldn't be writing this post, you know?
> Anyways, is there a hack?
> Thanks much.
>
|||That hit the spot - forgot all about the Client Utility, but what a simple,
quick and straightforward solution (...which is probably why I didn't arrive
at it on my own! heh.)
Thanks.
"Keith Kratochvil" wrote:

> Create an alias to the SQL Server within the Client Network Utility (within
> the SQL Server program group) and then register that alias within Enterprise
> Manager.
> --
> Keith
>
> "Paul Smith" <paul.smith@.zurichna.com> wrote in message
> news:18f301c4a648$0f3dc8e0$a601280a@.phx.gbl...
>

Enterprise manager compatibility

Hi
I trying register SQL Server 2005 Express Edition instance in Enterprise
Manager 2000 without success. Enterprise Manager 2000 do see instance and
lists its name in the list of available servers. But connection check
returns error: "SQL Server does not exist or access denied. ConnectionOpen
(Connect())".
Is Enterprise Manager 2000 compatible with SQL Server 2005 instances?Igor Solodovnikov (IgorSolodovnikov@.discussions.microsoft.com) writes:
> I trying register SQL Server 2005 Express Edition instance in Enterprise
> Manager 2000 without success. Enterprise Manager 2000 do see instance and
> lists its name in the list of available servers. But connection check
> returns error: "SQL Server does not exist or access denied. ConnectionOpen
> (Connect())".
> Is Enterprise Manager 2000 compatible with SQL Server 2005 instances?
No, you cannot connect to SQL 2005 with Enterprise Manager 2000. Query
Analyzer works though. (With some restrictions.)
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx|||Igor Solodovnikov wrote:
> Hi
> I trying register SQL Server 2005 Express Edition instance in Enterprise
> Manager 2000 without success. Enterprise Manager 2000 do see instance and
> lists its name in the list of available servers. But connection check
> returns error: "SQL Server does not exist or access denied. ConnectionOpen
> (Connect())".
> Is Enterprise Manager 2000 compatible with SQL Server 2005 instances?
No. Use SQL Server Management Studio for 2005. SSMS can also manage SQL
Server 2000 instances.
David Portas
SQL Server MVP
--

Enterprise manager / register with name

Hi,

I connect to a server on an other location with a VPN connection.
The SQL server on the other side is running an instance "MAINSERVER"
There are no problems to register the server locally as mainserver, but when i connect with the VPN it isnt't possible to register the server with the name "MAINSERVER"
It is only possible to register with its IP address.

Has anyone an idea why i cant't connect using the name?

Thanks!Hey Leo,

Sounds like you have a DNS issue. Just a guess but are you running Windows 2000. I have had many problems with VPN when it comes to DNS and WINS. On the other hand my XP machines have no problem. I'm not sure what it is about 2000 but I would like to see what kind of answers you get on this one. Have you yourself looked into any DNS issues?

Kal

Enterprise Manager - Available Servers - remote instance not listed

When using the register available servers in Enterprise Manager, the
named instances on a remote machine are not listed. The unnamed
instance is listed and will register successfully.
I have tried manually typing the names of the remote NAMED instances;
then tried to authenticate and get the message "SQL server does not
exist or access denied".
Local machine; SQL Server 2000 SP4 (Developer Edition) installed.
2 Instances
Unnamed
DEV\DB1
On the remote machine SQL Server 2000 (MSDE Edition) installed
3 Instances;
Unnamed
REM\DB1
REM\DB2
Both machines are on the same domain. All SQL server instances are
running.
I have also used the svrnetcn.exe tool to make sure the Named Pipes
and TCP/IP protocols are enabled. The port on the TCP/IP protocol has
been changed to 1433 on all remote instances. (both machines were
rebooted)
What else can I check ?
Thanks
DOn Sep 18, 9:18 pm, do <dmc...@.gmail.com> wrote:
> When using the register available servers in Enterprise Manager, the
> named instances on a remote machine are not listed. The unnamed
> instance is listed and will register successfully.
> I have tried manually typing the names of the remote NAMED instances;
> then tried to authenticate and get the message "SQL server does not
> exist or access denied".
> Local machine; SQL Server 2000 SP4 (Developer Edition) installed.
> 2 Instances
> Unnamed
> DEV\DB1
> On the remote machine SQL Server 2000 (MSDE Edition) installed
> 3 Instances;
> Unnamed
> REM\DB1
> REM\DB2
Create an alias for the named instances on the client end & then try
registering...
> Both machines are on the same domain. All SQL server instances are
> running.
> I have also used the svrnetcn.exe tool to make sure the Named Pipes
> and TCP/IP protocols are enabled. The port on the TCP/IP protocol has
> been changed to 1433 on all remote instances. (both machines were
> rebooted)
> What else can I check ?
> Thanks
> D

Enterprise Manager - Available Servers - remote instance not listed

When using the register available servers in Enterprise Manager, the
named instances on a remote machine are not listed. The unnamed
instance is listed and will register successfully.
I have tried manually typing the names of the remote NAMED instances;
then tried to authenticate and get the message "SQL server does not
exist or access denied".
Local machine; SQL Server 2000 SP4 (Developer Edition) installed.
2 Instances
Unnamed
DEV\DB1
On the remote machine SQL Server 2000 (MSDE Edition) installed
3 Instances;
Unnamed
REM\DB1
REM\DB2
Both machines are on the same domain. All SQL server instances are
running.
I have also used the svrnetcn.exe tool to make sure the Named Pipes
and TCP/IP protocols are enabled. The port on the TCP/IP protocol has
been changed to 1433 on all remote instances. (both machines were
rebooted)
What else can I check ?
Thanks
DHow about trying adding aliases from SQL Server Client Network Utility?
Add Aliases for your named instances and try connecting then.
You may obtain more info about this from the following link:
http://msdn2.microsoft.com/en-us/library/aa213780(SQL.80).aspx
You may want to have a look at the following article from BOL to learn more
about Browser Service of SQL Server 2005. This may be irrelevant however it
informs you about SS2000' s listening service too. It may give you an idea.
http://msdn2.microsoft.com/en-us/library/ms181087.aspx
--
Ekrem Önsoy
"do" <dmcb73@.gmail.com> wrote in message
news:1190189984.640820.24640@.o80g2000hse.googlegroups.com...
> When using the register available servers in Enterprise Manager, the
> named instances on a remote machine are not listed. The unnamed
> instance is listed and will register successfully.
> I have tried manually typing the names of the remote NAMED instances;
> then tried to authenticate and get the message "SQL server does not
> exist or access denied".
> Local machine; SQL Server 2000 SP4 (Developer Edition) installed.
> 2 Instances
> Unnamed
> DEV\DB1
> On the remote machine SQL Server 2000 (MSDE Edition) installed
> 3 Instances;
> Unnamed
> REM\DB1
> REM\DB2
> Both machines are on the same domain. All SQL server instances are
> running.
> I have also used the svrnetcn.exe tool to make sure the Named Pipes
> and TCP/IP protocols are enabled. The port on the TCP/IP protocol has
> been changed to 1433 on all remote instances. (both machines were
> rebooted)
> What else can I check ?
> Thanks
> D
>

Enterprise Manager

Hi,
I am using enterprise manager to manage various SQL servers however one
server that was working now refuses to connect/register again The strange
thing is that if I register the server in question it tries connect using
the wrong username (not the one I am logged on as. I cant find where it
caches/stores the old account details. How can I change the account in
question? We are using SQL & Windows Authenication.
Cheers
Hi
In EM, right click on the server and select "SQL Server Registration
properties" and modify the login credentials.
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Mikecl" wrote:

> Hi,
> I am using enterprise manager to manage various SQL servers however one
> server that was working now refuses to connect/register again The strange
> thing is that if I register the server in question it tries connect using
> the wrong username (not the one I am logged on as. I cant find where it
> caches/stores the old account details. How can I change the account in
> question? We are using SQL & Windows Authenication.
> Cheers
>
>
|||Hi,
Thanks for the info however I am using windows authentication, when Em try;s
to connect/register with this server It connects using a domain\test account
which does not have rights. The other registered servers are connected using
my domain\user account.
Where or why does this setting get retained. If I delete the registration
and try reegister it again it allways uses the domain\test account but only
with that server.
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
news:018438CC-21D1-4BF9-B0D7-F904B8D86BD7@.microsoft.com...[vbcol=seagreen]
> Hi
> In EM, right click on the server and select "SQL Server Registration
> properties" and modify the login credentials.
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
>
> "Mikecl" wrote:
strange[vbcol=seagreen]
using[vbcol=seagreen]
|||Hi,
U can use sp_password to change the default password for the user.
hope this help
from
doller
Mikecl wrote:
> Hi,
> I am using enterprise manager to manage various SQL servers however one
> server that was working now refuses to connect/register again The strange
> thing is that if I register the server in question it tries connect using
> the wrong username (not the one I am logged on as. I cant find where it
> caches/stores the old account details. How can I change the account in
> question? We are using SQL & Windows Authenication.
> Cheers
|||Hi Mike,
Thanks for the info however I am using windows authentication and the
problem is the account it try's and connects with is not the one I am logged
on with e.g it uses domain\test account rather than domain\mike account.
Where/how does it cache this info. I have deleted and registered the server
but is makes no difference
Thanks
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
news:018438CC-21D1-4BF9-B0D7-F904B8D86BD7@.microsoft.com...[vbcol=seagreen]
> Hi
> In EM, right click on the server and select "SQL Server Registration
> properties" and modify the login credentials.
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
>
> "Mikecl" wrote:
strange[vbcol=seagreen]
using[vbcol=seagreen]

Enterprise Manager

Hi,
I am using enterprise manager to manage various SQL servers however one
server that was working now refuses to connect/register again The strange
thing is that if I register the server in question it tries connect using
the wrong username (not the one I am logged on as. I cant find where it
caches/stores the old account details. How can I change the account in
question? We are using SQL & Windows Authenication.
CheersHi
In EM, right click on the server and select "SQL Server Registration
properties" and modify the login credentials.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Mikecl" wrote:

> Hi,
> I am using enterprise manager to manage various SQL servers however one
> server that was working now refuses to connect/register again The strange
> thing is that if I register the server in question it tries connect using
> the wrong username (not the one I am logged on as. I cant find where it
> caches/stores the old account details. How can I change the account in
> question? We are using SQL & Windows Authenication.
> Cheers
>
>|||Hi,
Thanks for the info however I am using windows authentication, when Em try;s
to connect/register with this server It connects using a domain\test account
which does not have rights. The other registered servers are connected using
my domain\user account.
Where or why does this setting get retained. If I delete the registration
and try reegister it again it allways uses the domain\test account but only
with that server.
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
news:018438CC-21D1-4BF9-B0D7-F904B8D86BD7@.microsoft.com...[vbcol=seagreen]
> Hi
> In EM, right click on the server and select "SQL Server Registration
> properties" and modify the login credentials.
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
>
> "Mikecl" wrote:
>
strange[vbcol=seagreen]
using[vbcol=seagreen]|||Hi,
U can use sp_password to change the default password for the user.
hope this help
from
doller
Mikecl wrote:
> Hi,
> I am using enterprise manager to manage various SQL servers however one
> server that was working now refuses to connect/register again The strange
> thing is that if I register the server in question it tries connect using
> the wrong username (not the one I am logged on as. I cant find where it
> caches/stores the old account details. How can I change the account in
> question? We are using SQL & Windows Authenication.
> Cheers|||Hi Mike,
Thanks for the info however I am using windows authentication and the
problem is the account it try's and connects with is not the one I am logged
on with e.g it uses domain\test account rather than domain\mike account.
Where/how does it cache this info. I have deleted and registered the server
but is makes no difference
Thanks
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
news:018438CC-21D1-4BF9-B0D7-F904B8D86BD7@.microsoft.com...[vbcol=seagreen]
> Hi
> In EM, right click on the server and select "SQL Server Registration
> properties" and modify the login credentials.
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
>
> "Mikecl" wrote:
>
strange[vbcol=seagreen]
using[vbcol=seagreen]

Enterprise Manager

Hi,
I am using enterprise manager to manage various SQL servers however one
server that was working now refuses to connect/register again The strange
thing is that if I register the server in question it tries connect using
the wrong username (not the one I am logged on as. I cant find where it
caches/stores the old account details. How can I change the account in
question? We are using SQL & Windows Authenication.
CheersHi
In EM, right click on the server and select "SQL Server Registration
properties" and modify the login credentials.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Mikecl" wrote:
> Hi,
> I am using enterprise manager to manage various SQL servers however one
> server that was working now refuses to connect/register again The strange
> thing is that if I register the server in question it tries connect using
> the wrong username (not the one I am logged on as. I cant find where it
> caches/stores the old account details. How can I change the account in
> question? We are using SQL & Windows Authenication.
> Cheers
>
>|||Hi,
Thanks for the info however I am using windows authentication, when Em try;s
to connect/register with this server It connects using a domain\test account
which does not have rights. The other registered servers are connected using
my domain\user account.
Where or why does this setting get retained. If I delete the registration
and try reegister it again it allways uses the domain\test account but only
with that server.
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
news:018438CC-21D1-4BF9-B0D7-F904B8D86BD7@.microsoft.com...
> Hi
> In EM, right click on the server and select "SQL Server Registration
> properties" and modify the login credentials.
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
>
> "Mikecl" wrote:
> > Hi,
> >
> > I am using enterprise manager to manage various SQL servers however one
> > server that was working now refuses to connect/register again The
strange
> > thing is that if I register the server in question it tries connect
using
> > the wrong username (not the one I am logged on as. I cant find where it
> > caches/stores the old account details. How can I change the account in
> > question? We are using SQL & Windows Authenication.
> >
> > Cheers
> >
> >
> >|||Hi,
U can use sp_password to change the default password for the user.
hope this help
from
doller
Mikecl wrote:
> Hi,
> I am using enterprise manager to manage various SQL servers however one
> server that was working now refuses to connect/register again The strange
> thing is that if I register the server in question it tries connect using
> the wrong username (not the one I am logged on as. I cant find where it
> caches/stores the old account details. How can I change the account in
> question? We are using SQL & Windows Authenication.
> Cheers|||Hi Mike,
Thanks for the info however I am using windows authentication and the
problem is the account it try's and connects with is not the one I am logged
on with e.g it uses domain\test account rather than domain\mike account.
Where/how does it cache this info. I have deleted and registered the server
but is makes no difference
Thanks
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
news:018438CC-21D1-4BF9-B0D7-F904B8D86BD7@.microsoft.com...
> Hi
> In EM, right click on the server and select "SQL Server Registration
> properties" and modify the login credentials.
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
>
> "Mikecl" wrote:
> > Hi,
> >
> > I am using enterprise manager to manage various SQL servers however one
> > server that was working now refuses to connect/register again The
strange
> > thing is that if I register the server in question it tries connect
using
> > the wrong username (not the one I am logged on as. I cant find where it
> > caches/stores the old account details. How can I change the account in
> > question? We are using SQL & Windows Authenication.
> >
> > Cheers
> >
> >
> >