Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
gigi_girl
Starting Member
6 Posts |
 Posted - 2013-03-14 : 11:54:31
|
| 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 SQL2008Windows Server 2008VMware thanks,gigi |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2013-03-15 : 05:32:07
|
| 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.htmlJack Vamvas--------------------http://www.sqlserver-dba.com |
 |
|
|
gigi_girl
Starting Member
6 Posts |
Posted - 2013-03-15 : 11:38:06
|
| Thank you, Jack. This is a step in the right direction. |
|
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2013-03-16 : 15:27:26
|
| Your welcome, let us know if there are other questionsJack Vamvas--------------------http://www.sqlserver-dba.com |
|
|
|
|
|
|
Point Application SW to a new Server