SQL Connection

G

Guest

I use "WIndow Authentification" to sign on to "Microsoft SQL Server
Management Studio Express". I create and account with "SQL Server
Authentification" and assigned a password. I also identify the database that
this ID has access to. When I then try to login with this id, I get a "Login
Failed for user 'Fred'. The user is not associated with a trusted SQL Server
Connection....Error: 18452". Why am I getting this error?

I assummed that if I am going to be using ASP.Net to sign on an read/update
a database table, that I need to create an ID and password for that activity.
Would that not be an accurate assesment of what needs to be done?

Thanks in advance for your assistance!!!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Open Connection error 1
Login failed for user ''. The user is not associated with a trusted SQL Server connection. 4
using Membership on production server (Copy Web Site tool) - Used to SQL Server 2000 enterprise edit 5
SQL Connection/Security problem 9
using Membership on production server (Copy Web Site tool) 3
Reason: Not associated with a trusted SQL Server connection. 1
Development environment setup: connect to SQL Server 2000 database 3
Failed to generate a user instance of SQL Server. Only an integratedconnection can generate a user i 2

Top