When i call ADOConnection.Connected := False
The connection with the MSDE server is still opened, why that?
I want to close that connection with the server
The connection is only closed when my application is terminated
Im using MSDE 2000 and my application is writen in Delphi
Connection pooling is the probably cause. See this article:
http://msdn.microsoft.com/library/de...l/pooling2.asp
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"Marcos Lommez" <lommez@.hotmail.com> wrote in message
news:O18zpcbUGHA.5108@.TK2MSFTNGP09.phx.gbl...
> When i call ADOConnection.Connected := False
> The connection with the MSDE server is still opened, why that?
> I want to close that connection with the server
> The connection is only closed when my application is terminated
> Im using MSDE 2000 and my application is writen in Delphi
>
>
|||Thanks
I have found the solution in that article
I just need to put the ';OLE DB Services = -2' to the end of my connetion
string
"Roger Wolter[MSFT]" <rwolter@.online.microsoft.com> escreveu na mensagem
news:%23Bd2jedUGHA.736@.TK2MSFTNGP12.phx.gbl...
> Connection pooling is the probably cause. See this article:
>
http://msdn.microsoft.com/library/de...l/pooling2.asp
>
> --
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> Use of included script samples are subject to the terms specified at
> http://www.microsoft.com/info/cpyright.htm
> "Marcos Lommez" <lommez@.hotmail.com> wrote in message
> news:O18zpcbUGHA.5108@.TK2MSFTNGP09.phx.gbl...
>
sql
Showing posts with label connected. Show all posts
Showing posts with label connected. Show all posts
Friday, March 30, 2012
Monday, March 19, 2012
MSDE /XP Problem -Please Help
Hi,
I have2 machines connected to each other. Both the systems
have MS XP operating systems with SP2 patch on them. I
have installed MSDE SP3 on both the systems.
I would like to run a query from one machine on a database
on the other using osql.I was unable to. It gives an error
saying "Access denied"
Are there any settings that i will have to change. I want
one to be like a server and another a client. Each has
its own database.
osql -Usa -Ppassword -S<servername> <enter>
Does not work.
-ZS
If you aren't getting a logon failure, check to make sure you have port 1433
(or the MSDE sqlserver exe) set up as an exception in the XP SP2 firewall
settings.
HTH,
Greg Low [MVP]
MSDE Manager SQL Tools
www.whitebearconsulting.com
"ZS" <anonymous@.discussions.microsoft.com> wrote in message
news:07f001c4b7af$fc2835f0$a301280a@.phx.gbl...
> Hi,
> I have2 machines connected to each other. Both the systems
> have MS XP operating systems with SP2 patch on them. I
> have installed MSDE SP3 on both the systems.
> I would like to run a query from one machine on a database
> on the other using osql.I was unable to. It gives an error
> saying "Access denied"
> Are there any settings that i will have to change. I want
> one to be like a server and another a client. Each has
> its own database.
> osql -Usa -Ppassword -S<servername> <enter>
> Does not work.
> -ZS
>
>
|||Thanks Greg. Yes the problem was with the firewall.
So it is fixed now. Thanks.
=ZS
>--Original Message--
>If you aren't getting a logon failure, check to make sure
you have port 1433
>(or the MSDE sqlserver exe) set up as an exception in the
XP SP2 firewall
>settings.
>HTH,
>--
>Greg Low [MVP]
>MSDE Manager SQL Tools
>www.whitebearconsulting.com
>"ZS" <anonymous@.discussions.microsoft.com> wrote in
message[vbcol=seagreen]
>news:07f001c4b7af$fc2835f0$a301280a@.phx.gbl...
systems[vbcol=seagreen]
database[vbcol=seagreen]
error[vbcol=seagreen]
want
>
>.
>
I have2 machines connected to each other. Both the systems
have MS XP operating systems with SP2 patch on them. I
have installed MSDE SP3 on both the systems.
I would like to run a query from one machine on a database
on the other using osql.I was unable to. It gives an error
saying "Access denied"
Are there any settings that i will have to change. I want
one to be like a server and another a client. Each has
its own database.
osql -Usa -Ppassword -S<servername> <enter>
Does not work.
-ZS
If you aren't getting a logon failure, check to make sure you have port 1433
(or the MSDE sqlserver exe) set up as an exception in the XP SP2 firewall
settings.
HTH,
Greg Low [MVP]
MSDE Manager SQL Tools
www.whitebearconsulting.com
"ZS" <anonymous@.discussions.microsoft.com> wrote in message
news:07f001c4b7af$fc2835f0$a301280a@.phx.gbl...
> Hi,
> I have2 machines connected to each other. Both the systems
> have MS XP operating systems with SP2 patch on them. I
> have installed MSDE SP3 on both the systems.
> I would like to run a query from one machine on a database
> on the other using osql.I was unable to. It gives an error
> saying "Access denied"
> Are there any settings that i will have to change. I want
> one to be like a server and another a client. Each has
> its own database.
> osql -Usa -Ppassword -S<servername> <enter>
> Does not work.
> -ZS
>
>
|||Thanks Greg. Yes the problem was with the firewall.
So it is fixed now. Thanks.
=ZS
>--Original Message--
>If you aren't getting a logon failure, check to make sure
you have port 1433
>(or the MSDE sqlserver exe) set up as an exception in the
XP SP2 firewall
>settings.
>HTH,
>--
>Greg Low [MVP]
>MSDE Manager SQL Tools
>www.whitebearconsulting.com
>"ZS" <anonymous@.discussions.microsoft.com> wrote in
message[vbcol=seagreen]
>news:07f001c4b7af$fc2835f0$a301280a@.phx.gbl...
systems[vbcol=seagreen]
database[vbcol=seagreen]
error[vbcol=seagreen]
want
>
>.
>
Friday, March 9, 2012
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]
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 MSDEIs 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]
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
> > > >
> >
> >
> >
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 - ADP Question
Hi,
After upsizing on MSDE, I created ADP on my terminal.
When the created ADP I need to copy to another user to get connected to MSDE hosted on my pc I followed these steps.
First I copied ADP to the user's pc and
1. Opened Administration Tools on user's pc
2. Clicked twice Data Source (ODBC) icon
3. Selected System DSN and clicked Add
4. Selected SQL Server (Last item) and Finish
5. Given new connection name (any name) in the field 'Name'. Description left empty. In Servaer, typed server name.
6. In the next page, I selected SQL Server Authentication and...
Here is my question:
Should I use at this step System Administrator's login id and password ?
OR
Should I use user's pc id and password ?
I tried both way. But login fails.
Where might have gone wrong? BTW, this the first user I trying on.
Any help would be highly appreviated.
With kind regards,
Ashfaquecreate a sql login in our MSDE using sp_addlogin and then use sp_adduser to grant them specific db access. see details in BOL. if you are using Wndows XP SP2 you may have to create an exception in the personal firewall r drop it altogether.|||Thanks Thrasymachus,
I would appreciate it very much if you could little bit in detail as I am new bee for this area.
With kind regards,
Ashfaque|||Do you have Books Online? If so (it's included free with SQL Server), open it up and go to the Index tab. Type in "logins-SQL Server" and start reading. It will give you more than enough information to accomplish this task. You can also type in the stored procedures he gave you to get syntax and usage information.|||oh why use the reference material. I drove for a couple of years without a license when I was a kid.|||Hi Guys,
No, I don't have Books Online..
Justi moving around with the help of you people...
I attached jpg image to give you a clear pic to know whats wrong..
With kind regards,
Ashfaque|||Hello Gentlemen,
I am still waiting for your valuable response..
With kind regards,
Ashfaque
After upsizing on MSDE, I created ADP on my terminal.
When the created ADP I need to copy to another user to get connected to MSDE hosted on my pc I followed these steps.
First I copied ADP to the user's pc and
1. Opened Administration Tools on user's pc
2. Clicked twice Data Source (ODBC) icon
3. Selected System DSN and clicked Add
4. Selected SQL Server (Last item) and Finish
5. Given new connection name (any name) in the field 'Name'. Description left empty. In Servaer, typed server name.
6. In the next page, I selected SQL Server Authentication and...
Here is my question:
Should I use at this step System Administrator's login id and password ?
OR
Should I use user's pc id and password ?
I tried both way. But login fails.
Where might have gone wrong? BTW, this the first user I trying on.
Any help would be highly appreviated.
With kind regards,
Ashfaquecreate a sql login in our MSDE using sp_addlogin and then use sp_adduser to grant them specific db access. see details in BOL. if you are using Wndows XP SP2 you may have to create an exception in the personal firewall r drop it altogether.|||Thanks Thrasymachus,
I would appreciate it very much if you could little bit in detail as I am new bee for this area.
With kind regards,
Ashfaque|||Do you have Books Online? If so (it's included free with SQL Server), open it up and go to the Index tab. Type in "logins-SQL Server" and start reading. It will give you more than enough information to accomplish this task. You can also type in the stored procedures he gave you to get syntax and usage information.|||oh why use the reference material. I drove for a couple of years without a license when I was a kid.|||Hi Guys,
No, I don't have Books Online..
Justi moving around with the help of you people...
I attached jpg image to give you a clear pic to know whats wrong..
With kind regards,
Ashfaque|||Hello Gentlemen,
I am still waiting for your valuable response..
With kind regards,
Ashfaque
Subscribe to:
Posts (Atom)