I am using SQL Server 2000 and Enterprise Manager. I have a publication and
I am trying to follow some instructions for configuring conflict resolution.
I open the Publication properties, go to the Articles tab, open an Article by
clicking the ellipses, and then go to the Resolver tab. All of the controls
on the Resolver tab are disabled. Is there something else I must do first to
enable conflict resolution on at the Database or Publication level?
Some settings are database specific. Most likely what has happened is the
article you are trying to change the resolver type to is published in a
different publication. To make this work you will have to drop it from
existing publication, change the resolver type and then put it back in.
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
"Michael" <Michael@.discussions.microsoft.com> wrote in message
news:454325A9-2D83-4664-9ECB-9143C5257BDF@.microsoft.com...
>I am using SQL Server 2000 and Enterprise Manager. I have a publication
>and
> I am trying to follow some instructions for configuring conflict
> resolution.
> I open the Publication properties, go to the Articles tab, open an Article
> by
> clicking the ellipses, and then go to the Resolver tab. All of the
> controls
> on the Resolver tab are disabled. Is there something else I must do first
> to
> enable conflict resolution on at the Database or Publication level?
Showing posts with label configuring. Show all posts
Showing posts with label configuring. Show all posts
Friday, 24 February 2012
Sunday, 19 February 2012
Configuring Users - best Practices
Hello All,
I need to find out the best practices approach for user configuration in SQL
Reporting Services. I have teams of developers, who would be using VS.NET
development and deploying using VS.NET. Whats the best approach I could take
for development...Ideally I would like each team of users to have a folder
and so that they could deploy the reports only to those folders. Also how do
I set VS.NET to deploy a specifc sub folder.
Any thoughts or suggestions would be of good help.
Thanks,
ChrisYou can't deploy to a SubFolder in RS2K. Deployment from VS takes your
project name and uses it when you deploy. Only get one level.
There is a My Report folder you can turn on using the Report Manager under
system settings, but not sure that'll help you solve the problem you've
described.
If you need more, most straight forward approach is to go into Report
Manager after you deploy and move things around. Either that or use Report
Manager to 1st create the directory structure (folders / subfolders)
desired, then as Content Manager use the Upload File button on the tool bar
from within the subfolder to upload your reports.
If you find this to be burdensome, perhaps consider creating a VB script
like the one at
http://msdn.microsoft.com/library/en-us/rsamples/htm/rss_sampleapps_v1_1apd.asp
to automate the deployment process. Note, you could also do this
programmatically using the RS2K SOAP API. Perhaps as a program or daemon
that traverses a directory structure looking for .rdl files and then creates
the equivalent folders in RS to upload the reports to.
--
-- "This posting is provided 'AS IS' with no warranties, and confers no
rights."
jhmiller@.online.microsoft.com
"Christopher Pragash" <chrispragash@.hotmail.com> wrote in message
news:uyCnuc6mEHA.1304@.TK2MSFTNGP09.phx.gbl...
> Hello All,
> I need to find out the best practices approach for user configuration in
> SQL
> Reporting Services. I have teams of developers, who would be using VS.NET
> development and deploying using VS.NET. Whats the best approach I could
> take
> for development...Ideally I would like each team of users to have a folder
> and so that they could deploy the reports only to those folders. Also how
> do
> I set VS.NET to deploy a specifc sub folder.
> Any thoughts or suggestions would be of good help.
> Thanks,
> Chris
>|||John H. Miller wrote:
> You can't deploy to a SubFolder in RS2K. Deployment from VS takes
> your project name and uses it when you deploy. Only get one level.
I don't think that's correct, John. I am able to deploy to any folder I
want in RS2K (SP1) by setting the TargetFolder property under Deployment in
the project's Property Pages.
I would think Chris could set up a separate folder for each developer and
set up permissions that allow a developer to publish only to his/her own
folder. Each developer would simply set the TargetFolder to the virtual
path to his/her folder.
--
Regards,
Jake Marx
MS MVP - Excel
www.longhead.com
[please keep replies in the newsgroup - email address unmonitored]|||Christopher Pragash wrote:
> Hello All,
> I need to find out the best practices approach for user configuration
in SQL
> Reporting Services. I have teams of developers, who would be using
VS.NET
> development and deploying using VS.NET. Whats the best approach I
could take
> for development...Ideally I would like each team of users to have a
folder
> and so that they could deploy the reports only to those folders.
you can:
* create separate security groups containing the various teams of
developers
* create the various target folders on the report server
* assign the pertinent security group to the 'Content Manager' role
(using Report Manager is the easiest way to do this)
the above assumes all users are in a single domain and that you have
the ability to create groups. if not, you can use report manager once
again to create the folders and then add each developer individually to
the content manager role.
> Also how do I set VS.NET to deploy a specifc sub folder.
once you have created a BI project in the VS designer, you right-click
the project and select properties. from there, you can figure the
appropriate subfolder to deploy to, as well as the target server.
hope this helps.
cheers,
~stuart|||John H. Miller:
> You can't deploy to a SubFolder in RS2K. Deployment from VS takes
> your project name and uses it when you deploy. Only get one level.
Jake Marx:
<< I don't think that's correct, John. I am able to deploy to any
folder I
want in RS2K (SP1) by setting the TargetFolder property under
Deployment in
the project's Property Pages. >>
Jake is correct. You can set the targetfolder property to be
arbitrarily deep. if the directory structure doesn't exist, it will be
created on the first deploy.
I need to find out the best practices approach for user configuration in SQL
Reporting Services. I have teams of developers, who would be using VS.NET
development and deploying using VS.NET. Whats the best approach I could take
for development...Ideally I would like each team of users to have a folder
and so that they could deploy the reports only to those folders. Also how do
I set VS.NET to deploy a specifc sub folder.
Any thoughts or suggestions would be of good help.
Thanks,
ChrisYou can't deploy to a SubFolder in RS2K. Deployment from VS takes your
project name and uses it when you deploy. Only get one level.
There is a My Report folder you can turn on using the Report Manager under
system settings, but not sure that'll help you solve the problem you've
described.
If you need more, most straight forward approach is to go into Report
Manager after you deploy and move things around. Either that or use Report
Manager to 1st create the directory structure (folders / subfolders)
desired, then as Content Manager use the Upload File button on the tool bar
from within the subfolder to upload your reports.
If you find this to be burdensome, perhaps consider creating a VB script
like the one at
http://msdn.microsoft.com/library/en-us/rsamples/htm/rss_sampleapps_v1_1apd.asp
to automate the deployment process. Note, you could also do this
programmatically using the RS2K SOAP API. Perhaps as a program or daemon
that traverses a directory structure looking for .rdl files and then creates
the equivalent folders in RS to upload the reports to.
--
-- "This posting is provided 'AS IS' with no warranties, and confers no
rights."
jhmiller@.online.microsoft.com
"Christopher Pragash" <chrispragash@.hotmail.com> wrote in message
news:uyCnuc6mEHA.1304@.TK2MSFTNGP09.phx.gbl...
> Hello All,
> I need to find out the best practices approach for user configuration in
> SQL
> Reporting Services. I have teams of developers, who would be using VS.NET
> development and deploying using VS.NET. Whats the best approach I could
> take
> for development...Ideally I would like each team of users to have a folder
> and so that they could deploy the reports only to those folders. Also how
> do
> I set VS.NET to deploy a specifc sub folder.
> Any thoughts or suggestions would be of good help.
> Thanks,
> Chris
>|||John H. Miller wrote:
> You can't deploy to a SubFolder in RS2K. Deployment from VS takes
> your project name and uses it when you deploy. Only get one level.
I don't think that's correct, John. I am able to deploy to any folder I
want in RS2K (SP1) by setting the TargetFolder property under Deployment in
the project's Property Pages.
I would think Chris could set up a separate folder for each developer and
set up permissions that allow a developer to publish only to his/her own
folder. Each developer would simply set the TargetFolder to the virtual
path to his/her folder.
--
Regards,
Jake Marx
MS MVP - Excel
www.longhead.com
[please keep replies in the newsgroup - email address unmonitored]|||Christopher Pragash wrote:
> Hello All,
> I need to find out the best practices approach for user configuration
in SQL
> Reporting Services. I have teams of developers, who would be using
VS.NET
> development and deploying using VS.NET. Whats the best approach I
could take
> for development...Ideally I would like each team of users to have a
folder
> and so that they could deploy the reports only to those folders.
you can:
* create separate security groups containing the various teams of
developers
* create the various target folders on the report server
* assign the pertinent security group to the 'Content Manager' role
(using Report Manager is the easiest way to do this)
the above assumes all users are in a single domain and that you have
the ability to create groups. if not, you can use report manager once
again to create the folders and then add each developer individually to
the content manager role.
> Also how do I set VS.NET to deploy a specifc sub folder.
once you have created a BI project in the VS designer, you right-click
the project and select properties. from there, you can figure the
appropriate subfolder to deploy to, as well as the target server.
hope this helps.
cheers,
~stuart|||John H. Miller:
> You can't deploy to a SubFolder in RS2K. Deployment from VS takes
> your project name and uses it when you deploy. Only get one level.
Jake Marx:
<< I don't think that's correct, John. I am able to deploy to any
folder I
want in RS2K (SP1) by setting the TargetFolder property under
Deployment in
the project's Property Pages. >>
Jake is correct. You can set the targetfolder property to be
arbitrarily deep. if the directory structure doesn't exist, it will be
created on the first deploy.
Configuring users
Hi,
I am connecting to sql server 2000 from an Access 2000 project. I want to
have certain users edit a stored procedure. I can give them execute
permission but this doesn't allow them edit. I don't want to give them owner
permissions on the sp.
How do I allow them edit this sp only?
Thanks
Tom
Currently only the owner, the DB owner or someone with system administration
permissions can alter an sp...
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Tom Swanick" <tom.swanick@.activant.com> wrote in message
news:OFRuinn5EHA.2876@.TK2MSFTNGP12.phx.gbl...
> Hi,
> I am connecting to sql server 2000 from an Access 2000 project. I want to
> have certain users edit a stored procedure. I can give them execute
> permission but this doesn't allow them edit. I don't want to give them
owner
> permissions on the sp.
> How do I allow them edit this sp only?
> Thanks
> Tom
>
|||Or db_ddladmin; however, this will also give them edit permissions on all
objects in the database.
Sincerely,
Anthony Thomas
"Wayne Snyder" <wayne.nospam.snyder@.mariner-usa.com> wrote in message
news:eIaw0Jp5EHA.1408@.TK2MSFTNGP10.phx.gbl...
Currently only the owner, the DB owner or someone with system administration
permissions can alter an sp...
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Tom Swanick" <tom.swanick@.activant.com> wrote in message
news:OFRuinn5EHA.2876@.TK2MSFTNGP12.phx.gbl...
> Hi,
> I am connecting to sql server 2000 from an Access 2000 project. I want to
> have certain users edit a stored procedure. I can give them execute
> permission but this doesn't allow them edit. I don't want to give them
owner
> permissions on the sp.
> How do I allow them edit this sp only?
> Thanks
> Tom
>
I am connecting to sql server 2000 from an Access 2000 project. I want to
have certain users edit a stored procedure. I can give them execute
permission but this doesn't allow them edit. I don't want to give them owner
permissions on the sp.
How do I allow them edit this sp only?
Thanks
Tom
Currently only the owner, the DB owner or someone with system administration
permissions can alter an sp...
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Tom Swanick" <tom.swanick@.activant.com> wrote in message
news:OFRuinn5EHA.2876@.TK2MSFTNGP12.phx.gbl...
> Hi,
> I am connecting to sql server 2000 from an Access 2000 project. I want to
> have certain users edit a stored procedure. I can give them execute
> permission but this doesn't allow them edit. I don't want to give them
owner
> permissions on the sp.
> How do I allow them edit this sp only?
> Thanks
> Tom
>
|||Or db_ddladmin; however, this will also give them edit permissions on all
objects in the database.
Sincerely,
Anthony Thomas
"Wayne Snyder" <wayne.nospam.snyder@.mariner-usa.com> wrote in message
news:eIaw0Jp5EHA.1408@.TK2MSFTNGP10.phx.gbl...
Currently only the owner, the DB owner or someone with system administration
permissions can alter an sp...
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Tom Swanick" <tom.swanick@.activant.com> wrote in message
news:OFRuinn5EHA.2876@.TK2MSFTNGP12.phx.gbl...
> Hi,
> I am connecting to sql server 2000 from an Access 2000 project. I want to
> have certain users edit a stored procedure. I can give them execute
> permission but this doesn't allow them edit. I don't want to give them
owner
> permissions on the sp.
> How do I allow them edit this sp only?
> Thanks
> Tom
>
Configuring users
Hi,
I am connecting to sql server 2000 from an Access 2000 project. I want to
have certain users edit a stored procedure. I can give them execute
permission but this doesn't allow them edit. I don't want to give them owner
permissions on the sp.
How do I allow them edit this sp only?
Thanks
TomCurrently only the owner, the DB owner or someone with system administration
permissions can alter an sp...
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Tom Swanick" <tom.swanick@.activant.com> wrote in message
news:OFRuinn5EHA.2876@.TK2MSFTNGP12.phx.gbl...
> Hi,
> I am connecting to sql server 2000 from an Access 2000 project. I want to
> have certain users edit a stored procedure. I can give them execute
> permission but this doesn't allow them edit. I don't want to give them
owner
> permissions on the sp.
> How do I allow them edit this sp only?
> Thanks
> Tom
>|||Or db_ddladmin; however, this will also give them edit permissions on all
objects in the database.
Sincerely,
Anthony Thomas
"Wayne Snyder" <wayne.nospam.snyder@.mariner-usa.com> wrote in message
news:eIaw0Jp5EHA.1408@.TK2MSFTNGP10.phx.gbl...
Currently only the owner, the DB owner or someone with system administration
permissions can alter an sp...
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Tom Swanick" <tom.swanick@.activant.com> wrote in message
news:OFRuinn5EHA.2876@.TK2MSFTNGP12.phx.gbl...
> Hi,
> I am connecting to sql server 2000 from an Access 2000 project. I want to
> have certain users edit a stored procedure. I can give them execute
> permission but this doesn't allow them edit. I don't want to give them
owner
> permissions on the sp.
> How do I allow them edit this sp only?
> Thanks
> Tom
>
I am connecting to sql server 2000 from an Access 2000 project. I want to
have certain users edit a stored procedure. I can give them execute
permission but this doesn't allow them edit. I don't want to give them owner
permissions on the sp.
How do I allow them edit this sp only?
Thanks
TomCurrently only the owner, the DB owner or someone with system administration
permissions can alter an sp...
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Tom Swanick" <tom.swanick@.activant.com> wrote in message
news:OFRuinn5EHA.2876@.TK2MSFTNGP12.phx.gbl...
> Hi,
> I am connecting to sql server 2000 from an Access 2000 project. I want to
> have certain users edit a stored procedure. I can give them execute
> permission but this doesn't allow them edit. I don't want to give them
owner
> permissions on the sp.
> How do I allow them edit this sp only?
> Thanks
> Tom
>|||Or db_ddladmin; however, this will also give them edit permissions on all
objects in the database.
Sincerely,
Anthony Thomas
"Wayne Snyder" <wayne.nospam.snyder@.mariner-usa.com> wrote in message
news:eIaw0Jp5EHA.1408@.TK2MSFTNGP10.phx.gbl...
Currently only the owner, the DB owner or someone with system administration
permissions can alter an sp...
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Tom Swanick" <tom.swanick@.activant.com> wrote in message
news:OFRuinn5EHA.2876@.TK2MSFTNGP12.phx.gbl...
> Hi,
> I am connecting to sql server 2000 from an Access 2000 project. I want to
> have certain users edit a stored procedure. I can give them execute
> permission but this doesn't allow them edit. I don't want to give them
owner
> permissions on the sp.
> How do I allow them edit this sp only?
> Thanks
> Tom
>
configuring user security problem!
Hi,
I am new to sql reporting services. I have just installed sql
reporting service sp1. We have our own web app which uses forms
authentication. I have a page where i use reportviewer control (which
came along with samples)...to run a report...there is a separate
physical report server and on that server, for the Reports virtual
directory i have "anonymous access" set. Within this i have set domain
user and password! Now microsot recommends to use "integrated windows
authentication". But as soon as i set it, my web page gives me report
server error that access is denied. I understand that my web page is
impersonating as local\ASPNET user.
I am very confused! can you help me?
I will really appreciate it
Thanks,
SauminIf you use forms authentication you have to create an extension to implement
it. You need to read up on how to do so if you need this capability. It
requires some effort on your part and it requires enterprise edition. I
suggest that you remove anonymous access for now (so you can learn how to
write a report etc and then implement form based security later). For now,
use integrated security (anonymous access and integrated security is
mutually exclusive). To supplement the info on security in the bol I suggest
this link from Scott Allen:
http://odetocode.com/Articles/215.aspx
Bruce L-C
"Saumin" <saumin_patel@.hotmail.com> wrote in message
news:35be972d.0408171307.3e2d9cab@.posting.google.com...
> Hi,
> I am new to sql reporting services. I have just installed sql
> reporting service sp1. We have our own web app which uses forms
> authentication. I have a page where i use reportviewer control (which
> came along with samples)...to run a report...there is a separate
> physical report server and on that server, for the Reports virtual
> directory i have "anonymous access" set. Within this i have set domain
> user and password! Now microsot recommends to use "integrated windows
> authentication". But as soon as i set it, my web page gives me report
> server error that access is denied. I understand that my web page is
> impersonating as local\ASPNET user.
> I am very confused! can you help me?
> I will really appreciate it
> Thanks,
> Saumin
I am new to sql reporting services. I have just installed sql
reporting service sp1. We have our own web app which uses forms
authentication. I have a page where i use reportviewer control (which
came along with samples)...to run a report...there is a separate
physical report server and on that server, for the Reports virtual
directory i have "anonymous access" set. Within this i have set domain
user and password! Now microsot recommends to use "integrated windows
authentication". But as soon as i set it, my web page gives me report
server error that access is denied. I understand that my web page is
impersonating as local\ASPNET user.
I am very confused! can you help me?
I will really appreciate it
Thanks,
SauminIf you use forms authentication you have to create an extension to implement
it. You need to read up on how to do so if you need this capability. It
requires some effort on your part and it requires enterprise edition. I
suggest that you remove anonymous access for now (so you can learn how to
write a report etc and then implement form based security later). For now,
use integrated security (anonymous access and integrated security is
mutually exclusive). To supplement the info on security in the bol I suggest
this link from Scott Allen:
http://odetocode.com/Articles/215.aspx
Bruce L-C
"Saumin" <saumin_patel@.hotmail.com> wrote in message
news:35be972d.0408171307.3e2d9cab@.posting.google.com...
> Hi,
> I am new to sql reporting services. I have just installed sql
> reporting service sp1. We have our own web app which uses forms
> authentication. I have a page where i use reportviewer control (which
> came along with samples)...to run a report...there is a separate
> physical report server and on that server, for the Reports virtual
> directory i have "anonymous access" set. Within this i have set domain
> user and password! Now microsot recommends to use "integrated windows
> authentication". But as soon as i set it, my web page gives me report
> server error that access is denied. I understand that my web page is
> impersonating as local\ASPNET user.
> I am very confused! can you help me?
> I will really appreciate it
> Thanks,
> Saumin
configuring the number of worker threads
We have a SQL 2000 server with max worker threads configured to be
3232767275275
The server sees some pretty high usage and we've been seeing some slow down
in the server. I've read that most systems run well with a value of 255.
I've also read something that suggests that lowering this value may help. Is
it better to lower the value or increase it to help performance?
Thanks
MG
Hi,
The default value set is 255 and is more than enough.
Most cases it is not required to increase the value; if the actual number
of connections exceeds the amount set in threads, SQL Server does a pooling
for worker threads so that the next available worker thread can handle the
request.
From Query anayzer run the command to get the correct value
SP_CONFIGURE 'max worker threads'
From the output see the running value. If the value is higher than 255 try
to change and monitor the threads using performance montor, Process, Thread
counter. This will give a clear picture of thread usage.
Thanks
Hari
SQL Server MVP
"MGeles" <michael.geles@.thomson.com> wrote in message
news:608FFF4F-87C3-4011-AB16-6C4412A23870@.microsoft.com...
> We have a SQL 2000 server with max worker threads configured to be
> 32 32767 275 275
> The server sees some pretty high usage and we've been seeing some slow
> down
> in the server. I've read that most systems run well with a value of 255.
> I've also read something that suggests that lowering this value may help.
> Is
> it better to lower the value or increase it to help performance?
> Thanks
> --
> MG
|||See http://support.microsoft.com/default...b;en-us;319942 for
additional information.
Adrian
"MGeles" <michael.geles@.thomson.com> wrote in message
news:608FFF4F-87C3-4011-AB16-6C4412A23870@.microsoft.com...
> We have a SQL 2000 server with max worker threads configured to be
> 32 32767 275 275
> The server sees some pretty high usage and we've been seeing some slow
> down
> in the server. I've read that most systems run well with a value of 255.
> I've also read something that suggests that lowering this value may help.
> Is
> it better to lower the value or increase it to help performance?
> Thanks
> --
> MG
|||MGeles,
This is a very small part of a much wider area of performance tuning. Have a
look through the articles at www.sql-server-performance.com for some
excellent methods on tuning your server.
You need to ascertain in a nutshell:
1) Is there any blocking happening > 1 sec
2) Is the disk IO bound
3) Is the server CPU bound
4) Which queries slow down the server
5) How much paging is happening in windows
6) How's the sql server buffer cache hit ratio - indicates RAM starvation
Also check your query plans and make sure your indexing is optimal. A
technique I use is to trace a typical workload into a SQL server table and
then query the trace table for the most cpu, io intensive and longest running
queries. I then check the query plans for these queries, and also the code.
You may even want to look at the database design itself - the biggest
performance bangs for your buck can often be obtained through tuning your
database design.
Regards,
Mark.
"MGeles" wrote:
> We have a SQL 2000 server with max worker threads configured to be
> 3232767275275
> The server sees some pretty high usage and we've been seeing some slow down
> in the server. I've read that most systems run well with a value of 255.
> I've also read something that suggests that lowering this value may help. Is
> it better to lower the value or increase it to help performance?
> Thanks
> --
> MG
3232767275275
The server sees some pretty high usage and we've been seeing some slow down
in the server. I've read that most systems run well with a value of 255.
I've also read something that suggests that lowering this value may help. Is
it better to lower the value or increase it to help performance?
Thanks
MG
Hi,
The default value set is 255 and is more than enough.
Most cases it is not required to increase the value; if the actual number
of connections exceeds the amount set in threads, SQL Server does a pooling
for worker threads so that the next available worker thread can handle the
request.
From Query anayzer run the command to get the correct value
SP_CONFIGURE 'max worker threads'
From the output see the running value. If the value is higher than 255 try
to change and monitor the threads using performance montor, Process, Thread
counter. This will give a clear picture of thread usage.
Thanks
Hari
SQL Server MVP
"MGeles" <michael.geles@.thomson.com> wrote in message
news:608FFF4F-87C3-4011-AB16-6C4412A23870@.microsoft.com...
> We have a SQL 2000 server with max worker threads configured to be
> 32 32767 275 275
> The server sees some pretty high usage and we've been seeing some slow
> down
> in the server. I've read that most systems run well with a value of 255.
> I've also read something that suggests that lowering this value may help.
> Is
> it better to lower the value or increase it to help performance?
> Thanks
> --
> MG
|||See http://support.microsoft.com/default...b;en-us;319942 for
additional information.
Adrian
"MGeles" <michael.geles@.thomson.com> wrote in message
news:608FFF4F-87C3-4011-AB16-6C4412A23870@.microsoft.com...
> We have a SQL 2000 server with max worker threads configured to be
> 32 32767 275 275
> The server sees some pretty high usage and we've been seeing some slow
> down
> in the server. I've read that most systems run well with a value of 255.
> I've also read something that suggests that lowering this value may help.
> Is
> it better to lower the value or increase it to help performance?
> Thanks
> --
> MG
|||MGeles,
This is a very small part of a much wider area of performance tuning. Have a
look through the articles at www.sql-server-performance.com for some
excellent methods on tuning your server.
You need to ascertain in a nutshell:
1) Is there any blocking happening > 1 sec
2) Is the disk IO bound
3) Is the server CPU bound
4) Which queries slow down the server
5) How much paging is happening in windows
6) How's the sql server buffer cache hit ratio - indicates RAM starvation
Also check your query plans and make sure your indexing is optimal. A
technique I use is to trace a typical workload into a SQL server table and
then query the trace table for the most cpu, io intensive and longest running
queries. I then check the query plans for these queries, and also the code.
You may even want to look at the database design itself - the biggest
performance bangs for your buck can often be obtained through tuning your
database design.
Regards,
Mark.
"MGeles" wrote:
> We have a SQL 2000 server with max worker threads configured to be
> 3232767275275
> The server sees some pretty high usage and we've been seeing some slow down
> in the server. I've read that most systems run well with a value of 255.
> I've also read something that suggests that lowering this value may help. Is
> it better to lower the value or increase it to help performance?
> Thanks
> --
> MG
configuring the number of worker threads
We have a SQL 2000 server with max worker threads configured to be
32 32767 275 275
The server sees some pretty high usage and we've been seeing some slow down
in the server. I've read that most systems run well with a value of 255.
I've also read something that suggests that lowering this value may help. I
s
it better to lower the value or increase it to help performance?
Thanks
--
MGHi,
The default value set is 255 and is more than enough.
Most cases it is not required to increase the value; if the actual number
of connections exceeds the amount set in threads, SQL Server does a pooling
for worker threads so that the next available worker thread can handle the
request.
From Query anayzer run the command to get the correct value
SP_CONFIGURE 'max worker threads'
From the output see the running value. If the value is higher than 255 try
to change and monitor the threads using performance montor, Process, Thread
counter. This will give a clear picture of thread usage.
Thanks
Hari
SQL Server MVP
"MGeles" <michael.geles@.thomson.com> wrote in message
news:608FFF4F-87C3-4011-AB16-6C4412A23870@.microsoft.com...
> We have a SQL 2000 server with max worker threads configured to be
> 32 32767 275 275
> The server sees some pretty high usage and we've been seeing some slow
> down
> in the server. I've read that most systems run well with a value of 255.
> I've also read something that suggests that lowering this value may help.
> Is
> it better to lower the value or increase it to help performance?
> Thanks
> --
> MG|||See http://support.microsoft.com/defaul...kb;en-us;319942 for
additional information.
Adrian
"MGeles" <michael.geles@.thomson.com> wrote in message
news:608FFF4F-87C3-4011-AB16-6C4412A23870@.microsoft.com...
> We have a SQL 2000 server with max worker threads configured to be
> 32 32767 275 275
> The server sees some pretty high usage and we've been seeing some slow
> down
> in the server. I've read that most systems run well with a value of 255.
> I've also read something that suggests that lowering this value may help.
> Is
> it better to lower the value or increase it to help performance?
> Thanks
> --
> MG|||MGeles,
This is a very small part of a much wider area of performance tuning. Have a
look through the articles at www.sql-server-performance.com for some
excellent methods on tuning your server.
You need to ascertain in a nutshell:
1) Is there any blocking happening > 1 sec
2) Is the disk IO bound
3) Is the server CPU bound
4) Which queries slow down the server
5) How much paging is happening in windows
6) How's the sql server buffer cache hit ratio - indicates RAM starvation
Also check your query plans and make sure your indexing is optimal. A
technique I use is to trace a typical workload into a SQL server table and
then query the trace table for the most cpu, io intensive and longest runnin
g
queries. I then check the query plans for these queries, and also the code.
You may even want to look at the database design itself - the biggest
performance bangs for your buck can often be obtained through tuning your
database design.
Regards,
Mark.
"MGeles" wrote:
> We have a SQL 2000 server with max worker threads configured to be
> 32 32767 275 275
> The server sees some pretty high usage and we've been seeing some slow dow
n
> in the server. I've read that most systems run well with a value of 255.
> I've also read something that suggests that lowering this value may help.
Is
> it better to lower the value or increase it to help performance?
> Thanks
> --
> MG
32 32767 275 275
The server sees some pretty high usage and we've been seeing some slow down
in the server. I've read that most systems run well with a value of 255.
I've also read something that suggests that lowering this value may help. I
s
it better to lower the value or increase it to help performance?
Thanks
--
MGHi,
The default value set is 255 and is more than enough.
Most cases it is not required to increase the value; if the actual number
of connections exceeds the amount set in threads, SQL Server does a pooling
for worker threads so that the next available worker thread can handle the
request.
From Query anayzer run the command to get the correct value
SP_CONFIGURE 'max worker threads'
From the output see the running value. If the value is higher than 255 try
to change and monitor the threads using performance montor, Process, Thread
counter. This will give a clear picture of thread usage.
Thanks
Hari
SQL Server MVP
"MGeles" <michael.geles@.thomson.com> wrote in message
news:608FFF4F-87C3-4011-AB16-6C4412A23870@.microsoft.com...
> We have a SQL 2000 server with max worker threads configured to be
> 32 32767 275 275
> The server sees some pretty high usage and we've been seeing some slow
> down
> in the server. I've read that most systems run well with a value of 255.
> I've also read something that suggests that lowering this value may help.
> Is
> it better to lower the value or increase it to help performance?
> Thanks
> --
> MG|||See http://support.microsoft.com/defaul...kb;en-us;319942 for
additional information.
Adrian
"MGeles" <michael.geles@.thomson.com> wrote in message
news:608FFF4F-87C3-4011-AB16-6C4412A23870@.microsoft.com...
> We have a SQL 2000 server with max worker threads configured to be
> 32 32767 275 275
> The server sees some pretty high usage and we've been seeing some slow
> down
> in the server. I've read that most systems run well with a value of 255.
> I've also read something that suggests that lowering this value may help.
> Is
> it better to lower the value or increase it to help performance?
> Thanks
> --
> MG|||MGeles,
This is a very small part of a much wider area of performance tuning. Have a
look through the articles at www.sql-server-performance.com for some
excellent methods on tuning your server.
You need to ascertain in a nutshell:
1) Is there any blocking happening > 1 sec
2) Is the disk IO bound
3) Is the server CPU bound
4) Which queries slow down the server
5) How much paging is happening in windows
6) How's the sql server buffer cache hit ratio - indicates RAM starvation
Also check your query plans and make sure your indexing is optimal. A
technique I use is to trace a typical workload into a SQL server table and
then query the trace table for the most cpu, io intensive and longest runnin
g
queries. I then check the query plans for these queries, and also the code.
You may even want to look at the database design itself - the biggest
performance bangs for your buck can often be obtained through tuning your
database design.
Regards,
Mark.
"MGeles" wrote:
> We have a SQL 2000 server with max worker threads configured to be
> 32 32767 275 275
> The server sees some pretty high usage and we've been seeing some slow dow
n
> in the server. I've read that most systems run well with a value of 255.
> I've also read something that suggests that lowering this value may help.
Is
> it better to lower the value or increase it to help performance?
> Thanks
> --
> MG
configuring the number of worker threads
We have a SQL 2000 server with max worker threads configured to be
32 32767 275 275
The server sees some pretty high usage and we've been seeing some slow down
in the server. I've read that most systems run well with a value of 255.
I've also read something that suggests that lowering this value may help. Is
it better to lower the value or increase it to help performance?
Thanks
--
MGHi,
The default value set is 255 and is more than enough.
Most cases it is not required to increase the value; if the actual number
of connections exceeds the amount set in threads, SQL Server does a pooling
for worker threads so that the next available worker thread can handle the
request.
From Query anayzer run the command to get the correct value
SP_CONFIGURE 'max worker threads'
From the output see the running value. If the value is higher than 255 try
to change and monitor the threads using performance montor, Process, Thread
counter. This will give a clear picture of thread usage.
Thanks
Hari
SQL Server MVP
"MGeles" <michael.geles@.thomson.com> wrote in message
news:608FFF4F-87C3-4011-AB16-6C4412A23870@.microsoft.com...
> We have a SQL 2000 server with max worker threads configured to be
> 32 32767 275 275
> The server sees some pretty high usage and we've been seeing some slow
> down
> in the server. I've read that most systems run well with a value of 255.
> I've also read something that suggests that lowering this value may help.
> Is
> it better to lower the value or increase it to help performance?
> Thanks
> --
> MG|||See http://support.microsoft.com/default.aspx?scid=kb;en-us;319942 for
additional information.
Adrian
"MGeles" <michael.geles@.thomson.com> wrote in message
news:608FFF4F-87C3-4011-AB16-6C4412A23870@.microsoft.com...
> We have a SQL 2000 server with max worker threads configured to be
> 32 32767 275 275
> The server sees some pretty high usage and we've been seeing some slow
> down
> in the server. I've read that most systems run well with a value of 255.
> I've also read something that suggests that lowering this value may help.
> Is
> it better to lower the value or increase it to help performance?
> Thanks
> --
> MG
32 32767 275 275
The server sees some pretty high usage and we've been seeing some slow down
in the server. I've read that most systems run well with a value of 255.
I've also read something that suggests that lowering this value may help. Is
it better to lower the value or increase it to help performance?
Thanks
--
MGHi,
The default value set is 255 and is more than enough.
Most cases it is not required to increase the value; if the actual number
of connections exceeds the amount set in threads, SQL Server does a pooling
for worker threads so that the next available worker thread can handle the
request.
From Query anayzer run the command to get the correct value
SP_CONFIGURE 'max worker threads'
From the output see the running value. If the value is higher than 255 try
to change and monitor the threads using performance montor, Process, Thread
counter. This will give a clear picture of thread usage.
Thanks
Hari
SQL Server MVP
"MGeles" <michael.geles@.thomson.com> wrote in message
news:608FFF4F-87C3-4011-AB16-6C4412A23870@.microsoft.com...
> We have a SQL 2000 server with max worker threads configured to be
> 32 32767 275 275
> The server sees some pretty high usage and we've been seeing some slow
> down
> in the server. I've read that most systems run well with a value of 255.
> I've also read something that suggests that lowering this value may help.
> Is
> it better to lower the value or increase it to help performance?
> Thanks
> --
> MG|||See http://support.microsoft.com/default.aspx?scid=kb;en-us;319942 for
additional information.
Adrian
"MGeles" <michael.geles@.thomson.com> wrote in message
news:608FFF4F-87C3-4011-AB16-6C4412A23870@.microsoft.com...
> We have a SQL 2000 server with max worker threads configured to be
> 32 32767 275 275
> The server sees some pretty high usage and we've been seeing some slow
> down
> in the server. I've read that most systems run well with a value of 255.
> I've also read something that suggests that lowering this value may help.
> Is
> it better to lower the value or increase it to help performance?
> Thanks
> --
> MG
Configuring the Full-Text Search Service on MSDE
Can anyone tell if MSDE has the full-text service available and if so how to set it up?
Thanks,
Ralph::Can anyone tell if MSDE has the full-text service available and if so how to set it up?
Yes.
No.
Means: Yes, I can tell. No, it simply is not available. You need the "real thing".
Configuring the code page of a OLEDB source.
hi,
i have a number of interfaces in which i have used oledb source.
the problem i am facing is oledb source components code page is not configurable now if i want to deploy the interface in a different environment which has a database with a different collation it gives a error that oledb source needs new metadata.
has anybody faced this problem earlier.please give me a solution to this problem ..
thanks in advance.
srikanth
Could you change the query to use cast around any varchar columns to force them the same or do you want to keep the collation for accents etc?Try changing the AlwaysUseDefaultCodePage property to true?
Configuring Text Log File Path in dtxConfig
Hi,
I am having trouble configuring the log file path in dtsconfig. I don't want to keep changing the log file path every time I change environments.
Here are the parameters.
<Configuration ConfiguredType="Property" Path="\Package.LogProviders[SSIS log provider for Text files].Properties[ConfigString]" ValueType="String">
<ConfiguredValue>SalesForceConnectLog</ConfiguredValue>
</Configuration>
<Configuration ConfiguredType="Property" Path="\Package.LogProviders[SSIS log provider for Text files].Properties[Name]" ValueType="String">
<ConfiguredValue>SSIS log provider for Text files</ConfiguredValue>
</Configuration>
I tried to enter the path on [ConfigString] but it didn't work.
Any Help is appreciated
Gulden
You don't update the log provider, you update the connection manager for that log provider.|||You are absolutely right. Your email also reminded me why I had ruled that out. It was a problem with logging to the same file from two different packages. I went back and corrected that.
Thanks for your answer..
Configuring subscription database as publication.
Hi, I need to configure this scenario
Part 1: Transactional publication configured in database A, the
subscriber is database B.
Part II: Configure a transactional publication in database B and send it
to database C and D.
I already configure the part 1 of the scenario. But when i try to
configure part B, i have the problem that the tables in database b Dont
have primary key, I try changing this option on each article:
"Delete all data in the the existing table". Assuming that if i already
create the tables with primary key, it will work, but it didnt.
Do somebody know how to configure it?
Thanks a lot for your help.
*** Sent via Developersdex http://www.codecomments.com ***
Maria,
on the article properties, select to take the declarative referential
integrity. This'll ensure that PKs don't become just unique indexes on the
subscriber, and the PKs will be created there.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
Part 1: Transactional publication configured in database A, the
subscriber is database B.
Part II: Configure a transactional publication in database B and send it
to database C and D.
I already configure the part 1 of the scenario. But when i try to
configure part B, i have the problem that the tables in database b Dont
have primary key, I try changing this option on each article:
"Delete all data in the the existing table". Assuming that if i already
create the tables with primary key, it will work, but it didnt.
Do somebody know how to configure it?
Thanks a lot for your help.
*** Sent via Developersdex http://www.codecomments.com ***
Maria,
on the article properties, select to take the declarative referential
integrity. This'll ensure that PKs don't become just unique indexes on the
subscriber, and the PKs will be created there.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
Configuring SSIS package to read a value before executin
Hi,
Is it possible in any ways to Configure a SSIS package in such a way that based on the User Input the package runs. For e.g if there is a table which has say 10 distinct groups. Normal SSIS package would ideally pick all the data from the source to the Destination
I want to know how to configure in Such a way that I should be able to say Group X as the input and data related to GroupX alone should be copied.
Select * from SomeTable where GroupName = @.CongigVar.
how to achieve something like this?
thanks
Hello,
What kind of input are you intrested in getting?
If you have the group name that you want to get information from in a table, you can, in control flow, make a query to a table, and put it on a variable, then on the data flow you can use the variable as a parameter.
To use it on a parameter your query should be
"Select * from SomeTable where GroupName = ?"
Then in the parameter button on the left you choose the variable that will pass tha value to the question mark.
Is that good for you?
Regards,
|||Hello,
I think that might just be what I need, but when I tried creating one, its failing with the error, 'Parameter Name Unrecognized'. I think am doing it wrongly. Can you post some links that explains how to put a value from a table onto a variable, and then use it as i/p to a Data flow?
thanks
|||Nfrf wrote:
Hello,
What kind of input are you intrested in getting?
If you have the group name that you want to get information from in a table, you can, in control flow, make a query to a table, and put it on a variable, then on the data flow you can use the variable as a parameter.
To use it on a parameter your query should be
"Select * from SomeTable where GroupName = ?"
Then in the parameter button on the left you choose the variable that will pass tha value to the question mark.
Is that good for you?
Regards,
There's no need to store values in a table. You can parameterize your package by passing it values when you call it. Explore the /SET option of dtexec. All the information you require is in Books Online.
-Jamie
|||
Yes it is true. I just gave him a way.
The thing that i thnik he wanted to know was the parameter on the query.
Even so thanks
Configuring SSIS in an Active\Active Cluster
OK so I am aware that the SSIS service can be clustered relatively easily but my problem is a bit more complex I believe.
I have an Active\Active\Active 3 node cluster running Windows 2003 sp1 all running SSIS packages. What I need is a solution to having an instance fail to another node and still be able to run scheduled SSIS packages through the SQL Agent.
The solution that I have come up with is to have a single network share for all three instances of SSIS running locally on the individual nodes. I have removed the ability for SSIS to look in MSDB by altering the config file and reference only the Packages share on the network for accessability. They all share the same config file on the share as well. The share structure looks something like this simplified example.
\\server1\SSIS\Configuration
\\server1\SSIS\Packages
\\server1\SSIS\Packages\Instance1\
\\server1\SSIS\Packages\Instance2\
\\server1\SSIS\Packages\Instance3\
Once I change the registry to point to the config file all three instances can access the Instance1, 2 or 3 directories.
This works ok for the jobs, and I can access the stored packages under the file system folder only if I'm remotely connected to that particular physical server hosting the service or on the console. The problem I am having though is when users or I attempt to access the SSIS Engine through SSMS from our locale machines. It seems as though SSMS is having trouble with the passthrough of the directory information. On the share I obviously have permissiosn to access the directory structure (full control to be exact) because I can get to it when I access it from SSMS on the server.
This is the error I get...
Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476
ADDITIONAL INFORMATION:
The storage location for the folder "File System\" cannot be accessed. (MsDtsSrvr)
DETAILS:
Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476
Program Location:
at Microsoft.SqlServer.Management.Smo.Enumerator.Process(Object connectionInfo, Request request)
at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.NavigableItemBuilder.BuildDynamicItemWithQuery(IList nodes, INodeInformation source, INavigableItem sourceItem, String urnQuery, Boolean registerBuilder, Boolean registerBuiltItems)
at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.NavigableItemBuilder.BuildDynamicItem(IList nodes, INodeInformation source, INavigableItem sourceItem, IFilterProvider filter)
at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.NavigableItemBuilder.Build(INodeInformation source, INavigableItem sourceItem, IFilterProvider filter)
at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.NavigableItem.GetChildren()
at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.ExplorerHierarchyNode.BuildChildren()
===================================
The storage location for the folder "File System\" cannot be accessed. (MsDtsSrvr)
Program Location:
at Microsoft.SqlServer.Dts.Runtime.Application.GetDtsServerPackageInfos(String sPackageFolder, String sServerName)
at Microsoft.SqlServer.Dts.SmoEnum.PackageEnum.GetData(EnumResult erParent)
at Microsoft.SqlServer.Management.Smo.Environment.GetData()
at Microsoft.SqlServer.Management.Smo.Environment.GetData(Request req, Object ci)
at Microsoft.SqlServer.Management.Smo.Enumerator.GetData(Object connectionInfo, Request request)
at Microsoft.SqlServer.Management.Smo.Enumerator.Process(Object connectionInfo, Request request)
Any work around or suggestion would be appreciated.
Thanks,
Zach
Anyone have any thoughts on how to make this work?
Thanks for the look,
Zach
Configuring SQLXML IIS
I have configured a virtual directory with my local SQL
Server and local IIS. I am able to execute my templates
without any problems. Pretty cool stuff!
Now I would like to do the same on our production SQL
Server and web server. The SQL Server and web server are
on two different machines. I have read that it is
possible to do this but I am confused as to which
computer I need to connect to through the IIS Virtual
Directory Management console. I am assuming it is the
web server. I tried both the SQL and web server and got
the same error - "An error occured connecting to
<server>. This server does not exist or is unavailable."
1. Can the web server reside on another machine?
2. Which server needs to be configured?
3. Why would I receive the error that I am getting?
Thank you for any assistance that you can provide.
Jason
Yes, the Web Server can be separate from the SQL Server. It's the Web server
you need to configure with the IIS Virtual Directory Management tool, but it
will need to have SQLXML installed. You'll also need to think carefully
about how you configure authentication in your SQLISAPI Virtual Directory.
As for the error, at face-value it looks like a networking issue - I assume
you've tried the usual troubleshooting approaches (i.e. pinging the server
by name or by IP address)?
Graeme Malcolm
Principal Technologist
Content Master Ltd.
"Jason" <anonymous@.discussions.microsoft.com> wrote in message
news:19bc001c42247$c41fd760$a601280a@.phx.gbl...
> I have configured a virtual directory with my local SQL
> Server and local IIS. I am able to execute my templates
> without any problems. Pretty cool stuff!
> Now I would like to do the same on our production SQL
> Server and web server. The SQL Server and web server are
> on two different machines. I have read that it is
> possible to do this but I am confused as to which
> computer I need to connect to through the IIS Virtual
> Directory Management console. I am assuming it is the
> web server. I tried both the SQL and web server and got
> the same error - "An error occured connecting to
> <server>. This server does not exist or is unavailable."
> 1. Can the web server reside on another machine?
> 2. Which server needs to be configured?
> 3. Why would I receive the error that I am getting?
> Thank you for any assistance that you can provide.
> Jason
>
|||Thanks Graeme, what do you mean about configuring
authentication? Are you referring to a user's ability to
access the templates? That was going to be my next
question!
Say I have these templates in my virtual directory that
can be called via HTTP. Anyone can get at them. Is
there a way to pass user credentials to the template in
order to authenticate the user who is trying to access
the template?
Jason
>--Original Message--
>Yes, the Web Server can be separate from the SQL Server.
It's the Web server
>you need to configure with the IIS Virtual Directory
Management tool, but it
>will need to have SQLXML installed. You'll also need to
think carefully
>about how you configure authentication in your SQLISAPI
Virtual Directory.
>As for the error, at face-value it looks like a
networking issue - I assume
>you've tried the usual troubleshooting approaches (i.e.
pinging the server
>by name or by IP address)?
>--
>Graeme Malcolm
>Principal Technologist
>Content Master Ltd.
>"Jason" <anonymous@.discussions.microsoft.com> wrote in
message[vbcol=seagreen]
>news:19bc001c42247$c41fd760$a601280a@.phx.gbl...
templates[vbcol=seagreen]
are[vbcol=seagreen]
unavailable."
>
>.
>
|||There are two things that require authentication here.
1. The virtual directory (and the physical template file). You'll need to
decide if your going to allow anonymous access to the virtual directory, in
which case the IUSR_computername accunt will need NTFS file permissions on
the virtual directory folder and the folder containing the templates (if
different), or whether you'll use Windows authentication (in which case the
user's domain account needs the appropriate NTFS permissions. This is just
like any other IIS Web site, and you can use the standard IIS admin tool to
configure site authentication.
2. SQL Server. You've got 4 choices here: (a) Have IIS connect to SQL Server
on the user's behalf, using Windows authentication (select "Always log on
as" and specify the Windows credentials in the virtual directory properties
Security tab - by default it will use the IUSR_computername account and
allow you to automatically synchronize the password. Alternatively, you can
specify any Windows account that you want to and specify the password), (b)
Have IIS connect to SQL Server on the user's behalf, using SQL Server
authentication (select "Always log on as" and specify the SQL Server login
credentials in the virtual directory properties Security tab - you might
also need to enable SQL Server authentication on the SQL Server since by
default it only uses Windows authentication), (c) Have IIS impersonate the
user's Windows credentials when accessing SQL Server (Select "Use Windows
Integrated Authentication" in the virtual directory properties Security
tab), or (d) Have IIS prompt for the user's SQL Server credentials and pass
them to SQL Server using clear text (Select "Use Basic Authentication (Clear
Text) to SQL Server account" in the virtual directory properties Security
tab).
In more general terms (a) and (b) are a form of the "Trusted Server" model
(in which the Web Server application is trusted to use its own credentials
to access the database on the user's behalf), while (c) and (d) are forms of
the "Impersonation/Delegation" model, in which the Web Server accesses the
database using the user's credentials.
In most cases, I'd tend to recommend (a), because it will allow IIS to use
connection pooling (and therefore make the application more scalable).
However, it does mean that everyone who accesses the database through the
Web site uses the same login to SQL Server. If your application is on an
Intranet and you need to force users to use their own account when accessing
SQl Server, then I'd go for (c), in which case Internet Explorer will
automatically send their domain credentials (assuming they're logged into a
domain) or prompt them for their Windows login. The main thing is that the
credentials are encrypted on the network. If you were to use (d) you'd have
to configure the virtual directory to use SSL in order to pass the login
details securely.
Hope that helps,
Graeme
Graeme Malcolm
Principal Technologist
Content Master Ltd.
"Jason" <anonymous@.discussions.microsoft.com> wrote in message
news:1d43801c422ec$75616580$a101280a@.phx.gbl...[vbcol=seagreen]
> Thanks Graeme, what do you mean about configuring
> authentication? Are you referring to a user's ability to
> access the templates? That was going to be my next
> question!
> Say I have these templates in my virtual directory that
> can be called via HTTP. Anyone can get at them. Is
> there a way to pass user credentials to the template in
> order to authenticate the user who is trying to access
> the template?
> Jason
>
> It's the Web server
> Management tool, but it
> think carefully
> Virtual Directory.
> networking issue - I assume
> pinging the server
> message
> templates
> are
> unavailable."
Server and local IIS. I am able to execute my templates
without any problems. Pretty cool stuff!
Now I would like to do the same on our production SQL
Server and web server. The SQL Server and web server are
on two different machines. I have read that it is
possible to do this but I am confused as to which
computer I need to connect to through the IIS Virtual
Directory Management console. I am assuming it is the
web server. I tried both the SQL and web server and got
the same error - "An error occured connecting to
<server>. This server does not exist or is unavailable."
1. Can the web server reside on another machine?
2. Which server needs to be configured?
3. Why would I receive the error that I am getting?
Thank you for any assistance that you can provide.
Jason
Yes, the Web Server can be separate from the SQL Server. It's the Web server
you need to configure with the IIS Virtual Directory Management tool, but it
will need to have SQLXML installed. You'll also need to think carefully
about how you configure authentication in your SQLISAPI Virtual Directory.
As for the error, at face-value it looks like a networking issue - I assume
you've tried the usual troubleshooting approaches (i.e. pinging the server
by name or by IP address)?
Graeme Malcolm
Principal Technologist
Content Master Ltd.
"Jason" <anonymous@.discussions.microsoft.com> wrote in message
news:19bc001c42247$c41fd760$a601280a@.phx.gbl...
> I have configured a virtual directory with my local SQL
> Server and local IIS. I am able to execute my templates
> without any problems. Pretty cool stuff!
> Now I would like to do the same on our production SQL
> Server and web server. The SQL Server and web server are
> on two different machines. I have read that it is
> possible to do this but I am confused as to which
> computer I need to connect to through the IIS Virtual
> Directory Management console. I am assuming it is the
> web server. I tried both the SQL and web server and got
> the same error - "An error occured connecting to
> <server>. This server does not exist or is unavailable."
> 1. Can the web server reside on another machine?
> 2. Which server needs to be configured?
> 3. Why would I receive the error that I am getting?
> Thank you for any assistance that you can provide.
> Jason
>
|||Thanks Graeme, what do you mean about configuring
authentication? Are you referring to a user's ability to
access the templates? That was going to be my next
question!
Say I have these templates in my virtual directory that
can be called via HTTP. Anyone can get at them. Is
there a way to pass user credentials to the template in
order to authenticate the user who is trying to access
the template?
Jason
>--Original Message--
>Yes, the Web Server can be separate from the SQL Server.
It's the Web server
>you need to configure with the IIS Virtual Directory
Management tool, but it
>will need to have SQLXML installed. You'll also need to
think carefully
>about how you configure authentication in your SQLISAPI
Virtual Directory.
>As for the error, at face-value it looks like a
networking issue - I assume
>you've tried the usual troubleshooting approaches (i.e.
pinging the server
>by name or by IP address)?
>--
>Graeme Malcolm
>Principal Technologist
>Content Master Ltd.
>"Jason" <anonymous@.discussions.microsoft.com> wrote in
message[vbcol=seagreen]
>news:19bc001c42247$c41fd760$a601280a@.phx.gbl...
templates[vbcol=seagreen]
are[vbcol=seagreen]
unavailable."
>
>.
>
|||There are two things that require authentication here.
1. The virtual directory (and the physical template file). You'll need to
decide if your going to allow anonymous access to the virtual directory, in
which case the IUSR_computername accunt will need NTFS file permissions on
the virtual directory folder and the folder containing the templates (if
different), or whether you'll use Windows authentication (in which case the
user's domain account needs the appropriate NTFS permissions. This is just
like any other IIS Web site, and you can use the standard IIS admin tool to
configure site authentication.
2. SQL Server. You've got 4 choices here: (a) Have IIS connect to SQL Server
on the user's behalf, using Windows authentication (select "Always log on
as" and specify the Windows credentials in the virtual directory properties
Security tab - by default it will use the IUSR_computername account and
allow you to automatically synchronize the password. Alternatively, you can
specify any Windows account that you want to and specify the password), (b)
Have IIS connect to SQL Server on the user's behalf, using SQL Server
authentication (select "Always log on as" and specify the SQL Server login
credentials in the virtual directory properties Security tab - you might
also need to enable SQL Server authentication on the SQL Server since by
default it only uses Windows authentication), (c) Have IIS impersonate the
user's Windows credentials when accessing SQL Server (Select "Use Windows
Integrated Authentication" in the virtual directory properties Security
tab), or (d) Have IIS prompt for the user's SQL Server credentials and pass
them to SQL Server using clear text (Select "Use Basic Authentication (Clear
Text) to SQL Server account" in the virtual directory properties Security
tab).
In more general terms (a) and (b) are a form of the "Trusted Server" model
(in which the Web Server application is trusted to use its own credentials
to access the database on the user's behalf), while (c) and (d) are forms of
the "Impersonation/Delegation" model, in which the Web Server accesses the
database using the user's credentials.
In most cases, I'd tend to recommend (a), because it will allow IIS to use
connection pooling (and therefore make the application more scalable).
However, it does mean that everyone who accesses the database through the
Web site uses the same login to SQL Server. If your application is on an
Intranet and you need to force users to use their own account when accessing
SQl Server, then I'd go for (c), in which case Internet Explorer will
automatically send their domain credentials (assuming they're logged into a
domain) or prompt them for their Windows login. The main thing is that the
credentials are encrypted on the network. If you were to use (d) you'd have
to configure the virtual directory to use SSL in order to pass the login
details securely.
Hope that helps,
Graeme
Graeme Malcolm
Principal Technologist
Content Master Ltd.
"Jason" <anonymous@.discussions.microsoft.com> wrote in message
news:1d43801c422ec$75616580$a101280a@.phx.gbl...[vbcol=seagreen]
> Thanks Graeme, what do you mean about configuring
> authentication? Are you referring to a user's ability to
> access the templates? That was going to be my next
> question!
> Say I have these templates in my virtual directory that
> can be called via HTTP. Anyone can get at them. Is
> there a way to pass user credentials to the template in
> order to authenticate the user who is trying to access
> the template?
> Jason
>
> It's the Web server
> Management tool, but it
> think carefully
> Virtual Directory.
> networking issue - I assume
> pinging the server
> message
> templates
> are
> unavailable."
Configuring SQLServerAgent 2000 mail session
How do I configure the SQLServerAgent 2000 mail session? Do I need MS Outlook installed on the server?How do I configure the SQLServerAgent 2000 mail session? Do I need MS Outlook installed on the server?
Yes you do. More specifically, you need MS Outlook 2000.
Try this link (http://support.microsoft.com/kb/263556). Bear in mind that SQL Agent Mail and SQL Mail are different, and must be configured separately (though you don't have to configure both).
In general, I HATE SQL Agent Mail. If Outlook hangs or whatever reason, you can potentially hang your entire job scheduling process. It can get real ugly real fast.
Google SMTP solutions for SQL 2000 and you'll find a lot of other options. Best bet, though, is to go with SQL 2005 and use the new database mail feature (which is SMTP based).
Regards,
hmscott
Yes you do. More specifically, you need MS Outlook 2000.
Try this link (http://support.microsoft.com/kb/263556). Bear in mind that SQL Agent Mail and SQL Mail are different, and must be configured separately (though you don't have to configure both).
In general, I HATE SQL Agent Mail. If Outlook hangs or whatever reason, you can potentially hang your entire job scheduling process. It can get real ugly real fast.
Google SMTP solutions for SQL 2000 and you'll find a lot of other options. Best bet, though, is to go with SQL 2005 and use the new database mail feature (which is SMTP based).
Regards,
hmscott
Configuring SQLMail on Standalone PC
Hi,
I want to try some programs using SQL Mail on my Local/Standalone PC.
I do not have a network connection and only have a dialup connection.
How do I setup/configure SQLMail in SQL2000? When I read about it, it
says that I need to have mailbox/profile setup. But I don't have
Exchange Server too.
Somehow I got hold of Exchange Server 2000 120-Eval edition. But I am
unable to install the same, because it says that it needs Active
Directory to be setup first.
Now my Win2K Server is already installed and I don't have Active
Directory setup. Is it possible to setup Active Directory on a
Local/Standalone PC which doesn't have Network card.
Please let me know if there is any possible way to write and test some
programs on a Standalone Win2K Server with is not connected to any
server. What will be the prerequisites of Standalone PC to use
SQLMail locally for testing purpose.
Thanks,
KamleshCan you use SMTP instead? http://www.aspfaq.com/2403
--
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"Kamlesh" <kamlesh2000@.yahoo.com> wrote in message
news:2644c0f6.0311212150.7bba5122@.posting.google.com...
> Hi,
> I want to try some programs using SQL Mail on my Local/Standalone PC.
> I do not have a network connection and only have a dialup connection.
> How do I setup/configure SQLMail in SQL2000? When I read about it, it
> says that I need to have mailbox/profile setup. But I don't have
> Exchange Server too.
> Somehow I got hold of Exchange Server 2000 120-Eval edition. But I am
> unable to install the same, because it says that it needs Active
> Directory to be setup first.
> Now my Win2K Server is already installed and I don't have Active
> Directory setup. Is it possible to setup Active Directory on a
> Local/Standalone PC which doesn't have Network card.
> Please let me know if there is any possible way to write and test some
> programs on a Standalone Win2K Server with is not connected to any
> server. What will be the prerequisites of Standalone PC to use
> SQLMail locally for testing purpose.
> Thanks,
> Kamlesh
I want to try some programs using SQL Mail on my Local/Standalone PC.
I do not have a network connection and only have a dialup connection.
How do I setup/configure SQLMail in SQL2000? When I read about it, it
says that I need to have mailbox/profile setup. But I don't have
Exchange Server too.
Somehow I got hold of Exchange Server 2000 120-Eval edition. But I am
unable to install the same, because it says that it needs Active
Directory to be setup first.
Now my Win2K Server is already installed and I don't have Active
Directory setup. Is it possible to setup Active Directory on a
Local/Standalone PC which doesn't have Network card.
Please let me know if there is any possible way to write and test some
programs on a Standalone Win2K Server with is not connected to any
server. What will be the prerequisites of Standalone PC to use
SQLMail locally for testing purpose.
Thanks,
KamleshCan you use SMTP instead? http://www.aspfaq.com/2403
--
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"Kamlesh" <kamlesh2000@.yahoo.com> wrote in message
news:2644c0f6.0311212150.7bba5122@.posting.google.com...
> Hi,
> I want to try some programs using SQL Mail on my Local/Standalone PC.
> I do not have a network connection and only have a dialup connection.
> How do I setup/configure SQLMail in SQL2000? When I read about it, it
> says that I need to have mailbox/profile setup. But I don't have
> Exchange Server too.
> Somehow I got hold of Exchange Server 2000 120-Eval edition. But I am
> unable to install the same, because it says that it needs Active
> Directory to be setup first.
> Now my Win2K Server is already installed and I don't have Active
> Directory setup. Is it possible to setup Active Directory on a
> Local/Standalone PC which doesn't have Network card.
> Please let me know if there is any possible way to write and test some
> programs on a Standalone Win2K Server with is not connected to any
> server. What will be the prerequisites of Standalone PC to use
> SQLMail locally for testing purpose.
> Thanks,
> Kamlesh
Friday, 17 February 2012
Configuring SQLMAIL
Hi
I wanted to send an email through sql server 2000.Before sending i need to
configure a profilename in Sqlmail from enterprise mananger.
And i took profile name from controlpanel>mail
While entering MAPI profile name and click on test button i get the below
error
xp_test_mapi_profile:failed with mail error 0x8004011
I have below environment on my system
OS : windows xp with updated service pack
OutLook 2000 configured with exchange server
can u help me out from this problem or can u tell step by step process of
configuring
Hi
Login with the SQL Server Service Domain Account.
Setup the mail profile.
Logout
Login again and then select the profile you created earlier under the
Support Service > SQL Mail in EM. If it is not in the dropdown, the profile
is not correct.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"TreeView Custom" wrote:
> Hi
> I wanted to send an email through sql server 2000.Before sending i need to
> configure a profilename in Sqlmail from enterprise mananger.
> And i took profile name from controlpanel>mail
>
> While entering MAPI profile name and click on test button i get the below
> error
> xp_test_mapi_profile:failed with mail error 0x8004011
> I have below environment on my system
> OS : windows xp with updated service pack
> OutLook 2000 configured with exchange server
>
> can u help me out from this problem or can u tell step by step process of
> configuring
>
|||Hi,
I think information on this link will help, especially on the step by step:
http://msdn.microsoft.com/library/de...rverE-mail.asp
Thanks,
RdR
"TreeView Custom" <TreeViewCustom@.discussions.microsoft.com> wrote in
message news:9CF6600D-741C-4736-AC14-1955499FE8DE@.microsoft.com...
> Hi
> I wanted to send an email through sql server 2000.Before sending i need to
> configure a profilename in Sqlmail from enterprise mananger.
> And i took profile name from controlpanel>mail
>
> While entering MAPI profile name and click on test button i get the below
> error
> xp_test_mapi_profile:failed with mail error 0x8004011
> I have below environment on my system
> OS : windows xp with updated service pack
> OutLook 2000 configured with exchange server
>
> can u help me out from this problem or can u tell step by step process of
> configuring
>
I wanted to send an email through sql server 2000.Before sending i need to
configure a profilename in Sqlmail from enterprise mananger.
And i took profile name from controlpanel>mail
While entering MAPI profile name and click on test button i get the below
error
xp_test_mapi_profile:failed with mail error 0x8004011
I have below environment on my system
OS : windows xp with updated service pack
OutLook 2000 configured with exchange server
can u help me out from this problem or can u tell step by step process of
configuring
Hi
Login with the SQL Server Service Domain Account.
Setup the mail profile.
Logout
Login again and then select the profile you created earlier under the
Support Service > SQL Mail in EM. If it is not in the dropdown, the profile
is not correct.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"TreeView Custom" wrote:
> Hi
> I wanted to send an email through sql server 2000.Before sending i need to
> configure a profilename in Sqlmail from enterprise mananger.
> And i took profile name from controlpanel>mail
>
> While entering MAPI profile name and click on test button i get the below
> error
> xp_test_mapi_profile:failed with mail error 0x8004011
> I have below environment on my system
> OS : windows xp with updated service pack
> OutLook 2000 configured with exchange server
>
> can u help me out from this problem or can u tell step by step process of
> configuring
>
|||Hi,
I think information on this link will help, especially on the step by step:
http://msdn.microsoft.com/library/de...rverE-mail.asp
Thanks,
RdR
"TreeView Custom" <TreeViewCustom@.discussions.microsoft.com> wrote in
message news:9CF6600D-741C-4736-AC14-1955499FE8DE@.microsoft.com...
> Hi
> I wanted to send an email through sql server 2000.Before sending i need to
> configure a profilename in Sqlmail from enterprise mananger.
> And i took profile name from controlpanel>mail
>
> While entering MAPI profile name and click on test button i get the below
> error
> xp_test_mapi_profile:failed with mail error 0x8004011
> I have below environment on my system
> OS : windows xp with updated service pack
> OutLook 2000 configured with exchange server
>
> can u help me out from this problem or can u tell step by step process of
> configuring
>
Configuring SQLMAIL
Hi
I wanted to send an email through sql server 2000.Before sending i need to
configure a profilename in Sqlmail from enterprise mananger.
And i took profile name from controlpanel>mail
While entering MAPI profile name and click on test button i get the below
error
xp_test_mapi_profile:failed with mail error 0x8004011
I have below environment on my system
---
OS : Windows XP with updated service pack
OutLook 2000 configured with exchange server
can u help me out from this problem or can u tell step by step process of
configuringHi
Login with the SQL Server Service Domain Account.
Setup the mail profile.
Logout
Login again and then select the profile you created earlier under the
Support Service > SQL Mail in EM. If it is not in the dropdown, the profile
is not correct.
Regards
--
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"TreeView Custom" wrote:
> Hi
> I wanted to send an email through sql server 2000.Before sending i need to
> configure a profilename in Sqlmail from enterprise mananger.
> And i took profile name from controlpanel>mail
>
> While entering MAPI profile name and click on test button i get the below
> error
> xp_test_mapi_profile:failed with mail error 0x8004011
> I have below environment on my system
> ---
> OS : Windows XP with updated service pack
> OutLook 2000 configured with exchange server
>
> can u help me out from this problem or can u tell step by step process of
> configuring
>|||Hi,
I think information on this link will help, especially on the step by step:
ServerE-mail.asp" target="_blank">http://msdn.microsoft.com/library/d...erverE-mail.asp
Thanks,
RdR
"TreeView Custom" <TreeViewCustom@.discussions.microsoft.com> wrote in
message news:9CF6600D-741C-4736-AC14-1955499FE8DE@.microsoft.com...
> Hi
> I wanted to send an email through sql server 2000.Before sending i need to
> configure a profilename in Sqlmail from enterprise mananger.
> And i took profile name from controlpanel>mail
>
> While entering MAPI profile name and click on test button i get the below
> error
> xp_test_mapi_profile:failed with mail error 0x8004011
> I have below environment on my system
> ---
> OS : Windows XP with updated service pack
> OutLook 2000 configured with exchange server
>
> can u help me out from this problem or can u tell step by step process of
> configuring
>
I wanted to send an email through sql server 2000.Before sending i need to
configure a profilename in Sqlmail from enterprise mananger.
And i took profile name from controlpanel>mail
While entering MAPI profile name and click on test button i get the below
error
xp_test_mapi_profile:failed with mail error 0x8004011
I have below environment on my system
---
OS : Windows XP with updated service pack
OutLook 2000 configured with exchange server
can u help me out from this problem or can u tell step by step process of
configuringHi
Login with the SQL Server Service Domain Account.
Setup the mail profile.
Logout
Login again and then select the profile you created earlier under the
Support Service > SQL Mail in EM. If it is not in the dropdown, the profile
is not correct.
Regards
--
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"TreeView Custom" wrote:
> Hi
> I wanted to send an email through sql server 2000.Before sending i need to
> configure a profilename in Sqlmail from enterprise mananger.
> And i took profile name from controlpanel>mail
>
> While entering MAPI profile name and click on test button i get the below
> error
> xp_test_mapi_profile:failed with mail error 0x8004011
> I have below environment on my system
> ---
> OS : Windows XP with updated service pack
> OutLook 2000 configured with exchange server
>
> can u help me out from this problem or can u tell step by step process of
> configuring
>|||Hi,
I think information on this link will help, especially on the step by step:
ServerE-mail.asp" target="_blank">http://msdn.microsoft.com/library/d...erverE-mail.asp
Thanks,
RdR
"TreeView Custom" <TreeViewCustom@.discussions.microsoft.com> wrote in
message news:9CF6600D-741C-4736-AC14-1955499FE8DE@.microsoft.com...
> Hi
> I wanted to send an email through sql server 2000.Before sending i need to
> configure a profilename in Sqlmail from enterprise mananger.
> And i took profile name from controlpanel>mail
>
> While entering MAPI profile name and click on test button i get the below
> error
> xp_test_mapi_profile:failed with mail error 0x8004011
> I have below environment on my system
> ---
> OS : Windows XP with updated service pack
> OutLook 2000 configured with exchange server
>
> can u help me out from this problem or can u tell step by step process of
> configuring
>
Configuring SQLMAIL
Hi
I wanted to send an email through sql server 2000.Before sending i need to
configure a profilename in Sqlmail from enterprise mananger.
And i took profile name from controlpanel>mail
While entering MAPI profile name and click on test button i get the below
error
xp_test_mapi_profile:failed with mail error 0x8004011
I have below environment on my system
---
OS : windows xp with updated service pack
OutLook 2000 configured with exchange server
can u help me out from this problem or can u tell step by step process of
configuringHi
Login with the SQL Server Service Domain Account.
Setup the mail profile.
Logout
Login again and then select the profile you created earlier under the
Support Service > SQL Mail in EM. If it is not in the dropdown, the profile
is not correct.
Regards
--
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"TreeView Custom" wrote:
> Hi
> I wanted to send an email through sql server 2000.Before sending i need to
> configure a profilename in Sqlmail from enterprise mananger.
> And i took profile name from controlpanel>mail
>
> While entering MAPI profile name and click on test button i get the below
> error
> xp_test_mapi_profile:failed with mail error 0x8004011
> I have below environment on my system
> ---
> OS : windows xp with updated service pack
> OutLook 2000 configured with exchange server
>
> can u help me out from this problem or can u tell step by step process of
> configuring
>|||Hi,
I think information on this link will help, especially on the step by step:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnovba01/html/SQLServerE-mail.asp
Thanks,
RdR
"TreeView Custom" <TreeViewCustom@.discussions.microsoft.com> wrote in
message news:9CF6600D-741C-4736-AC14-1955499FE8DE@.microsoft.com...
> Hi
> I wanted to send an email through sql server 2000.Before sending i need to
> configure a profilename in Sqlmail from enterprise mananger.
> And i took profile name from controlpanel>mail
>
> While entering MAPI profile name and click on test button i get the below
> error
> xp_test_mapi_profile:failed with mail error 0x8004011
> I have below environment on my system
> ---
> OS : windows xp with updated service pack
> OutLook 2000 configured with exchange server
>
> can u help me out from this problem or can u tell step by step process of
> configuring
>
I wanted to send an email through sql server 2000.Before sending i need to
configure a profilename in Sqlmail from enterprise mananger.
And i took profile name from controlpanel>mail
While entering MAPI profile name and click on test button i get the below
error
xp_test_mapi_profile:failed with mail error 0x8004011
I have below environment on my system
---
OS : windows xp with updated service pack
OutLook 2000 configured with exchange server
can u help me out from this problem or can u tell step by step process of
configuringHi
Login with the SQL Server Service Domain Account.
Setup the mail profile.
Logout
Login again and then select the profile you created earlier under the
Support Service > SQL Mail in EM. If it is not in the dropdown, the profile
is not correct.
Regards
--
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"TreeView Custom" wrote:
> Hi
> I wanted to send an email through sql server 2000.Before sending i need to
> configure a profilename in Sqlmail from enterprise mananger.
> And i took profile name from controlpanel>mail
>
> While entering MAPI profile name and click on test button i get the below
> error
> xp_test_mapi_profile:failed with mail error 0x8004011
> I have below environment on my system
> ---
> OS : windows xp with updated service pack
> OutLook 2000 configured with exchange server
>
> can u help me out from this problem or can u tell step by step process of
> configuring
>|||Hi,
I think information on this link will help, especially on the step by step:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnovba01/html/SQLServerE-mail.asp
Thanks,
RdR
"TreeView Custom" <TreeViewCustom@.discussions.microsoft.com> wrote in
message news:9CF6600D-741C-4736-AC14-1955499FE8DE@.microsoft.com...
> Hi
> I wanted to send an email through sql server 2000.Before sending i need to
> configure a profilename in Sqlmail from enterprise mananger.
> And i took profile name from controlpanel>mail
>
> While entering MAPI profile name and click on test button i get the below
> error
> xp_test_mapi_profile:failed with mail error 0x8004011
> I have below environment on my system
> ---
> OS : windows xp with updated service pack
> OutLook 2000 configured with exchange server
>
> can u help me out from this problem or can u tell step by step process of
> configuring
>
Subscribe to:
Posts (Atom)