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

Re: Instance name for SQL 2005

Subject: Re: Instance name for SQL 2005
From: Joe Webb
Date: Wed, 29 Mar 2006 06:19:42 -0600
Newsgroups: microsoft.public.sqlserver.notificationsvcs
If SQLNS is installed in the named instance, and it's with that
instance that you are attempting to create an SQLNS instance, then
you'll need to fully name the SQL Server instance with the
computername\instancename.

Can you post the relevant section of your ICF?



-- 
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 Wed, 29 Mar 2006 11:06:20 +0530, "Gouri" <[email protected]>
wrote:

>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:1143474159[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>