question

Equus avatar image
Equus asked

Can I continue to use windows authentication to connect to sql server when the server is not connected to a network?

Currently upgrading an access database to a newer version of access that uses sql server. We use window authentication for connecting. The current database is going to be taken off the network along and placed on a new server that is not on a network. The current sql server database is going to mirrored onto the new server that is off the network. Can we still use window authentication to connect to the server? Both the database and the server will be on windows based computers.

sql server 2012microsoft-access
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
anthony.green avatar image
anthony.green answered

You mean the computers are not going to be domain joined?


In that case no you cannot use windows authentication unless you run access and sql on the same machine.


As soon as you put the access front end somewhere else you need to use SQL authentication

2 comments
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Equus avatar image Equus commented ·
The computers will all be on the same network but they won't have a domain.
0 Likes 0 ·
anthony.green avatar image anthony.green commented ·

Then you need to use SQL Authentication.

0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.