Solved!
Go to SolutionHH
Hamilton.Hanco
14 Posts
0
1362
February 23rd, 2016 13:00
NW9: Cant see the DB through NW console
Hi Everyone,
I have this lab set at a esxi:
- NW9 at Windows 2008R2
- SQLExpress2008 at Windows 2008R2
I already install the NMM on the SQL server and also the agent.
I can add the SQL server as a filesystem server, browse the folders and take backups, BUT when trying to add the SQL as a SQLserver it doesnt let me expand the server and neither click next, I cant see the DB.
Aditionally, I run the backup from the SQL module and it works fine
I already did the all these with NW8.2 environment and everything works fine. Am I missing something??
671
0
Posted February 23rd, 2016 20:00
As these are different mechanisms, this is not possible.
The standard client setup is for filesystem clients only.
671
0
Posted February 24th, 2016 06:00
I know that
that's why I installed the Networker Module for Microsoft as well.
As I said I did the same steps on a NW 8.2 environment and it works fine; this mean I can browse the databases.
671
1
Posted February 24th, 2016 07:00
Hello hamihamiha
Please try to manually register the "Remote Agent" by running the following commands on the SQL client:
First make sure we update the VSS Writers information in the nsrladb by running:
vssclupdate
Then register the agent by running:
nsrnmsqlra -i
(nsr nmsql ra)
If it fails then go to the installation path for NMM in command prompt and run it from there.
Thank you,
Carlos
671
0
Posted February 24th, 2016 07:00
Well, so much has changed on the NW9. it might be just a cosmetic bug, i would recommend you to reach the support to see if a bug report has already been file on this.
671
0
Posted February 24th, 2016 08:00
Hi Carlos,
I ran the commands, but still cant browse the databases
671
0
Posted February 25th, 2016 02:00
I suspect your issue is that wizard might work well with real SQL, but not so well with Express version of it.
671
1
Posted February 25th, 2016 03:00
Hello hamihamiha
Also please make sure you disable UAC in all servers of the farm (WFE and SQL)
Also yes, thanks Hrvoje, I didn't read the SQLExpress option.
Try with UAC disabled and let us know.
Thank you,
Carlos
Hamilton.Hanco
14 Posts
671
0
Posted February 25th, 2016 09:00
Hi everyone,
After trying some stuffs I figured out that adding the client by IP doesnt work so well, so I have to add it by HOSTNAME; for that I had to add the IP and hostname into the HOSTS file in both servers(since I dont have an domain implemented)
I deleted the client 192.168.1.114 and then added it again using the HOSTNAME.... and now I can browse the databases.
Thanks to all!