Microsoft Sql Server Error 14430
Contents |
Recent PostsRecent Posts Popular changed database context to 'master' error TopicsPopular Topics Home Search Members Calendar Who's On Home
Changed Database Context To 'database Name'
» SQL Server 2005 » SS2K5 Replication » Changed database context to 'master' in... Changed changed database context to master replication database context to 'master' in Replication Rate Topic Display Mode Topic Options Author Message Saravanan 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: 2 days ago @ 8:46 PM Points: 2,333, Visits: 3,896 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: 2 days ago @ 8:46 PM Points: 2,333, Visits: 3,896 Can you do a sp_helpdb master and share details of filename M&M Post #1117004 Saravanan T S
log in tour help Tour Start here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Database Administrators Questions Tags Users Badges Unanswered Ask Question _ Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute: Sign http://www.sqlservercentral.com/Forums/Topic1116993-291-1.aspx up Here's how it works: Anybody can ask a question Anybody can answer The best answers are voted up and rise to the top Error configuring SQL Server as Distributor up vote 0 down vote favorite I'm trying to configure replication on a new install (moving to SQL 2012) and I keep getting the same error even after messing with the service name, folder permissions, etc... http://dba.stackexchange.com/questions/90725/error-configuring-sql-server-as-distributor Using the Configure Distribution Wizard, I'm getting the following error: SQL Server could not configure 'SQL01' as a Distributor Additional information: An exception occured while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.Connectioninfo) Destination path E:\MSSQL\Data is not valid. Unable to list directory contents. Specify a valid destination path. Changed database context to 'master'. (Microsoft SQL Server, Error: 14430) I logged in as the local Administrator. I connected to SQL using the local Administrator account. I tried running SQL Server/Agent as NETWORK SERVICE as well as making a local user and using the local user. The local user has full permissions to E:\MSSQL\Data folder which is where all the databases are kept. Windows Server 2008 R2 SQL Server 2012 SP2 Thank you, Adrian sql-server replication share|improve this question asked Feb 1 '15 at 5:41 Adrian P 1 In your destination path E:\Microsoft SQL Server\DATA is not valid. Unable to list directory contents. Specify a valid destination path. –Md Haidar Ali Khan Feb 1 '15 at 6:42 After replication once you must reboot the windows server. –Md Haidar Ali Khan Feb 1 '15 at 6:51 E:\MSSQL\Data is a valid path, it c
------------------------------ 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'. changed database (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 on that server. I restart server and do this both in wizard and code. but I get same error. Please Help. Edited by Mahdi Nameghi changed database context 3 hours 21 minutes ago January 27th, 2014 3:10am Sounds like you may be encountering the issue described in KB914779 Use the 'sa' account to configure the Replication topology. Free Windows Admin Tool Kit Click here and download it now January 27th, 2014 6:30am This topic is archived. No further replies will be accepted. Other recent topics Remote Administration For Windows. Easy remote access of Windows 10, 7, 8, XP, 2008, 2000, and Vista Computers Click here to find out more Reboot Hundreds of computers, disable flash drives, deploy power managements settings. Click here to get your free copy of Network Administrator. Over 25 plugins to make your life easier