microsoft.public.sqlserver.notificationsvcs
[Top] [All Lists]

Re: Instance name for SQL 2005

Subject: Re: Instance name for SQL 2005
From: "Gouri"
Date: Wed, 29 Mar 2006 11:06:20 +0530
Newsgroups: microsoft.public.sqlserver.notificationsvcs
Hi,

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 
its name.

GS


"Joe Webb" <[email protected]> wrote in message 
news:[email protected]
> 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.
>
> HTH...
>
>
>
>
> -- 
> Joe Webb
> SQL Server MVP
> http://www.sqlns.com
>
>
> ~~~
> Get up to speed quickly with SQLNS
> http://www.amazon.com/exec/obidos/tg/detail/-/0972688811
>
> I support PASS, the Professional Association for SQL Server.
> (www.sqlpass.org)
>
>
>
>
> On Tue, 28 Mar 2006 09:57:22 +0530, "Gouri" <[email protected]>
> wrote:
>
>>Hi,
>>
>>One instance is without (\) in it where the code runs properly, but 
>>another
>>machine with instance name having (\), error occurs
>>
>>GS
>>"CoreyB" <[email protected]> wrote in message
>>news:[email protected]
>>> 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:
>>>> Hi
>>>>
>>>> I am using Management studio, the code runs on the machine where the 
>>>> sql
>>>> server instance does not have (\) in its name
>>>>
>>>> GS
>>>> "CoreyB" <[email protected]> wrote in message
>>>> news:[email protected]
>>>> > Are you using nscontrol or Management Studio?  Can you post your
>>>> > syntax, if using nscontrol?
>>>> >
>>>
>> 



<Prev in Thread] Current Thread [Next in Thread>