In enterprise manager, I could define my sql server registration with
xxx.xxx.xxx.xxx, pppp where pppp is the non standard port number that
sql server is listening on.
Trying this in 2005 Management studio gives me:
TITLE: New Server Registration
---
Testing the registered server failed. Verify the server name, login
credentials, and database, and then click Test again.
---
ADDITIONAL INFORMATION:
Unknown ProviderConnection string is not valid (Microsoft SQL Server,
Error: 87)
For help, click:
http://go.microsoft.com/fwlink?ProdName=Microsoft%20SQL%20Server&EvtSrc=MSSQLServer&EvtID=87&LinkId=20476
Any ideas? It will be bad if sql2k5 management tools can't connect to
servers on alternate ports. Is there some new way to define a port?Probably better to post SQL Server 2005 questions in the dedicated SQL
Server 2005 newsgroups.
http://www.aspfaq.com/sql2005/show.asp?id=1
On 3/2/05 7:15 PM, in article
1109808938.817178.192760@.z14g2000cwz.googlegroups.com, "Josh Goodwin"
<jsgoods@.gmail.com> wrote:
> In enterprise manager, I could define my sql server registration with
> xxx.xxx.xxx.xxx, pppp where pppp is the non standard port number that
> sql server is listening on.
> Trying this in 2005 Management studio gives me:
> TITLE: New Server Registration
> ---
> Testing the registered server failed. Verify the server name, login
> credentials, and database, and then click Test again.
> ---
> ADDITIONAL INFORMATION:
> Unknown ProviderConnection string is not valid (Microsoft SQL Server,
> Error: 87)
> For help, click:
> http://go.microsoft.com/fwlink?ProdName=Microsoft%20SQL%20Server&EvtSrc=MSSQLS
> erver&EvtID=87&LinkId=20476
>
> Any ideas? It will be bad if sql2k5 management tools can't connect to
> servers on alternate ports. Is there some new way to define a port?
>|||Try to creat a client-side Server Alias with the Client Configuration
Utility.
Sincerely,
Anthony Thomas
"Aaron [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
news:BE4BD4ED.1C64%ten.xoc@.dnartreb.noraa...
Probably better to post SQL Server 2005 questions in the dedicated SQL
Server 2005 newsgroups.
http://www.aspfaq.com/sql2005/show.asp?id=1
On 3/2/05 7:15 PM, in article
1109808938.817178.192760@.z14g2000cwz.googlegroups.com, "Josh Goodwin"
<jsgoods@.gmail.com> wrote:
> In enterprise manager, I could define my sql server registration with
> xxx.xxx.xxx.xxx, pppp where pppp is the non standard port number that
> sql server is listening on.
> Trying this in 2005 Management studio gives me:
> TITLE: New Server Registration
> ---
> Testing the registered server failed. Verify the server name, login
> credentials, and database, and then click Test again.
> ---
> ADDITIONAL INFORMATION:
> Unknown ProviderConnection string is not valid (Microsoft SQL Server,
> Error: 87)
> For help, click:
>
http://go.microsoft.com/fwlink?ProdName=Microsoft%20SQL%20Server&EvtSrc=MSSQLS
> erver&EvtID=87&LinkId=20476
>
> Any ideas? It will be bad if sql2k5 management tools can't connect to
> servers on alternate ports. Is there some new way to define a port?
>
