Error 21037 Sql Server
Contents |
up Recent PostsRecent Posts Popular TopicsPopular Topics Home Search Members Calendar Who's On Home » SQL Server 2005 » changed database context to 'master' error SS2K5 Replication » Changed database context to 'master' in... Changed database context to changed database context to 'database name' 'master' in Replication Rate Topic Display Mode Topic Options Author Message Saravanan T Saravanan T Posted Monday, May 30, changed database context to master replication 2011 7:05 AM Mr or Mrs. 500 Group: General Forum Members Last Login: Monday, March 28, 2016 10:20 AM Points: 502, Visits: 801 While configuring replication i am getting the below error there is no remote user distributor admin mapped to local user null , could anyone help me!------------------------------SQL Server could not configure 'XXXXX-PC' as a Distributor.------------------------------ADDITIONAL INFORMATION:An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)------------------------------Invalid destination path C:\Program Files (x86)\Microsoft SQL Server\MSSQL.1\MSSQL\Data.Changed database context to 'master'. (Microsoft SQL Server, Error: 14430)For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.1399&EvtSrc=MSSQLServer&EvtID=14430&LinkId=20476------------------------------BUTTONS:OK------------------------------ Regards,Saravanan Post #1116993 M&MM&M Posted Monday, May 30, 2011 7:14 AM SSCrazy Group: General Forum Members Last Login: Yesterday @ 7:11 PM
An Error Occurred During Decryption. (microsoft Sql Server, Error: 15466)
Points: 2,332, Visits: 3,895 Are you using scripts or GUI? M&M Post #1116994 Saravanan T Saravanan T Posted Monday, May 30, 2011 7:34 AM Mr or Mrs. 500 Group: General Forum Members Last Login: Monday, March 28, 2016 10:20 AM Points: 502, Visits: 801 I have used both.. Error remains the same. Regards,Saravanan Post #1116999 M&MM&M Posted Monday, May 30, 2011 7:43 AM SSCrazy Group: General Forum Members Last Login: Yesterday @ 7:11 PM Points: 2,332, Visits: 3,895 Can you do a sp_helpdb master and share details of filename M&M Post #1117004 Saravanan T Saravanan T Posted Monday, May 30, 2011 7:50 AM Mr or Mrs. 500 Group: General Forum Members Last Login: Monday, March 28, 2016 10:20 AM Points: 502, Visits: 801 Hi Mohammed , Please find the details..even in sys.master_files the filenames are same...master 1 C:\Program Files (x86)\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\master.mdf PRIMARY 4096 KB Unlimited 10% data onlymastlog 2 C:\Program Files (x86)\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\mastlog.ldf NULL 1280 KB Unlimited 10% log only Regards,Saravanan Post #1117008 M&MM&M Posted Monday, May 30, 2011 8:09 AM SSCrazy Group: General Forum Members Last Login: Yesterday @ 7:11 PM Points: 2,332, Visits: 3,895 Saravanan,I found some links rela
360 games PC games
There Is No Remote User Mapped To Local User Null From The Remote Server
Windows games Windows phone games Entertainment All Entertainment Movies & TV Music Business & Education Business Students & educators Developers Sale Sale Find a store Gift cards Products Software & services Windows Office Free downloads & security Internet http://www.sqlservercentral.com/Forums/Topic1116993-291-1.aspx Explorer Microsoft Edge Skype OneNote OneDrive Microsoft Health MSN Bing Microsoft Groove Microsoft Movies & TV Devices & Xbox All Microsoft devices Microsoft Surface All Windows PCs & tablets PC accessories Xbox & games Microsoft Lumia All https://support.microsoft.com/en-us/kb/3091643 Windows phones Microsoft HoloLens For business Cloud Platform Microsoft Azure Microsoft Dynamics Windows for business Office for business Skype for business Surface for business Enterprise solutions Small business solutions Find a solutions provider Volume Licensing For developers & IT pros Develop Windows apps Microsoft Azure MSDN TechNet Visual Studio For students & educators Office for students OneNote in classroom Shop PCs & tablets perfect for students Microsoft in Education Support Sign in Cart Cart Javascript is disabled Please enable javascript and refresh the page Cookies are disabled Please enable cookies and refresh the page CV: {{ getCv() }} English (United States) Terms of use Privacy & cookies Trademarks © 2016 Microsoft
ReplTalkMarch 2, 20111 0 0 0 Replication Agent fails with “An error occurred during decryption.” Chris Skorlinski SQL Server Escalation Services While helping a customer on a Replication issue, https://blogs.msdn.microsoft.com/repltalk/2011/03/02/replication-agent-fails-with-an-error-occurred-during-decryption/ we encountered an very unusual error message. An error occurred during decryption. There is no remote user 'distributor_admin' mapped to local user '(null)' from the remote server 'repl_distributor'. Changed database context to 'master'. (Microsoft SQL Server, Error: 15466) There are some key words in this error (‘distributor_admin', ‘repl_distributor') which lead us down the path of failure in the Linked Server used by changed database Replication Agent to connect back to the Distributor in order to update Agent status. For testing, we tried to recreate the same linked server. The sp_addlinkedserver command failed with the same error. This confirms where the agent was failing, but now why. CREATE LOGIN [distributor_admin] WITH PASSWORD=N'xyz', DEFAULT_DATABASE=[master], DEFAULT_LANGUAGE=[us_english], CHECK_EXPIRATION=OFF, CHECK_POLICY=ON EXEC sys.sp_addsrvrolemember @loginame = N'distributor_admin', @rolename = N'sysadmin' EXEC master.dbo.sp_addlinkedserver @server = changed database context N'repl_distributor', @srvproduct=N'SQL Server' EXEC master.dbo.sp_addlinkedsrvlogin @rmtsrvname=N'repl_distributor',@useself=N'False',@locallogin=NULL,@rmtuser=N'distributor_admin',@rmtpassword=N'xyz' Further investigation uncovered the SQL Agent Services was running under a Domain Account. From the SQL Errorlog we discovered a “Service Principal Name (SPN)” could not be created. We know the SPN is used for delegation to allow one domain user to Impersonate another domain user using Kerberos Authentication. Our solution was to log on to the Distributor using the same Logon account as the SQL Agent and SQL Service account. We also used the same SQL Agent Service Account across all 3 servers (publisher, distributor, subscriber) used in Replication. While not the most secure, it did simplify authentication and allow Replication Agent to connect without unexpected errors. Tags distributor_admin repl_distributor sp_addlinkedserver Comments (1) Cancel reply Name * Email * Website Brandon Williams says: April 4, 2011 at 10:21 pm Hi Chris, Had the customer's Publisher/Distributor recently been moved? I once encountered this same error after I had moved a Publisher/Distributor to a new machine using backup and restore with publication, msdb, distribution, and master databases using the keep_replication switch. It turns out the Service Master Key from the