Absent Member.
Absent Member.
5749 views

How to configure a remote SQL Server Express database to store WebInspect scan data

TITLE:

How to configure a remote SQL Server Express database to store WebInspect scan data





ISSUE:

Your WebInspect™ 7.x machine runs low on memory when running scans
and you would like to configure another remote machine's SQL Server
Express database to receive data from WebInspect.




SOLUTION:

Follow the procedure below on the remote database machine:



1. Enable all protocols in the SQL Server Configuration Manager by
going to Start > Programs > Microsoft SQL Server 2005 >
Configuration Tools > SQL Server Configuration Manager. The
protocols are listed under the SQL Server 2005 Network Configuration
(tree) > Protocols for SQLEXPRESS


2. Open the SQL Server 2005 Surface Area Configuration utility by
going Start > Programs > Microsoft SQL Server 2005 >
Configuration Tools > SQL Server 2005 Surface Area Configuration.



3. Click "Surface Area Configuration for Services and Connections" and select "Remote Connections."



4. On the right side, select the "Local and remote connections" option and then select "Using both TCP/IP and named pipes."



6. Click Apply, then OK.



7. Restart the SQL Server 2005 (SQLExpress) service. You may need to restart the computer.



8. To test your connection, use SQL Server Management Studio
Express on the WebInspect machine to log into the remote SQL Server
Express database.



Notes:

- You will need to start the SQL Server Browser Service and allow port 1433 (for SQL traffic) if you are using Windows Firewall.

- Also ensure the user within SQL Server Express has db_creator and db_owner permissions.



Labels (2)
0 Likes
2 Replies
Cadet 3rd Class
Cadet 3rd Class

How to configure webinspect enterprise with another sql server port?

0 Likes
Admiral Admiral
Admiral

You responded to an article for a very old version of WebInspect - and your question is about WebInspect Enterprise so be aware that this is essentially a new topic (and WebInspect Enterprise connected to a SQL Express database is an unsupported configuration), but to answer the question, when you are prompted in the WebInspect Enterprise initializer for the database sderver name, simply follow that by a comma and the desired port.

0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.