Hi,
I have 2 SQL 2K Servers set up on my home network. Both PC's are running Windows XP and as far as I can tell are configured identically, however I can connect to the Server A from PC B but not Server B from PC A (both work fine when I am on the same machine I try to connect to). Any ideas anyone, the error message I am getting is attached.Could one server be configured to listen on named pipes, but not the other? Could one client be configured to use Named Pipes as its default client, while the other was configured to use TCP/IP? My guess is that one of the machines has a problem with either the client or the server network configuration.
-PatP|||If I understand you correctly you are able to connect from A to B but not from B to A, both A and B have an installation of SQLServer up and running. From the errormessage attached and the fact that you are able to setup a connection from A to B, I'd look for network issues on B. Are you able to ping A from B? Is A listed in the network neighbourhood on B? On A, is the SQL Agent running?
EDIT: sniped on a friday!|||Ok solved it, A had not had file and print sharing set up, didn't even think to check this as I could see it on the network, so assumed it was setup correctly!
Showing posts with label configured. Show all posts
Showing posts with label configured. Show all posts
Monday, 19 March 2012
Sunday, 19 February 2012
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 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 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."
Friday, 17 February 2012
Configuring SQL to use AWE
I have configured a SQL200 instance to use 5gb of my server's memory.
At startup the log indicates that AWE is being used, and I see
that the memory is being grabbed when the instance starts.
But in the log indicates that the Working Set Size is set to 1 GB.
Does this mean anything when using AWE..
Am I getting full use of AWE on my instance. How can I tell....
Thanks
Paul
Check the Buffer Manager counter in Perfmon. There are a set of
events/classes related to AWE which you can check.
Anith
At startup the log indicates that AWE is being used, and I see
that the memory is being grabbed when the instance starts.
But in the log indicates that the Working Set Size is set to 1 GB.
Does this mean anything when using AWE..
Am I getting full use of AWE on my instance. How can I tell....
Thanks
Paul
Check the Buffer Manager counter in Perfmon. There are a set of
events/classes related to AWE which you can check.
Anith
Configuring SQL to use AWE
I have configured a SQL200 instance to use 5gb of my server's memory.
At startup the log indicates that AWE is being used, and I see
that the memory is being grabbed when the instance starts.
But in the log indicates that the Working Set Size is set to 1 GB.
Does this mean anything when using AWE..
Am I getting full use of AWE on my instance. How can I tell....
Thanks
PaulCheck the Buffer Manager counter in Perfmon. There are a set of
events/classes related to AWE which you can check.
--
Anith
At startup the log indicates that AWE is being used, and I see
that the memory is being grabbed when the instance starts.
But in the log indicates that the Working Set Size is set to 1 GB.
Does this mean anything when using AWE..
Am I getting full use of AWE on my instance. How can I tell....
Thanks
PaulCheck the Buffer Manager counter in Perfmon. There are a set of
events/classes related to AWE which you can check.
--
Anith
Configuring SQL to use AWE
I have configured a SQL200 instance to use 5gb of my server's memory.
At startup the log indicates that AWE is being used, and I see
that the memory is being grabbed when the instance starts.
But in the log indicates that the Working Set Size is set to 1 GB.
Does this mean anything when using AWE..
Am I getting full use of AWE on my instance. How can I tell....
Thanks
PaulCheck the Buffer Manager counter in Perfmon. There are a set of
events/classes related to AWE which you can check.
Anith
At startup the log indicates that AWE is being used, and I see
that the memory is being grabbed when the instance starts.
But in the log indicates that the Working Set Size is set to 1 GB.
Does this mean anything when using AWE..
Am I getting full use of AWE on my instance. How can I tell....
Thanks
PaulCheck the Buffer Manager counter in Perfmon. There are a set of
events/classes related to AWE which you can check.
Anith
Configuring SQL Reporting Services for SSL
I've got an issue that is perhaps a bit different than any other
related posting on this topic.
I have successfully installed and configured SSRS for SQL 2005 and now
I'm at the step where I need to require SSL. So I opened the
Reporting Services Configuration, then selected Report Server Virtual
Directory. Then I select the checkbox Require Secure Socket Layer
(SSL) connections. At this step I am required to enter the name of
the certificate. Here is the problem: The server in on 2 seemingly
different domains and the certificate was issued to domain A, but the
server name is listed under domain B, but both domains resolve to the
same IP address. Here are the specifics:
A) The cert was named according to this domain pattern:
<server_name>.orgA.domainA.com
B) The computer name in system properties is:
<server_name>.orgB.xx.domainB.com
When I run the report server web interface, I get this error "The
request failed with HTTP status 401: Unauthorized."
So my question is: Why isn't the certificate for Domain A working?
Should I request a certificate under the domain of option B above? Is
there a configuration that is required? Note - I've modified the file
rsreportserver.config per the installation instructions.
Thanks in advance for your assistance,
-ScottOn Mar 6, 10:33 am, scottdistef...@.gmail.com wrote:
> I've got an issue that is perhaps a bit different than any other
> related posting on this topic.
> I have successfully installed and configured SSRS for SQL 2005 and now
> I'm at the step where I need to require SSL. So I opened the
> Reporting Services Configuration, then selected Report Server Virtual
> Directory. Then I select the checkbox Require Secure Socket Layer
> (SSL) connections. At this step I am required to enter the name of
> the certificate. Here is the problem: The server in on 2 seemingly
> different domains and the certificate was issued to domain A, but the
> server name is listed under domain B, but both domains resolve to the
> same IP address. Here are the specifics:
> A) The cert was named according to this domain pattern:
> <server_name>.orgA.domainA.com
> B) The computer name in system properties is:
> <server_name>.orgB.xx.domainB.com
> When I run the report server web interface, I get this error "The
> request failed with HTTP status 401: Unauthorized."
> So my question is: Why isn't the certificate for Domain A working?
> Should I request a certificate under the domain of option B above? Is
> there a configuration that is required? Note - I've modified the file
> rsreportserver.config per the installation instructions.
> Thanks in advance for your assistance,
> -Scott
Anybody thoughts?|||On Mar 6, 11:33 am, scottdistef...@.gmail.com wrote:
> I've got an issue that is perhaps a bit different than any other
> related posting on this topic.
> I have successfully installed and configured SSRS for SQL 2005 and now
> I'm at the step where I need to require SSL. So I opened the
> Reporting Services Configuration, then selected Report Server Virtual
> Directory. Then I select the checkbox Require Secure Socket Layer
> (SSL) connections. At this step I am required to enter the name of
> the certificate. Here is the problem: The server in on 2 seemingly
> different domains and the certificate was issued to domain A, but the
> server name is listed under domain B, but both domains resolve to the
> same IP address. Here are the specifics:
> A) The cert was named according to this domain pattern:
> <server_name>.orgA.domainA.com
> B) The computer name in system properties is:
> <server_name>.orgB.xx.domainB.com
> When I run the report server web interface, I get this error "The
> request failed with HTTP status 401: Unauthorized."
> So my question is: Why isn't the certificate for Domain A working?
> Should I request a certificate under the domain of option B above? Is
> there a configuration that is required? Note - I've modified the file
> rsreportserver.config per the installation instructions.
> Thanks in advance for your assistance,
> -Scott
I'm sorry to pester, but I'm running out of things to try on this
issue. Does anyone have thoughts to share on requiring SSL with SQL
2005 Reporting?
related posting on this topic.
I have successfully installed and configured SSRS for SQL 2005 and now
I'm at the step where I need to require SSL. So I opened the
Reporting Services Configuration, then selected Report Server Virtual
Directory. Then I select the checkbox Require Secure Socket Layer
(SSL) connections. At this step I am required to enter the name of
the certificate. Here is the problem: The server in on 2 seemingly
different domains and the certificate was issued to domain A, but the
server name is listed under domain B, but both domains resolve to the
same IP address. Here are the specifics:
A) The cert was named according to this domain pattern:
<server_name>.orgA.domainA.com
B) The computer name in system properties is:
<server_name>.orgB.xx.domainB.com
When I run the report server web interface, I get this error "The
request failed with HTTP status 401: Unauthorized."
So my question is: Why isn't the certificate for Domain A working?
Should I request a certificate under the domain of option B above? Is
there a configuration that is required? Note - I've modified the file
rsreportserver.config per the installation instructions.
Thanks in advance for your assistance,
-ScottOn Mar 6, 10:33 am, scottdistef...@.gmail.com wrote:
> I've got an issue that is perhaps a bit different than any other
> related posting on this topic.
> I have successfully installed and configured SSRS for SQL 2005 and now
> I'm at the step where I need to require SSL. So I opened the
> Reporting Services Configuration, then selected Report Server Virtual
> Directory. Then I select the checkbox Require Secure Socket Layer
> (SSL) connections. At this step I am required to enter the name of
> the certificate. Here is the problem: The server in on 2 seemingly
> different domains and the certificate was issued to domain A, but the
> server name is listed under domain B, but both domains resolve to the
> same IP address. Here are the specifics:
> A) The cert was named according to this domain pattern:
> <server_name>.orgA.domainA.com
> B) The computer name in system properties is:
> <server_name>.orgB.xx.domainB.com
> When I run the report server web interface, I get this error "The
> request failed with HTTP status 401: Unauthorized."
> So my question is: Why isn't the certificate for Domain A working?
> Should I request a certificate under the domain of option B above? Is
> there a configuration that is required? Note - I've modified the file
> rsreportserver.config per the installation instructions.
> Thanks in advance for your assistance,
> -Scott
Anybody thoughts?|||On Mar 6, 11:33 am, scottdistef...@.gmail.com wrote:
> I've got an issue that is perhaps a bit different than any other
> related posting on this topic.
> I have successfully installed and configured SSRS for SQL 2005 and now
> I'm at the step where I need to require SSL. So I opened the
> Reporting Services Configuration, then selected Report Server Virtual
> Directory. Then I select the checkbox Require Secure Socket Layer
> (SSL) connections. At this step I am required to enter the name of
> the certificate. Here is the problem: The server in on 2 seemingly
> different domains and the certificate was issued to domain A, but the
> server name is listed under domain B, but both domains resolve to the
> same IP address. Here are the specifics:
> A) The cert was named according to this domain pattern:
> <server_name>.orgA.domainA.com
> B) The computer name in system properties is:
> <server_name>.orgB.xx.domainB.com
> When I run the report server web interface, I get this error "The
> request failed with HTTP status 401: Unauthorized."
> So my question is: Why isn't the certificate for Domain A working?
> Should I request a certificate under the domain of option B above? Is
> there a configuration that is required? Note - I've modified the file
> rsreportserver.config per the installation instructions.
> Thanks in advance for your assistance,
> -Scott
I'm sorry to pester, but I'm running out of things to try on this
issue. Does anyone have thoughts to share on requiring SSL with SQL
2005 Reporting?
Tuesday, 14 February 2012
Configuring Reporting Services 2005 on windows 2003 server with II
A question to those who installed and configured Reporting services 2005
successfully and area ble to generate a data model from the cube though a
browser { IE}.
Can you please let me know what accounts did you use in the setup process
and to create a data model from the browser ? I installed RS2005 and
configured it but I am unable to create a data model from a browser . I want
to use Report Builder to build my reports from the web with the data model
as my data source.
I appreciate your time and effort in hleping me to solve my problem.
Thank You
--
KKallis,
I am having difficulty in understanding exactly what you are asking.
To create a Report Model use Business Intelligence Development Studio.
Use a Report Model Project template from the New Project dialog.
Andrew Watt
MVP - InfoPath
On Fri, 7 Oct 2005 07:37:14 -0700, Kallis
<Kallis@.discussions.microsoft.com> wrote:
>A question to those who installed and configured Reporting services 2005
>successfully and area ble to generate a data model from the cube though a
>browser { IE}.
>Can you please let me know what accounts did you use in the setup process
>and to create a data model from the browser ? I installed RS2005 and
>configured it but I am unable to create a data model from a browser . I want
>to use Report Builder to build my reports from the web with the data model
>as my data source.
>I appreciate your time and effort in hleping me to solve my problem.
>Thank You|||Andrew,
Thanks for responding . My point of concern is about generating a data
model from the web.After deploying a cube from SSAS project ,I can browse to
the cube from the browser thru IIS .Here , there should be a button which
says "Generate A Model" to generate a data model . I don't see this button .
This data model is based on the cube . The data model created from the Report
Model Project is based on the SQL DB and is of not much use to me .Are you
able to generate a data model based on the cube ?
thanks
--
K
"Andrew Watt [MVP - InfoPath]" wrote:
> Kallis,
> I am having difficulty in understanding exactly what you are asking.
> To create a Report Model use Business Intelligence Development Studio.
> Use a Report Model Project template from the New Project dialog.
> Andrew Watt
> MVP - InfoPath
> On Fri, 7 Oct 2005 07:37:14 -0700, Kallis
> <Kallis@.discussions.microsoft.com> wrote:
> >A question to those who installed and configured Reporting services 2005
> >successfully and area ble to generate a data model from the cube though a
> >browser { IE}.
> >
> >Can you please let me know what accounts did you use in the setup process
> >and to create a data model from the browser ? I installed RS2005 and
> >configured it but I am unable to create a data model from a browser . I want
> >to use Report Builder to build my reports from the web with the data model
> >as my data source.
> >
> >I appreciate your time and effort in hleping me to solve my problem.
> >
> >Thank You
>
successfully and area ble to generate a data model from the cube though a
browser { IE}.
Can you please let me know what accounts did you use in the setup process
and to create a data model from the browser ? I installed RS2005 and
configured it but I am unable to create a data model from a browser . I want
to use Report Builder to build my reports from the web with the data model
as my data source.
I appreciate your time and effort in hleping me to solve my problem.
Thank You
--
KKallis,
I am having difficulty in understanding exactly what you are asking.
To create a Report Model use Business Intelligence Development Studio.
Use a Report Model Project template from the New Project dialog.
Andrew Watt
MVP - InfoPath
On Fri, 7 Oct 2005 07:37:14 -0700, Kallis
<Kallis@.discussions.microsoft.com> wrote:
>A question to those who installed and configured Reporting services 2005
>successfully and area ble to generate a data model from the cube though a
>browser { IE}.
>Can you please let me know what accounts did you use in the setup process
>and to create a data model from the browser ? I installed RS2005 and
>configured it but I am unable to create a data model from a browser . I want
>to use Report Builder to build my reports from the web with the data model
>as my data source.
>I appreciate your time and effort in hleping me to solve my problem.
>Thank You|||Andrew,
Thanks for responding . My point of concern is about generating a data
model from the web.After deploying a cube from SSAS project ,I can browse to
the cube from the browser thru IIS .Here , there should be a button which
says "Generate A Model" to generate a data model . I don't see this button .
This data model is based on the cube . The data model created from the Report
Model Project is based on the SQL DB and is of not much use to me .Are you
able to generate a data model based on the cube ?
thanks
--
K
"Andrew Watt [MVP - InfoPath]" wrote:
> Kallis,
> I am having difficulty in understanding exactly what you are asking.
> To create a Report Model use Business Intelligence Development Studio.
> Use a Report Model Project template from the New Project dialog.
> Andrew Watt
> MVP - InfoPath
> On Fri, 7 Oct 2005 07:37:14 -0700, Kallis
> <Kallis@.discussions.microsoft.com> wrote:
> >A question to those who installed and configured Reporting services 2005
> >successfully and area ble to generate a data model from the cube though a
> >browser { IE}.
> >
> >Can you please let me know what accounts did you use in the setup process
> >and to create a data model from the browser ? I installed RS2005 and
> >configured it but I am unable to create a data model from a browser . I want
> >to use Report Builder to build my reports from the web with the data model
> >as my data source.
> >
> >I appreciate your time and effort in hleping me to solve my problem.
> >
> >Thank You
>
Sunday, 12 February 2012
Configuring Active Directory as a Linked Server.
Hi, in a server running sql server 2000 sp3, as a new requirement for an
application. They need to have the active Directory configured as a
Linked Server.
Do somebody know the pros and cons of configuring this.
Thanks a lot for your help.
*** Sent via Developersdex http://www.codecomments.com ***Hi,
its their SQL Server ,SQL server can be integrated with Active Directory ,
please read *Active Directory* in BOL.
here are some articles FYI :
msdn.microsoft.com/library/en-us/architec/8_ar_cs_1gku.asp
msdn.microsoft.com/.../adsi/adsi/ creating_a_heterogeneous_join_between_sq
l_s
erver_and_active_directory.asp
:-)
Regards
--
Andy Davis
Activecrypt Team
---
SQL Server Encryption Software
http://www.activecrypt.com
"MariaGuzman" wrote:
> Hi, in a server running sql server 2000 sp3, as a new requirement for an
> application. They need to have the active Directory configured as a
> Linked Server.
> Do somebody know the pros and cons of configuring this.
> Thanks a lot for your help.
> *** Sent via Developersdex http://www.codecomments.com ***
>
application. They need to have the active Directory configured as a
Linked Server.
Do somebody know the pros and cons of configuring this.
Thanks a lot for your help.
*** Sent via Developersdex http://www.codecomments.com ***Hi,
its their SQL Server ,SQL server can be integrated with Active Directory ,
please read *Active Directory* in BOL.
here are some articles FYI :
msdn.microsoft.com/library/en-us/architec/8_ar_cs_1gku.asp
msdn.microsoft.com/.../adsi/adsi/ creating_a_heterogeneous_join_between_sq
l_s
erver_and_active_directory.asp
:-)
Regards
--
Andy Davis
Activecrypt Team
---
SQL Server Encryption Software
http://www.activecrypt.com
"MariaGuzman" wrote:
> Hi, in a server running sql server 2000 sp3, as a new requirement for an
> application. They need to have the active Directory configured as a
> Linked Server.
> Do somebody know the pros and cons of configuring this.
> Thanks a lot for your help.
> *** Sent via Developersdex http://www.codecomments.com ***
>
Friday, 10 February 2012
Configure the version of referenced Assemblies after the deployment
Hi all,
I'm using the Reporting Services 2000 and the Report Designer within Visual Studio 2003. I have
configured several Assembly References (Report Properties -> References). After the addition of an
Assembly the respective row shows amongst others the version of the referenced Assembly. These
informations can be found in the RDL file as well.
I'm looking for a way to configure the version of a referenced Assembly "at runtime" *after* the
deployment of the respective report to the Reporting Services. From .NET Assemblies I know the
application configuration files (.config file) which can be used to configure and to change,
respectively, the version of referenced Assemblies "at runtime".
Thanks in advance,
Jochen.Hello Jochen,
You could redirect one version of myAssembly to another in the web.config
file of the ReportServer folder.
For more information, you could refer the following article:
http://msdn2.microsoft.com/en-us/library/7wd6ex19(VS.80).aspx
Hope this will be helpful!
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.
==================================================(This posting is provided "AS IS", with no warranties, and confers no
rights.)|||Hello Wei,
thank you very much. This is exactly what I'm looking for.
Regards,
Jochen.
Wei Lu [MSFT] wrote:
> Hello Jochen,
> You could redirect one version of myAssembly to another in the web.config
> file of the ReportServer folder.
> For more information, you could refer the following article:
> http://msdn2.microsoft.com/en-us/library/7wd6ex19(VS.80).aspx
> Hope this will be helpful!
> Sincerely,
> Wei Lu
> Microsoft Online Community Support
> ==================================================> Get notification to my posts through email? Please refer to
> http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
> ications.
> Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
> where an initial response from the community or a Microsoft Support
> Engineer within 1 business day is acceptable. Please note that each follow
> up response may take approximately 2 business days as the support
> professional working with you may need further investigation to reach the
> most efficient resolution. The offering is not appropriate for situations
> that require urgent, real-time or phone-based interactions or complex
> project analysis and dump analysis issues. Issues of this nature are best
> handled working with a dedicated Microsoft Support Engineer by contacting
> Microsoft Customer Support Services (CSS) at
> http://msdn.microsoft.com/subscriptions/support/default.aspx.
> ==================================================> (This posting is provided "AS IS", with no warranties, and confers no
> rights.)
>
I'm using the Reporting Services 2000 and the Report Designer within Visual Studio 2003. I have
configured several Assembly References (Report Properties -> References). After the addition of an
Assembly the respective row shows amongst others the version of the referenced Assembly. These
informations can be found in the RDL file as well.
I'm looking for a way to configure the version of a referenced Assembly "at runtime" *after* the
deployment of the respective report to the Reporting Services. From .NET Assemblies I know the
application configuration files (.config file) which can be used to configure and to change,
respectively, the version of referenced Assemblies "at runtime".
Thanks in advance,
Jochen.Hello Jochen,
You could redirect one version of myAssembly to another in the web.config
file of the ReportServer folder.
For more information, you could refer the following article:
http://msdn2.microsoft.com/en-us/library/7wd6ex19(VS.80).aspx
Hope this will be helpful!
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.
==================================================(This posting is provided "AS IS", with no warranties, and confers no
rights.)|||Hello Wei,
thank you very much. This is exactly what I'm looking for.
Regards,
Jochen.
Wei Lu [MSFT] wrote:
> Hello Jochen,
> You could redirect one version of myAssembly to another in the web.config
> file of the ReportServer folder.
> For more information, you could refer the following article:
> http://msdn2.microsoft.com/en-us/library/7wd6ex19(VS.80).aspx
> Hope this will be helpful!
> Sincerely,
> Wei Lu
> Microsoft Online Community Support
> ==================================================> Get notification to my posts through email? Please refer to
> http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
> ications.
> Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
> where an initial response from the community or a Microsoft Support
> Engineer within 1 business day is acceptable. Please note that each follow
> up response may take approximately 2 business days as the support
> professional working with you may need further investigation to reach the
> most efficient resolution. The offering is not appropriate for situations
> that require urgent, real-time or phone-based interactions or complex
> project analysis and dump analysis issues. Issues of this nature are best
> handled working with a dedicated Microsoft Support Engineer by contacting
> Microsoft Customer Support Services (CSS) at
> http://msdn.microsoft.com/subscriptions/support/default.aspx.
> ==================================================> (This posting is provided "AS IS", with no warranties, and confers no
> rights.)
>
Configure SQL XML support in IIS
I have configured SQL XML Support in IIS but still i am not able to Use
http://localhost/ss?Sql=select+*+from+users+for+xml+auto
I am getting Internal Server Error
Hi, if you're sure that the SQL XML Support in IIS has been configured correctly, you can try to add a root element for your output:
http://localhost/ss?sql=select+*+from+users+for+xml+auto&root=users
You can refer to this article for configuring virtual directory for SQLXML:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/xmlsql/ac_xml1_2xvd.asp
Configure SQL Server on Web Server!!
I recently have configured a web server based on Windows 2003 Server and IIS 5. I'd installed SQL Server 2005 on to it. I want this SQL server to be accessiable to my clients for their data storage purpose. I want to configure this sql server accessiable to them through a DNS name. My domain name is www.talons.com.np. How can i do this? I need your all kind support in this regard.
It is not clear what your clients are going to use to access the server.Could you clarify your plans?|||
Please do not double post. As indicated in the other post, if you want them connect to the SQL Server machine by DNS name, you can configure a port redirection on your outside router to route the incoming connections on port 1433 to the SQL Server.
Jens K. Suessmeyer
http://www.sqlserver2005.de
Configure SQL Server 2000 on Web Server accessible to client!!
I recently have configured my Web Server based on Windows 2003 Server and IIS 5x. I'd also installed SQL Server 2005 into this. Now I want toc onfigure this SQL Server, so that my client can access their database through a DNS name. I request you all for your kind support in this regard. Thanks in advance.
Datbased are not access by DNS Name. Default instances of server are accessed through DNS Names. Using the syntax for the default server e.g. Computername or for a named instance ComputerName\InstanceName should do the trick. If you want to reach the instances by just a name, without the \ within the name, you will have to configure an alias for them on each client machine.
Jens K. Suessmeyer
http://www.sqlserver2005.de
Configure SQL Server 2000 on a Web Server accessible to client!!
I have recently configured a Web Server based on Windows 2003 Server and IIS 5x. I'd also installed SQL Server 2005 into this. Now I want toc onfigure this SQL Server, so that my client can access their database through a DNS name. I request you all for your kind support in this regard. Thanks in advance.
PLease do not double post, see the answer in (one of your) other threads.
Jens K. Suessmeyer
http://www.sqlserver2005.de
Configure Report Server / VSTS
Hi,
during the install of VSTS - I get the errror that Reporting services are
not configured correctly.
This seems to be due to the Web Service Identity not being configured.
(This WAS configured and fine before installing SharePoint & attempting the
VSTS install)
If I try to edit the Web Service Identity - I get :
ReportServicesConfigUI.WMIProvider.WMIProviderException: A virtual directory
must first be created before performing this operation.
at
ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.SetWebServiceIdentity(String
applicationPool)
The ASP.Net service account box is blank (I've re-run aspnet_regiis)
The report server box is blank as is the Report Manager box - any attempt to
create or select an existing pool errors.
(the reports & reportserver virtual folders already exist in IIS)
TIA
PhilHello Phil,
Since you installed Sharepoint to the web server, it will install the isapi
filter and handle all the httprequest.
So I suggest you create and configure the Reporting Services on the other
virtual directory.
For example, you could create as RSmanager and RSServer.
Hope this helps.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Hi ,
How is everything going? Please feel free to let me know if you need any
assistance.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.
during the install of VSTS - I get the errror that Reporting services are
not configured correctly.
This seems to be due to the Web Service Identity not being configured.
(This WAS configured and fine before installing SharePoint & attempting the
VSTS install)
If I try to edit the Web Service Identity - I get :
ReportServicesConfigUI.WMIProvider.WMIProviderException: A virtual directory
must first be created before performing this operation.
at
ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.SetWebServiceIdentity(String
applicationPool)
The ASP.Net service account box is blank (I've re-run aspnet_regiis)
The report server box is blank as is the Report Manager box - any attempt to
create or select an existing pool errors.
(the reports & reportserver virtual folders already exist in IIS)
TIA
PhilHello Phil,
Since you installed Sharepoint to the web server, it will install the isapi
filter and handle all the httprequest.
So I suggest you create and configure the Reporting Services on the other
virtual directory.
For example, you could create as RSmanager and RSServer.
Hope this helps.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Hi ,
How is everything going? Please feel free to let me know if you need any
assistance.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to:
Posts (Atom)