Enterprise Mgr to remote database

Hi Guys,
I have a web app hosted on an external box with my dev box here. both use identical SQL2000 backends. What I would like is to have my Enterprise Manager have both servers registered so that I can work from one interface. No probs getting the local one registered, but how do I register the external DB server? It's not in my domain, but I do have an IP address and Administrator rights on the remote box. This is probably simple, but I must be missing something.
Thanks
MikeJust add your external server as linked...|||Umm . . OK.

1. So New Sql Server Registration gives me the Register Wizard.
2. I enter the IP address manually in the Available Servers field and click add. Click Next.
3. So far, so good. Can't use my current Windows Account info (different domain), so I select SQL Server login info and put in SA account details.
4. I get a Connecting dialog then "SQL Server does not exist or access denied - ConnectionOpen - (Connect()"

Sorry if I sound dense, but . . . . .|||Try using the subdomain.domain address construct rather than IP address.

Example:

somesqlservermachinename.domain.com

I've had problems connecting to one of our remote SQL Servers via IP address (odd, since the same server is in the same subnet as two other SQL Servers that I can connect fine using their IP Addresses). But the subdomain construct works just fine.

Enterprise Manager Use of Port 445

SQL Server 2005 Enterprise Manager running on a Windows 2003 member server
is constantly trying to reach the remote SQL Server on port 445. That
implies that File & Printer Sharing would be turned on at the destination
SQL Server. We do turn on File & Printer sharing lightly on servers
because of the security implications, so in this case the Enterprise Manager
cannot connect on port 445. It is still trying to do this persistently,
and even after the admin connects to the database and starts using it, the
Enterprise Manager is persisting repeatedly, forever, to connect on port
445.
What specific functionality is Enterprise Manager attempting to invoke on
the target by use of port 445? Is it something as simple as an
automatic service start request to the SQL Server service on the target
machine?
--
WillHi Will
SQL Server 2005 has Management Studio and not Enterprise Manager.
Port 445 is used in for Named Pipes, if your server is not using this
protocol it should be disabled in the server configuration tool.
John
"Will" wrote:
> SQL Server 2005 Enterprise Manager running on a Windows 2003 member server
> is constantly trying to reach the remote SQL Server on port 445. That
> implies that File & Printer Sharing would be turned on at the destination
> SQL Server. We do turn on File & Printer sharing lightly on servers
> because of the security implications, so in this case the Enterprise Manager
> cannot connect on port 445. It is still trying to do this persistently,
> and even after the admin connects to the database and starts using it, the
> Enterprise Manager is persisting repeatedly, forever, to connect on port
> 445.
> What specific functionality is Enterprise Manager attempting to invoke on
> the target by use of port 445? Is it something as simple as an
> automatic service start request to the SQL Server service on the target
> machine?
> --
> Will
>
>|||My guess is that it is SSMS that periodically check if the instance is running (service is
starting). In 2000's EM, you could configure whether to do this with the registration, but I didn't
find such an option in SSMS...
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Will" <westes-usc@.noemail.nospam> wrote in message
news:OoSdnTJTDtYbFpDanZ2dnUVZ_jWdnZ2d@.giganews.com...
> SQL Server 2005 Enterprise Manager running on a Windows 2003 member server is constantly trying to
> reach the remote SQL Server on port 445. That implies that File & Printer Sharing would be
> turned on at the destination SQL Server. We do turn on File & Printer sharing lightly on servers
> because of the security implications, so in this case the Enterprise Manager cannot connect on
> port 445. It is still trying to do this persistently, and even after the admin connects to the
> database and starts using it, the Enterprise Manager is persisting repeatedly, forever, to connect
> on port 445.
> What specific functionality is Enterprise Manager attempting to invoke on the target by use of
> port 445? Is it something as simple as an automatic service start request to the SQL Server
> service on the target machine?
> --
> Will
>|||Tibor Karaszi (tibor_please.no.email_karaszi@.hotmail.nomail.com) writes:
> My guess is that it is SSMS that periodically check if the instance is
> running (service is starting). In 2000's EM, you could configure whether
> to do this with the registration, but I didn't find such an option in
> SSMS...
You can make it happen less often if you set
HKLM\Software\Microsoft\Microsoft SQL Server\90\Tools\Shell\PollingInterval
to a suitable value. The unit is apparently centiseconds. See
https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=247367.
Beware that on a 64-bit machine the location is
HKLM\SOFTWARE\Wow6432Node\Microsoft\Microsoft SQL Server\90\Tools\Shell
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx|||"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:1B1E5FB9-7471-4623-A237-55F873D6B7F4@.microsoft.com...
> SQL Server 2005 has Management Studio and not Enterprise Manager.
> Port 445 is used in for Named Pipes, if your server is not using this
> protocol it should be disabled in the server configuration tool.
Apparently my programmer is using a third party administrator tool. I'm
sure he also uses Enterprise Manager. Are you saying Enterprise Manager
will fail to work on a client when contact SQL Server 2005? He is managing
a production SQL Server 2000 database and just now starting to work with SQL
Server 2005 experimentally.
We already set the client and server protocols at the console of the SQL
Server 2005 computer using the SQL configuration tool, and all protocols
except for TCP and Shared Memory are disabled.
How does the client bootstrap which protocol to use to initiate connection
to the server? There is a catch 22 there where the client does not know
the server configuration regarding client protocols until after client
connects. How does the server communicate its client protocol settings
back to the client? Client is just attempting named pipes no matter what,
then backing off to TCP as a second choice, and once connection is made,
then obeying client protocol rules configured on the server?
--
Will
> "Will" wrote:
>> SQL Server 2005 Enterprise Manager running on a Windows 2003 member
>> server
>> is constantly trying to reach the remote SQL Server on port 445. That
>> implies that File & Printer Sharing would be turned on at the destination
>> SQL Server. We do turn on File & Printer sharing lightly on servers
>> because of the security implications, so in this case the Enterprise
>> Manager
>> cannot connect on port 445. It is still trying to do this persistently,
>> and even after the admin connects to the database and starts using it,
>> the
>> Enterprise Manager is persisting repeatedly, forever, to connect on port
>> 445.
>> What specific functionality is Enterprise Manager attempting to invoke on
>> the target by use of port 445? Is it something as simple as an
>> automatic service start request to the SQL Server service on the target
>> machine?
>> --
>> Will
>>|||"Erland Sommarskog" <esquel@.sommarskog.se> wrote in message
news:Xns99C728CF744BYazorman@.127.0.0.1...
> Tibor Karaszi (tibor_please.no.email_karaszi@.hotmail.nomail.com) writes:
>> My guess is that it is SSMS that periodically check if the instance is
>> running (service is starting). In 2000's EM, you could configure whether
>> to do this with the registration, but I didn't find such an option in
>> SSMS...
> You can make it happen less often if you set
> HKLM\Software\Microsoft\Microsoft SQL
> Server\90\Tools\Shell\PollingInterval
> to a suitable value. The unit is apparently centiseconds. See
> https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=247367.
> Beware that on a 64-bit machine the location is
> HKLM\SOFTWARE\Wow6432Node\Microsoft\Microsoft SQL Server\90\Tools\Shell
When I went to the appropriate location on a 32-bit machine, the
PollingInterval Value does not exist. Should I create it and what Value
type should it be?
Since my programmer is using an older management client, my guess is the
port 445 behavior we are seeing is specific to that tool and not
controllable by this registry value, but no harm in trying to change its
value and seeing effect on client behavior.
Is there really nothing that can be set on the client computer itself as a
guideline for behavior of client applications? Are applications like
Enterprise Manager and Management Studio using any specific database API
like OLEDB, or are they using proprietary protocols?
--
Will|||Will (westes-usc@.noemail.nospam) writes:
> When I went to the appropriate location on a 32-bit machine, the
> PollingInterval Value does not exist. Should I create it and what Value
> type should it be?
Yes, you need to create it. I only have it on my machine at home, but I
believe it was a DWORD. The reason I looked into this, is that I had the
same problem as in the bug report.
> Since my programmer is using an older management client, my guess is the
> port 445 behavior we are seeing is specific to that tool and not
> controllable by this registry value, but no harm in trying to change its
> value and seeing effect on client behavior.
Is that some non-MS product? In your original post you said "SQL Server 2005
Enterprise Manager", but there is no such beast. If your programmer simply
running the old Enterprise Manager from SQL 2000, simply have him to
delete that registration, or uncheck the option to display server status.
> Is there really nothing that can be set on the client computer itself as a
> guideline for behavior of client applications? Are applications like
> Enterprise Manager and Management Studio using any specific database API
> like OLEDB, or are they using proprietary protocols?
The client computer is the only place where you can set this. Obviously.
And typically it's per application, since it's the application that polls
the server.
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx|||Will (westes-usc@.noemail.nospam) writes:
> We already set the client and server protocols at the console of the SQL
> Server 2005 computer using the SQL configuration tool, and all protocols
> except for TCP and Shared Memory are disabled.
> How does the client bootstrap which protocol to use to initiate
> connection to the server? There is a catch 22 there where the client
> does not know the server configuration regarding client protocols until
> after client connects. How does the server communicate its client
> protocol settings back to the client? Client is just attempting named
> pipes no matter what, then backing off to TCP as a second choice, and
> once connection is made, then obeying client protocol rules configured
> on the server?
You control this with with SQL Configuration Manager or the Client Network
Utility in the SQL 2000 toolset. There you set up in which order the client
is to attempt which protocols.
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx|||Will wrote on Thu, 11 Oct 2007 20:03:45 -0700:
> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message news:1B1E5FB9-7471-4623-A237-55F873D6B7F4@.microsoft.com...
>> SQL Server 2005 has Management Studio and not Enterprise Manager.
>> Port 445 is used in for Named Pipes, if your server is not using this
>> protocol it should be disabled in the server configuration tool.
> Apparently my programmer is using a third party administrator tool. I'm
> sure he also uses Enterprise Manager. Are you saying Enterprise
> Manager will fail to work on a client when contact SQL Server 2005? He
> is managing a production SQL Server 2000 database and just now
> starting to work with SQL Server 2005 experimentally.
Enterprise Manager does not work with SQL Server 2005. SMSS will work with
SQL Server 2000 and 2005, but not version 7 or lower. Makes my job here fun,
as I'm having to support 7, 2000, and 2005 and so have to use both EM and
SMSS. It also means that there's no GUI for handling setting up replication
between 2005 and 7 either, it all has to be done using T-SQL - but it does
work :)
Dan

Enterprise Manager Substitute

Is there a product I can use that would allow me to connect to a remote database and manage data locally? I downloaded the trial version and am using enterprise manager, but once the trial has expired, I"ll need something else. My database is hosted at a
commercial hosting company and I don't need to do any further development. I just need to get into the database and make minor data modifications. Is there something more affordable than purchasing the entire SQL Server suite?
Try this:
http://www.microsoft.com/downloads/d...displaylang=en
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Cindy" <cindy@.penchina.com> wrote in message
news:1087340B-6AB2-4831-B9E1-72F281FCC6CB@.microsoft.com...
> Is there a product I can use that would allow me to connect to a remote
database and manage data locally? I downloaded the trial version and am
using enterprise manager, but once the trial has expired, I"ll need
something else. My database is hosted at a commercial hosting company and I
don't need to do any further development. I just need to get into the
database and make minor data modifications. Is there something more
affordable than purchasing the entire SQL Server suite?
|||http://www.aspfaq.com/2442
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"Cindy" <cindy@.penchina.com> wrote in message
news:1087340B-6AB2-4831-B9E1-72F281FCC6CB@.microsoft.com...
> Is there a product I can use that would allow me to connect to a remote
database and manage data locally? I downloaded the trial version and am
using enterprise manager, but once the trial has expired, I"ll need
something else. My database is hosted at a commercial hosting company and I
don't need to do any further development. I just need to get into the
database and make minor data modifications. Is there something more
affordable than purchasing the entire SQL Server suite?
|||Thanks Aaron. I wanted to send you an email off the list but your email address got bounced so if you can send me your email address, that would be great.
|||Take out the TRASH.
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"Cindy" <cindy@.penchina.com> wrote in message
news:ACA8D9A0-6807-47F8-8E27-B8B981F980F2@.microsoft.com...
> Thanks Aaron. I wanted to send you an email off the list but your email
address got bounced so if you can send me your email address, that would be
great.

Enterprise Manager Substitute

Is there a product I can use that would allow me to connect to a remote data
base and manage data locally? I downloaded the trial version and am using en
terprise manager, but once the trial has expired, I"ll need something else.
My database is hosted at a
commercial hosting company and I don't need to do any further development. I
just need to get into the database and make minor data modifications. Is th
ere something more affordable than purchasing the entire SQL Server suite?Try this:
A332CB7F959&displaylang=en" target="_blank">http://www.microsoft.com/downloads/...&displaylang=en
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Cindy" <cindy@.penchina.com> wrote in message
news:1087340B-6AB2-4831-B9E1-72F281FCC6CB@.microsoft.com...
> Is there a product I can use that would allow me to connect to a remote
database and manage data locally? I downloaded the trial version and am
using enterprise manager, but once the trial has expired, I"ll need
something else. My database is hosted at a commercial hosting company and I
don't need to do any further development. I just need to get into the
database and make minor data modifications. Is there something more
affordable than purchasing the entire SQL Server suite?|||http://www.aspfaq.com/2442
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"Cindy" <cindy@.penchina.com> wrote in message
news:1087340B-6AB2-4831-B9E1-72F281FCC6CB@.microsoft.com...
> Is there a product I can use that would allow me to connect to a remote
database and manage data locally? I downloaded the trial version and am
using enterprise manager, but once the trial has expired, I"ll need
something else. My database is hosted at a commercial hosting company and I
don't need to do any further development. I just need to get into the
database and make minor data modifications. Is there something more
affordable than purchasing the entire SQL Server suite?|||Thanks Aaron. I wanted to send you an email off the list but your email addr
ess got bounced so if you can send me your email address, that would be grea
t.|||Take out the TRASH.
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"Cindy" <cindy@.penchina.com> wrote in message
news:ACA8D9A0-6807-47F8-8E27-B8B981F980F2@.microsoft.com...
> Thanks Aaron. I wanted to send you an email off the list but your email
address got bounced so if you can send me your email address, that would be
great.

Enterprise Manager Substitute

Is there a product I can use that would allow me to connect to a remote database and manage data locally? I downloaded the trial version and am using enterprise manager, but once the trial has expired, I"ll need something else. My database is hosted at a commercial hosting company and I don't need to do any further development. I just need to get into the database and make minor data modifications. Is there something more affordable than purchasing the entire SQL Server suite?Try this:
http://www.microsoft.com/downloads/details.aspx?FamilyId=C039A798-C57A-419E-ACBC-2A332CB7F959&displaylang=en
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Cindy" <cindy@.penchina.com> wrote in message
news:1087340B-6AB2-4831-B9E1-72F281FCC6CB@.microsoft.com...
> Is there a product I can use that would allow me to connect to a remote
database and manage data locally? I downloaded the trial version and am
using enterprise manager, but once the trial has expired, I"ll need
something else. My database is hosted at a commercial hosting company and I
don't need to do any further development. I just need to get into the
database and make minor data modifications. Is there something more
affordable than purchasing the entire SQL Server suite?|||http://www.aspfaq.com/2442
--
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"Cindy" <cindy@.penchina.com> wrote in message
news:1087340B-6AB2-4831-B9E1-72F281FCC6CB@.microsoft.com...
> Is there a product I can use that would allow me to connect to a remote
database and manage data locally? I downloaded the trial version and am
using enterprise manager, but once the trial has expired, I"ll need
something else. My database is hosted at a commercial hosting company and I
don't need to do any further development. I just need to get into the
database and make minor data modifications. Is there something more
affordable than purchasing the entire SQL Server suite?|||Take out the TRASH.
--
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"Cindy" <cindy@.penchina.com> wrote in message
news:ACA8D9A0-6807-47F8-8E27-B8B981F980F2@.microsoft.com...
> Thanks Aaron. I wanted to send you an email off the list but your email
address got bounced so if you can send me your email address, that would be
great.

Enterprise Manager Shortcuts for Remote Servers

Hello and thank you in advance.
I have multiple databases on a single remote MSSQL server (from my ISP). I
can only access them via Enterprise Manager. My quandary is that every time
I log in, I have to click the server name, then wait for the database to
load, then sift through this enormous list to find the database I am seeking.
I'd like to have shortcuts to each specific database so I can connect and
get to the tables with one click.
Anyone know how to do this?
Thanks,
JulianHi Julian,
Do you have restriction for using Query Analyzer also? If not, while
configuring the client ODBC, you can specify the default database you wish to
connect to.
--
Thanks
Yogish|||Thank you for your reply. I don't think I have a restriction for Query
Analyzer, but I am a novice at best and am only barely qualified to use
Enterprise Manager.
Does this mean I'd have to switch to Query Analyzer or are you suggesting
that I can use Query Analyzer to store my default database and somehow tie
that back to using Enterprise Manager? It puzzles me why Enterprise Manager
doesn't allow you to store a default database for each SQL Server
Registration.
"Yogish" wrote:
> Hi Julian,
> Do you have restriction for using Query Analyzer also? If not, while
> configuring the client ODBC, you can specify the default database you wish to
> connect to.
> --
> Thanks
> Yogish|||Hi Julian,
You can do lot of operations with Query Analyzer (QA). If you are using SQL
Server 2000 client, you can use Object Browser to access all the database
objects, provided you have the permission.
Check out Books online.
--
Thanks
Yogish

Enterprise Manager Shortcuts for Remote Servers

Hello and thank you in advance.
I have multiple databases on a single remote MSSQL server (from my ISP). I
can only access them via Enterprise Manager. My quandary is that every time
I log in, I have to click the server name, then wait for the database to
load, then sift through this enormous list to find the database I am seeking.
I'd like to have shortcuts to each specific database so I can connect and
get to the tables with one click.
Anyone know how to do this?
Thanks,
Julian
Hi Julian,
Do you have restriction for using Query Analyzer also? If not, while
configuring the client ODBC, you can specify the default database you wish to
connect to.
Thanks
Yogish
|||Thank you for your reply. I don't think I have a restriction for Query
Analyzer, but I am a novice at best and am only barely qualified to use
Enterprise Manager.
Does this mean I'd have to switch to Query Analyzer or are you suggesting
that I can use Query Analyzer to store my default database and somehow tie
that back to using Enterprise Manager? It puzzles me why Enterprise Manager
doesn't allow you to store a default database for each SQL Server
Registration.
"Yogish" wrote:

> Hi Julian,
> Do you have restriction for using Query Analyzer also? If not, while
> configuring the client ODBC, you can specify the default database you wish to
> connect to.
> --
> Thanks
> Yogish
|||Hi Julian,
You can do lot of operations with Query Analyzer (QA). If you are using SQL
Server 2000 client, you can use Object Browser to access all the database
objects, provided you have the permission.
Check out Books online.
Thanks
Yogish

Enterprise Manager Shortcuts for Remote Servers

Hello and thank you in advance.
I have multiple databases on a single remote MSSQL server (from my ISP). I
can only access them via Enterprise Manager. My quandary is that every time
I log in, I have to click the server name, then wait for the database to
load, then sift through this enormous list to find the database I am seeking
.
I'd like to have shortcuts to each specific database so I can connect and
get to the tables with one click.
Anyone know how to do this?
Thanks,
JulianHi Julian,
Do you have restriction for using Query Analyzer also? If not, while
configuring the client ODBC, you can specify the default database you wish t
o
connect to.
Thanks
Yogish|||Thank you for your reply. I don't think I have a restriction for Query
Analyzer, but I am a novice at best and am only barely qualified to use
Enterprise Manager.
Does this mean I'd have to switch to Query Analyzer or are you suggesting
that I can use Query Analyzer to store my default database and somehow tie
that back to using Enterprise Manager? It puzzles me why Enterprise Manager
doesn't allow you to store a default database for each SQL Server
Registration.
"Yogish" wrote:

> Hi Julian,
> Do you have restriction for using Query Analyzer also? If not, while
> configuring the client ODBC, you can specify the default database you wish
to
> connect to.
> --
> Thanks
> Yogish|||Hi Julian,
You can do lot of operations with Query Analyzer (QA). If you are using SQL
Server 2000 client, you can use Object Browser to access all the database
objects, provided you have the permission.
Check out Books online.
Thanks
Yogish

Enterprise Manager Question

I have two clients who are on the same Remote SQL server with a webhost (SQLSERVERS1500.COM). Is there a way to connect to add this server to enterprise manager twice so I can connect to each of their accounts separately? Currently when I try to do this Ent. Manager tells me that the Server name already exists. I tried addding one of the servers to a different group, but that gave me the same error message.
thanksYes. You want to use client network utility (cliconfg.exe) to create an
alias then connect via the alias.
--
-oj
RAC & QALite!
http://www.rac4sql.net
"max" <ljp007@.hotmail.com> wrote in message
news:F95280E5-2635-4A09-B9D6-2C6BF69E5D3B@.microsoft.com...
> I have two clients who are on the same Remote SQL server with a webhost
(SQLSERVERS1500.COM). Is there a way to connect to add this server to
enterprise manager twice so I can connect to each of their accounts
separately? Currently when I try to do this Ent. Manager tells me that the
Server name already exists. I tried addding one of the servers to a
different group, but that gave me the same error message.
> thanks|||Create aliases in the client network utility, such as Servername_userA and
Servername_userB, that point to the same IP address or domain name. Then
you can create a registration for each "dynamic server name" with different
users.
--
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"max" <ljp007@.hotmail.com> wrote in message
news:F95280E5-2635-4A09-B9D6-2C6BF69E5D3B@.microsoft.com...
> I have two clients who are on the same Remote SQL server with a webhost
(SQLSERVERS1500.COM). Is there a way to connect to add this server to
enterprise manager twice so I can connect to each of their accounts
separately? Currently when I try to do this Ent. Manager tells me that the
Server name already exists. I tried addding one of the servers to a
different group, but that gave me the same error message.
> thanks|||Use the client network utility to define an alias for one.
>--Original Message--
>I have two clients who are on the same Remote SQL server
with a webhost (SQLSERVERS1500.COM). Is there a way to
connect to add this server to enterprise manager twice so
I can connect to each of their accounts separately?
Currently when I try to do this Ent. Manager tells me
that the Server name already exists. I tried addding one
of the servers to a different group, but that gave me the
same error message.
>thanks
>.
>|||Actually, I see it now, its in the sql server groups when I add a new
server. That worked.
Thanks
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Enterprise Manager Port?

What port does SQL Server Enterprise Manager need open to connect to a
remote database? I'm not finding documentation on this.Shabam
By default SQL Server uses port 1433. This is the port Enterprise Manager
will attempt to use when connecting to SQL Server. If the SQL Server you are
attaempting to connect to was set up to use another port you will need to
use the SQL Server Client Network Utility to set up an alias to the port
being used.
Hope this helps
John
"Shabam" wrote:
> What port does SQL Server Enterprise Manager need open to connect to a
> remote database? I'm not finding documentation on this.
>
>|||It's up to the Remote SQL Server and the client network utility. By default
named pipes and TCP port 1433 (UDP port 1434 is a broadcast port for server
name but not necessary) Check the SQL Error log on the remote server to see
what protocol it is listening on. Then check the SQL Server client network
utility on your workstation. Create an alias if necessary.
"Shabam" <chalupa@.yomama-nospam.com> wrote in message
news:3bidnexq3dFh_6TfRVn-gg@.adelphia.com...
> What port does SQL Server Enterprise Manager need open to connect to a
> remote database? I'm not finding documentation on this.
>

Enterprise Manager Logon Failures

Hello,
I have an interesting situation: We have some remote users who connect to a
SQL server remotely with Enterprise Manager. Anytime Ent. Mgr is open on
their machines Accoutn Logon errors are generated in on the SQL server for
the login that they are logged onto their computer with. The registration
for the server specifically uses SQL security to authenticate.
Anybody have any idea why Ent. Manager would be causing this?
Derek
Hi,
Do you want to remove these messages? If yes then just disable the auditing
options in Enterprise manager.
1. Open enterprise manager
2. Select the server you need to disable to auditing
3. Right click and select properties and select "Secury" tab
4. Select the Audit level based on ur requirement
5. Click OK
Did I answer your question?
Thanks
Hari
MCDBA
"Derek" <dg364@.juno.com> wrote in message
news:#$47FNvNEHA.3988@.TK2MSFTNGP09.phx.gbl...
> Hello,
> I have an interesting situation: We have some remote users who connect to
a
> SQL server remotely with Enterprise Manager. Anytime Ent. Mgr is open on
> their machines Accoutn Logon errors are generated in on the SQL server for
> the login that they are logged onto their computer with. The registration
> for the server specifically uses SQL security to authenticate.
> Anybody have any idea why Ent. Manager would be causing this?
> Derek
>
>
|||It could be the polling of the services from the clients.
You can try turning off the polling on the clients and see
if that makes a difference.
In Enterprise Manager, go to tools then select options.
Clear the checkbox for Server State Polling on the
General tab.
-Sue
On Mon, 10 May 2004 17:59:52 -0700, "Derek" <dg364@.juno.com>
wrote:

>Hello,
>I have an interesting situation: We have some remote users who connect to a
>SQL server remotely with Enterprise Manager. Anytime Ent. Mgr is open on
>their machines Accoutn Logon errors are generated in on the SQL server for
>the login that they are logged onto their computer with. The registration
>for the server specifically uses SQL security to authenticate.
>Anybody have any idea why Ent. Manager would be causing this?
>Derek
>
|||Sue,
That did it. Thanks a lot, it was bothering my event logs...
Derek
"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
news:5ff1a0da0iecild95l9jkn9ib01jhadgch@.4ax.com... [vbcol=seagreen]
> It could be the polling of the services from the clients.
> You can try turning off the polling on the clients and see
> if that makes a difference.
> In Enterprise Manager, go to tools then select options.
> Clear the checkbox for Server State Polling on the
> General tab.
> -Sue
> On Mon, 10 May 2004 17:59:52 -0700, "Derek" <dg364@.juno.com>
> wrote:
to a[vbcol=seagreen]
for[vbcol=seagreen]
registration
>
|||Your welcome Derek and thanks for posting back the results!
-Sue
On Tue, 11 May 2004 12:10:42 -0700, "Derek" <dg364@.juno.com>
wrote:

>Sue,
>That did it. Thanks a lot, it was bothering my event logs...
>Derek
>
>"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
>news:5ff1a0da0iecild95l9jkn9ib01jhadgch@.4ax.com.. .
>to a
>for
>registration
>

Enterprise Manager Logon Failures

Hello,
I have an interesting situation: We have some remote users who connect to a
SQL server remotely with Enterprise Manager. Anytime Ent. Mgr is open on
their machines Accoutn Logon errors are generated in on the SQL server for
the login that they are logged onto their computer with. The registration
for the server specifically uses SQL security to authenticate.
Anybody have any idea why Ent. Manager would be causing this?
DerekHi,
Do you want to remove these messages? If yes then just disable the auditing
options in Enterprise manager.
1. Open enterprise manager
2. Select the server you need to disable to auditing
3. Right click and select properties and select "Secury" tab
4. Select the Audit level based on ur requirement
5. Click OK
Did I answer your question?
Thanks
Hari
MCDBA
"Derek" <dg364@.juno.com> wrote in message
news:#$47FNvNEHA.3988@.TK2MSFTNGP09.phx.gbl...
> Hello,
> I have an interesting situation: We have some remote users who connect to
a
> SQL server remotely with Enterprise Manager. Anytime Ent. Mgr is open on
> their machines Accoutn Logon errors are generated in on the SQL server for
> the login that they are logged onto their computer with. The registration
> for the server specifically uses SQL security to authenticate.
> Anybody have any idea why Ent. Manager would be causing this?
> Derek
>
>|||It could be the polling of the services from the clients.
You can try turning off the polling on the clients and see
if that makes a difference.
In Enterprise Manager, go to tools then select options.
Clear the checkbox for Server State Polling on the
General tab.
-Sue
On Mon, 10 May 2004 17:59:52 -0700, "Derek" <dg364@.juno.com>
wrote:

>Hello,
>I have an interesting situation: We have some remote users who connect to
a
>SQL server remotely with Enterprise Manager. Anytime Ent. Mgr is open on
>their machines Accoutn Logon errors are generated in on the SQL server for
>the login that they are logged onto their computer with. The registration
>for the server specifically uses SQL security to authenticate.
>Anybody have any idea why Ent. Manager would be causing this?
>Derek
>|||Sue,
That did it. Thanks a lot, it was bothering my event logs...
Derek
"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
news:5ff1a0da0iecild95l9jkn9ib01jhadgch@.
4ax.com...
> It could be the polling of the services from the clients.
> You can try turning off the polling on the clients and see
> if that makes a difference.
> In Enterprise Manager, go to tools then select options.
> Clear the checkbox for Server State Polling on the
> General tab.
> -Sue
> On Mon, 10 May 2004 17:59:52 -0700, "Derek" <dg364@.juno.com>
> wrote:
>
to a[vbcol=seagreen]
for[vbcol=seagreen]
registration[vbcol=seagreen]
>|||Your welcome Derek and thanks for posting back the results!
-Sue
On Tue, 11 May 2004 12:10:42 -0700, "Derek" <dg364@.juno.com>
wrote:

>Sue,
>That did it. Thanks a lot, it was bothering my event logs...
>Derek
>
>"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
> news:5ff1a0da0iecild95l9jkn9ib01jhadgch@.
4ax.com...
>to a
>for
>registration
>

Enterprise Manager Logon Failures

Hello,
I have an interesting situation: We have some remote users who connect to a
SQL server remotely with Enterprise Manager. Anytime Ent. Mgr is open on
their machines Accoutn Logon errors are generated in on the SQL server for
the login that they are logged onto their computer with. The registration
for the server specifically uses SQL security to authenticate.
Anybody have any idea why Ent. Manager would be causing this?
DerekHi,
Do you want to remove these messages? If yes then just disable the auditing
options in Enterprise manager.
1. Open enterprise manager
2. Select the server you need to disable to auditing
3. Right click and select properties and select "Secury" tab
4. Select the Audit level based on ur requirement
5. Click OK
Did I answer your question?
Thanks
Hari
MCDBA
"Derek" <dg364@.juno.com> wrote in message
news:#$47FNvNEHA.3988@.TK2MSFTNGP09.phx.gbl...
> Hello,
> I have an interesting situation: We have some remote users who connect to
a
> SQL server remotely with Enterprise Manager. Anytime Ent. Mgr is open on
> their machines Accoutn Logon errors are generated in on the SQL server for
> the login that they are logged onto their computer with. The registration
> for the server specifically uses SQL security to authenticate.
> Anybody have any idea why Ent. Manager would be causing this?
> Derek
>
>|||It could be the polling of the services from the clients.
You can try turning off the polling on the clients and see
if that makes a difference.
In Enterprise Manager, go to tools then select options.
Clear the checkbox for Server State Polling on the
General tab.
-Sue
On Mon, 10 May 2004 17:59:52 -0700, "Derek" <dg364@.juno.com>
wrote:
>Hello,
>I have an interesting situation: We have some remote users who connect to a
>SQL server remotely with Enterprise Manager. Anytime Ent. Mgr is open on
>their machines Accoutn Logon errors are generated in on the SQL server for
>the login that they are logged onto their computer with. The registration
>for the server specifically uses SQL security to authenticate.
>Anybody have any idea why Ent. Manager would be causing this?
>Derek
>|||Sue,
That did it. Thanks a lot, it was bothering my event logs...
Derek
"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
news:5ff1a0da0iecild95l9jkn9ib01jhadgch@.4ax.com...
> It could be the polling of the services from the clients.
> You can try turning off the polling on the clients and see
> if that makes a difference.
> In Enterprise Manager, go to tools then select options.
> Clear the checkbox for Server State Polling on the
> General tab.
> -Sue
> On Mon, 10 May 2004 17:59:52 -0700, "Derek" <dg364@.juno.com>
> wrote:
> >Hello,
> >
> >I have an interesting situation: We have some remote users who connect
to a
> >SQL server remotely with Enterprise Manager. Anytime Ent. Mgr is open on
> >their machines Accoutn Logon errors are generated in on the SQL server
for
> >the login that they are logged onto their computer with. The
registration
> >for the server specifically uses SQL security to authenticate.
> >
> >Anybody have any idea why Ent. Manager would be causing this?
> >
> >Derek
> >
> >
>|||Your welcome Derek and thanks for posting back the results!
-Sue
On Tue, 11 May 2004 12:10:42 -0700, "Derek" <dg364@.juno.com>
wrote:
>Sue,
>That did it. Thanks a lot, it was bothering my event logs...
>Derek
>
>"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
>news:5ff1a0da0iecild95l9jkn9ib01jhadgch@.4ax.com...
>> It could be the polling of the services from the clients.
>> You can try turning off the polling on the clients and see
>> if that makes a difference.
>> In Enterprise Manager, go to tools then select options.
>> Clear the checkbox for Server State Polling on the
>> General tab.
>> -Sue
>> On Mon, 10 May 2004 17:59:52 -0700, "Derek" <dg364@.juno.com>
>> wrote:
>> >Hello,
>> >
>> >I have an interesting situation: We have some remote users who connect
>to a
>> >SQL server remotely with Enterprise Manager. Anytime Ent. Mgr is open on
>> >their machines Accoutn Logon errors are generated in on the SQL server
>for
>> >the login that they are logged onto their computer with. The
>registration
>> >for the server specifically uses SQL security to authenticate.
>> >
>> >Anybody have any idea why Ent. Manager would be causing this?
>> >
>> >Derek
>> >
>> >
>

enterprise manager for SQL 2000

Hello,
I have been using SQL 7 for some time and so have the
Enterprise manager to match. I have just started work on a
remote SQL server, which runs SQL 2000 - and so my
Enterprise manager can't communicate with it.
I have looked everywhere, but can't see a way of
controlling the remote server without upgrading my SQL
server to version 2000. This seems a bit of an overkill
when all I want to do is create and import a few tables on
the remote server.
Do I really have to pay for a whole system upgrade, even
though I don't want to use SQL 2000 here, just so I can
import some tables? I can't seem to locate an alternative
Microsoft solution.
Thanks.
DCIf you upgrade your CLient Utilites to SQL2k you will be able to communicate
with the SQL7 and SQL2K boxes. It's backward compatible.
--
HTH
Ryan Waight, MCDBA, MCSE
"david cox" <davidcox@.mail.com> wrote in message
news:044401c37d08$f422d640$a001280a@.phx.gbl...
> Hello,
> I have been using SQL 7 for some time and so have the
> Enterprise manager to match. I have just started work on a
> remote SQL server, which runs SQL 2000 - and so my
> Enterprise manager can't communicate with it.
> I have looked everywhere, but can't see a way of
> controlling the remote server without upgrading my SQL
> server to version 2000. This seems a bit of an overkill
> when all I want to do is create and import a few tables on
> the remote server.
> Do I really have to pay for a whole system upgrade, even
> though I don't want to use SQL 2000 here, just so I can
> import some tables? I can't seem to locate an alternative
> Microsoft solution.
> Thanks.
> DC

Enterprise manager and remote connection

Hi,
I am trying to connect to two different SQL Servers using my broadband inter
net connection.
Both servers are connected to a network which has one "visible" IP address.
Using the Enterprise Manager, I can connect successfully to one SQL Server,
but cannot access the SQL Server on another of the network servers. Obviousl
y in Enterprise Manager, I am supplying the IP address in order to connect t
o the SQL Servers, but how
do I differentiate between the two different SQL Servers at the other end an
d connect to both at the same IP address?
Many thanks,
Jonathan SIf the servers are on the same physical machine, then the default instance
listens on 1433 and the other "named instance" would listen on another
port. You'll need this info in order to connect. By default Named
Instances listen on dynamic ports. You'll want to change this to a fixed
port and only allow traffic to this specific port for the second instance.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.

Enterprise manager and remote connection

Hi,
I am trying to connect to two different SQL Servers using my broadband internet connection.
Both servers are connected to a network which has one "visible" IP address.
Using the Enterprise Manager, I can connect successfully to one SQL Server, but cannot access the SQL Server on another of the network servers. Obviously in Enterprise Manager, I am supplying the IP address in order to connect to the SQL Servers, but how
do I differentiate between the two different SQL Servers at the other end and connect to both at the same IP address?
Many thanks,
Jonathan S
If the servers are on the same physical machine, then the default instance
listens on 1433 and the other "named instance" would listen on another
port. You'll need this info in order to connect. By default Named
Instances listen on dynamic ports. You'll want to change this to a fixed
port and only allow traffic to this specific port for the second instance.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.

Enterprise Manager and named instances

Hi, How to connect via internet to MSDE 2000 named instance using Enterprise
Manager?
On remote server (2K Server) there are installed MSDE 2000 default instance
and named instance. Named instance is using port 3077.
Adam,
in the Client Network utility define an alias which points to your
named instance and define the port number.
M

Enterprise manager - databases - "No items"

Hi all,
I'm using Enterprise Manager to connect to several remote SQL Server
Databases (in different locations).
It works fine for all servers except the one that shows "No items" when I
click on "databases". After "refresh" it successfully receives list of
databases but after a few hours...
When I right click on databases and select "Export data" then I can select
my database from the list but when I specify "Copy objects and data between
SQL server databases" I receive somthing like :
"User 'aaa' is not valid user in database
'some_database_but_different_then_I_have_selected' ".
When I try to create new DTS Package that should "copy SQL Server objects
task" I receive similar error.
I can work with Query Analyzer but don't know how to make backup copy of the
database to my local database since I have only db_owner rights (I'm not
member of sysadmin server role).
I have send the following article
http://support.microsoft.com/default...b;en-us;315523 to my
database povider but he says they have everything set properly...
Can anybody help me, please?
Thank You
George
Hi George,
From your description, I understand that, as a remote client, your SQL
Server Enterprise Manager would occasionally not display the your database.
When refreshing it, the database would display but in a long time. Have I
fully understood you? If there is anything I misunderstood, please feel
free to let me know.
Based on my understanding, the Server has a significant number of databases
and a few of them were marked as autoclose. This meant when user connected
using SQL Server Enterprise Manager, the database would need to be started
before the queries to enumerate tables and data could be run. This delay
was causing the queries to fail and resulted in the databases to not be
displayed. Refreshing allowed the databases to be started while the query
was resubmitted.
To resolve the issue, you should contact your database provider to remove
the autoclose settings form all of your databases. He could do in this way
EXEC sp_MSforeachdb @.command1="sp_dboption '?','autoclose',false"
Autoclose option is not recommended for production systems since it can be
a significant performance impact.
It the above doesn't resovle the issue, You shoud have a look at the size
of tempdb. You could try using one of the methods documented in the
following article to shrink tempdb back to it's original size
307487 HOW TO: Shrink the Tempdb Database in SQL Server
http://support.microsoft.com/?id=307487
Would you please tell me that how large is tempdb currently, and how large
was it when SQL Server Enterprise Manager experienced the failure to
enumerate the databases? Was the autogrowth option turned off for tempdb
previously?
If the above two doesn't resolve your issue, would you please run the
following queries in your Query Analyzer when the problem happens and show
me the results?
select name, DATABASEPROPERTY(name, N'IsDetached'),(case when
DATABASEPROPERTY(name, N'IsShutdown') is null then -1 else
DATABASEPROPERTY(name, N'IsShutdown') end), DATABASEPROPERTY(name,
N'IsSuspect'),
DATABASEPROPERTY(name, N'IsOffline'), DATABASEPROPERTY(name, N'IsInLoad'),
(case when DATABASEPROPERTY(name, N'IsInRecovery') is null then -1 else
DATABASEPROPERTY(name, N'IsInRecovery') end), (case when
DATABASEPROPERTY(name,
N'IsNotRecovered') is null then -1 else
DATABASEPROPERTY(name, N'IsNotRecovered') end), DATABASEPROPERTY(name,
N'IsEmergencyMode'),
DATABASEPROPERTY(name, N'IsInStandBy'), has_dbaccess(name), status,
category,
status2
from master.dbo.sysdatabases
Moreover, detailed information about autoclose option of database could be
found at
Avoiding the Autoclose and Autoshrink Options
http://www.microsoft.com/sql/techinf.../autoclose.asp
AutoClose Property
http://msdn.microsoft.com/library/de...us/sqldmo/dmor
ef_p_a_5cl5.asp
Thank you for your patience and cooperation. If you have any questions or
concerns, don't hesitate to let me know. We are here to be of assistance!
Sincerely yours,
Michael Cheng
Microsoft Online Support
************************************************** *********
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks.
|||Hi George,
I wanted to post a quick note to see whether you have apply my suggestion
and your Enterprise manager works fine. If you would like additional
assistance or information regarding this particular issue. We appreciate
your patience and look forward to hearing from you!
Sincerely yours,
Michael Cheng
Microsoft Online Support
************************************************** *********
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks.
|||Hi Michael,
sorry for delay. I have send Your information to my database provider. He
has promissed that he checks it in few days. Now I have tried to connect to
my database and IT WORKS!!! I can see databases, I can work with my
database, I have succesfully run my DTS packages too and everything is
without delay.
Thank You very much for Your help!!!
Best regards
George
""Michael, Cheng [MSFT]"" <v-mingqc@.online.microsoft.com> wrote in message
news:z3vX9N2KEHA.3088@.cpmsftngxa10.phx.gbl...
> Hi George,
> I wanted to post a quick note to see whether you have apply my suggestion
> and your Enterprise manager works fine. If you would like additional
> assistance or information regarding this particular issue. We appreciate
> your patience and look forward to hearing from you!
> Sincerely yours,
> Michael Cheng
> Microsoft Online Support
> ************************************************** *********
> Get Secure! - www.microsoft.com/security
> This posting is provided "as is" with no warranties and confers no rights.
> Please reply to newsgroups only, many thanks.
>

Enterprise Manager - Available Servers - remote instance not listed

When using the register available servers in Enterprise Manager, the
named instances on a remote machine are not listed. The unnamed
instance is listed and will register successfully.
I have tried manually typing the names of the remote NAMED instances;
then tried to authenticate and get the message "SQL server does not
exist or access denied".
Local machine; SQL Server 2000 SP4 (Developer Edition) installed.
2 Instances
Unnamed
DEV\DB1
On the remote machine SQL Server 2000 (MSDE Edition) installed
3 Instances;
Unnamed
REM\DB1
REM\DB2
Both machines are on the same domain. All SQL server instances are
running.
I have also used the svrnetcn.exe tool to make sure the Named Pipes
and TCP/IP protocols are enabled. The port on the TCP/IP protocol has
been changed to 1433 on all remote instances. (both machines were
rebooted)
What else can I check ?
Thanks
DOn Sep 18, 9:18 pm, do <dmc...@.gmail.com> wrote:
> When using the register available servers in Enterprise Manager, the
> named instances on a remote machine are not listed. The unnamed
> instance is listed and will register successfully.
> I have tried manually typing the names of the remote NAMED instances;
> then tried to authenticate and get the message "SQL server does not
> exist or access denied".
> Local machine; SQL Server 2000 SP4 (Developer Edition) installed.
> 2 Instances
> Unnamed
> DEV\DB1
> On the remote machine SQL Server 2000 (MSDE Edition) installed
> 3 Instances;
> Unnamed
> REM\DB1
> REM\DB2
Create an alias for the named instances on the client end & then try
registering...
> Both machines are on the same domain. All SQL server instances are
> running.
> I have also used the svrnetcn.exe tool to make sure the Named Pipes
> and TCP/IP protocols are enabled. The port on the TCP/IP protocol has
> been changed to 1433 on all remote instances. (both machines were
> rebooted)
> What else can I check ?
> Thanks
> D

Enterprise Manager - Available Servers - remote instance not listed

When using the register available servers in Enterprise Manager, the
named instances on a remote machine are not listed. The unnamed
instance is listed and will register successfully.
I have tried manually typing the names of the remote NAMED instances;
then tried to authenticate and get the message "SQL server does not
exist or access denied".
Local machine; SQL Server 2000 SP4 (Developer Edition) installed.
2 Instances
Unnamed
DEV\DB1
On the remote machine SQL Server 2000 (MSDE Edition) installed
3 Instances;
Unnamed
REM\DB1
REM\DB2
Both machines are on the same domain. All SQL server instances are
running.
I have also used the svrnetcn.exe tool to make sure the Named Pipes
and TCP/IP protocols are enabled. The port on the TCP/IP protocol has
been changed to 1433 on all remote instances. (both machines were
rebooted)
What else can I check ?
Thanks
DHow about trying adding aliases from SQL Server Client Network Utility?
Add Aliases for your named instances and try connecting then.
You may obtain more info about this from the following link:
http://msdn2.microsoft.com/en-us/library/aa213780(SQL.80).aspx
You may want to have a look at the following article from BOL to learn more
about Browser Service of SQL Server 2005. This may be irrelevant however it
informs you about SS2000' s listening service too. It may give you an idea.
http://msdn2.microsoft.com/en-us/library/ms181087.aspx
--
Ekrem Önsoy
"do" <dmcb73@.gmail.com> wrote in message
news:1190189984.640820.24640@.o80g2000hse.googlegroups.com...
> When using the register available servers in Enterprise Manager, the
> named instances on a remote machine are not listed. The unnamed
> instance is listed and will register successfully.
> I have tried manually typing the names of the remote NAMED instances;
> then tried to authenticate and get the message "SQL server does not
> exist or access denied".
> Local machine; SQL Server 2000 SP4 (Developer Edition) installed.
> 2 Instances
> Unnamed
> DEV\DB1
> On the remote machine SQL Server 2000 (MSDE Edition) installed
> 3 Instances;
> Unnamed
> REM\DB1
> REM\DB2
> Both machines are on the same domain. All SQL server instances are
> running.
> I have also used the svrnetcn.exe tool to make sure the Named Pipes
> and TCP/IP protocols are enabled. The port on the TCP/IP protocol has
> been changed to 1433 on all remote instances. (both machines were
> rebooted)
> What else can I check ?
> Thanks
> D
>