I have installed an MSDE instance on my PC. I have used both the setup.exe program and installed MSDE with the merge modules. Everything works fine - I am able to programmatically connect to the database and execute all of my statements. However, when I t
ry to register the database with Enterprise Manager, Enterprise Manager doesn't see the instance. Similarly, my program that uses SQLDMO.DLL to enumerate all servers does not see the MSDE instance. Both the database, my program, and Enterprise Manager are
running locally on the same machine.
This is a development box, and I have had to uninstall MSDE by hand several times by removing registry keys manually. I suspect that my problem is that I have deleted a key that I needed. Does anyone have any clues? Thanks in advance.
Rob Reagan
MSDE with Sp3a or MSDE Release A installs by default without network
connections enabled and will not advertise itself on the network. You can
still register the instance in Enterprise Manager by typing the name in the
textbox during registration.
You can install MSDE with network connections, see the "Customizing Desktop
Engine Setup.exe" topic in Books Online for details. You can also enable
network connections after installation with (I think) svrnetcn.exe in the
Tools\Bin directory, but I have no MSDe instance to check that at the
moment.
Jacco Schalkwijk
SQL Server MVP
"Rob Reagan" <RobReagan@.discussions.microsoft.com> wrote in message
news:AEC24187-ADA9-48D1-ADC3-837FEE031CEB@.microsoft.com...
> I have installed an MSDE instance on my PC. I have used both the setup.exe
program and installed MSDE with the merge modules. Everything works fine - I
am able to programmatically connect to the database and execute all of my
statements. However, when I try to register the database with Enterprise
Manager, Enterprise Manager doesn't see the instance. Similarly, my program
that uses SQLDMO.DLL to enumerate all servers does not see the MSDE
instance. Both the database, my program, and Enterprise Manager are running
locally on the same machine.
> This is a development box, and I have had to uninstall MSDE by hand
several times by removing registry keys manually. I suspect that my problem
is that I have deleted a key that I needed. Does anyone have any clues?
Thanks in advance.
> Rob Reagan
Showing posts with label trouble. Show all posts
Showing posts with label trouble. Show all posts
Friday, March 30, 2012
Friday, March 23, 2012
MSDE 2000 installation on XP
We're having trouble installing MSDE 2000 on two machines here. They were Win98, upgraded to XP Professional using the upgrade CD labelled 'version 2002'. If we run MSDE installation the routine goes virtually to the end, then the progress bar runs backwards down to zero and the product is not installed. As an experiment we installed XP Pro from a full install (as opposed to upgrade) CD and then ran the MSDE installation, and it worked just fine on the same machine. Problem is we've sold these as XP Pro upgrades and so we don't have keys to install full version for the customer. The verbose log informs me that the installation failed but not clearly why (there's almost 3.5Mb of it).
I realise this might not be enough for anyone to help, but I was hoping that the reverse progress bar might be something someone else has experienced. The machines are Celeron 700 or 766, one has 64Mb the other has 128Mb, 20Gb HDDs with plenty (>18Gb) available. All ideas greatly appreciated.The following article addresses your issue:
MSDN Article (http://support.microsoft.com/default.aspx?scid=kb;EN-US;q313939)
Good luck.|||Thank you very much. I'll try that out - looks like it will do the trick as we didn't specifically have file and print sharing loaded.|||Originally posted by theosgb
Thank you very much. I'll try that out - looks like it will do the trick as we didn't specifically have file and print sharing loaded.
We had the same problem here. Once we ran lodctr /r:PrefStringBackup.ini we were able to install the software.|||Hi,
Would you please give me more details on this command.
Your immidiate response is truly appreciated.
Kal
Originally posted by csturgeon
We had the same problem here. Once we ran lodctr /r:PrefStringBackup.ini we were able to install the software.|||I found info on lodctr /r:PrefStringBackup.ini at this URL I don't see how it relates to an XP install problem. It appears to relate to an MSDE install problem on all NT OSes. But, I did NOT read all it said.
Tim S
http://support.microsoft.com/default.aspx?scid=kb;en-us;315083|||Originally posted by TimS
I found info on lodctr /r:PrefStringBackup.ini at this URL I don't see how it relates to an XP install problem. It appears to relate to an MSDE install problem on all NT OSes. But, I did NOT read all it said.
Tim S
http://support.microsoft.com/default.aspx?scid=kb;en-us;315083
We have found that when a user upgrades from 98/ME to XP. the performance counters get messed up. Once the counters are gone, MSDE will not go on. Running this command reset the counters thereby allowing MSDE to be installed.|||I got past the install after running the LODCTR command and then enabling File and Print Sharing. THANK you guys for all the help .
Best regards,
Kal
I realise this might not be enough for anyone to help, but I was hoping that the reverse progress bar might be something someone else has experienced. The machines are Celeron 700 or 766, one has 64Mb the other has 128Mb, 20Gb HDDs with plenty (>18Gb) available. All ideas greatly appreciated.The following article addresses your issue:
MSDN Article (http://support.microsoft.com/default.aspx?scid=kb;EN-US;q313939)
Good luck.|||Thank you very much. I'll try that out - looks like it will do the trick as we didn't specifically have file and print sharing loaded.|||Originally posted by theosgb
Thank you very much. I'll try that out - looks like it will do the trick as we didn't specifically have file and print sharing loaded.
We had the same problem here. Once we ran lodctr /r:PrefStringBackup.ini we were able to install the software.|||Hi,
Would you please give me more details on this command.
Your immidiate response is truly appreciated.
Kal
Originally posted by csturgeon
We had the same problem here. Once we ran lodctr /r:PrefStringBackup.ini we were able to install the software.|||I found info on lodctr /r:PrefStringBackup.ini at this URL I don't see how it relates to an XP install problem. It appears to relate to an MSDE install problem on all NT OSes. But, I did NOT read all it said.
Tim S
http://support.microsoft.com/default.aspx?scid=kb;en-us;315083|||Originally posted by TimS
I found info on lodctr /r:PrefStringBackup.ini at this URL I don't see how it relates to an XP install problem. It appears to relate to an MSDE install problem on all NT OSes. But, I did NOT read all it said.
Tim S
http://support.microsoft.com/default.aspx?scid=kb;en-us;315083
We have found that when a user upgrades from 98/ME to XP. the performance counters get messed up. Once the counters are gone, MSDE will not go on. Running this command reset the counters thereby allowing MSDE to be installed.|||I got past the install after running the LODCTR command and then enabling File and Print Sharing. THANK you guys for all the help .
Best regards,
Kal
MSDE 2000 database setup trouble
Hello
I am running a stand-alone test environment for an application in XP Pro
which I can only use MSDE to manage my databases.
I've successfully installed msde and am finally able to connect using 'osql
-Usa -Ppassword -S (local)\testmachine' , because I can get the '1>' command
prompt.
My trouble is when I try to create and/or restore a database for the test
application to use I'm running into trouble. For example enter this :
1> USE master
2> RESTORE DATABASE master FROM DISK='C:\master\master_db2.BAK'
3>GO
and I get an error message telling me that "RESTORE DATABASE must be used in
single user mode when trying to restore the master database" ...... I also
get a similar message when trying to create and restore a database called
'public'.
how do I successfully get into 'single user mode' ?
hi,
APB wrote:
> Hello
> I am running a stand-alone test environment for an application in XP
> Pro which I can only use MSDE to manage my databases.
> I've successfully installed msde and am finally able to connect using
> 'osql -Usa -Ppassword -S (local)\testmachine' , because I can get the
> '1>' command prompt.
> My trouble is when I try to create and/or restore a database for the
> test application to use I'm running into trouble. For example enter
> this :
> 1> USE master
> 2> RESTORE DATABASE master FROM DISK='C:\master\master_db2.BAK'
> 3>GO
> and I get an error message telling me that "RESTORE DATABASE must be
> used in single user mode when trying to restore the master database"
> ...... I also get a similar message when trying to create and
> restore a database called 'public'.
> how do I successfully get into 'single user mode' ?
have a look at http://msdn2.microsoft.com/en-us/library/ms180965.aspx ..
typically you open a command window, navigate to the \Binn folder of the
instance you want to start and execute something like
C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\>sqlservr.exe -s
InstanceName -m
this will start the instance in single user modo, so that you'll be able to
restore the master database...
to restore "normal user's" database(s) the single user mode is not required,
but the database(s) to be restored must not be in use... so no active
connections must be running against the database(s) to be restored..
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.bizhttp://italy.mvps.org
DbaMgr2k ver 0.20.0 - DbaMgr ver 0.64.0 and further SQL Tools
-- remove DMO to reply
I am running a stand-alone test environment for an application in XP Pro
which I can only use MSDE to manage my databases.
I've successfully installed msde and am finally able to connect using 'osql
-Usa -Ppassword -S (local)\testmachine' , because I can get the '1>' command
prompt.
My trouble is when I try to create and/or restore a database for the test
application to use I'm running into trouble. For example enter this :
1> USE master
2> RESTORE DATABASE master FROM DISK='C:\master\master_db2.BAK'
3>GO
and I get an error message telling me that "RESTORE DATABASE must be used in
single user mode when trying to restore the master database" ...... I also
get a similar message when trying to create and restore a database called
'public'.
how do I successfully get into 'single user mode' ?
hi,
APB wrote:
> Hello
> I am running a stand-alone test environment for an application in XP
> Pro which I can only use MSDE to manage my databases.
> I've successfully installed msde and am finally able to connect using
> 'osql -Usa -Ppassword -S (local)\testmachine' , because I can get the
> '1>' command prompt.
> My trouble is when I try to create and/or restore a database for the
> test application to use I'm running into trouble. For example enter
> this :
> 1> USE master
> 2> RESTORE DATABASE master FROM DISK='C:\master\master_db2.BAK'
> 3>GO
> and I get an error message telling me that "RESTORE DATABASE must be
> used in single user mode when trying to restore the master database"
> ...... I also get a similar message when trying to create and
> restore a database called 'public'.
> how do I successfully get into 'single user mode' ?
have a look at http://msdn2.microsoft.com/en-us/library/ms180965.aspx ..
typically you open a command window, navigate to the \Binn folder of the
instance you want to start and execute something like
C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\>sqlservr.exe -s
InstanceName -m
this will start the instance in single user modo, so that you'll be able to
restore the master database...
to restore "normal user's" database(s) the single user mode is not required,
but the database(s) to be restored must not be in use... so no active
connections must be running against the database(s) to be restored..
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.bizhttp://italy.mvps.org
DbaMgr2k ver 0.20.0 - DbaMgr ver 0.64.0 and further SQL Tools
-- remove DMO to reply
MSDE 2000 and Windows 2003
I am having trouble connecting to a Windows 2003 w/ MSDE 2000 from all my client PCs. I can connect locally from my Server. I have no firewalls or any other devices in between my clients and server.
Did you enable network connection on msde? Use svrnetcn.exe.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Jiffy" <anonymous@.discussions.microsoft.com> wrote in message
news:94F601EF-E2C2-4777-BDB8-DDC76DFFE97A@.microsoft.com...
> I am having trouble connecting to a Windows 2003 w/ MSDE 2000 from all my client PCs. I can connect locally
from my Server. I have no firewalls or any other devices in between my clients and server.
|||After you do this you will need to stop and restart MSDE.
Rand
This posting is provided "as is" with no warranties and confers no rights.
Did you enable network connection on msde? Use svrnetcn.exe.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Jiffy" <anonymous@.discussions.microsoft.com> wrote in message
news:94F601EF-E2C2-4777-BDB8-DDC76DFFE97A@.microsoft.com...
> I am having trouble connecting to a Windows 2003 w/ MSDE 2000 from all my client PCs. I can connect locally
from my Server. I have no firewalls or any other devices in between my clients and server.
|||After you do this you will need to stop and restart MSDE.
Rand
This posting is provided "as is" with no warranties and confers no rights.
MSDE 2000 and Windows 2003
I am having trouble connecting to a Windows 2003 w/ MSDE 2000 from all my cl
ient PCs. I can connect locally from my Server. I have no firewalls or any o
ther devices in between my clients and server.Did you enable network connection on msde? Use svrnetcn.exe.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Jiffy" <anonymous@.discussions.microsoft.com> wrote in message
news:94F601EF-E2C2-4777-BDB8-DDC76DFFE97A@.microsoft.com...
> I am having trouble connecting to a Windows 2003 w/ MSDE 2000 from all my client P
Cs. I can connect locally
from my Server. I have no firewalls or any other devices in between my clien
ts and server.|||After you do this you will need to stop and restart MSDE.
Rand
This posting is provided "as is" with no warranties and confers no rights.
ient PCs. I can connect locally from my Server. I have no firewalls or any o
ther devices in between my clients and server.Did you enable network connection on msde? Use svrnetcn.exe.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Jiffy" <anonymous@.discussions.microsoft.com> wrote in message
news:94F601EF-E2C2-4777-BDB8-DDC76DFFE97A@.microsoft.com...
> I am having trouble connecting to a Windows 2003 w/ MSDE 2000 from all my client P
Cs. I can connect locally
from my Server. I have no firewalls or any other devices in between my clien
ts and server.|||After you do this you will need to stop and restart MSDE.
Rand
This posting is provided "as is" with no warranties and confers no rights.
Subscribe to:
Posts (Atom)