Add SSL to Report Server after installation

Hello All!
I made the mistake of not enabling SSL on report server when I installed it.
Does anyone know how I could go about enabling it after the fact? I have a
website on which I have applied our cert but anytime you go to the reports or
reportmanager virtual directory it sees this as unsecure. Any help would be
greatly appreciated.
Thanks!
Jerry L. Cutshaw
Network/Database Administrator
Overland Solutions Inc.You will have to modify the SecureConnectionLevel setting in the
RSReportServicer.config file. See:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsprog/htm/rsp_prog_soapapi_dev_2xiq.asp
and
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql2k/html/sslsetup.asp
(if you just can't sleep at night and need something to read)
Adrian M.
"Chainsaw" <Chainsaw@.discussions.microsoft.com> wrote in message
news:A08FAF89-A7F9-4C5B-81ED-03D1669B4480@.microsoft.com...
> Hello All!
> I made the mistake of not enabling SSL on report server when I installed
> it.
> Does anyone know how I could go about enabling it after the fact? I have
> a
> website on which I have applied our cert but anytime you go to the reports
> or
> reportmanager virtual directory it sees this as unsecure. Any help would
> be
> greatly appreciated.
> Thanks!
> Jerry L. Cutshaw
> Network/Database Administrator
> Overland Solutions Inc.

add second node to sql2005 clustered

Hi, where I can find a guide step-by-step to add a second node to
existing sql2005 cluster?
I have installed an istance only on first node and now I want add the
second one.
I run the setup but i don't see the option to add the new node.
The resources are off-line in the node that i'm going to install.
Thank and sorry for my bad english
..yo.mo.
Cluster modifications are no longer run from the setup CD. Use "Add/Remove
Programs" in control panel to make cluster modifications to SQL 2005
systems.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
<dpasella@.gmail.com> wrote in message
news:1135164200.016047.77780@.g14g2000cwa.googlegro ups.com...
> Hi, where I can find a guide step-by-step to add a second node to
> existing sql2005 cluster?
> I have installed an istance only on first node and now I want add the
> second one.
> I run the setup but i don't see the option to add the new node.
> The resources are off-line in the node that i'm going to install.
>
> Thank and sorry for my bad english
> .yo.mo.
>
|||> <dpasella@.gmail.com> wrote in message
> news:1135164200.016047.77780@.g14g2000cwa.googlegro ups.com...
>Geoff N. Hiten wrote:
> Cluster modifications are no longer run from the setup CD. Use "Add/Remove
> Programs" in control panel to make cluster modifications to SQL 2005
> systems.
>
Thanks for your reply.
I have used "add/remove programs" but i can't modify the instance.
The log report that:
Complete: SetPackageInstallStateAction at: 2005/11/27 18:19:12,
returned true
Running: DeterminePackageTransformsAction at: 2005/11/27 18:19:12
Complete: DeterminePackageTransformsAction at: 2005/11/27 18:19:14,
returned true
Running: ValidateSetupPropertiesAction at: 2005/11/27 18:19:14
Complete: ValidateSetupPropertiesAction at: 2005/11/27 18:19:14,
returned true
Running: OpenPipeAction at: 2005/11/27 18:19:14
Complete: OpenPipeAction at: 2005/11/27 18:19:14, returned false
Error: Action "OpenPipeAction" failed during execution.
Running: CreatePipeAction at: 2005/11/27 18:19:14
Complete: CreatePipeAction at: 2005/11/27 18:19:14, returned true
Running: RunRemoteSetupAction at: 2005/11/27 18:19:14
<Func Name='CProcessCtrl::GetInstallPath'>
<EndFunc Name='CProcessCtrl::GetInstallPath' Return='0'
GetLastError='0'>
Error: 0x80070005 TaskScheduler::SetTargetComputer for \\CASTORE
Complete: RunRemoteSetupAction at: 2005/11/27 18:19:16, returned false
Error: Action "RunRemoteSetupAction" failed during execution. Error
information reported during run:
Attempting to determine log files for remote install.
Connection to remote computer's scheduler service.
Error: 80070005 Access denied
Running: PopulateMutatorDbAction at: 2005/11/27 18:19:16
Complete: PopulateMutatorDbAction at: 2005/11/27 18:19:16, returned
true
Running: GenerateRequestsAction at: 2005/11/27 18:19:16
Thanks for your help
..yo.mo.
|||Make sure the Windows Scheduler is running on the remote node.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
<dpasella@.gmail.com> wrote in message
news:1135704589.682373.8140@.g49g2000cwa.googlegrou ps.com...
> Thanks for your reply.
> I have used "add/remove programs" but i can't modify the instance.
> The log report that:
>
> Complete: SetPackageInstallStateAction at: 2005/11/27 18:19:12,
> returned true
> Running: DeterminePackageTransformsAction at: 2005/11/27 18:19:12
> Complete: DeterminePackageTransformsAction at: 2005/11/27 18:19:14,
> returned true
> Running: ValidateSetupPropertiesAction at: 2005/11/27 18:19:14
> Complete: ValidateSetupPropertiesAction at: 2005/11/27 18:19:14,
> returned true
> Running: OpenPipeAction at: 2005/11/27 18:19:14
> Complete: OpenPipeAction at: 2005/11/27 18:19:14, returned false
> Error: Action "OpenPipeAction" failed during execution.
> Running: CreatePipeAction at: 2005/11/27 18:19:14
> Complete: CreatePipeAction at: 2005/11/27 18:19:14, returned true
> Running: RunRemoteSetupAction at: 2005/11/27 18:19:14
> <Func Name='CProcessCtrl::GetInstallPath'>
> <EndFunc Name='CProcessCtrl::GetInstallPath' Return='0'
> GetLastError='0'>
> Error: 0x80070005 TaskScheduler::SetTargetComputer for \\CASTORE
> Complete: RunRemoteSetupAction at: 2005/11/27 18:19:16, returned false
> Error: Action "RunRemoteSetupAction" failed during execution. Error
> information reported during run:
> Attempting to determine log files for remote install.
> Connection to remote computer's scheduler service.
> Error: 80070005 Access denied
> Running: PopulateMutatorDbAction at: 2005/11/27 18:19:16
> Complete: PopulateMutatorDbAction at: 2005/11/27 18:19:16, returned
> true
> Running: GenerateRequestsAction at: 2005/11/27 18:19:16
>
> Thanks for your help
> .yo.mo.
>
|||Yes, the service is running (local service).
It is the first control that I have made
Thanks
..yo.mo.
Geoff N. Hiten wrote:[vbcol=seagreen]
> Make sure the Windows Scheduler is running on the remote node.
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
>
> <dpasella@.gmail.com> wrote in message
> news:1135704589.682373.8140@.g49g2000cwa.googlegrou ps.com...

Add Reporting Services to Trusted Accounts

I installed SQL 2005 SP2 and RS add-in for Sharepoint to a WSS 3.0 site.

I get the error: 'A connection to the server cannot be established' when I try to use the sharepoint account set up for this purpose. It is in the farm administrators, and has the required permissions when I check the database. Are there any other recommended troubleshooting tips that I can do? Thanks.

Dan

FYI - I resolved the problem by adding the account to the local group WSS_RESTRICTED_WPG. This account needs to be in the Local Administrator's group, and the groups starting with WSS.

Add new datasource C++ sqlexpress does not work

I have Visual C++ Express edition and SQL Express edition installed. When I try to add a datasource, the only two choices are Microsoft Access and SQL Server File. This SQL one does not work when I select it with an error that it was "Unable to open the physical file x.mdf. Operating system error 32: 32(The process cannot access the file because it is being used by another process.). An attempt to attach an auto-named database.... When I do my own

System::Data::SqlClient::SqlConnection ^ c0;

System::Data::SqlClient::SqlCommand ^ k0;

System::Data::SqlClient::SqlDataReader ^ r0;

things work fine. Do I need to get a $ edition, download something extra, connect to the a different file (master.mdf and not x.mdf), repair/reinstall, ...?

I would note that it destroyed my msde mdf in previous attempts before I decided to try only the sql express server as a datasource.

I haven't really used VC++ express, but I'll have a go at solving the problem. You shouldn't need to buy the $ edition of SQL Server, or download something extra. In the past when I've seen this error, it has either been to do with file permissions or another instance being attached to the file. Verify that the user you're currently logged on as has full permissions on the file you are trying to connect to.

If this doesn't help, maybe post the connection strings you are using up.

|||

For some reason I am not quite sure, when I tried to set up a datasource today after a reboot and not opening and debugging a project that had a manually written connection that worked, I was successful in getting the gui wizard to work.

Thanks.

add disk to a cluster running sql2005

hi,
I have a windows 2003 sp1 cluster running sql2005.
the DB is installed on S: and i have a R: & U: drive letter that is both
differend disk and runs fine in the cluster.
But i can not see those disks in sql 2005 why ?
the disks are in the same resource group (SQL)
where can I choose the R drive ?
if I choose attach DB I see only the S drive where the DB is installed.
any help is welcome
greetings,
Robert
Hi,
Just fixed it
I added the disk resources to the SQL2005 server resource and now it is
running.
greetings,
"Robert Smit ( 450331)" <RSM.news@.thebackbone.nl> wrote in message
news:OeiQZhQFGHA.524@.TK2MSFTNGP09.phx.gbl...
> hi,
> I have a windows 2003 sp1 cluster running sql2005.
> the DB is installed on S: and i have a R: & U: drive letter that is both
> differend disk and runs fine in the cluster.
> But i can not see those disks in sql 2005 why ?
> the disks are in the same resource group (SQL)
> where can I choose the R drive ?
> if I choose attach DB I see only the S drive where the DB is installed.
> any help is welcome
> greetings,
> Robert
>
|||Just adding them to the SQL Server group is not enough. They have to be
added as a dependency of the SQL Server resource.
Mike
Mentor
Solid Quality Learning
http://www.solidqualitylearning.com
"Robert Smit ( 450331)" <RSM.news@.thebackbone.nl> wrote in message
news:OeiQZhQFGHA.524@.TK2MSFTNGP09.phx.gbl...
> hi,
> I have a windows 2003 sp1 cluster running sql2005.
> the DB is installed on S: and i have a R: & U: drive letter that is both
> differend disk and runs fine in the cluster.
> But i can not see those disks in sql 2005 why ?
> the disks are in the same resource group (SQL)
> where can I choose the R drive ?
> if I choose attach DB I see only the S drive where the DB is installed.
> any help is welcome
> greetings,
> Robert
>

Add connection error: 40

Hi i just reinstalled windows, and installed visual studio .net 2005 and the Sql server.

But when im trying to add connection, select my computer at Server

name, type a databasename then pressing OK i get this message:

An error has occured while estabilishing a connection to the server.

When connection to SQL server 2005, this faliure may be caused by the

fact that under the default settings SQL Server does not allow remote

connections. (provider: Names pipes provider, error: 40 - Could not

open a connection to SQL Server)

Does anyone know what todo?

hermanTry this: open the SQL Server Configuration Manager, expand SQL Server 2005 Network Configuration, highlight protocols for MSSQLSERVER and enable TCIP/IP.

Mike

add an Oracle linked server as a subscriber

Hi,
I have an Oracle 9i client installed on SQL Server 2000, and I want to add a linked Oracle server to SQL Server so that I can use the linked Oracle server as a subscriber, I got an error says 'OLEDB error, OLEDB error trace: initialize returned 0x80004005
', and I can not view the tables or views in the Oracle linked server, can anybody help me on this?
Hong
80004005 is generic access denied you need to use a login and password on
your linked server which maps to SYSDBA or SYSTEM on the Oracle server.
Hilary Cotter
Looking for a book on SQL Server replication?
http://www.nwsu.com/0974973602.html
"Hong Wang" <anonymous@.discussions.microsoft.com> wrote in message
news:E7D43F27-B100-4CE1-A32C-B084E8EC2C96@.microsoft.com...
> Hi,
> I have an Oracle 9i client installed on SQL Server 2000, and I want to add
a linked Oracle server to SQL Server so that I can use the linked Oracle
server as a subscriber, I got an error says 'OLEDB error, OLEDB error trace:
initialize returned 0x80004005', and I can not view the tables or views in
the Oracle linked server, can anybody help me on this?
> Hong

Add a third node to a cluster

I have two node SQL Enterprise installed on a Windows 2003 cluster running
active -active. I would like to add a third node so that it would become 2
active and 1 passive . Is this feasible ?
Also , can someone tell me how can I make the third node standby for the
other two ? Do I have to install any binary and executable on the third node
/ modify the possible owner ?
Raymond
Look at "How to add nodes to an existing virtual server (Setup)" in BOL. It
gives a step by step on how to do it.
After you ran that, follow the steps in the Service Pack readme that you
have installed on the other nodes.
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Norman" <raymond.chan@.hotmail.com> wrote in message
news:u7qvDXwYFHA.2288@.TK2MSFTNGP14.phx.gbl...
>I have two node SQL Enterprise installed on a Windows 2003 cluster running
>active -active. I would like to add a third node so that it would become 2
>active and 1 passive . Is this feasible ?
> Also , can someone tell me how can I make the third node standby for the
> other two ? Do I have to install any binary and executable on the third
> node / modify the possible owner ?
> Raymond
>
|||Norman
To control failover you can use the Preferred Owners List on the Group
Property sheets. However if you have a Windows 2003 Cluster you can implement
AntiAffintityClassNames to make absolutely certain that a node that is in a
passive role take ownership of a group in the event of a failure. See the
following KB for details on how to setup.
http://support.microsoft.com/default...;en-us;Q296799
Regards
CT
"Norman" wrote:

> I have two node SQL Enterprise installed on a Windows 2003 cluster running
> active -active. I would like to add a third node so that it would become 2
> active and 1 passive . Is this feasible ?
> Also , can someone tell me how can I make the third node standby for the
> other two ? Do I have to install any binary and executable on the third node
> / modify the possible owner ?
> Raymond
>
>

Add a new data source to a SQL Server Compact Edition

I have installed SQL Server 2005 CE on my computer, but when I try to add a data connection to a CE database in Visual Studio 2005, I cannot find the option "SQL Server 2005 Combact Edition". Why?

Hi,

see this here: http://img366.imageshack.us/img366/555/untitledph0.jpg
-Jens.

|||I have the same issue. I install the SQL compact framework runtime, SDK, and VS2K5 components but the option is never listed in the potential data sources for any project. I can create as many SQL server, SQL server express, or Access databases as I want, but the option for the Compact Edition just isn't listed.|||Hi,

I face the exactly the same problem. Have anyone found the solution to this?
thanks.

regards,
TY|||Hi,

Finally i got the problem fixed. Seem like there are some name conflict within the VS2005 for the Mobile Edition and Compact Edition. Just need to install the VS2005 SP1 all those problem will automatic fixed.
thanks.

regards,
Tze Yang

Add a new data source to a SQL Server Compact Edition

I have installed SQL Server 2005 CE on my computer, but when I try to add a data connection to a CE database in Visual Studio 2005, I cannot find the option "SQL Server 2005 Combact Edition". Why?

Hi,

see this here: http://img366.imageshack.us/img366/555/untitledph0.jpg
-Jens.

|||I have the same issue. I install the SQL compact framework runtime, SDK, and VS2K5 components but the option is never listed in the potential data sources for any project. I can create as many SQL server, SQL server express, or Access databases as I want, but the option for the Compact Edition just isn't listed.|||Hi,

I face the exactly the same problem. Have anyone found the solution to this?
thanks.

regards,
TY
|||Hi,

Finally i got the problem fixed. Seem like there are some name conflict within the VS2005 for the Mobile Edition and Compact Edition. Just need to install the VS2005 SP1 all those problem will automatic fixed.
thanks.

regards,
Tze Yang