Anegescency
New Member
I don't know if this as an ASP.Net question or should be posted on the database forum. I'm just beginning to use SQL Server. I created a database with no problem. When I try to create a connection from my aspx page I get the following error:<BR><BR>Login failed for user 'sa'. Reason: Not associated with a trusted SQL Server connection.<BR><BR>I'm not sure where to go to "associate" a user with an SQL connection. I looked in "Admin tools", and control panel "User Accounts" and even down loaded the SQL books on line and tried to figure it out, but I'm just not finding a starting point.<BR><BR>My appologies if this post should go on database.<BR><BR>Any suggestions would be appreciated.<BR><BR>tomttI'm not sure if this is good or bad practice, but it works. Go to server properties and the security tab. Select SQL Server and Windows for authentication and System account for startup service. That should work. For a good SQL Server forum check out www.sqlteam.com. <BR><BR>Good luck.<BR><BR>Nick