Cannot create a connection to data source

Windows 2003 Enterprise SP1, Sql Server 2005 June CTP.
I created a report on data from another server. I can run the report just
fine on the server with Reporting Services.
When I try to run the report from my computer I get the cannot create
connection error. I have full rights to the server and sa privilages to SQL
Server on the RS server and the remote server on which the data is located.
I have checked with the Network administrator and kerberos is enabled.
I really need to get this working and prove to management that RS will do
all we need in the way of a reporting tool.
Your help will be apprecited.
RoyWith the June CTP comes the Surface Area Configuration tool. Launch the
tool and makes sure that remote connections are enabled for your SQL
Server. By default, SQL is much tighter on security and remote connections
are off after initial install.
--
| Thread-Topic: Cannot create a connection to data source
| thread-index: AcWsvM7xh3SUrYS9QcCFLHwzj12wwg==| X-WBNR-Posting-Host: 65.118.63.88
| From: =?Utf-8?B?Um95?= <Roy@.discussions.microsoft.com>
| Subject: Cannot create a connection to data source
| Date: Mon, 29 Aug 2005 10:12:17 -0700
| Lines: 12
| Message-ID: <EB5CC7FC-F898-48AC-A8CD-E9B6668EF797@.microsoft.com>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="Utf-8"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Content-Class: urn:content-classes:message
| Importance: normal
| Priority: normal
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| Newsgroups: microsoft.public.sqlserver.reportingsvcs
| NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
| Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl
| Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.reportingsvcs:51349
| X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
|
| Windows 2003 Enterprise SP1, Sql Server 2005 June CTP.
| I created a report on data from another server. I can run the report just
| fine on the server with Reporting Services.
| When I try to run the report from my computer I get the cannot create
| connection error. I have full rights to the server and sa privilages to
SQL
| Server on the RS server and the remote server on which the data is
located.
| I have checked with the Network administrator and kerberos is enabled.
| I really need to get this working and prove to management that RS will do
| all we need in the way of a reporting tool.
| Your help will be apprecited.
| Roy
|
||||Brad,
I did set the server to allow remote connections.
Roy
""Brad Syputa - MS"" wrote:
> With the June CTP comes the Surface Area Configuration tool. Launch the
> tool and makes sure that remote connections are enabled for your SQL
> Server. By default, SQL is much tighter on security and remote connections
> are off after initial install.
> --
> | Thread-Topic: Cannot create a connection to data source
> | thread-index: AcWsvM7xh3SUrYS9QcCFLHwzj12wwg==> | X-WBNR-Posting-Host: 65.118.63.88
> | From: =?Utf-8?B?Um95?= <Roy@.discussions.microsoft.com>
> | Subject: Cannot create a connection to data source
> | Date: Mon, 29 Aug 2005 10:12:17 -0700
> | Lines: 12
> | Message-ID: <EB5CC7FC-F898-48AC-A8CD-E9B6668EF797@.microsoft.com>
> | MIME-Version: 1.0
> | Content-Type: text/plain;
> | charset="Utf-8"
> | Content-Transfer-Encoding: 7bit
> | X-Newsreader: Microsoft CDO for Windows 2000
> | Content-Class: urn:content-classes:message
> | Importance: normal
> | Priority: normal
> | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
> | Newsgroups: microsoft.public.sqlserver.reportingsvcs
> | NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
> | Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl
> | Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.reportingsvcs:51349
> | X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
> |
> | Windows 2003 Enterprise SP1, Sql Server 2005 June CTP.
> | I created a report on data from another server. I can run the report just
> | fine on the server with Reporting Services.
> | When I try to run the report from my computer I get the cannot create
> | connection error. I have full rights to the server and sa privilages to
> SQL
> | Server on the RS server and the remote server on which the data is
> located.
> | I have checked with the Network administrator and kerberos is enabled.
> | I really need to get this working and prove to management that RS will do
> | all we need in the way of a reporting tool.
> | Your help will be apprecited.
> | Roy
> |
> |
>