Tracking Forums, Newsgroups, Maling Lists
Home Scripts Tutorials Tracker Forums
  Advanced Search
  HOME    TRACKER    MS SQL Server






SuperbHosting.net & Arvixe.com have generously sponsored dedicated servers and web hosting to ensure a reliable and scalable dedicated hosting solution for BigResource.com.







Non Trusted Domains


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 Complete Forum Thread with Replies
Sponsored Links:

Related Messages:
DTS Between Non-trusted Domains (VPN)
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 Replies !   View Related
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 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

View Replies !   View Related
Disconnection Of Trusted Users Across Domains
I have an Access 97 frontend with a Sql Server backend, I have created a number of users in Sql Server 6.5 (SP5a) and used trusted connections. The users exist on another domain so it's across domains. The users connect to Sql Server OK, but are disconnected after 20 minutes producing a "login failed" within the error log. If the users are on the same domain then they don't get disconnected. Does anybody know of a timeout under Sql Server / NT across domains or know why this is happening??????

Can somebody please help me?

Thanks
Mark Green

View Replies !   View Related
Linked Servers In Non-Trusted Domains
Hi,
I am trying to set up linked servers between two non-trusted domains. Has anyone done this? If so how did you setup your authentication?

Thank you for all your help,
Phil.............

View Replies !   View Related
Different Domains
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 Replies !   View Related
Domains And SQL
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 Replies !   View Related
Clients In Different Domains
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 Replies !   View Related
SQL Server - Domains
Can anyone advise me?

We have three SQL Server Servers' (London, New York, Hong Kong). Currently we have three separate domains (one at each site). We are wanting to alter our network to have one global domain and are wondering whether there are any difficulties that SQL Server may experience in doing so ?

help much appreciated

P.

View Replies !   View Related
SQL Server - Domains
Can anyone advise me?

We have three SQL Server Servers' (London, New York, Hong Kong). Currently we have three separate domains (one at each site). We are wanting to alter our network to have one global domain and are wondering whether there are any difficulties that SQL Server may experience in doing so ?

help much appreciated

P.

View Replies !   View Related
How To Change Domains
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 Replies !   View Related
Changing Domains
I have been informed that I will soon have to change the domain that my sql server resides in. Does anyone know if I will have to reinstall sql after this happens?

View Replies !   View Related
Replication Between Domains
What are the requirements to set up relplication between domains? Are the
domains required to be in a trust relationship? If not, how can transactional replication be achieved in such a scenario.

Thanks for your help
Sincerely
Ziggy

View Replies !   View Related
Different Domains(very Urgent)
Hi everbody,
I have two Sql server production boxs and both are in different domain.I am unable to register the server another domain server. Let me know how to register the diffrent domain server.
Thanks in Advance

View Replies !   View Related
Replication From Different Domains
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 Replies !   View Related
Discrete Domains In Sql


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 willbe expanded bymore 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 iswithin 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 Replies !   View Related
Mirroring And Domains

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 Replies !   View Related
SQL Server Authentication Across Domains
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 Replies !   View Related
Access To Different Databases In Different Domains
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 Replies !   View Related
SQL Server Domains/Workgroups
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 Replies !   View Related
Dos Command To Copy Between 2 Domains
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 Replies !   View Related
Accessing SQL Servers Across Domains
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 Replies !   View Related
Data Transfer Between Domains
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 Replies !   View Related
Merge Replication Between Different Domains
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 Replies !   View Related
Merge Replication Between Domains
Setting up Merge replication and push subscribers.
The snapshot agent seems to work fine, but getting an error with the Merge agent...'subscribedservername' is not configured as a subscription server. It is configured as a subscriber from the publishing server. Is there somewhere else where it needs to be defined, or do we need a domain trust?

Thanks,
C. Fischer

View Replies !   View Related
Data Transfer Between Domains
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 Replies !   View Related
SQL Server Domains/Workgroups
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 Replies !   View Related
Connection In Case Of Domains
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 Replies !   View Related
Transactional Replications Between Domains
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 Replies !   View Related
Mirroring On Separete Domains
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 Replies !   View Related
Subscription E-mails To Other Domains
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 whatI may be missing?




View Replies !   View Related
BULK INSERT ON DIFFERENT DOMAINS


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 Replies !   View Related
Connecting To MS SQL Server 2000 From The Different Domains Using Asp.net
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 Replies !   View Related
QUESTION: Connecting With SQL Admin Across Domains
Hi, all.I am having some confusion with connecting to a SQL 2000 SP4 Serveracross a one-way trust.I have a SQL server in the trusting domain, and the Admin workstationsin 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 thatdomain, and attempt to establish a connection to the server, it fails:"A connection could not be established to %SERVERNAME%. Reason: SQLServer does not exist or access denied. ConnectionOpen (Connect()).."If I log onto the workstation using an ID in the trusting domain andattempt the same thing, the connection works. Incidentally, my trustingdomain ID has Admin rights to the server.I want to be able to connect to this box, but not be forced to use adomain 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 Replies !   View Related
Anyone Use Copy Database Wizard Across Domains?
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 Replies !   View Related
Manage SQL Servers On Multiple Domains
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 Replies !   View Related
Using Query Analyzer With Windows Auth Across Domains
Howdy,I have a SQL server in a completely different forrest than theworkstation I am running query analyzer on. However in query analyzerwhen I choose windows authentication I cannot manually specify"domainusername" as I could when mapping a file share across domainsor forests. Is there any way around this without resorting to using SQLServer authentication?Thanks

View Replies !   View Related
Replication Setup For Servers Belonging To Different Domains
Hi,
KB Article Id Q160563 provides information on 'Replication and Windows NT server network configuration' for versions 6.0 and 6.5. Does anyone know if there is a similar article for version 7.0?

I need to set up replication and, the servers participating in replication belong to different domains. Is there any restriction on the network library that has to be used across these servers? For example, would it work only with either named pipes or multiprotocol? Also, what are the other prerequisites to setting up replication for servers participating in different domains? I am aware of the following three prerequisites :
1. Bidirectional trust relationship across servers participating in replication.
2. The same domain admin service account to be used by all servers participating in replication.
3. SQL Server name and NT server name for each of the servers participating in replication must match.

Thanks in advance
-Praveena

View Replies !   View Related
Isssue With Repllication Accross Domains And Inter
Hi,

I am newbie in replication,

I have a requirement where need to set upo replication with db such as both dbs are in different domain.
I have created a merge publication with create pulblisher wizard.

I want to use FTP as default location for the snapshot so that from both the domain database can accesss this path and subscriber will take the snapshot from it.


Issue facing like to run the snapshot agent we need to provide windows domain user or machine user but we can't add this user in FTP machine as domain is differnt will not get access on this machine.


I am getting following error:

Message: The replication agent failed to create the directory '\192.168.7.57ftprootuncPARAG-TEST_NORTHWINDSUB_PARAG_PUB20070810185320'.
Stack: at Microsoft.SqlServer.Replication.Utilities.CreateDirectoryWithExtendedErrorInformation(String directory)
at Microsoft.SqlServer.Replication.Snapshot.SnapshotProvider.CreateSnapshotFolders()
at Microsoft.SqlServer.Replication.Snapshot.MergeSnapshotProvider.CreateSnapshotFolders()
at Microsoft.SqlServer.Replication.Snapshot.SqlServerSnapshotProvider.GenerateSnapshot()
at Microsoft.SqlServer.Replication.SnapshotGenerationAgent.InternalRun()
at Microsoft.SqlServer.Replication.AgentCore.Run() (Source: MSSQL_REPL, Error number: MSSQL_REPL52026)
Get help: http://help/MSSQL_REPL52026
Source: mscorlib
Target Site: Void WinIOError(Int32, System.String)
Message: Logon failure: unknown user name or bad password.

Stack: at System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath)
at System.IO.Directory.InternalCreateDirectory(String fullPath, String path, DirectorySecurity dirSecurity)
at System.IO.Directory.CreateDirectory(String path, DirectorySecurity directorySecurity)
at Microsoft.SqlServer.Replication.Utilities.CreateDirectoryWithExtendedErrorInformation(String directory) (Source: mscorlib, Error number: 0)


Any help regarding this is appreciable.

Please can put more light on it if I am doing anything wrong.


Thanks & Regards
Amit Harhare

View Replies !   View Related
Running ETL Package Using SQL Server Agent Over 2 Different Domains
Okay, i've got an ETL package which works flawless, we've created a scheduled job for it which also worked.
This ETL accesses a flat file located on a server on a different location in the same domain.

Last week we start a migration to a new network, the location where the flat file is stored has already moved to the new domain but the SQL server agent is still on the old domain.
There is a trust between the 2 domains, the network user from the old domain has been added on the server in the new domain where the flatfile is located.

If i run the etl package manually it works flawless, now if i run the etl using the SQL server agent it won't run anymore.

I get the following error:

Executed as user: OIdDomaindwh. ...n 9.00.1399.06 for 32-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 21:15:00 Error: 2007-10-02 21:15:02.10 Code: 0xC001401E Source: Rolmer_Product Connection manager "Flatfile Product" Description: The file name "\fs-cha-fs01dwhproduit.csv" specified in the connection was not valid.


Don't tell me its a problem related to the user that the SQL Server Agent is set to because its set to OldDomaindwh which is the same user i use to login on the server where i can manually run it without problems. The problem only occures when i run it using the SQL server agent which uses the same user to execute packages.

This is a very difficult problem i doubt anyone here will be able to crack this nut, but if they do i'll be very impressed because it would require a real smart network admin with SQL experianceto figure this one out...


Good luck

View Replies !   View Related
Bizarre Issue With Vista Firewall And Domains...


Good afternoon,

3 of my fellow employees and I am having some strange issues with SQL Server...

When we are connected to the local network, we are unable to log into our SQL Server Instances locally through SSMS or programs that use SQL Serverunless we have our firewalls "default"(no exceptions). Of course, this is useless if we need to make client connections from other computers. So, if we add an exception, say "port 1433", the client CAN connect, but we can no longer connect locally...to ANY instances.

We have tried adding exceptions to the firewall for all SQL ports and programs. We've also made sure we've got the latest hotfixes and service packs. If I log in as the local computer admin and do not connect to the domain and turn off my firewall, everything works fine.

1. Tried enabling Remote Connections
2. Allowed multiple ports through firewall
3. Allowed multiple programs through firewall
4. Re-installed SQL

It's almost as if something on the local network or domain is causing an issue with our firewall.....

Anyone have any ideas?

Thanks,

View Replies !   View Related

Copyright 2005-08 www.BigResource.com, All rights reserved