sql server dts: SQL server in windows workgroup enviroment -- sql server dts

SQL server in windows workgroup enviroment

Ann
12/23/2003 12:03:45 PM

sql server dts: We are in a windows workgroup environment. No active
directory. Therefore no domains. (netware network)

I tried to use SQL server Copy database wizard to copy a
database to a developer sql server, it failed and
I checked the log find two error:
1. transfer login SQLserverPC\Administrator failed
2. failed to create a share OMWWIZD

It works OK if I just use DTS export and import to
transfer tables and other objects, but not databases.
Do I have to be in domain environment in order to
transfer databases? Any suggestions in workgroup
enviroment?
SQL server agent seems also only works in windows domain
enviroment, Is that correct?

Thanks

Re: SQL server in windows workgroup enviroment

Ann
12/23/2003 2:15:16 PM

Thanks, I did see this article.
That seems to mean I have to use a domain account to copy
files. But we don't have a domain account because we are
in a windows workgroup enviroment. We use netware for
network.

So what should I do in a workgroup environment to copy
databases?
Why there is no such error when I just copy tables
through the network?

Thank you.

[quoted text, click to view]
scid=http://support.microsoft.com:80/support/kb/articles/Q
274/4/63.ASP&NoWebContent=1
[quoted text, click to view]

Re: SQL server in windows workgroup enviroment

Allan Mitchell
12/23/2003 8:12:58 PM

Have you seen this article

http://support.microsoft.com/default.aspx?scid=http://support.microsoft.com:80/support/kb/articles/Q274/4/63.ASP&NoWebContent=1

--
--

Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

[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 in the sql server dts group.