Showing posts with label time. Show all posts
Showing posts with label time. Show all posts

Thursday, March 29, 2012

Deserialization failed

I am installing SSRS for the first time. I tried to create a simple report and I am getting the following error:

Deserialization failed: The type initializer for 'Microsoft.ReportDesigner.Drawing.RptStyleConstValue' threw an exception. Line 2, position 2.

Does anyone know how to fix this error?

Thanks,

Patrick

You have a problem http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=811976&SiteID=1 sql

Sunday, March 11, 2012

Deploying Reports in Visual Studio

About half the time I try to deploy a report in Visual Studio, I do not get
prompted for a user name or password and then get a message that says the
user does not have sufficient rights. Sometimes rebooting the computer will
help but not always. I was told that it is a credential caching problem.
Does anyone know how to get around this problem?try to save/reopen the report. If that doesn't work. close and re-run BIDs.
There are still some issues to be worked out with the dev environment.
--
Wayne Snyder MCDBA, SQL Server MVP
Mariner, Charlotte, NC
I support the Professional Association for SQL Server ( PASS) and it''s
community of SQL Professionals.
"Dave banker" wrote:
> About half the time I try to deploy a report in Visual Studio, I do not get
> prompted for a user name or password and then get a message that says the
> user does not have sufficient rights. Sometimes rebooting the computer will
> help but not always. I was told that it is a credential caching problem.
> Does anyone know how to get around this problem?

Deploying reports - Log In Screen

I have created a report, and want to now deploy it to the Report Server. Each time I try to do that, I get a Reporting Services Log In screen. I have no idea what to input, having tried my windows authentication and sa account without sucess. Is there something else that I need to set up so I can deploy my reports? Thanks in advance!

I've had the same problem. On Reports Manager, I went to the Data Source and set my security there.

I selected 'Credentials stored securely in the report server'.

I put in my username and password (domain\password).

I checked 'Use as Windows credentials when connecting to the data source'

Then after clicking apply, it worked.

Deploying report to multiple locations

We would like to be able to publish a report to more than 1 directory at the
same time. Is this or would this be possible? Currently, we deploy the base
report to a central location and create linked reports to all other locations.The benefit of using linked reports is that updating the report contents of
the original report will update the linked reports automatically. Note:
report parameters and data source settings won't get updated because they
are administrated separately for linked reports.
You may also want to check the following tool courtesy Jasper Smith (a SQL
Server MVP): http://www.sqldbatips.com/showarticle.asp?ID=62
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"clutch" <clutch@.discussions.microsoft.com> wrote in message
news:C16C6284-800A-41C1-822F-6C5FD518B727@.microsoft.com...
> We would like to be able to publish a report to more than 1 directory at
> the
> same time. Is this or would this be possible? Currently, we deploy the
> base
> report to a central location and create linked reports to all other
> locations.|||Thanks for the feedback. I was hoping you could answer one more thing.
Will it be possible to create a linked report, but have the ability to
select multiple locations at the same time? Rather than having to do each one
individually.
Thank you!
"Robert Bruckner [MSFT]" wrote:
> The benefit of using linked reports is that updating the report contents of
> the original report will update the linked reports automatically. Note:
> report parameters and data source settings won't get updated because they
> are administrated separately for linked reports.
> You may also want to check the following tool courtesy Jasper Smith (a SQL
> Server MVP): http://www.sqldbatips.com/showarticle.asp?ID=62
>
> -- Robert
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "clutch" <clutch@.discussions.microsoft.com> wrote in message
> news:C16C6284-800A-41C1-822F-6C5FD518B727@.microsoft.com...
> > We would like to be able to publish a report to more than 1 directory at
> > the
> > same time. Is this or would this be possible? Currently, we deploy the
> > base
> > report to a central location and create linked reports to all other
> > locations.
>
>|||No, you can only create one linked report at a time in report manager. But
since creating a linked report is just a SOAP-call (look for
CreateLinkedReport in BOL), you could write a RSS script which creates
multiple linked reports in a sequence.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"clutch" <clutch@.discussions.microsoft.com> wrote in message
news:08A92FF1-5327-435D-9877-D6A0179F0866@.microsoft.com...
> Thanks for the feedback. I was hoping you could answer one more thing.
> Will it be possible to create a linked report, but have the ability to
> select multiple locations at the same time? Rather than having to do each
> one
> individually.
> Thank you!
> "Robert Bruckner [MSFT]" wrote:
>> The benefit of using linked reports is that updating the report contents
>> of
>> the original report will update the linked reports automatically. Note:
>> report parameters and data source settings won't get updated because they
>> are administrated separately for linked reports.
>> You may also want to check the following tool courtesy Jasper Smith (a
>> SQL
>> Server MVP): http://www.sqldbatips.com/showarticle.asp?ID=62
>>
>> -- Robert
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>> "clutch" <clutch@.discussions.microsoft.com> wrote in message
>> news:C16C6284-800A-41C1-822F-6C5FD518B727@.microsoft.com...
>> > We would like to be able to publish a report to more than 1 directory
>> > at
>> > the
>> > same time. Is this or would this be possible? Currently, we deploy the
>> > base
>> > report to a central location and create linked reports to all other
>> > locations.
>>

Friday, March 9, 2012

deploying MSDE instance

Hi there,
I am having a hard time trying finding information on how to deploy my
instance along with my application. I found the following link to be useful
in attaching my database to the server
(http://support.microsoft.com/kb/q240293/) but how do I create that instance
for the attachment to occur. My application was coded using Visual C++ so
the deployment using the VB Package and Deployment Wizard does not apply. I
looked endless on the web on how to do this but to no avail.
I'm using Installshield X to package my install. I have it setup so that the
MSDE install folder is copied onto the c: drive. But I need to create the
instance in the command line using setup.exe. I don't know how to call the
command line within the Installshield script to create my instance. Am I
headed in the wrong direction or is there some easier way? Any help would be
much appreciated!
Hi
These may help!
http://msdn.microsoft.com/library/de...eddingmsde.asp
http://www.microsoft.com/sql/msde/te...ntegration.asp
John
"luv2travel" wrote:

> Hi there,
> I am having a hard time trying finding information on how to deploy my
> instance along with my application. I found the following link to be useful
> in attaching my database to the server
> (http://support.microsoft.com/kb/q240293/) but how do I create that instance
> for the attachment to occur. My application was coded using Visual C++ so
> the deployment using the VB Package and Deployment Wizard does not apply. I
> looked endless on the web on how to do this but to no avail.
> I'm using Installshield X to package my install. I have it setup so that the
> MSDE install folder is copied onto the c: drive. But I need to create the
> instance in the command line using setup.exe. I don't know how to call the
> command line within the Installshield script to create my instance. Am I
> headed in the wrong direction or is there some easier way? Any help would be
> much appreciated!
|||Thanks John!
"John Bell" wrote:
[vbcol=seagreen]
> Hi
> These may help!
> http://msdn.microsoft.com/library/de...eddingmsde.asp
> http://www.microsoft.com/sql/msde/te...ntegration.asp
> John
> "luv2travel" wrote:

deploying MSDE instance

Hi there,
I am having a hard time trying finding information on how to deploy my
instance along with my application. I found the following link to be useful
in attaching my database to the server
(http://support.microsoft.com/kb/q240293/) but how do I create that instance
for the attachment to occur. My application was coded using Visual C++ so
the deployment using the VB Package and Deployment Wizard does not apply. I
looked endless on the web on how to do this but to no avail.
I'm using Installshield X to package my install. I have it setup so that the
MSDE install folder is copied onto the c: drive. But I need to create the
instance in the command line using setup.exe. I don't know how to call the
command line within the Installshield script to create my instance. Am I
headed in the wrong direction or is there some easier way? Any help would be
much appreciated!Hi
These may help!
http://msdn.microsoft.com/library/d...beddingmsde.asp
http://www.microsoft.com/sql/msde/t...integration.asp
John
"luv2travel" wrote:

> Hi there,
> I am having a hard time trying finding information on how to deploy my
> instance along with my application. I found the following link to be usefu
l
> in attaching my database to the server
> (http://support.microsoft.com/kb/q240293/) but how do I create that instan
ce
> for the attachment to occur. My application was coded using Visual C++ so
> the deployment using the VB Package and Deployment Wizard does not apply.
I
> looked endless on the web on how to do this but to no avail.
> I'm using Installshield X to package my install. I have it setup so that t
he
> MSDE install folder is copied onto the c: drive. But I need to create the
> instance in the command line using setup.exe. I don't know how to call the
> command line within the Installshield script to create my instance. Am I
> headed in the wrong direction or is there some easier way? Any help would
be
> much appreciated!|||Thanks John!
"John Bell" wrote:
[vbcol=seagreen]
> Hi
> These may help!
> http://msdn.microsoft.com/library/d...beddingmsde.asp
> http://www.microsoft.com/sql/msde/t...integration.asp
> John
> "luv2travel" wrote:
>

deploying MSDE instance

Hi there,
I am having a hard time trying finding information on how to deploy my
instance along with my application. I found the following link to be useful
in attaching my database to the server
(http://support.microsoft.com/kb/q240293/) but how do I create that instance
for the attachment to occur. My application was coded using Visual C++ so
the deployment using the VB Package and Deployment Wizard does not apply. I
looked endless on the web on how to do this but to no avail.
I'm using Installshield X to package my install. I have it setup so that the
MSDE install folder is copied onto the c: drive. But I need to create the
instance in the command line using setup.exe. I don't know how to call the
command line within the Installshield script to create my instance. Am I
headed in the wrong direction or is there some easier way? Any help would be
much appreciated!Hi
These may help!
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql2k/html/sql_embeddingmsde.asp
http://www.microsoft.com/sql/msde/techinfo/MSDEintegration.asp
John
"luv2travel" wrote:
> Hi there,
> I am having a hard time trying finding information on how to deploy my
> instance along with my application. I found the following link to be useful
> in attaching my database to the server
> (http://support.microsoft.com/kb/q240293/) but how do I create that instance
> for the attachment to occur. My application was coded using Visual C++ so
> the deployment using the VB Package and Deployment Wizard does not apply. I
> looked endless on the web on how to do this but to no avail.
> I'm using Installshield X to package my install. I have it setup so that the
> MSDE install folder is copied onto the c: drive. But I need to create the
> instance in the command line using setup.exe. I don't know how to call the
> command line within the Installshield script to create my instance. Am I
> headed in the wrong direction or is there some easier way? Any help would be
> much appreciated!|||Thanks John!
"John Bell" wrote:
> Hi
> These may help!
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql2k/html/sql_embeddingmsde.asp
> http://www.microsoft.com/sql/msde/techinfo/MSDEintegration.asp
> John
> "luv2travel" wrote:
> > Hi there,
> >
> > I am having a hard time trying finding information on how to deploy my
> > instance along with my application. I found the following link to be useful
> > in attaching my database to the server
> > (http://support.microsoft.com/kb/q240293/) but how do I create that instance
> > for the attachment to occur. My application was coded using Visual C++ so
> > the deployment using the VB Package and Deployment Wizard does not apply. I
> > looked endless on the web on how to do this but to no avail.
> >
> > I'm using Installshield X to package my install. I have it setup so that the
> > MSDE install folder is copied onto the c: drive. But I need to create the
> > instance in the command line using setup.exe. I don't know how to call the
> > command line within the Installshield script to create my instance. Am I
> > headed in the wrong direction or is there some easier way? Any help would be
> > much appreciated!