MS Sql Server 2005 Express setup

MS Sql Server 2005 Express setup (Full Version)

All Forums >> [Network Security] >> GFI EventsManager

Message

ef -> MS Sql Server 2005 Express setup (30.Jun.2008 10:42:50 AM)
I need to install MS SQL Server 2005 Express Edition with Advanced Services Service Pack 2 (Italian) on the same machine on which GFI EventsManager 8 and its ReportPack will be installed (W2k3 SP2 Ita). Are there any suggested settings regarding Service Account details, Authentication method and User instances? On KBID002785 they aren't specified, so I would like to have some advice, if possible. Thank you.

spidermouse -> RE: MS Sql Server 2005 Express setup (1.Jul.2008 5:54:55 AM)
nothing really. all I can think of is this: - the sql browser service must be running (otherwise EVM can't find it) - in EVM, you can change the type of login from windows integrated to SQL, so that doesn't matter either. - allow named pipes in the SQL surface configuration, otherwise you will need to work with IP adreses instead of server names. that's pretty much it...

ef -> RE: MS Sql Server 2005 Express setup (2.Jul.2008 7:23:45 AM)
Hi, thank you for your answer. I installed MS SQL 2005 Exp Adv Ita Sp2 using Default Instance, Local System as Service Account, Windows Authentication Method, User instances enabled and let SQL Server Browser service also starting automatically. Then enabled Named pipes only for both MSSQLSERVER and Sql Native Client protocols and restarted services. GFI EVM setup wizard immediately alerted it "did not detect Microsoft SQL server on this machine" and suggested to download and install it. I tried enabling also TCP/IP for both protocols (listening on all addresses, default port), restarted services, checked that the sqlservr.exe process was listening on 0.0.0.0:1433 TCP socket, but same results. Am I missing something? Edit: MS Windows Firewall is disabled also.

spidermouse -> RE: MS Sql Server 2005 Express setup (2.Jul.2008 7:31:11 AM)
Unlikely. But I am a bit stumped that EVM should warn you that SQL is not installed on that machine. After all, what should stop you from using an SQL which is running on another machine altogether? If it's just an informationbox during the installation, then I'd ignore it and install WEVM and configure the SQL from within the EVM UI. One more thing: with SQL Express, you allways need to use <servername>\<instancename>, i.e. "SRV01\SQLEXPRESS". "SRV01" on its own will not work when you configure the DB in the EVM UI.

ef -> RE: MS Sql Server 2005 Express setup (2.Jul.2008 8:26:53 AM)
Ok, I ignored the warning, the setup wizard tried to download the MS Sql 2005 exp installation file (failed, as this server is denied access to the internet, but it wasn't pointed out...) and ended with the error "Failed to update backend database" (although the user running the setup wizard was member of the sysadmin role on MSSQL). Then I configured the backend DB from the GFI EVM GUI, specified the server name only (without the SQL EXPRESS instance name as you suggested, the sqlcmd -L showed I didn't need it, remind I installed MSSQL with the default instance name) and both main and backup DBs were successfully created. To summarize my experience: - setup wizard doesn't find MS SQL 2005 Exp installation on the same machine (is it an internazionalization issue?) - setup wizard doesn't point out when MS SQL 2005 Exp download fails - MS SQL 2005 Exp seems to work when installed using the default instance, Local System as Service Account, the SQL Service Browser running or not, Windows Authentication method (no need to activate Sql Server Authentication), Named Pipes for both MSSQLSERVER and Client Protocols (TCP/IP not needed) and sysadmin role for the user running the GFI EVM console. Now I would like to know: - does any other admin wanting to configure DB backend from the EVM GUI need to have sysadmin role too on MSSQL? - does the GFI EventsManager Service Account need to have sysadmin role too on MSSQL? Thank you.

ef -> RE: MS Sql Server 2005 Express setup (3.Jul.2008 1:38:08 PM)
Any replies from GFI technical support?

ef -> RE: MS Sql Server 2005 Express setup (4.Jul.2008 6:51:02 AM)
I did another test: I removed the previous installation, downloaded the 8.1 EVM revision and installed the product (in a domain admin security context with sysadmin role on MSSQL2005), but this time I selected a different service account for the GFI EventsManager service, member of the Domain admins Windows security group and member of the sysadmin role on MSSQL2005. As before, the setup wizard didn't find existing MS SQL 2005 Exp installation on the same machine, didn't warn that MS SQL 2005 Exp download failed and ended the installation warning "Failed to update backend database". From the EVM console, I successfully configured the back-end DB, but the GFI EventsManager refused to start, both from the EVM console and from the Services MMC snap-in. I checked that password was correctly entered for the service account and that this account was granted the "Logon as a sevice" user right. Error is 1053, event ID is 7009, Source Service Control Manager. When I changed the service account to the same user interactively logged on (same used for EVM installation), the service started. Is it a bug? How to use a different EVM service account than the same used for installation?

imatone -> RE: MS Sql Server 2005 Express setup (4.Jul.2008 12:18:13 PM)
That was exactly what we had experienced two weeks ago. At first we thought the incident was some kind of timeout issue of W2K3 which has a default 30,000 millisecond and according to another user from this forum, changing a dword or something in a registry value to 60,000 would fix the problem. We didn't try that b/c using another domain admin account the services somehow started normally! Is it a bug? I think so and I believe it happens only on a member server. Is yours a member server?

ef -> RE: MS Sql Server 2005 Express setup (4.Jul.2008 5:33:22 PM)
Yes, it is. GFI tech support? I can't fill the support request form, mine is an evaluation product only.

LeoSanchez -> RE: MS Sql Server 2005 Express setup (7.Jul.2008 12:34:02 PM)
Hello ef, Even if you are evaluating you can still submit a support request online. Please select the 'Evaluation' radio button and where it asks for customer ID please enter 'EVAL' as your ID. Once we receive your support request we will address your issue in a timely fashion.

ef -> RE: MS Sql Server 2005 Express setup (8.Jul.2008 6:50:28 AM)
Thank you, a case was opened.

ef -> RE: MS Sql Server 2005 Express setup (11.Jul.2008 12:55:49 PM)
It seems that the key is installing the GFI EVM product logging on the machine with the same Domain Admin user account that will be specified as service account for the GFI EventsManager service. You can't modify this service account later, otherwise the service will not restart. I think that this should be specified in the installation procedure. This Domain Admin doesn't need the sysadmin role added explicitly on MSSQL2005 (probably it's inherited from the BUILTIN\administrators which should be member of the sysadmin role yet).

Page: [1]