report in SQL 2005 problem

Hi,
I am using the Business Intelligence Development studio to create a
simple report in SQL 2005 server. I have created a dataset and tried to
connect to a database and it failed to connect. An error is given out and
said that it cannot connect to the database because the server does not
allow remote connection and error 40. Can anyone tell me how to enable
"allow remote connection" in a database or how to solve this problem?
Thanks.Use the "SQL Server Surface Area Configuration" tool.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"00KobeBrian" <a@.b.com> wrote in message news:%23shnTtR6GHA.4348@.TK2MSFTNGP03.phx.gbl...
> Hi,
> I am using the Business Intelligence Development studio to create a
> simple report in SQL 2005 server. I have created a dataset and tried to
> connect to a database and it failed to connect. An error is given out and
> said that it cannot connect to the database because the server does not
> allow remote connection and error 40. Can anyone tell me how to enable
> "allow remote connection" in a database or how to solve this problem?
> Thanks.
>|||Hi,
I tried to select "Local and remote connection" - "TCP/IP" and
"TCP/IP and named pipe" option and run again. But still got the same error.
Can anyone please help? Thanks.
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:ue7WsZV6GHA.3452@.TK2MSFTNGP05.phx.gbl...
> Use the "SQL Server Surface Area Configuration" tool.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "00KobeBrian" <a@.b.com> wrote in message
> news:%23shnTtR6GHA.4348@.TK2MSFTNGP03.phx.gbl...
>> Hi,
>> I am using the Business Intelligence Development studio to create
>> a simple report in SQL 2005 server. I have created a dataset and tried to
>> connect to a database and it failed to connect. An error is given out and
>> said that it cannot connect to the database because the server does not
>> allow remote connection and error 40. Can anyone tell me how to enable
>> "allow remote connection" in a database or how to solve this problem?
>> Thanks.|||Sorry Folks. I got it. I just didn't point to the correct server. Cheers
"00KobeBrian" <a@.b.com> wrote in message
news:uhhxA8z6GHA.4644@.TK2MSFTNGP04.phx.gbl...
> Hi,
> I tried to select "Local and remote connection" - "TCP/IP" and
> "TCP/IP and named pipe" option and run again. But still got the same
> error. Can anyone please help? Thanks.
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote
> in message news:ue7WsZV6GHA.3452@.TK2MSFTNGP05.phx.gbl...
>> Use the "SQL Server Surface Area Configuration" tool.
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>>
>> "00KobeBrian" <a@.b.com> wrote in message
>> news:%23shnTtR6GHA.4348@.TK2MSFTNGP03.phx.gbl...
>> Hi,
>> I am using the Business Intelligence Development studio to
>> create a simple report in SQL 2005 server. I have created a dataset and
>> tried to connect to a database and it failed to connect. An error is
>> given out and said that it cannot connect to the database because the
>> server does not allow remote connection and error 40. Can anyone tell me
>> how to enable "allow remote connection" in a database or how to solve
>> this problem? Thanks.
>