RE: connecting

Hi Maggie,

Thank you for the update.

For the first question, you need to use Mixed Mode to enable to use the SQL
Authentication. You could set it up when you install the SQL Server. Also,
you could change it after installation.

To change the Authentication mode, please do the following:

1. Open the Enterprise Manager, expand the server group to find your
server, right-click and click Properties.

2. Click Security Tab, and in the Authentication section, check to select
SQL Server and Windows. Then Click OK.

3. Restart the SQL Server.


For your second question, when you set the Login to access a database, if
you do not add it to any Server Role, by default, it could not access
other databases.

But you could configure this in the Database Access Tab of the New Login
Dialogbox.

Here is the article for your reference:
SQL Server Login Properties - New Login
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/entrmgr/em_
76zy.asp

Hope this will be helpful!

Sincerely,

Wei Lu
Microsoft Online Community Support

==================================================

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

.

Relevant Pages
Loading