Login time out

Hello together,
I've got the following: SQL Server 2005 Express & SQL Server 2000
The sql server 2000 has got a database with some tables, which I want to
show as view (readonly) in the sql server 2005 express.
Now I did the following:
I added a linked server to the sql 2005
I've choosen the security option: "Be made using this security context" with
the sql user and sql password of the SQL Server 2000
But when I try to select data from the server (SELECT * FROM
Server.Database.dbo.Table), I get the following error:
OLE DB provider "SQLNCLI" for linked server "192.168.80.5" returned message
"Login timeout expired".
OLE DB provider "SQLNCLI" for linked server "192.168.80.5" returned message
"An error has occurred while establishing a connection to the server. When
connecting to SQL Server 2005, this failure may be caused by the fact that
under the default settings SQL Server does not allow remote connections.".
Msg 126, Level 16, State 1, Line 0
VIA Provider: The specified module could not be found.
can anybody help me please?
thank you
bernhard
Run the Surface Area Configuration tool and enable the Remote Connections to
have access outside of the Express instance.
Andrew J. Kelly SQL MVP
"Bernhard Wurm" <Bernhard@.eworx.at> wrote in message
news:%23oLTY2WBGHA.628@.TK2MSFTNGP14.phx.gbl...
> Hello together,
> I've got the following: SQL Server 2005 Express & SQL Server 2000
> The sql server 2000 has got a database with some tables, which I want to
> show as view (readonly) in the sql server 2005 express.
> Now I did the following:
> I added a linked server to the sql 2005
> I've choosen the security option: "Be made using this security context"
> with the sql user and sql password of the SQL Server 2000
> But when I try to select data from the server (SELECT * FROM
> Server.Database.dbo.Table), I get the following error:
> OLE DB provider "SQLNCLI" for linked server "192.168.80.5" returned
> message "Login timeout expired".
> OLE DB provider "SQLNCLI" for linked server "192.168.80.5" returned
> message "An error has occurred while establishing a connection to the
> server. When connecting to SQL Server 2005, this failure may be caused by
> the fact that under the default settings SQL Server does not allow remote
> connections.".
> Msg 126, Level 16, State 1, Line 0
> VIA Provider: The specified module could not be found.
>
> can anybody help me please?
>
> thank you
> bernhard
>
>
|||But I want to connection the sql 2000 from the sql 2005 and not the other
way round.
If I view the properties of the SQL 2000 / Connections then I find "Allow
remote connections to this server". This is enabled.
"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> schrieb im Newsbeitrag
news:ebZmIAXBGHA.976@.TK2MSFTNGP15.phx.gbl...
> Run the Surface Area Configuration tool and enable the Remote Connections
> to have access outside of the Express instance.
> --
> Andrew J. Kelly SQL MVP
>
> "Bernhard Wurm" <Bernhard@.eworx.at> wrote in message
> news:%23oLTY2WBGHA.628@.TK2MSFTNGP14.phx.gbl...
>
|||Yes so you must do what I suggested. Try it and see if it works.
Andrew J. Kelly SQL MVP
"Bernhard Wurm" <Bernhard@.eworx.at> wrote in message
news:OxOYoHXBGHA.1864@.TK2MSFTNGP12.phx.gbl...
> But I want to connection the sql 2000 from the sql 2005 and not the other
> way round.
> If I view the properties of the SQL 2000 / Connections then I find "Allow
> remote connections to this server". This is enabled.
>
> "Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> schrieb im Newsbeitrag
> news:ebZmIAXBGHA.976@.TK2MSFTNGP15.phx.gbl...
>
|||Hello,
they are enabled.
thank you
"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> schrieb im Newsbeitrag
news:e4osudYBGHA.1372@.TK2MSFTNGP14.phx.gbl...
> Yes so you must do what I suggested. Try it and see if it works.
> --
> Andrew J. Kelly SQL MVP
>
> "Bernhard Wurm" <Bernhard@.eworx.at> wrote in message
> news:OxOYoHXBGHA.1864@.TK2MSFTNGP12.phx.gbl...
>
|||While don't talk directly about SQLNCLI they may be useful:
http://support.microsoft.com/default.aspx?kbid=314530
http://support.microsoft.com/default...b;en-us;905618
Andrew J. Kelly SQL MVP
"Bernhard Wurm" <Bernhard@.eworx.at> wrote in message
news:u3FJwzgBGHA.412@.TK2MSFTNGP15.phx.gbl...
> Hello,
> they are enabled.
> thank you
>
> "Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> schrieb im Newsbeitrag
> news:e4osudYBGHA.1372@.TK2MSFTNGP14.phx.gbl...
>