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 |
|
sql_2k
Starting Member
26 Posts |
 Posted - 2008-04-14 : 10:21:46
|
| Hi All, I have created a new user login with all necessary database permissions , but while trying to connect to the server with the same login the below error msg is coming up, please advise. Login failed for user 'TESTAPP'. The user is not associated with a trusted SQL Server connection. (Microsoft SQL Server, Error: 18452) |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-04-14 : 10:29:25
|
| Is it a windows login or sql login? Also have you checked the settings for authentication in surface configuration manager? |
 |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-04-14 : 10:34:33
|
| Did you enable Windows and Sql logins in Server properties? You have to restart services for that? |
|
|
|
sql_2k
Starting Member
26 Posts |
Posted - 2008-04-14 : 10:39:40
|
Hi,The login have created is SQL login. Also as am new to SQL 2005, would appreciate if you can guide me checking the settings for authentication in surface configuration managerquote:
Originally posted by visakh16
Is it a windows login or sql login? Also have you checked the settings for authentication in surface configuration manager?
|
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-04-14 : 10:44:15
|
| Did you check what i said? |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-04-14 : 10:49:00
|
| Refer this article:-http://www.hostmysite.com/support/vps/windows/mixedmode/ |
|
|
|
sql_2k
Starting Member
26 Posts |
Posted - 2008-04-14 : 10:51:47
|
Hi,The login have created is SQL login. Also as am new to SQL 2005, would appreciate if you can guide me checking the settings for authentication in surface configuration managerquote:
Originally posted by visakh16
Is it a windows login or sql login? Also have you checked the settings for authentication in surface configuration manager?
|
|
|
|
sql_2k
Starting Member
26 Posts |
Posted - 2008-04-14 : 10:53:18
|
Yes the SQL login was not enabled, now it's working.. tx a lot.quote:
Originally posted by sodeep
Did you check what i said?
|
|
|
|
|
|
|
Prob. with SQL server Login