Problem with connecting 2 SQl 2005 Servers

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Administering » Problem with connecting 2 SQl 2005 Servers

25 posts, Page 2 of 3

««1 2 3 »»

Problem with connecting 2 SQl 2005 Servers

Rate Topic

Display Mode

Topic Options

Author

Message

kraig.godden

Posted Tuesday, February 26, 2013 2:15 AM

Grasshopper

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

kraig.godden

Posted Tuesday, February 26, 2013 2:41 AM

Grasshopper

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

kraig.godden

Posted Tuesday, February 26, 2013 2:43 AM

Grasshopper

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

kraig.godden

Posted Tuesday, February 26, 2013 2:45 AM

Grasshopper

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

kraig.godden

Posted Tuesday, February 26, 2013 2:46 AM

Grasshopper

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

david.alcock

Posted Tuesday, February 26, 2013 4:40 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Yesterday @ 1:11 PM
Points: 117, Visits: 454

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

kraig.godden

Posted Tuesday, February 26, 2013 5:04 AM

Grasshopper

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

david.alcock

Posted Tuesday, February 26, 2013 6:00 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Yesterday @ 1:11 PM
Points: 117, Visits: 454

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

kraig.godden

Posted Tuesday, February 26, 2013 6:15 AM

Grasshopper

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

david.alcock

Posted Tuesday, February 26, 2013 7:02 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Yesterday @ 1:11 PM
Points: 117, Visits: 454

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 »

25 posts, Page 2 of 3

««1 2 3 »»

Permissions