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
Show tree view Topic
Topic Page 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 Go to previous topicPrev TopicGo to next topicNext Topic
Postnext
alex gomezSubject: relational database
Author: alex gomez
Date: 11 Jan 2007 11:27 AM
hello, i would like to connect to a ms sql server database that locally.
i don't know how to access it? on the tutorial video i see
//localhost:1433

this does not work for me. i entered my username and password, i just don't understand the connectivity.
any help will be great, thank you.

Postnext
Ivan PedruzziSubject: relational database
Author: Ivan Pedruzzi
Date: 11 Jan 2007 02:21 PM
Alex,

In order to connect to SQLServer you need to enable mixed Mode authentication and have the TCP-IP protocol enabled.

Hope this helps
Ivan Pedruzzi
Stylus Studio Team

Postnext
alex gomezSubject: relational database
Author: alex gomez
Date: 11 Jan 2007 04:13 PM
how do i enable this? is this done in style studio, o ms sql server?

thank you much.

Postnext
Ivan PedruzziSubject: relational database
Author: Ivan Pedruzzi
Date: 11 Jan 2007 04:23 PM

Alex,

You have check your your SQLServer configuration.

More details here
http://www.stylusstudio.com/SSDN/default.asp?action=9&fid=23&read=2893

Ivan

Postnext
alex gomezSubject: relational database
Author: alex gomez
Date: 11 Jan 2007 05:01 PM
Ivan, thank you for answering my question so quickly. I truly appreciated.
I felt lost and without a clue on this issue until you shared some light with me.

I followed the link you sent..Click TCP/IP over into the right-hand box, click Apply and then restart your instance/machine.

Two more things..how do i enable mix mode, and how do i know which port to use? can I leave the default port?

Once again, thank you..

Alex.

Postnext
Ivan PedruzziSubject: relational database
Author: Ivan Pedruzzi
Date: 11 Jan 2007 05:21 PM

The default TCP-IP port is fine.

To verify that the server is running type the following command at DOS prompt, you have to have ms-sql-s on listening status

C:\>netstat -a -p TCP

Active Connections

Proto Local Address Foreign Address State
TCP IVAN:epmap IVAN:0 LISTENING
TCP IVAN:microsoft-ds IVAN:0 LISTENING
TCP IVAN:ms-sql-s IVAN:0 LISTENING
TCP IVAN:ms-sql-m IVAN:0 LISTENING
...

See the attached screenshot for SQLServer 2000 and 2005 for mixed authentication


Ivan Pedruzzi
Stylus Studio Team

Posttop
alex gomezSubject: relational database
Author: alex gomez
Date: 12 Jan 2007 05:33 PM
in my case the sql shows as established.

 
Topic Page 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 Go to previous topicPrev TopicGo to next topicNext Topic
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.