Showing posts with label configure. Show all posts
Showing posts with label configure. Show all posts

Sunday, February 19, 2012

Connecting Enterprise Manager on non-standard port?

Is it possible to configure Enterprise Manager to connect to a remote
server on a non-standard port, without changing the port for ALL of
the registered servers?
I see that I can use the Client Network Utility to change the "default
port" for TCP/IP. But I have several servers registered, and only one
of them uses a non-standard port.
One would think that the port should be one of the Server Registration
Properties, but it doesn't appear to be.
I found one thread that came close to addressing this question, but it
dead-ended before getting quite to the point:
http://groups.google.com/groups?hl=e...server.clients
When registering the server, use the following format:
servername, portnumber
e.g.
sqlabc, 5500
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Allan Cady" <allancady@.yahoo.com> wrote in message
news:d563b154.0412041625.534c2b@.posting.google.com ...
> Is it possible to configure Enterprise Manager to connect to a remote
> server on a non-standard port, without changing the port for ALL of
> the registered servers?
> I see that I can use the Client Network Utility to change the "default
> port" for TCP/IP. But I have several servers registered, and only one
> of them uses a non-standard port.
> One would think that the port should be one of the Server Registration
> Properties, but it doesn't appear to be.
> I found one thread that came close to addressing this question, but it
> dead-ended before getting quite to the point:
>
http://groups.google.com/groups?hl=e...ndard%2522%26m
eta%3Dgroup%253Dmicrosoft.public.sqlserver.clients
|||Excellent, that does the trick. Thank you!
Just out of curiosity... do you happen to know if this is documented
in BOL? I don't see it.
"Mike Epprecht \(SQL MVP\)" <mike@.epprecht.net> wrote in message news:<#FO4niu2EHA.3128@.TK2MSFTNGP14.phx.gbl>...
> When registering the server, use the following format:
> servername, portnumber
> e.g.
> sqlabc, 5500
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "Allan Cady" <allancady@.yahoo.com> wrote in message
> news:d563b154.0412041625.534c2b@.posting.google.com ...
> http://groups.google.com/groups?hl=e...ndard%2522%26m
> eta%3Dgroup%253Dmicrosoft.public.sqlserver.clients
|||Hi
I have found any, but EM uses the same format as you would specify for a ADO
connection.
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Allan Cady" <allancady@.yahoo.com> wrote in message
news:d563b154.0412051800.2250e979@.posting.google.c om...
> Excellent, that does the trick. Thank you!
> Just out of curiosity... do you happen to know if this is documented
> in BOL? I don't see it.
>
> "Mike Epprecht \(SQL MVP\)" <mike@.epprecht.net> wrote in message
news:<#FO4niu2EHA.3128@.TK2MSFTNGP14.phx.gbl>...[vbcol=seagreen]
http://groups.google.com/groups?hl=e...ndard%2522%26m[vbcol=seagreen]
|||It occurred to me that I can also do this (specify an alternate port)
by defining an alias for the server in the Client Network Utility.

Friday, February 17, 2012

Connectin ASP.NET to SQL Server 2000, Problem.

Hi
Is there any settings that I must configure to connect an ASP.NET to SQL
Server 2000?
If there is please tell me.
Thanks in advance
Mohammad-Reza Taikandi
You may want to review this;
http://msdn.microsoft.com/library/de...us/dnnetsec/ht
ml/secnetlpMSDN.asp
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.
|||Thanks kevin
"Kevin McDonnell [MSFT]" <kevmc@.online.microsoft.com> wrote in message
news:c4gQP66NEHA.3564@.cpmsftngxa10.phx.gbl...
> You may want to review this;
>
http://msdn.microsoft.com/library/de...us/dnnetsec/ht
> ml/secnetlpMSDN.asp
> Thanks,
> Kevin McDonnell
> Microsoft Corporation
> This posting is provided AS IS with no warranties, and confers no rights.
>
>

Connectin ASP.NET to SQL Server 2000, Problem.

Hi
Is there any settings that I must configure to connect an ASP.NET to SQL
Server 2000?
If there is please tell me.
Thanks in advance
Mohammad-Reza TaikandiYou may want to review this;
http://msdn.microsoft.com/library/d...-us/dnnetsec/ht
ml/secnetlpMSDN.asp
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.|||Thanks kevin
"Kevin McDonnell [MSFT]" <kevmc@.online.microsoft.com> wrote in message
news:c4gQP66NEHA.3564@.cpmsftngxa10.phx.gbl...
> You may want to review this;
>
http://msdn.microsoft.com/library/d...-us/dnnetsec/ht
> ml/secnetlpMSDN.asp
> Thanks,
> Kevin McDonnell
> Microsoft Corporation
> This posting is provided AS IS with no warranties, and confers no rights.
>
>