If you've received this error, it maybe trivial to think the user doesn't have permissions to access SQL Server. For me, I didnt have 'Mixed Mode Authentication' enabled the first time and this time, I forgot to restart the SQLServer Windows Service (in configuration manager)..
Heres an overview...
....Solution
To resolve this issue, follow the instructions to set User Authentication.
SQL Server 2000:
Go to Start > Programs > Microsoft SQL Server > Enterprise Manager
Right-click the Server name, select Properties > Security
Under Authentication, select SQL Server and Windows
The server must be stopped and re-started before this will take effect
SQL Server 2005:
Go to Start > Programs > Microsoft SQL Server 2005 > SQL Server Management Studio
Right-click the Server name, select Properties > Security
Under Server Authentication, select SQL Server and Windows Authentication Mode
The server must be stopped and re-started before this will take effect..."
http://www-1.ibm.com/support/docview.wss?uid=swg21119906
It has solved my problem, so I hope it could be helpful for you too.
No comments:
Post a Comment