3 server scenario problem

Hi
I'm having trouble connecting to an instance of SQL Server 2005 (Express)
from 2 individual Windows Server 2003 machines running IIS (asp.net 2.0)
I have an IIS on each 2k3 machine, both with identical sites. The idea is
simply that we have a third sql server which is accessed by these 2 websites
.
One server gives me a Server login error (user not found:
MYDomain\ServerName), which the second server gives me the usual error 26 -
Cannot connect to Server/Instance specified.
Both IIS apps use the same query string (server=MYSQLSERVER\DARTS;
database=dartsV2;trustedconnection=yes;)
but as I say, one connects, one doesn't! very odd. Anyone got any
suggestions? I've enabled named pipes and tcp/ip on the sql server, along
with "allowing remote and local connections" using surface area config. I've
even setup SQL Browser, which seemed to cure one of the servers (both were
giving me the cannot find instance specified error).
Any suggestions guys?! I'm getting kinda desperate on this one... :o)
Cheers
DanHi,
To narrow down this issue, I have serveral questions which need your
confirmation:
1. Could you ping the SQL Server successfully from the two clients?
2. What will happen if you explicitly add the two domain accounts to the
users group of your third server ?
Also, I recommend you try configuring the client settings as following:
Click the Start menu;
Type cliconfg.exe;
Check if TCP/IP and Named Pipes protocols are enabled;
Select the Alias tab;
Check if the server instance exists in the list;
If it's not existed, click the Add button;
Input the alias name (<servername>\SQLEXPRESS) for Named Pipes protocol and
click OK.
Apply the settings, and then try again.
If you want to use TCP/IP protocol, please first check the listening TCP
port on your server via SQL Server Configuration Manager.
Then add an alias for TCP/IP protocol at the clients. Note that you need to
cancel the selection of "Dynamically determin the port" and input your TCP
port number.
An alias can be different with your SQL Server instance name, but the
server name should be same as your server name.
Please ensure that you can use telnet to access your SQL Server TCP port
before configuring the alias for TCP/IP:
telnet <your server name> <port number>
If you have any other concerns, please feel free to let me know. It's my
pleasure to be of assistance.
Charles Wang
Microsoft Online Community Support
========================================
==============
When responding to posts, please "Reply to Group" via your newsreader
so that others may learn and benefit from this issue.
========================================
==============
This posting is provided "AS IS" with no warranties, and confers no rights.
========================================
==============|||Hi Charles,
Thanks for the reply. I've actually fixed this particular issue, I simply
copied the code with the "user" error onto the other IIS server, so now I
have that error on both. However, I'll post somewhere else for that...
For clarification...
1) yes. I could also use osql (or sqlcmd) to connect to the sql server from
both domain servers, cos they both had sqle installed but no instance
running).
2) I tried that, but it couldn't find the computer accounts when I tried
adding roles etc - presumbly because they were computer accounts and not
users, I'm not sure though?
I have named pipes enabled but this is considered a security risk is it not?
However, I'm not sure how to setup a connection string with an ip address? I
tried server=xxx.xxx.xxx.xxx but it that couldn't connect from either server
?
(I have both named pipes and tcp/ip enabled).
Could you point me to an article on how to do that, because if named pipes
are risky, we shouldn't be using them!
Thanks for your reply and help.
Cheers
Dan
"Charles Wang[MSFT]" wrote:

> Hi,
> To narrow down this issue, I have serveral questions which need your
> confirmation:
> 1. Could you ping the SQL Server successfully from the two clients?
> 2. What will happen if you explicitly add the two domain accounts to the
> users group of your third server ?
> Also, I recommend you try configuring the client settings as following:
> Click the Start menu;
> Type cliconfg.exe;
> Check if TCP/IP and Named Pipes protocols are enabled;
> Select the Alias tab;
> Check if the server instance exists in the list;
> If it's not existed, click the Add button;
> Input the alias name (<servername>\SQLEXPRESS) for Named Pipes protocol an
d
> click OK.
> Apply the settings, and then try again.
> If you want to use TCP/IP protocol, please first check the listening TCP
> port on your server via SQL Server Configuration Manager.
> Then add an alias for TCP/IP protocol at the clients. Note that you need t
o
> cancel the selection of "Dynamically determin the port" and input your TCP
> port number.
> An alias can be different with your SQL Server instance name, but the
> server name should be same as your server name.
> Please ensure that you can use telnet to access your SQL Server TCP port
> before configuring the alias for TCP/IP:
> telnet <your server name> <port number>
> If you have any other concerns, please feel free to let me know. It's my
> pleasure to be of assistance.
> Charles Wang
> Microsoft Online Community Support
> ========================================
==============
> When responding to posts, please "Reply to Group" via your newsreader
> so that others may learn and benefit from this issue.
> ========================================
==============
> This posting is provided "AS IS" with no warranties, and confers no rights
.
> ========================================
==============
>|||Hi Dan,
Thanks for your updating and response.
The user error should be caused by the windows logon account at your client
computer not matching the Windows authentication on the server.
Please check if the Windows login account is a member of the Users or
Administrators group under your SQL Server machine. You can maunually add
it to the Users group and then add it to the logins of your SQL Server 2005
Express and assign it permissions in SQL Server 2005 Express.
If you did not install the SQL Server 2005 Management Studio Express, you
can download it from:
http://www.microsoft.com/downloads/...A5AE-4BD1-4E3D-
94B8-5A0F62BF7796&DisplayLang=en
This tool provides you an UI to manage your SQL Server 2005 Express like
SQL Server 2000 Enterprise Manager.
If this issue persists, it seems that it is related to the settings of your
web application. You can try using impersonation in your web.config file:
<system.web>
..
<authentication mode = "windows" />
..
<identity impersonate="true" />
..
</system.web>
For more information, you can refer to:
Using sql trusted Connections with asp.net
http://idunno.org/dotNet/trustedConnections.aspx
If you use impersonation, please ensure that the two Windows logon accounts
of your two web application servers must be as a member of the
Users/Administrators group on your SQL Server 2005 machine and be assigned
permissions in your SQL Server 2005 Express instance.
For the second error "Cannot connect to Server/Instance specified", it is
most likely a communication level error. If you are worried about the
security of Named Pipes, you can maually configure the TCP/IP protocol by
following my first reply. Also, you can configure a static TCP port at the
server side. By using SQL Server Configuration Manager, you can specify a
static TCP port under the IP All, and leave other fields under IP1 and IP2
blank:
1. Open SQL Server Configuration Manager;
2. Select Protocols for <instance name>;
3. Double click TCP/IP, switch to the IP Address tab;
4. Specify the TCP Port under the IPAll, leave all TCP Dynamics Ports under
IP1,IP2 and IPAll blank, and leave TCP Port under IP1 and IP2 blank.
5. Click OK and restart your SQL Server service.
On the client machines, ensure that you can use telnet to connect to the
server at the TCP port. Then try adding an alias for TCP/IP by using
cliconfg.exe at the client and try again.
Please feel free to let me know if you have any other questions or
concerns.
Sincerely yours,
Charles Wang
Microsoft Online Community Support|||Hi Dan,
I am interested in this issue. Would you mind letting me know the result of
the suggestions? If you need further assistance, feel free to let me know.
I will be more than happy to be of assistance.
Have a great day!
Charles Wang
Microsoft Online Community Support

2-node to 4-node

Hi!
I have a customer with a 2-node active/active sql2k cluster hosted on
w2k.
We now want to run this on w2k3 and we also want to build up the
cluster to have a 4-node active/active/active/active sql2k cluster.
Our plan is to do it in two steps as follow. We take the current 2
nodes offline and unplug them from the network and then install the 2
new nodes with w2k3 using the original ipaddresses and netbiosname and
then restoring the sql2k (one virtuel server and one named instance).
This should give us the same cluster as before but with sql2k running
on w2k3.
This is because the customer will be able to unplug the new nodes and
replug the old ones if there is any trouble with the new nodes.
Then after a few days it's time to reinstall the old nodes with w2k3
and new netbiosnames and connect them to the cluster so we get our
4-node. Then install 2 new named sql instances.
We want all 4 sql instances to be able to run in all 4 nodes.
Now some questions!
When I install a new named instance (on node 3) it will be available
in the other 2 nodes, but will the original sql2k on these 2 nodes be
available in node 3? The same question with node 4.
Is there some problems with sql2k and w2k3 because it is no way to
uninstall sql2k under MSCS? In w2k I'm able to remove it under the
control panel.
/Peter
I actually did a 2 to 4 node cluster upgrade. During the transition, I
replaced the original nodes with new hardware, so I went from 2 nodes with 4
procs each to 4 nodes with 8 procs each. I also went from 2 instances to 3
instances of SQL server. Here is how I did it.
Upgrade the existing nodes (1 at a time) to W2K3. Add the new nodes.
Install SQL and Service packs to the new nodes. Fail the cluster over to
the new nodes. Remove the old nodes and replace with new hardware. At this
point, I would drop those nodes and rebuild them from scratch. Upgrad for
2003 is good, but I prefer a clean build. Add the new nodes to SQL and
apply the service packs. Install the third SQL instance and service pack.
As for your two questions, whenever you add or remove a node, you will need
to use the SQL install CD to add or remove the node from the SQL
installation. This is in addition to evicting or adding the node from the
cluster tool. Choose Advanced Options and Maintain Failover Clustering.
Read BOL on failover clustering for more details.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Peter Lindberg" <peter.lindbergTAKE@.AWAYmartinsson.se> wrote in message
news:40641e4b.73299028@.msnews.microsoft.com...
> Hi!
> I have a customer with a 2-node active/active sql2k cluster hosted on
> w2k.
> We now want to run this on w2k3 and we also want to build up the
> cluster to have a 4-node active/active/active/active sql2k cluster.
> Our plan is to do it in two steps as follow. We take the current 2
> nodes offline and unplug them from the network and then install the 2
> new nodes with w2k3 using the original ipaddresses and netbiosname and
> then restoring the sql2k (one virtuel server and one named instance).
> This should give us the same cluster as before but with sql2k running
> on w2k3.
> This is because the customer will be able to unplug the new nodes and
> replug the old ones if there is any trouble with the new nodes.
> Then after a few days it's time to reinstall the old nodes with w2k3
> and new netbiosnames and connect them to the cluster so we get our
> 4-node. Then install 2 new named sql instances.
> We want all 4 sql instances to be able to run in all 4 nodes.
> Now some questions!
> When I install a new named instance (on node 3) it will be available
> in the other 2 nodes, but will the original sql2k on these 2 nodes be
> available in node 3? The same question with node 4.
> Is there some problems with sql2k and w2k3 because it is no way to
> uninstall sql2k under MSCS? In w2k I'm able to remove it under the
> control panel.
> /Peter
>
|||Thank's for your advice Geoff.
The questions comes after a test install I have done and there was a
few odd things that happend.
We use Veritas Volume Manager to allow dynamic disc. I'm not involved
in that part, but the storage techi say's that the veritas code for
w2k can't handle an upgrade of windows to w2k3 and veritas w2k code
can't be upgraded to w2k3 version and still running on w2k. That's why
I want to install w2k3 on new hw with the new codepack from Verirtas.
In our test we run into the following situation:
On node one where we installed the veritas code we connected to disk
and then set up the cluster and then the first sql virtual server. At
that time the other node didn't have the veritas code yet, it only had
w2k3 and was not part of the ckuster. That means all disk was
available to node one. That node was installed with a named instance
where I by the way had to use instruction from KB815431 and sp3a. That
was after the install of sql2k failed once.
After this we set up the veritas code on the other machine with
clustersupport and added it to the cluster. We made an error labeling
one disk with the same name as the other node(cut and paste). When
changing that we had to uninstall the veritas code and break the
cluster. On with veritas code again without clustersupport so we get a
possiblity to chage that label. Then get the node in the cluster
again.
Here I installed a new virtuel server with a new named instance and
sp3a on the second node. This setup was without problem and the only
odd thing was that the dtc service still was automatic.
Next step was to se that the instances could move between the nodes.
The second node could move to the first, but the first could not move
to the second. We found out that the first node have the service for
both instances but the second only the service for the last installed
instance.
I can't se why this happend.
This is why I'm conserned about adding 2 more nodes after a week. Will
the initial two be able to move to new once? If the problem I
described is created by some of my mistake I will still will do this
upgrade in 2 steps, but if there is this problem we have to reinstall
the old nodes to w2k3 at the same time.
I will try to recreate it in vmware workstation, but if someone know
anything about this I will be happy to hear it.
/Peter
On Fri, 26 Mar 2004 10:26:22 -0500, "Geoff N. Hiten"
<SRDBA@.Careerbuilder.com> wrotc:

>I actually did a 2 to 4 node cluster upgrade. During the transition, I
>replaced the original nodes with new hardware, so I went from 2 nodes with 4
>procs each to 4 nodes with 8 procs each. I also went from 2 instances to 3
>instances of SQL server. Here is how I did it.
>Upgrade the existing nodes (1 at a time) to W2K3. Add the new nodes.
>Install SQL and Service packs to the new nodes. Fail the cluster over to
>the new nodes. Remove the old nodes and replace with new hardware. At this
>point, I would drop those nodes and rebuild them from scratch. Upgrad for
>2003 is good, but I prefer a clean build. Add the new nodes to SQL and
>apply the service packs. Install the third SQL instance and service pack.
>As for your two questions, whenever you add or remove a node, you will need
>to use the SQL install CD to add or remove the node from the SQL
>installation. This is in addition to evicting or adding the node from the
>cluster tool. Choose Advanced Options and Maintain Failover Clustering.
>Read BOL on failover clustering for more details.
>--
>Geoff N. Hiten
>Microsoft SQL Server MVP
>Senior Database Administrator
>Careerbuilder.com
>I support the Professional Association for SQL Server
>www.sqlpass.org
>"Peter Lindberg" <peter.lindbergTAKE@.AWAYmartinsson.se> wrote in message
>news:40641e4b.73299028@.msnews.microsoft.com...
>
|||You can determine which nodes can host which instances. Using the Install
CD and the Advanced Options tab, you can add or remove individual nodes to a
particular instance. I added each instance to each new node individually.
I then added the service pack to the new node/instance. Of course, I
rebooted each new node after each step, so there are a lot of reboots.
There is a new feature in W2k3 where you can expand basic cluster disks
without converting them to dynamic disks. That may eliminate the need for
Veritas Volume Manager.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Peter Lindberg" <peter.lindberg@.unigrid.se> wrote in message
news:406873b9.247543388@.msnews.microsoft.com...
> Thank's for your advice Geoff.
> The questions comes after a test install I have done and there was a
> few odd things that happend.
> We use Veritas Volume Manager to allow dynamic disc. I'm not involved
> in that part, but the storage techi say's that the veritas code for
> w2k can't handle an upgrade of windows to w2k3 and veritas w2k code
> can't be upgraded to w2k3 version and still running on w2k. That's why
> I want to install w2k3 on new hw with the new codepack from Verirtas.
> In our test we run into the following situation:
> On node one where we installed the veritas code we connected to disk
> and then set up the cluster and then the first sql virtual server. At
> that time the other node didn't have the veritas code yet, it only had
> w2k3 and was not part of the ckuster. That means all disk was
> available to node one. That node was installed with a named instance
> where I by the way had to use instruction from KB815431 and sp3a. That
> was after the install of sql2k failed once.
> After this we set up the veritas code on the other machine with
> clustersupport and added it to the cluster. We made an error labeling
> one disk with the same name as the other node(cut and paste). When
> changing that we had to uninstall the veritas code and break the
> cluster. On with veritas code again without clustersupport so we get a
> possiblity to chage that label. Then get the node in the cluster
> again.
> Here I installed a new virtuel server with a new named instance and
> sp3a on the second node. This setup was without problem and the only
> odd thing was that the dtc service still was automatic.
> Next step was to se that the instances could move between the nodes.
> The second node could move to the first, but the first could not move
> to the second. We found out that the first node have the service for
> both instances but the second only the service for the last installed
> instance.
> I can't se why this happend.
> This is why I'm conserned about adding 2 more nodes after a week. Will
> the initial two be able to move to new once? If the problem I
> described is created by some of my mistake I will still will do this
> upgrade in 2 steps, but if there is this problem we have to reinstall
> the old nodes to w2k3 at the same time.
> I will try to recreate it in vmware workstation, but if someone know
> anything about this I will be happy to hear it.
> /Peter
>
> On Fri, 26 Mar 2004 10:26:22 -0500, "Geoff N. Hiten"
> <SRDBA@.Careerbuilder.com> wrotc:
with 4
3
this
for
pack.
need
the
>
|||I saw that under Advanced Options but the button was greymarked. It
must have happend something. Now I have done it i vmware and seen it
work.
Next will be the actual go later this week, and then two more nodes a
week later. I'll remember those reboots after each part. I get it that
before starting with node 4 you where up with SP3a on node 3.
/Peter
On Mon, 29 Mar 2004 09:39:03 -0500, "Geoff N. Hiten"
<SRDBA@.Careerbuilder.com> wrotc:

>You can determine which nodes can host which instances. Using the Install
>CD and the Advanced Options tab, you can add or remove individual nodes to a
>particular instance. I added each instance to each new node individually.
>I then added the service pack to the new node/instance. Of course, I
>rebooted each new node after each step, so there are a lot of reboots.
>There is a new feature in W2k3 where you can expand basic cluster disks
>without converting them to dynamic disks. That may eliminate the need for
>Veritas Volume Manager.

2nd Table on Report Shifts Down

Hi

I have created a report with in reporting services with 2 tables. One at the top of the page, and one at the bottom. The one at the top will contain payment details which grows depending on how many items(rows) are in my dataset and the table at the bottom contains a cheque layout - for ex. Pay Mr X, Date...etc. This table will fill out boxes on a cheque

My problem is that the table at the bottom(cheque) is being shifted down depending on what's in the top table(payment items). I need that the cheque table remain in the sample position, independent from what is in the payment table.

Has anybody ever encountered this problem and have a solution to it?

Thanks in advance.Hi

managed to solve this problem using Sub Reports. I put the top table into a sub report and it works fine.

The only problem is when adding another level of grouping in the Table within the sub report, the initial problem emerges again.

Any other ideas?

|||Try putting the table inside of a rectangle (invisible border). The table should "consume" the space in the containing rectangle before pushing the other table down. However, there is no guarantee that the bottom table will stay on the page if the top grows too much.