Link to home
Start Free TrialLog in
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)
Avatar of James Murrell
James Murrell
Flag of United Kingdom of Great Britain and Northern Ireland image
Ensure that you have specified a password for this account
Avatar of Vitor Montalvão
Vitor Montalvão
Flag of Switzerland image
How are you testing the connection to SQL Server?
Avatar of Mark Wills
Mark Wills
Flag of Australia image
have credential problems... if you really want anonymous logins, password is normally an e-mail address.
Avatar of Mark Wills
Mark Wills
Flag of Australia image
are you actually connecting in the first place ?
Avatar of ekheir
ekheir
Flag of Lebanon image

ASKER

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
Avatar of Mark Wills
Mark Wills
Flag of Australia image
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...
ASKER CERTIFIED SOLUTION
Avatar of Mark Wills
Mark Wills
Flag of Australia image
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Mark Wills
Mark Wills
Flag of Australia image
Also, goto SQL Server Configuration Manager , and enable Named Pipe  - normally brings up a different error, but might be worth a go...
Avatar of ekheir
ekheir
Flag of Lebanon image

ASKER

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
Avatar of ekheir
ekheir
Flag of Lebanon image

ASKER

is there any other solution ?
Avatar of Mark Wills
Mark Wills
Flag of Australia image
Would now suggest a network security / credentials issue...
Avatar of ekheir
ekheir
Flag of Lebanon image

ASKER

can u tell me how can i check for the network security?
Avatar of Mark Wills
Mark Wills
Flag of Australia image
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.
Avatar of Mark Wills
Mark Wills
Flag of Australia image
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