Web Synchronization - Is Direct Connection To The Publisher Required ?
Dec 6, 2006
Hi,
I've been trying to setup a merge replication environment for a SQL Server 2005 publisher. This connection can only happen via the internet and Port 1433 cannot be opened. The replication has to be enabled only via the intenet, which is why i figured web synchronization would be a feasible choice. I've since enabled the publisher and also set up the web synchronization on a SSL based virtual directory.
However, while setting up a subscription on the client machine (using Management Studio), the first step in the wizard is to connect to the publisher.
Essentially, i need to configure a subscriber to synchronize with a publisher using web synchronization over the internet, with no direct connection to the publisher.
I've followed all the steps specified in a multitude of web sites and "Books Online", however, i come back to the same problem at the subscriber.
Is there a way to get around this or am i not doing something correct?
Ashish
View 1 Replies
ADVERTISEMENT
May 17, 2006
I'm just starting out here.
I created a simple formview connected to a local file copy of the database by adding the database into the project. It worked fine.
However, I noticed that this copy of the database was not synch'ing with the database with the same name in SQL express. So I created a new connections string to access the SQL database directly out of SQL express. Its just a simple Select * from column. However, this gives an error. Why?
Server Error in '/NETCatMgr' Application.
The data types ntext and nvarchar are incompatible in the equal to operator.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.Data.SqlClient.SqlException: The data types ntext and nvarchar are incompatible in the equal to operator.
This is the connection string
<add name="CatalogMgrConnectionString" connectionString="Data Source=mymachinesqlexpress;Initial Catalog=CatalogSQL;Integrated Security=True"
providerName="System.Data.SqlClient" />
Doesn't make sense. How can the formview work fine with the SQL integrated into the project but not working with a connection string to the SQL Express proper???
View 2 Replies
View Related
Mar 23, 2007
Hello,
I have a problem with SqlClient (WindowsCE 4.2 & .NET CF2.0 SP2). PDA is connects on PC via USB-cradle and ActiveSync 4.0. PC is in the LAN and SQL Server 2005 is in the LAN too. I can't connect to SQL Server 2005 (after connection.Open() I get exception "PlatformNotSupported"). When I use SQL Server 2000, it's O.K.
Can I connect on the SQL Server 2005 from Windows CE 4.2?
Thanks.
View 3 Replies
View Related
Aug 10, 2007
Hello Everyone,
I'm trying to connect to Desktop SQL Server 2000 from Windows mobile PC Emulator (VS 2005). I need a direct connection using connection string to SQL Server 2000 through local wireless network without IIS.
Bellow is the code that I use. After executing this code I get an error on line Conn.Open(). Error says SQL Server does not exist or access denied.
SQL is un and running, and I can log in using SA username from the desktop. Even if I chance IP for another SQL server in my connection string I still get the same error. There is no firewall of any kind running.
Dim connectionSTR As String = "Persist Security Info=False;Integrated Security=False;Server=192.168.0.202,1433;initial catalog=MyDB;user id=sa;password=;"
Dim Conn As SqlConnection
Conn = New SqlConnection(connectionSTR)
Conn.Open()
If Conn.State = ConnectionState.Open Then
MessageBox.Show("Open")
End If
About my environment: SQL Server 2000 is running on Desktop PC with Windows XP SP2. Application which I need to connect to SQL Server is in Visual Studio 2005. I execute the application in Windows Mobile PC Emulator and try to connect to SQL Server from emulator.
Your advice and help is very appreciated
Thank you
Ika
View 3 Replies
View Related
Apr 25, 2007
I changed one data source settings in my SSIS project to use Windows Authentication instead of SQL Authentication. This data source is used to create connection managers in all SSIS packages. Soon after the data source was changed, when I opened any package using the connection manager that is based on this changed data source, I got an alert message box like the one given below showing different connection strings in data source and package connection manager. That's understandable (why can't VS 2005 do this silently or give an option to let this happen silently? that would be nice.).
Here is the problem. Even after both data source and connection manager are synchronized, still the same message box keeps on coming when ever I open any affected package (about 20 packages!). It is very annoying as you can see that old and new connection strings ARE IDENTICAL, still VS 2005 is not able to recognize this. I installed VS2005 SP1 even before I ran into this problem. I asked my friends to open this project and check the behavior on his machine. Same thing. Is this a known bug? How to fix this problem? Thanks for your help.
=====
Message box "Synchronize Connection Strings" (VS 2005 status bar shows "Performing post package load operations"):
This package contains at least one connection which is based on a datasource. The connection string for conenctions and data sources listed below are currently not identical. Connection strings of connections will be updated to reflect those on the datasource.
Connection: SqlServer.NET.HBI_DW.hbiuser
Data source: SqlServer.NET.HBI_DW.hbiuser
Old Connection String: Data Source=SDAL1060DB;Initial Catalog=HBI_DW;Integrated Security=True;
New Connection String: Data Source=SDAL1060DB;Initial Catalog=HBI_DW;Integrated Security=True;
=====
View 20 Replies
View Related
May 2, 2001
How much RAM is necessary for concurrent SQL connections? My server has 2 Xeon processors, 1GB RAM, a 10GB database size on a TCP/IP box. CPU utilization can run 80-90% and pages/sec can sometimes jump up to 40, especially is the users are running reports from the SQL database. I've been told by some people that I have enough RAM to support the 130 SQL user connections. Others I've been told that I need at least 40MB RAM per user (which means that I'm about 4GB short of RAM). Based on previous entries, I obviously need more, but how much more is the question.
View 3 Replies
View Related
Jul 20, 2005
I am writing SQL data apps using VB.NET 2003, MSDE is being used as theserver.When I create and instance of the server, it has a the formatmachinename/instancenameThis is fine for the developement machine but how does my code connect tothe server when it is on another machine ? When an instance of MSDE is runon the target, it will produce...anotherPCname/instancenameThanks for any help
View 11 Replies
View Related
Jan 22, 2007
I have a report with this data query:
select ID1 = 6, ID2 = 15, ID3 = 3, ID4 = 3
The data is evidently static here, and hence database access is not required.
Is there a way to omit the connection string in the Datasource, or have a disconnected Datasource that does not connect to any database?
Currently I am setting the connection string arbitrarily, but it would be ideal to omit it altogether.
TIA,
ana
View 1 Replies
View Related
Nov 15, 2007
Hi
I am new to .net and sql server....i have just installed VS 2005 and sql server7.0...
I am doing my coding in vb.net......so i wanted to know the connection of the datagrid to the db in my sql server 7.0.
Can some one pls help me with this urgently.
View 6 Replies
View Related
Nov 9, 2006
I have a wired situation..!I set up transactional replication on one of my development server (SQL2000 Dev Edition with sp4).It is running fine without any issues and all of a sudden, i noticed inmy repication monitor tab under Publisher where I usually see thepublication is empty now.I do see the snapshot agent, log reader and distribution agent under myagents inside the replication Monitor. But its usefull to see all 3agents in one window under publisher before. What happend? Is there anyway to get that inside that monitor? Has someone encountered thissitation before? Please advise....After that I tried to create a new set of replication on differentdatabase on the same server and i dont see those either underReplication Monitor - Publishers....All it says is (No Items)....I would appreciate any help to correct this issue... Thanks in advance..
View 2 Replies
View Related
Sep 6, 2006
Hello everybody,
There is some strange behaviour i've recently noticed while watching synchronization progress in Replication Monitor on SQL 2005 Server Standard with merge replication configured. The merge process seems to repeat several times.
This is the initial synchronizaion (reinitalization at the subsciber). Client is using Microsoft.SQLServer.Replication objects from .net framework assemblies.
The synchronization starts normally (status is "Running"). The last message of selected session box shows (among other messages): "Beginning evaluating partial replication filters" then "Finished evaluating partial replication filters" and finally "Merge completed after processing xxx changes... etc." after a few seconds. Status changes to "Completed" and then... the merge process starts again!! "Beginning evaluating partial replication filters" etc. And this repeats about 15-20 times.
And so whole process takes about 15 minutes instead about 45 seconds to complete initial synchronization. The number of changes is "Merge completed after processing ..." never change since the first such message.
Is this some bug in web synchronization or some invalid configuration setting? Why does merge process repeat itself so many times??
Please help, thanks in advance.
Kuba
View 6 Replies
View Related
Mar 28, 2007
Hi!
I have developed a database in MS SQL Server 2005 Express, to which I would require only bulkadmin server role from an external java application, because I only need to update rows, insert values or use select queries in the database.
The problem is that, using either the Microsoft JDBC Driver 1.1 or the Java JDBC ODBC Driver and the Windows XP Data Base (ODBC) configurations, I need a user with sysadmin server role inside Sql Server, otherwise JDBC won't connect to the database using the selected user. Even if I leave the sql login with setupadmin or any server role lower than sysadmin, the connection is refused.
Is there no way to connect using JDBC to MS Sql Server 2005 other than granting the connected user sysadmin rights? My code looks as follows:
Code Snippet
String driver = "com.microsoft.sqlserver.jdbc.SQLServerDriver";
String url = "jdbc:sqlserver://FIREBLADE\SQLEXPRESS";
String user = "username";
String password = "password$$";
Connection conn;
Class.forName(driver);
conn = DriverManager.getConnection(url,user,password);
if (conn != null)
System.out.println("SQL Server Connection established ...");
I have heard that Java JDBC connections to Microsoft require high-level access.
Any informed answer is more than welcome. Thanks for reading my post!
View 1 Replies
View Related
Aug 27, 2007
hi guys help please. I have a column name Quantity of type int in my table table1 and it has an intial value say 5. My question is, is it posible to update that column say, i want to add 10 from its initial value for it to have a value of 15, without querying it first from my application and store it to a varibale and add 10 to it for it to have 15 and execute update to set the initial to new value (15).
View 6 Replies
View Related
Dec 4, 2007
I did a little bit of looking in the forums for something like this, but I wasn't able to find anything. In essence, I am looking to create a web form in ASP.NET which will emulate the SQL Server Query Analyzer Tool... eventually what I'd like to see:
- A dropdown of different connection strings, to connect to different databases
-A multi-line textbox where a user could type in a query (be it a SELECT, CREATE, UPDATE, or multiple queries at once)
-A gridview object for results
-A multiline textbox to contain server output ("the command completed successfully", "xxx rows returned", "syntax at line 3 not recognized", etc)
I can do the first 3 without any difficulty, but I have absolutely no idea where to start with the server output. Anyone have any ideas? It does not need to be secure, as the only databases they'll have access to will be "test" databases and the pages will not be publicly hosted (LAN only)
View 2 Replies
View Related
Jan 3, 2008
Hi,
There are certian "routine things" that need to be queried in my database. Currently we can either do:
1) SELECT * FROM myTable WHERE id = x
OR
2) We can use a stored procedure to do the above SQL for us...That way, if the table changes, or we make changes to the database etc. The calling code will remain unchanged and we just have to change the stored procedure code instead of anywhere that calls it.
What would you say are any disadvantages of doing the 2nd approach?
Thanks!
View 14 Replies
View Related
Apr 10, 2007
I am using SQL RS 2005 with VS2005 in Windows Application. I have placed Report Viewer on Windows From and then report is attached with it. Now report previews well in BIDS as well as in VS2005. Moreover it exports perfectly to pdf and excel but when I click print button on report viewer and give direct print to printer, font size, textbox, rectangle and every other thing become large, like instead of 10 font size, it prints 12, instead of 240 width of rectangle, it prints 280 or so.
There must be some solution to this thing. Some one help
View 3 Replies
View Related
May 12, 2008
hi all,
I am using SQL reporting services 2005, i like to have a parameter as optional, is there is any diresct way to set a parameter as optional without setting through the default value.
View 6 Replies
View Related
Jul 24, 2007
Hi
I have found article by Jamie T. (www.sqlis.com/26.aspx) where he explains how to use direct configuration.
I followed every step.
Before building project I made sure that CreateDeploymentUtility = True.
Once project was built I have copied files from Deployment folder to other PC to c:PackageConfiguration (I have 3 files there: environment.dtsconfig, PersonAge.dtsx and jamie.SSISDeploymentManifest)
dtsConfig file is;
<?xml version="1.0" ?>
- <DTSConfiguration>
- <DTSConfigurationHeading>
<DTSConfigurationFileInfo GeneratedBy="me" GeneratedFromPackageName="PersonAge" GeneratedFromPackageID="{2612ABDA-E4FB-43DF-A1C1-44066426A798}" GeneratedDate="7/24/2007 9:46:41 AM" />
</DTSConfigurationHeading>
- <Configuration ConfiguredType="Property" Path="Package.Connections[Destination].Properties[InitialCatalog]" ValueType="String">
<ConfiguredValue>DataStore</ConfiguredValue>
</Configuration>
- <Configuration ConfiguredType="Property" Path="Package.Connections[Destination].Properties[ServerName]" ValueType="String">
<ConfiguredValue>MyPCsql2k5local</ConfiguredValue>
</Configuration>
</DTSConfiguration>
However, I am doing something wrong as I was not able to deploy this to another PC.
I double click Manifest file and in Configuration Package - Property there are two entries: InitailCatalog and ServerName. Initial Catalog has Value=DataStore and ServerName = MyPCsql2k5local. I change ServerName to be AlexPcSQL2k5Local.
I have Validate Package after instalation so I get error saying that connection to Destination failed.
If I go to File System to installed package and say Run, package will run OK if I change all ConnectionManagers to point to AlexPcSQL2k5Local
What is it that I am doing wrong?
View 7 Replies
View Related
Jul 12, 2007
Hi There,
I have recently upgraded to report Server 2005. I used to have a webpage that loaded a number of reports into different frames to give real time statistics for an IT Service Desk.
In the new version if try and link directly to the report (By right clicking a report and taking the link) the report loads with out any of the toolbars etc at the top as i need it, however it does not refresh and seem to be cached data.
Has anyone got any ideas how to resolve this problem, in short all I need is a way to directly view the report losing all the toolbars etc on the top and just displaying the data.
This has been driving me mad so if anyone could help i would be really grateful!
Many thanks
Gerard
View 1 Replies
View Related
Aug 3, 2004
Hi
I have a SQL 2000 table in which pictures are stored as an Image column. I want to display then onto a c# aspx webpage without storing them to disk.
What is the best way to read and display the pictures?
In classic ASP I used to do this:
Response.ContentType = "image/jpeg"
Response.BinaryWrite rs.fields("ThisImage")
but I can't get this to work in c#.
View 2 Replies
View Related
Oct 8, 2007
ok i need to know the difference between inner outer , left , right joins ....
anyone know any good tutorials ?
View 3 Replies
View Related
Dec 11, 2007
I have a table from 1.5 million records.
A valued-table function with the parameters used in a SELECT.
1) If I use:
DECLARE @Par1 int
SET @Par1 = 28338;
SELECT Count (*) FROM MyTableValuedFunction (@Par1)
Running time: 2.3 min.
2) If instead:
SELECT Count (*) FROM MyTableValuedFunction (28338)
Running time: 0.02 sec.
Why?
The two solutions are not identical?
View 5 Replies
View Related
Sep 29, 2006
If your XML configuration files will be in the same location on your Development, UAT and PROD servers, is there any merit to making your configurations indirect?
I am modifying the connection string with the XML. My strategy is to set up an XML configuration for each database that we have. The Dev XML config will point to Development connection, UAT to UAT etc..
My thought is that by using the direct configuration it will eliminate the need for environment variables and also allow me to add configs without having to reboot the servers, which you would need to do in order to get server to recongize the EV.
Thanks
View 5 Replies
View Related
May 3, 2006
I have taken over the support over a database in sql 2000 that has 10+ remote users that synchronise each day. However it also has 30+ users who are directly updating the data in the live database on the server.
One of these users is entering data directly upon the database on the server but the new rows are being placed in the conflict table somehow!!
Does anybody have any ideas about how this could be happening ?
Is it ok to have users directly updating on the server and users synchronising ?
I would appreciate any help!!
Thanks.
View 1 Replies
View Related
Aug 29, 2007
Is there a way to use trusted connections in ASP.NET and WinForm applications yet prevent users from accessing databases directly (outside of applications) ? I know the use of trusted connections are recommended for several reasons however I have a lot of applications that I need to prevent users from accessing databases directly outside of the applications themselves.
View 5 Replies
View Related
Dec 8, 2007
Hello. Does anybody knows if the are shortcuts to differrent menu items in Sql 2005 Management Studio ?For example i will to use the "Execute " button without need to use the mouse, as this case as of others.Any knows where can i find a map or a page info with the shortcuts of SQL2005 Management Studio ? Thanks
View 1 Replies
View Related
Aug 17, 2001
In SQL7 Query Analyzer we want the results of a SELECT statement not to be displayed on screen but written to a text file.
We assume that in the tons of sp_ and SET statements there should exist
one where output file can be defined.
Greetings from Mannheim, Germany
Ricardo
View 1 Replies
View Related
Jul 20, 2007
In 2000 there was a server level setting you could change in EM, to allow direct modifications to systems catalogs.
in 2005 I would like to update some sids in sysusers tables, do I also need to find and set this option first
View 6 Replies
View Related
Oct 21, 2015
Is there a way to setup a trace to show only direct TSQL statements triggered on my server? note I don't want to capture Procedure calls or the statements called within the procs.
Actually many people are firing direct SQL statements on server. And some are coming from entity framework as well. I just want to capture those.
View 1 Replies
View Related
Jul 23, 2005
From what I've read in the docs, ado.net currently supports opening sqlserver ce tables in table-direct mode and performing Seek operations on them(using SqlCeDataReader), but not on the full-blown sql server. Is this(will this be) still true with ado.net 2.0 & sql server 2005?
View 11 Replies
View Related
Sep 23, 2006
hi,
There is no direct equivalent to Oracle's rownum or row id in SQL Server
there is any possiblity are alternate thing is exist then please reply
regards
santosh
View 10 Replies
View Related
Nov 16, 2006
Hello,
I need some clarification. I am trying to utilize the XML Direct Configuration in my SSIS packages to utilize database connections in the package. I am wanting to utilize this the same way you could use UDLs in the SQL Server 2000 DTS packages.
Currently, I am creating the dtsConfig file and saving it to my desktop. I then modify it with notepad and add the following configuration where it looks like this:
<DTSConfiguration>
<Configuration ConfiguredType="Property" Path="Package.Connections[ConnectionName].Properties[ConnectionString]" ValueType="String">
<ConfiguredValue>Data Source=[ServerName];Initial Catalog=[DBName];Provider=SQLNCLI.1;Integrated Security=SSPI;Auto Translate=False;</ConfiguredValue>
</Configuration>
</DTSConfiguration>
Once this is created, I am trying to "re-use" this in SSIS packages created moving forward, where they all point to this configuration for the same database connection.
What I don't understand is when "Enabling Package Configuration" and then pointing to this dtsConfig file doesn't create a connection in "Connection Manager" NOR does it provide a way to create a blank connection and point to this configuration.
I feel like I am missing something thats so "great" about XML configuration files. Any help would be appreciated.
Thanks,
Daniel Lackey
MCSD
View 3 Replies
View Related
