February 23, 2004 at 2:43 am
I'm having difficulty with registering a new SQL server across
a network. I'm guessing it's something to do with the authentication method, but as of yet I can't get it to work.
I recieve the message
"Login failed for user 'computername/Guest' "
Curiously, doing things the other way round (registering this server on the other one across the network) works absolutely fine, and as far as I can tell I have them set up exactly the same.
Any help would be very much appreciated!
Ben
February 24, 2004 at 1:45 am
Many posibilities, but here are a few to try. Are both same version of sql server and EM? If you are using named instances in sql2000 then mdac 7 is req'd. Also try the following from the server you are having problems registering from. Create a network drive mapping to the other server then try and re-register. If this works then longer term use a net use and set up an IPC$ share. Another thing to try is create an alias via sql client network utility.
February 24, 2004 at 2:12 am
Thanks for the reply harper, I've now managed to sort this problem out. Not sure if this is ideal, but what I did was create a windows user on each machine using the exact same username and password, gave them both admin permissions and now mixed mode security on SQL server works fine!
Thanks again,
Ben
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply