Groups | Blog | Home
all groups > sql server new users > april 2005 >

sql server new users : Cannot replicate Northwind on SQL Server 2000


Dave Ingram
4/18/2005 9:10:01 AM
Trying to replicate Northwind on the same server in SQL Server 2000. Keep
getting the message: [SQL Server Agent on "XXXXXXXXXXXX" currently uses the
system account, which causes replication between servers to fail.]

If I go ahead and enter the default when asked for a new system I get this
error message in the Specify Snapshot Folder:

'C$\Program Files\Microsoft SQL Server\MSSQL\RelpData' is not a valid
pathname of file name.

Any help would be great appreciated!
Cristian Lefter
4/19/2005 12:00:00 AM
Try "\\SERVERNAME\C$\Program Files\Microsoft SQL Server\MSSQL\RelpData".
Replace SERVERNAME with your server name.
Cristian Lefter, SQL Server MVP

[quoted text, click to view]

Dave Ingram
4/19/2005 9:44:03 AM
My fault. The server name is already in there and I still keep getting the
same error message. I have made sure all the permissions for each file are
correct in Windows as well. Still keep getting the same message.

Thank you for your reply, Cristian!

Dave Ingram

[quoted text, click to view]
Richard Ding
4/19/2005 4:25:20 PM
You can recreate northwind database by run the script at
\\<servername>\c$\Program Files\Microsoft SQL
Server\MSSQL\Install\instnwnd.sql



[quoted text, click to view]

Dave Ingram
4/19/2005 9:07:01 PM
Richard, thanks. I discovered the "fix" by accident. Once I took the $ out
of the path and the Program Files, it worked like a charm.

Thanks again for your help.

Dave Ingram

[quoted text, click to view]
AddThis Social Bookmark Button