Unity installation MSDE vs SQL datastore

[tarun.pahuja]

Folks,

Could someone please tell me what are the advantages of installing the complete SQL software for unity install vs only installing the desktop engine. I see couple of documents on Cisco's website that talk about SQL software as oppose to MSDE software on unity server.

Thanks,

[kechambe]

Customers are not allowed to pick one over the other. A Unity system with 32 voice ports or fewer and without failover is licensed only for MSDE 2000, not for SQL Server 2000. Customers are required to install the version in accordance with what they have purchased because Cisco only pays Microsoft for SQL Server 2000 if the configuration requires it.

As long as you install the correct version for your configuration you won't notice a difference.

Thanks,

Keith

[tarun.pahuja]

we have 32 ports right now with failover, we are planning to pump up the unity ports to more than 32.

would their be a problem? can we uninstall msde and install SQL 2000. If i understand it correctly, sql is installed when the port are more that 32. Please elaborate under what circumstances would someone install complete SQL server and not msde.

Thanks,

[amylinit]

Unity with more than 32 ports OR a failover configuration requires SQL. If you have 32 ports or less without failover then you would run MSDE.

Here is a guide to upgrade/downgrade between SQL and MSDE:

http://www.cisco.com/en/US/products/sw/voicesw/ps2237/products_upgrade_guides_chapter09186a0080205a8c.html

[tarun.pahuja]

Folks thanks a ton for your help!

I am having a small issue may be you can help me.

In unified messaging. when we install data store by default it installs MSDE and does not ask for a password for SA account.

the problem is that when i install exchange, it does not let me proceed and tells me that i need to create a password for SA.

How can i overcome this issue?

how can i create a password for sa account without installing the enterprise manager.

Thanks

[Aaron Harrison]

Installing Enterprise Manager will make your life easier in the long run...

However to change your SA password you can just do this:

1) Search your c:\ drive for osql.exe

2) run a command prompt window and change to the osql directory

3) Type

osql -E

then hit enter

4) Type

sp_password NULL, 'password', 'sa'

putting your password in single quotes where I've put password, then hit enter

5) Type

Go

and hit enter

It should say password changed successfully or something like that...

Aaron