Not associated with a trusted sql server connection
 There
are two modes for authenticating user connections in SQL
Server and MSDE:
Compare & synchronize schemas & data (Free For SQL Server
Express)
Tune slow SQL Server code and eliminate blocks and
deadlocks
Import & export SQL Server data (CSV, Excel, XML, HTML)
The server can be configured to accept Windows Authentication only or Both
authentication modes. If the server is configured to accept Windows
Authentication only, clients connecting with a SQL Server account may get this
error message. Also, if you are connecting by specifying Windows
Authentication and your Windows account context does not have access to the
server, you may get this error message.
Changing SQL Server and MSDE authentication mode
By default, the value of the LoginMode Windows registry subkey is set to 1
for Windows Authentication and 2 for Mixed Mode Authentication. To enable
Mixed Mode authentication after installation, you must change this value to 2.
To change the value of LoginMode to 2, follow these steps:
- In Control Panel, open the Services tool to stop MSSQLSERVER and all
other related services (such as SQLSERVERAgent)
- To open Registry Editor, click Start, click Run, type regedt32, and then
click OK.
- Locate either of the following subkeys (depending on whether you
installed SQL Server/MSDE as a default instance or as a named instance):
Default Instance: HKEY_LOCAL_MACHINE\Software\Microsoft\MSSqlserver\MSSqlServer\
-or-
Named Instance: HKEY_LOCAL_MACHINE\Software\Microsoft\Microsoft
SQL Server\Instance Name\MSSQLServer\
- In the right pane, double-click the LoginMode subkey.
- In the DWORD Editor dialog box, set the value of this subkey to 2,
make sure that the Hex option is selected, and then click OK.
- Restart the MSSQLSERVER and the SQLSERVERAgent services for this
change to take effect.
WARNING: If you use Registry Editor incorrectly, you may cause
serious problems that may require you to reinstall your operating system.
For further information, refer to
http://support.microsoft.com/kb/319930/EN-US/
|
