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
  1. Leave a comment

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: