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 wi
th a "SQLExpress" named instance and I just have a
default instance o SQL Server Developer 2005 (and I would not install anothe
r 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 Bndchen" <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 ti
me 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 2
005 (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 Configurati
on 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 Bndchen" <nospam@.microsoft.com> wrote in message news:%238KccV
9MGHA.3164@.TK2MSFTNGP11.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 Bndchen" <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, I see. Thanks for the tips!
"Geoff N. Hiten" <SQLCraftsman@.gmail.com> escreveu na mensagem news:O5bday9MGHA.1180@.TK2MSFT
NGP09.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 inst
allation. This is so you can patch a SQL Server before
> exposing it to network connections, should such future patching be necessa
ry.
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
>
>
> "Max Andr Bndchen" <nospam@.microsoft.com> wrote in message news:uib%23tp
9MGHA.3064@.TK2MSFTNGP10.phx.gbl...
>