We have created Microsoft SQL Server database in semi dedicated environment. We are trying to connect Database from “Report Plus application” but it shows an error message as "Connection failed with the login is from untrusted domain and can't be used with windows authentication”.Pls advise how to solve it...
Hello Junaid,
Please check this article, it lists possible causes for that connectivity error,
http://blogs.msdn.com/b/sql_protocols/archive/2008/05/03/understanding-the-error-message-login-failed-for-user-the-user-is-not-associated-with-a-trusted-sql-server-connection.aspx
One of them being spaces in the connection string. Can you make sure you have none? Also, have you tried entering the credentials leaving the domain field empty?
Let me know if you have any additional questions regarding this matter.
The username & password which I have mentioned in screenshot is for SQL Server Authentication.If I enter without domain Name in "Authentication screen",whether it will connect as SQL Server Authentication ???.Pls advise.
I have tried without Domain also but now error message is "Can not open database for requested login:connection failed for database Khari_Mis",In account screen
which username & password to be filled ? I have entered SQL Server UserName & Password...
Note:
But its working in SQL Server Management Studio for SQL server Authentication (with same username & password for above)
In order to troubleshoot this issue we will need test credentials to your to your server.
Please send a message to mobileapps@infragistics.com with the test credentials mentioning this most "MSSQL in semi dedicated Environment"
Thanks.
Junaid,
Thank you for providing the test credentials. I was able to run some tests and this is what I found out:
- Both the URL and the IP provided point to a page
- SQL traffic is not HTTP/HTTPS
- We believe we don't support this
In spite of what I found, one of our engineers will see what we can do to support your scenario.
I'll update the thread as soon as I have their feedback.
Thank you for your patience and hava a nice day.