开发者

Error in SQL Server in network programming

开发者 https://www.devze.com 2023-02-28 17:56 出处:网络
I have 2 databases. The first one is created by 开发者_开发问答SQL Server Express and the second one is created programatically.

I have 2 databases. The first one is created by 开发者_开发问答SQL Server Express and the second one is created programatically.

I can work with them easily but the problem occurs when another user wants to login to them. I tried to add user to my databases with Create user[Domain\User] for login ... command.

This command worked for the first database but for second one I receive this error:

"The server principal 'Domain\User' is not able to access the database 'DBName' under the current security context."

or this error:

login failed for this user

Note that my program is used in network.

please help me


Just a guess: If the user and the server are in the domain the network want be any problem. You must add the login to the instance and assign it to a database along with the roles for the user.

0

精彩评论

暂无评论...
验证码 换一张
取 消