[MS SQL Server] Linked Server not working correctly |
- Linked Server not working correctly
- Failed to Enlist TSX Server (SQL Server WMI provider is not available)
- Problem with cdc when we altering the source table;
- Authentication Mode ??
| Linked Server not working correctly Posted: 14 Oct 2013 06:10 AM PDT I am trying to set up a linked server (2008R2 to 2008R2).. where the name of the linked server is not the name of the server (we have only one instance per server). But it fails with a login error:Msg 18456, Level 14, State 1, Line 1Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.The SQL Auth Login does exits, from below, and I can log in using Management StudioThe SQL I am using:EXEC master.dbo.sp_addlinkedserver @server = N'Willis02', @srvproduct=N'MSDASQL', @provider=N'SQLNCLI', @provstr=N'DRIVER={SQL Server};SERVER=R2D2;UID=LinkedServer_Test;PWD=Help;' EXEC sp_serveroption 'R2D2', 'rpc out', 'true';EXEC sp_serveroption 'R2D2', 'rpc', 'true'; |
| Failed to Enlist TSX Server (SQL Server WMI provider is not available) Posted: 14 Oct 2013 03:16 AM PDT I have an MSX server SQL 2008 (10.0.5512) attempting to enlist SQL 2012 (11.0.3128) running on server 2012 as a TSX server. In the enlist wizzard the first and third steps complete without error, step two fails "SQL Server WMI provider is not available on server, invalid namespace (SystemManagement)" Both SQL Server Service and Agent accounts are domain accounts. I can connect to the SqlServer Configuration Manager. Firewall is completely off. Same subnet. So far I have: 1. (Registry) MSXEncryptChannelOptions set to 0 2. Run mofcomp against sqlmgmproviderxpsp2up.mof 3. (Registry) Confrimed RegularMSXConnections 0 4. SQL Server Configuration/Network Configuraton all enabled 5. Component Services "Windows Management and Instrumentation" Launch and Activation Permissions added Everyone same as was on another SQL install server 2008. Allowed Local and Remote Launch and Activation. 6. WMIMGMT confirmed there is an entry for Root/Microsoft/SqlServer/ComputerManagement11 and permissions match current working install on server 2008. I have also tried to enlist a completely serperate Server 2012 with SQL 2012 with the same results. Any ideas are greatly appreciated. |
| Problem with cdc when we altering the source table; Posted: 13 Oct 2013 01:17 PM PDT Hello DBAs!Am facing the problem when I adding or altering the columns in source table.. its not getting reflected in cdc that corresponding table automatically... but previous months it was working fine.. but I could not see any error logs.. I would like to know why this ddl changes are not get reflected in cdc table?Is there any root cause..plz let me know you suggestions :-) Thanks in advance |
| Posted: 13 Oct 2013 05:42 PM PDT I have a sql server 2008 r2 install with Windows Authentication mode selected.However I am seeing SQL accounts connect - how is this possible ??Thanks |
| You are subscribed to email updates from SQLServerCentral / SQL Server 2008 / SQL Server 2008 Administration To stop receiving these emails, you may unsubscribe now. | Email delivery powered by Google |
| Google Inc., 20 West Kinzie, Chicago IL USA 60610 | |
No comments:
Post a Comment