QUESTION: Connecting With SQL Admin Across Domains

Nov 23, 2005

Hi, all.

I am having some confusion with connecting to a SQL 2000 SP4 Server
across a one-way trust.

I have a SQL server in the trusting domain, and the Admin workstations
in the trusted domain.

I am not using domain-level authentication, I am only using SQL IDs.

If I log onto the workstation in the trusted domain with an ID in that
domain, and attempt to establish a connection to the server, it fails:

"A connection could not be established to %SERVERNAME%. Reason: SQL
Server does not exist or access denied. ConnectionOpen (Connect()).."

If I log onto the workstation using an ID in the trusting domain and
attempt the same thing, the connection works. Incidentally, my trusting
domain ID has Admin rights to the server.

I want to be able to connect to this box, but not be forced to use a
domain ID from the trusting domain.

Again, domain-level authentication was not how I configured the server;
I set it up for SQL Server IDs only.

Can anyone shed some wisdom on this one??

Thanks!!

BD

View 1 Replies


ADVERTISEMENT

SQL Server Admin 2014 :: Configure Transnational Replication Between Two Different Domains And Non Trusted Domains?

Apr 28, 2014

Is it possible to configure transnational replication between two different domains also non trusted domains.

It's possible means what i need to take care before configure replication and how to configure transnational replication between two different domains.

View 2 Replies View Related

Connecting To MS SQL Server 2000 From The Different Domains Using Asp.net

Jul 24, 2007

Hi,
      My problem is somewhat like this that, i want to connect my all applications (developed in asp.net)  to one database. In other words i want to make a centralised database that can be accessible from the application running at the different domains. When i did so  by using the same username, password, database and server...i recieve an error that, "connection cannot be establised".
If any body have the solution for this problem. then please do write the "connection string"  for me that can be efficiantly used on the applications running on differnt domains.
Thanks and Regards,
Steve Dcosta
 

View 1 Replies View Related

SQL Server Admin 2014 :: Central Management Server Doesn't Support Multi Domains

Jun 3, 2015

As CM doesn't support SQL authentication, and if access SQL Server on another domain with no trust, we cannot use Windows authentication as well.

CM only supports Windows authentication, but for large organizations which will have multi domains.

I am thinking if there is no proper way/tool, we will develop one then.

View 0 Replies View Related

BDE Admin Connecting Problem, How Do I Connect Via IP Address.

Jun 12, 2006

Hi, I am connecting from clientside with sql server 2005 installed trying to connect to a database running on a server with sql server 2000 installed. this is not a 2000 to 2005 compatibility issue.
I can connect locally fine to the server and log in using the sa account, however for BDE admin i HAVE to use the server name instead of ip address. If i try to use the ip address of the server, the connection dosnt get established. *this is all happening localy on our own network.

How to I use ip address to connect instead of the server name? I will need to connect remotely outside of our network later on, and i dont think I can use the servername. Does anyone have a solution? thanks.

View 6 Replies View Related

SQL Server Admin 2014 :: Application Connecting To AG Listener Static IP Address - Not Name

Jul 22, 2015

We have a bought in application written in Visual Basic 6 using ADO 2.7 to connect to SQL Server. The application has two connections strings and uses internal logic to determine which of the two connection strings connects to a read-write database. It does something as simple as trying an update that makes no changes to a very small table somewhere.

Previously this application connected to a Mirrored Database hosted on two Windows Server Failover Clusters and SQL Server 2005.For the future the App will be connecting this application to a SQL Server 2014 Availability Group.The Availability Group is made up of four servers, in a cluster, two at one site on Subnet A and the other two at a second site on Subnet B. The Availability Group has been given a Listener with a DNS name of AGLISTEST on port 1433 with two Static IP addresses, one for each subnet.

Our Contractor has configured the Application’s connection strings to connect to the two Static IP addresses assigned to the AG. He is of the opinion that although ADO has zero understanding of an Availability Group, at least one of the Static IP Address will translate to the Availability Group primary server because it is a Cluster Resource and so act like a Cluster IP Address on Windows Server Failover Cluster; i.e. sort of mimicking the previous configuration. This does work and he has demonstrated it, however I can’t find any article that proves to my satisfaction this is intended behavior not something that accidentally works. If it is accidental behavior then that would be something that might stop working at an unexpected point in the future.

All the research I have found relates to connecting to the AG Listener name, and all the multi-subnet issues and Active Directory issues that go with connecting using what is a legacy client.So; the question is, is this translation / redirection of static IP Addresses assigned to an Availability Group listener documented and safe?

View 3 Replies View Related

Domains And SQL

Nov 7, 2000

Hey all,
I need your help again..We are having many domains. Actually
we have created SQLgroups in sql and granted permissions in our domain.
But guys from other domains are just entering into their query analyser
and accessing the sql server..They are not at all falling under our SQLgroups.
We have given trusted connections between domains..
My question here is
Is there anyway that there should be an option to select the domain
before they log in thru query analyser? Like Nobody should enter
from their domain ...only through our domain they should enter..?
Please help me out..

Thank you
Andrew.s

View 2 Replies View Related

Different Domains

Dec 9, 2004

Hi, I have two SQL servers in different domains(A and B), I cant use
the Enterprise Manager to register eachother...they show me "Sever doesnt exist" but when I use ping I can show them....
Please help me.....What can I do?

cedutang.

View 1 Replies View Related

DTS Between Non-trusted Domains (VPN)

Feb 1, 2001

I'm attempting to set up a dts transfer SQL 7 box to SQL 7 box. These two servers are on two separate NT domains with no trust relationship, and I will be sending the info across a VPN.

Anyone out there have a similar situation? Offer any recommendations, pitfalls, ports used, ways to do this??? I'd appreciate any ANY ideas on how to make this work. Thanks in advance.
-Tricia

View 2 Replies View Related

Non Trusted Domains

Mar 21, 2000

Is there any way to connect to SQL Server from a non trusted domain. Passthrough authentication works for other NT Server resources (like exchange folder, printers, shared folders), but SQL Server 7.0 does not seem to accept this passthrough authentication (where the username and password are the same in both domains). There is no internet access required.

View 1 Replies View Related

How To Change Domains

Apr 10, 2001

I need to move three sql 6.5 servers over from one domain to another domain. What is the best way to do it and what should I look out for? I am really new at this so any help would be great.

Brian

View 1 Replies View Related

Clients In Different Domains

Oct 25, 2005

I have situation like this:

Company with one head office and one remote office. In the two offices I have two domains with two PDCs. The two networks are connected with eachother through leased line and the routers are configured properly. The SQL Server is on the PDC in head office and "local" clients connect fine. I cannot connect from the remote office. I think that I have folowing solutions:

1. make trust relationships between two domains - it will be hard a little bit because second PDC is samba on linux

2. make all clients in remote office to be members of the head office domain - potential problems if the leased line drops

3. make all clients to log in with same account as SQL Server logs locally - stupid

4. something else - what?

Thanks in advance!
Daniel

View 3 Replies View Related

Discrete Domains In Sql

Aug 22, 2006



I have a sql-table. The domain of one of my columns a fix number of string values (like "blue", "green" and "yellow"). However, there is a big likelyhood that the domain will be expanded by more string values in the future (however, none of the existing string values will ever be discluded from the domain). How would I go about enforcing that all strings added to my column in my table is within my domain?

Should I use a check constraint, or create a domain, or sholud a create another table with the domain values and use a foreign key? What would be best practise for my problem?

View 1 Replies View Related

Mirroring And Domains

Sep 24, 2007


I not too hot on networking. When I type "IPCONFIG /ALL" the "Prmary DNS Suffix" is empty. Does this mean I have no domain? Can I configure a mirror on this server?

Thanks in advance.

View 6 Replies View Related

Replication From Different Domains

Oct 2, 2006

Hello,

First

I would like to replicate databases from an SQL 2000 Server to a SQL 2005 Server.

a. First can this be done?

b. Does it matter if both servers are on different domains?



Secondly

If all is possible from my above questions, in order for me to enable replication on the SQL 2000 Server, i need to rename the server from LOCAL to a realname. I get an error message saying that it can not use nicknames.

a. If I go ahead and make a New SQL Server Registration, could this have a major impact on the applications using the Database server?

b. When renaming, do I first Delete the current server registration or should I first create the new one then delete the old one?



Thank you very much in advance

View 1 Replies View Related

SQL Server Admin 2014 :: Does Security-admin Role Plus Deny Alter Any Login Cancel Each Other Out

Aug 27, 2015

I want to set up a database role so that users can use sp_readerrorlog through SSMS. It does a check on membership in the securityadmin role.

I have tested it and can see you can grant execute on xp_readerrorlog but the SSMS GUI uses sp_readerrorlog.

I thought I could create a user/certificate and add the signature to sp_readerrorlog but it's not permitted (likely because it's not a normal database object).

So the other solution is to add the users to the securityadmin role but then explicitly deny alter any login (best done with a custom server role in 2012+ but otherwise just manually in 2008). I tested this out and it works, I'm not able to alter any logins or increase my own permissions, I also did a check of what's reported from fn_my_permissions(null, null) and it shows minimal permissions like I'd expect.

View 0 Replies View Related

SQL Server Authentication Across Domains

Aug 31, 2006

Viual Studio 2003; ASP.Net; .Net Framework 1.1, SQL Server 2000Hi,We have two domains in our network - prod.domain.com and dev.domain.com. There is no trust relationship between the two domains. I am trying to connect to an SQL Server in dev.domain.com using SQL Server Authentication from prod.domain.com. My connection string uses the fully qualified domain name (xxxxxx.dev.domain.com) to connect. The error I receive is SQL Server does not exist or access denied. I can access the database through SQL Query Analyser and SQL Enterprise Manager across the domains with no problems. I can also connect through a .udl file using the same SQL Server Authentication information.If I run my application from dev.domain.com accessing a database that sits in prod.domain.com then the connection is fine.Can someone point me in the direction of any areas I can troubleshoot to see what is preventing the connection please? The only things I can see on the web are details of windows authentication across domains which isn't relevant to me in this instance. I've been pulling what little hair I have out over this for the last week.Thanks in advance.

View 3 Replies View Related

Merge Replication Between Different Domains

Oct 14, 1998

We are testing merge replication. Between servers on one domain, it works fine. Between servers on different domains, appears to work while configuring the Publisher and Push subscribers, but then errors appear after configuration. One error is that the Merge Agent could not connect to the subscriber.

The SQL Service accounts and passwords are the same on both servers. We also configured a one-way trust (maybe it is the wrong way)Subscribers trust the Publisher, and SQL service accounts added to local admin group on subscribing systems.

Anything else I should try?...modify publisher access list?

Thanks for the help.
Christi

View 1 Replies View Related

Data Transfer Between Domains

Mar 13, 2001

Hello,
I have a problem scheduling an Object Transfer task on a server that is in a different domain than the server it is getting the data from. I can set up the Object Transfer through the Tools/DatabaseObject Transfer... option and run it manually (works great), but if I schedule it to run, it stops after about 30 seconds and gives an error message "Process Exit Code 1. Cannot connect to source server." Any ideas would be much appreciated. Thank you
Ryan

View 1 Replies View Related

Accessing SQL Servers Across Domains

Jun 22, 1998

We have installed SQL servers in 3 domains. We cannot see the servers in Enterprise manager in the other domains from any other domain. Trusted security is set up. Named pipes is the set protocol as we made no changes at install time. We can see the NT servers in the Server manager. All services are running. Is there something that I missed? Any help will appreciated.

View 1 Replies View Related

SQL Server Domains/Workgroups

Dec 9, 2005

I have a network that has 10 machines-6 of them have sql server registrations. I am able to access all 6 from any machine while they are on the domain. However I also need to take 5 of them off of the domain to a remote site and set up a workgroup. I am able to log in to each sql server from the workgroup login but I am not able to run software on one machine that connects to a sql server registration on another machine in the workgroup. I get a "sql server does not exist or access denied" message. Further, when I open enterprise manager, the other sql servers don't show up and I am unable to add them using the wizard.

Any help would be much appreciated.

View 6 Replies View Related

Dos Command To Copy Between 2 Domains

Nov 20, 2007

anybody have the syntax floating around their heads to use DOS copy between 2 domains.

i think it is something like so ...

copy C:PathToMySQLServerMSSQL.1MSSQLBackupReportSe rver* remote_host=\10.0.0.0ackup" myusername@mydomain.com;mypassword

View 3 Replies View Related

Transactional Replications Between Domains

May 30, 2008

We have two seperate domains (connected via a VPN Tunnel over the internet) We want to replicate one table with a push publication between these two domains (both have sql server 2005 default instances) how do you figure out what ports to open up in order to be able to do transactional replication (of one table) between them????

View 1 Replies View Related

Connection In Case Of Domains

Jul 9, 2007

Hi
i wanna connect to a server that is installed with domain registration and using both sql and windows authentication.on this server i have created database and login for that respective database,but when i am trying to connect this server it gives me error. The login that i m using is able to connect when i m trying to connect server from console of the server.Please help me..

Chander

View 10 Replies View Related

Access To Different Databases In Different Domains

Apr 16, 2007

Hi everybody,there are several SQL-Server 2000 databases within a company locatedon different servers in different domains. On every database you canfind the same table X.I want to merge these tables X (UNION query) and print the result witha Crystal Report.Unfortunately I only have little knowledge on security, domains,distributed applications.Thanks for help.

View 2 Replies View Related

Subscription E-mails To Other Domains

Apr 3, 2008

I am testing the e-mail subscriptions to my hotmail account in anticipation of sending e-mail reports to our business partners. I have made the following to the RSreportserver.config file:

<PermittedHosts>
<HostName>mydomain.com</HostName>
<HostName>hotmail.com</HostName>
</PermittedHosts>

I then stopped and restarted the reporting services service. However, the test subscription fails with the following message:

The e-mail address of one or more recipients is not valid.


Any idea what I may be missing?


View 1 Replies View Related

Mirroring On Separete Domains

Mar 21, 2007

We have 2 servers each having a domain (i.e. 2 domains) running
Windows Server 2003
Standard Edition
Service Pack 1
We would like to have one of the servers replicate/mirror the data on to the other but we are getting this error
The error produced from the mirroring part is:

TITLE: Database Properties
------------------------------
An error occurred while starting mirroring.
------------------------------
ADDITIONAL INFORMATION:
Alter failed for Database 'CTSM'. (Microsoft.SqlServer.Smo)
------------------------------
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
------------------------------
The server network address "TCP://UM_db_live.UMlive.local:5022" cannot be reached or does not exist. Check the network address name and that the ports for the local and remote endpoints are operational. (Microsoft SQL Server, Error: 1418)
Thank you.

View 1 Replies View Related

BULK INSERT ON DIFFERENT DOMAINS

Feb 29, 2008



Hi,

I have bulk insert statement thats need to be run on two different domains. It is working when the files are on same domain. But failing while copying from two different domains.

Does anyone know how to implement this ?

BULK INSERT abc.DBO.table_200709
FROM 'IPADDRESSSourceTEST_FLATFILE.txt'
WITH
(
FIELDTERMINATOR =' |',
ROWTERMINATOR =' |'
)

View 2 Replies View Related

Manage SQL Servers On Multiple Domains

Aug 24, 2000

I have to maintain several SQL Server 7 DBs across multiple NT Domains (same network). How do I access the SQL Server on the second domain from enterprise manager?

Thanks!

Lia

View 1 Replies View Related

Anyone Use Copy Database Wizard Across Domains?

May 19, 2004

Has anyone been able to successfully use the database copy wizard to copy databases between domains?

I've got a SQL 7.0 database on domain A. I need to move it to domain B and upgrade it to SQL 2000.

Thanks
Sharon

View 2 Replies View Related

SQL 2012 :: Replication Between Different Sites And Domains

Jun 10, 2015

Can we setup a replication ( publisher and subscriber are Sql server) between two different domains, basically different company databases.

View 1 Replies View Related

Recovery :: Log Shipping Between Multiple Domains

Apr 30, 2015

I'm allowed to do Log Shipping from x.contoso.com to y.contoso.com, however there is a requirement to have the same data made available to servers residing on z.contoso.com.

Connectivity between x.contoso.com and z.contoso.com is not permitted, so configuring log shipping with multiple targets is not possible.y.contoso.com and z.contoso.com can talk to each other, so what is the most efficient way to move data from y to z.

View 6 Replies View Related

Mirroring :: Log Shipping Cross Different Domains

Oct 27, 2015

SQL Server 2012 SP2 - WIndows 2008 R2.

We are currently doing Mirroring from one domain to another (On a different subnet/network) via

Network1

DomainABCSQLAccount1 - Password1 -----> SQL Server Service Account
DomainABCSQLAccount2 - Password2 -----> SQL Server Agent Service Account

Network2

DomainABCSQLAccount1 - Password1 -----> SQL Server Service Account
DomainABCSQLAccount2 - Password2 -----> SQL Server Agent Service Account

And it works. We are planning to do the Log shipping but this time different Domain but same userID and Password

Network1

DomainABCSQLAccount1 - Password1 -----> SQL Server Service Account
DomainABCSQLAccount2 - Password2 -----> SQL Server Agent Service Account

Network2

DomainDEFSQLAccount1 - Password1 -----> SQL Server Service Account
DomainDEFSQLAccount2 - Password2 -----> SQL Server Agent Service Account

Is this possible without TRUST between the domains ?

View 3 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved