That is fine. I have a couple of quick questions that will help me answer this for you. (Actually, it is a co-worker who understands the SQL module better than I do who asked this)
I think the NetWorker wizard won't show the SQL databases, but we should be able to resolve the name.
I just found the solution. I found that when using MSSQL server 2008 and the networker module you have to install a microsoft sql compatibility software.
As we are discussing this, there is a question as to whether or not the cluster server will allow multiple instance. I beleive you can, but my co-worker is not so sure.
Please let us know if you are able to use two instances or not. I would like to have a firm answer on this.
Mark_Bellows
240 Posts
0
October 13th, 2010 06:00
Good morning, Osk!
I am looking for a clear answer to your question - I have a feeeling you may be correct.
Please be sure you have the correct administration guide for the SQL module. I have attached that file to this post.
You can find the latest version to download at
http://powerlink.emc.com/km/appmanager/km/secureDesktop?_nfpb=true&_pageLabel=default&internalId=0b014066803873f3&_irrt=true
I will try to get you an answer later today.
Mark
1 Attachment
300-008-656.pdf
fernadoroves
1 Rookie
•
44 Posts
0
October 13th, 2010 08:00
Mark, i think i made a mistake with my question. The network names of the virtual servers are rmclsql01 and rmclsql02. The real
problem is that the first one runs a default database instance, but the second one runs a named database instance, that's why
to access it i have to use rmclsql02\sql02.
Still i dont have a clue how to add this client to networker with the configuration wizard. When i do this using the network name rmclsql02,
i can see in Available applications Filesystem and SQL server, but when i go next i receive an error saying Unable to connect to server.
Any ideas of what's possibly wrong?
Thanks!
Mark_Bellows
240 Posts
0
October 13th, 2010 08:00
That is fine. I have a couple of quick questions that will help me answer this for you. (Actually, it is a co-worker who understands the SQL module better than I do who asked this)
I think the NetWorker wizard won't show the SQL databases, but we should be able to resolve the name.
Thank you!
Mark_Bellows
240 Posts
0
October 13th, 2010 09:00
Excellent! I am glad to hear that you resolved the issue!
fernadoroves
1 Rookie
•
44 Posts
0
October 13th, 2010 09:00
Hi mark
I just found the solution. I found that when using MSSQL server 2008 and the networker module you have to install a microsoft sql compatibility software.
i did this and problem solved.
Thanks!
Mark_Bellows
240 Posts
0
October 13th, 2010 10:00
Osk,
As we are discussing this, there is a question as to whether or not the cluster server will allow multiple instance. I beleive you can, but my co-worker is not so sure.
Please let us know if you are able to use two instances or not. I would like to have a firm answer on this.
Thank you!
Mark
Mark_Bellows
240 Posts
0
October 13th, 2010 10:00
Osk,
As a reminder, since this is a SQL cluster, there must be a network name for each named instance, which is the name that has to be used.
Mark
fernadoroves
1 Rookie
•
44 Posts
0
October 13th, 2010 11:00
Mark what we have here is:
Two physical nodes with two virtual servers using MSCluster. We installed a networker client for each physical node
and each virtual server, everyone with their particular IP address and network name. Then in one virtual server we have
a default database instance and in the other one (as our DBA told us) we have a named database instance.
All of this under an active/active configuration. (you can't have two default database instances with MSSQL 2008 and MSCluster).
Greetings
Oskar.
Bebo2k
544 Posts
0
April 11th, 2012 01:00
The Backward compatibility components for SQL Server 2008, which can be downloaded from the following link:
http://www.microsoft.com/download/en/details.aspx?id=16177
Thanks,
Ahmed Bahaa
B4FQqUoIrW12094
60 Posts
0
April 11th, 2012 01:00
Dear OSK,
Can you explain detail about the solution to resolve the same issue
what is mean by microsoft sql compatibility software for networker?
khezami
1 Message
0
December 30th, 2020 07:00
have you solve the problem ? i have the same issue and i dont know how to fixt it