Missing dll file: install

Showing posts with label install. Show all posts

Wednesday, March 21, 2012

MMC 3.0 and SQL 2000

I am to install MMC 3.0 to a server (Server 2003 Standard Edition SP1) with
SQL 2000 Sp4. I would like to know if Server Enterprise Manager works under
MMC 3.0.
--
Regards
Rasmus SÃ¶derlundHi Rasmus
EM seems to work fine with MMC 3.0
John
"Rasmus" wrote:
> I am to install MMC 3.0 to a server (Server 2003 Standard Edition SP1) with
> SQL 2000 Sp4. I would like to know if Server Enterprise Manager works under
> MMC 3.0.
> --
> Regards
>
> Rasmus SÃ¶derlund

Mixing SQL Server and MSDE and authentication

We install MSDE2000 under a named instance and with SQL Server
authentication, and specify a password for 'sa'.
I recently had someone install it on a system that already had SQL Server
installed.
On that system, we could not connect to the named instance using the "sa"
user and password specified in the installer. Using ODBC, we kept getting
the error 18452 - Login failed for user 'sa'.
How does the presence of SQL Server affect this? Does the 'sa' password for
the SQL Server default instance take precedence?
hi,
"JJ" <jjjj@.nospam.com> ha scritto nel messaggio
news:uAPJ05LGEHA.2732@.tk2msftngp13.phx.gbl...
> We install MSDE2000 under a named instance and with SQL Server
> authentication, and specify a password for 'sa'.
> I recently had someone install it on a system that already had SQL Server
> installed.
> On that system, we could not connect to the named instance using the "sa"
> user and password specified in the installer. Using ODBC, we kept getting
> the error 18452 - Login failed for user 'sa'.
> How does the presence of SQL Server affect this? Does the 'sa' password
for
> the SQL Server default instance take precedence?
>
it shoul'd really not...
all specified settings are instance specific, the only difference is that
the 1st instance (default) will listen to default TCP/IP port 1433, while
all other ubsequent instances will pass throught UDP port 1434 if they have
been set to dinamically retrieve the port number... but this another
story...
if you can reproduce the problem and are "sure" [ =;-) ] that the MSDE
instance has been installed specifying the SECURITYMODE=SQL parameter, you
are wellcome to open a case with Microsoft PSS...
thank you
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.7.0 - DbaMgr ver 0.53.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||hi again,
anyway, try checking the HKLM\Software\Microsoft\Microsoft SQL
Server\Instance Name\MSSQLServer\LoginMode registry key... it shoul'd be 2
or 0 for mixed mode authentication...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.7.0 - DbaMgr ver 0.53.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||That's the strange part - I did check that in the registry and it was set to
2, so I tried setting it to 0 (then stopped and restarted the MSDE instance)
and got the same error.
Unfortunately, I can't check it again because we ended up just using SQL
Server and uninstalling MSDE for the user with the problem. (It was
actually a mistake for the user to have done the install with MSDE because
usually if they have SQL Server already, we want them to just use that. I
can't think of a good reason for an end user to have both SQL Server and
MSDE installed on the same system. But I was curious to find out whether or
not it should have worked.)
It may indeed have been the dynamic port issue - I did not check the client
configuration to see if it was trying to go to a specific port (i.e. 1433).
But I would have thought it just wouldn't have connected since the server
name contained the instance name.
"Andrea Montanari" <andrea.sqlDMO@.virgilio.it> wrote in message
news:c4ju2l$2h7scp$1@.ID-207518.news.uni-berlin.de...
> hi again,
> anyway, try checking the HKLM\Software\Microsoft\Microsoft SQL
> Server\Instance Name\MSSQLServer\LoginMode registry key... it shoul'd be 2
> or 0 for mixed mode authentication...
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.7.0 - DbaMgr ver 0.53.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>

Mixed mode security

Hello all,
I'm trying to modify the security setting for a local install to m ake
it mixed mode, but in the SQL Server properties window I select SQL
Server and Windows then press OK, but the window doesn't close and it
won't let me save the settings. Why is this? Can anyone help?
Thanks,
JonIt would help if you specify the version and editions
"Jon" <JonMYates@.gmail.com> wrote in message
news:1191402457.786282.106960@.57g2000hsv.googlegroups.com...
> Hello all,
> I'm trying to modify the security setting for a local install to m ake
> it mixed mode, but in the SQL Server properties window I select SQL
> Server and Windows then press OK, but the window doesn't close and it
> won't let me save the settings. Why is this? Can anyone help?
> Thanks,
> Jon
>sql

Mixed Mode Authentication

Hi folks,
I have a microsoft SQL server 2000 on a Windows 2003 Server on my network, I
am trying to install project server 2003. Project server tells me that my
SQL server must be in Mixed mode to complete the installation.
The problem is that the server which was installed with "Windows Only" will
not switch to "Windows and SQL". I have restarted the services and still no
joy, what else can I do to change to mixed mode?
thanks
DaveWhat do you mean it wont switch? Do you get an error
message? If so, would you like to share it with the rest
of the class?
>--Original Message--
>Hi folks,
>I have a microsoft SQL server 2000 on a Windows 2003
Server on my network, I
>am trying to install project server 2003. Project server
tells me that my
>SQL server must be in Mixed mode to complete the
installation.
>The problem is that the server which was installed
with "Windows Only" will
>not switch to "Windows and SQL". I have restarted the
services and still no
>joy, what else can I do to change to mixed mode?
>thanks
>Dave
>
>.
>|||David,
Is SQL Server a local administrator on the machine? Does it have access
to the registry? This state is stored in the registry, and if SQL Server
doesn't have write permission to the registry it could fail.
The registry key is
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft
SQLServer\<instance_name>\MSSQLServer\LoginMode
The value of LoginMode is 1 for Windows Only, 2 for Mixed mode and you
may still see 0 for SQL Server only (servers upgraded from 6.5).
--
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
David Hodgson wrote:
> Hi folks,
> I have a microsoft SQL server 2000 on a Windows 2003 Server on my network, I
> am trying to install project server 2003. Project server tells me that my
> SQL server must be in Mixed mode to complete the installation.
> The problem is that the server which was installed with "Windows Only" will
> not switch to "Windows and SQL". I have restarted the services and still no
> joy, what else can I do to change to mixed mode?
> thanks
> Dave
>|||No error.
I select mixed mode on the server properties then once I've restarted the
services I go back in to server properties and "Windows Only" is still
selected, it won't switch!
I'm new to SQL so be gentle :)
Dave
"ChrisR" <anonymous@.discussions.microsoft.com> wrote in message
news:2bcbf01c46824$3b95a230$a301280a@.phx.gbl...
> What do you mean it wont switch? Do you get an error
> message? If so, would you like to share it with the rest
> of the class?
>
> >--Original Message--
> >Hi folks,
> >
> >I have a microsoft SQL server 2000 on a Windows 2003
> Server on my network, I
> >am trying to install project server 2003. Project server
> tells me that my
> >SQL server must be in Mixed mode to complete the
> installation.
> >
> >The problem is that the server which was installed
> with "Windows Only" will
> >not switch to "Windows and SQL". I have restarted the
> services and still no
> >joy, what else can I do to change to mixed mode?
> >
> >thanks
> >Dave
> >
> >
> >.
> >|||Hi Mark,
thanks for that, your correct, the currently logged on user which I thought
was part of the local administrators group isn't.
oh the joys
thanks
Dave
"Mark Allison" <marka@.no.tinned.meat.mvps.org> wrote in message
news:ugJluVCaEHA.3692@.TK2MSFTNGP09.phx.gbl...
> David,
> Is SQL Server a local administrator on the machine? Does it have access
> to the registry? This state is stored in the registry, and if SQL Server
> doesn't have write permission to the registry it could fail.
> The registry key is
> HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft
> SQLServer\<instance_name>\MSSQLServer\LoginMode
> The value of LoginMode is 1 for Windows Only, 2 for Mixed mode and you
> may still see 0 for SQL Server only (servers upgraded from 6.5).
> --
> Mark Allison, SQL Server MVP
> http://www.markallison.co.uk
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
>
> David Hodgson wrote:
> > Hi folks,
> >
> > I have a microsoft SQL server 2000 on a Windows 2003 Server on my
network, I
> > am trying to install project server 2003. Project server tells me that
my
> > SQL server must be in Mixed mode to complete the installation.
> >
> > The problem is that the server which was installed with "Windows Only"
will
> > not switch to "Windows and SQL". I have restarted the services and still
no
> > joy, what else can I do to change to mixed mode?
> >
> > thanks
> > Dave
> >
> >|||Just thought of something there, what do you mean is the "SQL Server" a
local administrator on the machine?
"Mark Allison" <marka@.no.tinned.meat.mvps.org> wrote in message
news:ugJluVCaEHA.3692@.TK2MSFTNGP09.phx.gbl...
> David,
> Is SQL Server a local administrator on the machine? Does it have access
> to the registry? This state is stored in the registry, and if SQL Server
> doesn't have write permission to the registry it could fail.
> The registry key is
> HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft
> SQLServer\<instance_name>\MSSQLServer\LoginMode
> The value of LoginMode is 1 for Windows Only, 2 for Mixed mode and you
> may still see 0 for SQL Server only (servers upgraded from 6.5).
> --
> Mark Allison, SQL Server MVP
> http://www.markallison.co.uk
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
>
> David Hodgson wrote:
> > Hi folks,
> >
> > I have a microsoft SQL server 2000 on a Windows 2003 Server on my
network, I
> > am trying to install project server 2003. Project server tells me that
my
> > SQL server must be in Mixed mode to complete the installation.
> >
> > The problem is that the server which was installed with "Windows Only"
will
> > not switch to "Windows and SQL". I have restarted the services and still
no
> > joy, what else can I do to change to mixed mode?
> >
> > thanks
> > Dave
> >
> >|||David,
What I meant was, is the Windows Domain Account that the MSSQLServer
service logs on under, a member of the Local Administrators group on the
server.
--
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
David Hodgson wrote:
> Just thought of something there, what do you mean is the "SQL Server" a
> local administrator on the machine?
>
> "Mark Allison" <marka@.no.tinned.meat.mvps.org> wrote in message
> news:ugJluVCaEHA.3692@.TK2MSFTNGP09.phx.gbl...
>>David,
>>Is SQL Server a local administrator on the machine? Does it have access
>>to the registry? This state is stored in the registry, and if SQL Server
>>doesn't have write permission to the registry it could fail.
>>The registry key is
>>HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft
>>SQLServer\<instance_name>\MSSQLServer\LoginMode
>>The value of LoginMode is 1 for Windows Only, 2 for Mixed mode and you
>>may still see 0 for SQL Server only (servers upgraded from 6.5).
>>--
>>Mark Allison, SQL Server MVP
>>http://www.markallison.co.uk
>>Looking for a SQL Server replication book?
>>http://www.nwsu.com/0974973602.html
>>
>>David Hodgson wrote:
>>Hi folks,
>>I have a microsoft SQL server 2000 on a Windows 2003 Server on my
> network, I
>>am trying to install project server 2003. Project server tells me that
> my
>>SQL server must be in Mixed mode to complete the installation.
>>The problem is that the server which was installed with "Windows Only"
> will
>>not switch to "Windows and SQL". I have restarted the services and still
> no
>>joy, what else can I do to change to mixed mode?
>>thanks
>>Dave
>>
>
>|||No but it is part of the "domain admins" group which is part of the "local
admins" group so permissions look ok.
"Mark Allison" <marka@.no.tinned.meat.mvps.org> wrote in message
news:%23gMxADDaEHA.2892@.TK2MSFTNGP10.phx.gbl...
> David,
> What I meant was, is the Windows Domain Account that the MSSQLServer
> service logs on under, a member of the Local Administrators group on the
> server.
> --
> Mark Allison, SQL Server MVP
> http://www.markallison.co.uk
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
>
> David Hodgson wrote:
> > Just thought of something there, what do you mean is the "SQL Server" a
> > local administrator on the machine?
> >
> >
> > "Mark Allison" <marka@.no.tinned.meat.mvps.org> wrote in message
> > news:ugJluVCaEHA.3692@.TK2MSFTNGP09.phx.gbl...
> >
> >>David,
> >>
> >>Is SQL Server a local administrator on the machine? Does it have access
> >>to the registry? This state is stored in the registry, and if SQL Server
> >>doesn't have write permission to the registry it could fail.
> >>
> >>The registry key is
> >>HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft
> >>SQLServer\<instance_name>\MSSQLServer\LoginMode
> >>
> >>The value of LoginMode is 1 for Windows Only, 2 for Mixed mode and you
> >>may still see 0 for SQL Server only (servers upgraded from 6.5).
> >>
> >>--
> >>Mark Allison, SQL Server MVP
> >>http://www.markallison.co.uk
> >>
> >>Looking for a SQL Server replication book?
> >>http://www.nwsu.com/0974973602.html
> >>
> >>
> >>
> >>David Hodgson wrote:
> >>
> >>Hi folks,
> >>
> >>I have a microsoft SQL server 2000 on a Windows 2003 Server on my
> >
> > network, I
> >
> >>am trying to install project server 2003. Project server tells me that
> >
> > my
> >
> >>SQL server must be in Mixed mode to complete the installation.
> >>
> >>The problem is that the server which was installed with "Windows Only"
> >
> > will
> >
> >>not switch to "Windows and SQL". I have restarted the services and
still
> >
> > no
> >
> >>joy, what else can I do to change to mixed mode?
> >>
> >>thanks
> >>Dave
> >>
> >>
> >
> >
> >sql

Mixed Mode Authentication

Monday, March 19, 2012

Mixed environment x64 and x86 (compatibility)

I have all sql servers running 32bit. We need another SQL cluster and I would
like to install SQL2005 x64. My concerns are the compatibility between
SQL2000 32bit, SQL2005 32bit and the new one:
questions:
can I restore a x64 database to a 32bit SQL Server?
Anyone has had compatibility issues using a mixed environment?
If there is no difference, why there are different AdventureWorks versions
(x64 and x86) to download?
http://www.microsoft.com/downloads/details.aspx?familyid=E719ECF7-9F46-4312-AF89-6AD8702E4E6E&displaylang=en
Microsoft says there is no problem, but I would like to hear some real
experience ..
thanks
Julio M
Hi
"Julio Mattos" wrote:

> I have all sql servers running 32bit. We need another SQL cluster and I would
> like to install SQL2005 x64. My concerns are the compatibility between
> SQL2000 32bit, SQL2005 32bit and the new one:
> questions:
> can I restore a x64 database to a 32bit SQL Server?
The backup file format is the same on both machines. The database file
format has not changed either, therefore you can move these from one platform
to the next without issues.

> Anyone has had compatibility issues using a mixed environment?

> If there is no difference, why there are different AdventureWorks versions
> (x64 and x86) to download?
> http://www.microsoft.com/downloads/details.aspx?familyid=E719ECF7-9F46-4312-AF89-6AD8702E4E6E&displaylang=en
This is probably because of the samples being deployed on different platforms.

> Microsoft says there is no problem, but I would like to hear some real
> experience ..
You should deploy this because you need a platform that is better suited for
the 64 bit environment i.e. better memory usage, better processors etc.

> thanks
> Julio M
>
John

Mixed environment x64 and x86 (compatibility)

I have all sql servers running 32bit. We need another SQL cluster and I would
like to install SQL2005 x64. My concerns are the compatibility between
SQL2000 32bit, SQL2005 32bit and the new one:
questions:
can I restore a x64 database to a 32bit SQL Server?
Anyone has had compatibility issues using a mixed environment?
If there is no difference, why there are different AdventureWorks versions
(x64 and x86) to download?
http://www.microsoft.com/downloads/details.aspx?familyid=E719ECF7-9F46-4312-AF89-6AD8702E4E6E&displaylang=en
Microsoft says there is no problem, but I would like to hear some real
experience ..
thanks
Julio MHi
"Julio Mattos" wrote:
> I have all sql servers running 32bit. We need another SQL cluster and I would
> like to install SQL2005 x64. My concerns are the compatibility between
> SQL2000 32bit, SQL2005 32bit and the new one:
> questions:
> can I restore a x64 database to a 32bit SQL Server?
The backup file format is the same on both machines. The database file
format has not changed either, therefore you can move these from one platform
to the next without issues.
> Anyone has had compatibility issues using a mixed environment?
> If there is no difference, why there are different AdventureWorks versions
> (x64 and x86) to download?
> http://www.microsoft.com/downloads/details.aspx?familyid=E719ECF7-9F46-4312-AF89-6AD8702E4E6E&displaylang=en
This is probably because of the samples being deployed on different platforms.
> Microsoft says there is no problem, but I would like to hear some real
> experience ..
You should deploy this because you need a platform that is better suited for
the 64 bit environment i.e. better memory usage, better processors etc.
> thanks
> Julio M
>
John

Mixed environment x64 and x86 (compatibility)

I have all sql servers running 32bit. We need another SQL cluster and I woul
d
like to install SQL2005 x64. My concerns are the compatibility between
SQL2000 32bit, SQL2005 32bit and the new one:
questions:
can I restore a x64 database to a 32bit SQL Server?
Anyone has had compatibility issues using a mixed environment?
If there is no difference, why there are different AdventureWorks versions
(x64 and x86) to download?
http://www.microsoft.com/downloads/...&displaylang=en
Microsoft says there is no problem, but I would like to hear some real
experience ..
thanks
Julio MHi
"Julio Mattos" wrote:

> I have all sql servers running 32bit. We need another SQL cluster and I wo
uld
> like to install SQL2005 x64. My concerns are the compatibility between
> SQL2000 32bit, SQL2005 32bit and the new one:
> questions:
> can I restore a x64 database to a 32bit SQL Server?
The backup file format is the same on both machines. The database file
format has not changed either, therefore you can move these from one platfor
m
to the next without issues.

> Anyone has had compatibility issues using a mixed environment?

> If there is no difference, why there are different AdventureWorks versions
> (x64 and x86) to download?
> http://www.microsoft.com/downloads/...&displaylang=en
This is probably because of the samples being deployed on different platform
s.

> Microsoft says there is no problem, but I would like to hear some real
> experience ..
You should deploy this because you need a platform that is better suited for
the 64 bit environment i.e. better memory usage, better processors etc.

> thanks
> Julio M
>
John

Monday, March 12, 2012

Missing Subject

Hi,
last month I installed SQL Server 2000 on a new server (Install SQL2000 and
then upgraded to SP4) because that server is going to replace the main
production server. I've restored the database dumps from the old server to
the new one and did also copy the SQL Agent jobs. Also configured SQL Mail,
because there are some stored procedures that use the xp_sendmail.
Everything seems to work OK, until I noticed that the mails, sent by SQL
Mail using the xp_sendmail are all missing the subject line, whereas the
subject line is present in the mail sent by the (old) production server.
the code in the stored procedures that invoke xp_sendmail is identical on
both machines.
Am I missing something or...
--
Adri
Programmers do it Bit by BitHi
Without seeing the actual call to xp_sendmail it is hard to say, but at a
guess you are possibly concatentating to a NULL value or something similar
either because the data is different or may be CONCAT_NULL_YIELDS_NULL is
different.
John
"Adri" wrote:
> Hi,
> last month I installed SQL Server 2000 on a new server (Install SQL2000 and
> then upgraded to SP4) because that server is going to replace the main
> production server. I've restored the database dumps from the old server to
> the new one and did also copy the SQL Agent jobs. Also configured SQL Mail,
> because there are some stored procedures that use the xp_sendmail.
> Everything seems to work OK, until I noticed that the mails, sent by SQL
> Mail using the xp_sendmail are all missing the subject line, whereas the
> subject line is present in the mail sent by the (old) production server.
> the code in the stored procedures that invoke xp_sendmail is identical on
> both machines.
> Am I missing something or...
> --
> Adri
> Programmers do it Bit by Bit|||Adri skrev:
> ...
> Am I missing something or...
> ...
Actually yes, the Subject ;)|||In fact, a simple
xp_sendmail @.recipients = 'someuser@.somedomain.where' ,@.message = 'message'
,@.subject = 'subject'
delivers an e-mail with an empty subject line :-(
--
Adri
Programmers do it Bit by Bit
"John Bell" wrote:
> Hi
> Without seeing the actual call to xp_sendmail it is hard to say, but at a
> guess you are possibly concatentating to a NULL value or something similar
> either because the data is different or may be CONCAT_NULL_YIELDS_NULL is
> different.
> John
> "Adri" wrote:
> > Hi,
> >
> > last month I installed SQL Server 2000 on a new server (Install SQL2000 and
> > then upgraded to SP4) because that server is going to replace the main
> > production server. I've restored the database dumps from the old server to
> > the new one and did also copy the SQL Agent jobs. Also configured SQL Mail,
> > because there are some stored procedures that use the xp_sendmail.
> >
> > Everything seems to work OK, until I noticed that the mails, sent by SQL
> > Mail using the xp_sendmail are all missing the subject line, whereas the
> > subject line is present in the mail sent by the (old) production server.
> >
> > the code in the stored procedures that invoke xp_sendmail is identical on
> > both machines.
> >
> > Am I missing something or...
> > --
> > Adri
> > Programmers do it Bit by Bit|||Hi Adri
More questions...
I assume you can send mail successfully from Outlook with a subject? if the
subject parameter is before the message parameter does it work? Is this 32 or
64 bit?
John
"Adri" wrote:
> In fact, a simple
> xp_sendmail @.recipients = 'someuser@.somedomain.where' ,@.message = 'message'
> ,@.subject = 'subject'
> delivers an e-mail with an empty subject line :-(
> --
> Adri
> Programmers do it Bit by Bit
>
> "John Bell" wrote:
> > Hi
> >
> > Without seeing the actual call to xp_sendmail it is hard to say, but at a
> > guess you are possibly concatentating to a NULL value or something similar
> > either because the data is different or may be CONCAT_NULL_YIELDS_NULL is
> > different.
> >
> > John
> >
> > "Adri" wrote:
> >
> > > Hi,
> > >
> > > last month I installed SQL Server 2000 on a new server (Install SQL2000 and
> > > then upgraded to SP4) because that server is going to replace the main
> > > production server. I've restored the database dumps from the old server to
> > > the new one and did also copy the SQL Agent jobs. Also configured SQL Mail,
> > > because there are some stored procedures that use the xp_sendmail.
> > >
> > > Everything seems to work OK, until I noticed that the mails, sent by SQL
> > > Mail using the xp_sendmail are all missing the subject line, whereas the
> > > subject line is present in the mail sent by the (old) production server.
> > >
> > > the code in the stored procedures that invoke xp_sendmail is identical on
> > > both machines.
> > >
> > > Am I missing something or...
> > > --
> > > Adri
> > > Programmers do it Bit by Bit|||Adri wrote:
> In fact, a simple
> xp_sendmail @.recipients = 'someuser@.somedomain.where' ,@.message = 'message'
> ,@.subject = 'subject'
> delivers an e-mail with an empty subject line :-(
> --
> Adri
> Programmers do it Bit by Bit
*bonk*
Sorry for my pityful attempt of being funny :) I actually didn't read
your post carefully enough and didn't realize your problem was really
'Missing Subject', not that some client added that as a subject for
your post (that you had sent without a subject)... Ahem...
Btw, did you do a search on Google, I saw a lot of hits using
"xp_sendmail" and "subject" as search parameters even though I didn't
instantly find a solution for the problem...
/impslayer, aka Birger Johansson|||Hi Adri,
My understanding of your issue is:
After the migration of SQL Server 2000 from an older server to a new one,
you can also send email by xp_sendmail in your stored procedures,however
those sent mails' subjects are missed.
If I have misunderstood, please let me know.
I recommend that you try the following:
1) Login as account that is running SQL Server server and open outlook.
2) Tools->Options->Mail Format tab. Change the "compose in message format"
to plan
text and send an email through outlook with a subject.
3) Change the "compose in message format" back to html. Send email with
subject.
Stop and start SQL Server instance might be necessary.
Sincerely yours,
Charles Wang
Microsoft Online Community Support
======================================================When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from this issue.
======================================================This posting is provided "AS IS" with no warranties, and confers no rights.
======================================================|||Hi Charles,
In fact, I did a new installation of SQL 2000 on a W2K3 server and upgraded
SQL from RTM to SP4. Having done that, I restored the (user)database dumps
from the old server to the new one, and configured SQL Mail as usual.
The old server had originally SQL 2000 RTM installed, upgraded to SP2, SP3,
Hotfix KB891640 applied and at last upgraded to SP4.
I've changed the Mail Format as you supposed, but that did not help.
--
Adri
Programmers do it Bit by Bit
"Charles Wang[MSFT]" wrote:
> Hi Adri,
> My understanding of your issue is:
> After the migration of SQL Server 2000 from an older server to a new one,
> you can also send email by xp_sendmail in your stored procedures,however
> those sent mails' subjects are missed.
> If I have misunderstood, please let me know.
> I recommend that you try the following:
> 1) Login as account that is running SQL Server server and open outlook.
> 2) Tools->Options->Mail Format tab. Change the "compose in message format"
> to plan
> text and send an email through outlook with a subject.
> 3) Change the "compose in message format" back to html. Send email with
> subject.
> Stop and start SQL Server instance might be necessary.
> Sincerely yours,
> Charles Wang
> Microsoft Online Community Support
> ======================================================> When responding to posts, please "Reply to Group" via
> your newsreader so that others may learn and benefit
> from this issue.
> ======================================================> This posting is provided "AS IS" with no warranties, and confers no rights.
> ======================================================>
>|||Like saying "This page is intentionally blank"!!!
John
"impslayer" wrote:
> Adri wrote:
> > In fact, a simple
> >
> > xp_sendmail @.recipients = 'someuser@.somedomain.where' ,@.message = 'message'
> > ,@.subject = 'subject'
> >
> > delivers an e-mail with an empty subject line :-(
> >
> > --
> > Adri
> > Programmers do it Bit by Bit
> *bonk*
> Sorry for my pityful attempt of being funny :) I actually didn't read
> your post carefully enough and didn't realize your problem was really
> 'Missing Subject', not that some client added that as a subject for
> your post (that you had sent without a subject)... Ahem...
> Btw, did you do a search on Google, I saw a lot of hits using
> "xp_sendmail" and "subject" as search parameters even though I didn't
> instantly find a solution for the problem...
> /impslayer, aka Birger Johansson
>|||Hi Adri,
To make sure this is a dabase wide issue or server instance side issue, I
recommend that you create a new stored procedure with xp_sendmail in a test
database and see whether or not it has the same issue.
Also, you may try recompiling the stored procedures.
Charles Wang
Microsoft Online Community Support|||Hi
Please clarify that using Outlook directly is working ok?
Which version of office is being used?
John
"Adri" wrote:
> Hi Charles,
> In fact, I did a new installation of SQL 2000 on a W2K3 server and upgraded
> SQL from RTM to SP4. Having done that, I restored the (user)database dumps
> from the old server to the new one, and configured SQL Mail as usual.
> The old server had originally SQL 2000 RTM installed, upgraded to SP2, SP3,
> Hotfix KB891640 applied and at last upgraded to SP4.
> I've changed the Mail Format as you supposed, but that did not help.
> --
> Adri
> Programmers do it Bit by Bit
>
> "Charles Wang[MSFT]" wrote:
> > Hi Adri,
> >
> > My understanding of your issue is:
> > After the migration of SQL Server 2000 from an older server to a new one,
> > you can also send email by xp_sendmail in your stored procedures,however
> > those sent mails' subjects are missed.
> > If I have misunderstood, please let me know.
> >
> > I recommend that you try the following:
> > 1) Login as account that is running SQL Server server and open outlook.
> > 2) Tools->Options->Mail Format tab. Change the "compose in message format"
> > to plan
> > text and send an email through outlook with a subject.
> > 3) Change the "compose in message format" back to html. Send email with
> > subject.
> >
> > Stop and start SQL Server instance might be necessary.
> >
> > Sincerely yours,
> > Charles Wang
> > Microsoft Online Community Support
> > ======================================================> > When responding to posts, please "Reply to Group" via
> > your newsreader so that others may learn and benefit
> > from this issue.
> > ======================================================> > This posting is provided "AS IS" with no warranties, and confers no rights.
> > ======================================================> >
> >
> >

Missing Subject

I actually didn't read
your post carefully enough and didn't realize your problem was really
'Missing Subject', not that some client added that as a subject for
your post (that you had sent without a subject)... Ahem...
Btw, did you do a search on Google, I saw a lot of hits using
"xp_sendmail" and "subject" as search parameters even though I didn't
instantly find a solution for the problem...
/impslayer, aka Birger Johansson|||Hi Adri,
My understanding of your issue is:
After the migration of SQL Server 2000 from an older server to a new one,
you can also send email by xp_sendmail in your stored procedures,however
those sent mails' subjects are missed.
If I have misunderstood, please let me know.
I recommend that you try the following:
1) Login as account that is running SQL Server server and open outlook.
2) Tools->Options->Mail Format tab. Change the "compose in message format"
to plan
text and send an email through outlook with a subject.
3) Change the "compose in message format" back to html. Send email with
subject.
Stop and start SQL Server instance might be necessary.
Sincerely yours,
Charles Wang
Microsoft Online Community Support
========================================
==============
When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from this issue.
========================================
==============
This posting is provided "AS IS" with no warranties, and confers no rights.
========================================
==============|||Hi Charles,
In fact, I did a new installation of SQL 2000 on a W2K3 server and upgraded
SQL from RTM to SP4. Having done that, I restored the (user)database dumps
from the old server to the new one, and configured SQL Mail as usual.
The old server had originally SQL 2000 RTM installed, upgraded to SP2, SP3,
Hotfix KB891640 applied and at last upgraded to SP4.
I've changed the Mail Format as you supposed, but that did not help.
--
Adri
Programmers do it Bit by Bit
"Charles Wang[MSFT]" wrote:

> Hi Adri,
> My understanding of your issue is:
> After the migration of SQL Server 2000 from an older server to a new one,
> you can also send email by xp_sendmail in your stored procedures,however
> those sent mails' subjects are missed.
> If I have misunderstood, please let me know.
> I recommend that you try the following:
> 1) Login as account that is running SQL Server server and open outlook.
> 2) Tools->Options->Mail Format tab. Change the "compose in message format"
> to plan
> text and send an email through outlook with a subject.
> 3) Change the "compose in message format" back to html. Send email with
> subject.
> Stop and start SQL Server instance might be necessary.
> Sincerely yours,
> Charles Wang
> Microsoft Online Community Support
> ========================================
==============
> When responding to posts, please "Reply to Group" via
> your newsreader so that others may learn and benefit
> from this issue.
> ========================================
==============
> This posting is provided "AS IS" with no warranties, and confers no rights
.
> ========================================
==============
>
>|||Like saying "This page is intentionally blank"!!!
John
"impslayer" wrote:

> Adri wrote:
> *bonk*
> Sorry for my pityful attempt of being funny

I actually didn't read
> your post carefully enough and didn't realize your problem was really
> 'Missing Subject', not that some client added that as a subject for
> your post (that you had sent without a subject)... Ahem...
> Btw, did you do a search on Google, I saw a lot of hits using
> "xp_sendmail" and "subject" as search parameters even though I didn't
> instantly find a solution for the problem...
> /impslayer, aka Birger Johansson
>|||Hi Adri,
To make sure this is a dabase wide issue or server instance side issue, I
recommend that you create a new stored procedure with xp_sendmail in a test
database and see whether or not it has the same issue.
Also, you may try recompiling the stored procedures.
Charles Wang
Microsoft Online Community Support

Friday, March 9, 2012

Missing Report Graphs

I am testing a new install of Reporting Services with Mom 2005. Every report
that I try to view that contains a graph simply displays an empty box with a
red X in the upper left. Is there some component that I am possibly missing
that contains the graph object?
Any help is appreciated!
--
Dale Foshe, mcseSee if cookies are allowed in the browser by looking at the status bar when
the report is requested.
--
Hope this helps.
---
Teo Lachev, MVP [SQL Server], MCSD, MCT
Author: "Microsoft Reporting Services in Action"
Publisher website: http://www.manning.com/lachev
Buy it from Amazon.com: http://shrinkster.com/eq
Home page and blog: http://www.prologika.com/
---
"Dale Foshe, mcse" <DaleFoshemcse@.discussions.microsoft.com> wrote in
message news:AE3335EA-A974-4D0E-A3AC-49FAAE34B759@.microsoft.com...
> I am testing a new install of Reporting Services with Mom 2005. Every
report
> that I try to view that contains a graph simply displays an empty box with
a
> red X in the upper left. Is there some component that I am possibly
missing
> that contains the graph object?
> Any help is appreciated!
> --
> Dale Foshe, mcse

missing Report Builder menu item after migration from RS2000 to 2005

I've done a clean install of RS2005 and then migrated old RS2000
database to RS2005.
After the migration the Report Builder menu item is missing.
I have system administrator level permission.
I need your advice.
TIA,
Kamelok, have solved it
there was one task unchecked in system administrator role definition -
"Execute Report Definitions"
Kamel
On 26 Sty, 16:40, "kamel" <kwic...@.gmail.com> wrote:
> I've done a clean install of RS2005and then migrated oldRS2000
> databasetoRS2005.AfterthemigrationtheReportBuildermenuitemismissing.
> I have system administrator level permission.
> I need your advice.
> TIA,
> Kamel

Wednesday, March 21, 2012

MMC 3.0 and SQL 2000

Mixing SQL Server and MSDE and authentication

Mixed mode security

Mixed Mode Authentication

Mixed Mode Authentication

Mixed Mode Authentication

Monday, March 19, 2012

Mixed environment x64 and x86 (compatibility)

Mixed environment x64 and x86 (compatibility)

Mixed environment x64 and x86 (compatibility)

Monday, March 12, 2012

Missing Subject

Missing Subject

Friday, March 9, 2012

Missing Report Graphs

missing Report Builder menu item after migration from RS2000 to 2005

Missing dll file

Blog Archive

About Me