Skip to main content

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