I want to know how to make IIS as default web server on machine instaead of built cassini web server..
Thanks in advance.
View Complete Post
Now you can perform efficient, sophisticated text analysis using regular expressions in SQL Server 2005.
MSDN Magazine February 2007
By now, you're certainly collecting a variety of data from your Web site. But once you collect it, what do you do with it. For it to be meaningful, this data must be categorized and analyzed. The SQL Server 2005 data mining functionalities can help you get the most out of those reams of data you collect, as Peter Pyungchul Kim explains.
Peter Pyungchul Kim
MSDN Magazine June 2005
i try to use the set server default for reporting services in wss3 but when i click on the link i get an error like this:
An unexpected error occurred while connecting to the report server. Verify that the report server is available and configured for SharePoint integrated mode. --> Server was unable to process request. --->
Client found response content type of 'text/html; charset=utf-8', but expected 'text/xml'.
The request failed with the error message:
<HEAD><meta name="GENERATOR" content="Microsoft SharePoint" /><meta name="progid" content="SharePoint.WebPartPage.Document" /><meta HTTP-EQUIV="Content-Type" content="text/html; charset=utf-8"
/><meta HTTP-EQUIV="Expires" content="0" /><meta name="ROBOTS" content="NOHTMLINDEX" /><title>
</title><link rel="stylesheet" type="text/css" href="/_layouts/1033/styles/core.css?rev=5msmprmeONfN6lJ3wtbAlA%3D%3D"/>
We are attempting to change the default collation of an SQL Server 2005 Clustered environment. We have created an "unattended install" script to perform this, and have modified it several times as errors have arisen repeatedly. The last time, however, we
used the following script:
start /wait setup.exe /qb VS=<FQN of SQL Server Virtual Name> INSTANCENAME=MSSQLSERVER REINSTALL=SQL_Engine REBUILDDATABASE=1 ADMINPASSWORD=<adminpwd> SAPWD=<NEW sa pwd> SQLCOLLATION=SQL_Latin1_General_CP1_CI_AS SQLACCOUNT=<domain\user>
SQLPASSWORD=<pwd> AGTACCOUNT=<domain\user> AGTPASSWORD=pwd GROUP=SQL Group REINSTALLMODE=vomus
We are running this script from the primary (Active) node of the cluster. We did notice that the bootstrap logs created from this final execution did include logs from both nodes. When I look in the Summary.txt file, it tells me that Setup succeeded with
the installation. After the script executed, we rolled the cluster from primary to secondary, and rebooted the primary node. We then rolled the cluster back to the primary, and rebooted the secondary node. Once that was complete, we cycled the SQL Server service
from the SQL Configuration Manager. After all those steps, we opened SSMS client to look at the properties of master, and the collation was still CI_AI.
We are losing valuable time in
I am frustrated with this challenge for populating default values for filters in report builder. Here are the steps that I am performing.
I have clicked on the filter icon, then dragged the dimension to the filter pane, switched the properties to Prompt and changed the operator to 'in this list'.
by default the value selected is 'no value selected', Microsoft online tutorials says that this should automatically populate the filter criteria with the default list of values for the underlying dimension. However it dosen't
How do I populate this filter with default list of values.
I have a user getting some problem with connecting to local SQL Server 2008 default instance using windows authentication with a user which has sysadmin role and is owner of each existing database:
2010-09-28 15:40:35.04 Logon Error: 18456, Severity: 14, State: 11.
2010-09-28 15:40:35.04 Logon Login failed for user 'IIS APPPOOL\RoomViewSEWebClient'.
Reason: Token-based server access validation failed with an infrastructure error. Check for previous errors. [CLIENT: 127.0.0.1]