Hello guys,
One of my staff upgraded my server pc of sambapos to windows 10, it was an “keep files as are” upgrade and luckily not a fresh start upgrade.
My server cannot connect, this is my error msg
the files should have stayed the same?
Few things to check:
- Is SQL Server windows service running?
- Is the computer name still SERVER-PC?
- Did you install SQL Server originally in mixed mode authentication (e.g. you have a sa username and password for SambaPOS)? Show your connection string in SambaPOS to confirm. In which case, possibly your user account is now set as a Microsoft account and may have changed. Connect in management studio using SQL Server Autnentication.
In a worst case scenario that you just don’t want the Windows 10 update, you can roll back to previous version of Windows for 30 days since upgrade. Search online if you want to rollback it is very easy and might save you a lot of hassle. But personally I’ve upgraded from Windows 8 to 10 and had no issues, and I suggest you stay on Windows 10.
1 Like
I chose the easy way out and did a roll back, thank you for advice.
-
My sql windows service does seem to be a problem, multiple restarts then reestablishes connection
-
Computer name stayed the same
-
yes it was mixed mode authentication and I tried all options there, password and windows authentication
I have decided to creating a server running Microsoft server 2012 instead of windows 10 for now.
again thank you for info!
1 Like