Normally we work on same SQL server.
However, today I will need to pull data from 2 different SQL server. Water bill database server are different SQL server with GIS database server, in order to pull data from remote water bill database, I have to create water bill database as linked server in GIS database' server object list. After that I can query in GIS database while pull data from another remote water bill database.
![](https://transparentgov.net/data/img5/standby_vv631.png)
Create a linked server.( water bill database server is linked server )
![](https://transparentgov.net/data/img5/standby_vv632.png)
How to fix this error
![](https://transparentgov.net/data/img5/standby_vv633.png)
SQL SERVER – FIX – Linked Server Error 7399 Invalid authorization specification
https://blog.sqlauthority.com/2016/06/11/sql-server-fix-linked-server-error-7399-invalid-authorization-specification/
![](https://transparentgov.net/data/img5/standby_vv636.png)
The problem is I try to link to water bill database with linked server object. I need to provide some credential login name with password. By default I have not provide any login password, that cause the ERROR 7399.
![](https://transparentgov.net/data/img5/standby_vv637png.png)
I have tried to provide windows authentication "COV\jhu" along with my windows password, seems linked server object does not like it. Still error.
Now I will create a SQL authentication which is a SQL account name with password on water bill database. Then I can provide this login password in my linked server object. This fix the problem.
![](https://transparentgov.net/data/img5/standby_vv638.png)
Don't forget give new SQL login with system admin role, which give it permission to access water bill table.
![](https://transparentgov.net/data/img5/standby_vv639.png)