In this tutorial I’m going to show you how you can install SAP Business One on Windows 7.
Advance System Date
First you need to advance your system time:
Double click the year and select 2012.
Remember to change the date back to 2011 once you have installed all the applications. Make sure not to launch Sap Business One Client before you change the date back later on.
Install SQL Server 2005
Then navigate to MSSQLExpress2005 folder. Right click ‘SQLEXPR32.EXE’ and select properties. In this screenshot, I selected Windows XP (Service Pack 3). I guess it works fine, but in case it doesn’t work. Then select XP (Service Pack 2). I’ve already tested it and it works.
Make sure all the components are checked. Otherwise, uninstall all the programs installed by the installer and repeat the process again.
Select, ‘will be installed on local hard drive’.
Select, ‘local system’
Again, make sure that all of these products has checkmark next to it. Otherwise you have to uninstall all the products from the control panel. Then install it again, using a different method.
Server Management Studio
This is an optional installation. You may ditch it if you want.
Make sure that the Name and Company are the same:
Next, we need to do some configurations on the Sql Server using the SQL Server Configuration Manager. It’s a component of Sql Server 2005, so its already installed on your system. Just search for it in the Start Menu:
Then enable TCP/IP protocol for each of the following:
Then restart the service so that the changes will take effect.
Next, navigate to Packages > Server Tools. Then do the same thing that we did earlier. This time do it on the ‘Setup.exe’ file:
Again, make sure that the User Name and Company Name are the same:
Next, navigate to packages > Server. Note that were always starting from the root of the SAP Installer 2007 folder.
Again, do the same thing with the ‘Setup.exe’ file on that folder.
Oops, this time choose Custom:
Make sure that it is MSSQL 2005.
- User Id: Sa
- Password: b1admin
Just leave this one as it is:
This is also an optional step, but if you installed SQL Server Management Studio Express. Then you might also want to do this:
Don’t worry, its only normal if you see this one:
Leave things as it is. But if you are having problems connecting then just ask Google. Because I’m not really in the mood to give links right now.
At the right-hand pane, Expand Databases, and look for the SBO-COMMON database. This is the database that will be used by Sap so make sure that it is there. If not, then you might want to repeat the process from installing the server tools up to this point.
Again, leave things as it is. But you might want to make sure that. Username is ‘sa’ and Password is ‘b1admin’.
If you see these babies, then you’re good to go. If not, then go back to the sql server configuration and make sure that the TCP/IP protocol is really enabled. And that the Sql service is restarted.
SAP Business One Client
At last, here’s what we are really going to install. But it has lots of prerequisites. So we went through all those steps first. You can find its installer on Packages > Client.
You already know this
Just click on Yes.
Oops, yeah you already know what I will say. So I won’t say it anymore
And yeah, it sucks but I think its not buddy buddy with Microsoft Office 2010 which I currently have on my Windows 7 machine.
But I tried, MS Office 2003 from my virtual box. And it works. You might want to comment it out if you have luck with office 2007 and 2010.
Data Transfer Workbench
I’m not really sure what is this for. But I think its for… Surprise! Transferring data
And yeah, you can find it in Packages > Data Transfer Workbench.
I’m already getting tired of explaining. So just follow the screenshots and move your ass.
SAP Business One Configuration
Click on Change Server.
I hope you still remember the ‘sa’ and ‘b1admin’
Just wait, until the OEC Computers shows up. Select it, then press ok.
Another installer will pop out. Just do the usual thing:
Change Time and Date
You might want to change your time and date settings now. Because if you will open up your browser and log in to facebook, google or youtube. You will always see the untrusted connection notification. Try it so you’ll see what I mean. Especially on Firefox.
I have trouble making the expiration longer than 30 days. So please comment if you know what to do with this animal.