SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 Other SQL Server 2008 Topics
 Point Application SW to a new Server
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

gigi_girl
Starting Member

5 Posts

Posted - 03/14/2013 :  11:54:31  Show Profile  Reply with Quote
I installed a application on a server and it set all config paths to the database as (local). For security reasons I need to point the application to a database on a different physical server. I have the exact same Database on both servers. Can I simply use regedit (wind ser 2008)and point the config strings to a different IP vs. (local)?

I am using SQL2008
Windows Server 2008
VMware

thanks,
gigi

Edited by - gigi_girl on 03/14/2013 11:58:51

jackv
Flowing Fount of Yak Knowledge

United Kingdom
2011 Posts

Posted - 03/15/2013 :  05:32:07  Show Profile  Visit jackv's Homepage  Reply with Quote
Assuming remote connections are allowed on the target sql server - setting the correct connection details - with correct authentication should allow a connection.
Find out the connection details - and apply to the relevant config file. If you have problems connecting - use the troubleshooting tips on this post to troubleshoot. http://www.sqlserver-dba.com/2012/05/cannot-connect-to-sql-server.html

Jack Vamvas
--------------------
http://www.sqlserver-dba.com
Go to Top of Page

gigi_girl
Starting Member

5 Posts

Posted - 03/15/2013 :  11:38:06  Show Profile  Reply with Quote
Thank you, Jack. This is a step in the right direction.
Go to Top of Page

jackv
Flowing Fount of Yak Knowledge

United Kingdom
2011 Posts

Posted - 03/16/2013 :  15:27:26  Show Profile  Visit jackv's Homepage  Reply with Quote
Your welcome, let us know if there are other questions

Jack Vamvas
--------------------
http://www.sqlserver-dba.com
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.06 seconds. Powered By: Snitz Forums 2000