Multiple instance name

Hi,
Is there a way to make the default instance (SQL 2005) work at the same time as a "named instance" ou make a "named instance" work
with two or more names?
My problem is that I'm using the QuickStart for VS 2005 and all code work with a "SQLExpress" named instance and I just have a
default instance o SQL Server Developer 2005 (and I would not install another instance just for that).
Thanks,
MaxYes, but you have to do this on the client. Use the SQL Server Configuration Manager to add an alias
for the desired server\instance with whatever server\instance name you like.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Max André Bündchen" <nospam@.microsoft.com> wrote in message
news:%238KccV9MGHA.3164@.TK2MSFTNGP11.phx.gbl...
> Hi,
> Is there a way to make the default instance (SQL 2005) work at the same time as a "named instance"
> ou make a "named instance" work with two or more names?
> My problem is that I'm using the QuickStart for VS 2005 and all code work with a "SQLExpress"
> named instance and I just have a default instance o SQL Server Developer 2005 (and I would not
> install another instance just for that).
> Thanks,
> Max
>|||I try it but when I try a connect with the alias name the server I receive: "this failure may be caused by the fact that under the
default settings SQL Server does not allow remote connections".
My alias is like that:
Name: mycomputer\SQLExpress
Port: <blank>
Protocol: TCP/IPa
Server: mycomputer
The default SQL Server is running under Network Service account.
Thanks,
Max
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> escreveu na mensagem
news:uHHdea9MGHA.2764@.TK2MSFTNGP10.phx.gbl...
> Yes, but you have to do this on the client. Use the SQL Server Configuration Manager to add an alias for the desired
> server\instance with whatever server\instance name you like.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "Max André Bündchen" <nospam@.microsoft.com> wrote in message news:%238KccV9MGHA.3164@.TK2MSFTNGP11.phx.gbl...
>> Hi,
>> Is there a way to make the default instance (SQL 2005) work at the same time as a "named instance" ou make a "named instance"
>> work with two or more names?
>> My problem is that I'm using the QuickStart for VS 2005 and all code work with a "SQLExpress" named instance and I just have a
>> default instance o SQL Server Developer 2005 (and I would not install another instance just for that).
>> Thanks,
>> Max
>|||As the message says, the default settings for SQL 2005 do not allow remote
connections. This has nothing to do with name resolution. You need to
enable remote connections using the Surface Area Configuration tool. Unlike
SQL 2000, SQL 2005 (all editions) does not allow remote connections
immediately following the installation. This is so you can patch a SQL
Server before exposing it to network connections, should such future
patching be necessary.
--
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Max André Bündchen" <nospam@.microsoft.com> wrote in message
news:uib%23tp9MGHA.3064@.TK2MSFTNGP10.phx.gbl...
>I try it but when I try a connect with the alias name the server I receive:
>"this failure may be caused by the fact that under the default settings SQL
>Server does not allow remote connections".
> My alias is like that:
> Name: mycomputer\SQLExpress
> Port: <blank>
> Protocol: TCP/IPa
> Server: mycomputer
> The default SQL Server is running under Network Service account.
> Thanks,
> Max
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com>
> escreveu na mensagem news:uHHdea9MGHA.2764@.TK2MSFTNGP10.phx.gbl...
>> Yes, but you have to do this on the client. Use the SQL Server
>> Configuration Manager to add an alias for the desired server\instance
>> with whatever server\instance name you like.
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>> Blog: http://solidqualitylearning.com/blogs/tibor/
>>
>> "Max André Bündchen" <nospam@.microsoft.com> wrote in message
>> news:%238KccV9MGHA.3164@.TK2MSFTNGP11.phx.gbl...
>> Hi,
>> Is there a way to make the default instance (SQL 2005) work at the same
>> time as a "named instance" ou make a "named instance" work with two or
>> more names?
>> My problem is that I'm using the QuickStart for VS 2005 and all code
>> work with a "SQLExpress" named instance and I just have a default
>> instance o SQL Server Developer 2005 (and I would not install another
>> instance just for that).
>> Thanks,
>> Max
>>
>|||Yes, I see. Thanks for the tips!
"Geoff N. Hiten" <SQLCraftsman@.gmail.com> escreveu na mensagem news:O5bday9MGHA.1180@.TK2MSFTNGP09.phx.gbl...
> As the message says, the default settings for SQL 2005 do not allow remote connections. This has nothing to do with name
> resolution. You need to enable remote connections using the Surface Area Configuration tool. Unlike SQL 2000, SQL 2005 (all
> editions) does not allow remote connections immediately following the installation. This is so you can patch a SQL Server before
> exposing it to network connections, should such future patching be necessary.
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
>
>
> "Max André Bündchen" <nospam@.microsoft.com> wrote in message news:uib%23tp9MGHA.3064@.TK2MSFTNGP10.phx.gbl...
>>I try it but when I try a connect with the alias name the server I receive: "this failure may be caused by the fact that under the
>>default settings SQL Server does not allow remote connections".
>> My alias is like that:
>> Name: mycomputer\SQLExpress
>> Port: <blank>
>> Protocol: TCP/IPa
>> Server: mycomputer
>> The default SQL Server is running under Network Service account.
>> Thanks,
>> Max
>> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> escreveu na mensagem
>> news:uHHdea9MGHA.2764@.TK2MSFTNGP10.phx.gbl...
>> Yes, but you have to do this on the client. Use the SQL Server Configuration Manager to add an alias for the desired
>> server\instance with whatever server\instance name you like.
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>> Blog: http://solidqualitylearning.com/blogs/tibor/
>>
>> "Max André Bündchen" <nospam@.microsoft.com> wrote in message news:%238KccV9MGHA.3164@.TK2MSFTNGP11.phx.gbl...
>> Hi,
>> Is there a way to make the default instance (SQL 2005) work at the same time as a "named instance" ou make a "named instance"
>> work with two or more names?
>> My problem is that I'm using the QuickStart for VS 2005 and all code work with a "SQLExpress" named instance and I just have a
>> default instance o SQL Server Developer 2005 (and I would not install another instance just for that).
>> Thanks,
>> Max
>>
>>
>