SQL Server 2008 Express: Change Server Collation
If you managed to get in trouble as I did, because you have different database and server collation (yes, there is a difference between server and database collation) and you use SQL Server 2008 Express, then you’ve found the right place to solve your problem.
How to get the setup.exe mentioned all over internet for standard SQL Server 2008:
- Start the SQL Server Express installer
- Wait until the extraction dialog is closed and you can see the installation window
- The installer will extract all the setup files into c: drive, the directory name can be easily found by looking for a mess of digits and letters
- Copy the content to a different directory (when you close the installer the content extracted by the installer will be removed)
- Close the installer (because there can’t be 2 installers running at the same time)
- Now you have the setup.exe available and you can run the old good rebuild command
setup.exe /Quiet /ACTION=REBUILDDATABASE /INSTANCENAME=MSSQLSERVER /SAPWD=[newpd] /SQLSYSADMINACCOUNTS=[machinename]\Administrators SQLCOLLATION=SQL_Latin1_General_CP1_CS_AS
where:
[nepwd] is new sa account password
[machinename] is the machine name to use the administrators group from
PLEASE NOTE:
You have to reattach your databases and recreate the logins, e.g. by running:
EXEC sp_change_users_login ‘Auto_Fix’, ‘user’, ‘login’, ‘password’
oracle impdb remap_schema with additional space
Posted by admin in Software & Development on 2011-12-08
Today, I tried to run impdb with remap_schema:old_owner:new_owner syntax and I ended up with empty database and plenty of errors.
The problem was that impdp tried to import from “old_owner” to “new_owner “. Do you see the difference? One additional space, because impdp somehow misunderstood the parameter separator as a part of new_owner.
Problem occurs in case of oracle 11.20 @ solaris. Solution is to provide remap_schema as a last parameter.
Confluence NTLM/SSPI (Domain Trusted Login) using Apache HTTP Server
Posted by admin in Plugins & translation on 2011-07-28
I also had some time to finish the article of How to authenticate users in Confluence using the Domain account without using jcifs to actually authenticate (it’s used only to get the user details after he/she had been authenticated).
If you have any questions or problems, just contact me.
This topic may also be known as:
- Confluence SSO
- Confluence Single Sign-On using Domain Account
- Confluence NTLM
JIRA NTLM/SSPI/SSO (Domain Trusted Login) using Apache HTTP Server
Posted by admin in Plugins & translation on 2011-07-26
Finally, after one year I had some time to finish the article of How to authenticate users in Jira using the Domain account without using jcifs to actually authenticate (it’s used only to get the user details after he/she had been authenticated).
If you have any questions or problems, just contact me.
