Oh, one more thing ... Is this a WinForm app or ASP.NET? If it's ASP.NET, then it may be a rights issue ... something about granting ASP User rights to the database or something. I don't do any ASP.NET really, so I'm no expert on this. You can search here on the UT for some answers if this is the case, cuz I know it's been answered a few times in the past.

~~Bonnie




>>Yep! Finer than frog hair!
>Now thats fine!
>
>>What exactly is or isn't happening? Got any error messages?
>Message: Login failed for user 'sa'
>Source: .Net SqlClient Data Provider
>
>And then more stack trace stuff that I care to know about in a lifetime.
>
>Ive tried changing to login properties on the database using Windows and SQL Server authentication and tried changing the connection string to refer to the server by name, changed the user and password etc.
>
>Im going to try this on my machine at home to see if I get the same error.