Prev: Prepared query - plan cache
Next: SQL SERVER 2000 domain changes for users.
From: AllenM on 14 Oct 2009 18:37
Hi Kevin,
Hopefully you are still watching this post. I got one more stupid question
for you if you don't mind. How do I know if I am running SQL 2005 Standard
or SQL 2005 Express? Or can it even just be the Workroup version.
On my SBS 2008 Server by defualt it is running WSS 3.0 for my comapnyweb. I
know I never installed any versions of SQL but do know that it probably
installed the embedded native version.
When I look in Programs Features I see this......

Microsoft SQL Server Managment Studio Express
Microsoft SQL Server Native Client
Microsoft SQL Server Setup Support Files (English)
Microsoft SQL Server VSS Writer

Can you tell me what version and or edition of SQL I am running? Thanks.




"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.
>>>>
>>>
>>>
>>
>>
>
>


From: TheSQLGuru on 22 Oct 2009 14:55
See here in BOL for SERVERPROPERTY function:
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/tsqlref9/html/11e166fa-3dd2-42d8-ac4b-04f18c612c4a.htm

--
Kevin G. Boles
Indicium Resources, Inc.
SQL Server MVP
kgboles a earthlink dt net


"AllenM" <NoReply(a)NoEmail.com> wrote in message
news:O%23L7h7RTKHA.4324(a)TK2MSFTNGP05.phx.gbl...
> Hi Kevin,
> Hopefully you are still watching this post. I got one more stupid question
> for you if you don't mind. How do I know if I am running SQL 2005 Standard
> or SQL 2005 Express? Or can it even just be the Workroup version.
> On my SBS 2008 Server by defualt it is running WSS 3.0 for my comapnyweb.
> I know I never installed any versions of SQL but do know that it probably
> installed the embedded native version.
> When I look in Programs Features I see this......
>
> Microsoft SQL Server Managment Studio Express
> Microsoft SQL Server Native Client
> Microsoft SQL Server Setup Support Files (English)
> Microsoft SQL Server VSS Writer
>
> Can you tell me what version and or edition of SQL I am running? Thanks.
>
>
>
>
> "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.
>>>>>
>>>>
>>>>
>>>
>>>
>>
>>
>
>


From: AllenM on 23 Oct 2009 11:38
Thanks. I've already accomplished what it was I was needing to do. I
appreciate you taking the time to provide your input and comments.


"TheSQLGuru" <kgboles(a)earthlink.net> wrote in message
news:EaSdnYu84vBsNH3XnZ2dnUVZ_r-dnZ2d(a)earthlink.com...
> See here in BOL for SERVERPROPERTY function:
> ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/tsqlref9/html/11e166fa-3dd2-42d8-ac4b-04f18c612c4a.htm
>
> --
> Kevin G. Boles
> Indicium Resources, Inc.
> SQL Server MVP
> kgboles a earthlink dt net
>
>
> "AllenM" <NoReply(a)NoEmail.com> wrote in message
> news:O%23L7h7RTKHA.4324(a)TK2MSFTNGP05.phx.gbl...
>> Hi Kevin,
>> Hopefully you are still watching this post. I got one more stupid
>> question for you if you don't mind. How do I know if I am running SQL
>> 2005 Standard or SQL 2005 Express? Or can it even just be the Workroup
>> version.
>> On my SBS 2008 Server by defualt it is running WSS 3.0 for my comapnyweb.
>> I know I never installed any versions of SQL but do know that it probably
>> installed the embedded native version.
>> When I look in Programs Features I see this......
>>
>> Microsoft SQL Server Managment Studio Express
>> Microsoft SQL Server Native Client
>> Microsoft SQL Server Setup Support Files (English)
>> Microsoft SQL Server VSS Writer
>>
>> Can you tell me what version and or edition of SQL I am running? Thanks.
>>
>>
>>
>>
>> "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.
>>>>>>
>>>>>
>>>>>
>>>>
>>>>
>>>
>>>
>>
>>
>
>


From: TheSQLGuru on 23 Oct 2009 14:34
Ahh, I see now the large date gap! Sorry - went on vacation! Glad you got
your problems resolved!

--
Kevin G. Boles
Indicium Resources, Inc.
SQL Server MVP
kgboles a earthlink dt net


"AllenM" <NoReply(a)NoEmail.com> wrote in message
news:OPMcgb$UKHA.5368(a)TK2MSFTNGP02.phx.gbl...
> Thanks. I've already accomplished what it was I was needing to do. I
> appreciate you taking the time to provide your input and comments.
>
>
> "TheSQLGuru" <kgboles(a)earthlink.net> wrote in message
> news:EaSdnYu84vBsNH3XnZ2dnUVZ_r-dnZ2d(a)earthlink.com...
>> See here in BOL for SERVERPROPERTY function:
>> ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/tsqlref9/html/11e166fa-3dd2-42d8-ac4b-04f18c612c4a.htm
>>
>> --
>> Kevin G. Boles
>> Indicium Resources, Inc.
>> SQL Server MVP
>> kgboles a earthlink dt net
>>
>>
>> "AllenM" <NoReply(a)NoEmail.com> wrote in message
>> news:O%23L7h7RTKHA.4324(a)TK2MSFTNGP05.phx.gbl...
>>> Hi Kevin,
>>> Hopefully you are still watching this post. I got one more stupid
>>> question for you if you don't mind. How do I know if I am running SQL
>>> 2005 Standard or SQL 2005 Express? Or can it even just be the Workroup
>>> version.
>>> On my SBS 2008 Server by defualt it is running WSS 3.0 for my
>>> comapnyweb. I know I never installed any versions of SQL but do know
>>> that it probably installed the embedded native version.
>>> When I look in Programs Features I see this......
>>>
>>> Microsoft SQL Server Managment Studio Express
>>> Microsoft SQL Server Native Client
>>> Microsoft SQL Server Setup Support Files (English)
>>> Microsoft SQL Server VSS Writer
>>>
>>> Can you tell me what version and or edition of SQL I am running? Thanks.
>>>
>>>
>>>
>>>
>>> "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.
>>>>>>>
>>>>>>
>>>>>>
>>>>>
>>>>>
>>>>
>>>>
>>>
>>>
>>
>>
>
>


First  |  Prev  | 
Pages: 1 2
Prev: Prepared query - plan cache
Next: SQL SERVER 2000 domain changes for users.