Connect to Server

Hi!

I m using VS2005 and SQL Server 2005 Express Edition For Database.

i want connect to the server with SQL Server Authentication, for this i created a account Name: ( Amit ) and assign the sysadmin security privleges.

whenever i try to connect with my account the below error comes:

TITLE: Connect to Server

Cannot connect to DOTNET\SQLEXPRESS.

ADDITIONAL INFORMATION:

Login failed for user 'amit'. The user is not associated with a trusted SQL Server connection. (Microsoft SQL Server, Error: 18452)

Please help it

Thanks

Amit

Can you post your connection string so that we can see how you are connecting.. Make sure that when you do post it change the server and usernames so that you do not make them puplic...

|||

This is probably due to the server being in integrated mode and the account being a sql login.

Switch the server to mixed mode and you should be able to connect.

-stevengo

---

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

|||

Hi Amit,

To determine the source of the login failure, you need to look for the error state in the server's error log. Take a look at this blog posting for more info: http://blogs.msdn.com/sql_protocols/archive/2006/02/21/536201.aspx

Il-Sung.