Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
cbanta
Starting Member
2 Posts |
 Posted - 2010-02-21 : 15:16:57
|
| Hello All,We have a set of 3 servers for a single signon software that we use and somehow the name of the individual servers in the group all got changed to (local) I know nothing about SQL and the vendor for this software doesn't seem to be too knowlegable either. they want me to delete and reregister the server names, but this really scares me, as I want to be sure I don't cause any bigger issues. I'd also like to know if this will or may cause any bigger issues so I'm not blindly trying to figure out what I did to break it. Basically we have 3 servers, the main one is suposed to Replicate with the second server, and the third doesn't replicate to either, its just a back up. The second server can't pull its subscription from the main server due to this name issue and so when I take the main server down to do backups and updates we get authentication issues for our users. I've included a link to a screenshot of the current state and the error as i know it can really help to be able to see whats going on. Any input you guys have would be much appreciated.Thanks,ChrisLINK:http://i124.photobucket.com/albums/p2/rangerhottie/sqlissue.jpg |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
cbanta
Starting Member
2 Posts |
Posted - 2010-02-22 : 10:00:16
|
| So I'm basically making a mountain out of a mole hill? also, do you know what would cause this to "flip" like this? that is one of my main concerns as I'd like to prevent this from happening again. Also, when I do this will I need to set my Subcriptions up again? (sorry for the ovbiously "noob" questions, I'm just trying to cover all my bases)Lastly, I love your sig line!Thanks,Chris |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
|
|
Server Registration name issue