|
|
You're in the
sql server clustering
group:Database mirroring - Client redirection
sql server clustering:
i install and configure database mirroring in SQL 2005 with automatic failover. Client aplications use ADO.NET or the native SQL Server client driver to connect to database. I know i have to write next connection string: "Data Source=ServerA;Failover Partner=ServerB;Initial Catalog=AdventureWorks;Integrated Security=True;" but the problem is i dont know where. Is there any file on aplication server that i have to change with this string so that ADO.NET or native SQL client driver will know what the is second server. I am only administrating server and dont know much about programing SQL so i would apreciate any help or link for solution. Thanks
This is a problem on the client side and it depends on how the client
accesses the connection string. If the client hardcodes the connection string, you would have to modify the source code and recompile. Hopefully, this is not case. Often, the client may read the connection string from a config file. In the case, you can just modify the config file. So to find out where, you should ask the owners of the client applications. If you have no clue where you may find the connections strings, chances are you are not the right person to make the change. Linchi [quoted text, click to view] "Peter" wrote:
> Helo, > i install and configure database mirroring in SQL 2005 with automatic > failover. Client aplications use ADO.NET or the native SQL Server client > driver to connect to database. I know i have to write next connection string: > "Data Source=ServerA;Failover Partner=ServerB;Initial > Catalog=AdventureWorks;Integrated Security=True;" > but the problem is i dont know where. Is there any file on aplication server > that i have to change with this string so that ADO.NET or native SQL client > driver will know what the is second server. > I am only administrating server and dont know much about programing SQL so i > would apreciate any help or link for solution. > > Thanks
The problem here is that i have to migrate all database from multi sql server
to one server. Currently there are around 8 aplication who use SQL (wsus, MOM, desktopautority, SIM, sharepoint...). I was hoping that it would be more easy. :) What about NLB with SQL mirroring. I test it today and still aplication didnt want to connect to mirror database. Didnt put a lot of effort yet, but would that work? Thanks. [quoted text, click to view] "Linchi Shea" wrote:
> This is a problem on the client side and it depends on how the client > accesses the connection string. If the client hardcodes the connection > string, you would have to modify the source code and recompile. Hopefully, > this is not case. Often, the client may read the connection string from a > config file. In the case, you can just modify the config file. > > So to find out where, you should ask the owners of the client applications. > If you have no clue where you may find the connections strings, chances are > you are not the right person to make the change. > > Linchi > > "Peter" wrote: > > > Helo, > > i install and configure database mirroring in SQL 2005 with automatic > > failover. Client aplications use ADO.NET or the native SQL Server client > > driver to connect to database. I know i have to write next connection string: > > "Data Source=ServerA;Failover Partner=ServerB;Initial > > Catalog=AdventureWorks;Integrated Security=True;" > > but the problem is i dont know where. Is there any file on aplication server > > that i have to change with this string so that ADO.NET or native SQL client > > driver will know what the is second server. > > I am only administrating server and dont know much about programing SQL so i > > would apreciate any help or link for solution. > > > > Thanks
I'm not up to date with NLB. But if it's still just for load balancing, I
doubt you should configure it with databbase mirroring since database mirroring is not meant for load balancing. Note that the standby is not available, so there is nothing to load balance with. Linchi [quoted text, click to view] "Peter" wrote:
> The problem here is that i have to migrate all database from multi sql server > to one server. Currently there are around 8 aplication who use SQL (wsus, > MOM, desktopautority, SIM, sharepoint...). I was hoping that it would be more > easy. :) > > What about NLB with SQL mirroring. I test it today and still aplication > didnt want to connect to mirror database. Didnt put a lot of effort yet, but > would that work? > > Thanks. > > "Linchi Shea" wrote: > > > This is a problem on the client side and it depends on how the client > > accesses the connection string. If the client hardcodes the connection > > string, you would have to modify the source code and recompile. Hopefully, > > this is not case. Often, the client may read the connection string from a > > config file. In the case, you can just modify the config file. > > > > So to find out where, you should ask the owners of the client applications. > > If you have no clue where you may find the connections strings, chances are > > you are not the right person to make the change. > > > > Linchi > > > > "Peter" wrote: > > > > > Helo, > > > i install and configure database mirroring in SQL 2005 with automatic > > > failover. Client aplications use ADO.NET or the native SQL Server client > > > driver to connect to database. I know i have to write next connection string: > > > "Data Source=ServerA;Failover Partner=ServerB;Initial > > > Catalog=AdventureWorks;Integrated Security=True;" > > > but the problem is i dont know where. Is there any file on aplication server > > > that i have to change with this string so that ADO.NET or native SQL client > > > driver will know what the is second server. > > > I am only administrating server and dont know much about programing SQL so i > > > would apreciate any help or link for solution. > > > > > > Thanks
[quoted text, click to view]
> I'm not up to date with NLB. But if it's still just for load balancing, I > doubt you should configure it with databbase mirroring since database > mirroring is not meant for load balancing. Note that the standby is not > available, so there is nothing to load balance with. ....unless you create a snapshot on mirror database... But in this way you have a secondary db alligned to snapshot time and you could use it only for reporting and other activity that don't require you real time data... It's not properly load balancing but it's a way to reduce some activity on principal database... [quoted text, click to view] > Linchi Ciao -- Luca Bianchi Microsoft MVP - SQL Server http://community.ugiss.org/blogs/lbianchi
[quoted text, click to view]
> ...unless you create a snapshot on mirror database... > But in this way you have a secondary db alligned to snapshot time and you > could use it only for reporting and other activity that don't require you > real time data... > It's not properly load balancing but it's a way to reduce some activity on > principal database... That setup would not make sense at all. On one computer, you have a read/write database and on the other computer you have this snapshot that is read only. If NLB directs a read/write SQL statement to the snapshot computer, you are hosed. And if you statically direct all the read-only queries to the snapshot, you don't need NLB at all. Linchi [quoted text, click to view] "Luca Bianchi" wrote:
> > I'm not up to date with NLB. But if it's still just for load balancing, I > > doubt you should configure it with databbase mirroring since database > > mirroring is not meant for load balancing. Note that the standby is not > > available, so there is nothing to load balance with. > > ...unless you create a snapshot on mirror database... > But in this way you have a secondary db alligned to snapshot time and you > could use it only for reporting and other activity that don't require you > real time data... > It's not properly load balancing but it's a way to reduce some activity on > principal database... > > > Linchi > > Ciao > > > -- > Luca Bianchi > Microsoft MVP - SQL Server > http://community.ugiss.org/blogs/lbianchi
Don't see what you're looking for? Try a search.
|
June 2003
July 2003
August 2003
September 2003
October 2003
November 2003
December 2003
January 2004
February 2004
March 2004
April 2004
May 2004
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
| home · blog · groups | Questions? Comments? Contact the dn |