- Community Home
- >
- Networking
- >
- Wireless
- >
- M and MSM Series
- >
- Re: Using SQL Express for Guest Management Softwar...
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-14-2011 09:29 AM
01-14-2011 09:29 AM
Using SQL Express for Guest Management Software database?
GMS 5.4 lists support for MS SQL 2005 and 2008 in the documentation, but does not specifically say anything about SQL Express. Can SQL Express be used as the DB for the Guest Management software?
I ask because I have a customer that does not have a database server that has direct access to their MSM 760 controller, but they would like to have multiple stations manage guest accounts. They are willing to set up an older PC, but they don't want to spend a load on server and SQL licensing just to authenticate guest users.
Thanks in advance for any insight anyone can provide here.
-Jon
- Tags:
- SQL
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-24-2011 10:17 AM
01-24-2011 10:17 AM
Re: Using SQL Express for Guest Management Software database?
To answer my own question, Yes, SQL Express can be used.
One issue I ran in to was using the default settings during the SQL Express setup, it will set up a named instance of SQL called 'SQLExpress'. This caused me a bit of a headache at first because I had to call the reference the database server as '.\SQLExpress' in the GMS config.
You will also have to give your GMS account db_creator and db_owner roles in the GMS database you set up.
-Jon
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-19-2011 08:21 AM
10-19-2011 08:21 AM
Re: Using SQL Express for Guest Management Software database?
Hi,
I am having a similar issue with the GMS software and SQL Express 2005
There is an existing instance called BKUPEXEC on the server which is used by the backup software.
I have created a new empty database called 'gms' and also a user called 'gms'
gms has db_owner role and is a db_creator on the server
On the config screen the for the guest management software I have chosen Microsoft SQL Server and now need to know the correct format for the hostname etc
I have tried using just the hostname, also tried .\BKUPEXEC and SERVERNAME\BKUPEXEC but nothing works
I can connect fine if I setup an ODBC connection using the same credentials. Help please!!!! :-)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-19-2011 09:20 AM
10-19-2011 09:20 AM
Re: Using SQL Express for Guest Management Software database?
Im having the same issue with MSSQL2005.. created a dbuser and db with the right credentials (tested with sql client), but still the GMS tells me it cannot connect to the database.
My server also have instances but I didnt know if GMS even supported instances so I created the database in the "default" instance. I've opened a case to HP support today, waiting to hear back from them.
CCIE Service Provider
MASE Network Infrastructure [2011]
H3CSE
CCNP R&S
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-19-2011 09:58 AM
10-19-2011 09:58 AM
Re: Using SQL Express for Guest Management Software database?
OK please let me know if you find an answer
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-03-2012 11:10 AM
07-03-2012 11:10 AM
Re: Using SQL Express for Guest Management Software database?
Also have the same issue, when connecting I just get an error
"GMS cannot access database"
I have made a new database and new user with correct roles/permissions but still no joy
GMS ver "GMS_5.5.0.1_B136" but have also tried other versions. SQLExpress2008
HELP
Pete
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-04-2012 05:56 AM
07-04-2012 05:56 AM
Re: Using SQL Express for Guest Management Software database?
I have managed to connect after making the foloowing change.
On the SQL 2008 server under TCP/IP check that the IP ALL section has TCP 1433 set. I had set up interface for this but not the IP ALL
All working
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-13-2012 06:47 AM
08-13-2012 06:47 AM
Re: Using SQL Express for Guest Management Software database?
Thanks!!!
i´ve also had this problem ... your tip rescuses my day :-)
SQL-Server Config manager -> Protocols -> TCP/IP -> IP-Addresses -> IPAll-Interface , TCP: 1433
Thanks
Tobias
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-03-2012 04:01 AM
10-03-2012 04:01 AM
Re: Using SQL Express for Guest Management Software database?
Great advice, gonna give it try now.
Thanks fellas.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-03-2012 04:30 AM
10-03-2012 04:30 AM
Re: Using SQL Express for Guest Management Software database?
One additional thing that is probably worth checking guys.....
when making the IPALL changes above, check that the individual IP interfaces are enabled as well as active in the Srvr Config Manager - SrVR Network COnfig - Protocols - TCP/IP - IP Addresses tab.
mine now works....
Thanks for your help fellas.