Urgent, master invited: Questions about setting up an ODBC data source to connect to a SQL Server!

wiconell · Post time: 2020-2-16 15:00:01

I created a new record in the System DSN of the ODBC data source, connected to a database server, there is a gagdb database on the server, and I created a connection to the gagdb database in ODBC. I first used SQL authention in ODBC, and entered the corresponding user and password. The default database was gagdb, and the connection was tested successfully. Because the boss requested to use windows authentication, I changed ODBC to windows authention. Of course, I don't need to provide user and password this time. The default database is still gagdb, but the test is that the connection is unsuccessful. Later, I changed the Default database to master and connected successfully. Is this what is the reason? How to change the default database or gagdb?

dazhuzhu1h · Post time: 2020-4-17 22:45:01

Security mechanism

fanfan1980 · Post time: 2020-4-18 12:15:01

Create a new data source to SQL Server
The third step can change the default database

waxiaoning · Post time: 2020-4-18 22:45:01

windows user is not granted access to your database

wiconell · Post time: 2020-4-20 13:15:02

If you change the default database to gagdb, the connection is unsuccessful, which is to solve this problem.
In addition, windows user can access that server, because I changed the authentication mode of the entire sql server to windows authentication

wiconell · Post time: 2020-7-29 10:15:01

How to set up so that windows users can access the gagdb database?

waxiaoning · Post time: 2020-7-29 15:00:01

It's best to set it in Enterprise Manager

wiconell · Post time: 2020-7-29 21:45:01

towaxiaoning: How do I set it up?

		Remember me	Forgot password?
Password			Register