P
patrick achatschitz via .NET 247
Hello
I wanted to develop a sample application with replication. For that i want
to go through the
http://www.msdn.microsoft.com/SQL/S.../msdnmag/issues/03/09/datapoints/default.aspx
article. But unfortunately some problems occur already at the point "SQL
Server CE Server Agent" and "Replication Publication":
1)At the point "Replication Publication" I opened the Enterprise Manager of
the SQL Server 2000 and clicks on the Northwind database but when i went
under New - Publication the following error occurs:
SQL Server replication does not support nicknames, such as "." or "(local)",
as server names.
So i think i have to delete this Server and register a new SQL Server under SQL Server Group but there and in the creation of the virtual directory there are some things which are not clear for me:
1)Create the virtual directory:
What do i have to enter as alias name?
Should i take Anonymous access or authenticated access?
Should i mark - One or more applications requiring SQL Server merge
application?
2)And the thing with the creation of a new SQL Server:
When i delete the currently registered Server (name is (local)(WindowsNT))
and create a new SQL Server, are the currently existed database then under my
new created SQL Server or are the deleted??-because i still need these
databases because i want to publish the Northwind database.
What name should i take as Available Servers which i then add to
servers?-there are now exist no servers.
Should i use the SQL Server Login(means password and user are sa?)? - and
then Login automatically with type in sa for login name and password?
Then i add the SQL Server to an existing SQL Server group?
During this Wizard i could not chose between NT Machine and local account??
Hopefully anybody find time for me.:-/
thanks in adance.
regards
pat
I wanted to develop a sample application with replication. For that i want
to go through the
http://www.msdn.microsoft.com/SQL/S.../msdnmag/issues/03/09/datapoints/default.aspx
article. But unfortunately some problems occur already at the point "SQL
Server CE Server Agent" and "Replication Publication":
1)At the point "Replication Publication" I opened the Enterprise Manager of
the SQL Server 2000 and clicks on the Northwind database but when i went
under New - Publication the following error occurs:
SQL Server replication does not support nicknames, such as "." or "(local)",
as server names.
So i think i have to delete this Server and register a new SQL Server under SQL Server Group but there and in the creation of the virtual directory there are some things which are not clear for me:
1)Create the virtual directory:
What do i have to enter as alias name?
Should i take Anonymous access or authenticated access?
Should i mark - One or more applications requiring SQL Server merge
application?
2)And the thing with the creation of a new SQL Server:
When i delete the currently registered Server (name is (local)(WindowsNT))
and create a new SQL Server, are the currently existed database then under my
new created SQL Server or are the deleted??-because i still need these
databases because i want to publish the Northwind database.
What name should i take as Available Servers which i then add to
servers?-there are now exist no servers.
Should i use the SQL Server Login(means password and user are sa?)? - and
then Login automatically with type in sa for login name and password?
Then i add the SQL Server to an existing SQL Server group?
During this Wizard i could not chose between NT Machine and local account??
Hopefully anybody find time for me.:-/
thanks in adance.
regards
pat