08-21-2008 11:19 AM
I'm installing a new copy of BES on a server and it says it can't see the exsiting SQL 2005 that's installed on the server.
Any ideas ... the walk thru and the install guide don't address this. I don't know much about SQL but the tool is called,
Microsoft SQL Server Management Studio Express.
08-21-2008 12:51 PM
Log into the SQL server and add account besadmin with dbcreator, server admin and sysadmin roles
create a DB called besmgmt
make besadmin owner of it
Log onto sql with besadmin account
Set up the data base with the createdb file(hopfully you copied the datbase folder from the install files to the sql server first)
Then when done have the BES connect to SQL and continue with the install.
08-21-2008 02:02 PM
If you've installed SQL 2005 Express edition, the sql server name is not simply SERVERNAME or LOCALHOST or IP ADDRESS, but rather:
By default SQL Express 2005 installs as an instance and not as the default instance. Specify WHATEVER\SQLEXPRESS and you should be able to connect happily.
08-21-2008 05:05 PM - edited 08-21-2008 05:06 PM
SQL 2005 or express is also locked down a bit during install
IIRC You have to enable protocols TCP/IP,Nammed pipes in order for BES to connect to it.
08-21-2008 08:55 PM
09-02-2008 11:02 AM
OK, so now I'm lost ! (grin) I just got back from a road trip and want to try to get the BES going this week.
I logged on to my server and opened the tool in the SQL called: MS SQL Server Mgmt Studio Express - the exe.
It opened a login to: SERVER\BKUPEXEC using my servers admin account .... so now what ?
09-02-2008 12:45 PM
09-12-2008 12:45 PM
OK, so I made a new database in this SQL Server Management Studio Express program called: BESMGMT and the owner of it is the user on the server called VAUNTCOM \ BESAdmin ....... there is a bunch of folders under it called:
- Database Diagrams
Can anyone clarify with this create db file or program is?
09-12-2008 04:49 PM