Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jhermiz
3564 Posts |
 Posted - 2004-09-22 : 11:57:14
|
| My login page was once working now I get an error:An Error Occurred: System.Data.SqlClient.SqlException: Login failed for user 'IMS'. Reason: Not associated with a trusted SQL Server connection. at System.Data.SqlClient.ConnectionPool.GetConnection(Boolean& isInTransaction) at System.Data.SqlClient.SqlConnectionPoolManager.GetPooledConnection(SqlConnectionString options, Boolean& isInTransaction) at System.Data.SqlClient.SqlConnection.Open() at ims.jakah.com.forgotpwd.Button1_Click(Object sender, EventArgs e) in \\Jakah-iis-2\ims\forgotpwd.aspx.vb:line 55 Something about login failed not associated with a trust sql server connection. Never got this error before.Can anyone provide some hints on this ?Jonwww.web-impulse.comCan you dig it: http://www.thecenturoncompany.com/jhermiz/blog/ |
|
|
Kristen
Test
22859 Posts |
Posted - 2004-09-22 : 13:30:59
|
| Sounds like your connection string is attempting a Trusted Connection and can't make one. What does your connection string look like?These guys have plenty of good info on conenction strings:http://www.able-consulting.com/ADO_Conn.htmKristen |
 |
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2004-09-22 : 13:32:42
|
| I suspect that the SQL Server is using Windows only authentication, and you are trying to login with a SQL Login. Right click the server in EM, and select properties->Security, and see if it says mixed or Windows only.-Chadhttp://www.clrsoft.comSoftware built for the Common Language Runtime. |
|
|
|
jhermiz
3564 Posts |
Posted - 2004-09-22 : 14:34:57
|
| Ack I found it...Somehow the datasource got messed up...sorry I didnt respond was in a hideous meeting :pJonwww.web-impulse.comCan you dig it: http://www.thecenturoncompany.com/jhermiz/blog/ |
|
|
|
|
|
|
was once working