Outlook vs Outlook Express on SQL server

I wanted to know if there was any difference in having Outlook or Outlook
Express installed on the SQL server machine if it is used for parsing emails
and for job failure notifications with in the SQL Agent.
thanks
Meenal
Meenal,
Please read:
INF: How to Configure SQL Mail
http://support.microsoft.com/default...b;en-us;263556
esp. " Because Microsoft Outlook Express does not create a Mail profile,
Outlook Express will not work with SQL Mail."
HTH
Jerry
"Meenal Dhody" <meenal_dhody@.hotmail.com> wrote in message
news:uYBJ3Y10FHA.2076@.TK2MSFTNGP14.phx.gbl...
>I wanted to know if there was any difference in having Outlook or Outlook
> Express installed on the SQL server machine if it is used for parsing
> emails
> and for job failure notifications with in the SQL Agent.
>
> thanks
> Meenal
>
|||Thank you - that was exactly the kind of information I was looking for.
thanks
Meenal
"Jerry Spivey" <jspivey@.vestas-awt.com> wrote in message
news:e$pGtm20FHA.2312@.TK2MSFTNGP14.phx.gbl...
> Meenal,
> Please read:
> INF: How to Configure SQL Mail
> http://support.microsoft.com/default...b;en-us;263556
> esp. " Because Microsoft Outlook Express does not create a Mail profile,
> Outlook Express will not work with SQL Mail."
> HTH
> Jerry
>
> "Meenal Dhody" <meenal_dhody@.hotmail.com> wrote in message
> news:uYBJ3Y10FHA.2076@.TK2MSFTNGP14.phx.gbl...
>
sql

Outlook vs Outlook Express on SQL server

I wanted to know if there was any difference in having Outlook or Outlook
Express installed on the SQL server machine if it is used for parsing emails
and for job failure notifications with in the SQL Agent.
thanks
MeenalMeenal,
Please read:
INF: How to Configure SQL Mail
http://support.microsoft.com/default.aspx?scid=kb;en-us;263556
esp. " Because Microsoft Outlook Express does not create a Mail profile,
Outlook Express will not work with SQL Mail."
HTH
Jerry
"Meenal Dhody" <meenal_dhody@.hotmail.com> wrote in message
news:uYBJ3Y10FHA.2076@.TK2MSFTNGP14.phx.gbl...
>I wanted to know if there was any difference in having Outlook or Outlook
> Express installed on the SQL server machine if it is used for parsing
> emails
> and for job failure notifications with in the SQL Agent.
>
> thanks
> Meenal
>|||Thank you - that was exactly the kind of information I was looking for.
thanks
Meenal
"Jerry Spivey" <jspivey@.vestas-awt.com> wrote in message
news:e$pGtm20FHA.2312@.TK2MSFTNGP14.phx.gbl...
> Meenal,
> Please read:
> INF: How to Configure SQL Mail
> http://support.microsoft.com/default.aspx?scid=kb;en-us;263556
> esp. " Because Microsoft Outlook Express does not create a Mail profile,
> Outlook Express will not work with SQL Mail."
> HTH
> Jerry
>
> "Meenal Dhody" <meenal_dhody@.hotmail.com> wrote in message
> news:uYBJ3Y10FHA.2076@.TK2MSFTNGP14.phx.gbl...
> >I wanted to know if there was any difference in having Outlook or Outlook
> > Express installed on the SQL server machine if it is used for parsing
> > emails
> > and for job failure notifications with in the SQL Agent.
> >
> >
> > thanks
> > Meenal
> >
> >
>

Outlook vs Outlook Express on SQL server

I wanted to know if there was any difference in having Outlook or Outlook
Express installed on the SQL server machine if it is used for parsing emails
and for job failure notifications with in the SQL Agent.
thanks
MeenalMeenal,
Please read:
INF: How to Configure SQL Mail
http://support.microsoft.com/defaul...kb;en-us;263556
esp. " Because Microsoft Outlook Express does not create a Mail profile,
Outlook Express will not work with SQL Mail."
HTH
Jerry
"Meenal Dhody" <meenal_dhody@.hotmail.com> wrote in message
news:uYBJ3Y10FHA.2076@.TK2MSFTNGP14.phx.gbl...
>I wanted to know if there was any difference in having Outlook or Outlook
> Express installed on the SQL server machine if it is used for parsing
> emails
> and for job failure notifications with in the SQL Agent.
>
> thanks
> Meenal
>|||Thank you - that was exactly the kind of information I was looking for.
thanks
Meenal
"Jerry Spivey" <jspivey@.vestas-awt.com> wrote in message
news:e$pGtm20FHA.2312@.TK2MSFTNGP14.phx.gbl...
> Meenal,
> Please read:
> INF: How to Configure SQL Mail
> http://support.microsoft.com/defaul...kb;en-us;263556
> esp. " Because Microsoft Outlook Express does not create a Mail profile,
> Outlook Express will not work with SQL Mail."
> HTH
> Jerry
>
> "Meenal Dhody" <meenal_dhody@.hotmail.com> wrote in message
> news:uYBJ3Y10FHA.2076@.TK2MSFTNGP14.phx.gbl...
>

outlook express with SQL server 2000

Hi ,
Can i know if outlook express is able to work with SQL server 2000 ?
i have created a acct but sql mail not able to find that profile
tks & rdgs
Hi
No. Only full Outlook.
http://support.microsoft.com/default...b;en-us;263556
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"maxzsim" wrote:

> Hi ,
> Can i know if outlook express is able to work with SQL server 2000 ?
> i have created a acct but sql mail not able to find that profile
> tks & rdgs
>
|||Just as a follow up to Mikes answer:
http://support.microsoft.com/default...311231&sd=tech
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> schrieb im Newsbeitrag
news:6A471B90-25E4-4FAE-80EB-BCE1C997B3FA@.microsoft.com...[vbcol=seagreen]
> Hi
> No. Only full Outlook.
> http://support.microsoft.com/default...b;en-us;263556
> --
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
>
> "maxzsim" wrote:
|||"maxzsim" <maxzsim@.discussions.microsoft.com> wrote in message
news:7D00E3BD-B7D7-405A-B891-FE823F4BBB93@.microsoft.com...
> Can i know if outlook express is able to work with SQL server 2000 ?
> i have created a acct but sql mail not able to find that profile
AFAIK you must install and configure Outlook (not Express) to get SQLMail
running.
Regards, Wojtek
sql

outlook express with SQL server 2000

Hi ,
Can i know if outlook express is able to work with SQL server 2000 ?
i have created a acct but sql mail not able to find that profile
tks & rdgsHi
No. Only full Outlook.
http://support.microsoft.com/defaul...kb;en-us;263556
--
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"maxzsim" wrote:

> Hi ,
> Can i know if outlook express is able to work with SQL server 2000 ?
> i have created a acct but sql mail not able to find that profile
> tks & rdgs
>|||Just as a follow up to Mikes answer:
http://support.microsoft.com/defaul...;311231&sd=tech
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
--
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> schrieb im Newsbeitrag
news:6A471B90-25E4-4FAE-80EB-BCE1C997B3FA@.microsoft.com...[vbcol=seagreen]
> Hi
> No. Only full Outlook.
> http://support.microsoft.com/defaul...kb;en-us;263556
> --
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
>
> "maxzsim" wrote:
>|||"maxzsim" <maxzsim@.discussions.microsoft.com> wrote in message
news:7D00E3BD-B7D7-405A-B891-FE823F4BBB93@.microsoft.com...
> Can i know if outlook express is able to work with SQL server 2000 ?
> i have created a acct but sql mail not able to find that profile
AFAIK you must install and configure Outlook (not Express) to get SQLMail
running.
Regards, Wojtek

outlook express with SQL server 2000

Hi ,
Can i know if outlook express is able to work with SQL server 2000 ?
i have created a acct but sql mail not able to find that profile
tks & rdgsHi
No. Only full Outlook.
http://support.microsoft.com/default.aspx?scid=kb;en-us;263556
--
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"maxzsim" wrote:
> Hi ,
> Can i know if outlook express is able to work with SQL server 2000 ?
> i have created a acct but sql mail not able to find that profile
> tks & rdgs
>|||Just as a follow up to Mikes answer:
http://support.microsoft.com/default.aspx?scid=kb;en-us;311231&sd=tech
--
HTH, Jens Suessmeyer.
--
http://www.sqlserver2005.de
--
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> schrieb im Newsbeitrag
news:6A471B90-25E4-4FAE-80EB-BCE1C997B3FA@.microsoft.com...
> Hi
> No. Only full Outlook.
> http://support.microsoft.com/default.aspx?scid=kb;en-us;263556
> --
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
>
> "maxzsim" wrote:
>> Hi ,
>> Can i know if outlook express is able to work with SQL server 2000 ?
>> i have created a acct but sql mail not able to find that profile
>> tks & rdgs
>>|||"maxzsim" <maxzsim@.discussions.microsoft.com> wrote in message
news:7D00E3BD-B7D7-405A-B891-FE823F4BBB93@.microsoft.com...
> Can i know if outlook express is able to work with SQL server 2000 ?
> i have created a acct but sql mail not able to find that profile
AFAIK you must install and configure Outlook (not Express) to get SQLMail
running.
Regards, Wojtek

Outlook Express

Newbie question - can Outlook Express be used with SQL Server 2000 for
notifications? Or do I have to use Outlook?
Rachael
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!AFAIK it is not supported on 32 bit SQL2000 for SQL Agent mail, however it
does work if you have SQL2000 SP3, the supported route is to use Outlook.
--
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Rachael Faber" <rfaber@.alldata.net> wrote in message
news:e0G4tvMUDHA.1712@.TK2MSFTNGP11.phx.gbl...
Newbie question - can Outlook Express be used with SQL Server 2000 for
notifications? Or do I have to use Outlook?
Rachael
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

ot: upgrading msde to SQL Server 2005 Express Edition

has anybody tried to do that yet? any experiences? how-tos?I just moved an MSDE database to SQL2005 Express with noproblems. I created a new instance with SQL2005 Express thendetached the DB from the MSDE instance moved the files and attached itto the Express instance. Everything appears to be working (thoughit is on a dev box).
Only issue to resolve now is backing up the database automatically,Express doesn't have an agent and I haven't found out how to back upthe DB.
HTH
Antony
|||

thanks'.

backup: i was reading something about the windows task scheduler ...

|||NP
With back up I have started a sep thread in another forum to try and sort this out.
http://forums.asp.net/1107445/ShowPost.aspx
Antony

OSQL and SQL 2005 Express

Hi All... I'm trying to upgrade one of our MSDE-based products to SQL 2005 Express. The installation of the product includes the use of a bat file that makes several OSQL calls. This bat file runs on the machine that has SQL 2005 Express installed and is failing - times out trying to connect. I've gotten away from the bat file and am now just trying to run OSQL against the db from a dos prompt. I'm getting the following:

C:\Documents and Settings\cdehaven>osql -E
[SQL Native Client]Named Pipes Provider: Could not open a connection to SQLServer [2].
[SQL Native Client]Login timeout expired
[SQL Native Client]An error has occurred while establishing a connection to
the server. When connecting to SQL Server 2005, this failure may be caused by
the fact that under the default settings SQL Server does not allow remote
connections.

Any thoughts? Thanks much!!

Curt

Answered my own question! I added a switch to the OSQL command line:

-S.\sqlexpress

This specifies the server and i suppose instance of sql server to connect to. I never needed to do this with MSDE, but I guess we need to now...

Curt

|||

MSDE installed as a default instance by default, SQL Server 2005 does not, it installs the Express instance by default in Machine\SQLExpress. if you are using a named instance you will either have to provide the following syntax (or use a SQLAlias on the machines)

1. Machine\InstanceName
2 Machinename,Portnumber (Which will redirect to the named instance, be aware that this is impratical for SQL Server Express named instances by default as the port is dynamically choosenupon startup of the service)

Jens K. Suessmeyer

http://www.sqlserver2005.de

osql

i'm trying to execute some scripts created by the express studio script wizard. i can connect with the studio, the website (asp worker) but i can't create the right cmdline for osql ..... this is my osql line ......

C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn>osql -S (local)\\SQLEXPRESS -U sa -P sablah -i run.sql.......

this is the error i'm getting in my logs

Error: 18456, Severity: 14, State: 16.
2006-12-22 15:30:45.11 Logon Login failed for user 'sa'. [CLIENT: <local machine>]

"Server=(local)\\SQLEXPRESS;Database=ggmi;User Id=sa;Password=cr79cr02;Trusted_connection=false;";

the following is the working connection string for my aspworker.

"Server=(local)\\SQLEXPRESS;Database=ggmi;User Id=sa;Password=cr79cr02;Trusted_connection=false;";

when i try to put in the trust conenction parameter is says that it conflicts with the user flag ,. probably because its a differant type of login process. any ideas?

First, you only use EITHER username/password OR Trusted_Connection -NOT both. So the second connection string should fail.

Second, in the connection string, the server 'should' have only one [\] between the machinename and the instancename.

|||Yah, i believe i posted that. for asp.net the string actually works. i know why its not supposed to be there. and thats obivously why i can't add that argument to the osql statement. but i'm still left with the original posting of my error. i'm not missing anything in my osql statement?|||

Reading your post again, it seems that you indicated that your ASP connection string failed.

is98 wrote:

the following is the working connection string for my aspworker.

"Server=(local)\\SQLEXPRESS;Database=ggmi;User Id=sa;Password=cr79cr02;Trusted_connection=false;";

when i try to put in the trust conenction parameter is says that it conflicts with the user flag ,. probably because its a differant type of login process. any ideas?

ASP may be able to handle the two backslashes in the servername, but OSQL cannot. And if I recall, doesn't ASP use (localhost) instead of (local)?

Try: "server=(local)\SQLExpress" INSTEAD OF "Server=(local)\\SQLEXPRESS"

|||who the man? you the man. the localhost part works still ok. i just took out the extra slash which obiviously now explains why it couldn't find the server. thanks muchly.|||

The double back-slash is an escape character for C based languages, such as C#. When ever you want to pass a backslash in a C based language, you either need to use the "\\" escape sequence or use the @. to indicate a litteral string. You are passing literal strings to oSQL, not C#, so the "\\" is not needed, as you've found.

Just thought you'd be interested in understanding that this wasn't just random behaivor.

Mike