Follow

System.Data.SqlClient.SqlException: Login failed for user 'webcam'

Syncing Webcam User

  • Open SQL Management Studio

 

  • Select New Query

webcam1.jpg

  • 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

webcam2.jpg

 

  • Select New Query

webcam1.jpg

  • 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

webcam3.jpg

 

  • Restart SQL Service and perform an IIS reset in command line

Webcam4.jpg

 

webcam5.jpg

 

 

 

 

 

 

 

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments

Powered by Zendesk