Avatar of ekheir
ekheirFlag for Lebanon asked on

connecting client to server sql2008

am receiving the down error while testing a link from my client computer while  every thing is ok on the server,both computers are on a domain and i have a domain admin rights

===================================

Failed to retrieve data for this request. (Microsoft.SqlServer.Management.Sdk.Sfc)

------------------------------
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476

------------------------------
Program Location:

   at Microsoft.SqlServer.Management.Sdk.Sfc.Enumerator.Process(Object connectionInfo, Request request)
   at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.NavigableItemBuilder.BuildDynamicItemWithQuery(IList nodes, INodeInformation source, INavigableItem sourceItem, String urnQuery, Boolean registerBuilder, Boolean registerBuiltItems)
   at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.NavigableItemBuilder.BuildDynamicItem(IList nodes, INodeInformation source, INavigableItem sourceItem, IFilterProvider filter)
   at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.NavigableItemBuilder.Build(INodeInformation source, INavigableItem sourceItem, IFilterProvider filter)
   at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.NavigableItem.GetChildren()
   at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.ExplorerHierarchyNode.BuildChildren()

===================================

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

------------------------------
Program Location:

   at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteReader(String sqlCommand)
   at Microsoft.SqlServer.Management.Smo.ExecuteSql.GetDataReader(String query)
   at Microsoft.SqlServer.Management.Smo.DataProvider.SetConnectionAndQuery(ExecuteSql execSql, String query)
   at Microsoft.SqlServer.Management.Smo.ExecuteSql.GetDataProvider(StringCollection query, Object con, StatementBuilder sb, RetriveMode rm)
   at Microsoft.SqlServer.Management.Smo.SqlObjectBase.FillData(ResultType resultType, StringCollection sql, Object connectionInfo, StatementBuilder sb)
   at Microsoft.SqlServer.Management.Smo.SqlObjectBase.FillDataWithUseFailure(SqlEnumResult sqlresult, ResultType resultType)
   at Microsoft.SqlServer.Management.Smo.SqlObjectBase.BuildResult(EnumResult result)
   at Microsoft.SqlServer.Management.Smo.SqlObjectBase.GetData(EnumResult erParent)
   at Microsoft.SqlServer.Management.Sdk.Sfc.Environment.GetData()
   at Microsoft.SqlServer.Management.Sdk.Sfc.Environment.GetData(Request req, Object ci)
   at Microsoft.SqlServer.Management.Sdk.Sfc.Enumerator.GetData(Object connectionInfo, Request request)
   at Microsoft.SqlServer.Management.Sdk.Sfc.Enumerator.Process(Object connectionInfo, Request request)

===================================

Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.
OLE DB provider "SQLNCLI10" for linked server "XXX" returned message "Invalid connection string attribute". (.Net SqlClient Data Provider)

------------------------------
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.00.1300&EvtSrc=MSSQLServer&EvtID=18456&LinkId=20476

------------------------------
Server Name: emad-01
Error Number: 18456
Severity: 14
State: 1


------------------------------
Program Location:

   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlDataReader.ConsumeMetaData()
   at System.Data.SqlClient.SqlDataReader.get_MetaData()
   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
   at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
   at System.Data.SqlClient.SqlCommand.ExecuteReader()
   at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteReader(String sqlCommand)
Microsoft SQL ServerMicrosoft SQL Server 2008

Avatar of undefined
Last Comment
Mark Wills

8/22/2022 - Mon
James Murrell

Ensure that you have specified a password for this account
Vitor Montalvão

How are you testing the connection to SQL Server?
Mark Wills

have credential problems... if you really want anonymous logins, password is normally an e-mail address.
Your help has saved me hundreds of hours of internet surfing.
fblack61
Mark Wills

are you actually connecting in the first place ?
ASKER
ekheir

iam not connecting throught the ANONYMOUS LOGON ,am using a domain admin user but while making test for the connection iam receiving the above msg ,yesterday while iam trying to fix this problem i changed the config in CLICONFG.EXE and iam receiving the account that iam connecting on the server  but even its not working, i attached a pic for the new error,
when iam using the client i can connect to the server and every thing is ok ,i can modifiy users,link,creating database ,................ else when iam using the linked server links iam facing this problem,
sql2008-error1.JPG
Mark Wills

have you added a login to the linked server ? as in sp_addserverlogin ? Otherwise it is trying to pass the current SQL Server credentials as the login credentials to the other server...
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
ASKER CERTIFIED SOLUTION
Mark Wills

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
See how we're fighting big data
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
Mark Wills

Also, goto SQL Server Configuration Manager , and enable Named Pipe  - normally brings up a different error, but might be worth a go...
ASKER
ekheir

named pipe is already enabled plus the tcp and the shared memory on the server and the client,
i done the remote login but still the same
ASKER
ekheir

is there any other solution ?
I started with Experts Exchange in 2004 and it's been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst
William Peck
Mark Wills

Would now suggest a network security / credentials issue...
ASKER
ekheir

can u tell me how can i check for the network security?
Mark Wills

Have a look at http://support.microsoft.com/kb/925744/en-us and follow the links - should give you more help...

you might want to create a specific user who is also part of windows authentication and use that person to login - make sure there is no special characters such as ; in the password - it causes problems...

also make sure you can connect to the linked server via the sql server you are logging into... it sounds like it is trying to pass an unknown user and failing immediately - hence the addlinkedsrvlogin tip...

also have a quick look at http://msdn.microsoft.com/en-us/library/ms366351.aspx and follow some of those links.
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
Mark Wills

with regard that last link, need to ascertain the correct error message... the 'public' message is kept fairly nondescript to prevent information disclosure to unauthenticated clients.  To determine the true reason for the failure,  look in the server's error log where a corresponding entry will be written.  that is where you will get the "real" state as given in :  http://msdn.microsoft.com/en-us/library/ms366351.aspx