?
Solved

SQL Server does not exist or access denied.

Posted on 2004-10-09
6
Medium Priority
?
655 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 500 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

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

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

International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
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.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.
Suggested Courses

770 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