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