i cant login as sql server authenticate in sql

i have changed mode, and restarted services, yet i cant login

Views: 632 | Community Opinion: 2

Bookmark this page..

Ask a New Question Go to Home

Community Opinion/Answers
srikanth Said..

hi shilpa frst of all i want know which version youare using like ql 2005 or 2008....if you are using 2005 first go to connect page...
hera ar the steps to folllow::---

To change security authentication mode

In SQL Server Management Studio Object Explorer, right-click the server, and then click Properties.

On the Security page, under Server authentication, select the new server authentication mode, and then click OK.

In the SQL Server Management Studio dialog box, click OK to acknowledge the requirement to restart SQL Server.

In Object Explorer, right-click your server, and then click Restart. If SQL Server Agent is running, it must also be restarted.

To enable the sa login

In Object Explorer, expand Security, expand Logins, right-click sa, and then click Properties.

On the General page, you might have to create and confirm a password for the login.

On the Status page, in the Login section, click Enabled, and then click OK.


Using Transact-SQL
To enable the sa login

In Object Explorer, connect to an instance of Database Engine.

On the Standard bar, click New Query.

Copy and paste the following example into the query window and click Execute. The following example enables the sa login and sets a new password.

srikanth Said..

here are the steps diagrmatically to follow:-

There are 2 methods of authentication by which GFI ReportCenter can authenticate to SQL Server 2005/2008. These are:

Windows authentication
SQL Server authentication (or mixed authentication).
In order to use SQL Server authentication you must first configure your server using the steps below.

Right-click on the server node and select 'Properties'.

Select 'Security' from the left menu under 'Select a page'.

Under 'Server Authentication', select the 'SQL Server and Windows Authentication mode option'.

Click 'OK' to close the dialog.

Right click on the server node and choose 'Restart' for the changes to take affect.

Enable SQL Server login

In the server node expand 'Security' and 'Logins'.

Right click on the login name and select 'Properties'.

Enter a password and confirm the password for the login.

Select 'Status' from the left menu under 'Select a page'.

Set the 'Login' option to 'Enabled'.

Click 'OK' to close the dialog.

What do you think? Add your opinion/answer
*your opinion/answer: