SBA on SBS [revisited]

On October 28, 2005, in news, by

The other day in the comments to the blog, Greg posted the ‘how to get SBA on SBS’ and yes, while there is a whitepaper in the works, you know us geeks we want to try everything NOW… so without further ado here it is:


Here is the configuration that worked for me – steps supplied by Microsoft:

On SBS
1. Go to Start | Run, type in svrnetcn and choose OK
2. Choose MICROSOFTSMLBIZ from drop under instance “SQL Server Network Utility” dialog
3. On the Left side of the dialog in the “Disabled Protocols” window select “TCP/IP” and click on “Enable” button.
4. On the right side of the window select the “TCP/IP” and click on “Properties” button.
5. In the “Default Port” field of the new dialog type 56183
6. Click OK to confirm
7. Click OK on the next dialog to confirm
8. Click OK on the Message “Any changes made will be saved; however, they will not take effect until SQL server service is stopped and restarted”.
9. Click OK on the next dialog
10. Go to Start | Run, type in services.msc and choose OK
11. In the Service Window, locate the MSSQL$MICROSOFTSMLBIZ instance and highlight
12. Choose to Stop the Service
13. Start the service

Then Perform the following steps:

1. Go to File | Manage Users, create your users
2. Once that completes go to File | Data Utilities
3. Choose Rebuild File, create a new .sbc file (give file unique name that you will recognize)
4. Send that .sbc file you create to client computer (where user you created on step 1 has access) where SBA is installed
5. Attempt to launch using the .sbc file

 

Comments are closed.