Data transfer between servers -- sql server clustering

Dana
10/22/2003 12:36:56 PM

Thanks for the reply.
Actually we are using SQL authentication to connect to the
server.
Before we seperated out different domains for development
and production, I set up alias via client network utility.
It worked fine (I could access the cluster server from my
local PC). But I am not sure how to specify the server
name for alias in term of cluster server when they are in
different domains. Could you help me out with it?

Thanks!

[quoted text, click to view]

Geoff N. Hiten
10/22/2003 2:44:54 PM

If SQL Servers are not in the same domain, you need to have them running in
mixed mode and connect via SQL authentication. Alternatively you could have
a trust between the domains and grant access to trusted users. You may also
need to create hosts file or SQL client tools aliases in order to resolve
names correctly if they do not have a common DNS or WINS context.

--
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com

[quoted text, click to view]

Geoff N. Hiten
10/22/2003 4:12:17 PM

Alias the FQDN of the clustered virtual server (MySQLServer.mydomain.com) to
the short name you normally use( MySQLServer). Then you can connect to the
instance via MySQLServer\MyInstanceName. Again, this requires common DNS.
Treat a clustered instance just like a named instance, only use the virtual
server name instead of the host computer name. Also, you will have to
grant login permissions to the trusted domain account you run the DTS
package. Complex but not impossible.

--
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server clustering

sql server clustering : Data transfer between servers