I am having problem with \ in the sql server instance name, not is sqlns
instance name. The SQL 2005 instance name is SQLLaunchVPC\SqlDev01 for which
it gives error when I try to create SQLNS instance which does not have \ in
"Joe Webb" <[email protected]> wrote in message
> The backslash character is rather special. It is used to separate an
> machine name from a named instance of SQL Server. For example the
> default instance of SQL Server on a computer called ASPEN can be
> reached by simply using ASPEN. However to connect to an SQL Server
> instance named SS2005 on ASPEN, you'd use the following name
> ASPEN\SS2005. These are SQL Server instances, not SQLNS instances .
> As for SQLNS, the instance name is used as a basis for name many other
> objects in the databases and as such you should refrain from including
> characters in your instance name that are not allowed for naming
> objects in SQLNS. BOL says to keep /, \, [, ], ", and ' out of your
> instance name.
> Joe Webb
> SQL Server MVP
> Get up to speed quickly with SQLNS
> I support PASS, the Professional Association for SQL Server.
> On Tue, 28 Mar 2006 09:57:22 +0530, "Gouri" <[email protected]>
>>One instance is without (\) in it where the code runs properly, but
>>machine with instance name having (\), error occurs
>>"CoreyB" <[email protected]> wrote in message
>>> I'm confused. In your first message, you said that your SQL instance
>>> did have \ in it. Then in your last message you said your instance
>>> does not have a \ in the name.
>>> Gouri wrote:
>>>> I am using Management studio, the code runs on the machine where the
>>>> server instance does not have (\) in its name
>>>> "CoreyB" <[email protected]> wrote in message
>>>> news:[email protected]
>>>> > Are you using nscontrol or Management Studio? Can you post your
>>>> > syntax, if using nscontrol?