Ann K
asked on
SQL Login
- In SQL Server Management Studio, open Object Explorer and expand the Databases folder.
- Expand the database in which to create the new database user.
- Right-click the Security folder, point to New, and then click User (The second one in your screenshot).
- On the General page, enter a name for the new user in the User name box.
- In the Login name box, enter the name of a SQL Server login to map to the database user.
- Click OK.
And to assign permissions
- Select your SQL database, Expand database name then select the table residing in that database for which you want to assign the required permissions to that database user
- Right click on that table, and select Properties.
- Click on Permissions option from Table Properties dialog box
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
i use HARRIS-PC\Guest and this time it accept it. But I am still getting the same error in my visual studio 2010 program.
in a non-domain environment to connect from other machines you need to use SQL authentication, you are trying to use just Windows Authentication. You also have to open ports 1433-1444
ASKER
Can you please tell me in step by step instruction how to i do that. Also SQL Server 2014 and visual studio 2010 both are installed on same computer.
ASKER
That is a service account don't use it use a regular account.
ASKER
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.