June 2, 2011 at 8:31 am
I need to prepare a Sql server 2005 installation for our staff who just purchased a vendor product.
I know the version of SQL server I need to install, what else should I know from the staff?
For example, do I need to ask them what collation of the databasle, then I should install the collation of what they have for server. Is that right?
What else should I know?
June 2, 2011 at 9:10 am
i'd ask for an install document. no doubt you will need to setup logins, agent jobs, deploy scripts etc...... ?
June 2, 2011 at 9:21 am
For collation, if I install SQL server using whatever the default collation is, even the vendor product database is different collation, it will work, correct?
Thanks
June 5, 2011 at 1:12 pm
It should. IIRC, you can specify the collation in your query if you absolutely have to. Either that or you can set it globally in a stored procedure, run the query, and set it back again.
June 6, 2011 at 4:09 am
i'd ask for an install document. no doubt you will need to setup logins, agent jobs, deploy scripts etc...... ?
I completely agree. If you do anything without having read the Vendor's install document then you risk having to redo a lot of your work.
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
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply