1. Am i right in assumeing MSDE 2000 and SQL Server 2000 Desktop engine Release A are the same.
2. Only people who have old MSDE shld install MSDE 2000 sp3 or sp3a, does that also mean for fresh insallation MSDE 2000 sp3 is enough.Frankly, at this stage I dont remember which file I downloaded but I guess it is SQL2kdesksp3.exe
3. I would like to use MSDE 2000 for VS.NET 2003 and I downloaded it from this site and followed the instructions given there:
http://www.microsoft.com/downloads/d...displaylang=en
3a. I know it is working because I see the green arrow light at the taskbar for start/stop and pausing the SQL Server
3b. I also downloaded the MS SQL Web Administrator from this site:
http://www.microsoft.com/downloads/d...displaylang=en
3c. But when I use the SQL web administrator to connet to SQL server it doesn't, but I still see the green light on the taskbar. Am I doing something wrong?
4. what is MSDE 2000 Deployment Toolkit Release Candidate - Do I need to install that also?
5. I plan to use VS.NET 2003 with MSDE 2000 - how do I test it from VS.NET? I do have the scripts for intallling Northwind database and when I use the OSQL utility I get the error as
[DBNETLIB]SQL Server does not exist or access denied.
[DBNETLIB]ConnectionOpen (Connect()).
Posted using Wimdows.net NntpNews Component -
Post Made from http://www.SqlJunkies.com/newsgroups Our newsgroup engine supports Post Alerts, Ratings, and Searching.
SQL Server Desktop Engine Rel A *is* MSDE 2000 with SP 3a already applied,
so you don't need to install SP 3a on a Release A installation. What
login/password are you using to connect, or are you using NT Authentication?
"SqlJunkies User" <User@.-NOSPAM-SqlJunkies.com> wrote in message
news:%23PTvP4fvEHA.908@.TK2MSFTNGP11.phx.gbl...
>
> 1. Am i right in assumeing MSDE 2000 and SQL Server 2000 Desktop engine
Release A are the same.
> 2. Only people who have old MSDE shld install MSDE 2000 sp3 or sp3a, does
that also mean for fresh insallation MSDE 2000 sp3 is enough.Frankly, at
this stage I dont remember which file I downloaded but I guess it is
SQL2kdesksp3.exe
> 3. I would like to use MSDE 2000 for VS.NET 2003 and I downloaded it from
this site and followed the instructions given there:
>
http://www.microsoft.com/downloads/d...displaylang=en
> 3a. I know it is working because I see the green arrow light at the
taskbar for start/stop and pausing the SQL Server
>
> 3b. I also downloaded the MS SQL Web Administrator from this site:
>
http://www.microsoft.com/downloads/d...displaylang=en
> 3c. But when I use the SQL web administrator to connet to SQL server it
doesn't, but I still see the green light on the taskbar. Am I doing
something wrong?
>
> 4. what is MSDE 2000 Deployment Toolkit Release Candidate - Do I need to
install that also?
> 5. I plan to use VS.NET 2003 with MSDE 2000 - how do I test it from
VS.NET? I do have the scripts for intallling Northwind database and when I
use the OSQL utility I get the error as
> [DBNETLIB]SQL Server does not exist or access denied.
> [DBNETLIB]ConnectionOpen (Connect()).
>
> --
> Posted using Wimdows.net NntpNews Component -
> Post Made from http://www.SqlJunkies.com/newsgroups Our newsgroup engine
supports Post Alerts, Ratings, and Searching.
Showing posts with label old. Show all posts
Showing posts with label old. Show all posts
Friday, March 23, 2012
MSDE 2000 error
1. Am i right in assumeing MSDE 2000 and SQL Server 2000 Desktop engine Rele
ase A are the same.
2. Only people who have old MSDE shld install MSDE 2000 sp3 or sp3a, does th
at also mean for fresh insallation MSDE 2000 sp3 is enough.Frankly, at this
stage I dont remember which file I downloaded but I guess it is SQL2kdesksp3
.exe
3. I would like to use MSDE 2000 for VS.NET 2003 and I downloaded it from th
is site and followed the instructions given there:
http://www.microsoft.com/downloads/...&displaylang=en
3a. I know it is working because I see the green arrow light at the taskbar
for start/stop and pausing the SQL Server
3b. I also downloaded the MS SQL Web Administrator from this site:
http://www.microsoft.com/downloads/...&displaylang=en
3c. But when I use the SQL web administrator to connet to SQL server it does
n't, but I still see the green light on the taskbar. Am I doing something w
rong?
4. what is MSDE 2000 Deployment Toolkit Release Candidate - Do I need to ins
tall that also?
5. I plan to use VS.NET 2003 with MSDE 2000 - how do I test it from VS.NET?
I do have the scripts for intallling Northwind database and when I use the O
SQL utility I get the error as
[DBNETLIB]SQL Server does not exist or access denied.
[DBNETLIB]ConnectionOpen (Connect()).
Posted using Wimdows.net NntpNews Component -
Post Made from http://www.SqlJunkies.com/newsgroups Our newsgroup engine sup
ports Post Alerts, Ratings, and Searching.SQL Server Desktop Engine Rel A *is* MSDE 2000 with SP 3a already applied,
so you don't need to install SP 3a on a Release A installation. What
login/password are you using to connect, or are you using NT Authentication?
"SqlJunkies User" <User@.-NOSPAM-SqlJunkies.com> wrote in message
news:%23PTvP4fvEHA.908@.TK2MSFTNGP11.phx.gbl...
>
> 1. Am i right in assumeing MSDE 2000 and SQL Server 2000 Desktop engine
Release A are the same.
> 2. Only people who have old MSDE shld install MSDE 2000 sp3 or sp3a, does
that also mean for fresh insallation MSDE 2000 sp3 is enough.Frankly, at
this stage I dont remember which file I downloaded but I guess it is
SQL2kdesksp3.exe
> 3. I would like to use MSDE 2000 for VS.NET 2003 and I downloaded it from
this site and followed the instructions given there:
>
http://www.microsoft.com/downloads/... />
laylang=en
> 3a. I know it is working because I see the green arrow light at the
taskbar for start/stop and pausing the SQL Server
>
> 3b. I also downloaded the MS SQL Web Administrator from this site:
>
http://www.microsoft.com/downloads/... />
laylang=en
> 3c. But when I use the SQL web administrator to connet to SQL server it
doesn't, but I still see the green light on the taskbar. Am I doing
something wrong?
>
> 4. what is MSDE 2000 Deployment Toolkit Release Candidate - Do I need to
install that also?
> 5. I plan to use VS.NET 2003 with MSDE 2000 - how do I test it from
VS.NET? I do have the scripts for intallling Northwind database and when I
use the OSQL utility I get the error as
> [DBNETLIB]SQL Server does not exist or access denied.
> [DBNETLIB]ConnectionOpen (Connect()).
>
> --
> Posted using Wimdows.net NntpNews Component -
> Post Made from http://www.SqlJunkies.com/newsgroups Our newsgroup engine
supports Post Alerts, Ratings, and Searching.sql
ase A are the same.
2. Only people who have old MSDE shld install MSDE 2000 sp3 or sp3a, does th
at also mean for fresh insallation MSDE 2000 sp3 is enough.Frankly, at this
stage I dont remember which file I downloaded but I guess it is SQL2kdesksp3
.exe
3. I would like to use MSDE 2000 for VS.NET 2003 and I downloaded it from th
is site and followed the instructions given there:
http://www.microsoft.com/downloads/...&displaylang=en
3a. I know it is working because I see the green arrow light at the taskbar
for start/stop and pausing the SQL Server
3b. I also downloaded the MS SQL Web Administrator from this site:
http://www.microsoft.com/downloads/...&displaylang=en
3c. But when I use the SQL web administrator to connet to SQL server it does
n't, but I still see the green light on the taskbar. Am I doing something w
rong?
4. what is MSDE 2000 Deployment Toolkit Release Candidate - Do I need to ins
tall that also?
5. I plan to use VS.NET 2003 with MSDE 2000 - how do I test it from VS.NET?
I do have the scripts for intallling Northwind database and when I use the O
SQL utility I get the error as
[DBNETLIB]SQL Server does not exist or access denied.
[DBNETLIB]ConnectionOpen (Connect()).
Posted using Wimdows.net NntpNews Component -
Post Made from http://www.SqlJunkies.com/newsgroups Our newsgroup engine sup
ports Post Alerts, Ratings, and Searching.SQL Server Desktop Engine Rel A *is* MSDE 2000 with SP 3a already applied,
so you don't need to install SP 3a on a Release A installation. What
login/password are you using to connect, or are you using NT Authentication?
"SqlJunkies User" <User@.-NOSPAM-SqlJunkies.com> wrote in message
news:%23PTvP4fvEHA.908@.TK2MSFTNGP11.phx.gbl...
>
> 1. Am i right in assumeing MSDE 2000 and SQL Server 2000 Desktop engine
Release A are the same.
> 2. Only people who have old MSDE shld install MSDE 2000 sp3 or sp3a, does
that also mean for fresh insallation MSDE 2000 sp3 is enough.Frankly, at
this stage I dont remember which file I downloaded but I guess it is
SQL2kdesksp3.exe
> 3. I would like to use MSDE 2000 for VS.NET 2003 and I downloaded it from
this site and followed the instructions given there:
>
http://www.microsoft.com/downloads/... />
laylang=en
> 3a. I know it is working because I see the green arrow light at the
taskbar for start/stop and pausing the SQL Server
>
> 3b. I also downloaded the MS SQL Web Administrator from this site:
>
http://www.microsoft.com/downloads/... />
laylang=en
> 3c. But when I use the SQL web administrator to connet to SQL server it
doesn't, but I still see the green light on the taskbar. Am I doing
something wrong?
>
> 4. what is MSDE 2000 Deployment Toolkit Release Candidate - Do I need to
install that also?
> 5. I plan to use VS.NET 2003 with MSDE 2000 - how do I test it from
VS.NET? I do have the scripts for intallling Northwind database and when I
use the OSQL utility I get the error as
> [DBNETLIB]SQL Server does not exist or access denied.
> [DBNETLIB]ConnectionOpen (Connect()).
>
> --
> Posted using Wimdows.net NntpNews Component -
> Post Made from http://www.SqlJunkies.com/newsgroups Our newsgroup engine
supports Post Alerts, Ratings, and Searching.sql
Monday, March 19, 2012
MSDE -> Express Upgrade problem.
Hello!
I'm trying to upgrade old MSDE instances to SQL Server 2005 Express SP1.
The following command fails:
SQLEXPR.EXE /qb UPGRADE=SQL_Engine INSTANCENAME=XXX ADDLOCAL=Client_Components,Connectivity
because the domain\x user cannot login. We have disabled Windows authentication. Is there a way to supply the SA login instead of a domain user?
Problem no #2:
After upgrading with Windows Authentication turned on, current SQL users cannot login (sa). Is Mixed authentication mode turned off during upgrade? Or what else could be the problem?
Our application is distributed around Europe. We have no control over our customers security settings/logins.
Also, the database contains sensitive data. Giving Windows Administrators access to the database is out of the question.
Kind regards
A
Check in the template.ini file that's in the high-level directory of the install media; the options are explained pretty well in there but in brief you can specify accounts, passwords, and security mode.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\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 looking for some guidance here. I have database which has exceeded the 2 gig limit. I deleted some old tables in an attempt to acquire some space. This worked out. However when I look at the size of my *.mdf it still appears in excess of the 2 gigs . I know this isn't true since I deleted 500 megs of stuff. How do i reclaim the space (get the file size to report correctly) or do I need to even worry about it.
Andy
AndyYou might try first backing up the database and then running the "Shrink" command. In Enterprise Manager Select the database, right click and select "Shrink..." from the list of commands. If you don't have Enterprise Manager you can try this command through osql or equivalent.
|||Thanks for your reply and help. I was just about to attempt it when I realized from reading another article on the subject than MSDE dynamically recalculates and adjusts files and indices. Turns out all I had to do was be patient and it took care of itself. This apparently is different functionality from the full blown version of SQL2000. Anyhow, thanks
DBCC SHRINKDATABASE ([YourDatabaseName], 0)
Andy
Saturday, February 25, 2012
msdb restore
I have a client who is trying to restore an old backup of
the msdb database. Of course, their new build of SQL is
different, so they can't do the restore. We get an error
similar to:
"Server: Msg 3168, Level 16, State 1, Line 1
The backup of the system database on device
d:\temp\master.bak cannot be restored because it was
created by a different version of the server (134217904)
than this server (134217920).
Server: Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally. "
what I need to know is how to interpret the version number
in the error message - i.e. "134217904" so I can figure
out what version they need to have running in order to
restore. Anyone have any ideas?
Thanks!Take a look at Q264474. That will help you :-)
/Peter
"Lia" <lkeston@.patriotsoftware.biz> wrote in message
news:4cdc01c3d5fb$f1edd8b0$7d02280a@.phx.gbl...
> I have a client who is trying to restore an old backup of
> the msdb database. Of course, their new build of SQL is
> different, so they can't do the restore. We get an error
> similar to:
> "Server: Msg 3168, Level 16, State 1, Line 1
> The backup of the system database on device
> d:\temp\master.bak cannot be restored because it was
> created by a different version of the server (134217904)
> than this server (134217920).
> Server: Msg 3013, Level 16, State 1, Line 1
> RESTORE DATABASE is terminating abnormally. "
> what I need to know is how to interpret the version number
> in the error message - i.e. "134217904" so I can figure
> out what version they need to have running in order to
> restore. Anyone have any ideas?
> Thanks!
>|||The following command should tell you what build of SQL Server the backup
was taken from:
RESTORE HEADERONLY
FROM DISK = 'd:\temp\master.bak '
You can look at http://support.microsoft.com/?id=264474 for further
information.
Rand
This posting is provided "as is" with no warranties and confers no rights.
the msdb database. Of course, their new build of SQL is
different, so they can't do the restore. We get an error
similar to:
"Server: Msg 3168, Level 16, State 1, Line 1
The backup of the system database on device
d:\temp\master.bak cannot be restored because it was
created by a different version of the server (134217904)
than this server (134217920).
Server: Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally. "
what I need to know is how to interpret the version number
in the error message - i.e. "134217904" so I can figure
out what version they need to have running in order to
restore. Anyone have any ideas?
Thanks!Take a look at Q264474. That will help you :-)
/Peter
"Lia" <lkeston@.patriotsoftware.biz> wrote in message
news:4cdc01c3d5fb$f1edd8b0$7d02280a@.phx.gbl...
> I have a client who is trying to restore an old backup of
> the msdb database. Of course, their new build of SQL is
> different, so they can't do the restore. We get an error
> similar to:
> "Server: Msg 3168, Level 16, State 1, Line 1
> The backup of the system database on device
> d:\temp\master.bak cannot be restored because it was
> created by a different version of the server (134217904)
> than this server (134217920).
> Server: Msg 3013, Level 16, State 1, Line 1
> RESTORE DATABASE is terminating abnormally. "
> what I need to know is how to interpret the version number
> in the error message - i.e. "134217904" so I can figure
> out what version they need to have running in order to
> restore. Anyone have any ideas?
> Thanks!
>|||The following command should tell you what build of SQL Server the backup
was taken from:
RESTORE HEADERONLY
FROM DISK = 'd:\temp\master.bak '
You can look at http://support.microsoft.com/?id=264474 for further
information.
Rand
This posting is provided "as is" with no warranties and confers no rights.
Subscribe to:
Posts (Atom)