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 |
|
wheetomeister
Starting Member
4 Posts |
 Posted - 2004-02-23 : 04:50:53
|
| Hi all,I'm having difficulty with registering a new SQL server acrossa 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 |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2004-02-23 : 05:49:59
|
| It's got through to the server but the message indicates that the user hasn't been granted access to it.Looks like this is an sql server login - maybe you should be using integrated security?.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
wheetomeister
Starting Member
4 Posts |
Posted - 2004-02-23 : 07:10:10
|
| I am indeed already using integrated security, and am logged in as Administrator. I'm assuming there is some kind of security related settings that I need to fiddle with, but as I am somewhat of a newbie I'm not sure what they are!Any ideas? |
|
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2004-02-23 : 07:15:06
|
| Where are you trying to register the server? In enterprise manager?I take it you have the use windows authentication checked.computername looks like the domain. Is it the same domain as the server or is it trusted.Have a look on the server under logins and see if it's there - if not try adding it.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
wheetomeister
Starting Member
4 Posts |
Posted - 2004-02-24 : 04:29:51
|
| Cheers for the help, I've managed to sort this out now.What I did was create a new windows user with admin rightson both machines using exactly the same username and password.Mixed mode security now works fine and I can register bothservers without any problems. |
|
|
|
|
|
|
Can't register another SQL server!