Error 14430 Sql Server
Contents |
Recent PostsRecent Posts Popular TopicsPopular Topics Home Search Members Calendar Who's On Home » changed database context to 'master' error SQL Server 2005 » SS2K5 Replication » Changed database context to 'master' changed database context to 'database name' in... Changed database context to 'master' in Replication Rate Topic Display Mode Topic Options Author Message Saravanan
Changed Database Context To Master Replication
T Saravanan T Posted Monday, May 30, 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 , 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 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
SQL Server experts to answer whatever question you can come up with. Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums. SQL Server Forums Profile | ActiveTopics | Members | Search | ForumFAQ Register Now and get your question answered! Username: Password: Save Password Forgot your Password? All Forums SQL Server 2005 Forums Replication (2005) Configuring the Distributor Replication Reply to Topic http://www.sqlservercentral.com/Forums/Topic1116993-291-1.aspx Printer Friendly Author Topic manju3606 Yak Posting Veteran India 78 Posts Posted-07/26/2011: 03:08:12 Hi,I'm Configuring the Distributor Replication and I'm getting the errorConfiguring...- Configuring the Distributor (Error)MessagesSQL Server could not configure 'mssqlserver' as a Distributor. (Microsoft.SqlServer.ConnectionInfo)------------------------------ADDITIONAL INFORMATION:An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)------------------------------Destination path C:\Program Files (x86)\Microsoft SQL Server\MSSQL.1\MSSQL\Data is not http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=163481 valid. Unable to list directory contents. Specify a valid destination path.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.4035&EvtSrc=MSSQLServer&EvtID=14430&LinkId=20476 - Enabling Publisher 'mssqlserver' (Stopped)Manju russell Pyro-ma-ni-yak USA 5072 Posts Posted-07/26/2011: 09:47:55 Are you local admin on the box?What step in the configuration were you at when it happend?What Version and Editions are the publisher, distributor and subscribers? manju3606 Yak Posting Veteran India 78 Posts Posted-07/26/2011: 11:51:27 Hi,I'm Configuring the Distributor Replication in a SA log in and i am using sqlserver-2005 Enterprise EditionI'm getting the error when Configuring the Distributor final stepwhen i clicking the finish button then i am getting that errorThank you so much russellManju russell Pyro-ma-ni-yak USA 5072 Posts Posted-07/26/2011: 12:19:07 Are you trying to make C:\Program Files (x86)\Microsoft SQL Server\MSSQL.1\MSSQL\Data the snapshot folder? If yes, don't. Then whatever folder you do use, make sure it is shared.Did the distributor_admin account get created?Is the SQL Agent account a domain account or local system account?Is this Transactional Repl
a sql server 2005 on win server 2003. I get this error: TITLE: New Publication Wizard http://answers.flyppdevportal.com/MVC/Post/Thread/a9a3feb3-01ee-443d-9f3d-dafb5e13e67a?category=sqlreplication ------------------------------ SQL Server could not configure 'aaa' 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\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 I am administrator changed database on that server. I restart server and do this both in wizard and code. but I get same error. Please Help. RepliesJohn Sansom on Mon, 27 Jan 2014 11:26:34 Sounds like you may be encountering the issue described in KB914779 Use the 'sa' account to configure the Replication topology. John changed database context Sansom | SQL Server MCM SQL Server DBA Blog | Twitter: @SqlBrit | LinkedIn Mahdi Nameghi on Mon, 27 Jan 2014 11:37:14 I used this account, but the problem exist!John Sansom on Mon, 27 Jan 2014 11:46:43 Did you review the KB article, and apply it's recommendations in full?M. Mahfoud EL HOUDAIGUI on Mon, 27 Jan 2014 12:03:26 1. Install the latest version of Service Pack of SQL 2005 (SP4) : http://www.microsoft.com/en-us/download/details.aspx?id=7218 2. Try again, if doesnt work,Install the latest version of Service Pack Of Windows Mahdi Nameghi on Mon, 27 Jan 2014 16:01:30 I tried this on another server without service back and there is no problem!John Sansom on Mon, 27 Jan 2014 16:15:29 I tried this on another server without service back and there is no problem! So what's different between the two environments?Hilary Cotter on Mon, 27 Jan 2014 16:51:37 Can you try the followin