trusted connection
-
Hi, How is it possible to use trusted connection for an Intranet site? Intranet is using a webservice which is hosted on a web server on LAN. This is the connectionstring that I am currently using for the intranet website in the company LAN. Data Source=SQLMachineName1\MSQL_DEV;Initial Catalog=DBdatabaseName;Persist Security Info=True;User Id=WebUserAccountName;Password=password; I would like to use this connectionstring instead so that I can have more control over the logged in users. If I do use this connectionstring the error it gives is: Login failed for user (null). Not associated with a trusted sql server connection. Data Source=SQLMachineName1\MSQL_DEV;Initial Catalog=DBdatabaseName;Integrated Security=True
-
Hi, How is it possible to use trusted connection for an Intranet site? Intranet is using a webservice which is hosted on a web server on LAN. This is the connectionstring that I am currently using for the intranet website in the company LAN. Data Source=SQLMachineName1\MSQL_DEV;Initial Catalog=DBdatabaseName;Persist Security Info=True;User Id=WebUserAccountName;Password=password; I would like to use this connectionstring instead so that I can have more control over the logged in users. If I do use this connectionstring the error it gives is: Login failed for user (null). Not associated with a trusted sql server connection. Data Source=SQLMachineName1\MSQL_DEV;Initial Catalog=DBdatabaseName;Integrated Security=True
the problem is in your server rights, not in your code...
enjoy the code with you is my priority, Blaise Braye