Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««123»»

Problem with connecting 2 SQl 2005 Servers Expand / Collapse
Author
Message
Posted Tuesday, February 26, 2013 2:15 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, February 28, 2013 3:46 AM
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
Post #1423932
Posted Tuesday, February 26, 2013 2:41 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, February 28, 2013 3:46 AM
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
Post #1423944
Posted Tuesday, February 26, 2013 2:43 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, February 28, 2013 3:46 AM
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
Post #1423945
Posted Tuesday, February 26, 2013 2:45 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, February 28, 2013 3:46 AM
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
Post #1423947
Posted Tuesday, February 26, 2013 2:46 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, February 28, 2013 3:46 AM
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
Post #1423948
Posted Tuesday, February 26, 2013 4:40 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Monday, April 07, 2014 3:56 AM
Points: 200, Visits: 778
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'
Post #1424002
Posted Tuesday, February 26, 2013 5:04 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, February 28, 2013 3:46 AM
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
Post #1424010
Posted Tuesday, February 26, 2013 6:00 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Monday, April 07, 2014 3:56 AM
Points: 200, Visits: 778
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'
Post #1424037
Posted Tuesday, February 26, 2013 6:15 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, February 28, 2013 3:46 AM
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
Post #1424045
Posted Tuesday, February 26, 2013 7:02 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Monday, April 07, 2014 3:56 AM
Points: 200, Visits: 778
OK, thats fine, in that case can you right click and test connection on it?

'Only he who wanders finds new paths'
Post #1424067
« Prev Topic | Next Topic »

Add to briefcase ««123»»

Permissions Expand / Collapse