Deployment to one Database 'Clearing' Another...

Hi,

We have a setup whereby our production server builds to a build cube overnight, and if and when this completes successfully, and passes sanity checks, it automatically backs up and restores the cube over the top of a 'live cube'.

This seemed like a fair enough plan - it allows developers to deploy to the production server without breaking the production-live cube, however, we have noticed that deploying to the build cube database sometimes results in the clearing out of the production cube database (much to the users' dismay!).

Anyone else seen anything similar, or have any ideas as to what the problem could be?

Thanks,

Will.

First time I hear about something like that.

Try and see if you can use Synchronization functionality to deploy your changes from test to production. This is more straightforward then backup-copy-restore.

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

|||

Hi Edward,

Thanks for your reply.

We currently build the cube on the production server (and 'deploy' the live cube to a databae on the same server) - we're of the view that synchronization is not possible with two databases on the same server. Is this correct?

Regards,

Will.

|||

You are right. You cannot synch from one database to another on the same server instance.

What I suggest in your case is to install another instance of Analysis Server on the same server machine. This case you achive better separation between test and production. If something wrong goes with the test instance, you can easily restart it or, it would be easier to monitor usage of the production server instance without developers interfere. Then, also you'd be able to use synch. Overall in your case second instance might be cleaner solution.

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

Deployment and Configuration

I have several clients using several SQL server databases that have all been
setup on one machine which they access remotely using terminal services. Each
client has their own software installation with their own set of databases.
So, there would be many client installations on the same machine. How would i
setup reporting services so that each client has their own set of reports?
How would i go about deploying the reports for each client given that the
clients' databases would have different names and hence the connection
strings will be different? Please help!
regardsSet up a datasource for each client - unless you have hundreds, in which case
I am not sure.sql

Deploying SQL Server 2005 Express

Hello

1.) Is there any solution for integrating the deployment of the sql server express into the setup project of my vb 2005 app ? 'Cause it is too much to install the framework... then the sql server and then the app....... Any help would be appreciated!

Thx

This may help:

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

Buck Woody

Deploying SQL Server 2005 Express

Hello

1.) Is there any solution for integrating the deployment of the sql server express into the setup project of my vb 2005 app ? 'Cause it is too much to install the framework... then the sql server and then the app....... Any help would be appreciated!

Thx

This may help:

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

Buck Woody

Deploying Report asks for Reporting Services Login, but won't take

Recently setup my first Sharepoint (wss 3.0, sp2) site including integrated
Report Services. I have SQL Server 2005 (full version, not the express
version) installed on the same computer. I think I did a farm install, but
installed everything on one computer. I do plan on using some linked servers
to this 2005 box to pull in data from elsewhere. My report views perfectly
in SQLServer Business Intelligence Dev.
I must have accounts set up wrong somewhere, because when I go to deploy a
report it keeps popping up a Reporting Services Login Dialog box. No matter
what account I put in, or in what format (with or without the domain portion
of the account) it just blinks and comes back to the reporting services login
dialog box.
When I try uploading from Sharepoint into the doc lib,
I have searched through other similar sounding posts, and through the
documentation and I can't figure this one out.
Here is some pertinent info:
In Reporting Services Configuration Manager:
Windows Service Identity: The service Account is set to a domain acct
(domainname\SQLSrvcA), and Windows acct is selected, with the same acct name
specified.
Web Service identity: ASP.Net Service Acct = (tried both NT
Authority\Network Service and with domainname\SQLSrvcA)
Database Setup: Credential type is Windows Credentials, with the account
name: domainname\SQLSrvcA
The link on the Sharepoint Integration page works.
I do not have Kerberos setup. Using NTLM.
Anonymous Access is turned off.
Domainname\SQLSrvcA has been added to the local admin group.
Domainname\SQLSrvcA has been added as a top level Sharepoint Site Collection
Administrator, and Full Control, Design, Contribute, Read rights.
In SQL Server, domainname\SQLSrvcA is dbo for the reportserver db, the
reportservertemp db, on the reportservertemp db this acct also has RSExecRole
rights. This account is also dbo for the SharePoint_AdminContent db, public
and WSS_Content_Application_Pools rights to the Sharepoint_Config db, dbo for
the SharepointContent db.
The SQL Server properties are set for both SQL and Windows authentication.
SQL2005 Surface Area Feature Config shows Windows Integrated Security
enabled. (have also tested with it disabled and had the same results).
I did use the "default website", but changed the port to 8080. Going to
http:/servername:8080/reportserver works.
In IIS, looking at the properties for the default website, Anonymous access
is not enabled, and integrated windows authentication is on.
I am working on building this Shareoint site out as a portal. Folks will
only be able to get to it from within our domain. I want them to be able to
go straight to sharepoint without logging in (which was working before I
installed Reporting services). I then want them to be able to pick reports
and run them without any further authentication requests.
Thank you all for any assistance you can provide.
ShirleyWith integrated security it is looking for you (when deploying). Is your
account setup in the local administrators group on the server?
Also, I recommend against using linked servers. There is no need to do this.
Instead you have the data source setup to the server you want to pull the
data from.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"ShirleyH" <ShirleyNOSPAMH@.abshernw.com> wrote in message
news:893DF211-DEE7-4E99-9FB4-FDA8C47585FD@.microsoft.com...
> Recently setup my first Sharepoint (wss 3.0, sp2) site including
> integrated
> Report Services. I have SQL Server 2005 (full version, not the express
> version) installed on the same computer. I think I did a farm install,
> but
> installed everything on one computer. I do plan on using some linked
> servers
> to this 2005 box to pull in data from elsewhere. My report views
> perfectly
> in SQLServer Business Intelligence Dev.
> I must have accounts set up wrong somewhere, because when I go to deploy a
> report it keeps popping up a Reporting Services Login Dialog box. No
> matter
> what account I put in, or in what format (with or without the domain
> portion
> of the account) it just blinks and comes back to the reporting services
> login
> dialog box.
> When I try uploading from Sharepoint into the doc lib,
> I have searched through other similar sounding posts, and through the
> documentation and I can't figure this one out.
> Here is some pertinent info:
> In Reporting Services Configuration Manager:
> Windows Service Identity: The service Account is set to a domain acct
> (domainname\SQLSrvcA), and Windows acct is selected, with the same acct
> name
> specified.
> Web Service identity: ASP.Net Service Acct = (tried both NT
> Authority\Network Service and with domainname\SQLSrvcA)
> Database Setup: Credential type is Windows Credentials, with the account
> name: domainname\SQLSrvcA
>
> The link on the Sharepoint Integration page works.
> I do not have Kerberos setup. Using NTLM.
> Anonymous Access is turned off.
> Domainname\SQLSrvcA has been added to the local admin group.
> Domainname\SQLSrvcA has been added as a top level Sharepoint Site
> Collection
> Administrator, and Full Control, Design, Contribute, Read rights.
> In SQL Server, domainname\SQLSrvcA is dbo for the reportserver db, the
> reportservertemp db, on the reportservertemp db this acct also has
> RSExecRole
> rights. This account is also dbo for the SharePoint_AdminContent db,
> public
> and WSS_Content_Application_Pools rights to the Sharepoint_Config db, dbo
> for
> the SharepointContent db.
> The SQL Server properties are set for both SQL and Windows authentication.
> SQL2005 Surface Area Feature Config shows Windows Integrated Security
> enabled. (have also tested with it disabled and had the same results).
>
> I did use the "default website", but changed the port to 8080. Going to
> http:/servername:8080/reportserver works.
> In IIS, looking at the properties for the default website, Anonymous
> access
> is not enabled, and integrated windows authentication is on.
>
> I am working on building this Shareoint site out as a portal. Folks will
> only be able to get to it from within our domain. I want them to be able
> to
> go straight to sharepoint without logging in (which was working before I
> installed Reporting services). I then want them to be able to pick reports
> and run them without any further authentication requests.
> Thank you all for any assistance you can provide.
> Shirley
>|||I have put in my own account (which is a domain admin acct, and a local admin
acct) but it still doesn't take it, it just blinks and gives me the dialog
box back.
"Bruce L-C [MVP]" wrote:
> With integrated security it is looking for you (when deploying). Is your
> account setup in the local administrators group on the server?
> Also, I recommend against using linked servers. There is no need to do this.
> Instead you have the data source setup to the server you want to pull the
> data from.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "ShirleyH" <ShirleyNOSPAMH@.abshernw.com> wrote in message
> news:893DF211-DEE7-4E99-9FB4-FDA8C47585FD@.microsoft.com...
> > Recently setup my first Sharepoint (wss 3.0, sp2) site including
> > integrated
> > Report Services. I have SQL Server 2005 (full version, not the express
> > version) installed on the same computer. I think I did a farm install,
> > but
> > installed everything on one computer. I do plan on using some linked
> > servers
> > to this 2005 box to pull in data from elsewhere. My report views
> > perfectly
> > in SQLServer Business Intelligence Dev.
> >
> > I must have accounts set up wrong somewhere, because when I go to deploy a
> > report it keeps popping up a Reporting Services Login Dialog box. No
> > matter
> > what account I put in, or in what format (with or without the domain
> > portion
> > of the account) it just blinks and comes back to the reporting services
> > login
> > dialog box.
> >
> > When I try uploading from Sharepoint into the doc lib,
> > I have searched through other similar sounding posts, and through the
> > documentation and I can't figure this one out.
> >
> > Here is some pertinent info:
> > In Reporting Services Configuration Manager:
> > Windows Service Identity: The service Account is set to a domain acct
> > (domainname\SQLSrvcA), and Windows acct is selected, with the same acct
> > name
> > specified.
> > Web Service identity: ASP.Net Service Acct = (tried both NT
> > Authority\Network Service and with domainname\SQLSrvcA)
> > Database Setup: Credential type is Windows Credentials, with the account
> > name: domainname\SQLSrvcA
> >
> >
> > The link on the Sharepoint Integration page works.
> > I do not have Kerberos setup. Using NTLM.
> > Anonymous Access is turned off.
> > Domainname\SQLSrvcA has been added to the local admin group.
> > Domainname\SQLSrvcA has been added as a top level Sharepoint Site
> > Collection
> > Administrator, and Full Control, Design, Contribute, Read rights.
> > In SQL Server, domainname\SQLSrvcA is dbo for the reportserver db, the
> > reportservertemp db, on the reportservertemp db this acct also has
> > RSExecRole
> > rights. This account is also dbo for the SharePoint_AdminContent db,
> > public
> > and WSS_Content_Application_Pools rights to the Sharepoint_Config db, dbo
> > for
> > the SharepointContent db.
> >
> > The SQL Server properties are set for both SQL and Windows authentication.
> > SQL2005 Surface Area Feature Config shows Windows Integrated Security
> > enabled. (have also tested with it disabled and had the same results).
> >
> >
> > I did use the "default website", but changed the port to 8080. Going to
> > http:/servername:8080/reportserver works.
> >
> > In IIS, looking at the properties for the default website, Anonymous
> > access
> > is not enabled, and integrated windows authentication is on.
> >
> >
> > I am working on building this Shareoint site out as a portal. Folks will
> > only be able to get to it from within our domain. I want them to be able
> > to
> > go straight to sharepoint without logging in (which was working before I
> > installed Reporting services). I then want them to be able to pick reports
> > and run them without any further authentication requests.
> >
> > Thank you all for any assistance you can provide.
> > Shirley
> >
> >
>
>|||Let's back up and make sure you have RS installed properly. Even without any
report deployed you should be able to get to the reportserver. Make sure
that works for you:
http://yourserver/Reports/Pages/Folder.aspx
Does this come up?
Also, do you have a fixed IP address for the server?
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"ShirleyH" <ShirleyNOSPAMH@.abshernw.com> wrote in message
news:153C26DD-55A7-4442-9EDE-28D5A7A11393@.microsoft.com...
>I have put in my own account (which is a domain admin acct, and a local
>admin
> acct) but it still doesn't take it, it just blinks and gives me the dialog
> box back.
>
> "Bruce L-C [MVP]" wrote:
>> With integrated security it is looking for you (when deploying). Is your
>> account setup in the local administrators group on the server?
>> Also, I recommend against using linked servers. There is no need to do
>> this.
>> Instead you have the data source setup to the server you want to pull the
>> data from.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "ShirleyH" <ShirleyNOSPAMH@.abshernw.com> wrote in message
>> news:893DF211-DEE7-4E99-9FB4-FDA8C47585FD@.microsoft.com...
>> > Recently setup my first Sharepoint (wss 3.0, sp2) site including
>> > integrated
>> > Report Services. I have SQL Server 2005 (full version, not the express
>> > version) installed on the same computer. I think I did a farm
>> > install,
>> > but
>> > installed everything on one computer. I do plan on using some linked
>> > servers
>> > to this 2005 box to pull in data from elsewhere. My report views
>> > perfectly
>> > in SQLServer Business Intelligence Dev.
>> >
>> > I must have accounts set up wrong somewhere, because when I go to
>> > deploy a
>> > report it keeps popping up a Reporting Services Login Dialog box. No
>> > matter
>> > what account I put in, or in what format (with or without the domain
>> > portion
>> > of the account) it just blinks and comes back to the reporting services
>> > login
>> > dialog box.
>> >
>> > When I try uploading from Sharepoint into the doc lib,
>> > I have searched through other similar sounding posts, and through the
>> > documentation and I can't figure this one out.
>> >
>> > Here is some pertinent info:
>> > In Reporting Services Configuration Manager:
>> > Windows Service Identity: The service Account is set to a domain acct
>> > (domainname\SQLSrvcA), and Windows acct is selected, with the same acct
>> > name
>> > specified.
>> > Web Service identity: ASP.Net Service Acct = (tried both NT
>> > Authority\Network Service and with domainname\SQLSrvcA)
>> > Database Setup: Credential type is Windows Credentials, with the
>> > account
>> > name: domainname\SQLSrvcA
>> >
>> >
>> > The link on the Sharepoint Integration page works.
>> > I do not have Kerberos setup. Using NTLM.
>> > Anonymous Access is turned off.
>> > Domainname\SQLSrvcA has been added to the local admin group.
>> > Domainname\SQLSrvcA has been added as a top level Sharepoint Site
>> > Collection
>> > Administrator, and Full Control, Design, Contribute, Read rights.
>> > In SQL Server, domainname\SQLSrvcA is dbo for the reportserver db, the
>> > reportservertemp db, on the reportservertemp db this acct also has
>> > RSExecRole
>> > rights. This account is also dbo for the SharePoint_AdminContent db,
>> > public
>> > and WSS_Content_Application_Pools rights to the Sharepoint_Config db,
>> > dbo
>> > for
>> > the SharepointContent db.
>> >
>> > The SQL Server properties are set for both SQL and Windows
>> > authentication.
>> > SQL2005 Surface Area Feature Config shows Windows Integrated Security
>> > enabled. (have also tested with it disabled and had the same results).
>> >
>> >
>> > I did use the "default website", but changed the port to 8080. Going
>> > to
>> > http:/servername:8080/reportserver works.
>> >
>> > In IIS, looking at the properties for the default website, Anonymous
>> > access
>> > is not enabled, and integrated windows authentication is on.
>> >
>> >
>> > I am working on building this Shareoint site out as a portal. Folks
>> > will
>> > only be able to get to it from within our domain. I want them to be
>> > able
>> > to
>> > go straight to sharepoint without logging in (which was working before
>> > I
>> > installed Reporting services). I then want them to be able to pick
>> > reports
>> > and run them without any further authentication requests.
>> >
>> > Thank you all for any assistance you can provide.
>> > Shirley
>> >
>> >
>>|||"Going
>> > to
>> > http:/servername:8080/reportserver works." And I can browse into a list of folders that are from various Sharepoint sites under our top level sites.
"Bruce L-C [MVP]" wrote:
> Let's back up and make sure you have RS installed properly. Even without any
> report deployed you should be able to get to the reportserver. Make sure
> that works for you:
> http://yourserver/Reports/Pages/Folder.aspx
> Does this come up?
> Also, do you have a fixed IP address for the server?
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "ShirleyH" <ShirleyNOSPAMH@.abshernw.com> wrote in message
> news:153C26DD-55A7-4442-9EDE-28D5A7A11393@.microsoft.com...
> >I have put in my own account (which is a domain admin acct, and a local
> >admin
> > acct) but it still doesn't take it, it just blinks and gives me the dialog
> > box back.
> >
> >
> >
> > "Bruce L-C [MVP]" wrote:
> >
> >> With integrated security it is looking for you (when deploying). Is your
> >> account setup in the local administrators group on the server?
> >>
> >> Also, I recommend against using linked servers. There is no need to do
> >> this.
> >> Instead you have the data source setup to the server you want to pull the
> >> data from.
> >>
> >>
> >> --
> >> Bruce Loehle-Conger
> >> MVP SQL Server Reporting Services
> >>
> >> "ShirleyH" <ShirleyNOSPAMH@.abshernw.com> wrote in message
> >> news:893DF211-DEE7-4E99-9FB4-FDA8C47585FD@.microsoft.com...
> >> > Recently setup my first Sharepoint (wss 3.0, sp2) site including
> >> > integrated
> >> > Report Services. I have SQL Server 2005 (full version, not the express
> >> > version) installed on the same computer. I think I did a farm
> >> > install,
> >> > but
> >> > installed everything on one computer. I do plan on using some linked
> >> > servers
> >> > to this 2005 box to pull in data from elsewhere. My report views
> >> > perfectly
> >> > in SQLServer Business Intelligence Dev.
> >> >
> >> > I must have accounts set up wrong somewhere, because when I go to
> >> > deploy a
> >> > report it keeps popping up a Reporting Services Login Dialog box. No
> >> > matter
> >> > what account I put in, or in what format (with or without the domain
> >> > portion
> >> > of the account) it just blinks and comes back to the reporting services
> >> > login
> >> > dialog box.
> >> >
> >> > When I try uploading from Sharepoint into the doc lib,
> >> > I have searched through other similar sounding posts, and through the
> >> > documentation and I can't figure this one out.
> >> >
> >> > Here is some pertinent info:
> >> > In Reporting Services Configuration Manager:
> >> > Windows Service Identity: The service Account is set to a domain acct
> >> > (domainname\SQLSrvcA), and Windows acct is selected, with the same acct
> >> > name
> >> > specified.
> >> > Web Service identity: ASP.Net Service Acct = (tried both NT
> >> > Authority\Network Service and with domainname\SQLSrvcA)
> >> > Database Setup: Credential type is Windows Credentials, with the
> >> > account
> >> > name: domainname\SQLSrvcA
> >> >
> >> >
> >> > The link on the Sharepoint Integration page works.
> >> > I do not have Kerberos setup. Using NTLM.
> >> > Anonymous Access is turned off.
> >> > Domainname\SQLSrvcA has been added to the local admin group.
> >> > Domainname\SQLSrvcA has been added as a top level Sharepoint Site
> >> > Collection
> >> > Administrator, and Full Control, Design, Contribute, Read rights.
> >> > In SQL Server, domainname\SQLSrvcA is dbo for the reportserver db, the
> >> > reportservertemp db, on the reportservertemp db this acct also has
> >> > RSExecRole
> >> > rights. This account is also dbo for the SharePoint_AdminContent db,
> >> > public
> >> > and WSS_Content_Application_Pools rights to the Sharepoint_Config db,
> >> > dbo
> >> > for
> >> > the SharepointContent db.
> >> >
> >> > The SQL Server properties are set for both SQL and Windows
> >> > authentication.
> >> > SQL2005 Surface Area Feature Config shows Windows Integrated Security
> >> > enabled. (have also tested with it disabled and had the same results).
> >> >
> >> >
> >> > I did use the "default website", but changed the port to 8080. Going
> >> > to
> >> > http:/servername:8080/reportserver works.
> >> >
> >> > In IIS, looking at the properties for the default website, Anonymous
> >> > access
> >> > is not enabled, and integrated windows authentication is on.
> >> >
> >> >
> >> > I am working on building this Shareoint site out as a portal. Folks
> >> > will
> >> > only be able to get to it from within our domain. I want them to be
> >> > able
> >> > to
> >> > go straight to sharepoint without logging in (which was working before
> >> > I
> >> > installed Reporting services). I then want them to be able to pick
> >> > reports
> >> > and run them without any further authentication requests.
> >> >
> >> > Thank you all for any assistance you can provide.
> >> > Shirley
> >> >
> >> >
> >>
> >>
> >>
>
>|||reportserver is the RS application itself. However, just seeing the folder
list this way is not a good test. Report Manager is the portal that ships
with RS. Make sure this works for you.
http://yourserver/Reports/Pages/Folder.aspx
One other thing. Have you configured your VS project on where you are
supposed to deploy to?
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"ShirleyH" <ShirleyNOSPAMH@.abshernw.com> wrote in message
news:79639F43-3296-44E9-840B-F34977F2F77F@.microsoft.com...
> "Going
>> > to
>> > http:/servername:8080/reportserver works." And I can browse into a
>> > list of folders that are from various Sharepoint sites under our top
>> > level sites.
>
> "Bruce L-C [MVP]" wrote:
>> Let's back up and make sure you have RS installed properly. Even without
>> any
>> report deployed you should be able to get to the reportserver. Make sure
>> that works for you:
>> http://yourserver/Reports/Pages/Folder.aspx
>> Does this come up?
>> Also, do you have a fixed IP address for the server?
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "ShirleyH" <ShirleyNOSPAMH@.abshernw.com> wrote in message
>> news:153C26DD-55A7-4442-9EDE-28D5A7A11393@.microsoft.com...
>> >I have put in my own account (which is a domain admin acct, and a local
>> >admin
>> > acct) but it still doesn't take it, it just blinks and gives me the
>> > dialog
>> > box back.
>> >
>> >
>> >
>> > "Bruce L-C [MVP]" wrote:
>> >
>> >> With integrated security it is looking for you (when deploying). Is
>> >> your
>> >> account setup in the local administrators group on the server?
>> >>
>> >> Also, I recommend against using linked servers. There is no need to do
>> >> this.
>> >> Instead you have the data source setup to the server you want to pull
>> >> the
>> >> data from.
>> >>
>> >>
>> >> --
>> >> Bruce Loehle-Conger
>> >> MVP SQL Server Reporting Services
>> >>
>> >> "ShirleyH" <ShirleyNOSPAMH@.abshernw.com> wrote in message
>> >> news:893DF211-DEE7-4E99-9FB4-FDA8C47585FD@.microsoft.com...
>> >> > Recently setup my first Sharepoint (wss 3.0, sp2) site including
>> >> > integrated
>> >> > Report Services. I have SQL Server 2005 (full version, not the
>> >> > express
>> >> > version) installed on the same computer. I think I did a farm
>> >> > install,
>> >> > but
>> >> > installed everything on one computer. I do plan on using some
>> >> > linked
>> >> > servers
>> >> > to this 2005 box to pull in data from elsewhere. My report views
>> >> > perfectly
>> >> > in SQLServer Business Intelligence Dev.
>> >> >
>> >> > I must have accounts set up wrong somewhere, because when I go to
>> >> > deploy a
>> >> > report it keeps popping up a Reporting Services Login Dialog box. No
>> >> > matter
>> >> > what account I put in, or in what format (with or without the domain
>> >> > portion
>> >> > of the account) it just blinks and comes back to the reporting
>> >> > services
>> >> > login
>> >> > dialog box.
>> >> >
>> >> > When I try uploading from Sharepoint into the doc lib,
>> >> > I have searched through other similar sounding posts, and through
>> >> > the
>> >> > documentation and I can't figure this one out.
>> >> >
>> >> > Here is some pertinent info:
>> >> > In Reporting Services Configuration Manager:
>> >> > Windows Service Identity: The service Account is set to a domain
>> >> > acct
>> >> > (domainname\SQLSrvcA), and Windows acct is selected, with the same
>> >> > acct
>> >> > name
>> >> > specified.
>> >> > Web Service identity: ASP.Net Service Acct = (tried both NT
>> >> > Authority\Network Service and with domainname\SQLSrvcA)
>> >> > Database Setup: Credential type is Windows Credentials, with the
>> >> > account
>> >> > name: domainname\SQLSrvcA
>> >> >
>> >> >
>> >> > The link on the Sharepoint Integration page works.
>> >> > I do not have Kerberos setup. Using NTLM.
>> >> > Anonymous Access is turned off.
>> >> > Domainname\SQLSrvcA has been added to the local admin group.
>> >> > Domainname\SQLSrvcA has been added as a top level Sharepoint Site
>> >> > Collection
>> >> > Administrator, and Full Control, Design, Contribute, Read rights.
>> >> > In SQL Server, domainname\SQLSrvcA is dbo for the reportserver db,
>> >> > the
>> >> > reportservertemp db, on the reportservertemp db this acct also has
>> >> > RSExecRole
>> >> > rights. This account is also dbo for the SharePoint_AdminContent
>> >> > db,
>> >> > public
>> >> > and WSS_Content_Application_Pools rights to the Sharepoint_Config
>> >> > db,
>> >> > dbo
>> >> > for
>> >> > the SharepointContent db.
>> >> >
>> >> > The SQL Server properties are set for both SQL and Windows
>> >> > authentication.
>> >> > SQL2005 Surface Area Feature Config shows Windows Integrated
>> >> > Security
>> >> > enabled. (have also tested with it disabled and had the same
>> >> > results).
>> >> >
>> >> >
>> >> > I did use the "default website", but changed the port to 8080.
>> >> > Going
>> >> > to
>> >> > http:/servername:8080/reportserver works.
>> >> >
>> >> > In IIS, looking at the properties for the default website, Anonymous
>> >> > access
>> >> > is not enabled, and integrated windows authentication is on.
>> >> >
>> >> >
>> >> > I am working on building this Shareoint site out as a portal. Folks
>> >> > will
>> >> > only be able to get to it from within our domain. I want them to be
>> >> > able
>> >> > to
>> >> > go straight to sharepoint without logging in (which was working
>> >> > before
>> >> > I
>> >> > installed Reporting services). I then want them to be able to pick
>> >> > reports
>> >> > and run them without any further authentication requests.
>> >> >
>> >> > Thank you all for any assistance you can provide.
>> >> > Shirley
>> >> >
>> >> >
>> >>
>> >>
>> >>
>>|||My understanding is that once you install RS in Sharepoint integrated mode,
that Report Manager is no longer accessible. That RS management is only
accessible via Sharepoint.
?
Shirley
"Bruce L-C [MVP]" wrote:
> reportserver is the RS application itself. However, just seeing the folder
> list this way is not a good test. Report Manager is the portal that ships
> with RS. Make sure this works for you.
> http://yourserver/Reports/Pages/Folder.aspx
> One other thing. Have you configured your VS project on where you are
> supposed to deploy to?
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
> "ShirleyH" <ShirleyNOSPAMH@.abshernw.com> wrote in message
> news:79639F43-3296-44E9-840B-F34977F2F77F@.microsoft.com...
> > "Going
> >> > to
> >> > http:/servername:8080/reportserver works." And I can browse into a
> >> > list of folders that are from various Sharepoint sites under our top
> >> > level sites.
> >
> >
> >
> > "Bruce L-C [MVP]" wrote:
> >
> >> Let's back up and make sure you have RS installed properly. Even without
> >> any
> >> report deployed you should be able to get to the reportserver. Make sure
> >> that works for you:
> >>
> >> http://yourserver/Reports/Pages/Folder.aspx
> >>
> >> Does this come up?
> >>
> >> Also, do you have a fixed IP address for the server?
> >>
> >>
> >> --
> >> Bruce Loehle-Conger
> >> MVP SQL Server Reporting Services
> >>
> >> "ShirleyH" <ShirleyNOSPAMH@.abshernw.com> wrote in message
> >> news:153C26DD-55A7-4442-9EDE-28D5A7A11393@.microsoft.com...
> >> >I have put in my own account (which is a domain admin acct, and a local
> >> >admin
> >> > acct) but it still doesn't take it, it just blinks and gives me the
> >> > dialog
> >> > box back.
> >> >
> >> >
> >> >
> >> > "Bruce L-C [MVP]" wrote:
> >> >
> >> >> With integrated security it is looking for you (when deploying). Is
> >> >> your
> >> >> account setup in the local administrators group on the server?
> >> >>
> >> >> Also, I recommend against using linked servers. There is no need to do
> >> >> this.
> >> >> Instead you have the data source setup to the server you want to pull
> >> >> the
> >> >> data from.
> >> >>
> >> >>
> >> >> --
> >> >> Bruce Loehle-Conger
> >> >> MVP SQL Server Reporting Services
> >> >>
> >> >> "ShirleyH" <ShirleyNOSPAMH@.abshernw.com> wrote in message
> >> >> news:893DF211-DEE7-4E99-9FB4-FDA8C47585FD@.microsoft.com...
> >> >> > Recently setup my first Sharepoint (wss 3.0, sp2) site including
> >> >> > integrated
> >> >> > Report Services. I have SQL Server 2005 (full version, not the
> >> >> > express
> >> >> > version) installed on the same computer. I think I did a farm
> >> >> > install,
> >> >> > but
> >> >> > installed everything on one computer. I do plan on using some
> >> >> > linked
> >> >> > servers
> >> >> > to this 2005 box to pull in data from elsewhere. My report views
> >> >> > perfectly
> >> >> > in SQLServer Business Intelligence Dev.
> >> >> >
> >> >> > I must have accounts set up wrong somewhere, because when I go to
> >> >> > deploy a
> >> >> > report it keeps popping up a Reporting Services Login Dialog box. No
> >> >> > matter
> >> >> > what account I put in, or in what format (with or without the domain
> >> >> > portion
> >> >> > of the account) it just blinks and comes back to the reporting
> >> >> > services
> >> >> > login
> >> >> > dialog box.
> >> >> >
> >> >> > When I try uploading from Sharepoint into the doc lib,
> >> >> > I have searched through other similar sounding posts, and through
> >> >> > the
> >> >> > documentation and I can't figure this one out.
> >> >> >
> >> >> > Here is some pertinent info:
> >> >> > In Reporting Services Configuration Manager:
> >> >> > Windows Service Identity: The service Account is set to a domain
> >> >> > acct
> >> >> > (domainname\SQLSrvcA), and Windows acct is selected, with the same
> >> >> > acct
> >> >> > name
> >> >> > specified.
> >> >> > Web Service identity: ASP.Net Service Acct = (tried both NT
> >> >> > Authority\Network Service and with domainname\SQLSrvcA)
> >> >> > Database Setup: Credential type is Windows Credentials, with the
> >> >> > account
> >> >> > name: domainname\SQLSrvcA
> >> >> >
> >> >> >
> >> >> > The link on the Sharepoint Integration page works.
> >> >> > I do not have Kerberos setup. Using NTLM.
> >> >> > Anonymous Access is turned off.
> >> >> > Domainname\SQLSrvcA has been added to the local admin group.
> >> >> > Domainname\SQLSrvcA has been added as a top level Sharepoint Site
> >> >> > Collection
> >> >> > Administrator, and Full Control, Design, Contribute, Read rights.
> >> >> > In SQL Server, domainname\SQLSrvcA is dbo for the reportserver db,
> >> >> > the
> >> >> > reportservertemp db, on the reportservertemp db this acct also has
> >> >> > RSExecRole
> >> >> > rights. This account is also dbo for the SharePoint_AdminContent
> >> >> > db,
> >> >> > public
> >> >> > and WSS_Content_Application_Pools rights to the Sharepoint_Config
> >> >> > db,
> >> >> > dbo
> >> >> > for
> >> >> > the SharepointContent db.
> >> >> >
> >> >> > The SQL Server properties are set for both SQL and Windows
> >> >> > authentication.
> >> >> > SQL2005 Surface Area Feature Config shows Windows Integrated
> >> >> > Security
> >> >> > enabled. (have also tested with it disabled and had the same
> >> >> > results).
> >> >> >
> >> >> >
> >> >> > I did use the "default website", but changed the port to 8080.
> >> >> > Going
> >> >> > to
> >> >> > http:/servername:8080/reportserver works.
> >> >> >
> >> >> > In IIS, looking at the properties for the default website, Anonymous
> >> >> > access
> >> >> > is not enabled, and integrated windows authentication is on.
> >> >> >
> >> >> >
> >> >> > I am working on building this Shareoint site out as a portal. Folks
> >> >> > will
> >> >> > only be able to get to it from within our domain. I want them to be
> >> >> > able
> >> >> > to
> >> >> > go straight to sharepoint without logging in (which was working
> >> >> > before
> >> >> > I
> >> >> > installed Reporting services). I then want them to be able to pick
> >> >> > reports
> >> >> > and run them without any further authentication requests.
> >> >> >
> >> >> > Thank you all for any assistance you can provide.
> >> >> > Shirley
> >> >> >
> >> >> >
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
>
>|||I have attempted accessing the link/path you suggested and get the following:
"The operation is not supported on a report server that is configured to run
in Sharepoint integrated mode."
"ShirleyH" wrote:
> My understanding is that once you install RS in Sharepoint integrated mode,
> that Report Manager is no longer accessible. That RS management is only
> accessible via Sharepoint.
> ?
> Shirley
> "Bruce L-C [MVP]" wrote:
> > reportserver is the RS application itself. However, just seeing the folder
> > list this way is not a good test. Report Manager is the portal that ships
> > with RS. Make sure this works for you.
> >
> > http://yourserver/Reports/Pages/Folder.aspx
> >
> > One other thing. Have you configured your VS project on where you are
> > supposed to deploy to?
> >
> > --
> > Bruce Loehle-Conger
> > MVP SQL Server Reporting Services
> >
> >
> >
> > "ShirleyH" <ShirleyNOSPAMH@.abshernw.com> wrote in message
> > news:79639F43-3296-44E9-840B-F34977F2F77F@.microsoft.com...
> > > "Going
> > >> > to
> > >> > http:/servername:8080/reportserver works." And I can browse into a
> > >> > list of folders that are from various Sharepoint sites under our top
> > >> > level sites.
> > >
> > >
> > >
> > > "Bruce L-C [MVP]" wrote:
> > >
> > >> Let's back up and make sure you have RS installed properly. Even without
> > >> any
> > >> report deployed you should be able to get to the reportserver. Make sure
> > >> that works for you:
> > >>
> > >> http://yourserver/Reports/Pages/Folder.aspx
> > >>
> > >> Does this come up?
> > >>
> > >> Also, do you have a fixed IP address for the server?
> > >>
> > >>
> > >> --
> > >> Bruce Loehle-Conger
> > >> MVP SQL Server Reporting Services
> > >>
> > >> "ShirleyH" <ShirleyNOSPAMH@.abshernw.com> wrote in message
> > >> news:153C26DD-55A7-4442-9EDE-28D5A7A11393@.microsoft.com...
> > >> >I have put in my own account (which is a domain admin acct, and a local
> > >> >admin
> > >> > acct) but it still doesn't take it, it just blinks and gives me the
> > >> > dialog
> > >> > box back.
> > >> >
> > >> >
> > >> >
> > >> > "Bruce L-C [MVP]" wrote:
> > >> >
> > >> >> With integrated security it is looking for you (when deploying). Is
> > >> >> your
> > >> >> account setup in the local administrators group on the server?
> > >> >>
> > >> >> Also, I recommend against using linked servers. There is no need to do
> > >> >> this.
> > >> >> Instead you have the data source setup to the server you want to pull
> > >> >> the
> > >> >> data from.
> > >> >>
> > >> >>
> > >> >> --
> > >> >> Bruce Loehle-Conger
> > >> >> MVP SQL Server Reporting Services
> > >> >>
> > >> >> "ShirleyH" <ShirleyNOSPAMH@.abshernw.com> wrote in message
> > >> >> news:893DF211-DEE7-4E99-9FB4-FDA8C47585FD@.microsoft.com...
> > >> >> > Recently setup my first Sharepoint (wss 3.0, sp2) site including
> > >> >> > integrated
> > >> >> > Report Services. I have SQL Server 2005 (full version, not the
> > >> >> > express
> > >> >> > version) installed on the same computer. I think I did a farm
> > >> >> > install,
> > >> >> > but
> > >> >> > installed everything on one computer. I do plan on using some
> > >> >> > linked
> > >> >> > servers
> > >> >> > to this 2005 box to pull in data from elsewhere. My report views
> > >> >> > perfectly
> > >> >> > in SQLServer Business Intelligence Dev.
> > >> >> >
> > >> >> > I must have accounts set up wrong somewhere, because when I go to
> > >> >> > deploy a
> > >> >> > report it keeps popping up a Reporting Services Login Dialog box. No
> > >> >> > matter
> > >> >> > what account I put in, or in what format (with or without the domain
> > >> >> > portion
> > >> >> > of the account) it just blinks and comes back to the reporting
> > >> >> > services
> > >> >> > login
> > >> >> > dialog box.
> > >> >> >
> > >> >> > When I try uploading from Sharepoint into the doc lib,
> > >> >> > I have searched through other similar sounding posts, and through
> > >> >> > the
> > >> >> > documentation and I can't figure this one out.
> > >> >> >
> > >> >> > Here is some pertinent info:
> > >> >> > In Reporting Services Configuration Manager:
> > >> >> > Windows Service Identity: The service Account is set to a domain
> > >> >> > acct
> > >> >> > (domainname\SQLSrvcA), and Windows acct is selected, with the same
> > >> >> > acct
> > >> >> > name
> > >> >> > specified.
> > >> >> > Web Service identity: ASP.Net Service Acct = (tried both NT
> > >> >> > Authority\Network Service and with domainname\SQLSrvcA)
> > >> >> > Database Setup: Credential type is Windows Credentials, with the
> > >> >> > account
> > >> >> > name: domainname\SQLSrvcA
> > >> >> >
> > >> >> >
> > >> >> > The link on the Sharepoint Integration page works.
> > >> >> > I do not have Kerberos setup. Using NTLM.
> > >> >> > Anonymous Access is turned off.
> > >> >> > Domainname\SQLSrvcA has been added to the local admin group.
> > >> >> > Domainname\SQLSrvcA has been added as a top level Sharepoint Site
> > >> >> > Collection
> > >> >> > Administrator, and Full Control, Design, Contribute, Read rights.
> > >> >> > In SQL Server, domainname\SQLSrvcA is dbo for the reportserver db,
> > >> >> > the
> > >> >> > reportservertemp db, on the reportservertemp db this acct also has
> > >> >> > RSExecRole
> > >> >> > rights. This account is also dbo for the SharePoint_AdminContent
> > >> >> > db,
> > >> >> > public
> > >> >> > and WSS_Content_Application_Pools rights to the Sharepoint_Config
> > >> >> > db,
> > >> >> > dbo
> > >> >> > for
> > >> >> > the SharepointContent db.
> > >> >> >
> > >> >> > The SQL Server properties are set for both SQL and Windows
> > >> >> > authentication.
> > >> >> > SQL2005 Surface Area Feature Config shows Windows Integrated
> > >> >> > Security
> > >> >> > enabled. (have also tested with it disabled and had the same
> > >> >> > results).
> > >> >> >
> > >> >> >
> > >> >> > I did use the "default website", but changed the port to 8080.
> > >> >> > Going
> > >> >> > to
> > >> >> > http:/servername:8080/reportserver works.
> > >> >> >
> > >> >> > In IIS, looking at the properties for the default website, Anonymous
> > >> >> > access
> > >> >> > is not enabled, and integrated windows authentication is on.
> > >> >> >
> > >> >> >
> > >> >> > I am working on building this Shareoint site out as a portal. Folks
> > >> >> > will
> > >> >> > only be able to get to it from within our domain. I want them to be
> > >> >> > able
> > >> >> > to
> > >> >> > go straight to sharepoint without logging in (which was working
> > >> >> > before
> > >> >> > I
> > >> >> > installed Reporting services). I then want them to be able to pick
> > >> >> > reports
> > >> >> > and run them without any further authentication requests.
> > >> >> >
> > >> >> > Thank you all for any assistance you can provide.
> > >> >> > Shirley
> > >> >> >
> > >> >> >
> > >> >>
> > >> >>
> > >> >>
> > >>
> > >>
> > >>
> >
> >
> >|||Ahh, sorry, I didn't realize this (I don't run Sharepoint). This very well
could be a sharepoint / reporting services integration issue.
I'm afraid I can't help you with this. I'm out of ideas.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"ShirleyH" <ShirleyNOSPAMH@.abshernw.com> wrote in message
news:9E350FCD-D4DE-4E80-9BD9-09EB7ADFF0AA@.microsoft.com...
>I have attempted accessing the link/path you suggested and get the
>following:
> "The operation is not supported on a report server that is configured to
> run
> in Sharepoint integrated mode."
> "ShirleyH" wrote:
>> My understanding is that once you install RS in Sharepoint integrated
>> mode,
>> that Report Manager is no longer accessible. That RS management is only
>> accessible via Sharepoint.
>> ?
>> Shirley
>> "Bruce L-C [MVP]" wrote:
>> > reportserver is the RS application itself. However, just seeing the
>> > folder
>> > list this way is not a good test. Report Manager is the portal that
>> > ships
>> > with RS. Make sure this works for you.
>> >
>> > http://yourserver/Reports/Pages/Folder.aspx
>> >
>> > One other thing. Have you configured your VS project on where you are
>> > supposed to deploy to?
>> >
>> > --
>> > Bruce Loehle-Conger
>> > MVP SQL Server Reporting Services
>> >
>> >
>> >
>> > "ShirleyH" <ShirleyNOSPAMH@.abshernw.com> wrote in message
>> > news:79639F43-3296-44E9-840B-F34977F2F77F@.microsoft.com...
>> > > "Going
>> > >> > to
>> > >> > http:/servername:8080/reportserver works." And I can browse into
>> > >> > a
>> > >> > list of folders that are from various Sharepoint sites under our
>> > >> > top
>> > >> > level sites.
>> > >
>> > >
>> > >
>> > > "Bruce L-C [MVP]" wrote:
>> > >
>> > >> Let's back up and make sure you have RS installed properly. Even
>> > >> without
>> > >> any
>> > >> report deployed you should be able to get to the reportserver. Make
>> > >> sure
>> > >> that works for you:
>> > >>
>> > >> http://yourserver/Reports/Pages/Folder.aspx
>> > >>
>> > >> Does this come up?
>> > >>
>> > >> Also, do you have a fixed IP address for the server?
>> > >>
>> > >>
>> > >> --
>> > >> Bruce Loehle-Conger
>> > >> MVP SQL Server Reporting Services
>> > >>
>> > >> "ShirleyH" <ShirleyNOSPAMH@.abshernw.com> wrote in message
>> > >> news:153C26DD-55A7-4442-9EDE-28D5A7A11393@.microsoft.com...
>> > >> >I have put in my own account (which is a domain admin acct, and a
>> > >> >local
>> > >> >admin
>> > >> > acct) but it still doesn't take it, it just blinks and gives me
>> > >> > the
>> > >> > dialog
>> > >> > box back.
>> > >> >
>> > >> >
>> > >> >
>> > >> > "Bruce L-C [MVP]" wrote:
>> > >> >
>> > >> >> With integrated security it is looking for you (when deploying).
>> > >> >> Is
>> > >> >> your
>> > >> >> account setup in the local administrators group on the server?
>> > >> >>
>> > >> >> Also, I recommend against using linked servers. There is no need
>> > >> >> to do
>> > >> >> this.
>> > >> >> Instead you have the data source setup to the server you want to
>> > >> >> pull
>> > >> >> the
>> > >> >> data from.
>> > >> >>
>> > >> >>
>> > >> >> --
>> > >> >> Bruce Loehle-Conger
>> > >> >> MVP SQL Server Reporting Services
>> > >> >>
>> > >> >> "ShirleyH" <ShirleyNOSPAMH@.abshernw.com> wrote in message
>> > >> >> news:893DF211-DEE7-4E99-9FB4-FDA8C47585FD@.microsoft.com...
>> > >> >> > Recently setup my first Sharepoint (wss 3.0, sp2) site
>> > >> >> > including
>> > >> >> > integrated
>> > >> >> > Report Services. I have SQL Server 2005 (full version, not the
>> > >> >> > express
>> > >> >> > version) installed on the same computer. I think I did a farm
>> > >> >> > install,
>> > >> >> > but
>> > >> >> > installed everything on one computer. I do plan on using some
>> > >> >> > linked
>> > >> >> > servers
>> > >> >> > to this 2005 box to pull in data from elsewhere. My report
>> > >> >> > views
>> > >> >> > perfectly
>> > >> >> > in SQLServer Business Intelligence Dev.
>> > >> >> >
>> > >> >> > I must have accounts set up wrong somewhere, because when I go
>> > >> >> > to
>> > >> >> > deploy a
>> > >> >> > report it keeps popping up a Reporting Services Login Dialog
>> > >> >> > box. No
>> > >> >> > matter
>> > >> >> > what account I put in, or in what format (with or without the
>> > >> >> > domain
>> > >> >> > portion
>> > >> >> > of the account) it just blinks and comes back to the reporting
>> > >> >> > services
>> > >> >> > login
>> > >> >> > dialog box.
>> > >> >> >
>> > >> >> > When I try uploading from Sharepoint into the doc lib,
>> > >> >> > I have searched through other similar sounding posts, and
>> > >> >> > through
>> > >> >> > the
>> > >> >> > documentation and I can't figure this one out.
>> > >> >> >
>> > >> >> > Here is some pertinent info:
>> > >> >> > In Reporting Services Configuration Manager:
>> > >> >> > Windows Service Identity: The service Account is set to a
>> > >> >> > domain
>> > >> >> > acct
>> > >> >> > (domainname\SQLSrvcA), and Windows acct is selected, with the
>> > >> >> > same
>> > >> >> > acct
>> > >> >> > name
>> > >> >> > specified.
>> > >> >> > Web Service identity: ASP.Net Service Acct = (tried both NT
>> > >> >> > Authority\Network Service and with domainname\SQLSrvcA)
>> > >> >> > Database Setup: Credential type is Windows Credentials, with
>> > >> >> > the
>> > >> >> > account
>> > >> >> > name: domainname\SQLSrvcA
>> > >> >> >
>> > >> >> >
>> > >> >> > The link on the Sharepoint Integration page works.
>> > >> >> > I do not have Kerberos setup. Using NTLM.
>> > >> >> > Anonymous Access is turned off.
>> > >> >> > Domainname\SQLSrvcA has been added to the local admin group.
>> > >> >> > Domainname\SQLSrvcA has been added as a top level Sharepoint
>> > >> >> > Site
>> > >> >> > Collection
>> > >> >> > Administrator, and Full Control, Design, Contribute, Read
>> > >> >> > rights.
>> > >> >> > In SQL Server, domainname\SQLSrvcA is dbo for the reportserver
>> > >> >> > db,
>> > >> >> > the
>> > >> >> > reportservertemp db, on the reportservertemp db this acct also
>> > >> >> > has
>> > >> >> > RSExecRole
>> > >> >> > rights. This account is also dbo for the
>> > >> >> > SharePoint_AdminContent
>> > >> >> > db,
>> > >> >> > public
>> > >> >> > and WSS_Content_Application_Pools rights to the
>> > >> >> > Sharepoint_Config
>> > >> >> > db,
>> > >> >> > dbo
>> > >> >> > for
>> > >> >> > the SharepointContent db.
>> > >> >> >
>> > >> >> > The SQL Server properties are set for both SQL and Windows
>> > >> >> > authentication.
>> > >> >> > SQL2005 Surface Area Feature Config shows Windows Integrated
>> > >> >> > Security
>> > >> >> > enabled. (have also tested with it disabled and had the same
>> > >> >> > results).
>> > >> >> >
>> > >> >> >
>> > >> >> > I did use the "default website", but changed the port to 8080.
>> > >> >> > Going
>> > >> >> > to
>> > >> >> > http:/servername:8080/reportserver works.
>> > >> >> >
>> > >> >> > In IIS, looking at the properties for the default website,
>> > >> >> > Anonymous
>> > >> >> > access
>> > >> >> > is not enabled, and integrated windows authentication is on.
>> > >> >> >
>> > >> >> >
>> > >> >> > I am working on building this Shareoint site out as a portal.
>> > >> >> > Folks
>> > >> >> > will
>> > >> >> > only be able to get to it from within our domain. I want them
>> > >> >> > to be
>> > >> >> > able
>> > >> >> > to
>> > >> >> > go straight to sharepoint without logging in (which was working
>> > >> >> > before
>> > >> >> > I
>> > >> >> > installed Reporting services). I then want them to be able to
>> > >> >> > pick
>> > >> >> > reports
>> > >> >> > and run them without any further authentication requests.
>> > >> >> >
>> > >> >> > Thank you all for any assistance you can provide.
>> > >> >> > Shirley
>> > >> >> >
>> > >> >> >
>> > >> >>
>> > >> >>
>> > >> >>
>> > >>
>> > >>
>> > >>
>> >
>> >
>> >|||having the same issue with same set-up type credentials for the admin
in SharePoint and SQL... known issue, but was wondering if you had
anyone help you resolve it|||"Juan.Carlos.Novoa@.gmail.com" wrote:
> having the same issue with same set-up type credentials for the admin
> in SharePoint and SQL... known issue, but was wondering if you had
> anyone help you resolve it
>
I am also having the smae issue. Has there been any solution determined on
this?

Deploy RS

Hi,
I have 2 questions:
* How can I deploy my reports , as part of setup, to customer sites? I use
VS.NET deployment and install Shield tools.
* Can I break my reports into multiple HTML pages? Like search results, I
would like to have multiple pages and use my own buttons to navigate between
different pages.
ThanksYou can script deployment instead of using VS to deploy. I would think
installshield could call the script. RS ships with an example of scripting.
Your choice for the reports is to use the portal that ships with RS (Report
Manager) or you can have your own front end (ASP.Net or Winform or
whatever). If you have your own then you use either URL integration or web
services. To do as you describe below you would need to use web services.
Doable but complicated.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Alex" <alim@.rogers.com> wrote in message
news:%23UKKtTUCFHA.1292@.TK2MSFTNGP10.phx.gbl...
> Hi,
> I have 2 questions:
> * How can I deploy my reports , as part of setup, to customer sites? I use
> VS.NET deployment and install Shield tools.
> * Can I break my reports into multiple HTML pages? Like search results, I
> would like to have multiple pages and use my own buttons to navigate
between
> different pages.
> Thanks
>|||At ICCO (www.icco.com) we have built a tool that deploys RDLs in a batch. If
you are interested I can give you more details. You can also call me at (954)
5471293.
"Alex" wrote:
> Hi,
> I have 2 questions:
> * How can I deploy my reports , as part of setup, to customer sites? I use
> VS.NET deployment and install Shield tools.
> * Can I break my reports into multiple HTML pages? Like search results, I
> would like to have multiple pages and use my own buttons to navigate between
> different pages.
> Thanks
>
>

Deploy SMO project

Hi,
I'm writting a tools with SMO that supports SQL Server 2005 and 2000 and I'm wondering wich components do I have to include in my setup to support both versions ?

With SQLServer 2000 my application throws a following message :

"Could not load type ‘Microsoft.sqlServer.Management.Smo.TriggerBaseCollection’ from assembly ‘Microsoft.sqlServer.Management.Smo’, version = 9.0.242.0"
Thank you.You should obtain the "Microsoft SQL Server 2005 Management Objects Collection", which contains SMO. See http://www.microsoft.com/downloads/details.aspx?FamilyID=d09c1d60-a13c-4479-9b91-9e8b9d835cdc&DisplayLang=en

Peter

Deploy RS

Hi,
I have 2 questions:
* How can I deploy my reports , as part of setup, to customer sites? I use
VS.NET deployment and install Shield tools.
* Can I break my reports into multiple HTML pages? Like search results, I
would like to have multiple pages and use my own buttons to navigate between
different pages.
ThanksYou can script deployment instead of using VS to deploy. I would think
installshield could call the script. RS ships with an example of scripting.
Your choice for the reports is to use the portal that ships with RS (Report
Manager) or you can have your own front end (ASP.Net or Winform or
whatever). If you have your own then you use either URL integration or web
services. To do as you describe below you would need to use web services.
Doable but complicated.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Alex" <alim@.rogers.com> wrote in message
news:%23UKKtTUCFHA.1292@.TK2MSFTNGP10.phx.gbl...
> Hi,
> I have 2 questions:
> * How can I deploy my reports , as part of setup, to customer sites? I use
> VS.NET deployment and install Shield tools.
> * Can I break my reports into multiple HTML pages? Like search results, I
> would like to have multiple pages and use my own buttons to navigate
between
> different pages.
> Thanks
>|||At ICCO (www.icco.com) we have built a tool that deploys RDLs in a batch. If
you are interested I can give you more details. You can also call me at (954)
5471293.
"Alex" wrote:
> Hi,
> I have 2 questions:
> * How can I deploy my reports , as part of setup, to customer sites? I use
> VS.NET deployment and install Shield tools.
> * Can I break my reports into multiple HTML pages? Like search results, I
> would like to have multiple pages and use my own buttons to navigate between
> different pages.
> Thanks
>
>

Deploy Reports via Visual Studio 2005

This seems to be a basic issue, but I am having a problem trying to deploy a report to Reporting Services.

I have setup the deployment options under the properties of the Project. But each time I try to deploy a report, I get "The request failed with HTTP status 504: Gateway Time-out"

When I try to connect to connect directly to the TargetServerURL via a web browser from my client or the server itself, I can browse the structure fine. Not sure why I can't deploy via Visual Studio.

Thoughts?

Thanks

This is a guess but it sounds like it could be a problem with a proxy server. Your browser is usually set up to handle requests through a proxy transparently. Visual Studio is not. Does the target server exist outside of your firewall?|||

To localize the test, I put the system running the Visual Studio on the same subnet. It's wide open with NO ACL control or routing from that point.

|||Are you still getting the same error? If you are on the same subnet, the request shouldn't be using a gateway.|||yes, same issue exists.|||try opening a command window and running "tracert <reportserver ip>" this will show you how requests are being routed to your report server. If the ip address of the report server isn't the first on the list, you are using some kind of proxy or gateway to get to the report server.

Deploy Reports via Visual Studio 2005

This seems to be a basic issue, but I am having a problem trying to deploy a report to Reporting Services.

I have setup the deployment options under the properties of the Project. But each time I try to deploy a report, I get "The request failed with HTTP status 504: Gateway Time-out"

When I try to connect to connect directly to the TargetServerURL via a web browser from my client or the server itself, I can browse the structure fine. Not sure why I can't deploy via Visual Studio.

Thoughts?

Thanks

This is a guess but it sounds like it could be a problem with a proxy server. Your browser is usually set up to handle requests through a proxy transparently. Visual Studio is not. Does the target server exist outside of your firewall?|||

To localize the test, I put the system running the Visual Studio on the same subnet. It's wide open with NO ACL control or routing from that point.

|||Are you still getting the same error? If you are on the same subnet, the request shouldn't be using a gateway.|||yes, same issue exists.|||try opening a command window and running "tracert <reportserver ip>" this will show you how requests are being routed to your report server. If the ip address of the report server isn't the first on the list, you are using some kind of proxy or gateway to get to the report server.

Deploy Reports via Visual Studio 2005

This seems to be a basic issue, but I am having a problem trying to deploy a report to Reporting Services.

I have setup the deployment options under the properties of the Project. But each time I try to deploy a report, I get "The request failed with HTTP status 504: Gateway Time-out"

When I try to connect to connect directly to the TargetServerURL via a web browser from my client or the server itself, I can browse the structure fine. Not sure why I can't deploy via Visual Studio.

Thoughts?

Thanks

This is a guess but it sounds like it could be a problem with a proxy server. Your browser is usually set up to handle requests through a proxy transparently. Visual Studio is not. Does the target server exist outside of your firewall?|||

To localize the test, I put the system running the Visual Studio on the same subnet. It's wide open with NO ACL control or routing from that point.

|||Are you still getting the same error? If you are on the same subnet, the request shouldn't be using a gateway.|||yes, same issue exists.|||try opening a command window and running "tracert <reportserver ip>" this will show you how requests are being routed to your report server. If the ip address of the report server isn't the first on the list, you are using some kind of proxy or gateway to get to the report server.

Deploy MSDE using Command

I am using VB6 to install MSDE and here is my syntax.
Setup.exe INSTANCENAME=NK SECURITYMODE=SQL SAPWD=NKM
It will install and show the progress bar all they way to about 4 second
left then freezes up. The log shows this as the last thing it did prior to
locking up "Executing "C:\Program Files\Microsoft SQL
Server\80\Tools\Binn\sqlredis.exe /q:a"
Any idea what went wrong?
hi Grant,
Grant wrote:
> I am using VB6 to install MSDE and here is my syntax.
>
> Setup.exe INSTANCENAME=NK SECURITYMODE=SQL SAPWD=NKM
> It will install and show the progress bar all they way to about 4
> second left then freezes up. The log shows this as the last thing it
> did prior to locking up "Executing "C:\Program Files\Microsoft SQL
> Server\80\Tools\Binn\sqlredis.exe /q:a"
> Any idea what went wrong?
please have a look at http://tinyurl.com/dm5hs
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.16.0 - DbaMgr ver 0.61.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Interesting but I cannot do it through that process. It will be install on
thousands of customer so you can image the volume of calls we will get. I
will look for a different way to deploy MSDE. Thanks.
"Andrea Montanari" <andrea.sqlDMO@.virgilio.it> wrote in message
news:3vloskF164dfqU1@.individual.net...
> hi Grant,
> Grant wrote:
> please have a look at http://tinyurl.com/dm5hs
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.16.0 - DbaMgr ver 0.61.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>

Dependent Service on MSSQLSERVER?

I have a ABC service on a server1 that is dependent on MSSQLSERVER service running on server2. Does anyone know how to setup the service ABC on server1 to have a dependancy on MSSQLSERVER running on server2?
Thanks,
jgsI don't think you can, unless server1 and server2 are nodes of Active/Active cluster. What is the ABC service for?|||The ABC service is a VB application that uses the SQL Server 2000 database on startup and operation.....|||How in blazes do you write a service using VB ?!?!

-PatP

dependacy files of sql server for deployment setup applicaton

Respected Sir
this thing I knew 2 year later, unfortunately forget and missplace

I want to not depend on sql server 2000 clients , can I include some dll s in my vb6 setup sothat I may not depend on sql server client to install all my clients
I want to add dependancy files of sql server in my deployment setup of application written in vb6 ans sql server
plz help me
Can anybody provide liste of these filesConnectivity to SQL Server should be enabled in baseline installs of Windows XP, Windows 2000, Windows 2003 and may be part of Windows NT SP4 (can't remember and it's been a while).

In Windows XP, 2000 and 2003 you can type cliconfg at a command prompt to get the SQL Server Client Configuration utility; I don't believe that any install of SQL Client tools is required.

You should be able to test/validate connectivity by creating a simple text file, rename it to [something.UDL] and then double clicking on it to start the Universal Data Link wizard. Set the parameters (SQL Server driver, SQL Server name, user name, password and default database) and then click on the Test Connection button.

Regards,

hmscott