Re: SQL open error
From: CT (carstent_at_spammersgoawaydotnetservices.biz)
Date: 10/24/04
- Next message: Allan: "RE: Urgent!! regarding Session management in WEbservice"
- Previous message: Vikki Splat: "Visual Studio 2002 Enterprise Developer NEW IN BOX on ebay"
- In reply to: anonymous_at_discussions.microsoft.com: "Re: SQL open error"
- Next in thread: anonymous_at_discussions.microsoft.com: "Re: SQL open error"
- Reply: anonymous_at_discussions.microsoft.com: "Re: SQL open error"
- Messages sorted by: [ date ] [ thread ]
Date: Sun, 24 Oct 2004 21:18:39 +0200
You must use the user ID and password you used when you reinstalled SQL
Server. What user account id the MSSQLServer Windows service running under?
If not LocalSystem, perhaps that might help you (provided you know the
password of course ;-)).
-- Carsten Thomsen Enterprise Development with VS .NET, UML, and MSF http://www.apress.com/book/bookDisplay.html?bID=105 <anonymous@discussions.microsoft.com> wrote in message news:098e01c4b9f0$7d1d5360$a601280a@phx.gbl... > Carsten; > Thanks for your reply. I can access the SQL server > database thru the SQL Server Enterprise Manager. I don't > understand why the first connection string doesn't work in > my program. I tried to change the Server registration to > include SQL Server authentication in Enterprise Manager but > it keeps telling me that my user name is not associated > with a trusted SQL server connection, the same message I > get programmtically. How do I get my Windows ID to become > associated with a trusted SQL server connection? > Dave >>-----Original Message----- >>Have you checked that the user account used for running > your application can >>still access the SQL Server database? It seems that SQL > Server >>authentication is disabled and only Windows authentication > is enabled, which >>makes sense from a security perspective. However, that > means the second >>connection string you present, won't work. >> >>-- >>Carsten Thomsen >>Enterprise Development with VS .NET, UML, and MSF >>http://www.apress.com/book/bookDisplay.html?bID=105 >>"Dave" <anonymous@discussions.microsoft.com> wrote in message >>news:083801c4b94a$badc8870$a501280a@phx.gbl... >>>I reinstalled SQL 2000 server after reformatting my drive. >>> Now I cannot open a database in my C## program as before. >>> If I use "Provider=SQLOLEDB;Data Source=localhost; Initial >>> Catalog=master;Integrated Security=SSPI"; I >>> get an Invalid login error. If I use "Provider=SQLOLEDB; >>> Data Source=localhost; Initial Catalog=master;User >>> ID=Dave;Password=midn1te"; I get the following error, "User >>> no associated with a trusted SQL server connection." What >>> did I do wrong on my installation? Anyone know what these >>> errors mean? I sure can't find the answers in the Help. >>> Dave >> >> >>. >>
- Next message: Allan: "RE: Urgent!! regarding Session management in WEbservice"
- Previous message: Vikki Splat: "Visual Studio 2002 Enterprise Developer NEW IN BOX on ebay"
- In reply to: anonymous_at_discussions.microsoft.com: "Re: SQL open error"
- Next in thread: anonymous_at_discussions.microsoft.com: "Re: SQL open error"
- Reply: anonymous_at_discussions.microsoft.com: "Re: SQL open error"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
