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