Setting Up SQL-mail In WinXP
Oct 17, 2006I would need to use sql-mail for alerts etc on an SQL server installed on an Windows XP machine. IIS is installed. Is that possible and in that case how? Can I use POP-account for it?
Björn
ADVERTISEMENT
Setting Up SQL Mail
May 2, 2000Can someone point me in the direction of a good place to find out how to set this up properly please.
thanks
Setting Up SQL Mail
Dec 4, 1999Hi
I am using Windows NT 4.0, SQL Server 6.5 and Exchange 5.0. I would like to setup SQL mail.
I tried to create mail login, NT expects for MS mail server name and login.
When i enter my exchange server/login name does not recoganise.
Any guide please.. Thanks in advance
Moorthy
Setting Up SQL Mail
Jul 20, 2005How do you setup SQL Mail? I tried following the procedures on theonline manual but I do not understand what "On the instance of SQLServer, start the mail client using the newly created mail profile."means. What is the mail client? I have already setup the mail profilebut when I go to SQL Mail on Services and try setting it up, the profileI created is not showing on the pull down list.I appreciate any assistance.Thanks.*** Sent via Developersdex http://www.developersdex.com ***Don't just participate in USENET...get rewarded for it!
View 1 Replies View RelatedSetting Up SQL Mail In SQL2000
Jan 4, 2001We are running SQL2000 on Windows2000 with Outlook2000.
The SQL Server machine is logged into as Administrator.
I've set up a mailbox called MyMailBox on the above server. I've also set up a profile called MyMailProfile on the server. They are the only Mailbox and profile on this machine and are setup correctly (by our network admin guy).
In services i've set the SQLServerAgent to login as Administrator.
Problems:-
(1) I then try to set the SQLMail profile name in SQL Server but MyMailProfile doesn't appear in the list (it's blank) ? I can type it in but when clicking the test button i get the following message - 'error 18025....failed with mapi error' any ideas ??
(2) If i try to set up an operator when i choose myself from the list and click test it says 'this will send a message to Paul etc'...which is fine but when i then click OK i get the message 'error 22022 SQLServerAgent error: The SQLSserverAgent mail session is not running, check the mail profile and/or the SQLServerAgent service startup account in the SQLServerAgent properties dialog.' so OK i can do that...
(3) ...in the mail session of the SQLServerAgent properties i have entered MyMailProfile and the service startup account is Administrator. The problem in number (2) is the same ??
I have also checked the services - the MSSQLServer service is logged on using local system account whereas SQLServerAgent is logged on using Administrator - is that a problem ?
From here i'm stuck.
Why doesn't it work ? Is it something to do with NT permissioning ?
Does anyone know a good on-line source to help with setting up SQL Server Mail ?
thanks for any help.
SQL Mail Error While Setting Up......URGENT!!!
May 24, 2000Any help on the following error which I am getting when I am trying to set up SQL Mail for Internet Mail with Outlook Express?
Error 22030: A Mapi error(error no 271)occured.Unable to get the default MAPI Message store due to mapi error 271:One or more of the receipients was not found in the address book.
Thanks!
Need Help In Setting Up Sql Mail On Sql Server 2000
May 6, 2001Iam not sure why Iam not able to successfully set up sql mail. here are the steps I follow:
1. I Created a user account and password to be used for sql server and sql agent as a service account.( Domain Namesqlservice )
2. Logged off window 2000 then log in with the same account I created in step one.
3. double clicked mail icon in control panel to set up a mail account by specifying the following:
pop :pop.erols.com
smtp: smtp.erols.com
I choose POP instead of IMAP to set up the mail account
4.tested the account by opening Outlook and was able to send and recieve mail via Outlook.
So far so good
I assume that I have already (a)created a service account to be used for sql server and sql agen mail account (b) created a mail account (c)tested the mail.
5. I opened sql server and clicked on the mail in the management console to test the sql mail by typing the same mail account in the text box, then clicking test.... I got an error message the MAPI is not set up and it is not connecting to any profile.
another error I got was Error :xp_mapi profile : failed with mail error 0x80040106
Here are some questions that I am not sure about.
Q1. Do I need to set up smtp service in service tab to use same account as sql server/ sql agent. It is using local system account now
Q2. the above steps are correct, I guess so, so what is the reason not being able to set up the mail profile to be used by sql server mail
Thanks for your help
Ali
WInXP SP2 Issue
Oct 17, 2004I recently updated my Windows XP to SP2 and I ran in to trouble on my network and my web apps-they suddenly were not able to find or open by sql server db. I did a system restore and all was fine. Any idea what might have caused that?
Thanks!
SQL Express && WinXP
May 29, 2006Because IIS is needed for the Reporting Services, is it true then that I can't access this feature with Windows XP Home Edition. When installing SQL Express with Advanced features, it errored saying that IIS needs to be installed.
Thanks for your help
Ken
Cannot Install MSDE In Winxp Pro Sp2
May 17, 2007Dear all
I want to install the MSDE 2000 sp3 or sp4, and using this command "c:sql2ksp3MSDE> setup aspwd ="astrongpwd" "....but it failed during the installation ." Setup failed to configure the server. Refer to the server error logs and setup error logs for more information" this message is shown on final............And then, i go the event log to see what message, it show "17112 Invalid command option q.".............anyone know what happen....can tell me where can find the solution....thank you very much
regards
SQLEXPR_ADV.EXE Does Not Detect WinXP SP1
May 17, 2006Running SQLEXPR_ADV.EXE against Windows XP SP0 causes the setup to exit gracefully with a message indicating the the right service pack is not installed.
However, running SQLEXPR_ADV.EXE against Windows XP SP1 does not exit and continues to install. Then, when you try to run a script against the installation, you get the message:
[Microsoft][ODBC SQL Server Driver][DBMSLPCN][SQL Server does not exist or access denied].
This will become very problematic when installing SQL Server Express as the database for small installations.
The setup really needs to be updated to look for all the system requirements that it can detect. Evidently it can detect the Service Packs. The Wise Installer is not able to script that requirements unless there is some way to make the Windows Installer look for it that is not documented.
Pat
How To Install SQL Server 2000 On WinXP SP2
Jan 5, 2007I am try to install SQL Server 2000 on XP OS, but every time it showing only client version can be install to your current oprating system. Is there any patch or service pack to intstall SQL Server 2000 on XP SP2 based system?
View 1 Replies View RelatedInstalling SQL2k Enterprise On WinXP
Jun 4, 2004greetings!
need suggestions on installing SQL2k enterprise edition on my laptop with WinXP Pro...
everytime i run the SQL installation setup,.. it says that "SQL server is not supported on your operating system.Only client components will be installed"
I was able to install alright, but I want to install "server tools" because I want to learn XML/SQL.
im installing it on my laptop by the way.
what is required so the installation would let me install both Server and Client tools?
thank you very much in advance.
regards,
pparker
Multiple MSDE Instances In WinXP SP2
Mar 17, 2007I have installed two mssql 2000 MSDE sp4 instances on WinXP SP2.
I can connect both instances from local machine.
But when I try from remote PC, I can only connect to one with default instance name and can't connect to another one ComputerNameInstanceName.
I set the windows firewall off in WinXPSP2. But still can't connect.
I also try with mssql2000 MSDE sp3 instances. It is same ask sp4.
Please help!!!!!!
SQL 2000 Installation On WinXP Pro Problems
Sep 19, 2005I'm trying to install SQL 2000 Standard on WinXP Pro; I only need toinstall the Enterprise Manager and the Query Analyser. Early in theinstallation I get the messageA previous program installation created pending fileoperations on the installation machine.You must restart the computer before running setup.I've restarted the machine a few times and have even uninstalledsoftware that I thought suspicious. I know what the error messagemeans but I have no idea how to solve this problem. Any help would begreatly appreciated.Thanks,DavidP.S.: Could Spybot be the culprit?
View 3 Replies View RelatedWinXP, SQL Server 2000, Queries
May 8, 2006Hi,Does anyone know if MS SQL Server 2000, will run stability on a WindowsXP based O/S, using one of the new Dual Core chips, or HT chips?Especially given that when you install it you get compatabilitywarnings?ThanksDavid
View 2 Replies View RelatedConcurrent User On WinXP Prof
Nov 21, 2007When running MS SQL Server on a Windows XP Pro OS, is there a limit to the number of concurrent users or connections to the database? We want to run server for education in the high school (MS Select licence), we need 16 concurrent connections.
Thanks for any help.
Installing SQL Server 2000 On WinXP Pro
Oct 3, 2007Hello, I have the JDE One World application installed on my computer which is XP PRO SP2. When I open Enterprise Manager, I can go to my local machine as a server, expand it, and see all the JDE databases. I can create a new database and connect to it. However, I cannot install SQL Server 2000 on other XP Pro machines. How can I do this? This is SQL Server 2000 STANDARD. Thank you.
View 1 Replies View RelatedInstall Sql2000 Developer In Winxp Pro Servicepack1
Sep 1, 2004Newbie:
May I ask you a question:
It is Ok to install sql server 2000 developer edition on winxp?
thanks
Cannot Install SQL Server 2005 CTP On WinXP Pro Machine
Sep 7, 2005Hi all,
View 3 Replies View RelatedLinked Server/DTC Error In WinXP Vs Win2003Server
Mar 1, 2006Client side: WinXP Pro with MSDE 2000
Server side: Win2003 Server with SQL Server 2000
I've got the error message when creating linked server and running the DTC across two database servers, ""Error 18452: Login failed for user 'sa'. Reason: Not associated with a trusted SQL Server connection."
But, orginially, if the Server side is Win2000 Server with SQL Server 2000, everything is okay. When I migrate it to the Win2003Server platform, this thing happened.
I've also applied the following solution but it still doesn't work.
http://support.microsoft.com/default.aspx?scid=kb;en-us;827805http://support.microsoft.com/default.aspx?scid=kb;en-us;827805
and
http://support.microsoft.com/?kbid=873160
and the login mode is set to Mixed mode.
Many thanks.
Backup Win98 Files And Restoring To Winxp?
Nov 25, 2006I have some bookkeeping files that were saved using win98 backup that i need to restore to my accounting program on my winxp computer.. i have no idea how to do that. The files that are backed up belong to the same program on both the win98 and winxp.
View 1 Replies View RelatedCreating Databases On WinXP SP2 With SQL Server 2005 CE RC
Nov 28, 2006Hi,
For various reasons a new desktop application I am developing is using the SQL Server 2005 Compact Edition Release Candidate to store local data. On my development machine (XP SP2, VS2005, SQL Server 2005 Developer Edition) the software is able to create the database file, and read and write to it fine.
However on our test machine, which does not have any of the development tools the software is unable to create the database. A System.Data.SqlServerCe.SqlCeException is thrown. The message is: "SQL Mobile usage is restricted on this platform. To use SQL Mobile, you must install SQL Server 2005, Visual Studio 2005, or the Tablet PC SKU." Obviously this goes somewhat against the blurb for SQL Server CE.
Is this something that will be fixed shortly? Or is it the intention that databases can't be created on machines that do not SQL Server or Visual Studio installed? (Incidentally the reason for creating the database on the fly is that we are encrypting it, using the users credentials, so that only they can open the database.)
Thanks, Steve
Cannot Install SQL Server 2005 Standard WinXP Pro SP2
Feb 16, 2007Hello,
I have SQL Server 2000 Developer Edition already installed. Before starting
the SQL Server 2005 Standard setup, I exited the SQL server agent running in
my system tray.
I am logged on as Administrator and no other desktop apps are running. SQL
Server 2005 Setup reports several "Setup failed." error messages after the
install. I am choosing (for now) ONLY the workstation tools and books online
check mark. The installation presents a screen that says that these products
were successfully installed ("Setup finished"):
- MSXML6
- OWC11
- SQL Server Backward-Compatibility Files
However, these items have a red x next to them:
- SQL Server Books Online
- SQL Server Support Files
- SQLXML4
- SQL Native Client
- Workstation Components, Books Online, ...
My Setup log file terminates with a few messages--one of which contains the
words "Configuration failed." (This is the ONLY mention of the word "fail" in
the Setup log--see the excerpt below.)
Any ideas??? I'm stuck without SQL Server 2005 running so this is a
productivity killer for me.
More info: Here is what I have done, to no avail:
1) Installed the OWC11 components using a direct download from Microsoft.
That install worked. But when it runs again from the SQL Server 2005 DVD, it
fails.
2) Logged on not as a user with Admin rights, but as ADMINISTRATOR. Same
results--the SQL Server 2005 Standard setup failed.
3) Installed SQL Server 2005 Express successfully. Afterwards, tried again
to install SQL Server 2005 Standard, and that setup failed.
4) Cleared registry values for SQL Server 2005 under HKLM.../Software as
described in KB article. Also deleted the installation folder ...90. Tried
again to install SQL Server 2005 Standard, and that setup failed.
5) Tried the 180-day trial of SQL Server 2005 Enterprise--to no avail. Same
results.
Found error logs but they did not help me pinpoint the root cause for the
failed installation.
Thank you,
-- Jonathan
SQLSetup0004_zzzzz_SQLNCLI_1.log Excerpt:
============================+
MSI (s) (60:90) [12:01:14:390]: Note: 1: 1729
MSI (s) (60:90) [12:01:14:406]: Product: Microsoft SQL Server Native Client
-- Configuration failed.
MSI (s) (60:90) [12:01:14:406]: Cleaning up uninstalled install packages, if
any exist
MSI (s) (60:90) [12:01:14:406]: MainEngineThread is returning 1603
MSI (s) (60:68) [12:01:14:406]: Destroying RemoteAPI object.
MSI (s) (60:9C) [12:01:14:406]: Custom Action Manager thread ending.
=== Logging stopped: 2/8/2007 12:01:14 ===
MSI (c) (8C:4C) [12:01:14:406]: Decrementing counter to disable shutdown. If
counter >= 0, shutdown will be denied. Counter after decrement: -1
MSI (c) (8C:4C) [12:01:14:406]: MainEngineThread is returning 1603
=== Verbose logging stopped: 2/8/2007 12:01:14 ===
Problems (re)installing SQL Server 2005 In WinXP Pro
Jul 24, 2006I am attempting to install the Standard edition on a WinXP pro laptop that apparently had this installed before I got it. I Removed, thru Add/Remove, everything related to SQL Server. When I tried to do a fresh install of DB Services, Integration Services and Client tools, Setup Support and the Native Client seems to install ok, the directories get created and some files are put there. The installer stops and sez that the Databases Services and the Workstation Components are already installed, the Details button tells me that the only available option are thru the Add/Remove Programs. There are no entries for the Server or Client Tools on Add/Remove's list.
When I try to start the server it fails with "can't find the Path" reported in an Error Event, likewise I can't start the Management Studio because it can't find a file.
I think that I need to clean everything out to reinstall. I think that the Services are left over from the previous owner. Any suggestions???
joe elsaesser
My Connection String Doesn't Work After Installing WinXP Sp2
Mar 13, 2005Hi all,
Recently i have installed (winxp sp2) and i have encountered with some
problems, for example i always use the following Connection string for
connecting to SqlServer 2000 and work with it:
"Server=localhost;database=Test;Trusted_Connection=yes"
But now this string doesn't work and after some minutes i found out the solution as follows:
"Server=MYPCNAME;database=Test;Trusted_Connection=yes"
or
"Server=(local);database=Test;Trusted_Connection=yes"
or
"Server=.;database=Test;Trusted_Connection=yes"
(Note that my computer name really is "MYPCNAME")
Between three above solutions i want to know why "Server=MYPCNAME" work properly
BUT "Server=localhost" doesn't work after installing WinXP SP2.
Thanks in advanced.
Problems Of Installing MSDE2000 In WinXP Home Edition
Apr 12, 2005My Problems & Situation:Hi! I am a ASP.NET starter. My platform is WinXP Home Edition and I haven't installed any version of SQL server before.I download different version of MSDE and extracted in my C drive separately, including: 1. Microsoft SQL Server 2000 Desktop Engine (MSDE 2000) Release A 2. Microsoft SQL Server 2000 Service Pack 3a (contained MSDE 2000) 3. MSDE 2000 for Developers Using Visual Studio .NETsince all of the above versions have the same problem when I try to install it.
The problem is that when I double click each of the setup.exe, it will show a pop up error:[A strong SA password is requires for security reasons. Please use SAPWD switch to supply the same. Refer to readme for more details. Setup will now exit.]
Then I found a solution from Microsoft, it told me that: 1. Run the setup in the command prompt 2. Locate in the extracted path 3. type --> "Setup.exe /qb+ INSTANCENAME=NetSDK DISABLENETWORKPROTOCOLS=1 SAPWD=<pwd>"
p.s. I have changed the <pwd> to 123abc
However....another Error Occur:1st pop up --> [Unable to determine system default collation.]2nd pop up --> [Microsoft SQL Server Desktop Engine Setup failed.]
My Question:1. Why the error still occour when I type that command to setup? (Solution from Microsoft)2. How can I fix it and complete the installation?3. How many users(maximum) can be created in a MSDE database?
Greateful if anyone can give me hand.
User Credentials Delegation From IIS On WinXP To SQL Server On Win2003SRV Fails
Jan 12, 2007Problem:
I am trying to create an asp.net website with integrated windows authentication
to access SQL databases. IIS resides on WinXP and SQL Server
on Win2000 SRV. Both are in the same NT Domain. IIS and SQL Server cannot
reside on the same machine and a stand alone web server is
ideal as the website needs to access multiple SQL Servers. IIS is set to
Integrated Windows Authentication. The machine running IIS & the SQL Server
are set to be "trusted for delegation" in active directory. The domain user
accounts that will be accessing the databases are not marked as "Account
is sensitive and cannot be delegated".
The connection string that the web app uses to connect to SQL database is:
"Data Source=PWSSQLT;Integrated Security=SSPI;Initial Catalog=Pace_Master;Persist Security Info=true"
with which the user credentials should be flown to the SQL database.
But instead the delegation fails and results in the following ANONYMOUS authentication failure error:
Login failed for user 'NT AUTHORITYANONYMOUS LOGON'.
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: Login failed for user 'NT AUTHORITYANONYMOUS LOGON'.
Source Error:
// Open the connection, and return it
oConn.Open();
return oConn;
Source File: e:ING eIMSApp_CodeDataAccessConnectionManager.cs
Stack Trace:
[SqlException (0x80131904): Login failed for user 'NT AUTHORITYANONYMOUS LOGON'.]
System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader
dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK)
System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject,
SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance)
System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity,
SqlConnectionString connectionOptions, Object providerInfo, String newPassword,
SqlConnection owningObject, Boolean redirectedUserInstance)
System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options,
Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection)
System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection
owningConnection, DbConnectionPool pool, DbConnectionOptions options)
System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject)
System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject)
System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)
System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection,
DbConnectionFactory connectionFactory) +105
System.Data.SqlClient.SqlConnection.Open()
INGRS.DataAccess.ConnectionManager.GetConnection() in e:ING eIMSApp_CodeDataAccessConnectionManager.cs:
DAActivity.Page_Load(Object sender, EventArgs e) in e:ING eIMSDADAStatusDAActivity.aspx.cs
System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e)
System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e)
System.Web.UI.Control.OnLoad(EventArgs e)
System.Web.UI.Control.LoadRecursive()
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
_______________
Version Information: Microsoft .NET Framework Version:2.0.50727.42; ASP.NET Version:2.0.50727.210
---------------------
SQL Server Does Not Exist Or Access Denied. Error While Moving App From Winxp To Win2003
Mar 28, 2005hi,
I have an asp.net application which queries an sql server in some other domain and populates a grid with the results.
i am using sql server authentication and my connection string is as follows:-
Dim connectionString As String = "server=emr01; user id='private'; password='private'; database='NGEMRDev'"
i have also used the following tag in web.config:-
<identity impersonate="true" />
This works fine on my development pc i.e windows xp with sp2 .
but when i tried running the same application in windows 2003 the query gives the following exception:-
Server Error in '/TempDel' Application.
SQL Server does not exist or access denied.
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: SQL Server does not exist or access denied.Source Error:
Line 77: dataAdapter.SelectCommand = dbCommand
Line 78: Dim dataSet As System.Data.DataSet = New System.Data.DataSet
Line 79: dataAdapter.Fill(dataSet)
Line 80:
Line 81: Return dataSetSource File: c:inetpubwwwroot empdelemrtempdel.aspx Line: 79 Stack Trace:
[SqlException: SQL Server does not exist or access denied.]
System.Data.SqlClient.ConnectionPool.GetConnection(Boolean& isInTransaction) +472
System.Data.SqlClient.SqlConnectionPoolManager.GetPooledConnection(SqlConnectionString options, Boolean& isInTransaction) +372
System.Data.SqlClient.SqlConnection.Open() +384
System.Data.Common.DbDataAdapter.QuietOpen(IDbConnection connection, ConnectionState& originalState) +44
System.Data.Common.DbDataAdapter.FillFromCommand(Object data, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +304
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +77
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) +38
ASP.EmrTempDel_aspx.MyQueryMethod(String username) in c:inetpubwwwroot empdelemrtempdel.aspx:79
ASP.EmrTempDel_aspx.Button2_Click(Object sender, EventArgs e) in c:inetpubwwwroot empdelemrtempdel.aspx:89
System.Web.UI.WebControls.Button.OnClick(EventArgs e) +108
System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +58
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +18
System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +33
System.Web.UI.Page.ProcessRequestMain() +1292
Version Information: Microsoft .NET Framework Version:1.1.4322.2032; ASP.NET Version:1.1.4322.2032
Please help me as to how do i successfully implement my application in the windows 2003 server. i have given the aspnet user on the win2003 admin rights.
Is 2005 Merge Replication Reliable For Compact Edition Subscribers On WinXP Tablets Over VPN?
Oct 24, 2007
I posted a more detailed technical question a couple of weeks ago
with Subject = "Compact Edition 2005 Subscribers - Merge Agent failed after detecting that retention-based cleanup has deleted metadata"
But I got no replies.
Now my question is simpler: Is SQL Server 2005 Merge Replication reliable with Compact Edition subscribers on WindowsXP tablets?
We deleted all users' local databases a couple of weeks ago, and republished two publications with retention = 60 days.
Now we have at least one user who can't sync with the server, and replication monitor shows the error below.
But if she e-mails her sdf file to a support person, they can successfully sync her database.
We're sure that it's not a permissions issue, which is a normal suspicion when one user can perform a task that another can not.
It doesn't seem like a retention problem, because she's well inside the retention period.
She can successfully sync with the publication with upload/download tablers, but not with the publication with download only tables. Both publications were created on the same day, by the same DBA, with nearly identical properties.
This problem user has operated in the past with no problem, and she's configured identically to all of the others. It just seems like random flakyness with merge replication for Compact Edition subscribers.
I feel stupid saying that, because it sounds like I believe in a magical ghost in the machine. So my question is - IS MERGE REPLICATION A LITTLE BIT FLAKY FOR COMPACT EDITION SUBSCRIBERS ON XP MACHINES?
We've applied SP2 to the server, but no subsequent HotFixes.
We're trying to sell users and management on developing a larger occasionally connected system with the same replication scheme, so we need to know if it deserves our confidence.
Error messages:
The Merge Agent failed after detecting that retention-based metadata cleanup has deleted metadata at the Publisher for changes not yet sent to the Subscriber. You must reinitialize the subscription (without upload). (Source: MSSQL_REPL, Error number: MSSQL_REPL-2147199402)
Get help: http://help/MSSQL_REPL-2147199402
Integration Services :: Sending Mail With HTML Format In Send Mail Task
Aug 18, 2015I have to send mail with HTML format and attaching multiple files dynamically via send mail task.
View 10 Replies View RelatedDB Mail And Notify Operator Through DB Mail Error Could Not Retrieve Item From The Queue
Feb 2, 2007I've set up DB mail and sent a test e-mail and that comes through fine.
I set up an Operator with email Name: DWhelpton@k-and-s.com;MWeaver@k-and-s.com
I created a job and set up the notifications to e-mail the operator on failure.
When the job runs and fails, I do not get an e-mail and I get the following exception in the db mail log:
Date 2/2/2007 8:35:00 AM
Log Database Mail (Database Mail Log)
Log ID 402
Process ID 3936
Last Modified 2/2/2007 8:35:00 AM
Last Modified By NT AUTHORITYSYSTEM
Message
1) Exception Information
===================
Exception Type: Microsoft.SqlServer.Management.SqlIMail.Server.Common.BaseException
Message: Could not retrieve item from the queue.
Data: System.Collections.ListDictionaryInternal
TargetSite: Microsoft.SqlServer.Management.SqlIMail.Server.Controller.ICommand CreateSendMailCommand(Microsoft.SqlServer.Management.SqlIMail.Server.DataAccess.DBSession)
HelpLink: NULL
Source: DatabaseMailEngine
StackTrace Information
===================
at Microsoft.SqlServer.Management.SqlIMail.Server.Controller.CommandFactory.CreateSendMailCommand(DBSession dbSession)
at Microsoft.SqlServer.Management.SqlIMail.Server.Controller.CommandFactory.CreateCommand(DBSession dbSession)
at Microsoft.SqlServer.Management.SqlIMail.Server.Controller.CommandRunner.Run(DBSession db)
at Microsoft.SqlServer.Management.SqlIMail.IMailProcess.ThreadCallBack.MailOperation(Object o)
What step am I missing?
XP_sendmail Puts Copy Of Mail In Sent Mail Of Exchange Client.
Jul 9, 2001I am using nt4.0 sp5 with sql7.0 sp3 and exchange client.
Does anyone know how to keep xp_sendamil form putting a copy of the mail message in the sent mail folder or an automated process for deleting all mail in the sent folder? As it stands now I must manually delete all messages from the sent mail folder on a daily basis.
Thanks,
Ed.