impalahill
Grasshopper
Points: 23
More actions
January 4, 2008 at 11:19 am
#123097
While trying to access the Lansync database from another computer, I received an error that stated "SQL Server Access Denied"
How do I grant access?
SanjayAttray
SSChampion
Points: 13157
January 4, 2008 at 11:53 am
#764941
Do you have your login created with specific server role granted? If no, create login onto that server and add yourself to a server/database role.
SQL DBA.
January 4, 2008 at 11:58 am
#764944
What steps to i take to add a log in on the server?
can I do that from my computer or do i need the administrator?
January 4, 2008 at 12:34 pm
#764953
Use sp_grantlogin to allow a windows user to connect to SQL Server
Use sp_addlogin to allow a SQL Server login to connect to SQL Server.
a member of sysadmin and securityadmin fixed roles only can add a login to server.
Check BOL for correct syntax.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply