ansaurus

Question

Authentication Problem in Silverlight - Cannot connect to SQL Server

Answer 1

+2 A:

Change the Integrated Security to a User that has access to the database and you should then get connected.

Example:

<connectionStrings>
    <add name="Doner.CMS" connectionString="Data Source=SQL2k8;Network Library=DBMSSOCN;Initial Catalog=Doner;User ID=myUser;Password=myPassword;"/>
</connectionStrings>

Ardman 2010-05-13 09:25:00

Hi Ardman, you mean in the connection string? Can you give me a small example?

Johann 2010-05-13 09:42:29

@Johann: as you can see I've removed the Integrated Security from the ConnectionString.

Ardman 2010-05-13 10:14:11

@Johann: another thing has occurred to me, and that is the Machine Name. Is this the server you are connecting too? Or your local machine? If local, you'll need to obviously change this as well.

Ardman 2010-05-13 10:20:55

Hi ArdmanI tried the following <add name="SIEventManagerEntities" connectionString="metadata=res://*/EventManagerDBModel.csdl|res://*/EventManagerDBModel.ssdl|res://*/EventManagerDBModel.msl;provider=System.Data.SqlClient;provider connection string="Data Source=MONFU-PC;Initial Catalog=SIEventManager;User Id=johann;Password=mypassword;MultipleActiveResultSets=True"" providerName="System.Data.EntityClient" />But now its telling me that login failed for user 'johann'

Johann 2010-05-13 11:24:55

Does the user Johann exist in the database? And also make sure that the user has the necessary privileges for the database.

Ardman 2010-05-13 11:53:21

Yes the user johann exists, and I also mapped the user to the SIEventManager db, through Properties --> User Mapping, and set all database roles to the user (just as a test for the moment) and still nothing is displayed in the website

Johann 2010-05-13 12:01:42

Are you still getting "login failed" message?

Ardman 2010-05-13 12:05:36

This is the whole error message:-System.ServiceModel.DomainService.Client.DomainOPerationException:LoadOperation failed for Query 'GetEvents'. The underlying provider failed on Open. Inner Exception message: Login failed for user 'johann'

Johann 2010-05-13 12:08:15

Ok. Try and log-in to SQL Server using the user id johann and see if it connects. If not, reset the password for it and try it again.

Ardman 2010-05-13 13:07:18

Ok i cannot log in with username Johann, even when changing the password

Johann 2010-05-13 13:58:19

Have you created the user for the SQL Server? Or just the Database? If you click Security->Logins, do you see the Login? If not, create it there.

Ardman 2010-05-13 14:04:00

yes its there, and set to master database now

Johann 2010-05-13 14:54:51

Change that to point to your database.

Ardman 2010-05-13 15:15:36

ok done, still cannot log in though with that username

Johann 2010-05-13 15:34:05

Try deleting the user from the Security->Logins and also remove it from the database Security->Logins if it doesn't do that for you. Recreate the user in the Server Security->Logins and then try and connect to the Database Server using the newly created login.

Ardman 2010-05-13 15:49:02

ok deleted the user, and recreated it, gave it an sql server login, tried to login in and failed again

Johann 2010-05-13 16:12:32

Does your SQL Server allow Mixed Mode Authentication?

Ardman 2010-05-13 16:13:55

Do you mean in security settings? Server Authentication? It was set to Windows Authentication Mode and changed it to both now. Tried to login again but failed

Johann 2010-05-13 16:19:28

Now that you have done that, just try and create a new SQL user and try connecting again.

Ardman 2010-05-13 16:29:49

Ok I created a new user Events, and when trying to log in, i get the same error, Login failed for user 'events'.Error 18456

Johann 2010-05-13 17:12:51

ansaurus

tags:

views:

answers:

Authentication Problem in Silverlight - Cannot connect to SQL Server

related questions