search

Winterleaf / Winterleaf-WebDavSharp.SQLExample

14 stars 2 forks source link

Error while connecting to WebDAVSharp.SQL.exe through Web Browser #3

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 ?

Winterleaf commented 8 years ago

Yes, ADSI is a SQL Linked Server to Active Directory. Hrm I’ll need to update that.

From: Devils Jin [mailto:notifications@github.com] Sent: Monday, May 23, 2016 11:11 AM To: Winterleaf/Winterleaf-WebDavSharp.SQLExample Winterleaf-WebDavSharp.SQLExample@noreply.github.com Subject: [Winterleaf/Winterleaf-WebDavSharp.SQLExample] Error while connecting to WebDAVSharp.SQL.exe through Web Browser (#3)

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 ?

— You are receiving this because you are subscribed to this thread. Reply to this email directly or view it on GitHub https://github.com/Winterleaf/Winterleaf-WebDavSharp.SQLExample/issues/3

ghost commented 8 years ago

First of all, should this server be deployed automatically ? Then, probaply I've recreated the issue cause of network problems, if you didnt seperate them please delete the other issue with same content (sorry for that).

I'll try to create the linked server (ADSI) myself and feedback tomorrow.