Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

SQL server 8.0

Status
Not open for further replies.

Ghazal222

IS-IT--Management
Nov 16, 2004
9
0
0
US
How can I make user a trusted SQL Server connection
 
The use must be running Windows and either log into the domain that contains the server or on the server directly. The username/password must match on the user/server/domain.

Craig Berntson
MCSD, Visual FoxPro MVP, Author, CrysDev: A Developer's Guide to Integrating Crystal Reports"
 
The SQL Server login for the user must be set up to use Windows Authentication.

In Enterprise Manager, expand down to Security>Logins. Click on logins, find the account. Right click the account select properties. On the General tab, what authentication is used?

You can not change authentications. You must delete the Login and recreate it.

-SQLBill

Posting advice: FAQ481-4875
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top