SQL Server Mode & Password
SQL Server Mode & Password
When you see this message, please check if you have a ZiiPos Account in your Database
Open SQL Server Management Studio
Go to Security -> Logins
Click Logins--> New Login
Enter username :
ZiiPos
Select SQL Server Authentication
Set Password:
ZiiPos884568
Uncheck Enforce password policy
Go to Sever Roles tab
check system admin
USE [master]
GO
CREATE LOGIN [ZiiPos] WITH PASSWORD=N'ZiiPos884568', DEFAULT_DATABASE=[master], CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF
GO
EXEC master..sp_addsrvrolemember @loginame = N'ZiiPos', @rolename = N'sysadmin'
GO