Error creating new SSIS project

In my local client installation of the BI tools, I get the following error when simply creating an SSIS project and the default empty Package tries to display on the screen.

Index (zero based) must be greater than or equal to zero and less than the size of the argument list.

I can use the Reporting Services designer with no problems, and I can use SSIS from the client tools on the server. It is just on my local PC that I get this error. I have completely uninstalled all the tools and reinstalled with no luck.

PLEASE HELP!

If anyone can help, please reply. I am unable to use SSIS AT ALL right now because a new package will only display this error message. And this is the purchased version, not the evaluation copy.

Here is the full message

Microsoft Visual Studio is unable to load this document:
Index (zero based) must be greater than or equal to zero and less than the size of the argument list.

|||

I know it looks like I'm being a pest by bumping my post again, but I am not able to use SSIS at all on my PC. I HAVE TO get this resolved.

I am on Windows XP Pro fully patched and updated. I had SQL Express on my PC before and have since uninstalled it to see if that would help.

PLEASE HELP!!!

Error connecting to remote connections...

That's what appears at my client site. I have virtually the exact same
configuration on a handful of servers using the SQL Reporting Services and
the RDLC which is working great. Except this one server has:
"An error has occurred when establishing a connection to the server. When
connecting to SQL Server 2005, this failure may be caused by teh fact that
under the default settings SQL Server does not allow remote connections.
Named Pipes provider, error: 40 - Could not open a connection to the SQL
Server).
I think the IT admin used SQL permissions when he installed. Could that be
the problem?
Thanks in Advance.
ChrisThis link might help,
http://vadivel.blogspot.com/2007/01/error-has-occurred-while-establishing.html.
daw
"Chris Marsh" wrote:
> That's what appears at my client site. I have virtually the exact same
> configuration on a handful of servers using the SQL Reporting Services and
> the RDLC which is working great. Except this one server has:
> "An error has occurred when establishing a connection to the server. When
> connecting to SQL Server 2005, this failure may be caused by teh fact that
> under the default settings SQL Server does not allow remote connections.
> Named Pipes provider, error: 40 - Could not open a connection to the SQL
> Server).
> I think the IT admin used SQL permissions when he installed. Could that be
> the problem?
> Thanks in Advance.
> Chris
>
>|||Sorry, I should have specified this earlier but the SQL DB is SQL 2000 not
2005 which is what is strange. Again, works on multiple other configurations
but not this one.
"daw" <daw@.discussions.microsoft.com> wrote in message
news:D05FF90C-2A0D-43B9-83B4-D348859995E9@.microsoft.com...
> This link might help,
> http://vadivel.blogspot.com/2007/01/error-has-occurred-while-establishing.html.
> daw
> "Chris Marsh" wrote:
>> That's what appears at my client site. I have virtually the exact same
>> configuration on a handful of servers using the SQL Reporting Services
>> and
>> the RDLC which is working great. Except this one server has:
>> "An error has occurred when establishing a connection to the server. When
>> connecting to SQL Server 2005, this failure may be caused by teh fact
>> that
>> under the default settings SQL Server does not allow remote connections.
>> Named Pipes provider, error: 40 - Could not open a connection to the SQL
>> Server).
>> I think the IT admin used SQL permissions when he installed. Could that
>> be
>> the problem?
>> Thanks in Advance.
>> Chris
>>

Error connecting to Oracle via linked server after SP2 installatio

We have a test SQL Server box configured with the following:
Windows 2000, SP4
SQL Server: 8.00.944
Oracle Client Tools: 9.2.0.1
Microsoft ODBC for Oracle: 2.573.9030.00
We built a linked server to a 3rd party Oracle application. We used the
standard "Microsoft OLE DB Provider for Oracle" drvier from the drop down
list. We created views using this linked server and they worked fine.
However, after installing SP2 of Reporting Services, we now receive the
following error when we attempt to use the views:
[Microsoft][ODBC SQL Server Driver][SQL Server][OLE/DB provider returned
error message: Oracle client and networking components not found. These
components are supplied by Oracle Corporation and are part of the Oracle
Version 7.3.3 or later client software installation.
Provider is unable to function until these components are installed.]
We use a free SQL Tool called "Toad" to access the Oracle environment. This
tool uses the same Oracle Client Tools referred to in the error message.
This tool continues to function normally.
We really want to take advantage of some of the new features in SP2, but we
can't deploy this on our production SQL Reporting box until we get this issue
resolved. Any help in this matter would be greatly appreciated. Thanks!
--
Grande ApplicationsHello,
Microsoft OLE DB Provider for Oracle and Microsoft ODBC Driver for Oracle
are not supported with any Oracle versions later than 8i. For more
information, click the following article number to view the article in the
Microsoft Knowledge Base:
244661 Limitations of Microsoft Oracle ODBC Driver and OLE DB Provider
http://support.microsoft.com/default.aspx?scid=KB;EN-US;244661
Therefore, the cause of the issue is not related to the reporting service.
If you want to use Oracle version 9i, you can use the following settings in
step 3 of this procedure in the article 280106:
280106 How to set up and troubleshoot a linked server to Oracle in SQL
Server
http://support.microsoft.com/?id=280106
However, this configuration is not supported and is discouraged.
Oracle Client Microsoft Windows 2000
9.x
[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSDTC\MTxOCI]
"OracleXaLib"="oraclient9.dll"
"OracleSqlLib"="orasql9.dll"
"OracleOciLib"="oci.dll"
You can refer to the article 280106 to set up and troubleshoot a linked
server. I hope the information is helpful.
Sophie Guo
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
=====================================================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 Sophie,
Thanks much for your response. We were able to resolve the problem by
restarting the SQL server (SQL Server service); however, we have discovered
from others that this resolution has been known to provide only a temporary
fix.
Do you know where I can find a list of all of the files (and file versions)
installed and updated by Reporting Services SP 2? This would be very helpful
to us.
Thank you.
Grande Applications
Thank you
"Sophie Guo [MSFT]" wrote:
> Hello,
> Microsoft OLE DB Provider for Oracle and Microsoft ODBC Driver for Oracle
> are not supported with any Oracle versions later than 8i. For more
> information, click the following article number to view the article in the
> Microsoft Knowledge Base:
> 244661 Limitations of Microsoft Oracle ODBC Driver and OLE DB Provider
> http://support.microsoft.com/default.aspx?scid=KB;EN-US;244661
> Therefore, the cause of the issue is not related to the reporting service.
> If you want to use Oracle version 9i, you can use the following settings in
> step 3 of this procedure in the article 280106:
> 280106 How to set up and troubleshoot a linked server to Oracle in SQL
> Server
> http://support.microsoft.com/?id=280106
> However, this configuration is not supported and is discouraged.
> Oracle Client Microsoft Windows 2000
> 9.x
> [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSDTC\MTxOCI]
> "OracleXaLib"="oraclient9.dll"
> "OracleSqlLib"="orasql9.dll"
> "OracleOciLib"="oci.dll"
>
> You can refer to the article 280106 to set up and troubleshoot a linked
> server. I hope the information is helpful.
> Sophie Guo
> Microsoft Online Partner Support
> Get Secure! - www.microsoft.com/security
> =====================================================> 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.
>
>

Error connecting from classic ASP

I'm haveing some problems with using SQL Server in a classic ASP app.

When trying to connect with the db I get the error:

Microsoft SQL Native Client error '80004005'

TCP Provider: No connection could be made because the target machine actively refused it.

The Windows 2003 server runs both the SQL server 2005 express and IIS.

Connectionstring: "Provider=SQLNCLI;Server=KSP;Database=KSB;UID=sa;PWD=;"

I don't have a good answer for this one; it seems a bit like a permissions issue, you might want to check what user context your ASP app is running in and make sure that user has permission to the database file or server.

You should also consider asking this question in the .NET Data Access forum or in the ASP.NET fourms. The folks that hang out there have probably had more experience with ASP than I have.

Regards,

Mike Wachal
SQL Express team

-
Check out my tips for getting your answer faster and how to ask a good question: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=307712&SiteID=1

|||

Sql server express is a named instance, so you need to specify <servername>\sqlexpress in you connection string.

Check this out.

http://blogs.msdn.com/sql_protocols/archive/2006/03/23/558651.aspx

|||

Thank both of you for your advice. It was the <servername>\sqlexpress which was the problem.

Error after sp2 install

After installing sp2 on my production server ( went well in dev and qa) I got
this message:
Client found response content type of 'text/html; charset=utf-8', but
expected 'text/xml'. The request failed with the error message: -- <html>
<head> <title> SQL Server Reporting Services </title><meta name="Generator"
content="Microsoft SQL Server Reporting Services 9.00.2047.00" /> <meta
name="HTTP Status" content="500" /> <meta name="ProductLocaleID" content="9"
/> <meta name="CountryLocaleID" content="1033" /> <meta name="StackTrace"
content=" at Microsoft.ReportingServices.Diagnostics.RSConfiguration.Load()
at
Microsoft.ReportingServices.Diagnostics.RSConfigurationManager..ctor(String
configFileName, String configLocation) at
Microsoft.ReportingServices.Library.Global.get_ConfigurationManager() at
Microsoft.ReportingServices.WebServer.Global.StartApp() at
Microsoft.ReportingServices.WebServer.Global.Application_BeginRequest(Object
sender, EventArgs e)" /> <style> BODY {FONT-FAMILY:Verdana;
FONT-WEIGHT:normal; FONT-SIZE: 8pt; COLOR:black} H1 {FONT-FAMILY:Verdana;
FONT-WEIGHT:700; FONT-SIZE:15pt} LI {FONT-FAMILY:Verdana; FONT-WEIGHT:normal;
FONT-SIZE:8pt; DISPLAY:inline} .ProductInfo {FONT-FAMILY:Verdana;
FONT-WEIGHT:bold; FONT-SIZE: 8pt; COLOR:gray} A:link {FONT-SIZE: 8pt;
FONT-FAMILY:Verdana; COLOR:#3366CC; TEXT-DECORATION:none} A:hover {FONT-SIZE:
8pt; FONT-FAMILY:Verdana; COLOR:#FF3300; TEXT-DECORATION:underline} A:visited
{FONT-SIZE: 8pt; FONT-FAMILY:Verdana; COLOR:#3366CC; TEXT-DECORATION:none}
A:visited:hover {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; color:#FF3300;
TEXT-DECORATION:underline} </style> </head><body bgcolor="white"> <h1>
Reporting Services Error<hr width="100%" size="1" color="silver" /> </h1><ul>
<li>The report server has encountered a configuration error. See the report
server log files for more information. (rsServerConfigurationError) </li><ul>
<li>Access to the path 'C:\Program Files\Microsoft SQL
Server\MSSQL.2\Reporting Services\ReportServer\RSReportServer.config' is
denied.</li> </ul> </ul><hr width="100%" size="1" color="silver" /><span
class="ProductInfo">SQL Server Reporting Services</span> </body> </html> --.
I'd really appriciate help on this!!
FredHaving same problem, any solution?
"Fred" wrote:
> After installing sp2 on my production server ( went well in dev and qa) I got
> this message:
> Client found response content type of 'text/html; charset=utf-8', but
> expected 'text/xml'. The request failed with the error message: -- <html>
> <head> <title> SQL Server Reporting Services </title><meta name="Generator"
> content="Microsoft SQL Server Reporting Services 9.00.2047.00" /> <meta
> name="HTTP Status" content="500" /> <meta name="ProductLocaleID" content="9"
> /> <meta name="CountryLocaleID" content="1033" /> <meta name="StackTrace"
> content=" at Microsoft.ReportingServices.Diagnostics.RSConfiguration.Load()
> at
> Microsoft.ReportingServices.Diagnostics.RSConfigurationManager..ctor(String
> configFileName, String configLocation) at
> Microsoft.ReportingServices.Library.Global.get_ConfigurationManager() at
> Microsoft.ReportingServices.WebServer.Global.StartApp() at
> Microsoft.ReportingServices.WebServer.Global.Application_BeginRequest(Object
> sender, EventArgs e)" /> <style> BODY {FONT-FAMILY:Verdana;
> FONT-WEIGHT:normal; FONT-SIZE: 8pt; COLOR:black} H1 {FONT-FAMILY:Verdana;
> FONT-WEIGHT:700; FONT-SIZE:15pt} LI {FONT-FAMILY:Verdana; FONT-WEIGHT:normal;
> FONT-SIZE:8pt; DISPLAY:inline} .ProductInfo {FONT-FAMILY:Verdana;
> FONT-WEIGHT:bold; FONT-SIZE: 8pt; COLOR:gray} A:link {FONT-SIZE: 8pt;
> FONT-FAMILY:Verdana; COLOR:#3366CC; TEXT-DECORATION:none} A:hover {FONT-SIZE:
> 8pt; FONT-FAMILY:Verdana; COLOR:#FF3300; TEXT-DECORATION:underline} A:visited
> {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; COLOR:#3366CC; TEXT-DECORATION:none}
> A:visited:hover {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; color:#FF3300;
> TEXT-DECORATION:underline} </style> </head><body bgcolor="white"> <h1>
> Reporting Services Error<hr width="100%" size="1" color="silver" /> </h1><ul>
> <li>The report server has encountered a configuration error. See the report
> server log files for more information. (rsServerConfigurationError) </li><ul>
> <li>Access to the path 'C:\Program Files\Microsoft SQL
> Server\MSSQL.2\Reporting Services\ReportServer\RSReportServer.config' is
> denied.</li> </ul> </ul><hr width="100%" size="1" color="silver" /><span
> class="ProductInfo">SQL Server Reporting Services</span> </body> </html> --.
> I'd really appriciate help on this!!
> Fred|||Me too!
Browser window error:
â?¢ The report server has encountered a configuration error. See the report
server log files for more information. (rsServerConfigurationError)
o Access to the path 'c:\Program Files\Microsoft SQL
Server\MSSQL.3\Reporting Services\ReportServer\RSReportServer.config' is
denied.
<Header>
<Product>Microsoft SQL Server Reporting Services Version
9.00.3042.00</Product>
<Locale>en-US</Locale>
<TimeZone>Eastern Standard Time</TimeZone>
<Path>c:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting
Services\LogFiles\ReportServer__03_08_2007_15_56_35.log</Path>
<SystemName>TESS-RCREPS</SystemName>
<OSName>Microsoft Windows NT 5.1.2600 Service Pack 2</OSName>
<OSVersion>5.1.2600.131072</OSVersion>
</Header>
aspnet_wp!webserver!1!3/8/2007-15:56:37:: i INFO: Reporting Web Server started
aspnet_wp!diagnostic!1!3/8/2007-15:56:37:: Error loading configuration file:
Access to the path 'c:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting
Services\ReportServer\RSReportServer.config' is denied.
aspnet_wp!library!1!3/8/2007-15:56:38:: e ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException:
The report server has encountered a configuration error. See the report
server log files for more information., ;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException:
The report server has encountered a configuration error. See the report
server log files for more information. -->
System.UnauthorizedAccessException: Access to the path 'c:\Program
Files\Microsoft SQL Server\MSSQL.3\Reporting
Services\ReportServer\RSReportServer.config' is denied.
at System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath)
at System.IO.FileStream.Init(String path, FileMode mode, FileAccess
access, Int32 rights, Boolean useRights, FileShare share, Int32 bufferSize,
FileOptions options, SECURITY_ATTRIBUTES secAttrs, String msgPath, Boolean
bFromProxy)
at System.IO.FileStream..ctor(String path, FileMode mode, FileAccess
access, FileShare share)
at
Microsoft.ReportingServices.Diagnostics.Globals.SafeOpenXmlDocumentFile(XmlDocument doc, String pathToXmlFile)
at Microsoft.ReportingServices.Diagnostics.RSConfiguration.LoadDocument()
at Microsoft.ReportingServices.Diagnostics.RSConfiguration.Load()
-- End of inner exception stack trace --
aspnet_wp!diagnostic!1!3/8/2007-15:56:38:: Error loading configuration file:
Access to the path 'c:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting
Services\ReportServer\RSReportServer.config' is denied.
aspnet_wp!library!1!3/8/2007-15:56:38:: e ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException:
The report server has encountered a configuration error. See the report
server log files for more information., ;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException:
The report server has encountered a configuration error. See the report
server log files for more information. -->
System.UnauthorizedAccessException: Access to the path 'c:\Program
Files\Microsoft SQL Server\MSSQL.3\Reporting
Services\ReportServer\RSReportServer.config' is denied.
at System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath)
at System.IO.FileStream.Init(String path, FileMode mode, FileAccess
access, Int32 rights, Boolean useRights, FileShare share, Int32 bufferSize,
FileOptions options, SECURITY_ATTRIBUTES secAttrs, String msgPath, Boolean
bFromProxy)
at System.IO.FileStream..ctor(String path, FileMode mode, FileAccess
access, FileShare share)
at
Microsoft.ReportingServices.Diagnostics.Globals.SafeOpenXmlDocumentFile(XmlDocument doc, String pathToXmlFile)
at Microsoft.ReportingServices.Diagnostics.RSConfiguration.LoadDocument()
at Microsoft.ReportingServices.Diagnostics.RSConfiguration.Load()
-- End of inner exception stack trace --
"Joe S." wrote:
> Having same problem, any solution?
> "Fred" wrote:
> > After installing sp2 on my production server ( went well in dev and qa) I got
> > this message:
> >
> > Client found response content type of 'text/html; charset=utf-8', but
> > expected 'text/xml'. The request failed with the error message: -- <html>
> > <head> <title> SQL Server Reporting Services </title><meta name="Generator"
> > content="Microsoft SQL Server Reporting Services 9.00.2047.00" /> <meta
> > name="HTTP Status" content="500" /> <meta name="ProductLocaleID" content="9"
> > /> <meta name="CountryLocaleID" content="1033" /> <meta name="StackTrace"
> > content=" at Microsoft.ReportingServices.Diagnostics.RSConfiguration.Load()
> > at
> > Microsoft.ReportingServices.Diagnostics.RSConfigurationManager..ctor(String
> > configFileName, String configLocation) at
> > Microsoft.ReportingServices.Library.Global.get_ConfigurationManager() at
> > Microsoft.ReportingServices.WebServer.Global.StartApp() at
> > Microsoft.ReportingServices.WebServer.Global.Application_BeginRequest(Object
> > sender, EventArgs e)" /> <style> BODY {FONT-FAMILY:Verdana;
> > FONT-WEIGHT:normal; FONT-SIZE: 8pt; COLOR:black} H1 {FONT-FAMILY:Verdana;
> > FONT-WEIGHT:700; FONT-SIZE:15pt} LI {FONT-FAMILY:Verdana; FONT-WEIGHT:normal;
> > FONT-SIZE:8pt; DISPLAY:inline} .ProductInfo {FONT-FAMILY:Verdana;
> > FONT-WEIGHT:bold; FONT-SIZE: 8pt; COLOR:gray} A:link {FONT-SIZE: 8pt;
> > FONT-FAMILY:Verdana; COLOR:#3366CC; TEXT-DECORATION:none} A:hover {FONT-SIZE:
> > 8pt; FONT-FAMILY:Verdana; COLOR:#FF3300; TEXT-DECORATION:underline} A:visited
> > {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; COLOR:#3366CC; TEXT-DECORATION:none}
> > A:visited:hover {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; color:#FF3300;
> > TEXT-DECORATION:underline} </style> </head><body bgcolor="white"> <h1>
> > Reporting Services Error<hr width="100%" size="1" color="silver" /> </h1><ul>
> > <li>The report server has encountered a configuration error. See the report
> > server log files for more information. (rsServerConfigurationError) </li><ul>
> > <li>Access to the path 'C:\Program Files\Microsoft SQL
> > Server\MSSQL.2\Reporting Services\ReportServer\RSReportServer.config' is
> > denied.</li> </ul> </ul><hr width="100%" size="1" color="silver" /><span
> > class="ProductInfo">SQL Server Reporting Services</span> </body> </html> --.
> >
> > I'd really appriciate help on this!!
> >
> > Fred|||Deleting encrypted content in RS configuration fixed this for us.|||I got my RS working again. Originally my IIS 6.0 was running in 32 bit mode
for the RS. The SP2 upgrade it appears changed the RS to need 64 bit for
which the OS and SQL are both running. By changing IIS not to run 32 bit apps
the RS web pages appeared again.
"Fred" wrote:
> After installing sp2 on my production server ( went well in dev and qa) I got
> this message:
> Client found response content type of 'text/html; charset=utf-8', but
> expected 'text/xml'. The request failed with the error message: -- <html>
> <head> <title> SQL Server Reporting Services </title><meta name="Generator"
> content="Microsoft SQL Server Reporting Services 9.00.2047.00" /> <meta
> name="HTTP Status" content="500" /> <meta name="ProductLocaleID" content="9"
> /> <meta name="CountryLocaleID" content="1033" /> <meta name="StackTrace"
> content=" at Microsoft.ReportingServices.Diagnostics.RSConfiguration.Load()
> at
> Microsoft.ReportingServices.Diagnostics.RSConfigurationManager..ctor(String
> configFileName, String configLocation) at
> Microsoft.ReportingServices.Library.Global.get_ConfigurationManager() at
> Microsoft.ReportingServices.WebServer.Global.StartApp() at
> Microsoft.ReportingServices.WebServer.Global.Application_BeginRequest(Object
> sender, EventArgs e)" /> <style> BODY {FONT-FAMILY:Verdana;
> FONT-WEIGHT:normal; FONT-SIZE: 8pt; COLOR:black} H1 {FONT-FAMILY:Verdana;
> FONT-WEIGHT:700; FONT-SIZE:15pt} LI {FONT-FAMILY:Verdana; FONT-WEIGHT:normal;
> FONT-SIZE:8pt; DISPLAY:inline} .ProductInfo {FONT-FAMILY:Verdana;
> FONT-WEIGHT:bold; FONT-SIZE: 8pt; COLOR:gray} A:link {FONT-SIZE: 8pt;
> FONT-FAMILY:Verdana; COLOR:#3366CC; TEXT-DECORATION:none} A:hover {FONT-SIZE:
> 8pt; FONT-FAMILY:Verdana; COLOR:#FF3300; TEXT-DECORATION:underline} A:visited
> {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; COLOR:#3366CC; TEXT-DECORATION:none}
> A:visited:hover {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; color:#FF3300;
> TEXT-DECORATION:underline} </style> </head><body bgcolor="white"> <h1>
> Reporting Services Error<hr width="100%" size="1" color="silver" /> </h1><ul>
> <li>The report server has encountered a configuration error. See the report
> server log files for more information. (rsServerConfigurationError) </li><ul>
> <li>Access to the path 'C:\Program Files\Microsoft SQL
> Server\MSSQL.2\Reporting Services\ReportServer\RSReportServer.config' is
> denied.</li> </ul> </ul><hr width="100%" size="1" color="silver" /><span
> class="ProductInfo">SQL Server Reporting Services</span> </body> </html> --.
> I'd really appriciate help on this!!
> Fred