Connection Problem >please help.

Hi,

My sql server (MSDE) is in different machine (192.168.0.3) from where my web server (192.168.0.2) but they both are in same network. I have the following in my web.config to file

<add key="ConnectionString" value="server=192.168.0.3;Trusted_Connection=True;database=InetDb" /
I get the following error:

Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.

Is there a solution to it?
Please help.You could set the {uid} and {password} properties for a permission specific SQL account.|||thanks but you are talking to a beginner. I am not sure how but I am trying.
How do I set a user and password in MSDE|||Do you have administrator privliges on both of the server?|||I have this same problem, please msg me when you have solved it.|||You can take a look at these 2 links from MSDN:

http://msdn.microsoft.com/netframework/downloads/sdkmsde/default.aspx

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/distsql/distsql_84xl.asp

if your MSDE is on different PC, you need to use the DISABLENETWORKPROTOCOLS=0
switch during installation.

hope this helps,

Lei Xu
lei_xu@.hotmail.com|||Hi,

I administrate both servers. Home networking, you know..

Not sure what part I am missing but I still haven't been able to figure it out yet.

Regards,|||limsuwan

I had a similar problem and here is what worked for me.

I changed the setting to Mixed Mode from Windows authentication following the direction of the article at:

http://support.microsoft.com/?kbid=322336#2

Once I restarted my computer, the app came up fine.

My final web.config file looks like so:

<configuration>
<appSettings>
<add key="constring"
value="Server=(local);Database=AspNetJobs;UID=AspNETJobsUser;PWD=secret" />
</appSettings>
<system.web>
<authentication mode="Forms" >
<forms name=".ASPNETJOBS"
loginUrl="/aspnetjobs/site/password/login.aspx" />
</authentication>
</system.web>
</configuration
I am a newbie to .net development as well I had spent a couple of days trying to figure out this problem by going through the forums.

Hope this helps|||Thank you so much.
Regares,