Microsoft SQL Server 2005 Reporting Services -- Error 1303

I am trying to install Microsoft SQL Server 2005 Reporting Services, Receiving the following error

Microsoft SQL Server 2005 Reporting Services -- Error 1303. The installer has insufficient privileges to access this directory: C:\Config.Msi. The installation cannot continue. Log on as administrator or contact your system administrator.

I am already logged in as Administrator and should have all the necessary permissions to install software

Please help me.

I think you accidentally got the wrong forum for this. This is the replication forum. I suggest reposting your question in the SQL Server Reporting Services forum.

Phil Garding

|||Thankssql

Microsoft SQL Server 2005 Integration Services book by Kirk Haselden

Hello, I would love to know where people are discussing the book Microsoft SQL Server 2005 Integration Services book by Kirk Hasleden.

I'm on page 41 and I'm getting an error with the example in the "SELECT "2004" FROM Sales.vSalesPersonSalesByFiscalYears"
part because there is not a table called Sales.vSalesPersonSalesByFiscalYears in the AdventureWorks database.

Thank youoThat view exists in mine.|||Ok thanks - I didn't realize it was a view. Got it working...

Microsoft SQL Server 2005 DTS Designer Components

Hi,

I learned this from one of SSIS book-Migrating from Data Transformation Services to Integration Services in SQL.

For the design time components, Microsoft has created a special distribution called the Microsoft SQL Server 2005 DTS Designer Components. The Designer Components distribution replaces the components that get uninstalled when you upgrade your last instance of SQL Server 2000. If you want to upgrade all your SQL Server 2000 instances, this is the best and only option for recovering the DTS designer.

Is anybody heard of this 2005 DTS Designer component?

Where to download? How it works? Any experience to will be appreciated.

Thanks,

Charley

Some info here-

DTS2000
(http://wiki.sqlis.com/default.aspx/SQLISWiki/DTS2000.html)

|||

Thanks so much.

Charley

Microsoft SQL Server 2000 Reporting Services

I understand that this is available for free but I have not been able to find it for downloading. Can anyone point me in the right direction for this? Do you know does it really require alot of resources like I have been reading. People recomending a seperate SQL box just for thes reporting services. Please advise.

You can download evaluaiton copy from here.

Also you can download SP2 for RS 2000 here.

|||Thank you.... but my understanding was that I could get a regular copy vs. evaluation copy for free. Microsoft was letting SQL 2000 users have the reporting services until they upgraded to SQL 2005 which would have it in it. Do you know where you can get a regular copy?|||I am curious where this was mentioned. As far as your performance question, it is true that processing reports is an intensive task. However, a single box should more than enough to handle low to medium report loads. Besides, it will save you money if you host the database engine on the same server.

Microsoft SQL 2000 Reporting Services

Has anyone who is involved in testing the Beta 2 version of this SQL
add-on (reporting services) needed to implement a calendar control as
a means to obtain parameter criteria?
Is this possible to place and then fire the calendar control on a
report and then populate a field with the date that was selected on
the control.
Cheers
GrantHi
As this is a beta you are probably governed by an NDA, therefore a public
newsgroup is not the appropriate place for a question like this.
John
"GrantS" <sutcliffe_grant@.hotmail.com> wrote in message
news:6963940b.0312221250.5afb1f75@.posting.google.com...
> Has anyone who is involved in testing the Beta 2 version of this SQL
> add-on (reporting services) needed to implement a calendar control as
> a means to obtain parameter criteria?
> Is this possible to place and then fire the calendar control on a
> report and then populate a field with the date that was selected on
> the control.
> Cheers
> Grant|||Oops! OK - Thanks John.

Microsoft Search service vulnerabilities

I am working on a "best practices" document for my company and came across
the suggestion to disable any unnecessary SQL Server services. We do not us
e
full-text search so we have no need for the service. However, I would like
to be able to provide reasons why this service should be disabled. I've
searched for vulnerabilites related to the Microsoft Search service and have
come up empty. Does anyone know of any vulnerabilities?
Thanks!I'm not aware of any vulnerabilities but it's still a good idea to shut it
down if you know you are not going to use it. That way, if someone comes up
with an attack later, you aren't at risk. Reducing the surface that an
attacker can attack to only what's required is always a good idea.
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"cltdba" <cltdba@.discussions.microsoft.com> wrote in message
news:14FA55C3-C274-458F-B7A8-ABB90EAD3E2C@.microsoft.com...
>I am working on a "best practices" document for my company and came across
> the suggestion to disable any unnecessary SQL Server services. We do not
> use
> full-text search so we have no need for the service. However, I would
> like
> to be able to provide reasons why this service should be disabled. I've
> searched for vulnerabilites related to the Microsoft Search service and
> have
> come up empty. Does anyone know of any vulnerabilities?
> Thanks!

Microsoft reporting Services Support & Changes

Hi We are planning to install the Reporting Services, but have been given a very negative feedback by some companies which planned to move to this.

The type of uncertainities that are coming through are:
1) product may either undergo a signifcant change
2) lose support

Can anyone help me with these questions, as i myself believe that it is hard to imagine such a big change.

Let me know what you think about this?

Thanking you in anticipation,

Kind Regards,
NittoWhat information did those companies base their opinions on? It sounds very subjective to me. The ease of report design/deployment, and flexibility is enough for the two companies I do independant contracting for to proceed full steam with this.|||Hi,
They were not willing to give any concrete answers, but asked us to investiagate more into Microsoft's decisions on changing the product and Support.

Does anyone think that such a big change is possible?

Thanks, Nitto|||As part of the development team, I can assure you that we are moving forward with Reporting Services, as evidenced by our SQL 2005 release. While competitors might like to think otherwise, RS has a bright future.

Brian Welcker
Group Program Manager
Reporting Services

Microsoft Reporting Services - Error - Expects Parameter - Stored Procedure

Solution:
This happens to me quite a bit...its because the designer removes the
code that defines what
values are passed to your stored procedure.
You have to select the report you're working on > Right-Click 'Code' >
Locate the <Query> XML tag...and you'll have to re-define the
<QueryParameters>.
<Query>
<DataSourceName>GPS</DataSourceName>
<CommandType>StoredProcedure</CommandType>
<CommandText>spLRGetLeadRotationSummary</CommandText>
<QueryParameters>
<QueryParameter Name="@.StartDate">
<Value>=Parameters!StartDate.Value</Value>
</QueryParameter>
<QueryParameter Name="@.EndDate">
<Value>=Parameters!EndDate.Value</Value>
</QueryParameter>
<QueryParameter Name="@.RegionID">
<Value>=Parameters!RegionID.Value</Value>
</QueryParameter>
</QueryParameters>
</Query>You can also do this by clicking on the ..., parameters tab. Modifying the
xml is dangerous. Although if you have a lot of query parameters and RS
keeps losing it then I have sometimes saved the section off so I could copy
it back in.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
<petejk@.gmail.com> wrote in message
news:1135124852.986963.63390@.f14g2000cwb.googlegroups.com...
> Solution:
> This happens to me quite a bit...its because the designer removes the
> code that defines what
> values are passed to your stored procedure.
> You have to select the report you're working on > Right-Click 'Code' >
> Locate the <Query> XML tag...and you'll have to re-define the
> <QueryParameters>.
>
> <Query>
> <DataSourceName>GPS</DataSourceName>
> <CommandType>StoredProcedure</CommandType>
> <CommandText>spLRGetLeadRotationSummary</CommandText>
> <QueryParameters>
> <QueryParameter Name="@.StartDate">
> <Value>=Parameters!StartDate.Value</Value>
> </QueryParameter>
> <QueryParameter Name="@.EndDate">
> <Value>=Parameters!EndDate.Value</Value>
> </QueryParameter>
> <QueryParameter Name="@.RegionID">
> <Value>=Parameters!RegionID.Value</Value>
> </QueryParameter>
> </QueryParameters>
> </Query>
>

microsoft reporting services

Hi,
In Microsoft Abalysis Manager one can browse the cube data by right
clicking the cube and drag and drop columns to view data. Can the
same be achieved with reporting services.
Thanks in advance
BajiraoI'm not sure if I understand your question perfectly. There is a preview
function that you can use in the Report Designer that allows you to see what
a report would look like, plus you can preview the data set. If you're
asking whether or not you can query OLAP cubes from Reporting Services, the
answer is that you can, but you need to know MDX in order to do so.
We are working on a whitepaper that addresses this topic. It assumes you
already have good knowledge of MDX. Given the number
of inquiries, I've gone ahead and posted it over on the OLAP MSN group. You
can find it in the general discussion are of.
http://groups.msn.com/OLAPServicesDevelopersForum/
Sean
Sean
Sean Boon
SQL Server BI Product Unit
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm.
"Bajirao.B.T" <btbajirao@.yahoo.com> wrote in message
news:736f0ba3.0403180730.4e63cfd5@.posting.google.com...
> Hi,
> In Microsoft Abalysis Manager one can browse the cube data by right
> clicking the cube and drag and drop columns to view data. Can the
> same be achieved with reporting services.
> Thanks in advance
> Bajirao|||Thanks for the reply. I my be not clear in expressing what I want.
In microsoft analysis manager on right click, browse cube data > one
form pops up. There we can drag and drop dimensions from the top to work
area. So that the cube takes different shapes.
The same functionality I want to achieve in the web browser useng
Reporting services is that possible or not is my question.
Regards,
Bajirao
*** Sent via Developersdex http://www.examnotes.net ***
Don't just participate in USENET...get rewarded for it!

Microsoft Reporting Services

Folks --
Does anyone have any idea as to where I would go to find
help on getting the beta of Reporting Services up and
running?
Thanks
Pete HohenhausTry this page first
http://www.microsoft.com/technet/treeview/default.asp?url=/technet/prodtechnol/sql/next/rsdepgd.asp
And this is a chat link on RS
http://www.microsoft.com/technet/treeview/default.asp?url=/technet/itcommunity/chats/trans/sql/sql0625.asp
HTH
--
Ray Higdon MCSE, MCDBA, CCNA
--
"peteh@.180solutions.com" <anonymous@.discussions.microsoft.com> wrote in
message news:022701c3ac94$c4808480$a301280a@.phx.gbl...
> Folks --
> Does anyone have any idea as to where I would go to find
> help on getting the beta of Reporting Services up and
> running?
> Thanks
> Pete Hohenhaus|||Hey, Ray, thanks, man!
>--Original Message--
>Try this page first
>http://www.microsoft.com/technet/treeview/default.asp?
url=/technet/prodtechnol/sql/next/rsdepgd.asp
>And this is a chat link on RS
>http://www.microsoft.com/technet/treeview/default.asp?
url=/technet/itcommunity/chats/trans/sql/sql0625.asp
>HTH
>--
>Ray Higdon MCSE, MCDBA, CCNA
>--
>"peteh@.180solutions.com"
<anonymous@.discussions.microsoft.com> wrote in
>message news:022701c3ac94$c4808480$a301280a@.phx.gbl...
>> Folks --
>> Does anyone have any idea as to where I would go to
find
>> help on getting the beta of Reporting Services up and
>> running?
>> Thanks
>> Pete Hohenhaus
>
>.
>

Microsoft Reporting Services

Default value or value provided for the report parameter 'ParamaterName' is
not a valid value. (rsInvalidReportParameter)
I am getting this error when I am trying to run a deployed report.
However,
this is driving me mad because in the report preview within VS.Net the
report
works fine and i can choose the same parameter settings from within the dev
environment with no problems. I am populating this parameter with a
dropdown
with valid values from a sproc (and this I've done a thousand times before)
.
I can not figure out why it is throwing this error, particularly since it
works perfectly fine in the preview pane. How could it be crappin out when
I
deploy it?!?! I am going insane!
Pl. put in forum.
regards
Arvind Sharma
--
Message posted via http://www.sqlmonster.comOn the deployed report, in report manager, properties... is the prompt string
blank? If so it will try to render the report without prompting for input
which will throw that error.
"arvind sharma via SQLMonster.com" wrote:
> Default value or value provided for the report parameter 'ParamaterName' is
> not a valid value. (rsInvalidReportParameter)
> I am getting this error when I am trying to run a deployed report.
> However,
> this is driving me mad because in the report preview within VS.Net the
> report
> works fine and i can choose the same parameter settings from within the dev
> environment with no problems. I am populating this parameter with a
> dropdown
> with valid values from a sproc (and this I've done a thousand times before)
> ..
> I can not figure out why it is throwing this error, particularly since it
> works perfectly fine in the preview pane. How could it be crappin out when
> I
> deploy it?!?! I am going insane!
> Pl. put in forum.
> regards
> Arvind Sharma
> --
> Message posted via http://www.sqlmonster.com
>sql

Microsoft Releases Synchronization Services CTP

The Microsoft Synchronization Services for ADO.NET v1.0 CTP release appeared without fanfare on January 22, 2006. The release contains "v1.0 early CTP" bits for the sync framework and SQL Server 2005 Compact Edition (SSCE) v3.5, the Orcas successor to the SSCE v3.1 RTM bits, which Microsoft released on January 11, 2006. The current code name for Sync Services is OCS (for Occasionally Connected Systems).

Seems to me to resemble a "stealth release."

For more, see http://oakleafblog.blogspot.com/2007/01/microsoft-releases-synchronization.html.

Oops. Make that January 11, 2007!

--rj

Microsoft Please help-Web Service Problem

We had an app that called across to the web services to run batches of statements. Everything worked fine and now they stopped working. The report can still be ran from report manager. What things do we need to check to find the problem? Any help would be greatly appreciated.

Try turning on tracing and view the logs. Also see event viewer if there are any issues. It could be an issue with the app or connectivity instead of Reporting Services, since the web service is used to service Report Manager.

More info on logging.

http://msdn2.microsoft.com/en-us/library/ms156500.aspx

cheers,

Andrew

|||Thank you Andrew for your prompt response. We will look at the logs and see if that leads us in the right direction.|||

Some security patches were applied to the server in December. Is it possible that these could have messed with the way that authentication is handled?

Patches:

KB925398

KB925454

KB923689

KB911897

KB926247

KB923694

|||The app is getting the message back "The report server cannot open a connection to the report server database. A conection to the database is required for all requests and processing. SQL server does not exist or acess denied."|||Is it possible that any of these security patches could have messed with our authentication? Any suggestions Please.

Microsoft Ole db provider for Olap services 8.0

Hello Folks,

I am desperately trying to connect to AS using this provider. But when i attempt to connect to it using the UDL file i get the error message - "Provider is no longer available. Ensure that the provider is installed properly."

I have tried re-registering the files msolap80.dll and msmddo80.dll, but to no success.

thanks and have a great day!

Try installing "Microsoft SQL Server 2000 PivotTable Services " from http://www.microsoft.com/downloads/details.aspx?familyid=d09c1d60-a13c-4479-9b91-9e8b9d835cdc&displaylang=en

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

Microsoft OLE DB Provider for Analysis Services error 80004005

Hello

I get the following error message in one of my ASP applications:
--------------------------
Microsoft OLE DB Provider for Analysis Services error '80004005'
Cannot connect to the server '172.16.103.14'. The server is either not started or too busy.
--------------------------
The IIS server is on a different machine to the MSOLAP server.

When I change the ASP code to point the 'localhost' it runs fine so Im fairly confident the necessary db conn libraries are installed on the IIS server.

There does not appear to be any traffic between the IIS/MSOLAP servers. Although all TCP ports are open. Interestingly, there are other pages on the same site that access a SQL Server resident on the MSOLAP servers & there are no issues.

Any assistance on this matter would be greatly appreciated. (I am a relative novice re: ASP/MSOLAP/IIS etc)Howdy

Talk to your networking guys & check the Default Gateway setting for TCPIP on the server. Sounds like it cant find the server.

Can you ping the IP address from a dos window on the server?

Cheers

SG|||You should check client-library/server-library settings. You prolly have named pipes only and no TCP-IP connection set-up.|||Originally posted by sqlguy7777
Howdy

Talk to your networking guys & check the Default Gateway setting for TCPIP on the server. Sounds like it cant find the server.

Can you ping the IP address from a dos window on the server?

Cheers

SG

Everything seems to be in order on this front. You will note that connectivity to a SQL Server database on the application/database server from the ASP pages on the web server function OK.|||Originally posted by beyond cool
You should check client-library/server-library settings. You prolly have named pipes only and no TCP-IP connection set-up.

Everything seems to be in order on this front. Note that connectivity to a SQL Server database on the application/database server from the ASP pages on the web server function OK...unless im missing something here....|||Howdy kalaa,

Can you confirm you can do these things :

(1) Ping the SQL box by name from the web server from a dos window on the web server e.g. ping <SQL_Server_name>. This will test if you have connectivity to the SQL box from the web server and more importantly confirm the SQL box is recognised in DNS.

(2) you have a valid SQL user ID set up on the SQL box, and that user ID has at least read access in the required database on the SQL box.
This is the user ID that the web application will use to talk to the SQL box.

Cheers,

SG

Microsoft iSCSI Initiator & SQL Server services

Hello all,
I have Microsoft iSCSI Initiator (SAN) installed on a SQL Server machine and has this drive acting as a local drive. All the database's data files are residing on this drive, attached with SAN.
It runs as a service "Microsoft iSCSI Initiator" on the SQL Server machine.

Now the question is, when we restart the SQL Server all the databases change their status to "Suspect" and we have to stop all the sqlserver services (all the SQL instances) and start them all up. This is the only temporary solution we came up with.
Could any one has any real solution or had encounter such a problem before?

Any help is appreciated.

Thanks bunch!
imransi.Looks like your SQL Service starts before your SAN is available.|||Originally posted by rdjabarov
Looks like your SQL Service starts before your SAN is available.

You are 100% right. So thats why we are restarting SQL services.
We can manually start sql services but thats not what we wnat and really thsi should not be the solutuion ;)|||See if you can "impose" a dependency on MSSQLSERVER service in regards to this SAN service.

Microsoft Excel Add-In for Analysis Services

Our customer is using the latest version of the Microsoft Excel Add-In for Analysis Services in a Microsoft Excel ver 10.6823.6735. When using a filter on a report that queries a SSAS 2005 (SP1) cube Excel stops responding. Does anyone have an idea what to do or what to look for? Any help is welcome.

Thanks

Hi,

By 'Stop responding',

Do you mean that excel does not display any data?

or applying the filter does not filter the necessary data?

Regards

sql

Microsoft CRM Picklist Fields in Reports

Hi,
I have experience with Crystal Report Designer and Microsoft CRM. I am now
writing reports in SQL Reporting Services. In Crystal when you add a
picklist field to a report you are able to pick a field called
CaseTypeCodeName and it automatically associates the IncidentBase table to
the StringMap table so that the values for the picklist field automatically
show up.
I do not see that feature in SQL Reporting Services. What I am wondering is
how did people get around this? Do I need a special SQL query to pull this
information?
Thanks!!Yeah, just create a UDF that pulls the appropriate StringMap value.
"Amy" <Amy@.discussions.microsoft.com> wrote in message
news:F6800BE4-2DA9-4803-88D6-4DBEEB170502@.microsoft.com...
> Hi,
> I have experience with Crystal Report Designer and Microsoft CRM. I am
now
> writing reports in SQL Reporting Services. In Crystal when you add a
> picklist field to a report you are able to pick a field called
> CaseTypeCodeName and it automatically associates the IncidentBase table to
> the StringMap table so that the values for the picklist field
automatically
> show up.
> I do not see that feature in SQL Reporting Services. What I am wondering
is
> how did people get around this? Do I need a special SQL query to pull
this
> information?
> Thanks!!

Microsoft Consulting Services

Hi,
Is it expensive to hire microsoft consulting services for 1Day consultation
?
Thanks,
AliDepending on what you looking for and where you are located.
Probably for around 120-200 dollars an hour, but less than 1000 per day.
May ask why?
Yovan
"A.M" <IHateSpam@.sapm123.com> wrote in message
news:ONemK7$dDHA.2076@.TK2MSFTNGP12.phx.gbl...
> Hi,
> Is it expensive to hire microsoft consulting services for 1Day
consultation
> ?
> Thanks,
> Ali
>|||To make sure everything is secure around our webserver.
"Yovan Fernandez" <yfernandez@.sai-inc.com> wrote in message
news:rdQ7b.1001$ev2.675885@.newssrv26.news.prodigy.com...
> Depending on what you looking for and where you are located.
> Probably for around 120-200 dollars an hour, but less than 1000 per day.
> May ask why?
> Yovan
> "A.M" <IHateSpam@.sapm123.com> wrote in message
> news:ONemK7$dDHA.2076@.TK2MSFTNGP12.phx.gbl...
> > Hi,
> >
> > Is it expensive to hire microsoft consulting services for 1Day
> consultation
> > ?
> >
> > Thanks,
> > Ali
> >
> >
>|||In article <rdQ7b.1001$ev2.675885@.newssrv26.news.prodigy.com>,
yfernandez@.sai-inc.com said...
> Depending on what you looking for and where you are located.
> Probably for around 120-200 dollars an hour, but less than 1000 per day.
I doubt you're going to get a decent one for one day for less than $1000.
I've worked with MS consultants on medium-term projects that were billing
well over $2k/day and that was six or seven years ago.
I would question the expertise of a specialist that is only charging
$1000/day. That doesn't mean he's not any good, but if he really is he
should be charging more, especially for a 1-day gig.|||Microsoft has recently released some free tools which will help evaluate
security... look for them on MS web site ,and start by following their
instructions... then decide on the consultant.
--
Wayne Snyder, MCDBA, SQL Server MVP
Computer Education Services Corporation (CESC), Charlotte, NC
www.computeredservices.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"A.M" <IHateSpam@.sapm123.com> wrote in message
news:ONemK7$dDHA.2076@.TK2MSFTNGP12.phx.gbl...
> Hi,
> Is it expensive to hire microsoft consulting services for 1Day
consultation
> ?
> Thanks,
> Ali
>|||Can i buy a $200 ticket and the guy from microsoft help me using phone?
"Brad" <me@.privacy.net> wrote in message
news:MPG.19c9bdf67f187e3c98b68d@.news...
> In article <rdQ7b.1001$ev2.675885@.newssrv26.news.prodigy.com>,
> yfernandez@.sai-inc.com said...
> > Depending on what you looking for and where you are located.
> >
> > Probably for around 120-200 dollars an hour, but less than 1000 per day.
> I doubt you're going to get a decent one for one day for less than $1000.
> I've worked with MS consultants on medium-term projects that were billing
> well over $2k/day and that was six or seven years ago.
> I would question the expertise of a specialist that is only charging
> $1000/day. That doesn't mean he's not any good, but if he really is he
> should be charging more, especially for a 1-day gig.|||Hello,
Microsoft Consulting Services assists end-user organizations and
third-party software developers worldwide to design and build information
technology solutions that leverage Microsoft technology. The kind of
support service which you choose depends on your situation. It is better to
contact a local Microsoft representative to get more information about
Microsoft Consulting Services.
Contact your local Microsoft representative:
U.S. Sales Offices
http://www.microsoft.com/usa/
Worldwide Sales Offices
http://www.microsoft.com/worldwide/
For further information regarding Microsoft Consulting Services, please
refer to the following article:
Microsoft Consulting Services
http://www.microsoft.com/business/services/mcs.asp
Regards,
Michael Shao
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.

Microsoft Atlas in Reports?

Can Atlas popups be used in reporting services?

Currently I have a javascript pop-up link that opens a new window. What I would like to do is change this to open an Atlas popup.

Thanks

can this be done?