Create Database in VS.Net IDE

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Lori McDonald (lori_at_nospam.nospam)
Date: 09/21/04 

Date: Mon, 20 Sep 2004 21:41:04 -0700

I have been working with VS.Net for a few years but I am new to MSDE and SQL
Server.

I have installed MSDE on my desktop and I want to administer my database
using VS.Net 2003.

I am in the Server Explorer but I am having trouble creating a database.

I right-click on my server and say "Create Database". I give it a name and
I tell it I want SQL Server authentication.

I give it the username 'sa' and the password I specified for SA when I
installed MSDE.

But I get the following message:
Login failed for user 'sa'. Reason: Not associated with a trusted SQL
Server connection.

What am I doing wrong?

Relevant Pages

  • RE: Backups have Shadow Copy Problems
    ... and restarted the server. ... suggested and changed the recovery model to simple on the one database called ... I understand the issue to be: the backup task failed ... You back up data from a volume that contains a Microsoft SQL Server ...
    (microsoft.public.windows.server.sbs)
  • Re: upsizing to sql 2005
    ... the word SERVER in it, ... You can access to the database by multiple means (Access, ... and how does it update the SQL database with the new records in Access? ... Query Name: Arcadia - ARC ...
    (microsoft.public.access.queries)
  • Re: Linked Tables in Access
    ... any use of SQL Passthru, Linked Tables or any other use of MDB / MDE ... server, or would I also need to convert *those* queries to passthrough ... I've been trying to understand why Access database files become corrupt. ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Trouble Getting VS.Net 2003 WalkThroughs MSDE Connection
    ... Config Tool of SQL Server? ... > link to download the PUBs database. ... >>> Setup and they directed me to install MSDE and they attached a ...
    (microsoft.public.sqlserver.msde)
  • Re: Leveling by ID vs. "Standard"
    ... of this trade called Project Management. ... a database for the "Project Tables," ... to write reports on data from the server database. ... product supporting queries created with SQL. ...
    (microsoft.public.project)