InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 19 Jun 2013 19:20:30 GMT20http://www.sqlservercentral.com/Forums/Topic1423113-146-1.aspxyes i am using full unc path but how do you setup authentification as they are on two different domainsI can browse the folder after i inputdomain\username passwordWed, 27 Feb 2013 03:49:45 GMTkraig.goddenhttp://www.sqlservercentral.com/Forums/Topic1423113-146-1.aspxYou do need permissions to the folders, also, are you using the full UNC path for the folders?Wed, 27 Feb 2013 03:46:43 GMTdavid.alcockhttp://www.sqlservercentral.com/Forums/Topic1423113-146-1.aspxHi Davidwell i seemed to have progressed on it seems like it was a issue with alias on the local and remote sql but i seem to be having problems with permissions now.I have setup the subsciption etc on the remote sql which was fine but I notice that it wasnt syncing the tables so i clicked on view sync status and it displays the process could not connect to the distributerthe agent could not be startedwhen i google this message it seems like it is a permission problem but know on the servsql it will only run the server agent on local system and not on the domain admin account which is strange as it was working fine.i have looked at the properties of the distrubuter on the subcription and made sure that the snapshot folder is unc etc and tried changing the connection permissions to the sql sa username and the domain user account but still nothing Wed, 27 Feb 2013 02:35:02 GMTkraig.goddenhttp://www.sqlservercentral.com/Forums/Topic1423113-146-1.aspxI would check if server 2 (the subscriber) has visibility of server 1 that way. Looks like there's something inbetween that just hasnt worked, its not replication specific per say but other than that I'm not too sure I am afraid.Tue, 26 Feb 2013 08:55:47 GMTdavid.alcockhttp://www.sqlservercentral.com/Forums/Topic1423113-146-1.aspxok sorry i am alittle confused am i putting in the remote server or the local server name for the LInk server:also am i putting in the ip or server name and am i just selecting to connect by sql and not another datasourcealso when i try either local or remote server name i get the test connection to the linked server failedan exception occured while executing a transact - sql statement or batchTue, 26 Feb 2013 07:31:07 GMTkraig.goddenhttp://www.sqlservercentral.com/Forums/Topic1423113-146-1.aspxOK, thats fine, in that case can you right click and test connection on it?Tue, 26 Feb 2013 07:02:17 GMTdavid.alcockhttp://www.sqlservercentral.com/Forums/Topic1423113-146-1.aspxhi davidright i have right clicked on linked servers and have click on new when the new linked server dialog box appearswhat do i put in the Linked server: as if i put in the server and it throughs up an error about server already existsserver type:is it sql server or other data sourcesorry if these are stupid questionsTue, 26 Feb 2013 06:15:50 GMTkraig.goddenhttp://www.sqlservercentral.com/Forums/Topic1423113-146-1.aspxAh 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.Tue, 26 Feb 2013 06:00:18 GMTdavid.alcockhttp://www.sqlservercentral.com/Forums/Topic1423113-146-1.aspxhi Davidsorry 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.localsorry david i havent tried the linked server connection yet if i am honest i dont know how?Tue, 26 Feb 2013 05:04:37 GMTkraig.goddenhttp://www.sqlservercentral.com/Forums/Topic1423113-146-1.aspxSo 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?Tue, 26 Feb 2013 04:40:28 GMTdavid.alcockhttp://www.sqlservercentral.com/Forums/Topic1423113-146-1.aspxsorry 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 internallyTue, 26 Feb 2013 02:46:42 GMTkraig.goddenhttp://www.sqlservercentral.com/Forums/Topic1423113-146-1.aspxsorry 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 internallyTue, 26 Feb 2013 02:45:37 GMTkraig.goddenhttp://www.sqlservercentral.com/Forums/Topic1423113-146-1.aspxsorry 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 internallyTue, 26 Feb 2013 02:43:26 GMTkraig.goddenhttp://www.sqlservercentral.com/Forums/Topic1423113-146-1.aspxsorry forgot to add i am using the sql SA username as I thought this would have appropriate access rights etci used this when setting up internallyTue, 26 Feb 2013 02:41:15 GMTkraig.goddenhttp://www.sqlservercentral.com/Forums/Topic1423113-146-1.aspxI was reading this thread http://www.sqlservercentral.com/Forums/Topic759989-291-1.aspx and thought it was my answer but still nothing.Tue, 26 Feb 2013 02:15:19 GMTkraig.goddenhttp://www.sqlservercentral.com/Forums/Topic1423113-146-1.aspxwell i did go down this route last night as i did read somewhere that it could be down to the server name but its was as expectedserver 1 is called servsqlserver 2 is called chatsqli have created alias for both on server one but still no joy I have also tried connecting with servsql.domain.localbut still get an error messageTue, 26 Feb 2013 02:13:38 GMTkraig.goddenhttp://www.sqlservercentral.com/Forums/Topic1423113-146-1.aspxJust out of interest, from management studio on server B what do you get when you typeSELECT @@SERVERNAME is it the expected?Tue, 26 Feb 2013 02:06:14 GMTdavid.alcockhttp://www.sqlservercentral.com/Forums/Topic1423113-146-1.aspxWell of course that depends what you are doing! I was just double checking that server A can connect to server B directly, I know you can access server B through SSMS but can you set up server b as a linked server with the sql authentication on server A (apologies if you've told me you can already btw). Does the sql user have the adequate rights to use the replication objects?I did read about a potential fix where you can have a server alias whereby the alias name is exactly the same as the server name but that was some late reading and I would perhaps rule out the potential simpler issues first.Tue, 26 Feb 2013 02:02:42 GMTdavid.alcockhttp://www.sqlservercentral.com/Forums/Topic1423113-146-1.aspxHi DavidI am doing it with SQL authentification as to the linked server like i have said I am very new to sql so I have only setup replication and that worked just perfect for me internally this is why i have gone down this route.I was recommended to go down the replication route but please tell me if you think i would be better to go down the linked route.the thing that i dont get is in sql management Studio i can connect to the remote sql server and access all tables etc its just getting the replication to work.thanksTue, 26 Feb 2013 01:18:25 GMTkraig.goddenhttp://www.sqlservercentral.com/Forums/Topic1423113-146-1.aspxMay I ask, are you connecting to server 2 with windows or sql authentication? Can you set up a linked server on server 1 to the subscription server with the same credentials?Mon, 25 Feb 2013 15:19:37 GMTdavid.alcockhttp://www.sqlservercentral.com/Forums/Topic1423113-146-1.aspxHi David thanks very much for your help so far well i have tested all replication from two sql 2005 servers internally and all works fine so all i have done is replicated this to two servers that are in two external locationsServer 1 being the publisher and server 2 taking the subscriptions what i need to add is they are connected to two different domains and connected by a vpnI haven't got a script to authenticate is this what I am missing? I have added the ip and name to the host file for both servers enabling me to browse files with a username and password etcthe new error i am getting now when i try and setup replication points to a updated server name but this is not the case for me and the server name has never changed.I can also connect to the remote server from Sql management consol but just cant setup replicationi hope this helpsMon, 25 Feb 2013 10:12:43 GMTkraig.goddenhttp://www.sqlservercentral.com/Forums/Topic1423113-146-1.aspxMay I ask, I suppose in a step by step way, what you have done so far to set up replication ?Mon, 25 Feb 2013 07:38:07 GMTdavid.alcockhttp://www.sqlservercentral.com/Forums/Topic1423113-146-1.aspxHi Thanks for the reply yes it was off but I have enabled it now and when i go to setup replication i am getting the following error message SQL Server Replication requires the actual server name to make a connection to the server.connections through a server alias,ip address or any alternate name are not supported.Specify the actual server name, "servername" replication utilitiesI am using servername.domain.local to connect, i can browse the server fine by going to start run servername.domain.local.so i am alittle confused as to why i would be recieving this message when i am using the right server name etcby the way as you can tell i am very new to sql serverthanks again Mon, 25 Feb 2013 05:12:40 GMTkraig.goddenhttp://www.sqlservercentral.com/Forums/Topic1423113-146-1.aspxSQL Browser service running on server 2?Mon, 25 Feb 2013 03:35:27 GMTdavid.alcockhttp://www.sqlservercentral.com/Forums/Topic1423113-146-1.aspxHiI am running SQL 2005 Standard edition under Windows Small Business Server 2003.Everything, that I need runs just fine from local LAN clients. The problem is, i am installing another sql 2005 in another location i am trying to replicated data from server 1 go server 2 which i have connected via a vpn, I can ping and browse server 1 but I can't connect to the SQL server with Server Management studio. Everytime I try to connect, the connection ends up in error message:TITLE: Connect to Server------------------------------Cannot connect to sql.domain.local------------------------------ADDITIONAL INFORMATION:An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 53)For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=53&LinkId=20476server 1windows server 2003Sql 2005 standard all service packs etc192.168.10.1 vpn connectedserver 2windows server 2003Sql 2005 standard all service packs etc192.168.10.5 vpn connectedI have google searched this problem and tried all user recommendations I've found.- I have correctly forwarded ports on my router (e.g. I can access the remote desktop from remote places without problem)- The Windows firewall is well configured, I have added ports 1433, 1434 and I've tried it even with windows firewall turned off.- I have enabled all protocols needed and revised all setting concerning remote connections within configuration manager and surface configurationNothing has helped.Please guys if you have any recommendations for me i would be very gratefulAny kind of help will be highly appreciated.Fri, 22 Feb 2013 09:02:09 GMTkraig.godden