hi

i setuped a OsloMay2009CTP.exe but something wrong..
icould't installRepository Database

i installedmanually Repository Database throughbellow command.

1. mx create /database:Repository /dataFile:"<Path>/Repository.mdf" /dataFileInitialSize:1GB /dataFileMaxSize:"unlimited" /logFile:"<Path>/Repository.ldf" /logFileInitialSize:800MB /dataFileGrowth:100MB /logFileMaxSize:"unlimited" /logFileGrowth:100MB /force

2. mx install Repository.mx /database:Repository /property:RepositoryChangeTracking=+
   
   
   command 1 is successed.
   
   command 2 is failed.
   
   error message is 'column name 'sid' is not exist in aview or table'
   
   please help me..
   
   
   

I've helped molee get a working Repository database installed through a backup of a clean Repository database on a test machine. I had him use the AddPrincipal() stored procedure to add his local administrator account to the Repository after the installation. This seems to work. We were unable to determine why the Repository installation never succeeded. The root problems seems to be a different error that the local Administrator user already existed during the first installation of the Repository.mx and caused the install to fail. The other error was after removing the user and then reinstalling Repository.mx again.

Hi,

What version of SQL Server are you running?

--larsw

---

Lars Wilhelmsen | Senior Consultant | Miles, Norway | Connected Systems MVP | http://larswilhelmsen.com/

hi

Version is a sql server2008(sp1).



thank you.

Hi. Are you still having problems with the Repository installation? I was wondering if you could try the following test.

1. Make sure that you are a sysadmin on the default instance of SQL Server 2008 on your machine.
2. Try the following command-line to install a Repository with a new name, "RepositoryTest" (change the paths if necessary, but these are the defaults for SQL and Oslo):

"c:\Program Files\Microsoft Oslo\1.0\bin\mx.exe" create /database:RepositoryTest /dataFile:"C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\RepositoryTest.mdf" /dataFileInitialSize:1GB /dataFileMaxSize:"unlimited" /logFile:"C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\RepositoryTest.ldf" /logFileInitialSize:800MB /dataFileGrowth:100MB /logFileMaxSize:"unlimited" /logFileGrowth:100MB /force

3. Any errors yet? If not, go into SQL Server Management Studio. Look under databases in the Object Explorer and verify that there is a RepositoryTest database.
4. If the database exists, do the following with full paths again:

"c:\Program Files\Microsoft Oslo\1.0\bin\mx.exe" install "c:\Program Files\Microsoft Oslo\1.0\bin\Repository.mx" /database:RepositoryTest /property:RepositoryChangeTracking=+

5. Did you get the error again?

Let me know the results and I'll see if this gives us any clues to the source of the problem. BTW, I successfully ran both of the above commands on my May CTP install of Oslo.

Thanks.

Jason Roth

hi.

thank you your reply.

RepostoryTest Database is verified.

but When i executed number 4 command, error is occurred.


Error message is "Column name 'sid' is not in the target Table or View"

Thanks

hi.

how to send a trace log file to you??

Hi. Please sendit tojroth <at> microsoft.com. If it is very big, then send me a message at that address, and I'll provide you with an FTP location to upload it to.

Thanks.

Jason Roth

Jason/molee--any more progress here?

.Kraig

I've looked at the trace and a backup of the Repository database (what does get installed) and tried a few other things without success. I am involving others internally to see if they can look at the same information and provide some ideas. I'll include you on those mails. Thanks.

Jason

I've helped molee get a working Repository database installed through a backup of a clean Repository database on a test machine. I had him use the AddPrincipal() stored procedure to add his local administrator account to the Repository after the installation. This seems to work. We were unable to determine why the Repository installation never succeeded. The root problems seems to be a different error that the local Administrator user already existed during the first installation of the Repository.mx and caused the install to fail. The other error was after removing the user and then reinstalling Repository.mx again.

Thank you very much.

I have the same porblem ，thanks for all your help �a title="AVCHD Converter Mac" href="http://www.avchdconverters.com" title="AVCHD Converter Mac">AVCHD Converter Mac