SQL Server: RequestError: Invalid object name 'Table Name'.

Question

I create an database in the azure. And try to access the table in app service. When I start the app service in local machine, and it works fine. but When I deploy the app service in azure, the app service will fail to access the table, the error is 'RequestError: Invalid object name '[table Name]'.'

What's the problem and how can I fix the issue?

Thanks,

Answer 1

Hello @Crystal YU In addition to what Morillo mentioned above on the root cause of the issue.

1. Are you getting this error on only one table or for all tables , if you are seeing this on only one table then you simply made a mistake in naming when creating the table.
2. If it is for all tables , then you may need to verify if schema name is the same on Azure
3. List item

Please let us know

Regards,
Oury

Answer 2

In your code, you may be connecting directly to the master database. Do not forget to specify the database name you are connecting once you get connected to the logical SQL Azure server (server1.database.windows.net). Make sure the database name on Azure match the database name you use on your local SQL instance.

Update your app service with the correct database name, table name, and logical Azure SQL server name, as they may not be the same as your local environment.

Make sure the table exist on the same schema.

Answer 3

I specified the database name in the connection config(see following) when I try to connect it. And the app service deployed in Azure is the same code with the one deployed local.
var config = {
user: user,
password: password,
server: server,
database: database,
};