Visual Studio C# SQLProj - Throwing errors

36 Views Asked by At

I have a Visual Studio SQLProj that throws errors automatically when synching with the database. Not sure why this is happening when the DB is not throwing any errors at all.

For instance I have a username that called [datawriter]

When clicking on it I see the following code:

CREATE LOGIN [datawriter]

Not sure how this user works in the db but not in the project. Any idea how to fix this for good. Do I need to fix this in the db?

We should not see any errors when synching with the db.

1

There are 1 best solutions below

0
JEuvin On BEST ANSWER

Fix it like this:

CREATE LOGIN [datawriter]
FROM WINDOWS WITH DEFAULT_LANGUAGE = [us_english];
GO

CREATE USER [datawriter] FOR LOGIN [datawriter];
GO