configure sql xml support IIS

SQL Server Setup & Upgrade

Index ‹ SQL Server

- Previous
  - 1
    - SQL Server 2005 JDBC Driver v1.1 and SSL Hi folks, I'm trying to figure out if the SQL Server 2005 JDBC driver supports SSL at all. I've downloaded the driver documentation, looked at more web pages than I care to count, and even went as far as to take a stab at guessing at different driver property names in the hopes I might discover some undocumented feature. Each time I try, I come up dry. The following exception shows up in my JBoss log: 2007-01-03 12:13:36,812 WARN [org.jboss.resource.connectionmanager.JBossManagedConnectionPool] Throwable while attempting to get a new connection: null org.jboss.resource.JBossResourceException: Could not create connection; - nested throwable: (com.microsoft.sqlserver.jdbc.SQLServerException: The SQL Server login requires an SSL connection.) I know I have things working properly on the SQL Server side, as both osql and Query Analyzer work fine, and packet sniffing yields no plain text information. I've also tried swapping in the open source JTDS driver, and once again, sniffing shows that the data between the two machines in encrypted. Does anyone know if I'm just missing something completely obvious, or can someone state with absolute certainty that the driver does not support SSL Any ideas on how to find out if there are plans to support this feature and what the timeline might be Thanks in advance. Trev. Tag: configure sql xml support IIS
  - 2
    - Loading excel file(.xls) into sqlserver (ASP.net web application)(ASP.net framework 1.0) i found the following codes, hardcoding the datasource file for the excel file seems to worked... but i couldn't select and upload random files...(random means through the file selection screen...) 'Import by using OPENDATASOURCE. strSQL = "SELECT * INTO XLImport6 FROM " & _ "OPENDATASOURCE('Microsoft.Jet.OLEDB.4.0', " & _ "'Data Source=C:\test\xltest.xls;" & _ "Extended Properties=Excel 8.0')...[Customers$]" Debug.Print strSQL cn.Execute strSQL, lngRecsAff, adExecuteNoRecords Debug.Print "Records affected: " & lngRecsAff Tag: configure sql xml support IIS
  - 3
    - compact sqlce database Thank you. I will give it a try. Tag: configure sql xml support IIS
  - 4
    - Database design - best practices Does anyone know the location of an offical (Microsoft if possible) document that shows the best practices for databse design For instance what to call tables now schema's exist Should it be Countries LookCountry Geography.Country Geography.Countries What about Views and Stored procedures prefix with VW_ sp_ or some alternative Thanks Tag: configure sql xml support IIS
  - 5
    - How do can I do this? Thank you, Alan; you caught me. I have missed the EXCEPT join at least once before, too. Please keep after me until I get it right. :-) Dave Tag: configure sql xml support IIS
  - 6
    - OLE DB Source to Flat File Destintation using Fixed Width Columns - determining source column width Hi, I am trying to create a program that transfers tables to flat files. At this point in time, I have suceeded in created one that creates delimited files. However, I am now trying to create fixed-width files as you can do with the SSIS designer, but programatically. Is there a way to programatically determine the width of a column from the source table I can not seem to find any kind of function or member that stores this information or allows me to retrieve it. I know what I need to change in order to set a width for a column, but I just don't know how to find the width without just asking the user to provide one. Tag: configure sql xml support IIS
  - 7
    - date picker format in IE, Language: English (United Kingdom) [en-gb] still not working... is it because of the default value of the parameter but it's displaying the correct format for the date... thanks for your help Tag: configure sql xml support IIS
  - 8
    - Data disappearing during Run time Sorry about the typo, i was meaning "now". Back to your points 1.a connection to the main instance with an attached database (if by that it means a database, with a child database within it) 2. it's happening in both debugging and deployment Hope this helps - any other question please ask Cheers Tag: configure sql xml support IIS
  - 9
    - Old problem, but... Cannot open user default database. Login failed. Login failed for user 'NT AUTHORITY\NETWORK SERVICE'. I didn't use SQL Express before, now I am trying to use it. I thinkk it is convinient if you just want to copy db files to user's machine. like this <add name="schsecurity" connectionString="Data Source=.\SQLExpress;Integrated Security=true;User Instance=True;AttachDBFilename=|DataDirectory|aspnetdb.mdf" /> as long as user has sql express installed, he should be able to use the db once he copy the file aspnetdb.mdf over. but when I tried it, I got Cannot open user default database. Login failed. Login failed for user 'NT AUTHORITY\NETWORK SERVICE'. it looks simple, SQL express can not verify user 'NT AUTHORITY\NETWORK SERVICE' so I connect SQL express with SQL server management studio, and add the user into login of the SQL express and set the user as sysadmin. But I still get the error. Any idea thanks! Tag: configure sql xml support IIS
  - 10
    - Data Conversion It's going to be manual somehow... Either you configure the flat file source with the correct data types, or you add a derived column/data conversion component, or you stage the data into SQL Server and write a SQL statement to convert the view. Tag: configure sql xml support IIS
  - 11
    - Results from Aggregate() are wrong I opened a case with Microsoft related to our inaccurate results from Aggregate(). It appears that there is a bug in SP2 that causes queries to return inaccurate results when a cube dimension has unnatural hierarchies in it. I know that unnatural hierarchies have performance limitations but I thought they were a well-established feature of SSAS 2005 nevertheless. My understanding of the problem is still limited. Has anybody else heard anything more about the potential they have to corrupt query results Tag: configure sql xml support IIS
  - 12
    - Inconsistent Linked Server Query Results Hello, I have a linked server named 'Charlie_File' to an Excel Workbook that I set up in SQLServer 2005 Management Studio. The workbook is on my local C drive. Sometimes, I get the results back that I expect when I run the following query; SELECT * FROM OPENQUERY ( Charlie_file , 'SELECT * FROM [Feb$]' ) Sometimes, on subsequent runs of the above query, I get the following message; Msg 7399, Level 16, State 1, Line 1 The OLE DB provider "MSDASQL" for linked server "Charlie_file" reported an error. The provider did not give any information about the error. Msg 7303, Level 16, State 1, Line 1 Cannot initialize the data source object of OLE DB provider "MSDASQL" for linked server "Charlie_file". There seems to be about a minute or so of a delay before the query will run correctly on subsequent attempts. Is there a connection issue here where a connection blocks subsequent attempts to select the data within a specific time span Thank you for your help! cdun2 Tag: configure sql xml support IIS
  - 13
    - Can't get Dynamic Security working ... Ok, I think I figured out the issue. The parameters in my filter expression are too specific (if that's even possible). I tried removing the Dimension name and it works. So, the new expression looks like this: FILTER([DDO].Members, INSTR([DDO].CurrentMember.Properties("DDO Access List"), "JJester")) Anyhow, thanks for your help Mosha! Tag: configure sql xml support IIS
  - 14
    - Sql Query to create nested XML Sitemap Can you generate an example of the kind of output you are looking for If you can give a sample output I think I will be able to map to it. Tag: configure sql xml support IIS
  - 15
    - How Extract the data of TFINF when doing text mining? Thanks How Extract the data of TFINF when doing text mining Thanks Tag: configure sql xml support IIS
  - 16
    - Passing SELECT ALL from URL How do I pass this any values from a URL string Tag: configure sql xml support IIS
- Next
  - 1
    - Clone new database from existing The 'safest' (and easiest) method to do this is to do a backup, and then restore to a different name and/or location. Read up on RESTORE in Books Online. Tag: configure sql xml support IIS
  - 2
    - How to restrict a custom component to be used only in the event handler tab? This is really very helpful. Thanks again. $wapnil Tag: configure sql xml support IIS
  - 3
    - catch me if you can / bug in the "bug"? Hi! The german pdf explain exactly why this stuff is so important to me ;-) I'm happy about what you are saying about "3". About "1": no BOL has not an example with non existing stored proc, where the error will be catched! Thanks Tag: configure sql xml support IIS
  - 4
    - Parameters in an OLE DB Command Hello! Is there a way to use an OLE DB Command transform to execute the following SQL query "Select sum(length(" + @[User::varDBName] + ":informix.cyh_t.u_obj)) from " + @[User::varDBName] + ":informix.cyh_t, " + @[User::varDBName] + ":informix.cch_t where " + @[User::varDBName] + ":informix.cch_t.d_obj = {D '" + @[User::strQueryDate] + "'} and " + @[User::varDBName] + ":informix.cch_t.n_objid = " + @[User::varDBName] + ":informix.cyh_t.n_objid" I get a DB number from an OLE DB Source, do a lookup to get the DB name and then I want to use the OLE DB command to get a result from the query but I can't seem to get this to work. Am I using the wrong transform Thanks. Tag: configure sql xml support IIS
  - 5
    - How to set the current connectionString user as a defualt value? Hi, I'm using username & password in my connectionString to connect my program (C#.net) with Sql Server 2005.. I put in defualt value in one feild: user_name() it replace the user: dbo, not the user which I used in my connectionString . so.. how to get this user I tried to put: currnet_user but I get the same result, " dbo " not the user in my connectionString .. Tag: configure sql xml support IIS
  - 6
    - Generating letters in SSRS Hi. I'm looking for tutorials on how to use SSRS 2005 to generate letters in Word or PDF format from a database. We need to send letters with our company logo and some boilerplate text to a set of companies based on a SQL Server query. So the letter will look something like this, with the red areas repeating from the dataset, [logo goes here] 123 Any St. AnyCity, CA 90210 [today's date] Dear [name from database] , Some boilerplate text goes here. Your Account [account number from database] is past due. Sincerely, [scanned signature goes here] Somebody Tag: configure sql xml support IIS
  - 7
    - Can I retrieve a result set from a sp into a variable within a Execute SQL Task? I am building it in a variable that contains exec sp_name '20071201' Tag: configure sql xml support IIS
  - 8
    - Creating Stored Procedure in SQLServer2005 Thank you all, I have found the Answer I wasnt understanding the complex syntax so i simply deleted it all and kept the Following CREATE PROCEDURE [dbo].[NCompOpp] AS BEGIN Select from opmgr where opmgr.rectype="OP" END my major problem is that there are slight difference between writing Stored Procedures in SQL Server 2000 and in SQL Server 2005 Tag: configure sql xml support IIS
  - 9
    - Help with modifying a data source's query at runtime Please help figure out what is wrong with my code. The script is supposed to load a package (from file). The loaded package already has everything set up to run a query against a local server and output the results to an Excel file. The reason for the outer script is because I need to change the query based on a global variable. When the query changes, though, I think the existing dataflow Path is no longer valid, so I should remove it and re-create another one with the new input mappings. Here is my code, which runs and throws an exception at the AcquireConnections call. The error is Error: 0x2 at Script Task: The script threw an exception: Exception from HRESULT: 0xC020801B I pieced together this code from the examples in the online books, but I am not sure what to do. ' Microsoft SQL Server Integration Services Script Task ' Write scripts using Microsoft Visual Basic ' The ScriptMain class is the entry point of the Script Task. Imports System Imports System.Data Imports System.Math Imports Microsoft.SqlServer.Dts.Runtime Imports Microsoft.SqlServer.Dts.Pipeline Imports Microsoft.SqlServer.Dts.Pipeline.Wrapper Public Class ScriptMain Public Sub Main() ' Dim app As Microsoft.SqlServer.Dts.Runtime.Application = New Application() Dim package As Microsoft.SqlServer.Dts.Runtime.Package = _ app.LoadPackage( "c:\systime\ExcelOut\ExcelOut\ExcelOutDo.dtsx" , Nothing ) Dim pkgVars As Variables = package.Variables Dim gsVar As Variable = pkgVars( "User::gsExcelFile" ) Dim currVars As Variables = Dts.Variables Console.WriteLine(Dts.Variables( "User::gsExcelFile" ).Value) gsVar.Value = Dts.Variables( "User::gsExcelFile" ).Value pkgVars( "User::gsQuery" ).Value = Dts.Variables( "User::gsQuery" ).Value pkgVars( "User::gsCreateTable" ).Value = Dts.Variables( "User::gsCreateTable" ).Value Dim e As Executable = package.Executables( "ExcelOutTask" ) Dim thMainPipe As Microsoft.SqlServer.Dts.Runtime.TaskHost = _ CType (e, Microsoft.SqlServer.Dts.Runtime.TaskHost) Dim dataFlowTask As MainPipe = CType (thMainPipe.InnerObject, MainPipe) ' Get the source component. Dim SourceComponent As IDTSComponentMetaData90 = _ dataFlowTask.ComponentMetaDataCollection( "Local Source" ) Dim srcDesignTime As CManagedComponentWrapper = SourceComponent.Instantiate() srcDesignTime.ProvideComponentProperties() ' Reinitialize the metadata. srcDesignTime.AcquireConnections(vbNull) srcDesignTime.ReinitializeMetaData() srcDesignTime.ReleaseConnections() ' Get the destination component. Dim destination As IDTSComponentMetaData90 = _ dataFlowTask.ComponentMetaDataCollection( "Excel Destination" ) Dim destDesignTime As CManagedComponentWrapper = destination.Instantiate() destDesignTime.ProvideComponentProperties() ' Create the path. dataFlowTask.PathCollection.RemoveAll() Dim path As IDTSPath90 = dataFlowTask.PathCollection.New() path.AttachPathAndPropagateNotifications(SourceComponent.OutputCollection(0), _ destination.InputCollection(0)) 'Console.WriteLine(dataFlowTask.PathCollection.Count) Dim ret As DTSExecResult ret = package.Execute() Console.WriteLine(ret.ToString) Dts.TaskResult = Dts.Results.Success End Sub End Class Tag: configure sql xml support IIS
  - 10
    - Two Dimensions Sharing same Parent Table Dave, Thanks a lot Tag: configure sql xml support IIS
  - 11
    - Can't shrink DB Finally managed to shrink the DB, I've noticed that every DBCC SHRINKFILE command shrinked the DB in about 4-5%, so I just executed the command few 10s of time and it shrank to ~200MB. Thanks, YP Tag: configure sql xml support IIS
  - 12
    - Reporting services in SharePoint integration mode problems Hi, I'm having problems setting up Reporting Services in SharePoint Integration mode. The development environment works fine, but I can't get it to work in production. Problem seems to be in the authentication between SharePoint and Reporting Services. When I go to "Set Server Defaults" in the SharePoint central administration I get the following message: Code Snippet An unexpected error occurred while connecting to the report server. Verify that the report server is available and configured for SharePoint integrated mode. --> System.Web.Services.Protocols.SoapException: Server was unable to process request. ---> System.Net.WebException: The request failed with HTTP status 401: Unauthorized. at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall) at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters) at Microsoft.SqlServer.ReportingServices2006.ReportingService2006.ListSecureMethods() at Microsoft.ReportingServices.SharePoint.Soap.ReportService2006.ListSecureMethods() --- End of inner exception stack trace --- I get the same message when trying to deploy a report from Visual Studio to a SharePoint lib. Some info: - SP apppool is running under domain account a - SSRS apppool is running under domain account b - SP uses NTLM authentication - SP and SSRS are running on different servers - SSRS Configuration shows all green checkmarks Things I tried: - Basic authentication instead of Windows Integrated on SSRS - NTLM only instead of Negotiate on SSRS - Settings SPN's for SSRS, didn't help - Checked NTFS rights on ReportingServer dir, were fine (Domain users have read/list) Does anyone have an idea about how to solve this Any help is appreciated. Tag: configure sql xml support IIS
  - 13
    - Recursive Query Without Self-Referencing Structure I need a statement that can return a hierarchy of folders. There are a number of good articles out there describing how to do this in SQL 2005 with a Common Table Expression (CTE) that references itself under a UNION ALL. Yet every example I come across involves a self-referencing table. Unfortunately the architect of my project did not use that simple structure. Instead, we have a Folder table and Folder Properties table. Creating a child Folder involves adding a row in the Properties table that links to a parent. Here's the statement I came up with: WITH Folders (ID, ParentID, FolderName, FolderDepth) AS ( SELECT FOLDER_ID, NULL, FOLDER_NAME, 0 FROM ZZ_FOLDER WHERE FOLDER_ID = 1 UNION ALL SELECT F.FOLDER_ID, Folders.ID, F.FOLDER_NAME, Folders.FolderDepth + 1 FROM ZZ_FOLDER F INNER JOIN ZZ_FOLDER_PROP FP ON FP.FPROP_FOLDER_ID = F.FOLDER_ID WHERE FP.FPROP_LINK_ID = Folders.ID ) SELECT * FROM Folders The initial statement brings back the top of the folder structure. The recursive statement brings back Folder rows that have an entry in their Property rows for the parent. Yet when I try to execute this, I get: Msg 4104, Level 16, State 1, Line 1 The multi-part identifier "Folders.ID" could not be bound. Msg 4104, Level 16, State 1, Line 1 The multi-part identifier "Folders.ID" could not be bound. Msg 4104, Level 16, State 1, Line 1 The multi-part identifier "Folders.FolderDepth" could not be bound. It sounds like all the recursive references to the CTE are unavailable. What am I doing wrong Would welcome any suggestions, too. I realize this isn't a T-SQL specific question, more SQL in general, but I didn't see a more relevant forum. What follows are some tables/data to run the above statement against. -- Create Folder Tables CREATE TABLE ZZ_FOLDER ( FOLDER_ID INTEGER NOT NULL PRIMARY KEY, FOLDER_NAME VARCHAR(50)) CREATE TABLE ZZ_FOLDER_PROP ( FPROP_ID INTEGER NOT NULL PRIMARY KEY, FPROP_FOLDER_ID INTEGER NOT NULL, FPROP_LINK_TYPE VARCHAR(50), FPROP_LINK_ID INTEGER NOT NULL) GO -- Populate Folder Tables INSERT INTO ZZ_FOLDER VALUES (1, 'Top Level') INSERT INTO ZZ_FOLDER VALUES (2, 'Second Level A') INSERT INTO ZZ_FOLDER VALUES (3, 'Second Level B') INSERT INTO ZZ_FOLDER VALUES (4, 'Second Level C') INSERT INTO ZZ_FOLDER VALUES (5, 'Third Level A1') INSERT INTO ZZ_FOLDER VALUES (6, 'Third Level A2') INSERT INTO ZZ_FOLDER VALUES (7, 'Third Level A3') INSERT INTO ZZ_FOLDER VALUES (8, 'Third Level B1') INSERT INTO ZZ_FOLDER VALUES (9, 'Third Level C1') INSERT INTO ZZ_FOLDER VALUES (10, 'Third Level C2') INSERT INTO ZZ_FOLDER VALUES (11, 'Fourth Level A3A') INSERT INTO ZZ_FOLDER_PROP VALUES (1, 2, 'Folder', 1) INSERT INTO ZZ_FOLDER_PROP VALUES (2, 3, 'Folder', 1) INSERT INTO ZZ_FOLDER_PROP VALUES (3, 4, 'Folder', 1) INSERT INTO ZZ_FOLDER_PROP VALUES (4, 5, 'Folder', 2) INSERT INTO ZZ_FOLDER_PROP VALUES (5, 6, 'Folder', 2) INSERT INTO ZZ_FOLDER_PROP VALUES (6, 7, 'Folder', 2) INSERT INTO ZZ_FOLDER_PROP VALUES (7, 8, 'Folder', 3) INSERT INTO ZZ_FOLDER_PROP VALUES (8, 9, 'Folder', 4) INSERT INTO ZZ_FOLDER_PROP VALUES (9, 10, 'Folder', 4) INSERT INTO ZZ_FOLDER_PROP VALUES (10, 11, 'Folder', 7) GO /* Top Level Second Level A Third Level A1 Third Level A2 Third Level A3 Fourth Level A3A Second Level B Third Level B1 Second Level C Third Level C1 Third Level C2 */ Tag: configure sql xml support IIS
  - 14
    - c# reusing parameters I have a select statement which requires numerous parameters. here is a snippet. SqlCommand cmd = new SqlCommand("SELECT this from MyTable WHERE Answer1 = @Att 1AND Answer2 = @Att2 AND Answer3 = @Att3", connection) my parameters are added as follows. SqlParameter Att1 = new SqlParameter("@Att1", SqlDbType.VarChar, 50); Att1.Value = Attributes1; cmd.Parameters.Add(Att1); and so on... What I would like to do is be able to remove a parameter and re-run the SELECT statement if the number of entries retrieved is less than 5 (or any number) I tried just having a new Sql command like this. SqlCommand cmd2 = new SqlCommand("SELECT this from MyTable WHERE Answer1 = @Att 1AND Answer2 = @Att2, connection) and then did this.. cmd2.Parameters.Add(Att1); but it didn't work. Is there a way to do this so I don't have to keep copying the whole parameter command Thank you in advance for your help. And please be gentle, I'm very new to this. Tag: configure sql xml support IIS
  - 15
    - allocation problem/disk space disappears when processing cube I am processing a cube, during processing aggregations, the OLAP Drive free space trickles down, while nothing is being added to the files under the specific cube's data directories. Looks like Analysis Services may be temporarily storing aggregations results into some phantom files Anyone know about this Is it possible to tell how much free disk space this requires I don't like when it fails and doesn't say why... Tag: configure sql xml support IIS
  - 16
    - searching a Unicode data within a Image data type By the way: a lot has changed since SQL-server 2005 and W2k3. The collation to use for Hindi is Indic_General_90_CI_AS. I can't test is for you, since we only use Latin-based collations. Tag: configure sql xml support IIS

nambo

Hope someone can help me...anything would be appreciated. I am using sql server 2000...When I open the Configure sql xml support IIS tool to create a Virtual Directory the only thing that shows up is a computer icon and a IIS Virtual Directory Management for SQL Server. I can't expand ... there isn't a default web site.

The other tool called Enterprise Manager works fine with XP. Matter of fact all of the other tools work except for the Virtual Directory Manager.

Top