Winterleaf / Winterleaf-WebDavSharp.SQLExample

14 stars 2 forks source link

SecurityObject.IsGroup: NULL isnt a valid value for the column while update. #2

Open ghost opened 8 years ago

ghost commented 8 years ago

I setup the project (MS SQL 2012 on a Win2012 VM), deployed the DB's and added root folder (with dummy user as I didn't found another/cleaner way).

Now, I have the WebDAVSharp.SQL Server running and trying to connect to htpp://localhost:8880 through chrome. When connecting, the WebDAVSharp.SQL.exe throws two errors:

  1. Unhandled Exception: System.Data.SqlClient.SqlException: Server 'ADSI' could not be found in sys.servers
  2. The value 'NULL' can not be written to the 'IsGroup'-column. The column doesnt accept 'NULL' values. Error while UPDATE.

I cant explain myself the first error cause I dont know what the ADSI server could be in the sys.servers table, maybe some Active Directory ?

The second one seemingly results from an update statement to the SecurityObject table which specifies that 'IsGroup' should be NULL.

Am I just missing a server link, link to Active Directory or somthing or is this realy a kind of bug ?