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 |
|
sital
Yak Posting Veteran
89 Posts |
 Posted - 2008-12-11 : 11:48:23
|
Hi all,While opening SQL Server 2005, in the connect to server when I select SQL Authentication and give the user name and password the following error message is being displayed. What should I do to rectify the mistake?Also what is the difference between Windows Authentication and SQL Authentication?TITLE: Connect to Server------------------------------Cannot connect to SYSTEM\SQLEXPRESS.------------------------------ADDITIONAL INFORMATION:A connection was successfully established with the server, but then an error occurred during the login process. (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.) (Microsoft SQL Server, Error: 233) And at times when I enter the same username and password I get the following error.TITLE: Connect to Server------------------------------Cannot connect to SYSTEM\SQLEXPRESS.------------------------------ADDITIONAL INFORMATION:Login failed for user 'sa'. The user is not associated with a trusted SQL Server connection. (Microsoft SQL Server, Error: 18452)What could be the error? How can I rectify this problem? |
|
|
X002548
Not Just a Number
15586 Posts |
|
|
|
|
|
Error