10-24-2013 11:41 PM
Good day Everyone!
Before I start, i'd like to point out that i am new to NetBackup. And our company wants to backup there microsoft SQL database as a client(w/c i have no background with). the OS of the SQL server is windows 2012, which i have upgraded already from NetBackup 7.5 to 7.5.0.6 version for both Master Server (OS is RHEL 6) and Media Server (OS is RHEL 6) as well as for the client (OS is windows 2012). i already followed this technote http://www.symantec.com/business/support/index?page=content&id=TECH39418 but when i tried to backup the SQL database i get the following error.
Solved! Go to Solution.
10-25-2013 02:29 AM
This is wrong:
SQLHOST "\\.\PIPE\MICROSOFT##WID\TSQL\QUERY"
BROWSECLIENT "\\.\PIPE\MICROSOFT##WID\TSQL\QUERY"
I am curious to know why this machine is reporting its own hostname as \\.\PIPE\MICROSOFT##WID\TSQL\QUERY ????
Show this to SQL dba - maybe he/she will be able to tell you why?
Entry should match hostname.
If I look at your policy. it should be wsus2012.
So, replace with these lines:
SQLHOST WSUS2012
BROWSECLIENT WSUS2012
Also add a line in the script with the correct instance name.
INSTANCE <NAME>
10-24-2013 11:57 PM
Please show us screenshots of your steps (similar to the TN).
Did you choose to create a script? If so, please show us the contents of the script.
Have you changed NetBackup Client Service logon account as per the TN under 'Related articles' in the link you have found?
Please also show us the policy that you have created on the master server:
bppllist <policy-name> -U
(command is in /usr/openv/netbackup/bin/admincmd)
10-25-2013 01:57 AM
Here is the script that was generated:
10-25-2013 02:21 AM
Hi NewB,
I read the logs and found out that the problem is because your computer chair is too low.
Thanks,
10-25-2013 02:29 AM
This is wrong:
SQLHOST "\\.\PIPE\MICROSOFT##WID\TSQL\QUERY"
BROWSECLIENT "\\.\PIPE\MICROSOFT##WID\TSQL\QUERY"
I am curious to know why this machine is reporting its own hostname as \\.\PIPE\MICROSOFT##WID\TSQL\QUERY ????
Show this to SQL dba - maybe he/she will be able to tell you why?
Entry should match hostname.
If I look at your policy. it should be wsus2012.
So, replace with these lines:
SQLHOST WSUS2012
BROWSECLIENT WSUS2012
Also add a line in the script with the correct instance name.
INSTANCE <NAME>
10-25-2013 01:39 PM
That's an odd sqlhost name so I did a search and found this:
http://en.wikipedia.org/wiki/Windows_Internal_Database
SQL Server Management Studio Express can be used to connect to an instance of Windows Internal Database using
\\.\pipe\MSSQL$MICROSOFT##SSEE\sql\query
(2003-2008) or\\.\pipe\MICROSOFT##WID\tsql\query
(2012) as instance name. But this will only work locally, as Remote Connections cannot be enabled for this edition of SQL Server.
As Marianne says you need to replace that string with the actual hostname that is recognized over the network.
( SQLINSTANCE keyword can be omitted in which case it points to the default instance. )
11-06-2013 09:33 PM
Hi Guys,
I aplogize for not getting back to you guys soon enough, but i follow the lead you've given me and asked the DBA regarding this matter. And I found out that Windows Server Update Services (WSUS) has an embedded Windows Internal Database which can be access through the SQL Management Studio. that's the reason why the hostname looks like this "\\.\PIPE\MICROSOFT##WID\TSQL\QUERY" and not "WSUS2012" i guess this is more of an embedded configuration issue rather than NetBackup. Anyways, I am very grateful for the both of you for giving me some leads regarding this matter. Thanks you so much.
Regards,
Bapi
11-06-2013 09:51 PM
If your issue is solved, please mark the post that helped you most as Solution?
If more than one post helped you, select 'Request split solution' and select al helpful posts.
This will help other users with similar issues.