Which is trusted connection in sql server

Hi Friends, I created one dll to a software to access data from sql. When i run my code using above connection string working fine. But when i try to run the same code in another machine Sql Server not been installed I am getting error.

I am confused with the credentials. Here it looks like if you have some kind of major problem rather than "just" an authentication problem. For example it look like something such as trying to consume an unmanaged 32 bit DLL from a 64 bit application or the other way round Whether i need to give access to database for the specific user in sql server.? It means that it will run with the current Windows user in dev mode, it could be your own account, on a real server it would be the account Under which the web app runs.

So it could be that it uses an account which is not authorized to access the db etc Anyway it's best to just tell which error you have or the closest English translation. It should been then easier to guide you to solve THIS particular error rather than to have first to guess which error you have.

Find centralized, trusted content and collaborate around the technologies you use most. Connect and share knowledge within a single location that is structured and easy to search. Authentication is done by the domain, and authorization is handled by SQL Server.

SQL Server can also use its own logins, such as the sa user. These are both authenticated and authorized by SQL Server. It's a good primer. Stack Overflow for Teams — Collaborate and share knowledge with a private group.

Create a free Team What is Teams? Collectives on Stack Overflow. Learn more. What is a Trusted Connection? Ask Question. Asked 12 years, 3 months ago. Active 2 months ago. Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.

If you click the Options button, the dialog box expands to also contain the Options group:. The name of a SQL Server on your network. If you select a server name from the list, no further configuration is needed. You can enter " local " in the server box if you are using the same computer as SQL Server. When selected, SQL Server uses integrated login security Windows Authentication to establish connections using this data source, regardless of the current login security mode at the server. Any login ID or password supplied is ignored.

You must specify a login ID and password for all connection requests. If Use Trusted Connection is selected, the Password box is disabled. Specifies the default database to use on the connection.