sql server connect: I try to connect to the pubs database but get the following error:

Server Error in '/myWebApp' Application.
--------------------------------------------------------------------------------

Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.

Im logged in as myself, and also I've created a SQLUSER login to access the data, and assiged SQLUSER to userid but still no luck

I've check the security and it is check for SQL and windows authentication

Any other idea

thank

Security is fine. and other ideas

[quoted text, click to view]

How? Could you show your code?

Check on the server that Authentication is so to "SQL Server and Windows"
and not just "Windows"

In Enterprise Manager, right click on the server > Properties > Security
Tab.

--
--------------------------------
Mike Epprecht, Microsoft SQL Server MVP
Epprecht Consulting (PTY) LTD
Johannesburg, South Africa
Mobile: +27-82-552-0268
IM: mike@NOSPAMepprecht.net

Specialist SQL Server Solutions and Consulting

[quoted text, click to view]

* Have you restarted SQL Server since it was set to allow both SQL and Win
authentication?
* Is name resolution working both ways from client to server?
* Do other logins work?
* The logon server (Logonserver) for the client should be a valid domain
controller, NOT the local workstation
-- open a dos-prompt
-- Type "set logonserver" (without the quotes)
-- Type "dir <\\valuereturned\netlogon>" where valuereturned = the value
from the set statement above
* Do you have any aliases set up (cliconfg.exe) that are forcing a certain
protocol or redirecting you to another SQL instance?
* Does the problem happen from all tools (QA, OSQL, EM, etc.)?
* Are there any event viewer messages indicating problems connecting to a
domain controller or DSN server?
* Does the account have the "access this computer from the network" rights?


Cindy Gross, MCDBA, MCSE
http://cindygross.tripod.com
This posting is provided "AS IS" with no warranties, and confers no rights.