BESX install question. Exchange Management Shell code

Doubt it will help, but have you tried putting a space after "evensexch00" (but before the |) ?

Also it looks like you need to put in a space after "-extendedrights" (before the "Receive-As")

Good point. I thought I had caught all my typo's. Thank you for pointing them out.

Ha, now I get this.
BESXinstall3.jpg

I saw something similar on an SBS-related page, and they suggested to launch powershell using the "run as administrator" right click option in order to prevent the error.

Do think this is what I would have expected to see as my result?? For some reason "False" for Deny and Inherited doesn't seem right but I do not know.
BESXinstall4.jpg

Ok then, running it as Administrator was the way to go.

So I am following all the steps in the powerpoint link I provided above. I have installed the SQL express on the local server with the BESX and also my Exchange 2007. I did the restart and now I get this error. Any ideas.

I really appreciate all your help.

I obviously am not an IT person.
BESXinstall5.jpg

Go into Start->Microsoft SQL Server 2005->Configuration Tools->SQL Server Configuration Manager.  Go into SQL Server 2005 Network Configuration, then you should have an entry that says "protocols".  It may list more than one if you have more than one instance of SQL on the server.  If so, select the instance that corresponds to the Blackberry service.

Once in there, select the entry for TCP/IP and make sure is says  "enabled" next to it.  IF not, change it to enabled and follow any prompts about restarting the SQL services, then re-try the blackberry steps.

Unfortunately TCP/IP was already set to enabled for the "BLACKBERRY" protocol.

is this by any chance an SBS server?  Or is it just the regular version of Windows?

It is running windows server 2003 and exchange 2007.

Can you click OK in that error message and then re-post the screenshot?  I want to see what settings are behind that window.

.
BESXinstall6.jpg

If you go into start->run, type in "services.msc" (without  the quotes), then scroll down to the SQL server entry in the list, make sure it says it is running.  If not, right click on it and choose "start"

It was already running unfortunately.
BESXinstall7.jpg

When you created the SQL Express Blackberry instance, did it ask you to create a username/password?  If so, try clicking the button that says "SQL authentication" and then specifying the login info that you used during the SQL setup.

Going back through the powerpoint I do not see anywhere where I was asked for SQL username/password. I was however asked for information to set up the BESX.
BESXinstall8.jpg

You may need to go into the SQL server instace and configure it for Windows authentication.  I would also check the event logs to see if there are any errors related to SQL that are occuring at the same time as you're getting that error in the BES installation about it not being able to connect to the database.

I am able to get into the BLACKBERRY SQL express using windows auth. Where do I go to check the log files??

Once again thanks for all your help.

I can log into the MSQL express no problem using windows auth. I am not sure why the software can not gain access.
BESXinstall9.jpg

Are you logged in to the computer with the username oasisinfolink when you're running the BES installation?  You may need to make sure they're added in as a SQL user as those error messages indicate that it's not able to connect to the Blackberry instance of SQL using that username.

Yes I am logged into the computer as "oasisinfolink" to install and run the BESX. Logged in as "oasisinfolink" I am able to gain access to Microsoft SML Server Management Studio Express using windows auth shown in the image here. Any ideas??
BESXinstall10.jpg

Here in this image you can see the logins already created and just for fun I just create the bottom one for "evenstime\oasisinfolink" and I still get the error.
BESXinstall11.jpg

Now that you've added that explicit username into SQL, what are the errors that show up in the event logs while you run the BES install?  Before the errors were saying that evenstime\oasisinfolink couldn't connect to SQL but I'd be curious as to what the errors are now.

They are the same. I was thinking the same thing as you.

Can you look in the following location for the SQL error log?

C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG


The exact path that yours is in may vary due to the presence of several instances of SQL.  You'll want to find the path corresponding to the Blackberry instance obviously.

Once you find the log file, open it up and look for the events corresponding to the logon failures that were recorded in the Windows event logs. Within each of those failures, there should be something that says "State" that will give you a number indicating why the logon failure occurred.  The following link gives more info about what each "state" number means:  http://blogs.msdn.com/sql_protocols/archive/2006/02/21/536201.aspx

Error: 18456, Severity: 14, State: 16.
ERRORLOG

Your right there is no "BESMgmt" database to gain access to....
BESXinstall12.jpg

I assumed the DB was already created, but I bet maybe only the SQL instance was created.  I thought that step of the BES process would create it automatically but it appears it's not doing that.  It may have something to do with the fact that you have multiple SQL instances already on the server--maybe it's confusing the setup into thinking that the DB has already been created.

You should be able to manually create the database in SQL but I don't have an official guide with those steps handy right now.

I think you can just right click on "Databases" and create a new one called BESMgmt...

But then what about all the tables that will not be there? Will we assume the rest of the BES install will create those tables?

Hard to say.

I believe it will do that part automatically.

What do you think about this.      

http://www.blackberry.com/btsc/microsites/search.do?cmd=displayKC&docType=kc&externalId=KB18313&sliceId=1&docTypeID=DT_SUPPORTISSUE_1_1&dialogID=439520788&stateId=0 0 439514768

I do have this 'BESMgmt.cfg' file

I haven't seen anywhere where I would have had to do this on my own though.

I think that will work.  Usually you don't need to manually create the database but it definitely seems like that is the issue you're facing, and I don't see any other way around it.

It looks to me like I am still have a database rights or connection issue. This text below was pulled from the log file that was created when attempted to run the BESMgmt.cfg file. It says it is trying to connect to 'database=master' which is there. Maybe I need to give some permissions to that db and try this again. Let me know what you guys think. Maybe it is trying to connect to the default 'master' db in order to create the desired 'BESMgmt' db???  I have no idea. I'm throwing darts here.



[30000] (04/22 16:42:45.402):{0xFE4} [ENV] Running Process: CreateDB.exe, ID: 7892

[30000] (04/22 16:42:45.433):{0x1FF8} CBESDBInstaller::CBESDBInstaller - working directory is [D:\Research In Motion\BlackBerry Enterprise Server 5.0.1\Database]

[30000] (04/22 16:42:45.652):{0x1FF8} Schema is being installed

[30000] (04/22 16:42:45.652):{0x1FF8} Scripts loading from: D:\Research In Motion\BlackBerry Enterprise Server 5.0.1\Database\DBInstallScripts\SqlServer\

[30000] (04/22 16:42:45.652):{0x1FF8} Determining progress bar range

[30000] (04/22 16:42:45.980):{0x1FF8} ADO ConnectionTimeout value = 30s

[30000] (04/22 16:42:45.980):{0x1FF8} ADO ConnectionTimeout for re-initalizing the pool = 45s

[25137] (04/22 16:42:45.980):{0x1FF8} {ConnectionItem::ConnectToDB} Failed to connect.  Connection string is Provider=SQLOLEDB.1;Server=EVENSEXCH00\BLACKBERRY;Database=master;Network=dbmssocn;Trusted_Connection=Yes

[25000] (04/22 16:42:45.980):{0x1FF8} ConnectionItem::ConnectToDB: COM Error 0x800A0BB9 - Unknown error 0x800A0BB9 - Source: "(null)" - Description "(null)" - Command "ConnectionItem::ConnectToDB"

[20000] (04/22 16:42:45.996):{0x1FF8} [CBESDBInstaller::Connect] : Pool failed to initialize

====== END OF LOG ======



BESXinstall13.jpg

I agree with esmith69.  What are the rights of the username you are using?  

I doubt this user is a local admin. Would I do that through 'Computer Management' or Active Directory?? The user is a domain admin.

if the user is a domain admin then they're automatically a local admin. However, the user account you use for the BES installation and for running the BES services should NOT be a local admin.  See the following page for details:

http://www.blackberry.com/btsc/search.do?cmd=displayKC&docType=kc&externalId=KB02276&sliceId=SAL_Public&dialogID=16846392&stateId=1%200%2016850218

sorry...type in my last post.  I meant to say the user should not be a DOMAIN admin.  they definitely need to be a local admin on the BES server though

I did know not to make the user a domain admin but I had not made them a local admin. So that is done, I need to search through the other things on this website you sent. I believe most of that was set through the Exchange Management Shell scripts we ran.

Thanks.

This question has been classified as abandoned and is being closed as part of the Cleanup Program.  See my comment at the end of the question for more details.