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 ***

HELP

I have been looking at several programs for an auction company . I used my f
irewall and virus check before trying any demo's . Some are OK some not suit
able. One uses and loaded SQL and ? on my computer and it has never been th
e same since. Any ideas ? T
he program adm has tried hard to help me out but at this point I would like
to uninstall it Can Not
because SQL and ? never fully installed . Would like to restore my sys (and
learn more about SQL) without going thru a XP sys restore.(it did not work f
or awhile after the program install and took 2 days to fix ) I love knowing
how my computer works(start
ed with 8088)But time to let experts help. Wish I could keep up with the cha
nge as fast it happens today.Last things first.
If you want to understand SQL better, a good free place to start is Books
On-Lon (BOL for short), included free or available for download here:
SQL Server 2000 Books Online (Updated - SP3)
http://www.microsoft.com/downloads/...71A6-BCF4-45A6-
A2E2-F6AB5BE3EF12&displaylang=en
Another good general resource on SQL server is Inside SQL 2000 by Kalen
Delaney, but you will have to pay for that. She has to earn a living
somehow.
Now for the really important part. Here is how to remove a broken SQL
install:. I hope you are comfortable with registry changes, because that is
the only way to deal with a broken install of any app. It is not simple,
but it is a better alternative than a total system rebuild.
HOW TO: Manually Remove SQL Server 2000 Default, Named, or Virtual Instance
http://support.microsoft.com/defaul...1&Product=sql2k
If you have more questions you know where to go.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
CareerBuilder.com
"need2know" <rsjones@.wapda.com> wrote in message
news:057E5FA0-BBEB-410A-A2DC-147B4E1C02F2@.microsoft.com...

quote:

---

> I have been looking at several programs for an auction company . I used my

---

firewall and virus check before trying any demo's . Some are OK some not
suitable. One uses and loaded SQL and ? on my computer and it has never
been the same since. Any ideas ? The program adm has tried hard to help me
out but at this point I would like to uninstall it Can Not

quote:

---

> because SQL and ? never fully installed . Would like to restore my sys

---

(and learn more about SQL) without going thru a XP sys restore.(it did not
work for awhile after the program install and took 2 days to fix ) I love
knowing how my computer works(started with 8088)But time to let experts
help. Wish I could keep up with the change as fast it happens today.

quote:

---

>

---

HELP

I have been looking at several programs for an auction company . I used my firewall and virus check before trying any demo's . Some are OK some not suitable. One uses and loaded SQL and ? on my computer and it has never been the same since. Any ideas ? The program adm has tried hard to help me out but at this point I would like to uninstall it Can No
because SQL and ? never fully installed . Would like to restore my sys (and learn more about SQL) without going thru a XP sys restore.(it did not work for awhile after the program install and took 2 days to fix ) I love knowing how my computer works(started with 8088)But time to let experts help. Wish I could keep up with the change as fast it happens today.Last things first. :)
If you want to understand SQL better, a good free place to start is Books
On-Lon (BOL for short), included free or available for download here:
SQL Server 2000 Books Online (Updated - SP3)
http://www.microsoft.com/downloads/details.aspx?FamilyID=683D71A6-BCF4-45A6-
A2E2-F6AB5BE3EF12&displaylang=en
Another good general resource on SQL server is Inside SQL 2000 by Kalen
Delaney, but you will have to pay for that. She has to earn a living
somehow.
Now for the really important part. Here is how to remove a broken SQL
install:. I hope you are comfortable with registry changes, because that is
the only way to deal with a broken install of any app. It is not simple,
but it is a better alternative than a total system rebuild.
HOW TO: Manually Remove SQL Server 2000 Default, Named, or Virtual Instance
http://support.microsoft.com/default.aspx?scid=kb;en-us;290991&Product=sql2k
If you have more questions you know where to go.
--
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
CareerBuilder.com
"need2know" <rsjones@.wapda.com> wrote in message
news:057E5FA0-BBEB-410A-A2DC-147B4E1C02F2@.microsoft.com...
> I have been looking at several programs for an auction company . I used my
firewall and virus check before trying any demo's . Some are OK some not
suitable. One uses and loaded SQL and ? on my computer and it has never
been the same since. Any ideas ? The program adm has tried hard to help me
out but at this point I would like to uninstall it Can Not
> because SQL and ? never fully installed . Would like to restore my sys
(and learn more about SQL) without going thru a XP sys restore.(it did not
work for awhile after the program install and took 2 days to fix ) I love
knowing how my computer works(started with 8088)But time to let experts
help. Wish I could keep up with the change as fast it happens today.
>