SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 Creating Named Instance
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

sgondesi
Posting Yak Master

India
194 Posts

Posted - 11/05/2013 :  05:51:49  Show Profile  Reply with Quote
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 Regards
Srikar Reddy Gondesi,
BTECH-IT 2013 Passed Out,
Trainee for SQL Server Administration,
Miracle Software systems, Inc.

visakh16
Very Important crosS Applying yaK Herder

India
52317 Posts

Posted - 11/05/2013 :  06:03:05  Show Profile  Reply with Quote
nope. If you select only database engine service then named instance will only have database component, no other components like integration services, reporting services etc
You 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 MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs

Edited by - visakh16 on 11/05/2013 06:04:17
Go to Top of Page

sgondesi
Posting Yak Master

India
194 Posts

Posted - 11/05/2013 :  06:15:50  Show Profile  Reply with Quote
[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 etc
You 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 Regards
Srikar Reddy Gondesi,
BTECH-IT 2013 Passed Out,
Trainee for SQL Server Administration,
Miracle Software systems, Inc.
Go to Top of Page

sgondesi
Posting Yak Master

India
194 Posts

Posted - 11/05/2013 :  07:26:29  Show Profile  Reply with Quote
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 etc
You 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 MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs




Kindly please reply for the post as soon as possible.

--
Thanks and Regards
Srikar Reddy Gondesi,
BTECH-IT 2013 Passed Out,
Trainee for SQL Server Administration,
Miracle Software systems, Inc.
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

India
52317 Posts

Posted - 11/05/2013 :  08:14:13  Show Profile  Reply with Quote
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 etc
You 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 Regards
Srikar Reddy Gondesi,
BTECH-IT 2013 Passed Out,
Trainee for SQL Server Administration,
Miracle Software systems, Inc.


Depends on the Edition as well
for example in case of express edition no agent

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs

Edited by - visakh16 on 11/05/2013 08:14:52
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

India
52317 Posts

Posted - 11/05/2013 :  08:18:28  Show Profile  Reply with Quote
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 etc
You 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 MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs




Kindly please reply for the post as soon as possible.

--
Thanks and Regards
Srikar 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 MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
Go to Top of Page

sgondesi
Posting Yak Master

India
194 Posts

Posted - 11/05/2013 :  09:39:02  Show Profile  Reply with Quote
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 etc
You 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 MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs




Kindly please reply for the post as soon as possible.

--
Thanks and Regards
Srikar 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 MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs




I understood what you have said. I will change here after. Thank you.

--
Thanks and Regards
Srikar Reddy Gondesi,
BTECH-IT 2013 Passed Out,
Trainee for SQL Server Administration,
Miracle Software systems, Inc.
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.08 seconds. Powered By: Snitz Forums 2000