Solved

SQL Server does not exist or access denied.

Posted on 2004-10-09
6
654 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
Turn Insights into Action

Communication across every corner of your business is essential to increase the velocity of your application delivery and support pipeline. Automate, standardize, and contextualize your communication processes with xMatters.

 

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

On Demand Webinar: Networking for the Cloud Era

Did you know SD-WANs can improve network connectivity? Check out this webinar to learn how an SD-WAN simplified, one-click tool can help you migrate and manage data in the cloud.

Question has a verified solution.

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

Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
Recently we ran in to an issue while running some SQL jobs where we were trying to process the cubes.  We got an error saying failure stating 'NT SERVICE\SQLSERVERAGENT does not have access to Analysis Services. So this is a way to automate that wit…
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.

687 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