Solved

SQL Server does not exist or access denied.

Posted on 2004-10-09
6
650 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
Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

 

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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
How to select a spread of rows in SQL 8 55
SQL Error in WHERE Clause 5 39
Need to update TableA to TableB 6 34
SQL Server - Slabs 9 37
Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
Ever wondered why sometimes your SQL Server is slow or unresponsive with connections spiking up but by the time you go in, all is well? The following article will show you how to install and configure a SQL job that will send you email alerts includ…
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

910 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

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now