|
Versions SQL-Server: 7.0, 2000, 2005, 2008
Download your installation kit:
SQL_SERVER.ZIP
Server installation
- Create a new database
- Create tables: table.sql
- Insert in database: insert_gb.sql
(Français)
- Create the user who has access to database
SQL-Server 7.0 : replace COLLATE and French_CI_AS by
an empty string
Client installation
Execute the file .reg that suits your SQL installation type (SQL or Windows Authentification):
--> If you server uses a SQL authentification: AUTHENTIFICATION SQL.REG
Then, modify the string "Base" in the registry and precise the name or IP address of your server, the name of your database, the user and password.
"Provider=sqloledb;Data Source=Name of the server or IP address;Initial Catalog=name of the SQL database;User Id=SQL user;Password=Password of the SQL user"
--> If your SQL Server use the Windows authentification: SSPI.REG
Then, modify the string "Base" in the registry and precise the name or IP address of your server, the name of your database
"Provider=sqloledb;Data Source= Name of the server or IP address;Initial Catalog= Name of the database;Integrated
Security=SSPI"
--> If your database is installed in english, you must execute:
EN.REG
|
