sql server msde: can't access MSDE database after setup -- sql server msde

can't access MSDE database after setup

jhestess NO[at]SPAM yahoo.com
6/25/2004 10:42:50 AM

sql server msde: I can't log in with osql. My setup config file is as below.

[Options]
INSTANCENAME=NetSDK
SECURITYMODE=SQL
SAPWD=mypassword

It seems to install and run (green arrow in service bar after giving
it
myservername\NetSDK). Then I try this:

osql -U sa
Password: 'I give mypassword here
[Shared Memory]SQL Server does not exists or access denied.
[Shared Memory]ConnectionOpen (Connect()).

What does this mean? Am I missing something basic? I would really like
to use MSDE, but it seems broken or I just don't have enough
information.

Please cc to jhestess@yahoo.com. Thanks in advance.

John Estess

RE: can't access MSDE database after setup

Mark Ferguson
6/25/2004 2:16:01 PM

This may be a problem with ports or other things. Try these:

"Potential causes of the "SQL Server Does Not Exist or Access Denied" error message"
http://support.microsoft.com/default.aspx?scid=kb;en-us;328306&Product=sql

http://support.microsoft.com/?id=287932

http://support.microsoft.com/default.aspx?kbid=814130

--
Mark Ferguson

[quoted text, click to view]

Re: can't access MSDE database after setup

Andrea Montanari
6/25/2004 11:39:46 PM

hi John,
"John Estess" <jhestess@yahoo.com> ha scritto nel messaggio
news:136cf350.0406250942.1417a8a7@posting.google.com...
[quoted text, click to view]

try
c:\>osql -Smyservername\NetSDK -Usa -Pyour_pwd
--
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtm http://italy.mvps.org
DbaMgr2k ver 0.8.0 - DbaMgr ver 0.54.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
--------- remove DMO to reply

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server msde group.