Hi,
I deleted ALL the users from my VS DB project (I mean there is no files in the folder Users, also there is no text in pre- and post- deployment scripts)
And despite this fact I'm getting the same error.
I tried to look deeper into the matter and compared the schemas of the project and the DB to which I had unsucessfully tried to deploy it, and this is what I discovered:
For some reasons, during the deployment the VS tries to create a new user which has MY windows account, i.e. it tries to execute lines like so:
IF NOT EXISTS (SELECT * FROM master.dbo.syslogins WHERE loginname = N'DOMAIN-282D649\Login')
CREATE LOGIN [DOMAIN-282D649\Login] FROM WINDOWS
GO
CREATE USER [DOMAIN-282D649\Login] FOR LOGIN [DOMAIN-282D649\Login] WITH DEFAULT_SCHEMA=[dbo]
GRANT CONNECT TO [DOMAIN-282D649\Login]
GO
* DOMAIN - my domain, Login - my login
So, I'm out of ideas as to why on earth it does so, I have not been able to find any settings which would allow me to switch it off. I'm stuck
Could you suggest the way out, please
|