Forum Discussion
Setup sharepoint server and SQL on same machine
Hello,
I have never done it and I have not been able to setup on the same machine my SQL and Sharepoint server. I know that it is not recommanded by Microsoft but, for my application, it is better like this.
(I am using SQL 2019 and Sharepoint server 2019)
I am wondering if it is really possible to do it since I do not find any information about it or tutorial.
If you know the answer and/or have a link that can help me I'd be very pleased.
Thank you
1 Reply
- not sure why you haven't been able to do this... the only requirements are:
1.) the server be running a valid version of windows server (i.e. 2019, 2022, etc).
2.) the server be joined to a domain
3.) the account being used to install and run through the sharepoint config be a system admin on the SQL Server.
other than that, you just install SQL Server with at least the database engine, install using mixed mode if you want to use the SA account for SQL Server for anything and ensure you add whatever domain users as the SA.
Then just run through the Sharepoint 2019 install. during the fam config process the account doing the install should have access to the SQL Server as a sys admin role.
If you are struggling, there are tons of videos out there for this and also microsoft has the sharepoint community that outlines the user requirements.
You never said what windows software you are using but you need to be using Windows Server. Although you can get away with the domain controller, Database and Sharepoint on a single server, you really should have your domain controller on its own server, and then the DB and Sharepoint on one.
Make sure you have plenty of ram, and also, if possible set up SQL Server to store the database files on a different hard drive unless using fast SSDs or something like a NVMe (M.2 or U.2)
