MSDE 2000a

What is going on with this program?

When I try to install it I get the error message:

"A strong SA password is required for security reasons. Please use SAPWD switch to supply the same. Refer to readme for more details. Setup will now exit."

Runing Win2k server, logged in as Administration.
Readme file says nothing about this
As usual, you can't find anything on M$ KB site.

I also tried the MSDE SP3 version - got the same results.I finally got it to install...had to edit the setup.ini file.

The server is running, the service is running but...

there is no enterprise manager...how are you suppose to manage your databases?|||There are a few things to manage your database. First of all there's the command-line tool called osql.exe that can be used to execute commands on your database. The second option is to use Access projects (supported on Access 2000 and higher if I'm not mistaken). Projects are a way to connect to a SQL Server or MSDE instance from within the Access product (pretty powerful). Last but not least there is the Web Data Administrator that can be downloaded fromhttp://www.microsoft.com/downloads/details.aspx?FamilyId=C039A798-C57A-419E-ACBC-2A332CB7F959&displaylang=en.

Hope this can help?|||Hi if anyone is still reading this thread this is very helpfull. I was trying to use MSDE via MATRIX but there seems to be only an option to create tables but not relationships between them so I am wondering how to actually access MSDE directly , which of above 3 ways do you suggest and where do I find more about command line and projects?sql

MSDE 2000

I downloaded MSDE from microsoft. When I click on Setup.exe I get this message:-

A SA password is required for security reasons. Use SAPWD switch to supply the same.

What does this mean and how can I sort it out?

Many thanks

Jim::I downloaded MSDE from microsoft. When I click on Setup.exe I get this message:-

lets see.

::A SA password is required for security reasons.

You need to provide a password for the user SA in the database. The SA user is the Administrator of the database server.

::Use SAPWD switch to supply the same.

You need to speficy this password using - a command line parameter, called a switch.|||How do I do that?

Cheers

Jim|||Look at the bottom of this page...

http://www.asp.net/msde/default.aspx?tabindex=0&tabid=1|||just run setup.exe SAPWD="passwd" in the cmd line

MSDE - I broke it - Please Help

I have been trying to get connected to my MSDE sql server and finally used
osql -S server-name -E
then I set the 'sa' password
sp_password @.old = null, @.new = 'newpass', @.loginame ='sa'
go
- it said Password changed
THEN - (following directions - I thought)
I went into the Registry and set:
HKLM\Software\Microsoft\MSSqlserver\MSSqlServer\LoginMode
to a 2
NOW - I restarted SQL Server and it immediately stops and the Event Log says:
17120 : SQL Server could not spawn FRunCM thread.
THE REAL ISSUE is - I need a trusted connection (I think) to sql server
PLEASE READ ON
I posted in vsnet.general - No Answer
I am using XP and VisualStudio .Net - working my way through the
Visual Studio
Walkthrough: Creating a Distributed Application
All is actually going well and I reached the point of trying to Execute... :)
It works -but- when I hit the LoadData button I get:
Server was unable to process request. --> Login failed for user
'ServerName\IUSR_ServerName'.
HOW can I grant access to the IUSR account on MSDE sql "pubs" database?
WOULD the access permission be for "IUSR" -or- "IUSR_ServerName"
Please be specific...
DO I need to grant EXEC permissions for the StoredProcedures?
WILL this take care of the Update database function "SaveData"
WHERE is the application being told to use the IUSR account?
I don't see it in Web.config
Tooooo Many questions - I'll try not to bother you guys again...
Many, Many - Thanks in advance,
PaulI changed the Registry entry
HKLM\Software\Microsoft\MSSqlserver\MSSqlServer\LoginMode
back to a 1 That's what it was originally...
NOW - I get
17052 :
Microsoft SQL Server 2000 - 8.00.760 (Intel X86)
Dec 17 2002 14:22:05
Copyright (c) 1988-2003 Microsoft Corporation
Desktop Engine on Windows NT 5.1 (Build 2600: Service Pack 1)
17104 :
Server Process ID is 2440.
This instance of SQL Server last reported using a process id of 3760 at
10/20/2004 4:41:30 PM (local) 10/20/2004 9:41:30 PM (UTC).
17162 :
SQL Server is starting at priority class 'normal'(1 CPU detected).
17124 :
SQL Server configured for thread mode processing.
17125 :
Using dynamic lock allocation. [500] Lock Blocks, [1000] Lock Owner Blocks.
17052 :
0 transactions rolled back in database 'master' (1).
3454 :
Recovery is checkpointing database 'master' (1)
17834 :
Using 'SSNETLIB.DLL' version '8.0.766'.
Error Event Id 19011
SuperSocket info: ConnectionListen(Shared-Memory (LPC)) : Error 5.
17052 :
Recovery complete.
Warning Event Id 19011
SuperSocket info: (SpnRegister) : Error 1355.
19013 :
SQL server listening on .
Error: 17826, Severity: 18, State: 1
Could not set up Net-Library 'SSNETLIB'.
17120 :
SQL Server could not spawn FRunCM thread.
WHAT CAN I DO TO GET OUT OF THIS MESS ?
:):):)
THANKS
"PaulThomas" wrote:
> I have been trying to get connected to my MSDE sql server and finally used
> osql -S server-name -E
> then I set the 'sa' password
> sp_password @.old = null, @.new = 'newpass', @.loginame ='sa'
> go
> - it said Password changed
> THEN - (following directions - I thought)
> I went into the Registry and set:
> HKLM\Software\Microsoft\MSSqlserver\MSSqlServer\LoginMode
> to a 2
> NOW - I restarted SQL Server and it immediately stops and the Event Log says:
> 17120 : SQL Server could not spawn FRunCM thread.
> THE REAL ISSUE is - I need a trusted connection (I think) to sql server
> PLEASE READ ON
> I posted in vsnet.general - No Answer
> I am using XP and VisualStudio .Net - working my way through the
> Visual Studio
> Walkthrough: Creating a Distributed Application
> All is actually going well and I reached the point of trying to Execute... :)
> It works -but- when I hit the LoadData button I get:
> Server was unable to process request. --> Login failed for user
> 'ServerName\IUSR_ServerName'.
> HOW can I grant access to the IUSR account on MSDE sql "pubs" database?
> WOULD the access permission be for "IUSR" -or- "IUSR_ServerName"
> Please be specific...
> DO I need to grant EXEC permissions for the StoredProcedures?
> WILL this take care of the Update database function "SaveData"
> WHERE is the application being told to use the IUSR account?
> I don't see it in Web.config
> Tooooo Many questions - I'll try not to bother you guys again...
> Many, Many - Thanks in advance,
> Paul
>|||Reinstall
"PaulThomas" <PaulThomas@.discussions.microsoft.com> wrote in message
news:B9A93D12-DC62-4E5B-AD14-B07F12C3F34A@.microsoft.com...
> I changed the Registry entry
> HKLM\Software\Microsoft\MSSqlserver\MSSqlServer\LoginMode
> back to a 1 That's what it was originally...
> NOW - I get
> 17052 :
> Microsoft SQL Server 2000 - 8.00.760 (Intel X86)
> Dec 17 2002 14:22:05
> Copyright (c) 1988-2003 Microsoft Corporation
> Desktop Engine on Windows NT 5.1 (Build 2600: Service Pack 1)
> 17104 :
> Server Process ID is 2440.
> This instance of SQL Server last reported using a process id of 3760 at
> 10/20/2004 4:41:30 PM (local) 10/20/2004 9:41:30 PM (UTC).
> 17162 :
> SQL Server is starting at priority class 'normal'(1 CPU detected).
> 17124 :
> SQL Server configured for thread mode processing.
> 17125 :
> Using dynamic lock allocation. [500] Lock Blocks, [1000] Lock Owner
Blocks.
> 17052 :
> 0 transactions rolled back in database 'master' (1).
> 3454 :
> Recovery is checkpointing database 'master' (1)
> 17834 :
> Using 'SSNETLIB.DLL' version '8.0.766'.
> Error Event Id 19011
> SuperSocket info: ConnectionListen(Shared-Memory (LPC)) : Error 5.
> 17052 :
> Recovery complete.
> Warning Event Id 19011
> SuperSocket info: (SpnRegister) : Error 1355.
> 19013 :
> SQL server listening on .
> Error: 17826, Severity: 18, State: 1
> Could not set up Net-Library 'SSNETLIB'.
> 17120 :
> SQL Server could not spawn FRunCM thread.
> WHAT CAN I DO TO GET OUT OF THIS MESS ?
> :):):)
> THANKS
>
>
> "PaulThomas" wrote:
> > I have been trying to get connected to my MSDE sql server and finally
used
> > osql -S server-name -E
> > then I set the 'sa' password
> > sp_password @.old = null, @.new = 'newpass', @.loginame ='sa'
> > go
> > - it said Password changed
> > THEN - (following directions - I thought)
> > I went into the Registry and set:
> > HKLM\Software\Microsoft\MSSqlserver\MSSqlServer\LoginMode
> > to a 2
> > NOW - I restarted SQL Server and it immediately stops and the Event Log
says:
> > 17120 : SQL Server could not spawn FRunCM thread.
> >
> > THE REAL ISSUE is - I need a trusted connection (I think) to sql server
> > PLEASE READ ON
> >
> > I posted in vsnet.general - No Answer
> >
> > I am using XP and VisualStudio .Net - working my way through the
> > Visual Studio
> > Walkthrough: Creating a Distributed Application
> > All is actually going well and I reached the point of trying to
Execute... :)
> > It works -but- when I hit the LoadData button I get:
> > Server was unable to process request. --> Login failed for user
> > 'ServerName\IUSR_ServerName'.
> > HOW can I grant access to the IUSR account on MSDE sql "pubs" database?
> > WOULD the access permission be for "IUSR" -or- "IUSR_ServerName"
> > Please be specific...
> > DO I need to grant EXEC permissions for the StoredProcedures?
> > WILL this take care of the Update database function "SaveData"
> > WHERE is the application being told to use the IUSR account?
> > I don't see it in Web.config
> > Tooooo Many questions - I'll try not to bother you guys again...
> > Many, Many - Thanks in advance,
> > Paul
> >|||I assume you are saying to re-install MSDE
Is there any other way - I will of course loose the database, etc...
"Jeff Dillon" wrote:
> Reinstall
> "PaulThomas" <PaulThomas@.discussions.microsoft.com> wrote in message
> news:B9A93D12-DC62-4E5B-AD14-B07F12C3F34A@.microsoft.com...
> > I changed the Registry entry
> > HKLM\Software\Microsoft\MSSqlserver\MSSqlServer\LoginMode
> > back to a 1 That's what it was originally...
> > NOW - I get
> > 17052 :
> > Microsoft SQL Server 2000 - 8.00.760 (Intel X86)
> > Dec 17 2002 14:22:05
> > Copyright (c) 1988-2003 Microsoft Corporation
> > Desktop Engine on Windows NT 5.1 (Build 2600: Service Pack 1)
> > 17104 :
> > Server Process ID is 2440.
> > This instance of SQL Server last reported using a process id of 3760 at
> > 10/20/2004 4:41:30 PM (local) 10/20/2004 9:41:30 PM (UTC).
> > 17162 :
> > SQL Server is starting at priority class 'normal'(1 CPU detected).
> > 17124 :
> > SQL Server configured for thread mode processing.
> > 17125 :
> > Using dynamic lock allocation. [500] Lock Blocks, [1000] Lock Owner
> Blocks.
> > 17052 :
> > 0 transactions rolled back in database 'master' (1).
> > 3454 :
> > Recovery is checkpointing database 'master' (1)
> > 17834 :
> > Using 'SSNETLIB.DLL' version '8.0.766'.
> > Error Event Id 19011
> > SuperSocket info: ConnectionListen(Shared-Memory (LPC)) : Error 5.
> > 17052 :
> > Recovery complete.
> > Warning Event Id 19011
> > SuperSocket info: (SpnRegister) : Error 1355.
> > 19013 :
> > SQL server listening on .
> > Error: 17826, Severity: 18, State: 1
> > Could not set up Net-Library 'SSNETLIB'.
> > 17120 :
> > SQL Server could not spawn FRunCM thread.
> >
> > WHAT CAN I DO TO GET OUT OF THIS MESS ?
> > :):):)
> > THANKS
> >
> >
> >
> >
> > "PaulThomas" wrote:
> >
> > > I have been trying to get connected to my MSDE sql server and finally
> used
> > > osql -S server-name -E
> > > then I set the 'sa' password
> > > sp_password @.old = null, @.new = 'newpass', @.loginame ='sa'
> > > go
> > > - it said Password changed
> > > THEN - (following directions - I thought)
> > > I went into the Registry and set:
> > > HKLM\Software\Microsoft\MSSqlserver\MSSqlServer\LoginMode
> > > to a 2
> > > NOW - I restarted SQL Server and it immediately stops and the Event Log
> says:
> > > 17120 : SQL Server could not spawn FRunCM thread.
> > >
> > > THE REAL ISSUE is - I need a trusted connection (I think) to sql server
> > > PLEASE READ ON
> > >
> > > I posted in vsnet.general - No Answer
> > >
> > > I am using XP and VisualStudio .Net - working my way through the
> > > Visual Studio
> > > Walkthrough: Creating a Distributed Application
> > > All is actually going well and I reached the point of trying to
> Execute... :)
> > > It works -but- when I hit the LoadData button I get:
> > > Server was unable to process request. --> Login failed for user
> > > 'ServerName\IUSR_ServerName'.
> > > HOW can I grant access to the IUSR account on MSDE sql "pubs" database?
> > > WOULD the access permission be for "IUSR" -or- "IUSR_ServerName"
> > > Please be specific...
> > > DO I need to grant EXEC permissions for the StoredProcedures?
> > > WILL this take care of the Update database function "SaveData"
> > > WHERE is the application being told to use the IUSR account?
> > > I don't see it in Web.config
> > > Tooooo Many questions - I'll try not to bother you guys again...
> > > Many, Many - Thanks in advance,
> > > Paul
> > >
>
>|||I don't use MSDE, but maybe some general stuff will help.
Ususally the local system administrator logins are sql logins... So if you
login as an administrator perhaps you can get a trusted connection... Or
conversely (as a test) as the IUSR_SERvername login to the Administrators
group and see if that helps..
Once you can get logged in at all ( as a sql administrator)
HOW can I grant access to the IUSR account on MSDE sql "pubs" database?
sp_addlogin 'servername\IUSR_Servername'
WOULD the access permission be for "IUSR" -or- "IUSR_ServerName"
It is probably the entire servername\login ie
'servername\IUR_ServerName'
Please be specific...
DO I need to grant EXEC permissions for the StoredProcedures?
You probably do unless the SQL login is a member of a role, or permission
to the SPs has been granted to the public role.. Permissions are doc'd in
books on line... but to grant exec permission on an sp.... Grant execute on
dbo.myproc to thisuser
WILL this take care of the Update database function "SaveData"
If savedata is an SP and is owned by the same user as the tables it
updates, the answer is yes.
WHERE is the application being told to use the IUSR account?
I don't see it in Web.config
IIS connects to SQL using the login associated with IIS, which is
IUSR_Servername... This is because the end user looking at the web page, may
or may not be logged in to anything...
Tooooo Many questions - I'll try not to bother you guys again...
Not too many questions... We help one another here, whenever we can... If
you see a posting and you know the or think you can help... pay it back by
helping the next person... Good luck
Many, Many - Thanks in advance,
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"PaulThomas" <PaulThomas@.discussions.microsoft.com> wrote in message
news:611E96AB-43D4-4A1E-ABED-6F8B7DEEE097@.microsoft.com...
> I have been trying to get connected to my MSDE sql server and finally used
> osql -S server-name -E
> then I set the 'sa' password
> sp_password @.old = null, @.new = 'newpass', @.loginame ='sa'
> go
> - it said Password changed
> THEN - (following directions - I thought)
> I went into the Registry and set:
> HKLM\Software\Microsoft\MSSqlserver\MSSqlServer\LoginMode
> to a 2
> NOW - I restarted SQL Server and it immediately stops and the Event Log
says:
> 17120 : SQL Server could not spawn FRunCM thread.
> THE REAL ISSUE is - I need a trusted connection (I think) to sql server
> PLEASE READ ON
> I posted in vsnet.general - No Answer
> I am using XP and VisualStudio .Net - working my way through the
> Visual Studio
> Walkthrough: Creating a Distributed Application
> All is actually going well and I reached the point of trying to Execute...
:)
> It works -but- when I hit the LoadData button I get:
> Server was unable to process request. --> Login failed for user
> 'ServerName\IUSR_ServerName'.
> HOW can I grant access to the IUSR account on MSDE sql "pubs" database?
> WOULD the access permission be for "IUSR" -or- "IUSR_ServerName"
> Please be specific...
> DO I need to grant EXEC permissions for the StoredProcedures?
> WILL this take care of the Update database function "SaveData"
> WHERE is the application being told to use the IUSR account?
> I don't see it in Web.config
> Tooooo Many questions - I'll try not to bother you guys again...
> Many, Many - Thanks in advance,
> Paul
>|||No you won't. Copy the mdf and ldf files first
Jeff
"PaulThomas" <PaulThomas@.discussions.microsoft.com> wrote in message
news:D6C5331E-DDF5-4766-858D-CC5141699A35@.microsoft.com...
> I assume you are saying to re-install MSDE
> Is there any other way - I will of course loose the database, etc...
>
> "Jeff Dillon" wrote:
> > Reinstall
> >
> > "PaulThomas" <PaulThomas@.discussions.microsoft.com> wrote in message
> > news:B9A93D12-DC62-4E5B-AD14-B07F12C3F34A@.microsoft.com...
> > > I changed the Registry entry
> > > HKLM\Software\Microsoft\MSSqlserver\MSSqlServer\LoginMode
> > > back to a 1 That's what it was originally...
> > > NOW - I get
> > > 17052 :
> > > Microsoft SQL Server 2000 - 8.00.760 (Intel X86)
> > > Dec 17 2002 14:22:05
> > > Copyright (c) 1988-2003 Microsoft Corporation
> > > Desktop Engine on Windows NT 5.1 (Build 2600: Service Pack 1)
> > > 17104 :
> > > Server Process ID is 2440.
> > > This instance of SQL Server last reported using a process id of 3760
at
> > > 10/20/2004 4:41:30 PM (local) 10/20/2004 9:41:30 PM (UTC).
> > > 17162 :
> > > SQL Server is starting at priority class 'normal'(1 CPU detected).
> > > 17124 :
> > > SQL Server configured for thread mode processing.
> > > 17125 :
> > > Using dynamic lock allocation. [500] Lock Blocks, [1000] Lock Owner
> > Blocks.
> > > 17052 :
> > > 0 transactions rolled back in database 'master' (1).
> > > 3454 :
> > > Recovery is checkpointing database 'master' (1)
> > > 17834 :
> > > Using 'SSNETLIB.DLL' version '8.0.766'.
> > > Error Event Id 19011
> > > SuperSocket info: ConnectionListen(Shared-Memory (LPC)) : Error 5.
> > > 17052 :
> > > Recovery complete.
> > > Warning Event Id 19011
> > > SuperSocket info: (SpnRegister) : Error 1355.
> > > 19013 :
> > > SQL server listening on .
> > > Error: 17826, Severity: 18, State: 1
> > > Could not set up Net-Library 'SSNETLIB'.
> > > 17120 :
> > > SQL Server could not spawn FRunCM thread.
> > >
> > > WHAT CAN I DO TO GET OUT OF THIS MESS ?
> > > :):):)
> > > THANKS
> > >
> > >
> > >
> > >
> > > "PaulThomas" wrote:
> > >
> > > > I have been trying to get connected to my MSDE sql server and
finally
> > used
> > > > osql -S server-name -E
> > > > then I set the 'sa' password
> > > > sp_password @.old = null, @.new = 'newpass', @.loginame ='sa'
> > > > go
> > > > - it said Password changed
> > > > THEN - (following directions - I thought)
> > > > I went into the Registry and set:
> > > > HKLM\Software\Microsoft\MSSqlserver\MSSqlServer\LoginMode
> > > > to a 2
> > > > NOW - I restarted SQL Server and it immediately stops and the Event
Log
> > says:
> > > > 17120 : SQL Server could not spawn FRunCM thread.
> > > >
> > > > THE REAL ISSUE is - I need a trusted connection (I think) to sql
server
> > > > PLEASE READ ON
> > > >
> > > > I posted in vsnet.general - No Answer
> > > >
> > > > I am using XP and VisualStudio .Net - working my way through the
> > > > Visual Studio
> > > > Walkthrough: Creating a Distributed Application
> > > > All is actually going well and I reached the point of trying to
> > Execute... :)
> > > > It works -but- when I hit the LoadData button I get:
> > > > Server was unable to process request. --> Login failed for user
> > > > 'ServerName\IUSR_ServerName'.
> > > > HOW can I grant access to the IUSR account on MSDE sql "pubs"
database?
> > > > WOULD the access permission be for "IUSR" -or- "IUSR_ServerName"
> > > > Please be specific...
> > > > DO I need to grant EXEC permissions for the StoredProcedures?
> > > > WILL this take care of the Update database function "SaveData"
> > > > WHERE is the application being told to use the IUSR account?
> > > > I don't see it in Web.config
> > > > Tooooo Many questions - I'll try not to bother you guys again...
> > > > Many, Many - Thanks in advance,
> > > > Paul
> > > >
> >
> >
> >

MSDE

Having Problem connecting to Database with WebMatrix

When I try to ADD Database in WebMatrix through Sql Connection & enter USERNAME & PASSWORD it fails. Is there a way to create New USERNAME & PASSWORD? Perhaps through
the Command Line Prompt?

Any Help/Advice TIA

Tristen"setup /upgradesp" option may be for U.
Read carefullySQL Server MSDE notes.

MSDE

Hello,
I'm trying to setup a strong password for my sa account on
a windows 2000 server.
I tried using the instructions from Microsoft Knowledge
base but it keeps giving me a incorrect syntax error
message
Dear Maurice,
I take it that this is the article you are referring to -
322336 HOW TO: Verify and Change the MSDE System Administrator Password
http://support.microsoft.com/?id=322336
Could you please tell us what you executed and what the exact error message
was?
Cheers,
Vikram Jayaram
Microsoft, SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.
|||Dear Maurice,
I take it that this is the article you are referring to -
322336 HOW TO: Verify and Change the MSDE System Administrator Password
http://support.microsoft.com/?id=322336
Could you please tell us what you executed and what the exact error message
was?
Cheers,
Vikram Jayaram
Microsoft, SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.