Archive for September, 2011

Some additional tips n’ tricks if using SQL Server 2005 Express with IBM Systems Director

I had a client who wished to use SQL Express 2005 for it’s Director database.   SQL Express (with SP3) is downloadable from here and you’ll want to also get the SQL Server 2005 Management Studio Express (SSMSE).

Once it’s installed you can create your SQL database for IBM Systems Director as I’ve blogged previously.

However, when you use the cfgdbcmd.cmd I was receiving a number of SQL connectivity errors.  By default SQL 2005 Express doesn’t allow remote connectivity which is needed by SQLCMD, so you need to follow these instructions from Microsoft to turn this on – http://support.microsoft.com/kb/914277

Once I followed these steps I was still having problems !  So I tried to telnet to my local SQL server on port 1433 and my SQL server wasn’t responding.

In the Event Viewer, I could see that for MSSQL$SQLEXPRESS it informed me that “Server is listening on [ ‘any’ <ipv4> 55558]”   I then went into the SQL Server Configuration Manager, Protocols for SQLEXPRESS, TCP/IP and I changed the setting IPAll from 55558 to 1433.  After restarting the SQL service I could then perform a telnet localhost 1433  !

Now, when I ran the cfgdbcmd.cmd command, it successfully connected to SQL and changed my default Director database from Apache to SQL Express.

Note, my cfgdbcmd.rsp for SQL is included here:

DbmsApplication = SQLServer
DbmsTcpIpListenerPort = 1433
DbmsServerName = DirectorServerName.ad.mel.stg.ibm
DbmsDatabaseName = IBMDirector
DbmsInstanceName = SQLEXPRESS
DbmsUserId = DOMAIN\svc-ibmdirector
DbmsPassword = yourpasswordhere
DbmsDatabaseAppHome = C:\Program Files\Microsoft SQL Server JDBC Driver 3.0\sqljdbc_3.0\enu
DbmsIntegratedSecurity = true

I hope this helps you if you’re using SQL Express 2005 !

Advertisements

Leave a comment