November 27, 2013 at 1:10 am
I'm going to create a liked server but I see this error, I think that I checked every thing but I don't know how can I solve this error?
TITLE: Microsoft SQL Server Management Studio
------------------------------
The linked server has been created but failed a connection test. Do you want to keep the linked server?
------------------------------
ADDITIONAL INFORMATION:
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
------------------------------
Login failed for user 'ticketing'. (Microsoft SQL Server, Error: 18456)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.50.1600&EvtSrc=MSSQLServer&EvtID=18456&LinkId=20476
------------------------------
BUTTONS:
&Yes
&No
------------------------------
November 27, 2013 at 1:16 am
Login failed for user 'ticketing'. (Microsoft SQL Server, Error: 18456)
Seems pretty self-explanatory.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
November 27, 2013 at 1:21 am
BUT I'm sure about my user and password :ermm:
November 27, 2013 at 1:23 am
bkshn (11/27/2013)
BUT I'm sure about my user and password :ermm:
I can't see the screenshot you posted.
Can you add it as an attachment instead?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
November 27, 2013 at 1:29 am
I try to attach the picture of my error
November 27, 2013 at 1:33 am
ticketing is a SQL Server user on the other server?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
November 27, 2013 at 1:39 am
yes
but my servername is ticketing too , may be it causes this error! ?
November 27, 2013 at 2:40 am
Is it possible to show us the first screen of the configuration?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
November 27, 2013 at 3:54 am
Thanks alot for your help
we solve our problem , it seem related to another server that I wanted to connect.
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply