Viewing 15 posts - 1,156 through 1,170 (of 2,497 total)
I think you need to talk to your AD and Security people. You will need to use Kerberos security for SQL Server and enable an AD Trust relationship between...
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
October 28, 2009 at 4:36 am
On a 32-bit server Task Manager does not know about memory above the 4GB line.
If you enable AWE you will have to look in the SQL Errorlog file...
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
October 28, 2009 at 4:25 am
If you are using /SQLSVCACCOUNT="NT AUTHORITY\SYSTEM" you do not need /SQLSVCPASSWORD
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
October 26, 2009 at 4:23 am
I think there is a KB article about how to change the SQL service account using the Services applet. It includes the registry key permissions and file permissions that...
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
October 26, 2009 at 4:18 am
There are a number of syntax differences between the RDL of SQL 2008 RS and previous versions. Many reports work OK, but some will need upgrading.
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
October 20, 2009 at 5:09 am
The .Net 3.5 media should be included in your SQL install media, except to Express Edition.
Whenever I have done a SQL install with FineBuild, the install time has...
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
October 20, 2009 at 5:04 am
You may want to look at FineBuild V2.1. One of the scripts allows you to apply maintenance to an existing instance or to all instances.
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
October 20, 2009 at 4:56 am
The reason you did not get the result you wanted from the shrink is that Truncate just marks the table as empty, it dos not release the space it uses....
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
October 20, 2009 at 4:40 am
Persinally I would always use SQL 2008 unless there was a specific need to use SQL 2005. SQL 2008 can read and update databases created by SQL 2005.
I do...
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
October 20, 2009 at 4:20 am
I have not done this on Windows 7, but on Windows 2003 the sequence 1) SQL 2005, 2) Visual Studio 2008 worked. Mostly.
On a newly built OS, you should...
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
October 19, 2009 at 2:51 am
The ability to use Windows privileges and membership of local Administrators group are two different things in current Windows operating systems. Even in NT4 you could limit the privileges...
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
October 15, 2009 at 2:54 am
You can set 'Lock pages in memory' on all nodes. You must also work out how much memory to give each instance on each node so tat you do...
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
October 15, 2009 at 2:49 am
Do you just want to transfer your DTS packages from SQL 2000 to SQL 2005 or SQL 2008? If so then probably the best way is to use DTSBackup2000...
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
October 14, 2009 at 5:17 am
Does the service account have the Impersonate a client after authentication (Internal Name: SeImpersonatePrivilege) privilege in Windows? This is needed to allow SQL to use different security contexts.
Another important...
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
October 14, 2009 at 4:43 am
Is the job owner account a sysadmin account? If the job owner is not a sysadmin account then it will not be able to use the sa security context.
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
October 13, 2009 at 4:47 am
Viewing 15 posts - 1,156 through 1,170 (of 2,497 total)