Error 14430
Contents |
Recent PostsRecent Posts Popular TopicsPopular Topics
Changed Database Context To 'master' Error
Home Search Members Calendar Who's On Home » SQL Server changed database context to 'database name' 2005 » SS2K5 Replication » Changed database context to 'master' in... Changed database context to 'master'
Changed Database Context To Master Replication
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: 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: Mo
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 Printer Friendly Author Topic http://www.sqlservercentral.com/Forums/Topic1116993-291-1.aspx 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 valid. Unable to list directory contents. Specify http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=163481 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 Replication you're setting up?Have you read this? manju3606 Yak Posting Veteran India 78 Posts Posted-07/26/20
a Bug Impact on me: None Category:MySQL Server Severity:S2 (Serious) Version:4.1.12 OS:Linux (linux) Assigned to: Miguel Solorzano View Add Comment Files Developer Edit Submission View Progress Log Contributions [28 Oct 2005 15:28] Mark Modrall Description: I have a query using INSERT ... SELECT... ON DUPLICATE KEY UPDATE... that's https://bugs.mysql.com/bug.php?id=14430 throwing an erroneous parse error Column specified twice when it's not. How to repeat: create table test ( id INT UNSIGNED PRIMARY KEY, t INT UNSIGNED NOT NULL DEFAULT 0, tu INT UNSIGNED NOT NULL DEFAULT 0, h INT UNSIGNED NOT NULL http://www.xilinx.com/support/answers/14430.html DEFAULT 0, hu INT UNSIGNED NOT NULL DEFAULT 0 ) create table test1 ( id INT UNSIGNED PRIMARY KEY, date INT UNSIGNED NOT NULL DEFAULT 0, count INT UNSIGNED NOT NULL DEFAULT 0 ) create table test2 ( id INT UNSIGNED PRIMARY changed database KEY, pid INT UNSIGNED NOT NULL DEFAULT 0 ) Insert into test (id, t, tu) Select sql_big_result pid, sum(count) as t, count(count) as tu from test1, test2 where test1.date >= 1 and date <= 2 and test1.id = test2.id group by pid order by null ON DUPLICATE KEY UPDATE t=t+VALUES(t), tu=tu+VALUES(tu) Suggested fix: don't have one [28 Oct 2005 15:46] Valerii Kravchuk Thank you for a problem report. You version of MySQL is old enough. Can you, please, upgrade and try the same actions changed database context on 4.1.15? In 5.0.15, for example, everything works OK: mysql> create database test2; Query OK, 1 row affected (0.02 sec) mysql> use test2 Database changed mysql> create table test -> ( id INT UNSIGNED PRIMARY KEY, -> t INT UNSIGNED NOT NULL DEFAULT 0, -> tu INT UNSIGNED NOT NULL DEFAULT 0, -> h INT UNSIGNED NOT NULL DEFAULT 0, -> hu INT UNSIGNED NOT NULL DEFAULT 0 -> ); Query OK, 0 rows affected (0.36 sec) mysql> create table test1 -> ( id INT UNSIGNED PRIMARY KEY, -> date INT UNSIGNED NOT NULL DEFAULT 0, -> count INT UNSIGNED NOT NULL DEFAULT 0 -> ); Query OK, 0 rows affected (0.07 sec) mysql> create table test2 -> ( id INT UNSIGNED PRIMARY KEY, -> pid INT UNSIGNED NOT NULL DEFAULT 0 -> ); Query OK, 0 rows affected (0.10 sec) mysql> Insert into test (id, t, tu) Select sql_big_result pid, sum(count) as t, -> count(count) as tu from -> test1, test2 where test1.date >= 1 and date <= 2 and test1.id = test2.id -> group by pid order by null -> ON DUPLICATE KEY UPDATE t=t+VALUES(t), tu=tu+VALUES(tu); Query OK, 0 rows affected (0.14 sec) Records: 0 Duplicates: 0 Warnings: 0 mysql> select version(); +-----------+ | version() | +-----------+ | 5.0.15-nt | +-----------+ 1 row in set (0.00 sec) Can you, please, send also the content of your my.cnf file? [28 Oct 2005 15:49] Mark Modrall At my company, we're not allowed to use MySql 5 "until redhat starts bundli