Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Problem with connecting 2 SQl 2005 Servers


Problem with connecting 2 SQl 2005 Servers

Author
Message
kraig.godden
kraig.godden
Grasshopper
Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)

Group: General Forum Members
Points: 17 Visits: 44
I was reading this thread http://www.sqlservercentral.com/Forums/Topic759989-291-1.aspx and thought it was my answer but still nothing.

http://www.go-train.co.uk
kraig.godden
kraig.godden
Grasshopper
Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)

Group: General Forum Members
Points: 17 Visits: 44
sorry forgot to add i am using the sql SA username as I thought this would have appropriate access rights etc

i used this when setting up internally

http://www.go-train.co.uk
kraig.godden
kraig.godden
Grasshopper
Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)

Group: General Forum Members
Points: 17 Visits: 44
sorry thought i should add I am using the SA sql user account as I thought this has appropriate access rights

I used this account when setting up internally

http://www.go-train.co.uk
kraig.godden
kraig.godden
Grasshopper
Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)

Group: General Forum Members
Points: 17 Visits: 44
sorry thought i should add I am using the SA sql user account as I thought this has appropriate access rights

I used this account when setting up internally

http://www.go-train.co.uk
kraig.godden
kraig.godden
Grasshopper
Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)

Group: General Forum Members
Points: 17 Visits: 44
sorry thought i should add I am using the SA sql user account as I thought this has appropriate access rights

I used this account when setting up internally

http://www.go-train.co.uk
david.alcock
david.alcock
SSC Veteran
SSC Veteran (259 reputation)SSC Veteran (259 reputation)SSC Veteran (259 reputation)SSC Veteran (259 reputation)SSC Veteran (259 reputation)SSC Veteran (259 reputation)SSC Veteran (259 reputation)SSC Veteran (259 reputation)

Group: General Forum Members
Points: 259 Visits: 1157
So when you are on chatsql, you go to replication, local subscriptions...new subscription wizard and put in the servsql in the connect box, thats where the error occurs? And servsql has never been renamed and the credentials are OK.

Did you try creating a linked server connection on chatsql to servsql, and then perhaps try to query it afterwards?

'Only he who wanders finds new paths'
kraig.godden
kraig.godden
Grasshopper
Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)

Group: General Forum Members
Points: 17 Visits: 44
hi David

sorry about the previous post don't know why they have duplicated,

yes i go to replication, local subcription, new subscription etc and this is were i get the error

the mad thing is i can view the remote server etc in the server studio but can't create the replication

i now get

SQL server replication requires the actual server name to make connection to the server.

Connections through a server alias, ip address or any other alternate name are not supported
Specify the actual server names, ServSQL (replication utilities )

I have updated the host file with the ip servsql.domain.local

sorry david i havent tried the linked server connection yet if i am honest i dont know how?

http://www.go-train.co.uk
david.alcock
david.alcock
SSC Veteran
SSC Veteran (259 reputation)SSC Veteran (259 reputation)SSC Veteran (259 reputation)SSC Veteran (259 reputation)SSC Veteran (259 reputation)SSC Veteran (259 reputation)SSC Veteran (259 reputation)SSC Veteran (259 reputation)

Group: General Forum Members
Points: 259 Visits: 1157
Ah right, no worries.

If you go under Server Objects you will see the option for the new linked server, basically set it up with the sql credentials you are using and that will tell us if the server can see the other in the SQL sense.

'Only he who wanders finds new paths'
kraig.godden
kraig.godden
Grasshopper
Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)

Group: General Forum Members
Points: 17 Visits: 44
hi david

right i have right clicked on linked servers and have click on new

when the new linked server dialog box appears

what do i put in the Linked server: as if i put in the server and it throughs up an error about server already exists

server type:

is it sql server or other data source

sorry if these are stupid questions

http://www.go-train.co.uk
david.alcock
david.alcock
SSC Veteran
SSC Veteran (259 reputation)SSC Veteran (259 reputation)SSC Veteran (259 reputation)SSC Veteran (259 reputation)SSC Veteran (259 reputation)SSC Veteran (259 reputation)SSC Veteran (259 reputation)SSC Veteran (259 reputation)

Group: General Forum Members
Points: 259 Visits: 1157
OK, thats fine, in that case can you right click and test connection on it?

'Only he who wanders finds new paths'
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search