Syncing Webcam User
- Open SQL Management Studio
- Select New Query
- Copy
USE [MASTER]
GO
IF NOT EXISTS (SELECT * FROM sys.server_principals WHERE name = N'webcam')
CREATE LOGIN [webcam] WITH PASSWORD=N'r34d0nly', DEFAULT_DATABASE=[master], DEFAULT_LANGUAGE=[us_english], CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF
GO
IF NOT EXISTS (SELECT * FROM sys.server_principals WHERE name = N'ipconfigure')
CREATE LOGIN [ipconfigure] WITH PASSWORD=N'c4m3r4', DEFAULT_DATABASE=[master], DEFAULT_LANGUAGE=[us_english], CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF
GO
- Paste into the New Query and Execute
- Select New Query
- Copy and comment # out sections not needed
USE [ESM5_2_Central]
GO
ALTER USER webcam
WITH LOGIN = webcam
GO
-- management install, internal authentication only. Comment out for archive only installs or for active directory authentication.
USE [aspnetdb]
GO
ALTER USER webcam
WITH LOGIN = webcam
GO
-- archive install. Comment out for managment only installs
USE [ESM5_2]
GO
ALTER USER webcam
WITH LOGIN = webcam
GO
ALTER USER ipconfigure
WITH LOGIN = ipconfigure
GO
- Paste and Execute
- Restart SQL Service and perform an IIS reset in command line
Comments
0 comments
Article is closed for comments.