An 'OnClientConnected' on the Server side

Upon a client connecting to the server, is there an 'OnClientConnected'
-equivalent event on the server side that I can put some code to check who
has just connected or what application or workstation is connecting? I'm
looking for some way to check for 'valid' client applications.You can execute queries to view connection, session
information. In SQL Server 2000, query the sysprocesses
table in the master database. In SQL Server 2005, you can
query the dynamic management view sys.dm_exec_sessions. Both
have login times, host, program name and other info.
What you do from there depends on what you are trying to do
and what version of SQL Server may determine what options
are available to use.
-Sue
On Tue, 14 Feb 2006 13:25:28 -0800, "Trex"
<Trex@.community.nospam> wrote:

>Upon a client connecting to the server, is there an 'OnClientConnected'
>-equivalent event on the server side that I can put some code to check who
>has just connected or what application or workstation is connecting? I'm
>looking for some way to check for 'valid' client applications.|||Hello Trex,
You may want to consider to capture the audit logon/logoff event and store
them to a SQL table. Then you could use notification service to notfiy when
the insertion meets to requirment.
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
========================================
=============
This posting is provided "AS IS" with no warranties, and confers no rights.
--
>Thread-Topic: An 'OnClientConnected' on the Server side
>thread-index: AcYxrS0jasuUvcWgTpCZHnrqfgbL3A==
>X-WBNR-Posting-Host: 152.130.15.18
>From: "examnotes" <Trex@.community.nospam>
>Subject: An 'OnClientConnected' on the Server side
>Date: Tue, 14 Feb 2006 13:25:28 -0800
>Lines: 4
>Message-ID: <C4E19CC4-603C-4FD8-8044-96A28661C246@.microsoft.com>
>MIME-Version: 1.0
>Content-Type: text/plain;
> charset="Utf-8"
>Content-Transfer-Encoding: 7bit
>X-Newsreader: Microsoft CDO for Windows 2000
>Content-Class: urn:content-classes:message
>Importance: normal
>Priority: normal
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
>Newsgroups: microsoft.public.sqlserver.connect
>NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
>Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl
>Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.connect:46902
>X-Tomcat-NG: microsoft.public.sqlserver.connect
>Upon a client connecting to the server, is there an 'OnClientConnected'
>-equivalent event on the server side that I can put some code to check who
>has just connected or what application or workstation is connecting? I'm
>looking for some way to check for 'valid' client applications.
>|||Sounds like a solution. I can monitor this and kill a process if I don't
like what I see. Thank you Sue!
"Sue Hoegemeier" wrote:

> You can execute queries to view connection, session
> information. In SQL Server 2000, query the sysprocesses
> table in the master database. In SQL Server 2005, you can
> query the dynamic management view sys.dm_exec_sessions. Both
> have login times, host, program name and other info.
> What you do from there depends on what you are trying to do
> and what version of SQL Server may determine what options
> are available to use.
> -Sue
> On Tue, 14 Feb 2006 13:25:28 -0800, "Trex"
> <Trex@.community.nospam> wrote:
>
>|||Thank you Peter...this may be another possiblity for me!
"Peter Yang [MSFT]" wrote:

> Hello Trex,
> You may want to consider to capture the audit logon/logoff event and store
> them to a SQL table. Then you could use notification service to notfiy whe
n
> the insertion meets to requirment.
> Best Regards,
> Peter Yang
> MCSE2000/2003, MCSA, MCDBA
> Microsoft Online Partner Support
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> ========================================
=============
>
> This posting is provided "AS IS" with no warranties, and confers no rights
.
>
> --
>

An 'OnClientConnected' on the Server side

Upon a client connecting to the server, is there an 'OnClientConnected'
-equivalent event on the server side that I can put some code to check who
has just connected or what application or workstation is connecting? I'm
looking for some way to check for 'valid' client applications.
You can execute queries to view connection, session
information. In SQL Server 2000, query the sysprocesses
table in the master database. In SQL Server 2005, you can
query the dynamic management view sys.dm_exec_sessions. Both
have login times, host, program name and other info.
What you do from there depends on what you are trying to do
and what version of SQL Server may determine what options
are available to use.
-Sue
On Tue, 14 Feb 2006 13:25:28 -0800, "Trex"
<Trex@.community.nospam> wrote:

>Upon a client connecting to the server, is there an 'OnClientConnected'
>-equivalent event on the server side that I can put some code to check who
>has just connected or what application or workstation is connecting? I'm
>looking for some way to check for 'valid' client applications.
|||Hello Trex,
You may want to consider to capture the audit logon/logoff event and store
them to a SQL table. Then you could use notification service to notfiy when
the insertion meets to requirment.
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
================================================== ===
This posting is provided "AS IS" with no warranties, and confers no rights.
--
>Thread-Topic: An 'OnClientConnected' on the Server side
>thread-index: AcYxrS0jasuUvcWgTpCZHnrqfgbL3A==
>X-WBNR-Posting-Host: 152.130.15.18
>From: "=?Utf-8?B?VHJleA==?=" <Trex@.community.nospam>
>Subject: An 'OnClientConnected' on the Server side
>Date: Tue, 14 Feb 2006 13:25:28 -0800
>Lines: 4
>Message-ID: <C4E19CC4-603C-4FD8-8044-96A28661C246@.microsoft.com>
>MIME-Version: 1.0
>Content-Type: text/plain;
>charset="Utf-8"
>Content-Transfer-Encoding: 7bit
>X-Newsreader: Microsoft CDO for Windows 2000
>Content-Class: urn:content-classes:message
>Importance: normal
>Priority: normal
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
>Newsgroups: microsoft.public.sqlserver.connect
>NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
>Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl
>Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.connect:46902
>X-Tomcat-NG: microsoft.public.sqlserver.connect
>Upon a client connecting to the server, is there an 'OnClientConnected'
>-equivalent event on the server side that I can put some code to check who
>has just connected or what application or workstation is connecting? I'm
>looking for some way to check for 'valid' client applications.
>
|||Sounds like a solution. I can monitor this and kill a process if I don't
like what I see. Thank you Sue!
"Sue Hoegemeier" wrote:

> You can execute queries to view connection, session
> information. In SQL Server 2000, query the sysprocesses
> table in the master database. In SQL Server 2005, you can
> query the dynamic management view sys.dm_exec_sessions. Both
> have login times, host, program name and other info.
> What you do from there depends on what you are trying to do
> and what version of SQL Server may determine what options
> are available to use.
> -Sue
> On Tue, 14 Feb 2006 13:25:28 -0800, "Trex"
> <Trex@.community.nospam> wrote:
>
>
|||Thank you Peter...this may be another possiblity for me!
"Peter Yang [MSFT]" wrote:

> Hello Trex,
> You may want to consider to capture the audit logon/logoff event and store
> them to a SQL table. Then you could use notification service to notfiy when
> the insertion meets to requirment.
> Best Regards,
> Peter Yang
> MCSE2000/2003, MCSA, MCDBA
> Microsoft Online Partner Support
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> ================================================== ===
>
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> --
>
sql

An issue with Full Text Search against PDF blobs...

My client is trying to use SQL Server Full Text Search to search PDFs stored
in a varbinary(max) column. Full text search works fine for other Microsoft
Office documents stored in the same table but it does NOT give back any
results from the PDF documents.
Following is a high-level view of what the client did:
1. Installed Adobe PDF IFilter 6.0
2. Ran the stored procedure sp_fulltext_service (as documented)
3. Restarted the server
4. Verified that the filter got properly installed by querying the system
view
sys.fulltext_document_types
5. Created a full text index on the table with the documents
6. Started a full population of the index
7. Ran a sample query with a string he knows is in the PDF file like the
following:
select * from documents where freetext(document, ‘Review’) and got no
results
back
8. Ran the same sample query with a string he knows is in some Word files
like the
following: select * from documents where freetext(document, ‘SQL’) the
query
returned several rows back as expected.
Does anybody know what might be happening here?
Thank you!
Camilo Leon
Camilo,
Are you using 64-bit Windows and SQL Server? If so, last time I looked the
Adobe PDF IFilter was only 32-bit.
RLF
"Camilo" <Camilo@.discussions.microsoft.com> wrote in message
news:92BEFB18-89BF-4C7E-8B11-769B0C329B7B@.microsoft.com...
> My client is trying to use SQL Server Full Text Search to search PDFs
> stored
> in a varbinary(max) column. Full text search works fine for other
> Microsoft
> Office documents stored in the same table but it does NOT give back any
> results from the PDF documents.
> Following is a high-level view of what the client did:
> 1. Installed Adobe PDF IFilter 6.0
> 2. Ran the stored procedure sp_fulltext_service (as documented)
> 3. Restarted the server
> 4. Verified that the filter got properly installed by querying the system
> view
> sys.fulltext_document_types
> 5. Created a full text index on the table with the documents
> 6. Started a full population of the index
> 7. Ran a sample query with a string he knows is in the PDF file like the
> following:
> select * from documents where freetext(document, 'Review') and got no
> results
> back
> 8. Ran the same sample query with a string he knows is in some Word files
> like the
> following: select * from documents where freetext(document, 'SQL') the
> query
> returned several rows back as expected.
> Does anybody know what might be happening here?
> Thank you!
> Camilo Leon
>
|||Russell,
No, we are using a 32-bit machine in this case.
I did make FTS work with PDF files by creating a new table, importing the
data, creating a new catalog and populating it again.
Thanks!
Camilo
"Russell Fields" wrote:

> Camilo,
> Are you using 64-bit Windows and SQL Server? If so, last time I looked the
> Adobe PDF IFilter was only 32-bit.
> RLF
> "Camilo" <Camilo@.discussions.microsoft.com> wrote in message
> news:92BEFB18-89BF-4C7E-8B11-769B0C329B7B@.microsoft.com...
>
>
|||Check the gatherer logs to see what the status of your population was.
relevantNoise - dedicated to mining blogs for business intelligence.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Camilo" <Camilo@.discussions.microsoft.com> wrote in message
news:92BEFB18-89BF-4C7E-8B11-769B0C329B7B@.microsoft.com...
> My client is trying to use SQL Server Full Text Search to search PDFs
> stored
> in a varbinary(max) column. Full text search works fine for other
> Microsoft
> Office documents stored in the same table but it does NOT give back any
> results from the PDF documents.
> Following is a high-level view of what the client did:
> 1. Installed Adobe PDF IFilter 6.0
> 2. Ran the stored procedure sp_fulltext_service (as documented)
> 3. Restarted the server
> 4. Verified that the filter got properly installed by querying the system
> view
> sys.fulltext_document_types
> 5. Created a full text index on the table with the documents
> 6. Started a full population of the index
> 7. Ran a sample query with a string he knows is in the PDF file like the
> following:
> select * from documents where freetext(document, 'Review') and got no
> results
> back
> 8. Ran the same sample query with a string he knows is in some Word files
> like the
> following: select * from documents where freetext(document, 'SQL') the
> query
> returned several rows back as expected.
> Does anybody know what might be happening here?
> Thank you!
> Camilo Leon
>

An exception occurred while executing a Transact-SQL statement or batch

Hi,

i have a problem received from my client saying that she received an error that say : An exception occurred while executing a Transact-SQL statement or batch. There is no error code given in the error message. There is a additional infomation given: Timeout expired. timeout period elapsed prior to completion of the operation of the server is not responding. So can u advise me on this matter.

Thank You.

Regards,
S.PrathaIf you have a question about mysql you might get more responses if you post in the mysql forum instead of the misc forum.

-MODERATOR|||Hi Pratha. Welcome to The Scripts!

What type of software threw this exception?
What type of SQL server are you trying to connect to?
What programming language is the software written in?

Did you write any of this software yourself?
Do you have the code that is generating the error?

Do you have any information we can use to help you solve this?|||

Quote:

Originally Posted by Atli

Hi Pratha. Welcome to The Scripts!

What type of software threw this exception?
What type of SQL server are you trying to connect to?
What programming language is the software written in?

Did you write any of this software yourself?
Do you have the code that is generating the error?

Do you have any information we can use to help you solve this?

Atli has the patience of a saint!|||... this looks more like a MS SQL problem than a MySQL problem.|||Changed thread title to better describe the problem (did you know that threads whose titles do not follow the Posting Guidelines actually get FEWER responses?).

I'm going to go ahead and move this thread to the MS SQL forum, where our resident Experts will be better able to help you out.|||Timeout errors usually happen when something is running on the backend and doesnt return result to meet predefined deadline.
For example you are running a stored procedure that has to return some data to a front end application and setting on your connection says that it would wait for 30 seconds before timeout expired and error will be issued.

So you have to do several things to investigate this issue:
1. Check if application connects to the server with no problem.
2. Debug application and find where timeout happens and which command is sent to the server that is taking longer then expected.
3. Go back to the serve and see how long the same command actually runs on the server side and try optimizing if possible. It should include evaluation of a showplan and determine that you might need to create some indexes or maybe your server didnt have maintenance for a long time and you dont update statistics regularly. Could be a space issue or just some unattended process having exclusive lock on a table and can not release resources without intervention.
4. On application side you can extend timeout by setting it to 0 you will set waiting time to infinite until result will actually be returned back to the front end. Make sure that it is an only option you have left by trying to fix your problem with previous suggestions.

If everything I said here is gibberish to you try to find more experienced programmer to investigate an issue.

Thank you and good luck.

An established connection was aborted by the software in your host machine.

I am getting connection errors all over the place, in everything I'm doing related to native client and connection issues failing with my database. I have changed users, authentification from windows to sql, everything. The latest was when I tried to apply the properties of my existing OLE DB Connection editor, one that has been working fine up until today. Every time I try to reselect the database and table in the properties if this, it errors out with the below:

TITLE: Microsoft SQL Native Client

Communication link failure
TCP Provider: An established connection was aborted by the software in your host machine.

BUTTONS:

&Retry
Cancel

Here are my logs:
http://www.photopizzaz.biz/junk/logs.txt
print screens of various errors I have received on my remote SQL Server 2005 (Enterprise version):
http://www.photopizzaz.biz/junk/sqlserver_2005_errors_and_resolutions.doc

Have you checked if remote connections are enabled for your server and what network protocols are available?

Please open SQL Server Surface Area Configuration tool and click 'Surface Area Configuraiton for Services and Connections' to set those settings.

An established connection was aborted by the software in your host machine.

I am getting connection errors all over the place, in everything I'm doing related to native client and connection issues failing with my database. I have changed users, authentification from windows to sql, everything. The latest was when I tried to apply the properties of my existing OLE DB Connection editor, one that has been working fine up until today. Every time I try to reselect the database and table in the properties if this, it errors out with the below:

TITLE: Microsoft SQL Native Client

Communication link failure
TCP Provider: An established connection was aborted by the software in your host machine.

BUTTONS:

&Retry
Cancel

Here are my logs:
http://www.photopizzaz.biz/junk/logs.txt
print screens of various errors I have received on my remote SQL Server 2005 (Enterprise version):
http://www.photopizzaz.biz/junk/sqlserver_2005_errors_and_resolutions.doc

Have you checked if remote connections are enabled for your server and what network protocols are available?

Please open SQL Server Surface Area Configuration tool and click 'Surface Area Configuraiton for Services and Connections' to set those settings.

Alternatives to MS Outlook MAPI client

I want to be able to use SQLMail to send me alerts on
task failures, etc. Microsoft says we have to use a MAPI
client like MS Outlook to take advantage of this feature.
However, when I talk with my system administrators about
placing Outlook or similar mail clients on the server
they get all upset and scream about security. Are there
alternatives to Outlook that are more secure or less
intrusive or anything that would make the sa's happy and
still be able to use SQLMail?
This will give you some options...
http://www.karaszi.com/sqlserver/info_no_mapi.asp
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"Scott" <anonymous@.discussions.microsoft.com> wrote in message news:b64801c4376e$a48eaac0$a301280a@.phx.gbl...
> I want to be able to use SQLMail to send me alerts on
> task failures, etc. Microsoft says we have to use a MAPI
> client like MS Outlook to take advantage of this feature.
> However, when I talk with my system administrators about
> placing Outlook or similar mail clients on the server
> they get all upset and scream about security. Are there
> alternatives to Outlook that are more secure or less
> intrusive or anything that would make the sa's happy and
> still be able to use SQLMail?
|||Thanks Tibor for the information. I've downloaded
everything and I've gotten the mailing feature to work.
But when I setup the DBMaint SMTP Alerter I see that it
appears to be working also (through Profiler) but it
never sends an email? Any suggestions?

>--Original Message--
>This will give you some options...
>http://www.karaszi.com/sqlserver/info_no_mapi.asp
>--
>Tibor Karaszi, SQL Server MVP
>http://www.karaszi.com/sqlserver/default.asp
>
>"Scott" <anonymous@.discussions.microsoft.com> wrote in
message news:b64801c4376e$a48eaac0$a301280a@.phx.gbl...[vbcol=seagreen]
MAPI[vbcol=seagreen]
feature.[vbcol=seagreen]
about[vbcol=seagreen]
and
>
>.
>
|||Do you see and calls to xp_smtp_sendmail in the profiler trace?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
<anonymous@.discussions.microsoft.com> wrote in message news:b97601c437a6$fd4876e0$a101280a@.phx.gbl...[vbcol=seagreen]
> Thanks Tibor for the information. I've downloaded
> everything and I've gotten the mailing feature to work.
> But when I setup the DBMaint SMTP Alerter I see that it
> appears to be working also (through Profiler) but it
> never sends an email? Any suggestions?
> message news:b64801c4376e$a48eaac0$a301280a@.phx.gbl...
> MAPI
> feature.
> about
> and
|||Hi Tibor,
Is it possible to use Mozilla Thunderbird instead of
Outlook?

>--Original Message--
>This will give you some options...
>http://www.karaszi.com/sqlserver/info_no_mapi.asp
>--
>Tibor Karaszi, SQL Server MVP
>http://www.karaszi.com/sqlserver/default.asp
>
>"Scott" <anonymous@.discussions.microsoft.com> wrote in
message news:b64801c4376e$a48eaac0$a301280a@.phx.gbl...[vbcol=seagreen]
MAPI[vbcol=seagreen]
feature.[vbcol=seagreen]
about[vbcol=seagreen]
and
>
>.
>
|||I don't know... Is it MAPI compliant (extended for SQL Mail and Simple for Agent Mail)?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"Scott" <anonymous@.discussions.microsoft.com> wrote in message news:cb9d01c43933$782ff260$a401280a@.phx.gbl...[vbcol=seagreen]
> Hi Tibor,
> Is it possible to use Mozilla Thunderbird instead of
> Outlook?
> message news:b64801c4376e$a48eaac0$a301280a@.phx.gbl...
> MAPI
> feature.
> about
> and
|||I can't find anything that says it is or isn't a MAPI
client. I also can't find anything that shows somebody
using it for SQL Mail and Agent Mail.

>--Original Message--
>I don't know... Is it MAPI compliant (extended for SQL
Mail and Simple for Agent Mail)?
>--
>Tibor Karaszi, SQL Server MVP
>http://www.karaszi.com/sqlserver/default.asp
>
>"Scott" <anonymous@.discussions.microsoft.com> wrote in
message news:cb9d01c43933$782ff260$a401280a@.phx.gbl...[vbcol=seagreen]
on[vbcol=seagreen]
server[vbcol=seagreen]
there
>
>.
>
|||My guess is that it is not MAPI compliant. Just a guess, though...
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
<anonymous@.discussions.microsoft.com> wrote in message news:d2b901c439c3$b0afe560$a601280a@.phx.gbl...[vbcol=seagreen]
> I can't find anything that says it is or isn't a MAPI
> client. I also can't find anything that shows somebody
> using it for SQL Mail and Agent Mail.
> Mail and Simple for Agent Mail)?

Alternatives to MS Outlook for SQLMail

I want to be able to use SQLMail to send me alerts on
task failures, etc. Microsoft says we have to use a MAPI
client like MS Outlook to take advantage of this feature.
However, when I talk with my system administrators about
placing Outlook or similar mail clients on the server
they get all upset and scream about security. Are there
alternatives to Outlook that are more secure or less
intrusive or anything that would make the sa's happy and
still be able to use SQLMail?You can use xp_smtp_sendmail from www.sqldev.net
It isn't nearly as integrated as SQL Mail, but by adding a few steps to your
SQL Agent jobs, you can get most of the same functionality. It is very
stable and does exactly what the documentation says it does.
--
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Scott" <anonymous@.discussions.microsoft.com> wrote in message
news:b5e401c4376e$bd66d5e0$a601280a@.phx.gbl...
> I want to be able to use SQLMail to send me alerts on
> task failures, etc. Microsoft says we have to use a MAPI
> client like MS Outlook to take advantage of this feature.
> However, when I talk with my system administrators about
> placing Outlook or similar mail clients on the server
> they get all upset and scream about security. Are there
> alternatives to Outlook that are more secure or less
> intrusive or anything that would make the sa's happy and
> still be able to use SQLMail?|||"Scott" <anonymous@.discussions.microsoft.com> wrote in message
news:b5e401c4376e$bd66d5e0$a601280a@.phx.gbl...
> I want to be able to use SQLMail to send me alerts on
> task failures, etc. Microsoft says we have to use a MAPI
> client like MS Outlook to take advantage of this feature.
> However, when I talk with my system administrators about
> placing Outlook or similar mail clients on the server
> they get all upset and scream about security.
do you blame them ? installing Outlook on a database server is nuts ...|||http://www.aspfaq.com/2403
--
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"Scott" <anonymous@.discussions.microsoft.com> wrote in message
news:b5e401c4376e$bd66d5e0$a601280a@.phx.gbl...
> I want to be able to use SQLMail to send me alerts on
> task failures, etc. Microsoft says we have to use a MAPI
> client like MS Outlook to take advantage of this feature.
> However, when I talk with my system administrators about
> placing Outlook or similar mail clients on the server
> they get all upset and scream about security. Are there
> alternatives to Outlook that are more secure or less
> intrusive or anything that would make the sa's happy and
> still be able to use SQLMail?|||"Aaron Bertrand - MVP" <aaron@.TRASHaspfaq.com> wrote in message
news:uF33JP3NEHA.3124@.TK2MSFTNGP12.phx.gbl...
> http://www.aspfaq.com/2403
Aaron, I'm off-topic here but I notice you have an RSS feed on ASPFAQ; what
client do you recommend ? Thanks ...|||Should work in pretty much any, I don't have a personal preference...
--
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"Liz" <liz@.tiredofspam.com> wrote in message
news:eIpSqv3NEHA.3016@.tk2msftngp13.phx.gbl...
> "Aaron Bertrand - MVP" <aaron@.TRASHaspfaq.com> wrote in message
> news:uF33JP3NEHA.3124@.TK2MSFTNGP12.phx.gbl...
> > http://www.aspfaq.com/2403
> Aaron, I'm off-topic here but I notice you have an RSS feed on ASPFAQ;
what
> client do you recommend ? Thanks ...
>
>

Alternative to Merge Replication

I am involved in a development project of an enterprise level hosted application. The main product is a smart client application, and will soon have an embedded sql express option. At the moment I am building the WM 5.0 mobile application and have been advised against using merge replication to syncronize the databases.

The reasons have been that our main SQL 2005 database is on a hosted server that would have to open ports directly to the internet for the merge replication to do its thing. So far I have built some realy pain in the *** manual synchronization that loops through every table it needs to sync looking for a last modified time... pushing and pulling this way. This way it can pass DataSets through a web service just like the smart client app is working today.

Is Merge Replication acceptable or even safe in a situation like this? Any advice or opinions would be appreciated.

Thanks.

You do not need SQL Server to be on the internet for replication. Replication goes through IIS, so you only need IIS on the internet. You can use all security measures IIS offers including SSL and authentication to protect your data.

Keep in mind what whatever method you would choose, you have to have some open port for device to connect to. It's doubtful your home grown solution would be more secure than IIS which was around for years, tested by hackers, fixed and tested again. So, yes, replication should be appropriate for that.

|||

Ok, I understand what you are saying. Since it is hosted through IIS I guess we could avoid setting up IIS on our data boxes and create a virtual directory to the snapshot folder or whatever it exposed through IIS.

Another concern is filtering data. We have 6000 or so customers sharing one SQL server database and the data exposed to them is filtered through organization ID's and logins..., Is merge replication accessible through code (also the filters) or would each device have to be setup in SQL manually with a static view of data?

I'm sorry for the questions that might be ignorant, but I can't seem to find any good documentation on what situations merge replication is optimal for.

Thanks again.

|||

Excuse us for catching this up very lately.

You can use SqlCeReplication.HostName as your filter on SQL Server. You can use HOST_NAME() function on the SQL Server filter which would then replaced byt the SqlCeReplication.HostName to know which records this device/client is interested in.

I am sure there will be many more question that would arise and I sincerely request you to go through the resources available and get prepared for better questions!

Resources are listed out @. http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=295034&SiteID=1

Thanks,

Laxmi

Alternative to IPSec?

The client I'm working with has a 2-node Failover cluster. Owing to their
environment, they have several machines accessing the many databases. For
cost reasons, they went with SQL standard.
As to securing the traffic. I understand that IPSec isn't supported for
failover cluster, owing to the recovery time (6 minutes, according to the
document).
But the recovery for SQL standard doesn't allow external connections until
all databases are recovered. If the server has a lot of databases (perhaps
50), there may already be a delay.
I guess the questions I'm asking are:
1>Outside of the time delay, is there any other reasons to avoid IPSec?
2>In an environment with a lot of potential clients, what are the
recommended alternatives?
Thanks for any insight!
Bob Coppedge
me (at) RLCoppedge (put a dot here) com
IPSec can be processor intensive; so, offloading the encryption to an
outside engine would increase throughput. This could be through a support
NIC with these features, or a dedicated hardware appliance.
Short of that, you could use SSL encryption and/or HTTPS for communication.
Microsoft provides a good document on the subject through MSDN:
http://www.microsoft.com/downloads/details.aspx?displaylang=en&familyid=055ff772-97fe-41b8-a58c-bf9c6593f25e
Good luck.
Sincerely,
Anthony Thomas

"RL Coppedge" <RLCoppedge@.hotmail.com.(nospam)> wrote in message
news:28CF43D3-38DC-47A8-9C46-CC25D1A01150@.microsoft.com...
> The client I'm working with has a 2-node Failover cluster. Owing to their
> environment, they have several machines accessing the many databases. For
> cost reasons, they went with SQL standard.
> As to securing the traffic. I understand that IPSec isn't supported for
> failover cluster, owing to the recovery time (6 minutes, according to the
> document).
> But the recovery for SQL standard doesn't allow external connections until
> all databases are recovered. If the server has a lot of databases
(perhaps
> 50), there may already be a delay.
> I guess the questions I'm asking are:
> 1>Outside of the time delay, is there any other reasons to avoid IPSec?
> 2>In an environment with a lot of potential clients, what are the
> recommended alternatives?
> Thanks for any insight!
> Bob Coppedge
> me (at) RLCoppedge (put a dot here) com
>