emergency

  • Thread starter Thread starter JohnnyAppleseed
  • Start date Start date
J

JohnnyAppleseed

I hope I understand your question. To allow access to SQL Server: using
Enterprise Manager.. Security.. Logins.., add new entry for the Windows
Authentication account. Next, for access to a database: drill down on
DbName.. Users.., add a new user entry and associate it with the login
previously created. At this point, also specify the appropriate permissions:
public, data reader, etc. The WA account is now a trusted account on that
SQL Server. They may login using WA account name only.
 
Hello,

What I understand, is that you created a "SQL Server" account, and you get
this error when connecting. For this to work, SQL Authentication must be
enabled. Using "SQL Server Entreprise Manager", right click on your server's
node, choose properties, choose the security tab then check "SQL Server and
Windows" radio button. After click OK, and restart SQL Server.

The connection string should look like this in case of SQL Server
Authentication:

Server=MyServer;Database=myDatabase;Integrated Security=false;User
Id=myusername;Password=mypassword;

in case of Windows Authentication

Server=MyServer;Database=myDatabase;Integrated Security=true;

Best regards,
Sherif
 
Does any one can to me faverite?
How to associated an account with a trusted SQL connection
I created a login account in SQL 2000 server, can add the user into a
database that I work on. but I got a error about "Not associated with a
trusted SQL server connection." This is occoured in Windows 2003 but not in
XP. How do I resolve it?
Thanks if any one can do me a favor.
 
Back
Top