SSDN - DB to XML data source connection issue with MS-SQL2000

XML Editor

Sign Up

Search

Options

Chat

Help

News

Log in

Not Logged in

Topic

Topic Page 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20

Scott Cable

Subject: 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

Ivan Pedruzzi

Subject: 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

David Pike

Subject: 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?

Ivan Pedruzzi

Subject: 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

David Pike

Subject: 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?!

David Pike

Subject: 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.

Ivan Pedruzzi

Subject: 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

David Pike

Subject: 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

Topic Page 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20

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 to Conference:

Log In Options Username: Password:

Site Map | Privacy Policy | Terms of Use | Trademarks

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.