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
Jamie LongstreetSubject: SSPI over local instance for SQL Server
Author: Jamie Longstreet
Date: 30 Jun 2004 11:26 AM
I'm new here. I would like to know if I can connect to my local
instance. The File New (DB to XML Schema) option brings up a
//localhost:1433 login. I tried //local/instancename and
(local)\instancename... without any results. Any suggestions?

Jamie

Postnext
Ivan PedruzziSubject: RE: SSPI over local instance for SQL Server
Author: Ivan Pedruzzi
Date: 30 Jun 2004 12:38 PM

Hi Jamie,

To connect to a named instance using a connection URL, use the following
URL format:

//server_name\\instance_name

NOTE: The first backslash character (\) in \\instance_name is an escape
character.

where:

server_name is the IP address or hostname of the server.
instance_name is the name of the instance to which you want
connect on the server.


Hopes this help
Ivan



> -----Original Message-----
> From: stylus-studio-tech Listmanager
[mailto:stylus-studio-tech.listmanager@stylusstudio.com]
> Sent: Wednesday, June 30, 2004 11:29 AM
> Subject: SSPI over local instance for SQL Server
>
> From: "Jamie Longstreet" <jlongstreet@solsticepoint.com>
>
> I'm new here. I would like to know if I can connect to my local
> instance. The File New (DB to XML Schema) option brings up a
> //localhost:1433 login. I tried //local/instancename and
> (local)\instancename... without any results. Any suggestions?
>
> Jamie
>
>
>
> --
> To reply: mailto:stylus-studio-tech.7631@stylusstudio.com
> To start a new topic: mailto:stylus-studio-tech@stylusstudio.com
> To login: http://www.stylusstudio.com/SSDN/
> To (un)subscribe:
mailto:stylus-studio-tech.list-request@stylusstudio.com
>

Posttop
David  PikeSubject: RE: SSPI over local instance for SQL Server
Author: David Pike
Date: 07 Jan 2005 10:39 AM
This looked like it might be an answer to the question I posed on a different SQL Server connection issue.

But it doesn't work either. The message is that the instance is either invalid or not running, either of which is true.

The instance running is Dell_8400\ASPNET

According to the above post, this should work, shouldn't it?

//Dell_8400\\ASPNET

What is wrong?

 
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.