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 |
|
zaidqis
Yak Posting Veteran
63 Posts |
 Posted - 2006-06-25 : 07:43:47
|
| [code]TITLE: Connect to Server------------------------------Cannot connect to TOOLSBOX\SQLEXPRESS.------------------------------ADDITIONAL INFORMATION:Login failed for user 'sa'. The user is not associated with a trusted SQL Server connection. (Microsoft SQL Server, Error: 18452)For help, click: http://go.microsoft.com/fwlink?Prod...52&LinkId=20476------------------------------BUTTONS:OK------------------------------[/code]that is was the error message when i try to login using SQL Server Authoration ..... when i try login with sa or any other i creat iti am using SQL Server 2005 Expresswhat i have to do ???note : i checkd the user SA and there is no red arrow beside himthank you |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2006-06-25 : 08:41:33
|
Looks like you are using trusted connection in your client. Specify the login id & password in the connection strings.Also refer to http://www.connectionstrings.com/
KH |
 |
|
|
BigSam
Starting Member
30 Posts |
Posted - 2006-06-28 : 09:58:20
|
The sa account will only be useful if you installed SQL2k5 with Windows & SQL authentication.Are you trying to connect from a remote PC? If so you need to configure SQL2k5 for Remote access, in your case named-pipes. Run either the Configuration Manager or the Surface Area Configuration tools.If you are trying to connect from the same computer where SQL2k5 is installed, then I sugguest you 1st try to connect with Windows user account. If this doesn't work then again use the configuration tools.In either case I would suggest not using the sa account; create a SQL account with the appropriate access needed.BigSam |
|
|
|
|
|
|
SQL Server Authoration