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 |
|
msman88
Starting Member
3 Posts |
 Posted - 2009-09-05 : 17:00:45
|
| Problem:" Login failed for user ''. The user is not associated with a trusted SQL Server connection. "I have the following Conn." ---------------<add name="ConnectionString" connectionString="Data Source=mssql502.ixwebhosting.com; Initial Catalog=YGhlSriDB43; Integrated Security=SSPI; Min Pool Size=5;Max Pool Size=60;Connect Timeout=30; User ID=user;Password=pwd" providerName="System.Data.SqlClient"----------------Please Help.Thanx |
|
|
shah429
Yak Posting Veteran
52 Posts |
Posted - 2009-09-05 : 18:24:00
|
| Seems like you are using SQL Server authentication to connect, where as the server is configured to only used Windows. Is that correct? If yes, change the authentication mode to Mixed mode. Hope that helps. |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
Login failed for user ''. The user is not associat