I am having difficulty finding my SQL Server Enterprise Manager. I am running Windows XP and I am using the MSDE with Visual Studio .NET. Can someone help me? I am trying to take care of the username/pass for a trusted connection. How do I create a trusted connection?

MSDE does not come with Enterprise Manager. You can search on Google for a EM replacement. Or download the SQL Server trial from MS. The DB will expire, but client tools from the download have no expiration date.

PF

will i need to do this for it to work. which one do you think i should do? the trial one from ms or one that you prefer?

If you have Enterprise Manager on your machine already- then you don't need to worry about it.. The Enterprise Manager tools are not included with the MSDE download- so obviously at some point the EM tools were installed separately.


A "TRUSTED" connection means your using a username and password from the domain/machine rather than a connection built with a SQL Server account. So, the username and password for your trusted connection is the same as the username and password for your login to the machine/domain.


Hal Levy
NOT a Wiley/Wrox Employee- Got a job for me?

Hi all
I have found one possible and immediate solution at the Microsoft Knowledge Base. These articles will give you in-depth information on the various topics such as changing the MSDE authentication mode From Windows integrated to mixed mode at the time of installation and even after the installation. Just browse the two URLs give below.

http://support.microsoft.com/default...b;en-us;319930

http://support.microsoft.com/default...b;en-us;322336

Hope this will help you