MSDE 2000 with Access 2003: The First steps

Finally got to the point where I can connect to MSDE from Access. If you are setting up MSDE for the first time, you may find a couple useful points in the following.
MSDE 2000 with Access 2003: The First steps.
1) install MSDE from Office CD (need to locate in MSDE directory by browsing and start it manually. Read KB article 319930 first);
2) when installing, need to specify "sa" (system admin) password which is not (does not have to be anyway) the same as Windows Administrator's password. It is required in order not to leave sysadmin password blank which would leave a security hole;
3) if you are using all the correct switches with the 'setup' command, the mixed login mode will be allowed. The mixed login mode lets you login from non-admin account by using MSDE login. I did not use any switches so had to make the adjustments in the r
egistry. Very easy, but I still had to locate the required key which was not where it is supposed to be judging from KB article 319930, but quite near it.
4) restart and check that 2 new services are running: MSSQLSERVER and SQLSERVERAGENT.
5) restart the PC and log in under (Windows) administrator account (does not need to be THE "Administrator", just any account with admin privileges)
6) test the connection to MDSE by going to command line, typing "osql -E" (no " needed). You should see ">1" which means MDSE is running.
7) Now this is the $100 trick: type "sp_addlogin [BUILTIN\POWER USERS]", <ENTER>, "GO". wait for some reaction (something like 2 rows affected)
8) Here comes another $100 trick: type "grant all", <ENTER>, "to [BUILTIN\POWER USERS]", <ENTER>, "go".
Now you can go back to your every day Windows login (I assume you are using an account from Power Users group, aren't you?), start Access, create a new .adp file and connect your Access .adp file to MSDE using "Trusted Connection" or "Use Windows NT integ
rated security".
Oh by the way you can type "exit" from command line to stop your connection to MSDE when you feel like.
You can also submit commands and scripts via OSQL directly from the command
line. I thought from your previous post that you were trying to 'assign
(SQL) sysadmin permissions to a newly created (SQL) account.' I.e., your
SQL account was already created and you were trying to put it in the
sysadmin server role. By the way,
$50 Discount - GRANT grants database-specific permissions to users. So if
you have more than one Database, you need to use GRANT on all databases and
database objects you want the user to have access to.
$0.02 worth - sp_addrolemember and sp_addsrvrolemember adds users to
server-wide roles, like "sysadmin." GRANT is database object specific, so
it works only on individual databases and database objects (tables, etc.)
Cheers,
Michael C.
"Lolik" <Lolik@.discussions.microsoft.com> wrote in message
news:BDFB3614-78ED-4DB2-8468-7C78073A7906@.microsoft.com...
> Finally got to the point where I can connect to MSDE from Access. If you
are setting up MSDE for the first time, you may find a couple useful points
in the following.
> MSDE 2000 with Access 2003: The First steps.
> 1) install MSDE from Office CD (need to locate in MSDE directory by
browsing and start it manually. Read KB article 319930 first);
> 2) when installing, need to specify "sa" (system admin) password which is
not (does not have to be anyway) the same as Windows Administrator's
password. It is required in order not to leave sysadmin password blank which
would leave a security hole;
> 3) if you are using all the correct switches with the 'setup' command, the
mixed login mode will be allowed. The mixed login mode lets you login from
non-admin account by using MSDE login. I did not use any switches so had to
make the adjustments in the registry. Very easy, but I still had to locate
the required key which was not where it is supposed to be judging from KB
article 319930, but quite near it.
> 4) restart and check that 2 new services are running: MSSQLSERVER and
SQLSERVERAGENT.
> 5) restart the PC and log in under (Windows) administrator account (does
not need to be THE "Administrator", just any account with admin privileges)
> 6) test the connection to MDSE by going to command line, typing "osql -E"
(no " needed). You should see ">1" which means MDSE is running.
> 7) Now this is the $100 trick: type "sp_addlogin [BUILTIN\POWER USERS]",
<ENTER>, "GO". wait for some reaction (something like 2 rows affected)
> 8) Here comes another $100 trick: type "grant all", <ENTER>, "to
[BUILTIN\POWER USERS]", <ENTER>, "go".
> Now you can go back to your every day Windows login (I assume you are
using an account from Power Users group, aren't you?), start Access, create
a new .adp file and connect your Access .adp file to MSDE using "Trusted
Connection" or "Use Windows NT integrated security".
> Oh by the way you can type "exit" from command line to stop your
connection to MSDE when you feel like.
|||$0.02 worth - sp_addrolemember and sp_addsrvrolemember adds users to
server-wide roles, like "sysadmin." GRANT is database object specific, so
it works only on individual databases and database objects (tables, etc.)
__________________
Do not underestimate your input Michael!
Guess I should run sp_addsrvrolemember too. Still after having used GRANT as above I was able to create a new SQL database and connect to it, at the time a new Access .adp file was set up.
The $50 tag referred to using [BUILTIN\POWER USERS] as a login. Could not find it mentioned anywhere. Maybe it is obvious to everyone but me but figuring out what [Corporate\Bobj] is in XP language was not straightforward to me at all.
|||Yes, you can grant User Groups access rights to your SQL Server One of
the benefits of using Integrated Security for your SQL Server logins. The
built-in server roles, like sysadmin grant general permissions server-wide,
and include various other little niceties. Since your user created the 2nd
database, that user is the database owner (dbo) for that database, so that
user will have all the rights associated with that database. Server Roles
make it a little easier to admin multiple databases.
Cheers,
Michael C.

> Do not underestimate your input Michael!
> Guess I should run sp_addsrvrolemember too. Still after having used GRANT
as above I was able to create a new SQL database and connect to it, at the
time a new Access .adp file was set up.
sql

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\MSSq
lServer\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\MSSq
lServer\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\MSSq
lServer\LoginMode
> to a 2
> NOW - I restarted SQL Server and it immediately stops and the Event Log sa
ys:
> 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...[vbcol=seagreen]
> I changed the Registry entry
> HKLM\Software\Microsoft\MSSqlserver\MSSq
lServer\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[/vbcol
]
Blocks.[vbcol=seagreen]
> 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:
>
used[vbcol=seagreen]
says:[vbcol=seagreen]
Execute... [vbcol=seagreen]|||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...
> Blocks.
> used
> says:
> Execute...
>
>|||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\MSSq
lServer\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...[vbcol=seagreen]
> 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:
>
at[vbcol=seagreen]
finally[vbcol=seagreen]
Log[vbcol=seagreen]
server[vbcol=seagreen]
database?[vbcol=seagreen]

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\Lo ginMode
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 changed the Registry entry
HKLM\Software\Microsoft\MSSqlserver\MSSqlServer\Lo ginMode
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\Lo ginMode
> 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\Lo ginMode
> 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.[vbcol=seagreen]
> 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:
used[vbcol=seagreen]
says:[vbcol=seagreen]
Execute... [vbcol=seagreen]
|||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...
> Blocks.
> used
> says:
> Execute...
>
>
|||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\Lo ginMode
> 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...[vbcol=seagreen]
> 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:
at[vbcol=seagreen]
finally[vbcol=seagreen]
Log[vbcol=seagreen]
server[vbcol=seagreen]
database?[vbcol=seagreen]

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
> > > >
> >
> >
> >