Connecting to SQL across Non-Trusted Domains

The problem I am having is this :
SQL Servers in a non -trusted Windows 2000 Domain (Test domain) do not show
as being alive in Enterprise Manager unless you map a drive to a server in t
he non-trusted domain.
Has anyone seem this problem before? Not sure whether this is related to Act
ive Directory.
Also all our SQL Instances use specific port numbers.
Thanks
CPNZSounds like the Agent polling is not able to contact the other servers
unless you map a drive allowing your server
to communicate with the others. This is more of a problem with disjoined
domains that SQL Server.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.|||You can do the following.
Your SQL Server instances must be running as a LOCAL or Domain account. If
you configure a LOCAL account on the server you are trying to connect to
with the same username and password it will log in using this account.
Barry McAuslin
Look inside your SQL Server files with SQL File Explorer.
Go to http://www.sqlfe.com for more information.
"CPNZ" <anonymous@.discussions.microsoft.com> wrote in message
news:72C261EE-AB91-45D1-BA20-EE1F805E3FD0@.microsoft.com...
> The problem I am having is this :
> SQL Servers in a non -trusted Windows 2000 Domain (Test domain) do not
show as being alive in Enterprise Manager unless you map a drive to a server
in the non-trusted domain.
> Has anyone seem this problem before? Not sure whether this is related to
Active Directory.
> Also all our SQL Instances use specific port numbers.
> Thanks
> CPNZ|||Okay. We have clients using Enterprise Manager, and they used to be able to
connect accross these domains using SQL authentication.
Kevin could there be an Active Directory issue stopping these services being
seen accross the domains? My server people say nothing has changed in AD,
but you never know. Also could you give a little more info on the Polling A
gent.
Thanks
Clint|||Hi Clint,
The SQL Server state polling is controlled in Enterprise Manager.
Go to the server you registered. Then Select from the menu, Tools ,
Options.
By default we poll servers every 10 seconds.
Check to see if you're clients connect using Named Pipes or TCP/IP sockets.
You'll be unable to connect to a remote server in an untrusted domain
using Named Pipes. Use the SQL Client network utility to specify tcp/ip as
the protocol to connect to the remote server.
Hope this helps.
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.

Connecting to SQL across Non-Trusted Domains

The problem I am having is this :
SQL Servers in a non -trusted Windows 2000 Domain (Test domain) do not show
as being alive in Enterprise Manager unless you map a drive to a server in t
he non-trusted domain.
Has anyone seem this problem before? Not sure whether this is related to Act
ive Directory.
Also all our SQL Instances use specific port numbers.
ThanksClint,
That's called "working as designed" I'm afraif - it's expecting there to be
an underlying NT authentication.

> The problem I am having is this :
> SQL Servers in a non -trusted Windows 2000 Domain (Test domain) do not sho
w as being alive in Enterprise Manager unless you map a drive to a server in
the non-trusted domain.
> Has anyone seem this problem before? Not sure whether this is related to A
ctive Directory.
> Also all our SQL Instances use specific port numbers.
> Thanks
>
Neil Pike MVP/MCSE. Protech Computing Ltd
Reply here - no email
SQL FAQ (484 entries) see
http://forumsb.compuserve.com/gvfor...p?SRV=MSDevApps
(faqxxx.zip in lib 7)
or www.ntfaq.com/Articles/Index.cfm?DepartmentID=800
or www.sqlserverfaq.com
or www.mssqlserver.com/faq

Connecting to Reporting Services Server failed!!!

SQL Server 2005 and SSRS 2005 is curently installed on the same box. The OS is Windows 2003 (S) enterprise edition.

When I connect to the Reporting Services Server using the Sql Server Management studio I get the following error message

The request failed with HTTP status 407: Proxy Authentication Required.

(Microsoft.sqlserver.Management.UI.RSClient)

rsAccessDenied

I am tring to connect using the Windows Admin id. I would like to get an answer from this form.

-Aza

Any body to help here

-Nitu

Connecting to Remote SQL server - time out expired?

Hello

Im connecting to a remote SQL Server in Enterprise Manager Via VPN,

we checked the connection and everything but still o cant connect

to the remote server, Error message says "Time Out Expired",

we checked the firewall config, ADSL connection and it's all Ok

what seems to be the problem here??Hello

Im connecting to a remote SQL Server in Enterprise Manager Via VPN,

we checked the connection and everything but still o cant connect

to the remote server, Error message says "Time Out Expired",

we checked the firewall config, ADSL connection and it's all Ok

what seems to be the problem here??

There are oh so many possibilities...

1. Can you telnet to the remote server on the correct port?
2. Is there another firewall at the other end (I assume so since it's a VPN)? If so, can you verify that the traffic is getting beyond that firewall?
3. Are both firewalls set to handle the "hand-off" that occurs when incoming traffic on port 1433 is handed off to a negotiated port? This is usually automatic, but on some older firewalls, it must be manually configured.
4. Are you using hostname or IP address to connect? If hostname, what is the name resolution service running (I assume DNS)? If DNS, are you sure about the IP Address resolution?
5. Are you NAT'ing the internal IP addresses? Are the NATs configured correctly.

Look at your firewall logs carefully (hopefully there's a nice GUI to help you). The answer is likely in there somewhere. It may not be easy to find, but it's in there.

Regards,

hmscott

Connecting to remote SQL Server

I have SQL Server 2000 (Developer) on my computer. So I have SQL
Server Enterprise Manager + Tools (such as Query Analyzer).
I am doing some work on a remote server, mostly ASP pages (not
ASP.NET). There is a SQL Server database on that server. I would like
to use Enterprise Manager or Query Analyzer to access that database.
My main development environment is Dreamweaver MX2004. In Dreamweaver,
I was able to setup the database (on the databases tab) using a
"Custom Connection String", listed below (some info obfuscated for
security):
"Provider=SQLOLEDB.1;Persist Security Info=False;Initial
Catalog=funeral;Data Source=xx.xx.xx.xxx;Locale
Identifier=1033;Connect Timeout=15;Use Procedure for Prepare=1;Auto
Translate=True;Packet Size=4096;User Id=XXX;PASSWORD=XXXXXXXX;"
I don't know if it is possible to use the other tools to manage this
database. I've tried the following:
1. In Enterprise Manager, I've tried just putting the ip address as
the server, and "Use SQL Server authentication" from the user ID and
Password above, but I get the following error:
"SQL Server registration failed because of the connection failure
below... Cannot open user default database. Login failed"
2. Created a udl file. In the Provider, selected the "Microsoft OLE DB
Provider for SQL Server" Entered teh IP address and username/password
on the Connection Tab. I get the same error as #1 above.
Any insight would be greatly appreciated.
"Bryce Fischer" <spamtrap@.berzerker-soft.com> wrote in message
news:3btpo01us397pf1gmfl4bt9c8k9dcrv05e@.4ax.com...
> I have SQL Server 2000 (Developer) on my computer. So I have SQL
> Server Enterprise Manager + Tools (such as Query Analyzer).
> I am doing some work on a remote server, mostly ASP pages (not
> ASP.NET). There is a SQL Server database on that server. I would like
> to use Enterprise Manager or Query Analyzer to access that database.
> My main development environment is Dreamweaver MX2004. In Dreamweaver,
> I was able to setup the database (on the databases tab) using a
> "Custom Connection String", listed below (some info obfuscated for
> security):
> "Provider=SQLOLEDB.1;Persist Security Info=False;Initial
> Catalog=funeral;Data Source=xx.xx.xx.xxx;Locale
> Identifier=1033;Connect Timeout=15;Use Procedure for Prepare=1;Auto
> Translate=True;Packet Size=4096;User Id=XXX;PASSWORD=XXXXXXXX;"
> I don't know if it is possible to use the other tools to manage this
> database. I've tried the following:
> 1. In Enterprise Manager, I've tried just putting the ip address as
> the server, and "Use SQL Server authentication" from the user ID and
> Password above, but I get the following error:
> "SQL Server registration failed because of the connection failure
> below... Cannot open user default database. Login failed"
>
User XXX has a login on the remote server, but does not have a user in the
database he is configured to use. To administer the remote database, User
XXX must be a member of the sysadmin role on the remote server
http://snodland.blogspot.com
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.788 / Virus Database: 533 - Release Date: 01/11/2004
|||On Sat, 6 Nov 2004 22:04:54 -0000, "Bob Simms"
<bob_simms@.somewhere.com> wrote:

>User XXX has a login on the remote server, but does not have a user in the
>database he is configured to use. To administer the remote database, User
>XXX must be a member of the sysadmin role on the remote server
Thanks for the reply.
Is it possible to use Query Analyzer or Access to connect to the
server given the information in my original post? I don't need
administrator-like functionality. As I mentioned, in Dreamweaver, I'm
able to create a connection, and view the tables and data (not to be
confused with creating the connection on the ASP pages, but in
Dreamweaver itself.) Dreamweaver lets you browse the tables, and data,
it doesn't let you run SQL Statements, which is why I'd like to use
other tools I have.
TIA.
|||On Sat, 06 Nov 2004 20:21:58 -0500, Bryce Fischer
<spamtrap@.berzerker-soft.com> wrote:

>On Sat, 6 Nov 2004 22:04:54 -0000, "Bob Simms"
><bob_simms@.somewhere.com> wrote:
>
>Thanks for the reply.
>Is it possible to use Query Analyzer or Access to connect to the
>server given the information in my original post? I don't need
>administrator-like functionality. As I mentioned, in Dreamweaver, I'm
>able to create a connection, and view the tables and data (not to be
>confused with creating the connection on the ASP pages, but in
>Dreamweaver itself.) Dreamweaver lets you browse the tables, and data,
>it doesn't let you run SQL Statements, which is why I'd like to use
>other tools I have.
Well... After some persistence, I figured it out. In Access, and
Visual Studio, I was able to bring up the Data Link Properties dialog,
and enter the information, and the one step I was not doing, was
entering in the catalog in the "Select the database on the server:"
field.
I was able to accomplish the same thing in Visual Studio, Server
Explorer, Data Connections.

Connecting to remote SQL Server

I have SQL Server 2000 (Developer) on my computer. So I have SQL
Server Enterprise Manager + Tools (such as Query Analyzer).
I am doing some work on a remote server, mostly ASP pages (not
ASP.NET). There is a SQL Server database on that server. I would like
to use Enterprise Manager or Query Analyzer to access that database.
My main development environment is Dreamweaver MX2004. In Dreamweaver,
I was able to setup the database (on the databases tab) using a
"Custom Connection String", listed below (some info obfuscated for
security):
"Provider=SQLOLEDB.1;Persist Security Info=False;Initial
Catalog=funeral;Data Source=xx.xx.xx.xxx;Locale
Identifier=1033;Connect Timeout=15;Use Procedure for Prepare=1;Auto
Translate=True;Packet Size=4096;User Id=XXX;PASSWORD=XXXXXXXX;"
I don't know if it is possible to use the other tools to manage this
database. I've tried the following:
1. In Enterprise Manager, I've tried just putting the ip address as
the server, and "Use SQL Server authentication" from the user ID and
Password above, but I get the following error:
"SQL Server registration failed because of the connection failure
below... Cannot open user default database. Login failed"
2. Created a udl file. In the Provider, selected the "Microsoft OLE DB
Provider for SQL Server" Entered teh IP address and username/password
on the Connection Tab. I get the same error as #1 above.
Any insight would be greatly appreciated."Bryce Fischer" <spamtrap@.berzerker-soft.com> wrote in message
news:3btpo01us397pf1gmfl4bt9c8k9dcrv05e@.
4ax.com...
> I have SQL Server 2000 (Developer) on my computer. So I have SQL
> Server Enterprise Manager + Tools (such as Query Analyzer).
> I am doing some work on a remote server, mostly ASP pages (not
> ASP.NET). There is a SQL Server database on that server. I would like
> to use Enterprise Manager or Query Analyzer to access that database.
> My main development environment is Dreamweaver MX2004. In Dreamweaver,
> I was able to setup the database (on the databases tab) using a
> "Custom Connection String", listed below (some info obfuscated for
> security):
> "Provider=SQLOLEDB.1;Persist Security Info=False;Initial
> Catalog=funeral;Data Source=xx.xx.xx.xxx;Locale
> Identifier=1033;Connect Timeout=15;Use Procedure for Prepare=1;Auto
> Translate=True;Packet Size=4096;User Id=XXX;PASSWORD=XXXXXXXX;"
> I don't know if it is possible to use the other tools to manage this
> database. I've tried the following:
> 1. In Enterprise Manager, I've tried just putting the ip address as
> the server, and "Use SQL Server authentication" from the user ID and
> Password above, but I get the following error:
> "SQL Server registration failed because of the connection failure
> below... Cannot open user default database. Login failed"
>
User XXX has a login on the remote server, but does not have a user in the
database he is configured to use. To administer the remote database, User
XXX must be a member of the sysadmin role on the remote server
http://snodland.blogspot.com
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.788 / Virus Database: 533 - Release Date: 01/11/2004|||On Sat, 6 Nov 2004 22:04:54 -0000, "Bob Simms"
<bob_simms@.somewhere.com> wrote:

>User XXX has a login on the remote server, but does not have a user in the
>database he is configured to use. To administer the remote database, User
>XXX must be a member of the sysadmin role on the remote server
Thanks for the reply.
Is it possible to use Query Analyzer or Access to connect to the
server given the information in my original post? I don't need
administrator-like functionality. As I mentioned, in Dreamweaver, I'm
able to create a connection, and view the tables and data (not to be
confused with creating the connection on the ASP pages, but in
Dreamweaver itself.) Dreamweaver lets you browse the tables, and data,
it doesn't let you run SQL Statements, which is why I'd like to use
other tools I have.
TIA.|||On Sat, 06 Nov 2004 20:21:58 -0500, Bryce Fischer
<spamtrap@.berzerker-soft.com> wrote:

>On Sat, 6 Nov 2004 22:04:54 -0000, "Bob Simms"
><bob_simms@.somewhere.com> wrote:
>
>Thanks for the reply.
>Is it possible to use Query Analyzer or Access to connect to the
>server given the information in my original post? I don't need
>administrator-like functionality. As I mentioned, in Dreamweaver, I'm
>able to create a connection, and view the tables and data (not to be
>confused with creating the connection on the ASP pages, but in
>Dreamweaver itself.) Dreamweaver lets you browse the tables, and data,
>it doesn't let you run SQL Statements, which is why I'd like to use
>other tools I have.
Well... After some persistence, I figured it out. In Access, and
Visual Studio, I was able to bring up the Data Link Properties dialog,
and enter the information, and the one step I was not doing, was
entering in the catalog in the "Select the database on the server:"
field.
I was able to accomplish the same thing in Visual Studio, Server
Explorer, Data Connections.

Connecting to remote SQL Server

I have SQL Server 2000 (Developer) on my computer. So I have SQL
Server Enterprise Manager + Tools (such as Query Analyzer).
I am doing some work on a remote server, mostly ASP pages (not
ASP.NET). There is a SQL Server database on that server. I would like
to use Enterprise Manager or Query Analyzer to access that database.
My main development environment is Dreamweaver MX2004. In Dreamweaver,
I was able to setup the database (on the databases tab) using a
"Custom Connection String", listed below (some info obfuscated for
security):
"Provider=SQLOLEDB.1;Persist Security Info=False;Initial
Catalog=funeral;Data Source=xx.xx.xx.xxx;Locale
Identifier=1033;Connect Timeout=15;Use Procedure for Prepare=1;Auto
Translate=True;Packet Size=4096;User Id=XXX;PASSWORD=XXXXXXXX;"
I don't know if it is possible to use the other tools to manage this
database. I've tried the following:
1. In Enterprise Manager, I've tried just putting the ip address as
the server, and "Use SQL Server authentication" from the user ID and
Password above, but I get the following error:
"SQL Server registration failed because of the connection failure
below... Cannot open user default database. Login failed"
2. Created a udl file. In the Provider, selected the "Microsoft OLE DB
Provider for SQL Server" Entered teh IP address and username/password
on the Connection Tab. I get the same error as #1 above.
Any insight would be greatly appreciated."Bryce Fischer" <spamtrap@.berzerker-soft.com> wrote in message
news:3btpo01us397pf1gmfl4bt9c8k9dcrv05e@.4ax.com...
> I have SQL Server 2000 (Developer) on my computer. So I have SQL
> Server Enterprise Manager + Tools (such as Query Analyzer).
> I am doing some work on a remote server, mostly ASP pages (not
> ASP.NET). There is a SQL Server database on that server. I would like
> to use Enterprise Manager or Query Analyzer to access that database.
> My main development environment is Dreamweaver MX2004. In Dreamweaver,
> I was able to setup the database (on the databases tab) using a
> "Custom Connection String", listed below (some info obfuscated for
> security):
> "Provider=SQLOLEDB.1;Persist Security Info=False;Initial
> Catalog=funeral;Data Source=xx.xx.xx.xxx;Locale
> Identifier=1033;Connect Timeout=15;Use Procedure for Prepare=1;Auto
> Translate=True;Packet Size=4096;User Id=XXX;PASSWORD=XXXXXXXX;"
> I don't know if it is possible to use the other tools to manage this
> database. I've tried the following:
> 1. In Enterprise Manager, I've tried just putting the ip address as
> the server, and "Use SQL Server authentication" from the user ID and
> Password above, but I get the following error:
> "SQL Server registration failed because of the connection failure
> below... Cannot open user default database. Login failed"
>
User XXX has a login on the remote server, but does not have a user in the
database he is configured to use. To administer the remote database, User
XXX must be a member of the sysadmin role on the remote server
http://snodland.blogspot.com
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.788 / Virus Database: 533 - Release Date: 01/11/2004|||On Sat, 6 Nov 2004 22:04:54 -0000, "Bob Simms"
<bob_simms@.somewhere.com> wrote:
>> 1. In Enterprise Manager, I've tried just putting the ip address as
>> the server, and "Use SQL Server authentication" from the user ID and
>> Password above, but I get the following error:
>> "SQL Server registration failed because of the connection failure
>> below... Cannot open user default database. Login failed"
>User XXX has a login on the remote server, but does not have a user in the
>database he is configured to use. To administer the remote database, User
>XXX must be a member of the sysadmin role on the remote server
Thanks for the reply.
Is it possible to use Query Analyzer or Access to connect to the
server given the information in my original post? I don't need
administrator-like functionality. As I mentioned, in Dreamweaver, I'm
able to create a connection, and view the tables and data (not to be
confused with creating the connection on the ASP pages, but in
Dreamweaver itself.) Dreamweaver lets you browse the tables, and data,
it doesn't let you run SQL Statements, which is why I'd like to use
other tools I have.
TIA.|||On Sat, 06 Nov 2004 20:21:58 -0500, Bryce Fischer
<spamtrap@.berzerker-soft.com> wrote:
>On Sat, 6 Nov 2004 22:04:54 -0000, "Bob Simms"
><bob_simms@.somewhere.com> wrote:
>> 1. In Enterprise Manager, I've tried just putting the ip address as
>> the server, and "Use SQL Server authentication" from the user ID and
>> Password above, but I get the following error:
>> "SQL Server registration failed because of the connection failure
>> below... Cannot open user default database. Login failed"
>>User XXX has a login on the remote server, but does not have a user in the
>>database he is configured to use. To administer the remote database, User
>>XXX must be a member of the sysadmin role on the remote server
>Thanks for the reply.
>Is it possible to use Query Analyzer or Access to connect to the
>server given the information in my original post? I don't need
>administrator-like functionality. As I mentioned, in Dreamweaver, I'm
>able to create a connection, and view the tables and data (not to be
>confused with creating the connection on the ASP pages, but in
>Dreamweaver itself.) Dreamweaver lets you browse the tables, and data,
>it doesn't let you run SQL Statements, which is why I'd like to use
>other tools I have.
Well... After some persistence, I figured it out. In Access, and
Visual Studio, I was able to bring up the Data Link Properties dialog,
and enter the information, and the one step I was not doing, was
entering in the catalog in the "Select the database on the server:"
field.
I was able to accomplish the same thing in Visual Studio, Server
Explorer, Data Connections.

Connecting to online database using local Enterprise Manager

I have Enterprise Manager on my local machine. For the last twelve
months it has been connecting without problem to my online SQL Server
database provided by my ISP.

Three weeks ago the ISP applied some sort of extra security
arrangements to their SQL Server to allow access only through port
1433. they have told me to configure an alias using Network Client and
to register this alias in the usual way using my Enterprise Manager.

My problem is that despite creating the alias in exactly the way
instructed I just cannot connect to online database. I keep getting
the SQL Server does not exist or access denied when I try to connect.

As a result of advice obtained I have tried using the lite version of
the 'littleADmin' tool available from
http://www.mylittletools.net/scripts/en/mla_sql/

Using this useful looking software I find I cannot connect to the
online SQL database when it is installed on my own local machine but
if I install it on my website it does connect without problem to my
online SQL. Server database

However I need to use my more powerful Enterprise Manager to connect,
my question (at last!) is:

1. Is there likely to be a problem trying to connect to my online
database from Enterprise Manager on my local machine as a result of
the new security arrangements. In other words, is there something
analagous to what is happening with the 'littleAdmin tool' whereby
using Enterprise Manager I cannot connect from my local machine for
some reason obvious to everyone except myself??
or
2. Is it possible that there is some problem arising from Net Client?
(the aliases appear in Enterprise Manager OK)

I know my ISP should be answering this sort of question but they just
don't seem to know. I need to connect even if only to download my
database and take it to another ISP,

Best wishes, John MorganJohn Morgan (jfm@.XXwoodlander.co.uk) writes:
> I have Enterprise Manager on my local machine. For the last twelve
> months it has been connecting without problem to my online SQL Server
> database provided by my ISP.
> Three weeks ago the ISP applied some sort of extra security
> arrangements to their SQL Server to allow access only through port
> 1433. they have told me to configure an alias using Network Client and
> to register this alias in the usual way using my Enterprise Manager.
> My problem is that despite creating the alias in exactly the way
> instructed I just cannot connect to online database. I keep getting
> the SQL Server does not exist or access denied when I try to connect.
>...
> I know my ISP should be answering this sort of question but they just
> don't seem to know. I need to connect even if only to download my
> database and take it to another ISP,

And we don't even know their configuration. Or yours.

Can you connect with the IP address?

In the alias you have set up in Client Network Utility, have you checked
TCP/IP, entered the IP address, and unchecked "Dynamically determine port"
and specified 1433?

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp|||Hi John

Check out the information regarding port 1434 and MSDE.
http://msdn.microsoft.com/library/d...asp?frame=true

John

"John Morgan" <jfm@.XXwoodlander.co.uk> wrote in message
news:uhu3s09t8k7ngckgm5tjvq53bh1h76a3v0@.4ax.com...
>I have Enterprise Manager on my local machine. For the last twelve
> months it has been connecting without problem to my online SQL Server
> database provided by my ISP.
> Three weeks ago the ISP applied some sort of extra security
> arrangements to their SQL Server to allow access only through port
> 1433. they have told me to configure an alias using Network Client and
> to register this alias in the usual way using my Enterprise Manager.
> My problem is that despite creating the alias in exactly the way
> instructed I just cannot connect to online database. I keep getting
> the SQL Server does not exist or access denied when I try to connect.
> As a result of advice obtained I have tried using the lite version of
> the 'littleADmin' tool available from
> http://www.mylittletools.net/scripts/en/mla_sql/
> Using this useful looking software I find I cannot connect to the
> online SQL database when it is installed on my own local machine but
> if I install it on my website it does connect without problem to my
> online SQL. Server database
> However I need to use my more powerful Enterprise Manager to connect,
> my question (at last!) is:
> 1. Is there likely to be a problem trying to connect to my online
> database from Enterprise Manager on my local machine as a result of
> the new security arrangements. In other words, is there something
> analagous to what is happening with the 'littleAdmin tool' whereby
> using Enterprise Manager I cannot connect from my local machine for
> some reason obvious to everyone except myself??
> or
> 2. Is it possible that there is some problem arising from Net Client?
> (the aliases appear in Enterprise Manager OK)
> I know my ISP should be answering this sort of question but they just
> don't seem to know. I need to connect even if only to download my
> database and take it to another ISP,
> Best wishes, John Morgan|||Thank you Erland and JOhn

Re fixed IP address: my ISP tells me that as I do not have a fixed IP
address it means I cannot allow me access based on my IP address.

Yes, I have checked and rechecked that the Client Network Utility is
showing TCP/IP and that the 1433 port is specified.

I have looked at the Microsoft article suggested by John. This appears
to indicate that unless everything on the computer is upgraded then
port 1434 will be used when connecting online.

I have now uninstalled my current version of MSDE and attempted to
install a new default instance using the SP3a disk. this has brought
its own problem in that the apparently successfully installed new
version still reads 'Build 2600 Service Pack 1'

I have asked for advice on this on the MSDE News group but if you had
an insight into this it would be welcome,

Best wishes, John Morgan

On Thu, 16 Dec 2004 22:24:55 -0000, "John Bell"
<jbellnewsposts@.hotmail.com> wrote:

>Hi John
>Check out the information regarding port 1434 and MSDE.
>http://msdn.microsoft.com/library/d...asp?frame=true
>John
>"John Morgan" <jfm@.XXwoodlander.co.uk> wrote in message
>news:uhu3s09t8k7ngckgm5tjvq53bh1h76a3v0@.4ax.com...
>>I have Enterprise Manager on my local machine. For the last twelve
>> months it has been connecting without problem to my online SQL Server
>> database provided by my ISP.
>>
>> Three weeks ago the ISP applied some sort of extra security
>> arrangements to their SQL Server to allow access only through port
>> 1433. they have told me to configure an alias using Network Client and
>> to register this alias in the usual way using my Enterprise Manager.
>>
>> My problem is that despite creating the alias in exactly the way
>> instructed I just cannot connect to online database. I keep getting
>> the SQL Server does not exist or access denied when I try to connect.
>>
>> As a result of advice obtained I have tried using the lite version of
>> the 'littleADmin' tool available from
>> http://www.mylittletools.net/scripts/en/mla_sql/
>>
>> Using this useful looking software I find I cannot connect to the
>> online SQL database when it is installed on my own local machine but
>> if I install it on my website it does connect without problem to my
>> online SQL. Server database
>>
>> However I need to use my more powerful Enterprise Manager to connect,
>> my question (at last!) is:
>>
>> 1. Is there likely to be a problem trying to connect to my online
>> database from Enterprise Manager on my local machine as a result of
>> the new security arrangements. In other words, is there something
>> analagous to what is happening with the 'littleAdmin tool' whereby
>> using Enterprise Manager I cannot connect from my local machine for
>> some reason obvious to everyone except myself??
>> or
>> 2. Is it possible that there is some problem arising from Net Client?
>> (the aliases appear in Enterprise Manager OK)
>>
>> I know my ISP should be answering this sort of question but they just
>> don't seem to know. I need to connect even if only to download my
>> database and take it to another ISP,
>>
>> Best wishes, John Morgan|||Hi

Before 'Build 2600 Service Pack 1' it probably says "on Windows NT 5.1" i.e.
you are on Windows XP service pack 1. What does the first (few) line of
@.@.Version return?

I am not sure if I have already posted
http://support.microsoft.com/defaul...kb;en-us;287932, but what
does netstat -an return?

John

"John Morgan" <jfm@.XXwoodlander.co.uk> wrote in message
news:3hj6s0hcgim5b3u00uan9mfbqpvrk71537@.4ax.com...
> Thank you Erland and JOhn
> Re fixed IP address: my ISP tells me that as I do not have a fixed IP
> address it means I cannot allow me access based on my IP address.
> Yes, I have checked and rechecked that the Client Network Utility is
> showing TCP/IP and that the 1433 port is specified.
> I have looked at the Microsoft article suggested by John. This appears
> to indicate that unless everything on the computer is upgraded then
> port 1434 will be used when connecting online.
> I have now uninstalled my current version of MSDE and attempted to
> install a new default instance using the SP3a disk. this has brought
> its own problem in that the apparently successfully installed new
> version still reads 'Build 2600 Service Pack 1'
> I have asked for advice on this on the MSDE News group but if you had
> an insight into this it would be welcome,
> Best wishes, John Morgan
>
> On Thu, 16 Dec 2004 22:24:55 -0000, "John Bell"
> <jbellnewsposts@.hotmail.com> wrote:
>>Hi John
>>
>>Check out the information regarding port 1434 and MSDE.
>>http://msdn.microsoft.com/library/d...asp?frame=true
>>
>>John
>>
>>"John Morgan" <jfm@.XXwoodlander.co.uk> wrote in message
>>news:uhu3s09t8k7ngckgm5tjvq53bh1h76a3v0@.4ax.com...
>>>I have Enterprise Manager on my local machine. For the last twelve
>>> months it has been connecting without problem to my online SQL Server
>>> database provided by my ISP.
>>>
>>> Three weeks ago the ISP applied some sort of extra security
>>> arrangements to their SQL Server to allow access only through port
>>> 1433. they have told me to configure an alias using Network Client and
>>> to register this alias in the usual way using my Enterprise Manager.
>>>
>>> My problem is that despite creating the alias in exactly the way
>>> instructed I just cannot connect to online database. I keep getting
>>> the SQL Server does not exist or access denied when I try to connect.
>>>
>>> As a result of advice obtained I have tried using the lite version of
>>> the 'littleADmin' tool available from
>>> http://www.mylittletools.net/scripts/en/mla_sql/
>>>
>>> Using this useful looking software I find I cannot connect to the
>>> online SQL database when it is installed on my own local machine but
>>> if I install it on my website it does connect without problem to my
>>> online SQL. Server database
>>>
>>> However I need to use my more powerful Enterprise Manager to connect,
>>> my question (at last!) is:
>>>
>>> 1. Is there likely to be a problem trying to connect to my online
>>> database from Enterprise Manager on my local machine as a result of
>>> the new security arrangements. In other words, is there something
>>> analagous to what is happening with the 'littleAdmin tool' whereby
>>> using Enterprise Manager I cannot connect from my local machine for
>>> some reason obvious to everyone except myself??
>>> or
>>> 2. Is it possible that there is some problem arising from Net Client?
>>> (the aliases appear in Enterprise Manager OK)
>>>
>>> I know my ISP should be answering this sort of question but they just
>>> don't seem to know. I need to connect even if only to download my
>>> database and take it to another ISP,
>>>
>>> Best wishes, John Morgan
>sqlsql

Connecting to Network Server

Hi All,
I have 2 computers, one has SQL2000 and the other has MSDE2000. I have the
SQL tools installed on both computers.
When I use the enterprise manager and try to connect remote server I cannot
get the user to authenticate. It is trying to access the remote server
using the guest account.
There is no domain. Both computer have mixed mode authentication, and are
on the same 192.168.1.x network range.
What am I missing here.
Thanks
Lee
hi Lee,
"Lee Trotter" <latrotter@.@.@.sympatico.ca> ha scritto nel messaggio
news:%23lstCrAaEHA.3112@.tk2msftngp13.phx.gbl...
> Hi All,
> I have 2 computers, one has SQL2000 and the other has MSDE2000. I have
the
> SQL tools installed on both computers.
> When I use the enterprise manager and try to connect remote server I
cannot
> get the user to authenticate. It is trying to access the remote server
> using the guest account.
> There is no domain. Both computer have mixed mode authentication, and are
> on the same 192.168.1.x network range.
I did not undertand if you, from both machines, can not connect remotely or
you can not remotely connect just to the MSDE instance...
if this is the case, MSDE installs by default disabling network protocols,
in order to prevent external malicius attacks, so that only local connection
using Shared Memory are allowed..
you can modify this behaviour bot at install time, specifying the
DISABLENETWORKPROTOCOLS=0 parameter to the setup.exe boostrat MSDE
installer, and later, using Server Network Utility (svrnetcn.exe), enabling
the desired network protocol(s)..
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.8.0 - DbaMgr ver 0.54.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply

Connecting to named instance fails for Enterprise Manager but works with Query Analyzer

Hi,
We have just had a 64-bit SQL Server 2000 cluster installed in our
network and I am having difficulties connecting to it.
The named instance I am trying to access is 192.168.0.108\DX
I can connect to it from a machine on the same subnet using Enterprise
Manager, but not from a machine on another subnet (192.168.14.0), when
attempiting EM just stops responding. The weird thing is that I can
connect using Query Analyzer, but not EM (obviously using the same
connection details).
Does anybody have any suggestions to what might be causing this
behaviour?
The client computer I use is a Windows XP Professional with SP2 and
client connectivity tools for SQL Server 2000. I have tried disabling
the firewall, which didn't help. I can connect to another SQL Server
(default instance, 32-bit, non-clustered) on the other network with
EM.
Regards,
Ville Tuomola
Have you tried pinging the server when you can't connect?
Have you checked the registration/connection properties for
the server in Enterprise Manager? Are you sure you aren't
just getting a login timeout? You can increase the login
timeout from the menu go to Tools then Options. On the
Advanced tab, increase the login timeout to a value higher
than the default 4 seconds.
-Sue
On 7 Oct 2004 01:11:35 -0700, vtuomola@.gmail.com (Ville
Tuomola) wrote:

>Hi,
>We have just had a 64-bit SQL Server 2000 cluster installed in our
>network and I am having difficulties connecting to it.
>The named instance I am trying to access is 192.168.0.108\DX
>I can connect to it from a machine on the same subnet using Enterprise
>Manager, but not from a machine on another subnet (192.168.14.0), when
>attempiting EM just stops responding. The weird thing is that I can
>connect using Query Analyzer, but not EM (obviously using the same
>connection details).
>Does anybody have any suggestions to what might be causing this
>behaviour?
>The client computer I use is a Windows XP Professional with SP2 and
>client connectivity tools for SQL Server 2000. I have tried disabling
>the firewall, which didn't help. I can connect to another SQL Server
>(default instance, 32-bit, non-clustered) on the other network with
>EM.
>Regards,
>Ville Tuomola

Connecting to another SQL Server

I think I have done my homework and research on this. I'm in a company
Intranet and through Enterprise Manager, I have added the server I want to
access (FES89TXNCEV501) in my server group. I can access the that server and
open a view on that server (read only).
I want to write a query (see below) on another server (MY Server) and access
FES89TXNCEV501 to pull data to insert into My Server. I get an error telling
me the server doesn't exist or access denied. I tried;
EXEC sp_addlinkedserver
'FES89TXNCEV501',
N'SQL Server'
And my query is
SELECT TOP 1000 dbo.vwNiceEvaluationHeaders.dtDateCreated AS DateCreated
,
dbo.vwNiceUserInfo.vcLoginName AS Assoc_CorpID,
dbo.vwNiceUserInfo.vcLastName + ' ' + dbo.
vwNiceUserInfo.vcFirstName AS Associate, dbo.vwNiceEvaluationHeaders.fltScor
e
AS Score,
vwNiceUserInfo_1.vcLastName AS Evaluator,
vwNiceUserInfo_1.vcLoginName AS Eval_CorpID,
dbo.vwNiceFormDefinitionHeaders.vcFormName AS FormName
FROM OPENDATASOURCE ('SQLOLEDB',
'Data Source=FES89TXNCEV501;User
ID=bubba;Password=whatever;' ).Nice_Cls.dbo.vwNiceFormDefinitionHeaders
Rowset_1 INNER JOIN
dbo.vwNiceEvaluationHeaders ON dbo.
vwNiceFormDefinitionHeaders.iFormID = dbo.vwNiceEvaluationHeaders.iFormID
INNER JOIN
dbo.vwNiceUserInfo ON dbo.vwNiceEvaluationHeaders.
iAgentUserID = dbo.vwNiceUserInfo.iUserID INNER JOIN
dbo.vwNiceUserInfo vwNiceUserInfo_1 ON dbo.
vwNiceEvaluationHeaders.iEvaluatorUserID = vwNiceUserInfo_1.iUserID
WHERE (dbo.vwNiceEvaluationHeaders.dtDateCreated >= CONVERT(DATETIME,
'2006-08-07 00:00:00', 102))
GROUP BY dbo.vwNiceUserInfo.vcLoginName, dbo.vwNiceEvaluationHeaders.fltScor
e,
dbo.vwNiceUserInfo.vcLastName + ' ' + dbo.vwNiceUserInfo.vcFirstName,
dbo.vwNiceEvaluationHeaders.dtDateCreated,
vwNiceUserInfo_1.vcLastName, vwNiceUserInfo_1.vcLoginName,
dbo.vwNiceFormDefinitionHeaders.vcFormName
ANy help is greatly appreciated!!!
Message posted via droptable.com
http://www.droptable.com/Uwe/Forum...tivity/200608/1I'm not sure if it is causing your problem, but I don't think that you use
OPENDATASOURCE on a linked server .
You might try removing the linked server (using sp_dropserver), and be sure
that that is not 'gumming' up the works.
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
"Chamark via droptable.com" <u21870@.uwe> wrote in message
news:646ddd01cfdb8@.uwe...
>I think I have done my homework and research on this. I'm in a company
> Intranet and through Enterprise Manager, I have added the server I want to
> access (FES89TXNCEV501) in my server group. I can access the that server
> and
> open a view on that server (read only).
> I want to write a query (see below) on another server (MY Server) and
> access
> FES89TXNCEV501 to pull data to insert into My Server. I get an error
> telling
> me the server doesn't exist or access denied. I tried;
> EXEC sp_addlinkedserver
> 'FES89TXNCEV501',
> N'SQL Server'
> And my query is
>
> SELECT TOP 1000 dbo.vwNiceEvaluationHeaders.dtDateCreated AS
> DateCreated,
> dbo.vwNiceUserInfo.vcLoginName AS Assoc_CorpID,
> dbo.vwNiceUserInfo.vcLastName + ' ' + dbo.
> vwNiceUserInfo.vcFirstName AS Associate,
> dbo.vwNiceEvaluationHeaders.fltScore
> AS Score,
> vwNiceUserInfo_1.vcLastName AS Evaluator,
> vwNiceUserInfo_1.vcLoginName AS Eval_CorpID,
> dbo.vwNiceFormDefinitionHeaders.vcFormName AS
> FormName
> FROM OPENDATASOURCE ('SQLOLEDB',
> 'Data Source=FES89TXNCEV501;User
> ID=bubba;Password=whatever;' ).Nice_Cls.dbo.vwNiceFormDefinitionHeaders
> Rowset_1 INNER JOIN
> dbo.vwNiceEvaluationHeaders ON dbo.
> vwNiceFormDefinitionHeaders.iFormID = dbo.vwNiceEvaluationHeaders.iFormID
> INNER JOIN
> dbo.vwNiceUserInfo ON dbo.vwNiceEvaluationHeaders.
> iAgentUserID = dbo.vwNiceUserInfo.iUserID INNER JOIN
> dbo.vwNiceUserInfo vwNiceUserInfo_1 ON dbo.
> vwNiceEvaluationHeaders.iEvaluatorUserID = vwNiceUserInfo_1.iUserID
> WHERE (dbo.vwNiceEvaluationHeaders.dtDateCreated >= CONVERT(DATETIME,
> '2006-08-07 00:00:00', 102))
> GROUP BY dbo.vwNiceUserInfo.vcLoginName,
> dbo.vwNiceEvaluationHeaders.fltScore,
> dbo.vwNiceUserInfo.vcLastName + ' ' + dbo.vwNiceUserInfo.vcFirstName,
> dbo.vwNiceEvaluationHeaders.dtDateCreated,
> vwNiceUserInfo_1.vcLastName, vwNiceUserInfo_1.vcLoginName,
> dbo.vwNiceFormDefinitionHeaders.vcFormName
> ANy help is greatly appreciated!!!
> --
> Message posted via droptable.com
> http://www.droptable.com/Uwe/Forum...tivity/200608/1
>|||Having a linked server and using Opendatasource seems a bit
contradictory. Opendatasource is used for ad hoc access when
you aren't going to use linked servers - just need a one
time connect type of thing. However, just having the linked
server defined shouldn't cause a problem as the API just
uses the connection info you provide in the Opendatasource
command and doesn't really have any knowledge of what linked
servers you have.
If you are sure you want to use Opendatasource, Have you
tried just a simple one table select using Opendatasource as
a test?
-Sue
On Mon, 07 Aug 2006 20:54:04 GMT, "Chamark via
droptable.com" <u21870@.uwe> wrote:

>I think I have done my homework and research on this. I'm in a company
>Intranet and through Enterprise Manager, I have added the server I want to
>access (FES89TXNCEV501) in my server group. I can access the that server an
d
>open a view on that server (read only).
>I want to write a query (see below) on another server (MY Server) and acces
s
>FES89TXNCEV501 to pull data to insert into My Server. I get an error tellin
g
>me the server doesn't exist or access denied. I tried;
>EXEC sp_addlinkedserver
> 'FES89TXNCEV501',
> N'SQL Server'
>And my query is
>
>SELECT TOP 1000 dbo.vwNiceEvaluationHeaders.dtDateCreated AS DateCreate
d,
>dbo.vwNiceUserInfo.vcLoginName AS Assoc_CorpID,
> dbo.vwNiceUserInfo.vcLastName + ' ' + dbo.
>vwNiceUserInfo.vcFirstName AS Associate, dbo.vwNiceEvaluationHeaders.fltSco
re
>AS Score,
> vwNiceUserInfo_1.vcLastName AS Evaluator,
>vwNiceUserInfo_1.vcLoginName AS Eval_CorpID,
> dbo.vwNiceFormDefinitionHeaders.vcFormName AS FormNam
e
>FROM OPENDATASOURCE ('SQLOLEDB',
> 'Data Source=FES89TXNCEV501;User
>ID=bubba;Password=whatever;' ).Nice_Cls.dbo.vwNiceFormDefinitionHeaders
>Rowset_1 INNER JOIN
> dbo.vwNiceEvaluationHeaders ON dbo.
>vwNiceFormDefinitionHeaders.iFormID = dbo.vwNiceEvaluationHeaders.iFormID
>INNER JOIN
> dbo.vwNiceUserInfo ON dbo.vwNiceEvaluationHeaders.
>iAgentUserID = dbo.vwNiceUserInfo.iUserID INNER JOIN
> dbo.vwNiceUserInfo vwNiceUserInfo_1 ON dbo.
>vwNiceEvaluationHeaders.iEvaluatorUserID = vwNiceUserInfo_1.iUserID
>WHERE (dbo.vwNiceEvaluationHeaders.dtDateCreated >= CONVERT(DATETIME,
>'2006-08-07 00:00:00', 102))
>GROUP BY dbo.vwNiceUserInfo.vcLoginName, dbo.vwNiceEvaluationHeaders.fltSco
re,
>dbo.vwNiceUserInfo.vcLastName + ' ' + dbo.vwNiceUserInfo.vcFirstName,
> dbo.vwNiceEvaluationHeaders.dtDateCreated,
>vwNiceUserInfo_1.vcLastName, vwNiceUserInfo_1.vcLoginName,
> dbo.vwNiceFormDefinitionHeaders.vcFormName
>ANy help is greatly appreciated!!!|||If you have a linked server the from for the select is ...
FROM LinkedServerName..TableName
"Sue Hoegemeier" wrote:

> Having a linked server and using Opendatasource seems a bit
> contradictory. Opendatasource is used for ad hoc access when
> you aren't going to use linked servers - just need a one
> time connect type of thing. However, just having the linked
> server defined shouldn't cause a problem as the API just
> uses the connection info you provide in the Opendatasource
> command and doesn't really have any knowledge of what linked
> servers you have.
> If you are sure you want to use Opendatasource, Have you
> tried just a simple one table select using Opendatasource as
> a test?
> -Sue
> On Mon, 07 Aug 2006 20:54:04 GMT, "Chamark via
> droptable.com" <u21870@.uwe> wrote:
>
>|||Oops.. one more dot
FROM LinkedServerName...TableName
"Chris" wrote:
[vbcol=seagreen]
> If you have a linked server the from for the select is ...
> FROM LinkedServerName..TableName
> "Sue Hoegemeier" wrote:
>

Connecting to a second instance of SQL

When I try to connect to an external SQL Server via enterprise manager I
cannot seem to connect to a named instance. In the past this has worked with
no problem when I do ip\instance. However when I now try I am getting invali
d
instance name. The name I am using is correct. I am connecting from
Enterprise manager to a SQL2000 instance. Any ideas why it doesn`t connect ?
SiPlease paste in the exact error message
Kevin Hill
3NF Consulting
http://www.3nf-inc.com/NewsGroups.htm
http://kevin3nf.blogspot.com
"Simon" <Simon@.discussions.microsoft.com> wrote in message
news:356739A9-573E-4D7D-AF9B-2B0DA95CEE2E@.microsoft.com...
> When I try to connect to an external SQL Server via enterprise manager I
> cannot seem to connect to a named instance. In the past this has worked
> with
> no problem when I do ip\instance. However when I now try I am getting
> invalid
> instance name. The name I am using is correct. I am connecting from
> Enterprise manager to a SQL2000 instance. Any ideas why it doesn`t connect
> ?
>
> Si|||Invalid connection.Connectioopen (Invalid Instance())
Cheers
"Kevin3NF" wrote:

> Please paste in the exact error message
>
> --
> Kevin Hill
> 3NF Consulting
> http://www.3nf-inc.com/NewsGroups.htm
> http://kevin3nf.blogspot.com
>
> "Simon" <Simon@.discussions.microsoft.com> wrote in message
> news:356739A9-573E-4D7D-AF9B-2B0DA95CEE2E@.microsoft.com...
>
>|||Does the Instance Name contain any invalid character, such as '-'?
Try enclosing the instance name in square brackets, e.g.,
[MyServer\MyInstance].
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
"Simon" <Simon@.discussions.microsoft.com> wrote in message
news:A5D1AFBD-54F6-4600-A7EA-215AEFD7A1C6@.microsoft.com...[vbcol=seagreen]
> Invalid connection.Connectioopen (Invalid Instance())
> Cheers
> "Kevin3NF" wrote:
>|||There are no invalid characters. Even so I tried enclosing in square bracket
s
and still no joy.
Its a puzzle !
Si
"Arnie Rowland" wrote:

> Does the Instance Name contain any invalid character, such as '-'?
> Try enclosing the instance name in square brackets, e.g.,
> [MyServer\MyInstance].
> --
> Arnie Rowland, Ph.D.
> Westwood Consulting, Inc
> Most good judgment comes from experience.
> Most experience comes from bad judgment.
> - Anonymous
> You can't help someone get up a hill without getting a little closer to th
e
> top yourself.
> - H. Norman Schwarzkopf
>
> "Simon" <Simon@.discussions.microsoft.com> wrote in message
> news:A5D1AFBD-54F6-4600-A7EA-215AEFD7A1C6@.microsoft.com...
>
>|||Is UDP 1434 open between the SQL Server you are registering
on and the named instance you are trying to register? That
could be what's causing your problems.
You could try an alias and see if that works -
On the SQL Server box where you are trying to register the
named instance, use the Client Network Utility to create an
alias to the named instance and specify the port number
(check the listening port on the named instance).
In that scenario with the alias, you are specifying the port
so you would bypass the SQL Server Resolution Service and
going through UDP 1434.
-Sue
On Mon, 30 Oct 2006 01:20:02 -0800, Simon
<Simon@.discussions.microsoft.com> wrote:
[vbcol=seagreen]
>There are no invalid characters. Even so I tried enclosing in square bracke
ts
>and still no joy.
>Its a puzzle !
>Si
>"Arnie Rowland" wrote:
>

Connecting to a remote SQL Server the enterprise manager

I would like to connect to my Remote SQL Server using Enterprise manger. However I cannot find a way of doing it. I have tried to registering a new server using the register server wizard but I cannot get it to work does anyone have any suggestions?You should just have to enter the server name/IP address in the "New Sql Server Registration" wizard, select Windows authentications or Sql Server Authentication. Probably you would be use Sql Server Authentication and so you would enter the username and password. Click OK and it should connect.

Presumably you've already done this and it doesn't work.

It could be that a firewall on the server side is preventing the connection. In this case you have to talk with the people who control the firewall.

It could also be that the remote Sql server is using a different port number than usual and Enterprise Manager couldn't dynamically detect it. In that case you'd need to find the port number and use the Sql Client Network utility to create an Alias to refer to the remote server and to specify the port number to communicate with. On your machine go to:

Start->Programs->Microsoft Sql Server->Client Network Utility
Click the "Alias" tab
Click "Add"
Enter a Server alias (probably the machine name of the remote server)
Click "TCP/IP" radio button on the left side (most likely way to connect)
Enter server name (probably an IP address)
Uncheck "Dynamically determine port" and enter the port number.
Click OK

Go back into Enterprise Manager and re-start "New Sql Server Registration".
Next to the server box click the"..." button. You should see the server alias you created there.
Select the server alias and proceed with the rest of the setup.|||McMurdoStation

Thanks for the reply.
One thing that is reassuring is that this is how I have been trying to connect. However I have had no success. The remote server i am using runs on Win2003 with iis6. I have set up a username on the server with osql and given the user the correct privalages. however when I try to connect I keep getting the message. the server does not exist or access is denied. Is there anything else I can try?|||It's probably a firewall issue. Can you ping the server?

I've had similar problems in the past connecting to remote Sql Servers. Someone on the other end does some sort of magic and then I can connect. But I'm not a firewall person so I don't know what it is that they did.

Connecting to a MSDE server in Internet

Hi !!
I would like to connect to a SQL Server (MSDE edition) that's in Internet,
using Enterprise Manager either Query Analizer. For these I've configured
the client tool as:
Server Alias: INET_SERVER
Net: TCP/IP
Connection parameters:
Server name: [DNS_NAME]\[REMOTE_SERVER_NAME]\[INSTANCE_NAME]
Port number: 1433
Althought I've tried to configure the server name in different ways, I
haven't found the successful way to do it.
I don't think it's a firewall problem. In theory I've successfull disabled.
Thanks !!
Josep.You can check to see if it's a firewall or port blocking issue or not by
using TELNET and seeing if it can connect. Type this from a command
prompt (replace INET_SERVER with your server name).
telnet INET_SERVER 1433
If the telnet session fails to connect, you have a firewall issue or are
not using the correct port or host name - when I try to connect to
something that is blocked by a firewall, the error reported for me was
"could not open connection to the host on port xxxx: Connect failed".
If you get a screen that appears to be the start of the connected
session, you can be sure you have actually opened a port to another
machine. You won't be able to do anything meaningful from this telnet
session, but it rules out firewall, port, or hostname issues. Close it
and use the same settings to connect with Query Analyzer or Enterprise
Manager.
Good luck,
Tony Sebion
"Josep" <hola@.microsoft.com> wrote in message
news:#1fFelMxFHA.700@.TK2MSFTNGP11.phx.gbl:

> Hi !!
> I would like to connect to a SQL Server (MSDE edition) that's in Internet,
> using Enterprise Manager either Query Analizer. For these I've configured
> the client tool as:
> Server Alias: INET_SERVER
> Net: TCP/IP
> Connection parameters:
> Server name: [DNS_NAME]\[REMOTE_SERVER_NAME]\[INSTANCE_NAME]
> Port number: 1433
> Althought I've tried to configure the server name in different ways, I
> haven't found the successful way to do it.
> I don't think it's a firewall problem. In theory I've successfull disabled
.
>
> Thanks !!
> Josep.|||Well, it seems I didn't unblock the port successfully. So, my work is to
find how this router works... where else I've to configure the ports... but
I like to know that's not an SQL Server problem :-)
Thank you Tony for explaining me this very fast way, and easy, to know if a
port is blocked or not :D
Josep.
"Tony Sebion" <tony@.sebion.com> escribi en el mensaje
news:3q2bkiFcpoaaU1@.individual.net...
> You can check to see if it's a firewall or port blocking issue or not by
> using TELNET and seeing if it can connect. Type this from a command
> prompt (replace INET_SERVER with your server name).
> telnet INET_SERVER 1433
> If the telnet session fails to connect, you have a firewall issue or are
> not using the correct port or host name - when I try to connect to
> something that is blocked by a firewall, the error reported for me was
> "could not open connection to the host on port xxxx: Connect failed".
> If you get a screen that appears to be the start of the connected session,
> you can be sure you have actually opened a port to another machine. You
> won't be able to do anything meaningful from this telnet session, but it
> rules out firewall, port, or hostname issues. Close it and use the same
> settings to connect with Query Analyzer or Enterprise Manager.
> Good luck,
> Tony Sebion
> "Josep" <hola@.microsoft.com> wrote in message
> news:#1fFelMxFHA.700@.TK2MSFTNGP11.phx.gbl:
>
>|||Josep,
did you can do it? I have the same problem here. I think is not due to
firewall, all those ports are opened. (1433TCP; 1434UDP!)
Thank you,
Leo-
"Josep" <hola@.microsoft.com> escribi en el mensaje
news:%231$1wmaxFHA.4032@.TK2MSFTNGP15.phx.gbl...
> Well, it seems I didn't unblock the port successfully. So, my work is to
> find how this router works... where else I've to configure the ports...
> but I like to know that's not an SQL Server problem :-)
> Thank you Tony for explaining me this very fast way, and easy, to know if
> a port is blocked or not :D
> Josep.
>
> "Tony Sebion" <tony@.sebion.com> escribi en el mensaje
> news:3q2bkiFcpoaaU1@.individual.net...
>

Connecting to a MSDE server in Internet

Hi !!
I would like to connect to a SQL Server (MSDE edition) that's in Internet,
using Enterprise Manager either Query Analizer. For these I've configured
the client tool as:
Server Alias: INET_SERVER
Net: TCP/IP
Connection parameters:
Server name: [DNS_NAME]\[REMOTE_SERVER_NAME]\[INSTANCE_NAME]
Port number: 1433
Althought I've tried to configure the server name in different ways, I
haven't found the successful way to do it.
I don't think it's a firewall problem. In theory I've successfull disabled.
Thanks !!
Josep.
You can check to see if it's a firewall or port blocking issue or not by
using TELNET and seeing if it can connect. Type this from a command
prompt (replace INET_SERVER with your server name).
telnet INET_SERVER 1433
If the telnet session fails to connect, you have a firewall issue or are
not using the correct port or host name - when I try to connect to
something that is blocked by a firewall, the error reported for me was
"could not open connection to the host on port xxxx: Connect failed".
If you get a screen that appears to be the start of the connected
session, you can be sure you have actually opened a port to another
machine. You won't be able to do anything meaningful from this telnet
session, but it rules out firewall, port, or hostname issues. Close it
and use the same settings to connect with Query Analyzer or Enterprise
Manager.
Good luck,
Tony Sebion
"Josep" <hola@.microsoft.com> wrote in message
news:#1fFelMxFHA.700@.TK2MSFTNGP11.phx.gbl:

> Hi !!
> I would like to connect to a SQL Server (MSDE edition) that's in Internet,
> using Enterprise Manager either Query Analizer. For these I've configured
> the client tool as:
> Server Alias: INET_SERVER
> Net: TCP/IP
> Connection parameters:
> Server name: [DNS_NAME]\[REMOTE_SERVER_NAME]\[INSTANCE_NAME]
> Port number: 1433
> Althought I've tried to configure the server name in different ways, I
> haven't found the successful way to do it.
> I don't think it's a firewall problem. In theory I've successfull disabled.
>
> Thanks !!
> Josep.
|||Well, it seems I didn't unblock the port successfully. So, my work is to
find how this router works... where else I've to configure the ports... but
I like to know that's not an SQL Server problem :-)
Thank you Tony for explaining me this very fast way, and easy, to know if a
port is blocked or not :D
Josep.
"Tony Sebion" <tony@.sebion.com> escribi en el mensaje
news:3q2bkiFcpoaaU1@.individual.net...
> You can check to see if it's a firewall or port blocking issue or not by
> using TELNET and seeing if it can connect. Type this from a command
> prompt (replace INET_SERVER with your server name).
> telnet INET_SERVER 1433
> If the telnet session fails to connect, you have a firewall issue or are
> not using the correct port or host name - when I try to connect to
> something that is blocked by a firewall, the error reported for me was
> "could not open connection to the host on port xxxx: Connect failed".
> If you get a screen that appears to be the start of the connected session,
> you can be sure you have actually opened a port to another machine. You
> won't be able to do anything meaningful from this telnet session, but it
> rules out firewall, port, or hostname issues. Close it and use the same
> settings to connect with Query Analyzer or Enterprise Manager.
> Good luck,
> Tony Sebion
> "Josep" <hola@.microsoft.com> wrote in message
> news:#1fFelMxFHA.700@.TK2MSFTNGP11.phx.gbl:
>
|||Josep,
did you can do it? I have the same problem here. I think is not due to
firewall, all those ports are opened. (1433TCP; 1434UDP!)
Thank you,
Leo-
"Josep" <hola@.microsoft.com> escribi en el mensaje
news:%231$1wmaxFHA.4032@.TK2MSFTNGP15.phx.gbl...
> Well, it seems I didn't unblock the port successfully. So, my work is to
> find how this router works... where else I've to configure the ports...
> but I like to know that's not an SQL Server problem :-)
> Thank you Tony for explaining me this very fast way, and easy, to know if
> a port is blocked or not :D
> Josep.
>
> "Tony Sebion" <tony@.sebion.com> escribi en el mensaje
> news:3q2bkiFcpoaaU1@.individual.net...
>

Connecting to a 2005 database using 2000 EM

What are the steps to be able to add a 2005 server to a server group in the
2000 enterprise manager?
Thanks for any help,
Bob
You can't do that. You can, however, add a SQL 2000 database to SQL Server
Management Studio (the SQL 2005 replacement for EM.)
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
"Robert Dufour" <bdufour@.sgiims.com> wrote in message
news:%23grWQilGHHA.1912@.TK2MSFTNGP03.phx.gbl...
> What are the steps to be able to add a 2005 server to a server group in
> the 2000 enterprise manager?
> Thanks for any help,
> Bob
>

Connecting through Enterprise Manager

Hi
I am running Win2k Server on an XP machine. I have two
databases which I can run programs on with no problem. I
can connect and run queries through Query Analyzer with
no problem, but when i open Enterprise Manager to access
the Databases, the DB service stops and then I get the
message "The Connection to SQL Server has been broken.
The connection to the SQL Server is broken. Do you want
to try reconnecting to it?" I answer yes, and the prompt
for reconnecting keeps coming up. I can't access any of
my DB's through Enterprise manager. When I try to attach
a DB through the All Tasks option I get "Error 22528 [SQL-
DMO]This server connection has been unexpectedly broken
and cannot be reconnected."
Any ideas on what I need to do to rectify this problem?
Thanks
Dave LugoCheck your SQL errorlog to see if you have any stack dumps.
Cindy Gross, MCDBA, MCSE
http://cindygross.tripod.com
This posting is provided "AS IS" with no warranties, and confers no rights.

Connecting through Enterprise Manager

Hi
I am running Win2k Server on an XP machine. I have two
databases which I can run programs on with no problem. I
can connect and run queries through Query Analyzer with
no problem, but when i open Enterprise Manager to access
the Databases, the DB service stops and then I get the
message "The Connection to SQL Server has been broken.
The connection to the SQL Server is broken. Do you want
to try reconnecting to it?" I answer yes, and the prompt
for reconnecting keeps coming up. I can't access any of
my DB's through Enterprise manager. When I try to attach
a DB through the All Tasks option I get "Error 22528 [SQL-
DMO]This server connection has been unexpectedly broken
and cannot be reconnected."
Any ideas on what I need to do to rectify this problem?
Thanks
Dave Lugo
Check your SQL errorlog to see if you have any stack dumps.
Cindy Gross, MCDBA, MCSE
http://cindygross.tripod.com
This posting is provided "AS IS" with no warranties, and confers no rights.

Connecting Surface Area Configuration to server on Clustered Server

I've run into a problem after upgrading production servers running under Microsoft Cluster Server, Windows Enterprise Server 2003 SP1, and SQL Server 2005 SP1 Enterprise Edition.

Once I completed the upgrade and applied the patch, I needed to examine the values set in the Features component of the Surface Area Configuration tool. The tool attempts to connect to localhost\instancename, but reports the following error:

An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error:26 - Error Locating Server/Instance Specified)(Microsoft SQL Server)

I'm logged into the virtual server via Remote Desktop, but the SAC tool thinks I'm logged into the physical server supporting the virtual server. I seem to be caught between a rock and a hard place here, as I can't enable remote connections without first gaining access on the server itself.

Any help will be greatly appreciated.

Can anyone give me a little help here - I can't make configuration changes on production servers.

Thanks.

|||

Well, after a lucky break I found the answer.

sp_configure 'remote admin connections', 1
go
reconfigure
go

Once this was executed on the server I was able to go into Surface Area Configuration, enter the virtual server name, and connect successfully and make the other changes necessary. A simple solution to a scary problem. (Even though I'd used sp_configure for years on both Sybase and MSSQL servers it's easy to forget about the simple solutions.)

Connecting Surface Area Configuration to server on Clustered Server

I've run into a problem after upgrading production servers running under Microsoft Cluster Server, Windows Enterprise Server 2003 SP1, and SQL Server 2005 SP1 Enterprise Edition.

Once I completed the upgrade and applied the patch, I needed to examine the values set in the Features component of the Surface Area Configuration tool. The tool attempts to connect to localhost\instancename, but reports the following error:

An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error:26 - Error Locating Server/Instance Specified)(Microsoft SQL Server)

I'm logged into the virtual server via Remote Desktop, but the SAC tool thinks I'm logged into the physical server supporting the virtual server. I seem to be caught between a rock and a hard place here, as I can't enable remote connections without first gaining access on the server itself.

Any help will be greatly appreciated.

Can anyone give me a little help here - I can't make configuration changes on production servers.

Thanks.

|||

Well, after a lucky break I found the answer.

sp_configure 'remote admin connections', 1
go
reconfigure
go

Once this was executed on the server I was able to go into Surface Area Configuration, enter the virtual server name, and connect successfully and make the other changes necessary. A simple solution to a scary problem. (Even though I'd used sp_configure for years on both Sybase and MSSQL servers it's easy to forget about the simple solutions.)

|||thx a lot