|
sql
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Install SQL Server 2008 Questions ....We just start testing SQL Server 2008.
During installation, we would like to ask a number of questions: 1) Which account should be used ? Network Service or System. 2) When we choose "Mixed Authentication", it seems that we are not able to set up password for SA. Does SA not longer exist in SQL Server 2008 ? Since we are not using Active Directory as NOS, we have to use "Mixed Authentication". Thanking you in anticipation. Patrick Patrick
1) Which account should be used ? Network Service or System. In perfect world, you should have a domain account that sql server runs under, ah I see you do not use AD, use System Admin 2) When we choose "Mixed Authentication", it seems that we are not able to set up password for SA. Does SA not longer exist in SQL Server 2008 ? It does, I cannot remember just for installation, but you are able to change/create a new one ALTER LOGIN sa WITH PASSWORD ='blblblblblblblblbl' Show quoteHide quote "Patrick" <Patr***@discussions.microsoft.com> wrote in message news:%23hW6zBk%23JHA.200@TK2MSFTNGP05.phx.gbl... > We just start testing SQL Server 2008. > > During installation, we would like to ask a number of questions: > 1) Which account should be used ? Network Service or System. > 2) When we choose "Mixed Authentication", it seems that we are not able to > set up password for SA. Does SA not longer exist in SQL Server 2008 ? > Since we are not using Active Directory as NOS, we have to use "Mixed > Authentication". > > Thanking you in anticipation. > Patrick Dear Uri,
What is the difference between Network Service and System account ? Patrick Show quoteHide quote "Uri Dimant" <u***@iscar.co.il> wrote in message news:uDp8YUk%23JHA.4692@TK2MSFTNGP02.phx.gbl... > Patrick > > 1) Which account should be used ? Network Service or System. > > In perfect world, you should have a domain account that sql server runs > under, ah I see you do not use AD, use System Admin > > 2) When we choose "Mixed Authentication", it seems that we are not able to > set up password for SA. Does SA not longer exist in SQL Server 2008 ? > > It does, I cannot remember just for installation, but you are able to > change/create a new one > ALTER LOGIN sa WITH PASSWORD ='blblblblblblblblbl' > > > > > > > > "Patrick" <Patr***@discussions.microsoft.com> wrote in message > news:%23hW6zBk%23JHA.200@TK2MSFTNGP05.phx.gbl... >> We just start testing SQL Server 2008. >> >> During installation, we would like to ask a number of questions: >> 1) Which account should be used ? Network Service or System. >> 2) When we choose "Mixed Authentication", it seems that we are not able >> to set up password for SA. Does SA not longer exist in SQL Server 2008 ? >> Since we are not using Active Directory as NOS, we have to use "Mixed >> Authentication". >> >> Thanking you in anticipation. >> Patrick > > Hi
http://windowsitpro.com/article/articleid/47168/understanding-the-local-service-and-network-service-accounts.html Show quoteHide quote "Patrick" <Patr***@discussions.microsoft.com> wrote in message news:eaAzwKw%23JHA.2872@TK2MSFTNGP05.phx.gbl... > Dear Uri, > > What is the difference between Network Service and System account ? > > Patrick > > "Uri Dimant" <u***@iscar.co.il> wrote in message > news:uDp8YUk%23JHA.4692@TK2MSFTNGP02.phx.gbl... >> Patrick >> >> 1) Which account should be used ? Network Service or System. >> >> In perfect world, you should have a domain account that sql server runs >> under, ah I see you do not use AD, use System Admin >> >> 2) When we choose "Mixed Authentication", it seems that we are not able >> to >> set up password for SA. Does SA not longer exist in SQL Server 2008 ? >> >> It does, I cannot remember just for installation, but you are able to >> change/create a new one >> ALTER LOGIN sa WITH PASSWORD ='blblblblblblblblbl' >> >> >> >> >> >> >> >> "Patrick" <Patr***@discussions.microsoft.com> wrote in message >> news:%23hW6zBk%23JHA.200@TK2MSFTNGP05.phx.gbl... >>> We just start testing SQL Server 2008. >>> >>> During installation, we would like to ask a number of questions: >>> 1) Which account should be used ? Network Service or System. >>> 2) When we choose "Mixed Authentication", it seems that we are not able >>> to set up password for SA. Does SA not longer exist in SQL Server 2008 >>> ? Since we are not using Active Directory as NOS, we have to use "Mixed >>> Authentication". >>> >>> Thanking you in anticipation. >>> Patrick >> >> > Dear Uri,
Thank you for your advice. I would like to know why you choose "System" instead of "Network Services" ? Thanks Patrick Show quoteHide quote "Uri Dimant" <u***@iscar.co.il> wrote in message news:uSLC4Rw%23JHA.4168@TK2MSFTNGP05.phx.gbl... > Hi > http://windowsitpro.com/article/articleid/47168/understanding-the-local-service-and-network-service-accounts.html > > > > > "Patrick" <Patr***@discussions.microsoft.com> wrote in message > news:eaAzwKw%23JHA.2872@TK2MSFTNGP05.phx.gbl... >> Dear Uri, >> >> What is the difference between Network Service and System account ? >> >> Patrick >> >> "Uri Dimant" <u***@iscar.co.il> wrote in message >> news:uDp8YUk%23JHA.4692@TK2MSFTNGP02.phx.gbl... >>> Patrick >>> >>> 1) Which account should be used ? Network Service or System. >>> >>> In perfect world, you should have a domain account that sql server runs >>> under, ah I see you do not use AD, use System Admin >>> >>> 2) When we choose "Mixed Authentication", it seems that we are not able >>> to >>> set up password for SA. Does SA not longer exist in SQL Server 2008 ? >>> >>> It does, I cannot remember just for installation, but you are able to >>> change/create a new one >>> ALTER LOGIN sa WITH PASSWORD ='blblblblblblblblbl' >>> >>> >>> >>> >>> >>> >>> >>> "Patrick" <Patr***@discussions.microsoft.com> wrote in message >>> news:%23hW6zBk%23JHA.200@TK2MSFTNGP05.phx.gbl... >>>> We just start testing SQL Server 2008. >>>> >>>> During installation, we would like to ask a number of questions: >>>> 1) Which account should be used ? Network Service or System. >>>> 2) When we choose "Mixed Authentication", it seems that we are not able >>>> to set up password for SA. Does SA not longer exist in SQL Server 2008 >>>> ? Since we are not using Active Directory as NOS, we have to use "Mixed >>>> Authentication". >>>> >>>> Thanking you in anticipation. >>>> Patrick >>> >>> >> > > Patrik
For us Network... is more limited (has no access) to some shared folders (for backups as example) Show quoteHide quote "Patrick" <Patr***@discussions.microsoft.com> wrote in message news:e4%23$cW8%23JHA.3732@TK2MSFTNGP02.phx.gbl... > Dear Uri, > > Thank you for your advice. I would like to know why you choose "System" > instead of "Network Services" ? > > Thanks > Patrick > > "Uri Dimant" <u***@iscar.co.il> wrote in message > news:uSLC4Rw%23JHA.4168@TK2MSFTNGP05.phx.gbl... >> Hi >> http://windowsitpro.com/article/articleid/47168/understanding-the-local-service-and-network-service-accounts.html >> >> >> >> >> "Patrick" <Patr***@discussions.microsoft.com> wrote in message >> news:eaAzwKw%23JHA.2872@TK2MSFTNGP05.phx.gbl... >>> Dear Uri, >>> >>> What is the difference between Network Service and System account ? >>> >>> Patrick >>> >>> "Uri Dimant" <u***@iscar.co.il> wrote in message >>> news:uDp8YUk%23JHA.4692@TK2MSFTNGP02.phx.gbl... >>>> Patrick >>>> >>>> 1) Which account should be used ? Network Service or System. >>>> >>>> In perfect world, you should have a domain account that sql server runs >>>> under, ah I see you do not use AD, use System Admin >>>> >>>> 2) When we choose "Mixed Authentication", it seems that we are not able >>>> to >>>> set up password for SA. Does SA not longer exist in SQL Server 2008 ? >>>> >>>> It does, I cannot remember just for installation, but you are able to >>>> change/create a new one >>>> ALTER LOGIN sa WITH PASSWORD ='blblblblblblblblbl' >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>>> "Patrick" <Patr***@discussions.microsoft.com> wrote in message >>>> news:%23hW6zBk%23JHA.200@TK2MSFTNGP05.phx.gbl... >>>>> We just start testing SQL Server 2008. >>>>> >>>>> During installation, we would like to ask a number of questions: >>>>> 1) Which account should be used ? Network Service or System. >>>>> 2) When we choose "Mixed Authentication", it seems that we are not >>>>> able to set up password for SA. Does SA not longer exist in SQL >>>>> Server 2008 ? Since we are not using Active Directory as NOS, we have >>>>> to use "Mixed Authentication". >>>>> >>>>> Thanking you in anticipation. >>>>> Patrick >>>> >>>> >>> >> >> >  
Other interesting topics
How to Enqueue Messages With Service Broker in a Timely Fashion
Create Database on the server Upgrading from SQL Express to SQL Enterprise Raid levels Maintenance did not delete old files sql server management studio to connect to database sql replication SQL Server Programming Books Rolling back bcp takes forever. Shouldn't. SQL-server Strange Behaviour ? |
|||||||||||||||||||||||
