Xp Pro Settings To Work With Replication
Dec 23, 2006
hi guys :( ive searched on all the topics here about replication. but now i am wondering what windows xp settings do i have to edit? i read something about dcom settings and changing permissions. what is the RIGHT way to share a file or whatever because the schema cannot be accessed for some reason. i need a whole list of things to do because things are not working out after i read the tutorials on other sites. please someone help me.
basically i need to have two servers that need to be replicating each other. i realized that the instances have to be named so i am just totally confused. ill even let anyone connect remotely to help me out if they want. or explaining will do fine. please! thanks guys!
happy holidays!
View 3 Replies
ADVERTISEMENT
Dec 23, 2006
I tried Data Mining Add-Ins for Office 2007 - CTP December 2006.
Test settings: Windows XP SP2 english with Italian regional settings, Office 2007 english (RTM), SQL Server 2005 Developer (with SP2 CTP Dec06) and Data Mining Add-ins for Office 2007 (CTP Dec06).
If I keep regional settings in Italian, I get error like this:
Old format or invalid type library. (Exception from HRESULT: 0x80028018 (TYPE_E_INVDATAREAD))
If I change regional settings to English, the Add-in works.
I found this description as the possible cause of the problem: http://msdn2.microsoft.com/en-us/library/ms178780(vs.80).aspx - if this is the issue, it would be necessary to change the ExcelLocale1033Attribute on the component.
Is there another workaround other than to install the Office 2007 MUI?
Marco Russo
http://www.sqlbi.eu
http://www.sqljunkies.com/weblog/sqlbi
View 10 Replies
View Related
Nov 16, 2015
We have many transactional publications, and would like to have identical settings on each of them. Is any way to compare settings of these publications using script?
View 3 Replies
View Related
Jun 17, 2008
We are setting up the clients' database with transactional replication that allows the subscriber to send updates by pull subscriptions.
The plan is to create a second database so the users can keep working on the original database while we get the replication set up and working. Once we feel confident that the replication is working on the second database, the plan was to backup the old one, then detach it, and then restore the new database with the latest data from the old one. My question is whether this would preserve all the replication configurations that we set up? Since the replication adds a column to each table what would happen to that column? Or what is an alternative, which would allow us to set up the replication without disturbing the user's work, and then implement the replication with the latest data?
I am also wondering how to set the synchronization to happen once daily? I do not see where I can set that. I only see options for continuous vs on demand. Does on demand mean I can somehow schedule with an external program to run once a day?
Thanks for your patience, and I hope my questions make sense.
View 11 Replies
View Related
Mar 24, 1999
I have a database, whose size is 1600MG. That database needs to be copied to the other server. But, the server does not have enough space (1600MB) for the database since the other databases also share the space. Therefore, I transfered the database to a database in that server whose size was set up 700MB the server. The table schema and data were transered successfully. But, when I tried to replicate the tranfered data to another database. The transfered database did not show all of the tables which were shown when I had queried them against that transfered database.
My question is that why it did not show alll of the tables for me to pick up for replication. Does that have something to do with the transfered database? In other word, if I set up the same size of database for the transfered database, it would have worked. Right?
View 2 Replies
View Related
Sep 4, 2007
I'm pretty new to the whole replication method. I've been making c++ programs to replicate the databases using manual odbc classes. I'm ready to try something new if it would work for me.
I have multiple databases. Basically I have a bunch of computers, each with a SQL server. These databases are the "publishers" due to the fact they are the databases that receiving new data. All of the publishers then upload their new information to the main SQL server. This seems not an issue but the trick is when the publisher uploads the information to the new SQL server, it then deletes the uploaded information from itself. This is basically the same model for everything I do. I was hoping someone might be able to tell me how to do this with replication/triggers and what versions of SQL Server 2005 that I would need to put on each of the publishers and subscriber (main).
Thank you,
Jeremy
View 4 Replies
View Related
Mar 5, 2002
I set up the transationsal replication on SQL7.0. It did not work. Here are the messages
1 on Snapshot Agent: The process could not create file Server_namec$MSSQL7REPLdATAFTPServer_namefile_nam e. Error: Access is denied
2. On Log Reader Agent: bi replication transaction are available
3. Disribution Agent: The initial snapshot for publication "DB_Name" is not yet available.
Thank you for your help
View 2 Replies
View Related
Jun 22, 1999
Hi there, the subject says it all.
I have two databases on one server. I want to replicate 1 table from one Dbase to the other. Can it be done? Am running SQL 6.5 on NT 4
Gordon
View 2 Replies
View Related
Jul 15, 2004
I want to get notice by netsend, email or any other methods
when replication doesn't work or malfunction.
Does anyone know how to do this or any other solution you use for this kind of issue?
Thank you..
View 9 Replies
View Related
Feb 6, 2004
I have maually deleted the Database.LDF file by stopping the SQL Server. When i start the SQL Server, merge replication which was configured for the database does not work. How do i fix this problem.
Thanks in advance.
Regards,
Venu.
View 1 Replies
View Related
May 15, 2006
Hi
I'm developing a scientific appliation - to forecast the spread of disease. The algorithm has been designed such that different subpopulations reside on separate computers.
The model uses the same set of data repeatedly, and only returns a small signature that reflects the appropriateness of a particular set of parameters.
The model does however change, and I'm looking for a way to roll out this model (which only contains T-SQL, CLR assemblies and service broker code).
I have considered setting up a database on each computer which has the 'data' files which are static, and a separate database which contains the algorithm which can be amended.
Could one then detach the algorithm database making the new version that can then be rolled out (by attaching it to each computer used)?
Is this the best practice? Does anyone have a suggestion as to how to do this?
Go well
Greg
View 1 Replies
View Related
Sep 4, 2006
Hello!
I have a problem with creating Merge replication between two instances of MSDE 2000. In the article http://support.microsoft.com/kb/324992/, published by Microsoft, described, that it is possible.
I am creating Merge Publication at MSDE 2000, with Distributor and Publisher configured at same machine, with options "Allow Pull Subscriptions" and "Allow Anonymous Subscriptions". There is no problem with creating of Publication. Even snapshot generation finishes successfully. Also I create a login with SQL Server Authentication and "System Administrators" database role at the publisher in order to connect to it from Subscriber.
The problem occurs, when creating anonymous pull subscription to this publication at another instance of MSDE. During initial synchronization an error occurs:
The process could not connect to Distributor '<publisher_server_name>'. Login failed for user '<login_created_at_publisher>'. Reason: Not associated with a trusted SQL Server connection. The step failed.
Although I didn't use Windows Authentication at all, so Subscriber doesn't need to connect to Distributor using trusted SQL Server connection.
What is a problem and how can I workaround?
Note: The same works correctly, if MS SQL Server used as a Publisher instead of MSDE.
Please, help!
I can provide publication and subscription creation scripts, if required.
View 1 Replies
View Related
Sep 20, 2007
Hi,
we have developped an application on pdaphone. we try to use merge replication between our sql server 2000 sp4 and sql Ce 3.0 via GPRS . Sometime that works very fine . Sometime it's a nightmare !!! nothing work . we have multiple error....
can someone tell me, what are the rules to make it work ?
can someone tell me, if it really works fine ?
thanks
View 1 Replies
View Related
Aug 4, 2015
I have been evaluating merge replication, 'push' subscription on SQL Server 2014. If the default resolver is used (I refer to @article_resolver parameter of sp_addmergearticle), all seems to work as expected. However if I use "Microsoft SQL Server Subscriber Always Wins Conflict Resolver" (or any other MS standard resolver for that matter), if the Subscriber is on a different machine, the merge agent invariably gives the following error: "The process could not initialize <resolver_name>. Verify that the component is registered correctly."
This does not happen if the Subscriber is on the same machine as the Publisher and Distributor.
The problem seemed to exist in SQL Server 2008 according to some posts but it has been apparently fixed since then. I've tried the following:
- @partition_options = 0, as was suggested somewhere.
- Copied ssrpub.dll (the resolver dll) to the Subscriber machine (should not really matter as this is 'push' subscription?)
- Registered ssrpub.dll with regsvr32 on the Publisher/Distributor machine.
I've also run sp_enumcustomresolvers on the Publisher machine, and it happily showed all standard resolver, including the "Microsoft SQL Server Subscriber Always Wins Conflict Resolver".
Another thought is, I'm using SQL Server Express as the Subscriber (on the remote machine). Perhaps it does not support custom resolvers? (I'm using the full SQL Server in the 'local subscriber' variant, which does work OK as I mentioned before).
Note also that if I create a new publication via SSMS, the Resolver tab of the Article Properties dialog is empty, i.e. it does not list any resolver. The same tab contains the full list of resolvers though, if opened for an existing publication.
View 2 Replies
View Related
Feb 28, 2006
I have a mobile device application using mobile sql 2005 replicating with sql 2000 in a x86 environment. This works fine!
I'm having issues getting this to work under Windows Server 2003 X64.
I've got all the components installed under the X64 environment including CLR 2.0 X64 and the mobile sql tools. the but when I run the Configure Web Synchronization Wizard I get the following error. SQL Server 2005 Mobile Edition Server Tools were not found on the IIS server. Run the SQL Server 2005 Mobile Edition Server Tools installer....
My question is: Were do I get the X64 version of these tools?
sqlce30setupen.msi
sql2Ken@P4.msi
The SQL environment is X86 as follows: SQL2000 SP4
Microsoft SQL Server 2000 - 8.00.2039 (Intel X86) May 3 2005 23:18:38 Copyright (c) 1988-2003 Microsoft Corporation Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 1)
Any help would be much appreciated!
View 6 Replies
View Related
May 6, 2002
I am running AWE on SQL 2000 (the server has 8 gig of RAM). I have the SQL Server set to use a max of 6 gig. The server hung unexpectedly (SQL showed no errors or signs). Has anyone had any problems with using AWE, and or any suggestions or changes I might need to do?
Thanks
View 1 Replies
View Related
Jul 26, 2000
Hi,
Can i check installation settings for SQL Server 6.5 ... like what sort order id. has been choosen etc. ? by any query ?
Thanks
View 1 Replies
View Related
Jul 16, 2002
New SQL2000 installation into which I've copied data from multiple SQL7 installations. Some of the databases I've copied over from a SQL7 server with code page 850, sort order/collation 42, using the detach-copy mdf/ldf-attach procedure outlined elsewhere on this site (thank you). Other databases have been DTS'd from another SQL7 server with code page 850, sort order/collation 44.
In the end I want all databases to be in the default Latin1_General_CI_AI collation I've chosen for my installation.
I'm off to immerse myself in collation papers and alter database documentation from BOL, but was hoping someone could enlighten me in a less painful way.
Thanks,
Al
View 2 Replies
View Related
Mar 27, 2008
Hi all
I've got a problem with an American software vendor, who's asked me to check and adjust the regional settings within SQL Express 2005, installed on an XP SP2 pc
I'm scanning meta data into this database
If I enter a date field with a UK date format, I get an error in the SQL logs
If I enter a date field with a US date format, everything is fine
The XP box is setup with all UK region settings
I've been told that my SQL install should automatically use the region settings from whatever OS that it's installed on
I've checked everywhere within SQL, and it all looks to be setup with UK region settings
I suggested to the software vendor that the problem lies with their software
Can anyone suggest if I've missed anything, or where I should be checking my region settings within SQL?
Kind Regards
Tonasis
View 2 Replies
View Related
Apr 14, 2008
From the sql server management studio i cannot see database properties
logical file name of mdf, location of the mdf
logical file name of ldf, location of the ldf
what setup should i change to see the properties.
View 5 Replies
View Related
Sep 9, 2006
When SQL Server and Web site are both on same machine,
it runs fine, can get data and display in web page.
but when trying to get data from remote SQL Server, it gives error.
What's the setting for SQL server configure and security settings
in different versions?
MS SQL 2000 | MS SQL 2005
==============================================
Framework 1.x ? | ?
Framework 2.0 ? | ?
Thanks alot.
Please provide some setting help for the ?
View 4 Replies
View Related
Jun 26, 2007
is there a simple manual how to setup RS.
with the administrators group im able to view my reports. but normal users are not able to view anything. they can enter reporting services, but not open a report.
View 1 Replies
View Related
Sep 13, 2006
I am sure I'm being blind here (it wouldn't be the first time - and won't be the last time).
I have a package that retrieves some values from SQL table to allow me to dynically create an email message, so it retrieves To Addresses, From Address, Header, Body from a table, populates variables, and uses expressions to assign those to the SEND MAIL TASK.
That is working (after a bit of head/wall/banging to get my default virtual SMTP server running locally).
Now I am trying to make the SMTP Server Name dynamic. The Property SMTPConnection specifies the SMTP Connection Manager to use, and not the server, so it doesn't seem as though I can configure a property on the SEND MAIL TASK to achieve this.
Now I'm focussing on using SQL Package Configurations to try and drive this. As I see it, just like XML configurations, if you change a value in the configuration source, then when the package runs, it get's that value, and uses it.
I have change the configuration value (outside of the package). I confirm it is actually changed by running a SQL Task that gets the value from the configuration table, and view the value assigned to the variable in watches. The value returned is a different value (in my case I changed it to an invalid servername), and yet the task still runs through successfully, using the previous SMTP servername.
huh?
View 4 Replies
View Related
Sep 29, 2006
I wanted to know if there is a way to enforce security settings on SQL 8 Server. Specifically password lengths, expiration,e tc. These servers run on a Windows Platform, so if it is not possible to enforce passwords at the database level can the windows passwords parameters be enforced for the server.
Also, how would I be able to find the last changes made to the tables within the database.
View 1 Replies
View Related
Oct 16, 2006
I need to place some site settings in my Report Manger.But in my Report Manager there is no Site Settings Icon.Is this installation problem please help me.
View 3 Replies
View Related
Nov 6, 2006
I have a page that uses an SQLDataSource web control to populate a GridView control. The SQLDataSource control uses three parameters, one of which is a text string (varchar(50)). I get timeout expired exceptions when I run the page with two specific string values, yet when I run the stored procedure in SqlSvr Management Studio, the procedure runs in 5 seconds and under 1 seconds. Being rnew to ASP.NET 2.0 and .Net in general, I have no idea where this lag is occurring. I would like to know two things:
1. What is causing the lag that causes the timeout in ASP.NET 2.0.
2. What can be done to adjust the timeout period SQLSVR, IIS, ASP.NET).
The underlying query is running as desired (considering the data it has to chew on). For all other values, data is returned almost instantanious. I can provide a copy of the query id need be.
Truly appreciate any insight you can give me!
View 2 Replies
View Related
Dec 3, 2007
INSERT [DELETE] failed because the following SET options have incorrect settings: 'ARITHABORT'. Verify that SET options are correct for use with indexed views and/or indexes on computed columns and/or query notifications and/or xml data type methods.
On local dev machine with SQL Express DB everything works fine. Once moved to shared hosting environment (with adjustments to web.config), insert and delete stored procedures produce the above error.
Made sure that stored procedures SET ARITHABORT ON at the beginning and OFF at the end, without success. Even SET ARITHABORT ON at DB level without success.
Suggestions appreciated
View 2 Replies
View Related
Dec 11, 2003
Hi all,
I am a newbie to .NET and MS SQL server. I am trying to connect to sql server d/b from my application files.
How should i open a connection from my system pc5 (where application/proj being developed) to SQL serevr which is installed on my server(server1). Both are in network.
I have installed sql client on my system(pc5) and created my d/b (MyDB) thru EM, now how can i create username & password for MyDB datbase.
I had installed ASP.NET Commerce server(from ASP.NEt site) on my system pc5 its working fine with accessing Commerce d/b from server1. I observed the string in web.config file of commerce application it is as follows.
<add key="ConnectionString" value="server=server1;database=Commerce;uid=CommerceUser;pwd=CommerceUser;" />
In the same way can i create Username and passsword for MyDB database, if so how should i do that. that should look like some thing like this..
<add key="ConnectionString" value="server=server1;database=MyDB;uid=MyDBUser;pwd=MyDBpass;" />
to do in this way i need to create username and pw for MyDB . How should i create username ansd pw for MYDB datase.
Pls help me out.
Thanks in adv
Kumar
View 3 Replies
View Related
Jun 5, 2006
Hello all. I created an app locally with VWD Express and moved it to to our server but I am getting the following error...
An attempt to attach an auto-named database for file D:WebApp_DataSurvey.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.
This is the connectionstring from the web.config file used on the server. I did not change anything from the local copy.
<connectionStrings>
<add name="SurveyConnectionString1" connectionString="Data Source=.SQLEXPRESS;AttachDbFilename=|DataDirectory|Survey.mdf;Integrated Security=True;User Instance=True"
providerName="System.Data.SqlClient" />
</connectionStrings>
What settings do I need to change in order for this to work? Any advice is appreciated. Thanks.
View 1 Replies
View Related
Jan 23, 2004
Hi,
I was wondering how to change the language settings on SQL Server. The server is currently set to US English, and I was wondering how it is possible to change it to UK English. The Server Regional Settings are set to UK English.
Also, on a semi-related topic, does SQL Server store dates in a universal format, and then when data is requested does it 'translate' these dates into the format required by that particular regional setting?
Thank you for any input
Marman
View 1 Replies
View Related
May 12, 2014
Using the Agentpress theme I have put together a client site that is fully functional, however the client has asked that the search query is altered slightly and i'm having trouble working out how to do it.Basically they want the search facility provide the following options:
1. Bedrooms searched for as 1+, 2+, 3+ and 4 or more.
2. Property availability to provide just 2 options - Available and Include Let Properties.
how to change the search settings to return this information.
View 2 Replies
View Related
Apr 5, 2006
Hi all,
I need to change the Language Settings from my query analyser. Is it Possible???
If so, how ??
Thanks in advance
Regards,
satish.r
"Known is a drop, Unknown is an Ocean"
View 1 Replies
View Related
