i have database on another machine by name "sqldev" and I am trying to
connect to it from another machine whose name is same "sqldev". then
it gives me error and refuse to connect it. Can anybody tell me why
and how to resolve it?No idea - what is the error message? Also, what are your Windows and
MSSQL versions, do you have a domain or a workgroup, and are you using
Windows or SQL logins? You seem to be saying that you have two machines
with the same name on one network; if so, then you should change one of
them to avoid name resolution problems.
Simon|||A faster solution is to connect w/ the other machine's IP address. When
you rename the server you have to partially reinstall SQL. It isn't a
quick task, but you can figure out how to do it by searching Google.
No comments:
Post a Comment