How to create a new instance in SQL 2005 Server Standard?
in [Server Configuration]
|
From: AllenM on 13 Oct 2009 12:20 I have an SBS 2008 Premium Server running SQL 2005 Standard. This was installed with the OS to accomodate the SBS Monitoring features. I want install another instance so I can create other databases within that new instance. I do not want the new databases running in the default operating system instances. Any input and information is very much appreciated. Thanks in advance.
From: TheSQLGuru on 13 Oct 2009 12:52 Question 1) why don't you want the new databases running in default instance? If you want a new instance of SQL Server, you need to install it. Since you are asking this question I take it you have little to no experience with sql server. may I recommend you get a professional to help you with this, and perhaps give your current system a review? Lots of things could be bad/suboptimal and you not even know it. -- Kevin G. Boles Indicium Resources, Inc. SQL Server MVP kgboles a earthlink dt net "AllenM" <NoReply(a)NoEmail.com> wrote in message news:ee8nfECTKHA.4364(a)TK2MSFTNGP04.phx.gbl... >I have an SBS 2008 Premium Server running SQL 2005 Standard. This was >installed with the OS to accomodate the SBS Monitoring features. I want >install another instance so I can create other databases within that new >instance. I do not want the new databases running in the default operating >system instances. Any input and information is very much appreciated. >Thanks in advance. >
From: AllenM on 13 Oct 2009 13:20 You are correct I have limited SQL knowledge and experience. Let me give you a summary of what led me to this and what I'm trying to accomplish. I have an SBS 2008 Premium Server that is running SQL 2005 Standard that was installed to accomodate the SBS components that need SQL. The defualt instance installed was SBSMONITORING. So I want to install Outlook Business Contact Manager. This can be done using SQL 2005 Express. In fact I did have this installed and running on a different Windows 2008 Standard Server. So now the boss wants this Windows 2008 Server to use SQL 2008 Standard only to accomodate SharePoint 2007 Server. So now I can no longer use this Windows 2008 Server to create my BCM SQL database as BCM is not supported in SQL 2008. So my reasoning for wanting to create a new instance in SQL 2005 Standard on my SBS 2008 server is that I don't want the database to reside in the default instance SBSMONITORING. Now wheter or not my reasoning is legitimate and or doable or there is no problem with having the SharePoint DB installed in the default instance I am not sure. That's why I am asking hoping to get an expert and experienced opinion. "TheSQLGuru" <kgboles(a)earthlink.net> wrote in message news:_9mdnS8tCdcEMknXnZ2dnUVZ_gydnZ2d(a)earthlink.com... > Question 1) why don't you want the new databases running in default > instance? > > If you want a new instance of SQL Server, you need to install it. > > Since you are asking this question I take it you have little to no > experience with sql server. may I recommend you get a professional to > help you with this, and perhaps give your current system a review? Lots > of things could be bad/suboptimal and you not even know it. > > -- > Kevin G. Boles > Indicium Resources, Inc. > SQL Server MVP > kgboles a earthlink dt net > > > "AllenM" <NoReply(a)NoEmail.com> wrote in message > news:ee8nfECTKHA.4364(a)TK2MSFTNGP04.phx.gbl... >>I have an SBS 2008 Premium Server running SQL 2005 Standard. This was >>installed with the OS to accomodate the SBS Monitoring features. I want >>install another instance so I can create other databases within that new >>instance. I do not want the new databases running in the default operating >>system instances. Any input and information is very much appreciated. >>Thanks in advance. >> > >
From: TheSQLGuru on 13 Oct 2009 21:43 I don't know of a reason you cannot have non sharepoint databases with that instance, although i am not a sharepoint guru - just a sql server one. I do know clients that have sharepoint and other stuff on same sql instance. If you do want another instance, just go through the installation routine to install it. Use the read me for guidance. -- Kevin G. Boles Indicium Resources, Inc. SQL Server MVP kgboles a earthlink dt net "AllenM" <NoReply(a)NoEmail.com> wrote in message news:O1E6EmCTKHA.4364(a)TK2MSFTNGP04.phx.gbl... > You are correct I have limited SQL knowledge and experience. Let me give > you a summary of what led me to this and what I'm trying to accomplish. > I have an SBS 2008 Premium Server that is running SQL 2005 Standard that > was installed to accomodate the SBS components that need SQL. The defualt > instance installed was SBSMONITORING. > So I want to install Outlook Business Contact Manager. This can be done > using SQL 2005 Express. In fact I did have this installed and running on a > different Windows 2008 Standard Server. So now the boss wants this Windows > 2008 Server to use SQL 2008 Standard only to accomodate SharePoint 2007 > Server. So now I can no longer use this Windows 2008 Server to create my > BCM SQL database as BCM is not supported in SQL 2008. > So my reasoning for wanting to create a new instance in SQL 2005 Standard > on my SBS 2008 server is that I don't want the database to reside in the > default instance SBSMONITORING. Now wheter or not my reasoning is > legitimate and or doable or there is no problem with having the SharePoint > DB installed in the default instance I am not sure. That's why I am asking > hoping to get an expert and experienced opinion. > > > "TheSQLGuru" <kgboles(a)earthlink.net> wrote in message > news:_9mdnS8tCdcEMknXnZ2dnUVZ_gydnZ2d(a)earthlink.com... >> Question 1) why don't you want the new databases running in default >> instance? >> >> If you want a new instance of SQL Server, you need to install it. >> >> Since you are asking this question I take it you have little to no >> experience with sql server. may I recommend you get a professional to >> help you with this, and perhaps give your current system a review? Lots >> of things could be bad/suboptimal and you not even know it. >> >> -- >> Kevin G. Boles >> Indicium Resources, Inc. >> SQL Server MVP >> kgboles a earthlink dt net >> >> >> "AllenM" <NoReply(a)NoEmail.com> wrote in message >> news:ee8nfECTKHA.4364(a)TK2MSFTNGP04.phx.gbl... >>>I have an SBS 2008 Premium Server running SQL 2005 Standard. This was >>>installed with the OS to accomodate the SBS Monitoring features. I want >>>install another instance so I can create other databases within that new >>>instance. I do not want the new databases running in the default >>>operating system instances. Any input and information is very much >>>appreciated. Thanks in advance. >>> >> >> > >
From: AllenM on 14 Oct 2009 11:33 Thanks Kevin for the input. I know I can run setup again to create a new instance. My only concern was not overwriting or losing the current default instance (SBSMONITORING). "TheSQLGuru" <kgboles(a)earthlink.net> wrote in message news:CbGdncVtDNafsUjXnZ2dnUVZ_vadnZ2d(a)earthlink.com... >I don't know of a reason you cannot have non sharepoint databases with that >instance, although i am not a sharepoint guru - just a sql server one. I >do know clients that have sharepoint and other stuff on same sql instance. > > If you do want another instance, just go through the installation routine > to install it. Use the read me for guidance. > > > -- > Kevin G. Boles > Indicium Resources, Inc. > SQL Server MVP > kgboles a earthlink dt net > > > "AllenM" <NoReply(a)NoEmail.com> wrote in message > news:O1E6EmCTKHA.4364(a)TK2MSFTNGP04.phx.gbl... >> You are correct I have limited SQL knowledge and experience. Let me give >> you a summary of what led me to this and what I'm trying to accomplish. >> I have an SBS 2008 Premium Server that is running SQL 2005 Standard that >> was installed to accomodate the SBS components that need SQL. The defualt >> instance installed was SBSMONITORING. >> So I want to install Outlook Business Contact Manager. This can be done >> using SQL 2005 Express. In fact I did have this installed and running on >> a different Windows 2008 Standard Server. So now the boss wants this >> Windows 2008 Server to use SQL 2008 Standard only to accomodate >> SharePoint 2007 Server. So now I can no longer use this Windows 2008 >> Server to create my BCM SQL database as BCM is not supported in SQL 2008. >> So my reasoning for wanting to create a new instance in SQL 2005 Standard >> on my SBS 2008 server is that I don't want the database to reside in the >> default instance SBSMONITORING. Now wheter or not my reasoning is >> legitimate and or doable or there is no problem with having the >> SharePoint DB installed in the default instance I am not sure. That's why >> I am asking hoping to get an expert and experienced opinion. >> >> >> "TheSQLGuru" <kgboles(a)earthlink.net> wrote in message >> news:_9mdnS8tCdcEMknXnZ2dnUVZ_gydnZ2d(a)earthlink.com... >>> Question 1) why don't you want the new databases running in default >>> instance? >>> >>> If you want a new instance of SQL Server, you need to install it. >>> >>> Since you are asking this question I take it you have little to no >>> experience with sql server. may I recommend you get a professional to >>> help you with this, and perhaps give your current system a review? Lots >>> of things could be bad/suboptimal and you not even know it. >>> >>> -- >>> Kevin G. Boles >>> Indicium Resources, Inc. >>> SQL Server MVP >>> kgboles a earthlink dt net >>> >>> >>> "AllenM" <NoReply(a)NoEmail.com> wrote in message >>> news:ee8nfECTKHA.4364(a)TK2MSFTNGP04.phx.gbl... >>>>I have an SBS 2008 Premium Server running SQL 2005 Standard. This was >>>>installed with the OS to accomodate the SBS Monitoring features. I want >>>>install another instance so I can create other databases within that new >>>>instance. I do not want the new databases running in the default >>>>operating system instances. Any input and information is very much >>>>appreciated. Thanks in advance. >>>> >>> >>> >> >> > >
|
Next
|
Last
Pages: 1 2 Prev: Prepared query - plan cache Next: SQL SERVER 2000 domain changes for users. |