Windows Authentication in SQL Server 2005
-
Hi I have SQL server installed in a machine. From another machine if I create a DSN using windows authentication, I am getting an erro message. Thanks
Windows Authentication means that the user account that the client application is running under is the account used to connect to SQL Server. That means that either the server and client must be in the same Windows domain or forest or that the server and client domains/forests must trust each other, or that there must be a Windows user account on the server with the same username and password as the client software runs as. In addition, the user, or a group that the user is a member of, must be granted a login on the instance of SQL Server that you're connecting to, and that login must be mapped to a user or role in the database you're trying to use.
Stability. What an interesting concept. -- Chris Maunder