Solved

SQL Server does not exist or access denied.

Posted on 2004-10-09
6
653 Views
Last Modified: 2007-12-19
Hi there

I have just installed MSDE 2000 on XPsp1, with the following options
[Options]
SAPWD="W1bble001"
DISABLENETWORKPROTOCOLS=0
TARGETDIR="C:\dev\mssql\"
DATADIR="C:\dev\mssql\"
SECURITYMODE=SQL

The service was started.

The problem is that I cannot connect to the database at all with the sa account... or any other account cuz I haven't set any up.

I have tried the Web interface to connect, and it just sits there and hangs.

I have also tried setting up an ODBC connection, but then thats when I get the above error again.

When trying to launch the samples, they just seem to hang as well.

What am I missing?

Thanks
Nigel.
0
Comment
Question by:nigel5
  • 4
  • 2
6 Comments
 
LVL 34

Expert Comment

by:arbert
ID: 12268881
What do you get if you you try and telnet to the server:

telnet yourservername 1433

Do you just get a blank screen (able to type a few characters and then take back to the dos prompt), or does it immediately time out?
0
 

Author Comment

by:nigel5
ID: 12269048
I get a blank screen then back to the command prompt.

After the third reboot now, and subsequent re-install, I managed to find a copy of the northwind install sql and run that in with osql.

Prior to running osql I got the same error as above (while attempting to connect to any database), but now I can connect and query the Northwind database, however I am still unable to administer it via the web access, and don't know of any other tools to do so.

I am also not sure what'll happen after a reboot.

Is there a way without some administration tool to perform a restore from a .BAK file, or is there a a link do wownload enterprise manager for free??

Cheers
N.
0
 
LVL 34

Accepted Solution

by:
arbert earned 125 total points
ID: 12269064
Legally you can't use enterprise without a SQL Server license.  However, you can download a 120 free trial of SQL Server from microsoft's site (http://www.microsoft.com/sql).  You can also use OSQL (since you finally got connected)  using

RESTORE database yourdatabasenamehere from disk='c:\folder\yourbackup.bak'  --chang drive and folder to your path

Here are a couple of additional MSDE tools you can use:

http://www.toadsoft.com/toadsqlserver/toad_sqlserver.htm
http://squirrel-sql.sourceforge.net/index.php?page=faq
http://www.mylittletools.net/scripts/en/mla_sql/
http://www.msde.biz/
http://www.microsoft.com/downloads/details.aspx?FamilyID=c039a798-c57a-419e-acbc-2a332cb7f959&displaylang=en

Brett
0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

Author Comment

by:nigel5
ID: 12269535
trying osql....
osql /Usa /PMySaPa55word /Slocalhost /isharepoint.sql

with this sql
restore
    database "uk-argo-asp-01_LM_W3SVC_1_Collab"
from
    disk = 'c:\dev\mssql\backup\Sharepoint.BAK'
with
    recovery
    , replace
    , MOVE 'uk-argo-asp-01_LM_W3SVC_1_Collab' TO 'c:\dev\mssql\MSSQL\Data\Sharepoint.mdf'
    , MOVE 'uk-argo-asp-01_LM_W3SVC_1_Collab_Log' TO 'c:\dev\mssql\MSSQL\Data\Sharepoint.ldf'

I get this output.
1> 2> 3> 4> 5> 6> 7> 8> 9> 10> Msg 170, Level 15, State 1, Server PENSIONS-067, Line 2
Line 2: Incorrect syntax near 'uk-argo-asp-01_LM_W3SVC_1_Collab'.

so I try single quotes... same thing.

I try no quotes
Line 2: Incorrect syntax near '-'.

I try braces and parentheses in the quotes
Line 2: Incorrect syntax near '('.

I try no quotes but just parentheses or braces
1> 2> 3> 4> 5> 6> 7> 8> 9> 10> Syntax error or access violation

how can I use the provided tools?
0
 

Author Comment

by:nigel5
ID: 12269537
Oh, Brett, nothing wrong with your answer, and you'll probably get the points, but I am just trying to push a little :)
0
 

Author Comment

by:nigel5
ID: 12269553
Looks like I solved that one as well... its square braces...
[uk-argo-asp-01_LM_W3SVC_1_Collab]

bladdy microsoft
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

749 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question