Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sgondesi
Posting Yak Master
200 Posts |
 Posted - 2013-11-05 : 05:51:49
|
| Hello everybody,i have a default instance of SQL Server enterprise evaluation edition installed in my laptop. Now i want to create a named instance. Running setup.exe and mentioning the new instance name in the instance configuration is the only way right?If yes, while running the setup.exe for the creation of new instance, if i select only the database engine services in the "Feature selection" step, will my default instance and this newly created instance share all the other features which i selected while installing the default instance?-- Thanks and RegardsSrikar Reddy Gondesi,BTECH-IT 2013 Passed Out,Trainee for SQL Server Administration,Miracle Software systems, Inc. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-11-05 : 06:03:05
|
| nope. If you select only database engine service then named instance will only have database component, no other components like integration services, reporting services etcYou will still be able to connect to both instances using client tools (SSMS, Profiler etc) you installed for the default instance so far as your named instance version is not higher than default instance.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
 |
|
|
sgondesi
Posting Yak Master
200 Posts |
Posted - 2013-11-05 : 06:15:50
|
[quote]Originally posted by visakh16
nope. If you select only database engine service then named instance will only have database component, no other components like integration services, reporting services etcYou will still be able to connect to both instances using client tools (SSMS, Profiler etc) you installed for the default instance so far as your named instance version is not higher than default instance.Sir,so now if i select only database engine services from the "Feature selection" step,there be only two services(SQLServer and SQLServer agent) running in the configuration manager right?-- Thanks and RegardsSrikar Reddy Gondesi,BTECH-IT 2013 Passed Out,Trainee for SQL Server Administration,Miracle Software systems, Inc. |
|
|
|
sgondesi
Posting Yak Master
200 Posts |
Posted - 2013-11-05 : 07:26:29
|
quote:
Originally posted by visakh16
nope. If you select only database engine service then named instance will only have database component, no other components like integration services, reporting services etcYou will still be able to connect to both instances using client tools (SSMS, Profiler etc) you installed for the default instance so far as your named instance version is not higher than default instance.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs
Kindly please reply for the post as soon as possible.-- Thanks and RegardsSrikar Reddy Gondesi,BTECH-IT 2013 Passed Out,Trainee for SQL Server Administration,Miracle Software systems, Inc. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-11-05 : 08:14:13
|
quote:
Originally posted by sgondesi
[quote]Originally posted by visakh16
nope. If you select only database engine service then named instance will only have database component, no other components like integration services, reporting services etcYou will still be able to connect to both instances using client tools (SSMS, Profiler etc) you installed for the default instance so far as your named instance version is not higher than default instance.Sir,so now if i select only database engine services from the "Feature selection" step,there be only two services(SQLServer and SQLServer agent) running in the configuration manager right?-- Thanks and RegardsSrikar Reddy Gondesi,BTECH-IT 2013 Passed Out,Trainee for SQL Server Administration,Miracle Software systems, Inc.
Depends on the Edition as wellfor example in case of express edition no agent------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-11-05 : 08:18:28
|
quote:
Originally posted by sgondesi
quote:
Originally posted by visakh16
nope. If you select only database engine service then named instance will only have database component, no other components like integration services, reporting services etcYou will still be able to connect to both instances using client tools (SSMS, Profiler etc) you installed for the default instance so far as your named instance version is not higher than default instance.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs
Kindly please reply for the post as soon as possible.-- Thanks and RegardsSrikar Reddy Gondesi,BTECH-IT 2013 Passed Out,Trainee for SQL Server Administration,Miracle Software systems, Inc.
You sound as if you're paying us for services provided.Please understand that we're volunteering ourselves for helping others and we also have our daily jobs.If you want dedicated help, you may be better off hiring someone for consulting work. If you're looking at that kind of help, PM me and we can discuss further.Otherwise response depends on how many voluteers are present at that time checking forums.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
|
|
|
sgondesi
Posting Yak Master
200 Posts |
Posted - 2013-11-05 : 09:39:02
|
quote:
Originally posted by visakh16
quote:
Originally posted by sgondesi
quote:
Originally posted by visakh16
nope. If you select only database engine service then named instance will only have database component, no other components like integration services, reporting services etcYou will still be able to connect to both instances using client tools (SSMS, Profiler etc) you installed for the default instance so far as your named instance version is not higher than default instance.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs
Kindly please reply for the post as soon as possible.-- Thanks and RegardsSrikar Reddy Gondesi,BTECH-IT 2013 Passed Out,Trainee for SQL Server Administration,Miracle Software systems, Inc.
You sound as if you're paying us for services provided.Please understand that we're volunteering ourselves for helping others and we also have our daily jobs.If you want dedicated help, you may be better off hiring someone for consulting work. If you're looking at that kind of help, PM me and we can discuss further.Otherwise response depends on how many voluteers are present at that time checking forums.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs
I understood what you have said. I will change here after. Thank you.-- Thanks and RegardsSrikar Reddy Gondesi,BTECH-IT 2013 Passed Out,Trainee for SQL Server Administration,Miracle Software systems, Inc. |
|
|
|
|
|
|
|
|
Creating Named Instance