Blending life, nature and technology.
Unable to connect to remote server – error
If you get this message say from Visual Studio when trying to deploy SSRS reports to a SQL Server 2008 database instance, heres how this can be resolved. This is usually caused by kerberos security authentication. Navigate to: C:\Program Files\Microsoft SQL Server\MSRS10.MSSQLSERVER\Reporting Services\ReportServer Edit the file rsreportserver.config
Make the change below:
<!–<Add Key=”SecureConnectionLevel” Value=”2″/>–>
<Add Key=“SecureConnectionLevel“ Value=“0“/>
Restart Reportserver. You should be able to deploy your reports now to SQL Server Reporting Services 2008.
| Print article | This entry was posted by Stephen on December 31, 2008 at 8:33 am, and is filed under Software, computers. Follow any responses to this post through RSS 2.0. You can leave a response or trackback from your own site. |
No comments yet.
No trackbacks yet.
MCITP Exam 70-450
about 2 months ago - No comments
Microsoft Exam 70-450: PRO: Designing, Optimizing and Maintaining a Database Administrative Solution Using Microsoft SQL Server 2008 Passed this exam on 5/25. It rained heavily all day. Books for this exam arent really out yet, even from Microsoft. Theres a new book that came out l’ll immediately recommend to anyone – its very concise, real-world
SQL Server 2008 Data Collection..
about 3 months ago - No comments
“SQL Server 2008 provides a data collector that you can use to obtain and save data that is gathered from several sources. The data collector enables you to use data collection containers, which enable you to determine the scope and frequency of data collection on a computer that is running SQL Server 2008.” Setup steps
SQL Server 2008 R2 installation notes…
about 3 months ago - No comments
Click here to view my installation by pictures webpage for Microsoft SQL Server 2008 R2
Installing Sharepoint 2010 Beta..
about 5 months ago - No comments
Microsoft Sharepoint 2010 beta software requires the following: Application server role, web server IIS Role SQL Server 2008 native client Microsoft “Geneva” framework runtime Microsoft Chart Controls for Microsoft Framework 3.5 Microsoft Filter Pack 2.0 SQL Server 2008 Analysis Services ADOCMD.NET I attempted to install this on a development Windows 2008 R2 server, which already
Transferring logins and passwords between SQL Server 2005 and SQL Server 2008
about 6 months ago - No comments
This link is very useful and details how to transfer the logins and the passwords between instances of Microsoft SQL Server 2005, and Microsoft SQL Server 2008, on different servers. – Microsoft Knowledge Base: #246133
Microsoft SQL Server, Error: 15401
about 6 months ago - No comments
Got this error a lot when trying to add NT user accounts on a SQL Server 2008 installation that was connected to a Windows 2008R2 server running Active Directory 2008 at Windows 2000 functional level. Same error message appeared when troubleshooting this from a SQL Server 2005 instance in the same server environment. You’ll keep
Azure sample database setup….
about 7 months ago - No comments
Notes on setting up the sample database – adventureworks [click here] for Microsoft’s cloud computing sql server called Azure: you need an account – get one from sql.azure.com – it takes some time for your access information to arrive by email. download the sample database using link above extract/unzip to a known location make sure
Business Intelligence w/SQL 2008
about 7 months ago - No comments
Currently reading “Delivering Business Intelligence with Microsoft SQL Server 2008 by Brian Larson” Interesting quotes/definitions: “Would you tell me please, which way I ought to go from here?” asked Alice. “That depends a good deal on where you want to get to,” said the Cat. “I don’t much care where,” said Alice. “Then, it doesn’t matter
Azure SQL….
about 7 months ago - No comments
Adventure works sample databases are now available for Microsoft’s SQL Azure at codeplex – click here.
collection_set_3_upload job keeps failing on uploading Query Statistics – SQL Server 2008
about 9 months ago - No comments
Keep getting the error messages below from the logs: To view the detailed logs in SSMS 2008: Drill down on Management -> data collection -> query statistics -> view logs ====== Error Messages Below===== Event Data Code Message SSIS error. Component name: DFT – Upload collection snapshot, Code: -1073450974, Subcomponent: SSIS.Pipeline, Description: SSIS Error Code