![]() If SQL Server native driver is available in the customer's environment, they could decide to use this driver as the issue doesn't occur when using SQL Server native driver. In this case, you must specify a login ID and password for all connection requests. When not selected (the default), Microsoft SQL Server uses standard login security to establish connections using this data source. The Microsoft SQL Server system administrator must have associated your Windows network ID with a Microsoft SQL Server login ID. Any login ID or password supplied is ignored. When domain B users try to setup ODBC to access the SQL datase on domain A, they get this message: 'SQL Server error: 18456. The users on domain A have no problem to access teh SQL database. Microsoft SQL Server uses integrated login security to establish connections using this data source, regardless of the current login security mode at the server. The Microsoft SQL 2008 is running on one member server of domain A. Use NT Authentication: Select the Use NT Authentication check box to specify that the SQL Server Wire Protocol driver request a secure (or trusted) connection to Microsoft SQL Server running on Windows NT, Windows 2000, Windows XP, or Windows Server 2003. The attached SDAP User Guide document mentions the below :
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
June 2023
Categories |