[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now

x
?
Solved

SQL Server does not exist or access denied.

Posted on 2004-10-09
6
Medium Priority
?
656 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
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 

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: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying 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

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…
Ready to get certified? Check out some courses that help you prepare for third-party exams.
Via a live example, show how to shrink a transaction log file down to a reasonable size.
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

649 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