Problem with logon to sql server with SAP(SID) user.

[Former Member]

Hello all,

I have a new mssql and sap installation server. When I logon on to sap server with SIDadm i can not logon to sql DB.

I get this error. 

*Login failed for user 'PIMNT10\pidadm'. (.Net SqlClient Data Provider).*

I know it is a sap scrip to solve this problem. Is it any body kan help me to find this scrip.

Thanks.

[former_member189725 · Accepted solution]

Please refer this note

Note 551915 - R/3 won't start after database restore or database copy

Attached the database with sp_attach script .

Regards

Ratnajit

[Former Member · Accepted solution]

Hello Ratnajit,

Thanks for reply. My problem is

user permission on sql server. I find this note for my problem.

FYI.

Note 592514 - MSSQL: internal database users, permissions and security

Thanks Reza