solarwinds Database Manager - Backup

davorsl500

Hi,

I have used SQL Express and I would like to make DB Backup, but I can't add a server in to the DataBase Manager.

I can't choose SQL Server from the list (because doesn't exist) and I can't add local SQL server by entering IP address or Server name neither option (Windows NT Integrated sec or SQL Server UserID and password) doesn't work, can I make DB Backup if I use SQL Express installed on same server with Solarwinds NPM?

 

Regards,

Davor

Yann

Hi,

can't add local SQL server by entering IP address or Server name neither option

The SQL Engine name must be the following:

SERVERNAME\INSTANCENAME or IP\INSTANCENAME or (local)\INSTANCENAME

 

usually the instance name is SQLEXPRESS for SQL Server 2005 Express Edition. So I would bet on (local)\SQLEXPRESS or (local)\SOLARWINDSORION (let me know if I am wrong .

If the SQL Server instance is configured as the default instance, SERVERNAME, IP or (local) itself works.

You can check the name of the instance by following the below steps:

Start > run > SQLServerManager.msc + ok

In SQL Server 2005 Services check the instance name between brackets in the SQL Server service name.

can I make DB Backup if I use SQL Express installed on same server with Solarwinds NPM?

Yes.

You can even install SQL Server Management Studio Express to further manage your database.

HTH,

Yann