- MS SQL 7.0 administration -

Denne vejledninger beskriver hvordan man administrerer en MS SQL 7.0 database.

Lav en System DSN (Data Source Name) og brug derefter MS Access eller Enterprise Manager fra MS SQL 7.0 CDen. Proceduren er lidt forskellig afhængig af operativsystem og sprog. Den er beskrevet nedenstående for en engelsk Windows 2000 Professional, bruger du et andet system kan der altså være mindre forskelle. Enterprise Manager giver dig en del flere muligheder end MS Access, men kan kun bruges hvis du har din egen MS SQL 7.0 CD eller adgang til at låne en. Enterprise Manager er gratis men da den kun ligger på samme CD som MS SQL 7.0 serveren, kan vi desværre ikke udlevere den.

Tilføj en System DSN til din maskine

  1. Start/Settings/Control Panel/Administrative tools/Data sources (ODBC)
  2. System DSN, Add
  3. SQL Server, Finish
  4. Name: SQLBrugernavn, Next
  5. (*) With SQL Server..., Client Configuration
  6. (*) TCP/IP, Computer name: mssql.dit-domaene.dk, OK
  7. [v] Connect to obtain add....
  8. Login ID: SQLUserName, Password: SQLKodeord, Next
  9. Next, Finish
  10. Test Data Source, OK
  11. OK, OK

Opsæt MS Access til MS SQL server

  1. Start MS Access
  2. Filer | Ny | Projekt (eksisterende database) | Angiv et filnavn | Opret
  3. Select or enter a server name: SQLBrugernavn
  4. (*) Use a specific user name and password
  5. User name: SQLBrugernavn
  6. [ ] Blank password
  7. Password: SQLKodeord
  8. (*) Select the database on the server: SQLBrugernavn
  9. OK

Installer Enterprise Manager

  1. Kør installation fra f.eks. MS SQL 7.0 CDen
  2. Start | Programs | Microsoft SQL Server 7.0 | Enterprise Manager
  3. Microsoft SQL Servers | Højreklik SQL Server Group | New SQL Server registration
  4. Server: SQLBrugernavn, Login Name: SQLBrugernavn, Password: SQLKodeord, OK
 

Referencer

crossfit

"Team CrossFit Copenhagen takker for støtten fra Azero i vores kamp for at nå til CrossFit Games (VM) i Californien i Juli."

Nikolaj Rønnow

2015-01-19T11:02:53+00:00

Nikolaj Rønnow

crossfit
"Team CrossFit Copenhagen takker for støtten fra Azero i vores kamp for at nå til CrossFit Games (VM) i Californien i Juli."
eyeforimage

Azero has been Eye for Image's ISP from the very beginning. It's reassuring to know that they not only have a great array of products, but that we can always get relevant and timely information from their professional support team, by just picking up the phone and talking to someone.

Matt Coyle, Technical Copywriter / Eye for Image ApS

2015-01-20T03:47:24+00:00

Matt Coyle, Technical Copywriter / Eye for Image ApS

eyeforimage
Azero has been Eye for Image's ISP from the very beginning. It's reassuring to know that they not only have a great array of products, but that we can always get relevant and timely information from their professional support team, by just picking up the phone and talking to someone.

Kontakt Azero

Firmainformationer

AzeroCloud ApS
Nørregade 33
8464 Galten
CVR: 38 70 69 93
VAT: DK38706993

Telefon

Telefon: 38 19 50 17
 

Normal telefontid

Man-Fre: 10:00-12:00