Access connection to MS sql server

[johnseito]

Hello,

Could someone provide me an example on how to connect ACCESS to Microsoft SQL server if given the server name, and login and database name but no password as

servername.connect12.com, 15234
Login as in co/age213


Database name dbFruits

[ranman256]

in access , external data tab,
(in newer access) New data source,
from other sources,
odbc,
link,
fill out info

in older access,
click OCBC,
same info

[johnseito]

I did as told by you. Connection failed.
SQL server error: 53

[johnseito]

can we connect via VBA code ?

[NoellaG]

To SQL server you don't need an ODBC connection. Use the native SQL driver. Then ask your SQL database administrator to add your windows login to a SQL user group or provide you with an SQL login and password. Without it, you cannot connect, that's the whole point of SQL security. This is made on 2 levels: first you need an account/login to login to the SQL server and above that you need a valid user + password to the database you want to use.