Connect Timeout will not work - SQLOLEDB

It seams as if the Connect Timeout property is not working correctly if the server that one is trying to connect to is down. This is my connection string.

Provider=SQLOLEDB;Pooling=False;Data Source=172.16.136.4;Initial Catalog=Db1;User ID=test;Password=test;Connect Timeout=5;

The timeout is ignored and the connection times out after about 15/20 seconds?

Any ideas?my guess is that your seeing the network connection timeout, not the sql connection timeout...

i.e.

before you can establish a sql connection, you need to establish a network connection|||Yes this seams to be correct , I am now working on a way of checking that the network connection is avaible before issuing a connection. Looking at using some ping routine, Will update this thread with the results

Configuring Report Services for 64 bit SQL 2005

Hi all

Can anyone help?

I have installed reporting services for 64 bit SQL and I am having a problem configuring it correctly so that I can access the reports manager on http://localhost/reports.

I have studied various SQL server 2005 bibles and looked at information on the microsoft support site but nothing seems to be helping me.

I get the impression that it could be a problem with the IIS server.

Can anyone give me a complete run down on how to set up and configure the reporting services so that it will actually work. Every step of the way please.

Thanks

Alex Oakley

Hi Alex. Are you using a default instance of the SQL Server 2005 installation or did you use a named instance? Also, what error are you getting when you attempt to access report manager?

|||

I am using a default instance.

When I am trying to access the report manager the internet page isnt loading at all.

I am getting the usual IE screen where url cannot be found.

Alex

|||

Try Http://Servername/Reports and see what you get....

|||I have tried that and the page is not being displayed....

|||

Can you open the RS config tool and make sure that all sections are configured properly. You should see a green icon if everything is configured correctly.

Thanks,
Sharmila

Configure Report Server / VSTS

Hi,
during the install of VSTS - I get the errror that Reporting services are
not configured correctly.
This seems to be due to the Web Service Identity not being configured.
(This WAS configured and fine before installing SharePoint & attempting the
VSTS install)
If I try to edit the Web Service Identity - I get :
ReportServicesConfigUI.WMIProvider.WMIProviderException: A virtual directory
must first be created before performing this operation.
at
ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.SetWebServiceIdentity(String
applicationPool)
The ASP.Net service account box is blank (I've re-run aspnet_regiis)
The report server box is blank as is the Report Manager box - any attempt to
create or select an existing pool errors.
(the reports & reportserver virtual folders already exist in IIS)
TIA
PhilHello Phil,
Since you installed Sharepoint to the web server, it will install the isapi
filter and handle all the httprequest.
So I suggest you create and configure the Reporting Services on the other
virtual directory.
For example, you could create as RSmanager and RSServer.
Hope this helps.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Hi ,
How is everything going? Please feel free to let me know if you need any
assistance.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.