March 18, 2009 at 6:01 am
TITLE: Connect to Server
------------------------------
Cannot connect to NAIMISH-PC.
------------------------------
ADDITIONAL INFORMATION:
Login failed for user 'naimish'. The user is not associated with a trusted SQL Server connection. (Microsoft SQL Server, Error: 18452)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=18452&LinkId=20476
------------------------------
BUTTONS:
OK
------------------------------
Can anyone help me solve this problem?
March 18, 2009 at 6:12 am
Hi,
Could you tell me what authentication you have used to connect to the server. It seems to be that you are using windows authentication to connect to the server and hence it is getting failed. If this is the case, try connecting with SQL Server authentication.
Regards,
Ashok S
March 18, 2009 at 6:20 am
Thanks for your reply, Ashok. I was using SQL Server Authentication.
Actually, I logged in as windows authentication and created new user with sql server auth.
username and password.
but, when I logged in as new user, I encoutered with this error.
-Naimish
March 18, 2009 at 6:25 am
Check server properties if it is in Windows authentication mode....
If so, then change it to mixed-mode authentication.
March 18, 2009 at 6:33 am
I changed the Server properties to windows and sql server authentication mode. But this time I have got this error.
TITLE: Connect to Server
------------------------------
Cannot connect to NAIMISH-PC.
------------------------------
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)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=233&LinkId=20476
------------------------------
BUTTONS:
OK
------------------------------
March 18, 2009 at 6:39 am
Well...login problem is resolved...now its problem from the server-side.
Restart the sql server service once...(if its not production:-))
Check if the protocols(tcp/ip,shared memory) are enabled.
March 18, 2009 at 6:47 am
SQL Reddy (3/18/2009)
Well...login problem is resolved...now its problem from the server-side.Restart the sql server service once...(if its not production:-))
Check if the protocols(tcp/ip,shared memory) are enabled.
Hi,
As mentioned check whether the Named Connections are Enabled or not in the Server. If not Enable it and restart the server. Hope this will fix you problem.
Also have a look at this,
Regards,
Ashok S
March 19, 2009 at 5:01 am
Again I got the same error.
TITLE: Connect to Server
------------------------------
Cannot connect to NAIMISH-PC.
------------------------------
ADDITIONAL INFORMATION:
Login failed for user 'rutikas'. The user is not associated with a trusted SQL Server connection. (Microsoft SQL Server, Error: 18452)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=18452&LinkId=20476
------------------------------
BUTTONS:
OK
------------------------------
I have checked the authentication mode is mixed and still giveing me error.
Any other solution there?
March 19, 2009 at 5:09 am
Hi Namish,
Are you sure that your SQL Server has a user called "'rutikas"?
Does your SQL Server allows Windows Authentication?
Are you able to connect to your server thru SSMS using windows/sql server authentication [other than "'rutikas"]?
Regards,
Ashok S
March 19, 2009 at 5:14 am
No I could not login using this user at all. yes there is user called rutikas.
I have got sql server and windows authentication mode enabled.
March 19, 2009 at 5:25 am
Hi,
Really hard to identify your problem yaar. I'm sorry, I guess I can't help you :ermm:.
Regards,
Ashok S
Viewing 11 posts - 1 through 10 (of 10 total)
You must be logged in to reply to this topic. Login to reply