I have an analytical database running on pc01. A sql2000 installed as
default instance on pc02 and a sql2005 installed as named instance also
on pc02.

I'm running the business intelligence project on pc01, deploying it to
the same pc01. In that project there is a datasource connected to the
sql2005 named instance on pc02.

If I fill in pc02\sql2005 as name is doesn't connect, but when I fill
in just pc02 it connects and lists the DB's on the sql2005 named
instance. I connect using server authentication.

I can then explore the data on pc02 from within the business
intelligence project without any problems.

But when I try to deploy I get the following errors depending on the
sort of connection I try:

DOTNET/System.Data.SqlClient: Errors in the high-level relational
engine. The following exception occurred while the managed
IDbConnection interface was being used: .

SQL Native Client: OLE DB error: OLE DB or ODBC error: 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.;
08001; Client unable to establish connection; 08001; Encryption not
supported on the client.; 08001.


When I try native OLE DB I can't even succeed in the test connection.

Native OLE DB: Cannot connect: Test connections failed because of an
error in initializing provider. [DBNETLIB] ConnectionOpen (Invalid
Instance()). Invalid Connection.


Extra info:
- Remote connection is open at pc02.
- Tried with the SQL2000 stopped on pc02 with no difference.


What am I missing? This should be something simple?


--
Thanks in advance,

Stijn Verrept.