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 |
|
oracarun
Starting Member
2 Posts |
 Posted - 2008-11-21 : 06:36:17
|
| hi please help me to solve this...Different issueI am an oracle admin. But our website uses SQL Server Now the issue is the sqlserver was connecting to a TEST DB earlier. Now they want to shift the connection to a PROD DB.I edited the tnsnames to show the new PROD DB connection. And i can tnsping it to verify the connection.I now need to remove the earlier DB connection in sqlserver and have it to connect to the new PROD DBMY sqlserver admin has no clue.So can any1 guide me how to have this connection take effect |
|
|
darkdusky
Aged Yak Warrior
591 Posts |
Posted - 2008-11-21 : 06:47:19
|
| When you say sqlserver was connecting to a Test DB - was it doing this using Linked Server or another method? If its using linked server can you not just drop the old link and create a new one in Server Objects? |
 |
|
|
oracarun
Starting Member
2 Posts |
Posted - 2008-11-21 : 07:29:40
|
| hi siri am an oracle dba.i have no clue about how the setup is done in sql server ..if they are using linked server or not but i will ask them about it.the thing is the sql server admin has no clue about configuringso i need all the help i can get in order to make this connection possible please help me sir... |
|
|
|
darkdusky
Aged Yak Warrior
591 Posts |
Posted - 2008-11-25 : 04:50:13
|
| Check in Server Objects / Linked Servers. If there is a linked server open its properties and direct to new server. |
|
|
|
|
|
|
connection problem