connecting to local sql server



hi,
i have a local sql server running, i can connect to it through query
analyzer, typing ; as the SQL Server name, using windows auth. i can
do the same using sql server auth, putting in a username/password. I
recently downloaded a ASP.NET Time Tracker Database, as it's installing
at the end, it try a test connection. It only lists localhost, not ;,
but everytime it tried it keeps failing. when i try to login into
localhost using query analyzer, either sql or windows auth, it keeps
failing as well. Keep getting a SQl server does not exist or access
denied error. under enterprise manager i see it there as local and
properties show my auth method is set to sql server and windows. any
ideas?

.



Relevant Pages

  • Immer noch Probleme mit dem Debugger
    ... Client (Query Analyzer) und SQL Server nicht auf der gleichen Maschine ... Gezielt gesetzte Haltepunkte waren dem Debugger ...
    (microsoft.public.de.sqlserver)
  • Re: long SQL lines for osql
    ... It works great in Query ... Analyzer, but when run through osql it takes errors on lines that are ... One thing to keep in mind, is by default OSQL runs with QUOTED_IDENTIFIER ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ...
    (comp.databases.ms-sqlserver)
  • SQL Server 2005 Express
    ... I've installed VS.NET 2005 Beta along with SQL Server 2005 Express Beta on ... I'm interested in connecting to SQL Server via query ... analyzer or a similar tool. ...
    (microsoft.public.sqlserver.server)
  • Re: multiple times execution of procedure
    ... If Query ... Analyzer told you that then it might not be accurate because it can't give ... server or what happened with the network link between SQL server and the ... concurrently and it executes that in an iteration M times. ...
    (microsoft.public.sqlserver.programming)
  • Re: Tools with/for Express
    ... Enterprise Manager does not work with SQL Server 2005. ... Analyzer is pretty dumb and just passes on what you type, ... But Enterprise Manager tries to write it's own code and it doesn't use SQL ... I then attempted to use Query Analyzer. ...
    (microsoft.public.sqlserver.tools)