SQL 2000

  • Thread starter Thread starter graham menzies-kitchin
  • Start date Start date
G

graham menzies-kitchin

Am trying to get a sql connection to an existing .mdb file using the
upsizing wizard.
Every thing goes well until asked for the name of the SQL server.
No matter what I put in it fails to make a connection tho' I have SQL
manager running in sys tray.
What is it's name.
Access 2002, XP.
Thank for any suggestions

Graham
 
Dear Graham:

If you do not choose a name for an instance of SQL Server when it is
installed, I believe it is named "default". I think you can look in the Sys
tray to see.

Tom Ellison
 
Dear Tom

Many thanks. Tried default, @@servername, SQL Server etc
Finally tried computer name which turned up on a dropdown list.
Last thing I would have expected but that was it.

Graham
 
Back
Top