Q. Why do I receive the message "Not Associated with a trusted SQL Server Connection" when I try to connect to an SQL database and use a valid SQL username?

A. The problem you describe typically occurs when a Microsoft SQL Server installation is configured to use only Windows authentication and not SQL Server authentication. To solve the problem, perform the following steps:

  1. Start SQL Server Enterprise Manager (Start, Programs, Microsoft SQL Server, Enterprise Manager).
  2. Navigate to the SQL Server system in the Microsoft Management Console (MMC) treeview pane by selecting Console Root, Microsoft SQL Servers, SQL Server Group, &ltsql server&gt (or &ltlocal&gt); right-click the server; and select Properties from the context menu.
  3. In the SQL Server Properties dialog box, select the Security tab.
  4. In the Security section, make sure that Authentication is set to "SQL Server and Windows" and not "Windows only," as the figure at Figure shows. If necessary, change the selection and click OK.
Hide comments

Comments

  • Allowed HTML tags: <em> <strong> <blockquote> <br> <p>

Plain text

  • No HTML tags allowed.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Lines and paragraphs break automatically.
Publish