Hello,
I have two SQL 2K server, both are running fine with public IP address.
i.e.
Server #1: 100.100.100.101
Server #2: 200.200.200.202
I use SQL Server #1 Client Network Utility to create an Alias i.e. SQL2.
The alias has the ip 200.200.200.202 and port 1433
Then I use SQL Server #1 Enterprise Manager to register SQL2 with SQL Server
authentication. (login name: sa and password)
Then I got the following error message:
"SQL2 - SQL Server does not exist or access denied. Connection(Connect("
Thanks
Try to see if connectivity is possible at all - ie register the IP address
in enterprise manager and see it this works on its own.
Rgds,
Paul Ibison SQL Server MVP, www.replicationanswers.com/default.asp
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
|||No,
Can not register IP address or Alias.
Thanks
"Paul Ibison" wrote:
> Try to see if connectivity is possible at all - ie register the IP address
> in enterprise manager and see it this works on its own.
> Rgds,
> Paul Ibison SQL Server MVP, www.replicationanswers.com/default.asp
> (recommended sql server 2000 replication book:
> http://www.nwsu.com/0974973602p.html)
>
>
|||But I can ping each other.
Thanks
"Paul Ibison" wrote:
> Try to see if connectivity is possible at all - ie register the IP address
> in enterprise manager and see it this works on its own.
> Rgds,
> Paul Ibison SQL Server MVP, www.replicationanswers.com/default.asp
> (recommended sql server 2000 replication book:
> http://www.nwsu.com/0974973602p.html)
>
>
|||Check on the server whose IP address is being registered, using the server
network utility, to confirm that port 1433 is being used.
Rgds,
Paul Ibison SQL Server MVP, www.replicationanswers.com/default.asp
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
|||Hello,
There is no IP address is being registered.
Yes, the port is 1433
Thanks
"Paul Ibison" wrote:
> Check on the server whose IP address is being registered, using the server
> network utility, to confirm that port 1433 is being used.
> Rgds,
> Paul Ibison SQL Server MVP, www.replicationanswers.com/default.asp
> (recommended sql server 2000 replication book:
> http://www.nwsu.com/0974973602p.html)
>
>
>
|||My guess is that there is a firewall between the computers which hasn't got
port 1433 open.
Rgds,
Paul Ibison SQL Server MVP, www.replicationanswers.com/default.asp
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
|||Hello,
How to check the port 1433 is open or not?
One server is behind Cisco 1720 router with direct IP address.
One server is behind DSL router, I forward port 21, 80, and 1433 to this
server.
I try to use FTP and Web, and I don't have any problem.
Thanks
"Paul Ibison" wrote:
> My guess is that there is a firewall between the computers which hasn't got
> port 1433 open.
> Rgds,
> Paul Ibison SQL Server MVP, www.replicationanswers.com/default.asp
> (recommended sql server 2000 replication book:
> http://www.nwsu.com/0974973602p.html)
>
>
>
>
|||It seems you have some sort of network problem rather than a replication
issue, as you can ping the server, but using the same IP address and port
1433 fails at the registration level, even before replication is set up.
Sorry - I doubt I can help you directly much more with this. In my case I
have a network guy that checks the firewall logs to ensure that port 1433
traffic passes from one server to the other through the firewall - maybe you
can have the same done.
Rgds,
Paul Ibison SQL Server MVP, www.replicationanswers.com/default.asp
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
|||Which group should I post to ask the question?
Thanks a lot!!!
"Paul Ibison" wrote:
> It seems you have some sort of network problem rather than a replication
> issue, as you can ping the server, but using the same IP address and port
> 1433 fails at the registration level, even before replication is set up.
> Sorry - I doubt I can help you directly much more with this. In my case I
> have a network guy that checks the firewall logs to ensure that port 1433
> traffic passes from one server to the other through the firewall - maybe you
> can have the same done.
> Rgds,
> Paul Ibison SQL Server MVP, www.replicationanswers.com/default.asp
> (recommended sql server 2000 replication book:
> http://www.nwsu.com/0974973602p.html)
>
>
>
>
>
Showing posts with label public. Show all posts
Showing posts with label public. Show all posts
Friday, March 23, 2012
Wednesday, March 21, 2012
New SQL Login cannot list DB in EM
I have a SQL Server 2000 instance running sp3 (in a
cluster).
When I create a NEW SQL user, and give that user access to
ONE database (public and DBO) I cannot list ANY databases
from Enterprise Manager when I login with that user. If I
refresh the Enterprise Manager Databases View, eventually
it will display the Databases - but only after about 10
minutes and I get access violation errors in my SQL and NT
logs. Even if I create a 'dummy SQL login' and give it
access to Northwind, the same results - I cannot list
databases in Enterprise Manager. I tried making the
Defalt DB both Master and the actual DB with the same
results
I tried to recreate this problem on another Clustered SQL
Server 2000 Instance - this one running sp3a, and I am NOT
able to recreate this problem.
I can't imagine that this is a Service Pack issue. Does
anyone have any suggestions?
If you remove the guest user in any database a similar problem can occur.
Look at the following article:
http://support.microsoft.com/?kbid=315523
PRB: Removal of Guest Account May Cause Handled Exception Access Violation
in SQL Server
Rand
This posting is provided "as is" with no warranties and confers no rights.
|||Thank you very much!!! I ran the script in the KB article and it fixed my problem!
sql
cluster).
When I create a NEW SQL user, and give that user access to
ONE database (public and DBO) I cannot list ANY databases
from Enterprise Manager when I login with that user. If I
refresh the Enterprise Manager Databases View, eventually
it will display the Databases - but only after about 10
minutes and I get access violation errors in my SQL and NT
logs. Even if I create a 'dummy SQL login' and give it
access to Northwind, the same results - I cannot list
databases in Enterprise Manager. I tried making the
Defalt DB both Master and the actual DB with the same
results
I tried to recreate this problem on another Clustered SQL
Server 2000 Instance - this one running sp3a, and I am NOT
able to recreate this problem.
I can't imagine that this is a Service Pack issue. Does
anyone have any suggestions?
If you remove the guest user in any database a similar problem can occur.
Look at the following article:
http://support.microsoft.com/?kbid=315523
PRB: Removal of Guest Account May Cause Handled Exception Access Violation
in SQL Server
Rand
This posting is provided "as is" with no warranties and confers no rights.
|||Thank you very much!!! I ran the script in the KB article and it fixed my problem!
sql
New SQL Login cannot list DB in EM
I have a SQL Server 2000 instance running sp3 (in a
cluster).
When I create a NEW SQL user, and give that user access to
ONE database (public and DBO) I cannot list ANY databases
from Enterprise Manager when I login with that user. If I
refresh the Enterprise Manager Databases View, eventually
it will display the Databases - but only after about 10
minutes and I get access violation errors in my SQL and NT
logs. Even if I create a 'dummy SQL login' and give it
access to Northwind, the same results - I cannot list
databases in Enterprise Manager. I tried making the
Defalt DB both Master and the actual DB with the same
results
I tried to recreate this problem on another Clustered SQL
Server 2000 Instance - this one running sp3a, and I am NOT
able to recreate this problem.
I can't imagine that this is a Service Pack issue. Does
anyone have any suggestions?If you remove the guest user in any database a similar problem can occur.
Look at the following article:
http://support.microsoft.com/?kbid=315523
PRB: Removal of Guest Account May Cause Handled Exception Access Violation
in SQL Server
Rand
This posting is provided "as is" with no warranties and confers no rights.|||Thank you very much!!! I ran the script in the KB article and it fixed my problem!
cluster).
When I create a NEW SQL user, and give that user access to
ONE database (public and DBO) I cannot list ANY databases
from Enterprise Manager when I login with that user. If I
refresh the Enterprise Manager Databases View, eventually
it will display the Databases - but only after about 10
minutes and I get access violation errors in my SQL and NT
logs. Even if I create a 'dummy SQL login' and give it
access to Northwind, the same results - I cannot list
databases in Enterprise Manager. I tried making the
Defalt DB both Master and the actual DB with the same
results
I tried to recreate this problem on another Clustered SQL
Server 2000 Instance - this one running sp3a, and I am NOT
able to recreate this problem.
I can't imagine that this is a Service Pack issue. Does
anyone have any suggestions?If you remove the guest user in any database a similar problem can occur.
Look at the following article:
http://support.microsoft.com/?kbid=315523
PRB: Removal of Guest Account May Cause Handled Exception Access Violation
in SQL Server
Rand
This posting is provided "as is" with no warranties and confers no rights.|||Thank you very much!!! I ran the script in the KB article and it fixed my problem!
New SQL Login cannot list DB in EM
I have a SQL Server 2000 instance running sp3 (in a
cluster).
When I create a NEW SQL user, and give that user access to
ONE database (public and DBO) I cannot list ANY databases
from Enterprise Manager when I login with that user. If I
refresh the Enterprise Manager Databases View, eventually
it will display the Databases - but only after about 10
minutes and I get access violation errors in my SQL and NT
logs. Even if I create a 'dummy SQL login' and give it
access to Northwind, the same results - I cannot list
databases in Enterprise Manager. I tried making the
Defalt DB both Master and the actual DB with the same
results
I tried to recreate this problem on another Clustered SQL
Server 2000 Instance - this one running sp3a, and I am NOT
able to recreate this problem.
I can't imagine that this is a Service Pack issue. Does
anyone have any suggestions?If you remove the guest user in any database a similar problem can occur.
Look at the following article:
http://support.microsoft.com/?kbid=315523
PRB: Removal of Guest Account May Cause Handled Exception Access Violation
in SQL Server
Rand
This posting is provided "as is" with no warranties and confers no rights.|||Thank you very much!!! I ran the script in the KB article and it fixed my
problem!
cluster).
When I create a NEW SQL user, and give that user access to
ONE database (public and DBO) I cannot list ANY databases
from Enterprise Manager when I login with that user. If I
refresh the Enterprise Manager Databases View, eventually
it will display the Databases - but only after about 10
minutes and I get access violation errors in my SQL and NT
logs. Even if I create a 'dummy SQL login' and give it
access to Northwind, the same results - I cannot list
databases in Enterprise Manager. I tried making the
Defalt DB both Master and the actual DB with the same
results
I tried to recreate this problem on another Clustered SQL
Server 2000 Instance - this one running sp3a, and I am NOT
able to recreate this problem.
I can't imagine that this is a Service Pack issue. Does
anyone have any suggestions?If you remove the guest user in any database a similar problem can occur.
Look at the following article:
http://support.microsoft.com/?kbid=315523
PRB: Removal of Guest Account May Cause Handled Exception Access Violation
in SQL Server
Rand
This posting is provided "as is" with no warranties and confers no rights.|||Thank you very much!!! I ran the script in the KB article and it fixed my
problem!
Monday, March 12, 2012
New MS SQL User cannot display DBs via Enterprise Manager
I have a SQL Server 2000 instance running sp3 (in a cluster).
When I create a NEW SQL user, and give that user access to ONE database (pub
lic and DBO) I cannot list ANY databases from Enterprise Manager when I logi
n with that user. If I refresh the Enterprise Manager Databases View, eventu
ally it will display the Da
tabases - but only after about 10 minutes and I get access violation errors
in my SQL and NT logs. Even if I create a 'dummy SQL login' and give it acce
ss to Northwind, the same results - I cannot list databases in Enterprise Ma
nager. I tried changing the
users default DB to Master - but I got the same results. It does not seem t
o matter what I make the default DB for this user - I still get the errors.
I tried to recreate this problem on another Clustered SQL Server 2000 Instan
ce - this one running sp3a, and I am NOT able to recreate this problem.
I can't imagine that this is a Service Pack issue. Does anyone have any sugg
estions?Previous post "If I refresh the Enterprise Manager Databases View,
eventually it will display the Databases - but only after about 10 minutes
and I get access violation errors in my SQL and NT logs. "
I'd recommend opening up a support case with a SQL Engineer to review teh
Access Violation errors. All bets are off until you resolve this first.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.|||Found the following KB article
http://support.microsoft.com/defaul...15523&Product=s
ql2k
and I checked this out by doing a select * from sysusers on each of my
Databases and 'some' of them had the guest account deleted directly from
their sysusers table!!!
To test the script in the article, I took a 'healthy' DEV Instance,
turned ON the switch in the server setttings that allows modifications
to be made directly to system catalogs, then I deleted the guest account
in one of my user databases. This 'broke' it and i could no longer get
a list of DBs in EM without sysadmin priviledges. I ran the script
which checked each DB and adds the guest account make in if it find it
missing and then disables the "allow modifications to be made directly
to system catalogs" switch. AND THIS WORKED!!!!
Thought I would pass this on. Thank you everyone for your input.
*** Sent via Developersdex http://www.examnotes.net ***
Don't just participate in USENET...get rewarded for it!
When I create a NEW SQL user, and give that user access to ONE database (pub
lic and DBO) I cannot list ANY databases from Enterprise Manager when I logi
n with that user. If I refresh the Enterprise Manager Databases View, eventu
ally it will display the Da
tabases - but only after about 10 minutes and I get access violation errors
in my SQL and NT logs. Even if I create a 'dummy SQL login' and give it acce
ss to Northwind, the same results - I cannot list databases in Enterprise Ma
nager. I tried changing the
users default DB to Master - but I got the same results. It does not seem t
o matter what I make the default DB for this user - I still get the errors.
I tried to recreate this problem on another Clustered SQL Server 2000 Instan
ce - this one running sp3a, and I am NOT able to recreate this problem.
I can't imagine that this is a Service Pack issue. Does anyone have any sugg
estions?Previous post "If I refresh the Enterprise Manager Databases View,
eventually it will display the Databases - but only after about 10 minutes
and I get access violation errors in my SQL and NT logs. "
I'd recommend opening up a support case with a SQL Engineer to review teh
Access Violation errors. All bets are off until you resolve this first.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.|||Found the following KB article
http://support.microsoft.com/defaul...15523&Product=s
ql2k
and I checked this out by doing a select * from sysusers on each of my
Databases and 'some' of them had the guest account deleted directly from
their sysusers table!!!
To test the script in the article, I took a 'healthy' DEV Instance,
turned ON the switch in the server setttings that allows modifications
to be made directly to system catalogs, then I deleted the guest account
in one of my user databases. This 'broke' it and i could no longer get
a list of DBs in EM without sysadmin priviledges. I ran the script
which checked each DB and adds the guest account make in if it find it
missing and then disables the "allow modifications to be made directly
to system catalogs" switch. AND THIS WORKED!!!!
Thought I would pass this on. Thank you everyone for your input.
*** Sent via Developersdex http://www.examnotes.net ***
Don't just participate in USENET...get rewarded for it!
Subscribe to:
Posts (Atom)