XML Editor
Sign up for a WebBoard account Sign Up Keyword Search Search More Options... Options
Chat Rooms Chat Help Help News News Log in to WebBoard Log in Not Logged in
Conferences Close Tree View
+ Stylus Studio Feature Requests (1175)
- Stylus Studio Technical Forum (14546)
-> + Splitting EDIFACT files pipeli... (3)
-> + Problem with SAXO processor - ... (5)
-> + PDF Format Help (4)
-> + License check unreliable (2)
-> - XML related issue (1)
-> + Need help regarding pipeline o... (2)
-> + Error converting XML to EDIFAC... (4)
-> + XSLT Profiling for XSLT 1.0 s... (2)
-> + Grouping (2)
-> - Best Toner for Sensitive Skin (1)
-> + Best Practice for Pipeline err... (2)
-> + pdf generation (4)
-> + Problems excuting a Pipeline w... (2)
-> + XML serializer (3)
-> + Supported EDIFACT versions (5)
-> - Anyone know XActimate ESX file... (1)
-> + Stylus Studio with OpenJDK (2)
-> - Encoding error when importing ... (1)
-> - SEO Service in Delhi, India (1)
-> - HP Printer Support (1)
-- [1-20] [21-40] [41-60] Next
+ Website Feedback (247)
+ XSLT Help and Discussion (7621)
+ XQuery Help and Discussion (1946)
+ 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.