Problems connecting thru firewall

I have developed an application that handles data from a SQL server runnig inside my main domain.

When i connect with the SQL server from the inside i have no problems at all.

However we opened up the application (smart client application) for some beta testers and i bumped into some problems. i changed the connectionstring to use the IP for the server. I also tried a registered dns name, but i got the following

The aspnetdb i use for authentication is refusing to run the stored procedures and i get the famous disconnected due to the remote server does not accept remote calls, or something like that.

If i disable the Authentication in the application and just run the application with the same connectionstring IP or DNS, parts of the application works. Some of the stored procedures get executed , and the others does not get executed.

I have looked at the owner of the items but they all have the same owner and exec rights. I have checked my C# code and they are all using the patterns to execute the calls the same way.

Does anyone have any idea whats going on here ?

I also confirmed that the correct SQL ports has been opened in the PIX.
I ran home and tried to connect the sql server managment studio from home and i got access , the application still behaves like before

how about using a sql server mixed mode for authentication.|||

Hi

The SQL server is set to mixed mode security and i'm using a SQL login i created with dbo schema.

|||

is the server configured to accept local and remote connection

in the surface configuration

start>programs> sqlserver2005>

configuration tools>surface area configuration>

configuration for service and connection>datbase engine

>remote connection> check local and remote connection

|||

Thanks for your answer

I found the problem last night. In the solution someone had added a SQL report that had a hardcoded connectionstring. The try catch found the connection issue and then skipped parts of the load of the application.

Once i removed the conn string everything is working fine...

Problem:fail to invoke remote RPC method

I have two xp sp2 machines(one desktop with sql server running, the other is
a virtual pc, on the same domain), I'm trying to connect between the two
using the dtcping.exe tool from ms
the virtual pc has vs2005 etc installed and I can't get it to run a
distributed transaction on the sql server machine, both machines have the sp2
firewall disabled.
the rpc services are running, msdtc service are running,
on the virtual pc I get the following
Firewall Port Settings:
Port:5000-5015
RPC server is ready
++++++++++++Validating Remote Computer Name++++++++++++
08-03, 12:09:03.756-->Start DTC connection test
Name Resolution:
Gilbert-->10.0.4.22-->Gilbert
08-03, 12:09:03.776-->Start RPC test (PERTH-->Gilbert)
Problem:fail to invoke remote RPC method
Error(0x6BA) at dtcping.cpp @.289
-->RPC pinging exception
-->1722(The RPC server is unavailable.)
RPC test failed
on the desktop sql server machine I get this
Firewall Port Settings:
Port:5000-5015
RPC server is ready
++++++++++++Validating Remote Computer Name++++++++++++
08-03, 12:08:50.353-->Start DTC connection test
Name Resolution:
Perth-->10.0.4.23-->Perth
08-03, 12:08:50.368-->Start RPC test (GILBERT-->Perth)
Problem:fail to invoke remote RPC method
Error(0x5) at dtcping.cpp @.289
-->RPC pinging exception
-->5(Access is denied.)
RPC test failed
the msdtc service has been set to use my domain account and all the options
have been enabled, network access, inbound, outbound etc.
I have set up the msdtc to use ports 5000-5015
any ideas out there?
to get this poc working
Try turning off Norton internet worm protection...
Stuart
"SP" wrote:

> I have two xp sp2 machines(one desktop with sql server running, the other is
> a virtual pc, on the same domain), I'm trying to connect between the two
> using the dtcping.exe tool from ms
> the virtual pc has vs2005 etc installed and I can't get it to run a
> distributed transaction on the sql server machine, both machines have the sp2
> firewall disabled.
> the rpc services are running, msdtc service are running,
> on the virtual pc I get the following
> Firewall Port Settings:
> Port:5000-5015
> RPC server is ready
> ++++++++++++Validating Remote Computer Name++++++++++++
> 08-03, 12:09:03.756-->Start DTC connection test
> Name Resolution:
> Gilbert-->10.0.4.22-->Gilbert
> 08-03, 12:09:03.776-->Start RPC test (PERTH-->Gilbert)
> Problem:fail to invoke remote RPC method
> Error(0x6BA) at dtcping.cpp @.289
> -->RPC pinging exception
> -->1722(The RPC server is unavailable.)
> RPC test failed
> on the desktop sql server machine I get this
> Firewall Port Settings:
> Port:5000-5015
> RPC server is ready
> ++++++++++++Validating Remote Computer Name++++++++++++
> 08-03, 12:08:50.353-->Start DTC connection test
> Name Resolution:
> Perth-->10.0.4.23-->Perth
> 08-03, 12:08:50.368-->Start RPC test (GILBERT-->Perth)
> Problem:fail to invoke remote RPC method
> Error(0x5) at dtcping.cpp @.289
> -->RPC pinging exception
> -->5(Access is denied.)
> RPC test failed
> the msdtc service has been set to use my domain account and all the options
> have been enabled, network access, inbound, outbound etc.
> I have set up the msdtc to use ports 5000-5015
> any ideas out there?
> to get this poc working
>
|||Thanks Stuart, you are the man!
"Stuart" wrote:
[vbcol=seagreen]
> Try turning off Norton internet worm protection...
> Stuart
> "SP" wrote:

Problem:fail to invoke remote RPC method

I have two xp sp2 machines(one desktop with sql server running, the other is
a virtual pc, on the same domain), I'm trying to connect between the two
using the dtcping.exe tool from ms
the virtual pc has vs2005 etc installed and I can't get it to run a
distributed transaction on the sql server machine, both machines have the sp
2
firewall disabled.
the rpc services are running, msdtc service are running,
on the virtual pc I get the following
Firewall Port Settings:
Port:5000-5015
RPC server is ready
++++++++++++Validating Remote Computer Name++++++++++++
08-03, 12:09:03.756-->Start DTC connection test
Name Resolution:
Gilbert-->10.0.4.22-->Gilbert
08-03, 12:09:03.776-->Start RPC test (PERTH-->Gilbert)
Problem:fail to invoke remote RPC method
Error(0x6BA) at dtcping.cpp @.289
-->RPC pinging exception
-->1722(The RPC server is unavailable.)
RPC test failed
on the desktop sql server machine I get this
Firewall Port Settings:
Port:5000-5015
RPC server is ready
++++++++++++Validating Remote Computer Name++++++++++++
08-03, 12:08:50.353-->Start DTC connection test
Name Resolution:
Perth-->10.0.4.23-->Perth
08-03, 12:08:50.368-->Start RPC test (GILBERT-->Perth)
Problem:fail to invoke remote RPC method
Error(0x5) at dtcping.cpp @.289
-->RPC pinging exception
-->5(Access is denied.)
RPC test failed
the msdtc service has been set to use my domain account and all the options
have been enabled, network access, inbound, outbound etc.
I have set up the msdtc to use ports 5000-5015
any ideas out there?
to get this poc working Try turning off Norton internet worm protection...
Stuart
"SP" wrote:

> I have two xp sp2 machines(one desktop with sql server running, the other
is
> a virtual pc, on the same domain), I'm trying to connect between the two
> using the dtcping.exe tool from ms
> the virtual pc has vs2005 etc installed and I can't get it to run a
> distributed transaction on the sql server machine, both machines have the
sp2
> firewall disabled.
> the rpc services are running, msdtc service are running,
> on the virtual pc I get the following
> Firewall Port Settings:
> Port:5000-5015
> RPC server is ready
> ++++++++++++Validating Remote Computer Name++++++++++++
> 08-03, 12:09:03.756-->Start DTC connection test
> Name Resolution:
> Gilbert-->10.0.4.22-->Gilbert
> 08-03, 12:09:03.776-->Start RPC test (PERTH-->Gilbert)
> Problem:fail to invoke remote RPC method
> Error(0x6BA) at dtcping.cpp @.289
> -->RPC pinging exception
> -->1722(The RPC server is unavailable.)
> RPC test failed
> on the desktop sql server machine I get this
> Firewall Port Settings:
> Port:5000-5015
> RPC server is ready
> ++++++++++++Validating Remote Computer Name++++++++++++
> 08-03, 12:08:50.353-->Start DTC connection test
> Name Resolution:
> Perth-->10.0.4.23-->Perth
> 08-03, 12:08:50.368-->Start RPC test (GILBERT-->Perth)
> Problem:fail to invoke remote RPC method
> Error(0x5) at dtcping.cpp @.289
> -->RPC pinging exception
> -->5(Access is denied.)
> RPC test failed
> the msdtc service has been set to use my domain account and all the option
s
> have been enabled, network access, inbound, outbound etc.
> I have set up the msdtc to use ports 5000-5015
> any ideas out there?
> to get this poc working
>|||Thanks Stuart, you are the man!
"Stuart" wrote:
[vbcol=seagreen]
> Try turning off Norton internet worm protection...
> Stuart
> "SP" wrote:
>

PROBLEM: Login name is 'dbo' ?? in Database

Here is a good one:
This is from sp_helplogins:
LOGINNAME DATABASE
DOMAIN\LOGIN1 Database1 db_owner MemberOf
DOMAIN\LOGIN1 Database1 dbo User
DOMAIN\LOGIN1 Database2 db_owner MemberOf
DOMAIN\LOGIN1 Database2 DOMAIN\LOGIN1 User
ALTER USER [dbo] WITH NAME=[DOMAIN\LOGIN1]
GO
results in:
Msg 15150, Level 16, State 1, Line 1
Cannot alter the user 'dbo'.
Someone must have tried to make the login db_owner by setting the name
to 'dbo'. What I need is to have the 2nd line above have DOMAIN\LOGIN1
as a user in Database1. Any ideas on how to fix this mess?Supposing that DOMAIN\LOGIN1 is represented by the dbo user, what problem do
you have?
Please, rate this post. Thanks!
--
May the bytes be with you!!!
Pedro López-Belmonte Eraso
MCAD, MCT
"Erik G" wrote:
> Here is a good one:
> This is from sp_helplogins:
> LOGINNAME DATABASE
> DOMAIN\LOGIN1 Database1 db_owner MemberOf
> DOMAIN\LOGIN1 Database1 dbo User
> DOMAIN\LOGIN1 Database2 db_owner MemberOf
> DOMAIN\LOGIN1 Database2 DOMAIN\LOGIN1 User
> ALTER USER [dbo] WITH NAME=[DOMAIN\LOGIN1]
> GO
> results in:
> Msg 15150, Level 16, State 1, Line 1
> Cannot alter the user 'dbo'.
> Someone must have tried to make the login db_owner by setting the name
> to 'dbo'. What I need is to have the 2nd line above have DOMAIN\LOGIN1
> as a user in Database1. Any ideas on how to fix this mess?
>|||On Jan 18, 3:59=A0pm, Pedro L=F3pez-Belmonte
<plber...@.mizarsoluciones.com.quitaestoparaenviar> wrote:
> Supposing that DOMAIN\LOGIN1 is represented by the dbo user, what problem =do
> you have?
I can not add a DOMAIN\LOGIN1 as a user. I need to set a database
role (db_role1 for this example) for user DOMAIN\LOGIN1 and the user
does not exist. I don't want DOMAIN\LOGIN1 to be db_owner, I want it
to be a user with db_role1.
Thanks
Erik|||> ALTER USER [dbo] WITH NAME=[DOMAIN\LOGIN1]
> GO
> results in:
> Msg 15150, Level 16, State 1, Line 1
> Cannot alter the user 'dbo'.
You need to change the database owner to a different login before you can
add the user to the database as a normal user. For example:
USE Database1;
ALTER AUTHORIZATION ON DATABASE::Database1 TO [sa];
CREATE USER [DOMAIN\LOGIN1];
For more info in database ownership issues, see
http://weblogs.sqlteam.com/dang/archive/2008/01/13/Database-Owner-Troubles.aspx
Hope this helps.
Dan Guzman
SQL Server MVP
"Erik G" <info@.fdaregulatory.com> wrote in message
news:ffe839b8-93fd-4281-b494-f5b439d7d351@.s12g2000prg.googlegroups.com...
> Here is a good one:
> This is from sp_helplogins:
> LOGINNAME DATABASE
> DOMAIN\LOGIN1 Database1 db_owner MemberOf
> DOMAIN\LOGIN1 Database1 dbo User
> DOMAIN\LOGIN1 Database2 db_owner MemberOf
> DOMAIN\LOGIN1 Database2 DOMAIN\LOGIN1 User
> ALTER USER [dbo] WITH NAME=[DOMAIN\LOGIN1]
> GO
> results in:
> Msg 15150, Level 16, State 1, Line 1
> Cannot alter the user 'dbo'.
> Someone must have tried to make the login db_owner by setting the name
> to 'dbo'. What I need is to have the 2nd line above have DOMAIN\LOGIN1
> as a user in Database1. Any ideas on how to fix this mess?