XML Editor
Sign up for a WebBoard account Sign Up Keyword Search Search More Options... Options
search
Chat Rooms Chat Help Help News News Log in to WebBoard Log in Not Logged in
Home » Boards » Stylus Studio Developer Network » Stylus Studio Technical Forum » DB to XML data source connection issue with MS-SQL2000
Conferences Close Tree View
+ Stylus Studio Feature Requests (1192)
- Stylus Studio Technical Forum (14621)
-> + External Cascading Style Sheet... (2)
-> + Need help with XML mapping - P... (2)
-> + Convert image to base64 in xsl... (2)
-> + Automation (2)
-> - Changing Default Property valu... (1)
-> + Help in reading cdata using xs... (4)
-> + Ok, I can programatically conv... (2)
-> + How do I prevent the previewer... (2)
-> + Can I programatically convert ... (2)
-> + XML To Flat File - Reverse Eng... (3)
-> + Check for valid attribute valu... (3)
-> + Java.lang.OutOfMemory - when I... (3)
-> + How to convert text in EBCDIC ... (8)
-> + First steps in XSLT mapping (4)
-> + Option to build XSL-FO is not ... (3)
-> + using Adaptor convert XML to e... (2)
-> + Using XML Converter on a Compl... (2)
-> + Java built-in processor needed... (3)
-> + XSL to draw a table (2)
-> - Stylus Studio in c# solutions (1)
-> + entities within schemaLocation... (4)
-> + java runtime error during xslt... (2)
-> + Conversion of XML Doc for RSS ... (2)
-> + Does anyone know how to upgrad... (2)
-> + XML editor corrupts my file (5)
-> + Stylus Studio & Berkeley DB XM... (4)
-> + XSLT for page breakout (2)
-> + How to avoid creating empty el... (2)
-> + Error in converting 945 EDI us... (4)
-> + XML to X12 (invoice 810 edi) (2)
-> - Stylus Studio 2009 Enterprise ... (1)
-> + Stylus Studio 2007 - license d... (2)
-> + XML to X12 conversion error (6)
-> + How to reset JVM (to another j... (2)
-> + How to generate XML sample dat... (2)
-> + Document Path reference after ... (4)
-> + concatenate with xquery (6)
-> + i want to capture the xml tag ... (3)
-> + "View Sample XML" in schema an... (2)
-> + Can't get to Toolbar settings ... (2)
-> + SOAPException (3)
-> + how to patch xml files with wr... (2)
-> + wysiwug xslt editor (2)
-> + XML to Google Charts (10)
-> + XML to HL7 (2)
-> - Outputting this XML (1)
-> + Interpreting XSD Error Message... (2)
-> + converter EDI --> typ = no (8)
-> + License issue (7)
-> + One of the simplest questions ... (3)
-> + xQuery transformation encounte... (2)
-> + Schema Evolution (2)
-> + Preview in Browser button gray... (4)
-> + converter:EDI:val=no AND chr=.... (4)
-> + [XQuery][DB2 JDBC Driver]Unsu... (2)
-> + Need Help Create XML file thro... (4)
-> + Flat file to XML conversion in... (5)
-> + How to set delimiters if it's ... (4)
-> + XSD Validation failing (4)
-> + XSD Validation failing (2)
-> + Web Service Call cannot retrie... (7)
-> + Flat file conversion to XML (2)
-> + Stylus Studio crash (5)
-> + Stylus Studio No Longer loads (2)
-> + How do I print in color? (2)
-> + Integrating Documentum WebPubl... (2)
-> + Stylus Studio crashes on openi... (4)
-> + Change format of XML output fo... (3)
-> + XSLT mapper / Source file not ... (7)
-> + Stylus Studio crashes on start... (3)
-> + Loading GML3.1 (3)
-> + NullPointerException when runn... (5)
-> + Can not open Stylus Studio (3)
-> + macros for custom validation e... (6)
-> + Does Stylus Studio generate XM... (4)
-> + another csv conversion (7)
-> + ADD CVS to Source Control drop... (2)
-> + Automate xquery (6)
-> + Correcting multiple XML docume... (2)
-> + Unable to locate Components\Da... (5)
-> + Runtime Error, Struzzo.exe, Ab... (11)
-> + Convert XML to EDIfact (3)
-> + I don't have the Mapper tab (6)
-> + CSV conversion with null field (3)
-> + Converting a Complex Flat File... (2)
-> - installion in batch mode (1)
-> + Complete Custom Validation Lis... (2)
-> + creating xml from csv flat fil... (9)
-> - need Help Regarding XBRL (1)
-> + Exception FODC0004: file or di... (2)
-> + Activation (2)
-> + java runtime error (2)
-> + connection problem with AS 400... (4)
-> + XML to 837I EDI -- multiple NM... (3)
-> + WYSIWYG in SSv7 (2)
-> - Write into < head /> tags us... (1)
-> + Maximum recursion depth exceed... (2)
-> - Code coverage testing (1)
-> - Passing JavaScript with multip... (1)
-> + preserving white space in XML ... (8)
-- Previous [721-740] [741-760] [761-780] Next
+ Website Feedback (249)
+ XSLT Help and Discussion (7625)
+ XQuery Help and Discussion (2016)
+ Stylus Studio FAQs (159)
+ Stylus Studio Code Samples & Utilities (364)
+ Stylus Studio Announcements (113)
Topic  
Postnext
Scott CableSubject: DB to XML data source connection issue with MS-SQL2000
Author: Scott Cable
Date: 09 Sep 2004 02:31 AM
When I try to create a DB to XML data source I get the following error.

java.sql.SQLException:[StylusStudio][SQL Server JDBC Driver][SQLServer]
Login failed for user 'domain\username'. Reason: Not associated with a
trusted SQL Server connection.

1) I am logged in on a WindowsXP machine under the 'domain\username'
account.
2) This account has admin privileges on the (local) SQL server I'm
wnat to access.
3) The SQL Server is setup for Windows only security (changing to
mixed mode security is not an option).

My connection settings are :

Database type = Microsoft SQL Server
Server URL = //localhost:1433
Username = 'domain\username'
Password = domain account password

I usually see this sort of error when an ASP.net app tries to connect
to a SQL database but the application doesn't use impersonation or the
aspnet_wp process has no access rights on the database.

Does java run as a built-in account which needs db permissons or should
it be impersonating the logged on user ?

Thanks
Scott Cable
Postnext
Ivan PedruzziSubject: DB to XML data source connection issue with MS-SQL2000
Author: Ivan Pedruzzi
Date: 09 Sep 2004 01:53 PM
Hi Scott

Unfortunately Stylus doesn't support Windows authentication as you described.

Windows authentication is supported via Active Directory using Kerberos protocol.
You can find a description for how to configure the server here

http://media.datadirect.com/download/docs/jdbc/jdbcig/wininst.html#wp1114647

Ivan

Postnext
David PikeSubject: DB to XML data source connection issue with MS-SQL2000
Author: David Pike
Date: 07 Jan 2005 10:29 AM
I do not understand this issue. I have MSDE with mixed mode authentication, so I have the standard SA plus my own password.

My MSDE Server is this:
Dell_8400\ASPNET

What does it take to get a connection? (I get a wide variety of non-connect messages.)

If I use MS Web Data Administrator and log-in as Cassini Personal WebServer and use SQL log-in (SA plus password), that same screen gives me a port number, and this gets me into the SQL database on the Webadministration page. So it works.

But what would be proper syntax / entry under URL Builder for opening a rel. DB?

Here are examples of what don't work:

//Dell_8400\ASPNET:111;DataBaseName=pubs
//local\ASPNET:111;DataBaseName=pubs
//local:111
//local:111;DatabaseName=pubs

And every other possible variation of this.

What do I need to get a connection?
Postnext
Ivan PedruzziSubject: DB to XML data source connection issue with MS-SQL2000
Author: Ivan Pedruzzi
Date: 07 Jan 2005 12:10 PM
Hi David

Which Stylus Studio build are you running (Help->About)?

The sytax for the server URL to referecence a SQLServer local instance is the following

//Dell_8400\ASPNET:111

You should use the URL builder to create the URL.

I just tried on my machine with SQLServer 2k it seems to work fine

Hope this helps
Ivan
Postnext
David PikeSubject: DB to XML data source connection issue with MS-SQL2000
Author: David Pike
Date: 07 Jan 2005 12:20 PM
Hello, Ivan, no, this setting does not work either. Could it possible having something to do with the fact that I'm using MSDE, and not a full-fledged SQL? I doubt it, but I'm a novice in these things.

I am using an evaluation version of Build 6.0, 212i

Let me flatter you. Altove XML Spy through me totally for loop. Having just started experimenting with Stylus, I am very impressed. Even more impressed by your almost instant response to my question.

But where's the problem in getting this connection?!
Postnext
David PikeSubject: DB to XML data source connection issue with MS-SQL2000
Author: David Pike
Date: 07 Jan 2005 12:21 PM
Here's the error message.

java.sql.SQLException: [StylusStudio][SQLServer JDBC Driver][StylusStudio][SQLServer JDBC Driver]The requested instance is either invalid or not running.
Postnext
Ivan PedruzziSubject: DB to XML data source connection issue with MS-SQL2000
Author: Ivan Pedruzzi
Date: 07 Jan 2005 01:28 PM
Originally Posted: 07 Jan 2005 01:26 PM
Thanks, Is your SQLServer configure to enable the TCP-IP protocol? In MSDE 2000 TCP/IP is not enabled by default. To enable TCP/IP uses the "SVRNETCN" command. Run SVRNETCN (Start/Run/SVRNETCN). This pops up a basic dialog which immediately tells you that SQL isn't connected with any protocol. Click TCP/IP over into the right-hand box, click Apply and then restart your instance/machine. The default TCP-IP port is 1433, but you can change it. You have to use the same port in the server URL. Ivan
Posttop
David PikeSubject: DB to XML data source connection issue with MS-SQL2000
Author: David Pike
Date: 07 Jan 2005 02:45 PM
Ivan, that finally did it, but curiously, I happened to try it on a different instance of MSDE.

It seems still not to want to work on the Dell_8400\ASPNET instance, which I installed with a slightly newer version of MSDE.

I don't know why this connection won't work, as it opens elsewhere.... But the problem must be at my end.

In any case, your help - quick and efficient - was much appreciated. If this is any indication of the professionalism of your company (the program itself makes a first-class impression), then you've achieved something not very many software vendors achieve.

You made a quick sale. I will purchase Stylus Studio for download over the weekend.

Best regards,

Professor David Pike
Univ. of North Carolina at Chapel Hill
   
Download A Free Trial of Stylus Studio 6 XML Professional Edition Today! Powered by Stylus Studio, the world's leading XML IDE for XML, XSLT, XQuery, XML Schema, DTD, XPath, WSDL, XHTML, SQL/XML, and XML Mapping!  
go

Log In Options

Site Map | Privacy Policy | Terms of Use | Trademarks
Stylus Scoop XML Newsletter:
W3C Member
Stylus Studio® and DataDirect XQuery ™are from DataDirect Technologies, is a registered trademark of Progress Software Corporation, in the U.S. and other countries. © 2004-2016 All Rights Reserved.