August 2, 2009 at 11:40 pm
Hello SQL Experts
Could you please explain the below scenarios..if this is possible...?
For the first time when we install SQL Server we will have the default instance, i.e. the computer name will be considered as the SQL Server Name. However after that we can have the number of "named instances" and can provide names per our own interest.
Questions...
(1) Can we change the name of the "deafult instance"?
(2) For the first time installing SQL Server also can we have the named instanes installed to the system instead of having atleast 1 default instance?
(3) How many named instances are supported in the following versions of the SQL Servers?
2000, 2005 and 2008?
Regards
Sourav
Thanks.
August 3, 2009 at 12:17 am
Sourav (8/2/2009)
Hello SQL ExpertsCould you please explain the below scenarios..if this is possible...?
For the first time when we install SQL Server we will have the default instance, i.e. the computer name will be considered as the SQL Server Name. However after that we can have the number of "named instances" and can provide names per our own interest.
Questions...
(1) Can we change the name of the "deafult instance"?
There is no way where you can change the name of the default instance or any other named instances after installation. Default instance name will be MSSQLSERVER. If you want to change the name the only thing you have to do is uninstall and reinstall sql server. Same in all versions of sql server
(2) For the first time installing SQL Server also can we have the named instanes installed to the system instead of having atleast 1 default instance?
Yes you can install directly a named instance without installing default instance. Same in all versions of sql server
(3) How many named instances are supported in the following versions of the SQL Servers?
2000, 2005 and 2008?
SQL Server 2000 supports 16 instances
SQL Server 2005 Enterprise or Developer supports 50
SQL Server 2005 Other Editions supports 16
SQL Server 2008 Enterprise 50
SQL Server 2008 Other Editions supports 16
[font="Verdana"]Thanks
Chandra Mohan[/font]
August 3, 2009 at 12:32 am
Thank you chandra, for your response...
Can you please reemphasis on the point 2::
(2) For the first time installing SQL Server also can we have the named instanes installed to the system instead of having atleast 1 default instance?
Yes you can install directly a named instance without installing default instance. Same in all versions of sql server.
Per my understanding,if we are installing the SQL Server Through the SQLcmd prompts without having the SSMS, then only it can have allow to install the "Named Instance" directly for the first time? Is not that so..? Becoz..the default instance checkbox remains greyed up so not allowing the users to check and provide a name..
Can you please explain how to use the Named instance from the very first instance itself?
Regards
Sourav
Thanks.
August 3, 2009 at 1:16 am
Per my understanding,if we are installing the SQL Server Through the SQLcmd prompts without having the SSMS, then only it can have allow to install the "Named Instance" directly for the first time? Is not that so..? Becoz..the default instance checkbox remains greyed up so not allowing the users to check and provide a name..
Can you please explain how to use the Named instance from the very first instance itself?
Sourav,
It seems you are using wrong terminology. sqlcmd and ssms comes only after installation of sql server. The correct term is command prompt. You can use the following command to install a named instance or default instance
for default instance
Start /wait \servers\setup.exe /qb INSTANCENAME= ADDLOCAL=All PIDKEY= SAPWD= SQLACCOUNT= SQLPASSWORD= AGTACCOUNT= AGTPASSWORD= SQLBROWSERACCOUNT= SQLBROWSERPASSWORD=
for named instance (here iam giving the instancename as sql2k5
Start /wait \servers\setup.exe /qb INSTANCENAME=sql2k5 ADDLOCAL=All PIDKEY= SAPWD= SQLACCOUNT= SQLPASSWORD= AGTACCOUNT= AGTPASSWORD= SQLBROWSERACCOUNT= SQLBROWSERPASSWORD=
you can refer to the link here on How to install sql server from command prompt
http://msdn.microsoft.com/en-us/library/ms144259(SQL.90).aspx
[font="Verdana"]Thanks
Chandra Mohan[/font]
June 28, 2016 at 6:37 am
can we install all 50 instance as named instance without installing the default instance.?
Thanks,
Sunil G.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply