cant register sql2k5

I have a local instance of sql2k5, as well as a remote one. From my local
Management Studio, I try to register the remote one, and I get the message...
A connection was successfully established to the server, but then an error
occured during the login process. (provider: TCP Provider, error:0 - An
existing connection was forcibly closed by the remote host. ) (MSSQL, Error:
10054)
Any ideas?
TIA,
ChrisR
Did you enable TCP/IP connections from remote machines in SQL Surface
Area Configuration Tool? They're not turned on by default in 2005.
ChrisR wrote:
> I have a local instance of sql2k5, as well as a remote one. From my local
> Management Studio, I try to register the remote one, and I get the message...
> A connection was successfully established to the server, but then an error
> occured during the login process. (provider: TCP Provider, error:0 - An
> existing connection was forcibly closed by the remote host. ) (MSSQL, Error:
> 10054)
> Any ideas?
> --
> TIA,
> ChrisR
|||I don't have a Configurations tab on the remote box... I just realized its
Beta2. Could this have sometihng to do with it?
TIA,
ChrisR
"Corey Bunch" wrote:

> Did you enable TCP/IP connections from remote machines in SQL Surface
> Area Configuration Tool? They're not turned on by default in 2005.
> ChrisR wrote:
>
|||Are you looking under Programs\SQL 2005\Configuration Tools\Surface Area
Configuration tool?
"ChrisR" wrote:
[vbcol=seagreen]
> I don't have a Configurations tab on the remote box... I just realized its
> Beta2. Could this have sometihng to do with it?
> --
> TIA,
> ChrisR
>
> "Corey Bunch" wrote:
|||Start\ Programs\ there is no Configuration Tools option.
TIA,
ChrisR
"burt_king" wrote:
[vbcol=seagreen]
> Are you looking under Programs\SQL 2005\Configuration Tools\Surface Area
> Configuration tool?
> "ChrisR" wrote:
|||Sorry... start\programs\sql2k5\ there is no Configuration Tools option.
TIA,
ChrisR
"ChrisR" wrote:
[vbcol=seagreen]
> Start\ Programs\ there is no Configuration Tools option.
> --
> TIA,
> ChrisR
>
> "burt_king" wrote:
|||How about Computer Manager, under Services, you should have some SQL Server Configuration Node. Here
you can enable the netlibs.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"ChrisR" <ChrisR@.discussions.microsoft.com> wrote in message
news:0AA1654F-9449-484F-9CCA-AC7472FEF91B@.microsoft.com...[vbcol=seagreen]
> Sorry... start\programs\sql2k5\ there is no Configuration Tools option.
> --
> TIA,
> ChrisR
>
> "ChrisR" wrote:
|||And do what to the netlibs? I dont see anything like enable remote connections.
TIA,
ChrisR
"Tibor Karaszi" wrote:

> How about Computer Manager, under Services, you should have some SQL Server Configuration Node. Here
> you can enable the netlibs.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "ChrisR" <ChrisR@.discussions.microsoft.com> wrote in message
> news:0AA1654F-9449-484F-9CCA-AC7472FEF91B@.microsoft.com...
>
|||Also, I tried to register in reverse.
1; In my local box, I went into
I logged into the remote box and tried to register my local box. I went into
SQL Server Surface Area Config/ Services and Connections/ Remote Connections/
Local and Remote Connections is checked.
When I try to register it says Unknown ProviderConnection string is invalid.
(MSSQL error: 87)
TIA,
ChrisR
"burt_king" wrote:
[vbcol=seagreen]
> Are you looking under Programs\SQL 2005\Configuration Tools\Surface Area
> Configuration tool?
> "ChrisR" wrote:
|||Hard to know what your setup look like as you are on an older version (beta). On my machines, I use
the following folder structure:
SQL Server Configuration Manager
SQL Server 2005 Network Configuration
Protocols for [instancename]
In above folder I can right-click a netlib (TCP/IP, for instance) and enable it.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"ChrisR" <ChrisR@.discussions.microsoft.com> wrote in message
news:F19474D2-3815-4B06-B549-FE357816A8C9@.microsoft.com...[vbcol=seagreen]
> And do what to the netlibs? I dont see anything like enable remote connections.
> --
> TIA,
> ChrisR
>
> "Tibor Karaszi" wrote: