|
|
|
date: Sat, 25 Mar 2006 16:37:52 +0530,
group: microsoft.public.sqlserver.notificationsvcs
back
Re: Instance name for SQL 2005
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"
wrote:
>Hi,
>
>One instance is without (\) in it where the code runs properly, but another
>machine with instance name having (\), error occurs
>
>GS
>"CoreyB" wrote in message
>news:1143474159.261833.141420@e56g2000cwe.googlegroups.com...
>> 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" wrote in message
>>> news:1143292757.951417.267230@i39g2000cwa.googlegroups.com...
>>> > Are you using nscontrol or Management Studio? Can you post your
>>> > syntax, if using nscontrol?
>>> >
>>
>
date: Tue, 28 Mar 2006 06:22:04 -0600
author: Joe Webb
Re: Instance name for SQL 2005
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" wrote in message
news:o4ai225j6n33lolaiqafsta1b1hhfli5na@4ax.com...
> 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"
> wrote:
>
>>Hi,
>>
>>One instance is without (\) in it where the code runs properly, but
>>another
>>machine with instance name having (\), error occurs
>>
>>GS
>>"CoreyB" wrote in message
>>news:1143474159.261833.141420@e56g2000cwe.googlegroups.com...
>>> 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" wrote in message
>>>> news:1143292757.951417.267230@i39g2000cwa.googlegroups.com...
>>>> > Are you using nscontrol or Management Studio? Can you post your
>>>> > syntax, if using nscontrol?
>>>> >
>>>
>>
date: Wed, 29 Mar 2006 11:06:20 +0530
author: Gouri
Re: Instance name for SQL 2005
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"
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" wrote in message
>news:o4ai225j6n33lolaiqafsta1b1hhfli5na@4ax.com...
>> 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"
>> wrote:
>>
>>>Hi,
>>>
>>>One instance is without (\) in it where the code runs properly, but
>>>another
>>>machine with instance name having (\), error occurs
>>>
>>>GS
>>>"CoreyB" wrote in message
>>>news:1143474159.261833.141420@e56g2000cwe.googlegroups.com...
>>>> 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" wrote in message
>>>>> news:1143292757.951417.267230@i39g2000cwa.googlegroups.com...
>>>>> > Are you using nscontrol or Management Studio? Can you post your
>>>>> > syntax, if using nscontrol?
>>>>> >
>>>>
>>>
>
date: Wed, 29 Mar 2006 06:19:42 -0600
author: Joe Webb
|
|
