Subject:MS Sql Server Author:Bob Scott Date:13 Jun 2007 11:38 AM
I am having problems connecting to Microsoft Sql Server.
If I use Sql server login it works Ok.
If I use integrated security by appending ;AuthenticationMethod=Type2 to the server URL and using a space for the username and an empty password everything seems Ok in the File Explorer but as soon as I drop a table into the schema window or Xquery Source windiow I get:-
Login failed for user '%20'
The server I need to connect to only has integrated security.