HELP Cant get connection to my server with SQLDMO

I am trying to learn SQLDMO for working with our SQL Server 2000
servers. I grabbed a demo program from:
http://www.csharphelp.com/archives2/archive342.html
called SQLDMO for C# from Kevin Goss
I built the program successfully in VS 2003
and it shows me a list of servers (mine being on the list)
but when I try and connect to it using the interface I get the
following messages:
Error
--
[Microsoft][SQL Native Client][SQL Server]Login failed for user
'CODE1\smoody'. Reason: Not associated with a trusted SQL Server
connection.
[Microsoft][SQL Native Client]Shared Memory Provider: The system cannot
open the file.
[Microsoft][SQL Native Client]Communication link failure
--
OK
--
The code where this is occurring is: (I didnt want to include the whole
program and I wasnt sure how much was needed for diagnosing the
problem) I can send more of the code if needs be, just tell me how much
you think you need.
SQLDMO.SQLServer srv = new SQLDMO.SQLServerClass();
srv.Connect(this.cboServers.SelectedItem.ToString(),this.txtUser.Text,this.t
xtPassword.Text);
I have confirmed that the user has access to the database as well as
setting up a DSN entry to access the database. But as of yet I still
can not get past the errors... Please HELP!!!!!
Thanks
-SteveSteve,
Ensure the SQL Server is running in Mixed Mode Authentition instead of
Windows Authentication only or change your connection string to use Windows
credentials.
HTH
Jerry
"SteveM" <steve.moody@.philips.com> wrote in message
news:1129926133.227261.243290@.g47g2000cwa.googlegroups.com...
>I am trying to learn SQLDMO for working with our SQL Server 2000
> servers. I grabbed a demo program from:
> http://www.csharphelp.com/archives2/archive342.html
> called SQLDMO for C# from Kevin Goss
> I built the program successfully in VS 2003
> and it shows me a list of servers (mine being on the list)
> but when I try and connect to it using the interface I get the
> following messages:
> --
> Error
> --
> [Microsoft][SQL Native Client][SQL Server]Login failed for user
> 'CODE1\smoody'. Reason: Not associated with a trusted SQL Server
> connection.
> [Microsoft][SQL Native Client]Shared Memory Provider: The system cannot
> open the file.
>
> [Microsoft][SQL Native Client]Communication link failure
> --
> OK
> --
>
>
> The code where this is occurring is: (I didnt want to include the whole
> program and I wasnt sure how much was needed for diagnosing the
> problem) I can send more of the code if needs be, just tell me how much
> you think you need.
>
> SQLDMO.SQLServer srv = new SQLDMO.SQLServerClass();
> srv.Connect(this.cboServers.SelectedItem.ToString(),this.txtUser.Text,this
.txtPassword.Text);
>
> I have confirmed that the user has access to the database as well as
> setting up a DSN entry to access the database. But as of yet I still
> can not get past the errors... Please HELP!!!!!
> Thanks
> -Steve
>|||I checked and indeed I was NOT running in mixed mode. I changed this and
will check to see if that was the problem. I think I may have found a
better way to do things however. A co-worker of mine showed me a
property called
srv.LoginSecure = true;
This uses my windows credentials without my having to record my userid
and password (even though I know I can encrypt it in a config file in
the project). This seems a better way to go, but I do want to learn to
do things the other way, so you advice will be very helpful. Thanks for
taking the time to respond I appreciate it
-Steve
*** Sent via Developersdex http://www.examnotes.net ***