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 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 Oracle DB using SSIS

Can anybody point me how to connect to an Oracle DB using SSIS? I use the ole DB Connection Manager and pick the Microsoft OLE DB Provider for Oracle but it doesn't seem to work. Any suggestions are greatly apprecaited.

Thanks.

Sam.

Why doesn't it "seem to work"? What errors are you getting? What isn't happening? What IS happening?

Have you got Oracle client installed? Have you configured OLE DB Driver with the name of the TNS entry?

-Jamie

|||

This is the error msg I get.

Test Connection failed because of an error in initializing provider. ORA-12514: TNS listener does not currently know of service requested in connect descriptor.

I have Oracle client installed.

How do I configure OLE DB Driver with the name of the TNS entry? I am new to Oracle...so please bear with me..

Thanks a lot..

|||

First of all you need to verify that you can connect to oracle using the configured driver before you try to do it in SSIS.

There is a file on your client called tnsnames.ora. That file should contain what is called a TNS entry that contains all teh connection details for your Oracle server. Your Oracle DBA will give you the TNS entry.

Verify that you can connect and then connect the name of the TNS entry (it usually ends in ".world") into the OLE DB Driver config UI.

-Jamie

|||

Hi Jamie,

Thanks for a quick reply. I have an entry in the tnsnames.ora file for the connection details. So I checked to see if I can connect with the host string in the tnsnames.ora along with the user name/password. To do that I used Oracle SQL* PLUS. I am able to connect.

I couldn't understand the second step...

"then connect the name of the TNS entry (it usually ends in ".world") into the OLE DB Driver config UI." Can you please explain in more detail?

Thanks a lot...I really appreciate your help.

|||

When you build the SSIS Connection Manager using the microsoft OLE DB Provider for Oracle you will see a box labelled Server Name. Copy the name of the tns entry into that box.

-Jamie

|||

I got it Jamie. I was having two locations for tnsnames.ora and that was the reason for the error...

I appreciate your help.

Thanks.

|||

Hi Jamie,

I have the same problem now in production environment. I have to connect to oracle db from production too and I downloaded the client tools on my 64 bit windows server 2003. I edited the tnsnames to have an entry. When I try to connect to oracle, it gives me an error saying client and networking tools not installed, but I did install them. Can you please help me?

Thanks.

Sam.

Connecting to Oracle DB using SSIS

Can anybody point me how to connect to an Oracle DB using SSIS? I use the ole DB Connection Manager and pick the Microsoft OLE DB Provider for Oracle but it doesn't seem to work. Any suggestions are greatly apprecaited.

Thanks.

Sam.

Why doesn't it "seem to work"? What errors are you getting? What isn't happening? What IS happening?

Have you got Oracle client installed? Have you configured OLE DB Driver with the name of the TNS entry?

-Jamie

|||

This is the error msg I get.

Test Connection failed because of an error in initializing provider. ORA-12514: TNS listener does not currently know of service requested in connect descriptor.

I have Oracle client installed.

How do I configure OLE DB Driver with the name of the TNS entry? I am new to Oracle...so please bear with me..

Thanks a lot..

|||

First of all you need to verify that you can connect to oracle using the configured driver before you try to do it in SSIS.

There is a file on your client called tnsnames.ora. That file should contain what is called a TNS entry that contains all teh connection details for your Oracle server. Your Oracle DBA will give you the TNS entry.

Verify that you can connect and then connect the name of the TNS entry (it usually ends in ".world") into the OLE DB Driver config UI.

-Jamie

|||

Hi Jamie,

Thanks for a quick reply. I have an entry in the tnsnames.ora file for the connection details. So I checked to see if I can connect with the host string in the tnsnames.ora along with the user name/password. To do that I used Oracle SQL* PLUS. I am able to connect.

I couldn't understand the second step...

"then connect the name of the TNS entry (it usually ends in ".world") into the OLE DB Driver config UI." Can you please explain in more detail?

Thanks a lot...I really appreciate your help.

|||

When you build the SSIS Connection Manager using the microsoft OLE DB Provider for Oracle you will see a box labelled Server Name. Copy the name of the tns entry into that box.

-Jamie

|||

I got it Jamie. I was having two locations for tnsnames.ora and that was the reason for the error...

I appreciate your help.

Thanks.

|||

Hi Jamie,

I have the same problem now in production environment. I have to connect to oracle db from production too and I downloaded the client tools on my 64 bit windows server 2003. I edited the tnsnames to have an entry. When I try to connect to oracle, it gives me an error saying client and networking tools not installed, but I did install them. Can you please help me?

Thanks.

Sam.

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 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 Named Instance

Hi,

How can i connect to Named Instance of MSDE on remote server from Enterprice Manager in my local computer ?

Instance name is Helm

I can connect inside server like

osql -S -E .\Helm

But how i access from remote machine using Enterprice Manager ?

Regards,

Yujin Bobymachinename\Helm

connecting to database from script component

Can someone please send me some sample code on how to connect to the database from the script component? I tried using the connection manager to establish a connection and then use it inside my code in VB.NET but it did not work. Please send me some samples.did you try using ado.net to connect to the database?|||

See also http://msdn2.microsoft.com/en-us/library/ms135897.aspx

And here is a sample of destination component:
http://msdn2.microsoft.com/en-us/library/ms135939.aspx

connecting to database from script component

Can someone please send me some sample code on how to connect to the
database from the script component? I tried using the connection manager to
establish a connection and then use it inside my code in VB.NET but it did
not work. Please send me some samples.Shiva
InVB.net you can specify app.config file to communiccate with a database,
have you read about it?
"Shiva" <arbitsquare@.hotmail.com> wrote in message
news:%23JFufYzjGHA.4716@.TK2MSFTNGP03.phx.gbl...
> Can someone please send me some sample code on how to connect to the
> database from the script component? I tried using the connection manager
> to establish a connection and then use it inside my code in VB.NET but it
> did not work. Please send me some samples.
>

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 Analysis Services Manager

Hi,
I have Windows 2000 sp4, and SQL Server 2000 with sp3a.
No matter what I do I cannot connect to the Analysis
Services manager. I get the following message:
Unable to connect to registry on server (xxxxx), or you
are not in Group OLAP Administrators on this server.
I'm signed on with full admin privleges and am in the OLAP
Admin group.
What else could I be missing ?
Thanks for any help.Shad,
>> Is there a seperate sp3 specifically for Analysis Services?
Yes.Its called Sql2kasp3.exe and you can find it in :
SQL Server 2000 Service Pack 3a
http://www.microsoft.com/sql/downloads/2000/sp3.asp
>>version of the Analysis Services it is Version 8.0.194
Means you dont have any analysis services service pack installed.
Dinesh.
SQL Server FAQ at
http://www.tkdinesh.com
"Shad" <msgmeus@.yahoo.com> wrote in message
news:007f01c36cb0$7c70ff90$a301280a@.phx.gbl...
> Thanks,
> I have installed SP3a for SQL Server, if I look at the
> version of the Analysis Services it is Version 8.0.194
> My SQL 2000 version is 8.0.760(sp3)
> The first link you gave me pertains to Windows XP (I
> think), the second says SP3 should solve the problem.
> Is there a seperate sp3 specifically for Analysis Services?
> Thanks
> >--Original Message--
> >Shad,
> >
> >What is the Analysis Services service pack level? See
> >
> >PRB: Cannot Connect Through Analysis Manager Although a
> Member of
> >Administrator Group
> >http://support.microsoft.com/default.aspx?scid=kb;en-
> us;307365
> >
> >FIX: Pre-Analysis Services Service Pack 3 Client Cannot
> Administer Analysis
> >Services Service Pack 3
> >http://support.microsoft.com/default.aspx?scid=kb;en-
> us;331925
> >
> >--
> >Dinesh.
> >SQL Server FAQ at
> >http://www.tkdinesh.com
> >
> >"Shad Gamel" <msgmeus@.yahoo.com> wrote in message
> >news:0da201c36ca1$040bea10$a301280a@.phx.gbl...
> >> Hi,
> >>
> >> I have Windows 2000 sp4, and SQL Server 2000 with sp3a.
> >>
> >> No matter what I do I cannot connect to the Analysis
> >> Services manager. I get the following message:
> >>
> >> Unable to connect to registry on server (xxxxx), or you
> >> are not in Group OLAP Administrators on this server.
> >>
> >> I'm signed on with full admin privleges and am in the
> OLAP
> >> Admin group.
> >>
> >> What else could I be missing ?
> >>
> >> Thanks for any help.
> >
> >
> >.
> >

Connecting to a web based MSSQL DB

Hi all,

I'm running a MSSQL DB on our web server and currently I need to use Teratrax Database Manager to connect and manage it. Unfortunately this doesn't seem to have any features to export the data from the database.

I read somewhere about an online MSSQL tool which can manage online databases? Does this exist?

What tool would I use to connect to my database to export data from it? I have an evaluation copy of MS SQL Server 2005 but my knowledge with it is limited and I'm having trouble getting it connected to a remote DB (local DBs are fine).

Any help would be appreciated!

Thanks!

Hi,

although there are some applications out there to administer SQL Server, they are just mimic to SQL Server Enterprise Manager / Managment Studio (you didn′t tell which version of SQL Server you want to administer). Perhpas you should get a CAL to administer the boxes on the web. SQL EM and SQLMS works fine over the internet and should save you some time compared to using a small featured similiar application.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

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...
>