Installing MSSQL 2008

[Extornia]

I've made a guide on how to properly install MSSQL 2008 for CABAL

Download:

To view the content, you need to sign in or register

 

[schneemann101]

I have problems to add the Server01 to the Database

TITLE: Microsoft SQL Server Management Studio
------------------------------

Restore failed for Server 'Cabal-Server'.  (Microsoft.SqlServer.SmoExtended)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.50.2500.0+((KJ_PCU_Main).110617-0026+)&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Restore+Server&LinkId=20476

------------------------------
ADDITIONAL INFORMATION:

System.Data.SqlClient.SqlError: The operating system returned the error '5(Zugriff verweigert)' while attempting 'RestoreContainer::ValidateTargetForCreation' on 'C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\Server01.mdf'. (Microsoft.SqlServer.Smo)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.50.2500.0+((KJ_PCU_Main).110617-0026+)&LinkId=20476

------------------------------
BUTTONS:

OK
------------------------------

Edit#
Than I try to add the Original Database file from the release by "Justin Bieber" it works fine.

 

[Onplay]

why not have tutorial how to create database cabal in sql2008 r2 ? and can help create some tutorial how to setting cabal in centos 5.X

 

[Extornia]

why not have tutorial how to create database cabal in sql2008 r2 ? and can help create some tutorial how to setting cabal in centos 5.X

Because it is very simple and anyone should be able to do it? You simply right click and select create new db

 

[toast2250]

Creating and restoring the databases is same as in EP2 guides by TDP.

To view the content, you need to sign in or register

I gues XP Crypt support is not needed?
It was used for registration encryption or something like that?

The code was posted by someone, credits to him.

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go

ALTER  FUNCTION [dbo].[fn_md5] (@data varchar(255)) 
RETURNS CHAR(32)  AS  
BEGIN
	return SUBSTRING(master.dbo.fn_varbintohexstr(HashBytes('MD5', @data)), 3, 32)
END


Exec dbo.cabal_tool_registeraccount 'yourusername' , 'yourpassword'

Im not very exp'ed in this.
I installed on Server 2003, works well. :

 

[Extornia]

Creating and restoring the databases is same as in EP2 guides by TDP.

To view the content, you need to sign in or register

I gues XP Crypt support is not needed?
It was used for registration encryption or something like that?

The code was posted by someone, credits to him.

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go

ALTER  FUNCTION [dbo].[fn_md5] (@data varchar(255)) 
RETURNS CHAR(32)  AS  
BEGIN
	return SUBSTRING(master.dbo.fn_varbintohexstr(HashBytes('MD5', @data)), 3, 32)
END


Exec dbo.cabal_tool_registeraccount 'yourusername' , 'yourpassword'

Im not very exp'ed in this.
I installed on Server 2003, works well. :

You did not need to run that query. If you look into the dbo.cabal_tool_registeraccount query you will see that the new database uses pwdencrypt that hashes in a binary format. Its a SQL feature.

 

[klazerpel32]

Hello, could you tell me which version and edition of your SQL Server 2008? Thank you.