Stefan [MSFT]
Guest
|
 Posted:
Sun Nov 13, 2005 9:50 pm Post subject:
Re: Got error running DCA - Behind Firewall- You do not have |
|
|
Hi Hantaris,
based on the error message it seems that the share memory protocol is used
to connect to the SQL server.
Actually shared memory can only be used if the database is on the same
machine as MCMS.
But the SQL client tools should never use shared memory if a remote machine
has been choosen.
Please verify if disabling shared memory protocol in the SQL client network
utility resolves the issue. If not, please post a follow up question on a
SQL related newsgroup as the problem comes from a component shipped with the
SQL client tools.
Cheers,
Stefan
"Hantaris" <mailing.maurizio.romano@gmail.com> schrieb im Newsbeitrag
news:1131729852.983742.22960@o13g2000cwo.googlegroups.com...
| Quote: | Hi,
I hope someone may help me to fix this issue.
I have installed CMS 2002sp1 on a server Windows 2000 SP 4(I call it
CMSWEBSERVER) into DMZ. When I try to run DCA to configure my database
I got this error:
You do not have database owner (dbo) rights
-2147221504.[Microsoft][ODBC SQL Server Driver][Shared Memory]SQL
Server does not exist or access denied.
[Microsoft][ODBC SQL Server Driver][Shared Memory]ConnectionOpen
(Connect()).
The account used to authenticate against the DB Server is the SA and it
has the ownership of the database so I'm quite sure that the error
message is wrong.
Between DB Server (with SP3 installad) and CMSWEBSERVER there is a
firewall and I think this software may be cause of my problem. Do
anyone know which ports I have to open? It's enough to leave open the
SQL Server port (1433) and 445 port???; I have to reconfigure SQL
Client configuration through Network Utility??
I've installed MDAC 2.8 sp 1 with no results and I can reach DB Server
through Query analyzer....
Any suggestion will be much appreciated.
Maurizio
|
|
|
FAQ
Memberlist
Register
Profile
Log in to check your private messages
Log in