I have installed SQL Server in my home PC for personal use. When I had planned to configure SQL Server through the Surface area configuration, I found an error like this: "The file or the assembly could not be loaded" microsoft.sqlserver.customcontrols, version = 9.0. 242..0, Culture = Neutral, PublicTech = 89845dcd8080cc91 'or its dependencies. The system specified file can not be found. (SQSAC) ". What do I do to solve this problem?
Try on the basis of this link ...
sqlcmd -s & lt; Dbname & gt; LoadTest Ape sp_grantdbaccess' domain 'user', 'user' exec sp_addrolemember 'db_datareader', use 'user'
1) Replace with your database name. If this is the default database, then it is. \ Sqlexpress
2) Replace 'domain' user 'with the account that you want to grant access and' user 'to replace with the user name database. For example,
exec sp_grantdbaccess 'company \ sean', 'sean'
3) Replace 'user' in previous statement. So in my example,
exec sp_addrolemember 'db_datareader', 'sean'
Comments
Post a Comment