MSDE Trusted Connection - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

MSDE (2000)

MSDE Trusted Connection

Author

Topic

eduardofcomelo
Starting Member

3 Posts

Posted - 2005-03-04 : 13:45:59

I have installed MSDE 2000 on a Windows XP. After that I have created the database. When I am trying to use the Query Analizer to connect to the database an error message is coming that is "Trusted Connection not found"

Please ! How can I create a Trusted Connection ?

thanks in advanced,

best regards,

Eduardo F. de Melo

Eduardo F. de Melo
------------------
ASP.NET
SQL SERVER, MSDE, MYSQL

derrickleggett
Pointy Haired Yak DBA

4184 Posts

Posted - 2005-03-05 : 13:59:43

Login using the sa username and password.
Use sp_grantlogin
Use sp_grantdbaccess
Use the appropriate grant statements for permissions.
I would assume you want to setup one user as admin on the SQL Server and never use sa again (great idea).
For that, you would add this particular user to the System Admin role with sp_addsrvrolemember.

The syntax for all these commands, and a LOT of other free information, can be conveniently found in Books Online.

MeanOldDBA
derrickleggett@hotmail.com

When life gives you a lemon, fire the DBA.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources