Viewing 15 posts - 1,501 through 1,515 (of 2,497 total)
SQL Server only works on a Microsoft operating system. There may be other considerations for running SQL Server on a mobile, but I am not an expert on how...
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
February 5, 2009 at 8:20 am
Part of being a good DBA is risk asessment. We know that Microsoft have hardcoded assumptions about where the resource db is located within the SP2 install, so we...
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
February 5, 2009 at 4:22 am
Have a look at SQL Server FineBuild. Even if you decide you don't want to use the scripts to do the installs, it can be worth raiding the Reference...
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
February 4, 2009 at 7:13 am
George,
Maybe it does not matter what the folders are called, I have not tried different folder names.
Provided that the CD1 media is in a different folder to the CD2...
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
February 4, 2009 at 5:14 am
Personally, I would not move master or model, for slightly different reasons.
The SP2 install places a new version of mssqlsystemresource into the original location of this database (as defined at...
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
February 4, 2009 at 3:12 am
Anders, it sounds like you are saying that if an organisation gets themselves a bad outsourcing contract then they can have problems. Sounds logical to me...
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
February 4, 2009 at 2:40 am
You should look in the SQL install logs to find the root cause of this problem.
The Agent account is the first account to be validated, and the same error message...
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
February 4, 2009 at 2:35 am
The /AGTSVCPASSWORD parameter does not like the password value to be in quotes.
I said this in a previous post in this thread because I had an install that failed...
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
January 30, 2009 at 2:55 am
I have had a similar problem when trying to install on a guest server. The local accounts are accepted but the domain accounts are not. The cause of...
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
January 30, 2009 at 2:43 am
You should be able to write a script to generate the necessary SQL Agent jobs.
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
January 29, 2009 at 7:07 am
On a 32-bit box, the limit of 4GB is there because that is the largest number you can hold in a 32-bit integer.
32-bit Windows uses some special code called PAE...
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
January 29, 2009 at 6:06 am
Can anyone answer what that % for the TotalServerMemory that is set in SSAS properties actually specifies
On a 32-bit box, this refers to memory below the 4GB line. On...
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
January 29, 2009 at 5:53 am
Sorry, that was a typo. I have corrected it to say /3GB.
If you have more than 16GB on the box, you must NOT use the /3GB switch. This...
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
January 29, 2009 at 5:49 am
Do you have /3GB set in BOOT.INI? If not, then 1.6 GB is about all that AS will be able to get on your server.
If you do not have...
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
January 29, 2009 at 5:06 am
In SSMS, right-click on your AS instance and select Properties. Scroll down to find the Memory options and set these as required, using the Value column. See BOL...
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
January 29, 2009 at 3:26 am
Viewing 15 posts - 1,501 through 1,515 (of 2,497 total)