MSSQL (Microsoft SQLServer) ConnectionString in ASP/ASP.net:

SQL ODBC connection strings: Standard Security “Driver=; Server=Your_Server_Name; Database=Your_Database_Name; Uid=Your_Username; Pwd=Your_Password;” SQL OLE DB connection strings: “Provider=SQLOLEDB; Data Source=127.0.0.1; Initial Catalog=Your_Database_Name; UserId=Your_Username; Password=Your_Password;” SQL SqlConnection .NET strings: “Server=127.0.0.1; Database=Your_Database_Name; UserID=Your_Username; Password=Your_Password; Trusted_Connection=False” SQL SqlConnection for SQL 2008: “Provider=SQLNCLI10; Server=127.0.0.1; Database=database_name; UId=user_id; Pwd=password;”

Backup MSSQL database with MSSQLDump

1) Download MSSQLDump from http://www.parallels.com.cn/downloads/Prima/Tools/MsSqlDump.zip 2) Place the MSSQLDump file into C:\X 3) Go to command prompt and change the directory to C:\X 4) Run the command MSSQLDump -S localhost -U database_username -P database_password -D database_name -O database_backup.sql -createtable -insertdata

DirectAdmin User Access Levels Explained

DirectAdmin is a control panel comprising three different access level: The Admin Level has full administrative privileges and users at this level will also have access to lower user levels, allowing them to perform any administrative tasks. Resellers come after the Admin Level, mostly being used to create and manage user accounts for end users, to

Installatron – Error: Bytecode Loader Failed. See Troubleshooting For Detail.

Your Installatron Application Installer is broken and needs to be repaired when you receive the following error message. Error: Bytecode loader failed. See troubleshooting for detail   Access your web server via SSH and run the following command: /usr/local/installatron/repair –stable   Once the repair is completed, your Installatron Application Installer has been repaired and will