.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Report Designer Unable to Connect to SQL 2005 Database...Sort of.

Posted By:      Posted Date: May 22, 2011    Points: 0   Category :

SO here is the problem I have a whole project SSRS 2005 project that is unable to connect to the SQL 2005 Standard database. When I try to access the data under the "Data" tab I get the following Error.  Interestingly when I go in the data source connection settings and click the "Test Connection" all is good. But still the report is not able to pull any data without the error comming up. I have removed and reinstalled VS 2005 Pro, removed and reinstalled SQL tools on the workstation all with the same error. I have the same project on an older laptop and all is well. Help!!!!



TITLE: Microsoft Report Designer

A connection cannot be made to the database.
Set and test the connection string.


Format of the initialization string does not conform to specification starting at index 75. (System.Data)

More on the Error:



A connection cannot be made to the database.
Set and test the connection string.
 (Microsoft Report Designer)

Program Location:

   at Microsoft.ReportDesigner.Design.Query.CreateConnection()

View Complete Post

More Related Resource Links

PowerPivot Report is unable to connect database after uploading onto SharePoint 2010


Hi All,

I have developed one PowerPivot Report in excel 2010 and uploaded into SharePoint 2010. The report has slicers and filters which are working pretty well in excel 2010.

I'm able to open the report through sharepoint browser and  if click on any slicer getting the following error.

An error occurred during an attempt to establish a connection to the external data source. The following connections failed to refresh:

Also i'm unable to see the filter on the report.

I have got some info on google regarding 'Claims to windows token service' should up and run. But, i'm still getting the same after enabling 'Claims to windows token service' as well.

Please help me in this regard.

Thanks & Regards,


unable to connect to database



I am using visual studio 2005 and sql server 2005.

I am developing a small quiz application and i have stored the connection string in app.config file which is given below.:

<?xml version="1.0" encoding="utf-8" ?>
        <add name="quizdb"
            connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|Quiz Application.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True"
            providerName="System.Data.SqlClient" />
i have retrieved connection string property through configurationmanager class 

and when i m connecting to database  it gives me a runtime error:


Sql Exception was unhandled

System.Data.SqlClient.SqlException was unhandled
  Message="An attempt to attach an auto-named database for file F:\\Quiz\\Quiz\\bin\\Debug\\Quiz Application.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located

Connect to existing sql 2005 database


Hello There,

I had successfully restored sql 2000 database to sql 2005. It works like charm

Now i am creating a database model in MVC

I follow these steps

Right click on model > ADO.NET entity data model > Generate from database > New connection (Microsoft sql server) > server name > select or enter database name

But no server name AND database name show in both drop down lists. When i mannually enter database name (which exists in sql 2005) then click on TEST CONNECTION. It gives follwoing error

"A network-related or instance-specific error while establishing a connection to sql server. the server was not found or was not accessible. verify that the instance name is correct and that sql server is configured to allow remote connections.

Kindly help me with this


Unable to install SP3 on SQL 2005 due to Database Services language being blank

Hi all,   I have an issue that requires me to upgrade to a later SP (currently on RTM), but when I try to install SP3 Database Services cannot be ticked. Upon inspection I see that its reporting "This update requires language ENU.  The language for this product instance MSSQLSERVER is . Download the upadte for langage .", when I check teh Language field to the right it is blank, other parts however are fine and can be upgraded. Can you advise please as I don't know how to manually set the language (which is reported inside SQL itself as English (United Kingdom)) and I cannot un/reinstall. Thanks, John

Unable to connect to SQL Server 2005 remotly, all client protocols are blank

I have an installation of SQL 2005 and had issues connecting remotly. Looking at the client protocolols, they are all blank. I can see that TCPIP, Named Pipes, VIA, etc. are 'enabled', but where the words 'TCPIP', 'Names Pipes', etc. should be, it's just blank. I tried to install SQL 2008R hoping the Client Protocols would be corrected during the installaion, but they were not. I'm assuming the issue with the Client Protocols not showing up is a symptom of the problem. Does anyone have any ideas? Thanks!

Reporting Services Add-In for MOSS2007 : Unable to connect to the database Error at "Set Server Defa

Dear Expert, I've succesfully install the Add-In + configure the reporting services (integrated mode) + activate the features on my MOSS2007. As we know by activating this at my Central Admin, i'm able to see "Reporting Services" under my Application Management as below:   1) Manage Integration Setting   ---> My report url : http://servername:808/ReportServer (Trusted Account) 2) Grand Database Access --->  My setting : <servername> with default instance  3) Set Server Defaults ---> Area that i receive an error "Unable to connect to database" Anybody here have a same experience? please assist me, Thanks in Advanced My Note: OS : Windows Server 2008 Enterprise x64bit (SP2) SQL : SQL 2005 with latest Service Pack (SP3)  My Error Log: <Header>   <Product>Microsoft SQL Server Reporting Services Version 9.00.4035.00</Product>   <Locale>en-US</Locale>   <TimeZone>Malay Peninsula Standard Time</TimeZone>   <Path>c:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\LogFiles\ReportServer__08_04_2010_10_51_59.log</Path>   <SystemName>SEINE</SystemName>   <OSName>Microsoft Windows NT 6.0.6002 Service Pack 2</OSName>   <OSVersion>6.0.6002.131072</OS

unable to connect to a database engine

Hi. i have recently installed SQll Server 2005 but i am facing issue while connecting to a databse engine..how should i do it..?its showing an error which looks like this TITLE: Connect to Database Engine ------------------------------ Cannot connect to sanchit. ------------------------------ ADDITIONAL INFORMATION: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 53) For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=53&LinkId=20476 please assist me in this....

How to connect from Crystal Report to FireBird Database

Hi, Im using a crystal report in Visual Studio 2005 and I need to connect to a Firebird Database but a dont have idea how to connect it, Please help me...

Report builder 3.0 - Unable to connect to server

Hi there, We've been using Report Builder 2.0, and its been working pretty nicely. We have the option 'Use this report server or sharepoint site by default' option set to http://<server>/reportserver - and users can connect via the 'Open' dialog, save, etc. However, some of our users have been testing Report Builder 3.0 - and they are unable to connect, even though the URL is set exactly the same.  They have Report Builder 2.0 and 3.0 installed on the same client workstation. With the same settings, 2.0 can connect, but 3.0 can not. The target installation is SSRS is SQL 2008. The error is: Connection failed. Unable to connect to the server that is specified in the URL... Make sure that the server is running, the URL is correct and you have permission to use the server. Does anybody have any ideas? thanks, mark

SSRS 2008 - report manager: System.Net.WebException: Unable to connect to the remote server

I have an instance of Reporting Services 2008 running on Windows 2003 server.  So, the webservice URL is running on port 801, and runs fine (I can browse reports from that directory, and upload / deploy new reports and overwrite existing reports. Report manager is set to use port 800 (IIS is also on that machine running port 80).  When I attempt to connect to report manager, I get the following error, with a link to "Home" in report manager (which brings me back to the existing error page):    Unable to connect to the remote server  In the logfiles for reporting services, the following error is there: " System.Net.WebException: Unable to connect to the remote server ---> System.Net.Sockets.SocketException: No connection could be made because the target machine actively refused it.   Any ideas? Windows Firewall is NOT running on this machine.   Thanks, Chrisrjp

Unable to use XML datasource to run a report on Report server( Report runs fines in Report designer

We are trying to run a report which uses a xml file  to load a report on SSRS. We have copied the xml to the Pages folder  and are able to access the xml via the link https://<servername>/Reports/Pages/test.xml This runs fine in the report designer.(i,e we are able to get create xml data source and use a dataset to retrieve the data from xml to the report designer) However when I try to create a XML datasource on the development server and try to run the report , we get the following error Error: An error occurred during client rendering. An error has occurred during report processing. Query execution failed for dataset 'DataSet1'. Failed to execute web request for the specified URL. Unauthorized: The remote server returned an error: (401) Unauthorized. The remote server returned an error: (401) Unauthorized. I have updated the XML datasource to use Windows Account which is in the adminstrators group.   Any suggestions or hints are appreciated  

Unable To Connect Database Error:Sharepoint 2007 Internet Site.

Hi Techies,  we are running 4farm Sharepoint internet site. now a days we are getting the below error very regularly. Event Viewer :The description for Event ID ( 27745 ) in Source ( Windows SharePoint Services 3 ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event: #50071: Unable to connect to the database SharePoint_Config on SPPREPROD02VMDK\SPPREDPROD.  Check the database connection information and make sure that the database server is running.. Sharepoint Logs:#50071 :#50071: Unable to connect to the database SharePoint_Config on pfc-penndb-tst. Check the database connection information and make sure that the database server is running.. Please Advice . Regards, raju.  Nag: http://nagaraju-sharepoint.blogspot.com. Posting is provided with no warranties.

Trouble to connect report on SSAS 2005

Hello! I have deployed my first report (ssrs2008) using a ssas (2005) cube as data source but I can't get it to work. I setup the credentials to use Windows Authentication in the SSAS data source and when I open the report from the rs server it renders fine, however when I try it from a workstation I get the error below: The SSRS instance is not on the same server as SSAS. Any Clue? Thanks! Cannot create a connection to data source 'TestCube'. The connection either timed out or was lost. Unable to read data from the transport connection: An existing connection was forcibly closed by the remote host. An existing connection was forcibly closed by the remote host

how to connect my hosting database from my pc using sql server management studio 2005



I have one asp.net hosting account with some service provider.. 

They have given me some xxx.xxxxxx.com to access sql server from my desktop... 

I enter xxx.xxxxx.com in server name and username and password but it will not connect.. 

so please let me know what are the steps i have to do to access my hosting database...

they have given sql server 2008 im using in local sql server 2005 management studio so let me know how to connect

thanks in advance

Unable to sort RSS feed in Web Part or SP Designer 2007

I have an RSS Moss 2007 webpart to display feeds from http://www.fujitsu.com/uk/news/pr/uk-news-pr-rss.rss but the feed is coming in reverse date order. In Sharepoint designer when I try to sort by pubDate (descending), the sort order is arbitrary and it appears that the feed is being limited in size with the latest post being some 3 years ago.

Any help would be appreciated.

Unable to connect to the SQL content database from sharepoint web front server.



SharePoint farm is as below. 1 SQL, 1 WFE, 1 Application server. SQL 2005 and SharePoint 2007 with SP1.

SharePoint portal is working fine from 1 year, suddenly from today morning in the WFE eventvwr we are getting 27745, 3355 and 5586 event id errors. Site also giving error saying "unable to connect the content database". This is repeating for 10 to 15 min.

when ever these errors occur in eventvwr sharepoint will not work.

Please suggest on this issue.

waiting for MS replies..






How to add a Database Connection on Sharepoint Designer 2007 to access SQL 2005 tables?


I've tried and looked on many sites with different solutions for which non of them resolved my issue. I've a blank Sharepoint site and want to view data from an SQL DB. It says that a Server Error occurred and that the Data Retrieval Service didn't worked out while listing the DB's.

I tried using the 3 methods... using the also the connection string in different ways... when I do it using VB, Office and Java... I can see the data from that DB... why on Sharepoint Designer it doesn't? It supposed to be more easier than other tools.

I'm really desperate. Any help is very welcome.



ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend