February 14, 2019 at 7:54 am
Sue_H - Wednesday, February 13, 2019 11:58 AMOr if you installed SQL Server with a case sensitive collation, the login would be case sensitive.
Sue
Well We have two instances on each environment DEV and UAT.
DEV01 (Default instance with default port 1433)
DEV (Instance with port 2000)
UAT01 (Default instance with default port 1433)
UAT (Instance with port 2000)
So, when i try to add subscriber from DEV instance -> UAT, i am receiving message please use default instance UAT01.
SQL Server replication requires the actual server name to make a connection to the server .
Same way from UAT as well.
February 14, 2019 at 8:00 am
EasyBoy - Thursday, February 14, 2019 7:54 AMSue_H - Wednesday, February 13, 2019 11:58 AMOr if you installed SQL Server with a case sensitive collation, the login would be case sensitive.
Sue
Well We have two instances on each environment DEV and UAT.
DEV01 (Default instance with default port 1433)
DEV (Instance with port 2000)UAT01 (Default instance with default port 1433)
UAT (Instance with port 2000)So, when i try to add subscriber from DEV instance -> UAT, i am receiving message please use default instance UAT01.
SQL Server replication requires the actual server name to make a connection to the server .
Same way from UAT as well.
Wondering if you have DNS Aliases in play, here....
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)
February 14, 2019 at 8:17 am
EasyBoy - Thursday, February 14, 2019 7:54 AMSue_H - Wednesday, February 13, 2019 11:58 AMOr if you installed SQL Server with a case sensitive collation, the login would be case sensitive.
Sue
Well We have two instances on each environment DEV and UAT.
DEV01 (Default instance with default port 1433)
DEV (Instance with port 2000)UAT01 (Default instance with default port 1433)
UAT (Instance with port 2000)So, when i try to add subscriber from DEV instance -> UAT, i am receiving message please use default instance UAT01.
SQL Server replication requires the actual server name to make a connection to the server .
Same way from UAT as well.
This was an error with Login failure where you said you tried to add the subscription you got a login failure.
So now it's a message to use the default instance? This is getting a bit confusing on what is going on.
Sue
February 14, 2019 at 8:40 am
sgmunson - Thursday, February 14, 2019 8:00 AMEasyBoy - Thursday, February 14, 2019 7:54 AMSue_H - Wednesday, February 13, 2019 11:58 AMOr if you installed SQL Server with a case sensitive collation, the login would be case sensitive.
Sue
Well We have two instances on each environment DEV and UAT.
DEV01 (Default instance with default port 1433)
DEV (Instance with port 2000)UAT01 (Default instance with default port 1433)
UAT (Instance with port 2000)So, when i try to add subscriber from DEV instance -> UAT, i am receiving message please use default instance UAT01.
SQL Server replication requires the actual server name to make a connection to the server .
Same way from UAT as well.Wondering if you have DNS Aliases in play, here....
Or maybe servers being renamed. Really can't tell with the changes in errors and the last message.
Sue
Viewing 4 posts - 16 through 18 (of 18 total)
You must be logged in to reply to this topic. Login to reply