I am trying to install a local version of SQL2000 on my XP Pro.
I am having this problem, do you know why because I cannot find the solution on the microsoft website:
Server: Msg 17, Level 16, State 1
[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied.You'd probably do better to post this kind of question in the Micrsoft SQL Server (http://www.dbforums.com/f7/) forum.
-PatP
Showing posts with label local. Show all posts
Showing posts with label local. Show all posts
Wednesday, March 28, 2012
Friday, March 23, 2012
Installing a local instance of SQL on a Cluster Node
Hi
I have an Active/Passive SQL 2000 Cluster - the OS is W3K Server.
I would like to install a local copy of SQL Server on the node that is
currently passive - if I start the SQL install process, it does give me
this option but I don't know what, if any, problems this might cause.
I appreciate if the currently active node fails, it will failover to
the node which also has a local version running as well.
Has anyone done this? I've tried searching groups and Microsoft without
success.
Thanks
Toby
It's OK to install local instances on cluster nodes. Just make sure the
instance name does not conflict with any instance on the cluster.
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
..
<tjbeaumont@.gmail.com> wrote in message
news:1160036955.164570.322690@.i3g2000cwc.googlegro ups.com...
Hi
I have an Active/Passive SQL 2000 Cluster - the OS is W3K Server.
I would like to install a local copy of SQL Server on the node that is
currently passive - if I start the SQL install process, it does give me
this option but I don't know what, if any, problems this might cause.
I appreciate if the currently active node fails, it will failover to
the node which also has a local version running as well.
Has anyone done this? I've tried searching groups and Microsoft without
success.
Thanks
Toby
|||<tjbeaumont@.gmail.com> wrote in message
news:1160036955.164570.322690@.i3g2000cwc.googlegro ups.com...
> Hi
> I have an Active/Passive SQL 2000 Cluster - the OS is W3K Server.
> I would like to install a local copy of SQL Server on the node that is
> currently passive - if I start the SQL install process, it does give me
> this option but I don't know what, if any, problems this might cause.
Yes, you can do it, but it is a violation of the HA spirit. Meaning, why in
the world would you want to screw around and do that when the company has
obviously felt that the other SQL instances (in the cluster) require HA?
Don't mess with the HA environment!
Russ Kaufmann
MVP - Windows Server - Clustering
ClusterHelp.com, a Microsoft Certified Gold Partner
Web http://www.clusterhelp.com
Blog http://msmvps.com/clusterhelp
|||That's true for production clusters. But we install standalone SQL instances
on a clustered node all the time on our test clusters.
Linchi
"Russ Kaufmann" wrote:
> <tjbeaumont@.gmail.com> wrote in message
> news:1160036955.164570.322690@.i3g2000cwc.googlegro ups.com...
> Yes, you can do it, but it is a violation of the HA spirit. Meaning, why in
> the world would you want to screw around and do that when the company has
> obviously felt that the other SQL instances (in the cluster) require HA?
> Don't mess with the HA environment!
>
> --
> Russ Kaufmann
> MVP - Windows Server - Clustering
> ClusterHelp.com, a Microsoft Certified Gold Partner
> Web http://www.clusterhelp.com
> Blog http://msmvps.com/clusterhelp
>
>
|||"Linchi Shea" <LinchiShea@.discussions.microsoft.com> wrote in message
news:6B70403B-35CF-4773-9160-8FFC9DDC8638@.microsoft.com...
> That's true for production clusters. But we install standalone SQL
> instances
> on a clustered node all the time on our test clusters.
So, your test environment doesn't mirror production?
Actually, I can see doing that.
Russ Kaufmann
MVP - Windows Server - Clustering
ClusterHelp.com, a Microsoft Certified Gold Partner
Web http://www.clusterhelp.com
Blog http://msmvps.com/clusterhelp
I have an Active/Passive SQL 2000 Cluster - the OS is W3K Server.
I would like to install a local copy of SQL Server on the node that is
currently passive - if I start the SQL install process, it does give me
this option but I don't know what, if any, problems this might cause.
I appreciate if the currently active node fails, it will failover to
the node which also has a local version running as well.
Has anyone done this? I've tried searching groups and Microsoft without
success.
Thanks
Toby
It's OK to install local instances on cluster nodes. Just make sure the
instance name does not conflict with any instance on the cluster.
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
..
<tjbeaumont@.gmail.com> wrote in message
news:1160036955.164570.322690@.i3g2000cwc.googlegro ups.com...
Hi
I have an Active/Passive SQL 2000 Cluster - the OS is W3K Server.
I would like to install a local copy of SQL Server on the node that is
currently passive - if I start the SQL install process, it does give me
this option but I don't know what, if any, problems this might cause.
I appreciate if the currently active node fails, it will failover to
the node which also has a local version running as well.
Has anyone done this? I've tried searching groups and Microsoft without
success.
Thanks
Toby
|||<tjbeaumont@.gmail.com> wrote in message
news:1160036955.164570.322690@.i3g2000cwc.googlegro ups.com...
> Hi
> I have an Active/Passive SQL 2000 Cluster - the OS is W3K Server.
> I would like to install a local copy of SQL Server on the node that is
> currently passive - if I start the SQL install process, it does give me
> this option but I don't know what, if any, problems this might cause.
Yes, you can do it, but it is a violation of the HA spirit. Meaning, why in
the world would you want to screw around and do that when the company has
obviously felt that the other SQL instances (in the cluster) require HA?
Don't mess with the HA environment!
Russ Kaufmann
MVP - Windows Server - Clustering
ClusterHelp.com, a Microsoft Certified Gold Partner
Web http://www.clusterhelp.com
Blog http://msmvps.com/clusterhelp
|||That's true for production clusters. But we install standalone SQL instances
on a clustered node all the time on our test clusters.
Linchi
"Russ Kaufmann" wrote:
> <tjbeaumont@.gmail.com> wrote in message
> news:1160036955.164570.322690@.i3g2000cwc.googlegro ups.com...
> Yes, you can do it, but it is a violation of the HA spirit. Meaning, why in
> the world would you want to screw around and do that when the company has
> obviously felt that the other SQL instances (in the cluster) require HA?
> Don't mess with the HA environment!
>
> --
> Russ Kaufmann
> MVP - Windows Server - Clustering
> ClusterHelp.com, a Microsoft Certified Gold Partner
> Web http://www.clusterhelp.com
> Blog http://msmvps.com/clusterhelp
>
>
|||"Linchi Shea" <LinchiShea@.discussions.microsoft.com> wrote in message
news:6B70403B-35CF-4773-9160-8FFC9DDC8638@.microsoft.com...
> That's true for production clusters. But we install standalone SQL
> instances
> on a clustered node all the time on our test clusters.
So, your test environment doesn't mirror production?
Actually, I can see doing that.
Russ Kaufmann
MVP - Windows Server - Clustering
ClusterHelp.com, a Microsoft Certified Gold Partner
Web http://www.clusterhelp.com
Blog http://msmvps.com/clusterhelp
Installing a Database
Hello all...I develop a Database in a Local Instance of a server.
Then, I need to install ALL the New database in a remote server using TCP
connection and, I have no idea how script them and how can I execute this
script remotely. Obviously, I have Administrator permissions on this server
(W2K3).
Any Idea?
Some sample to clarify me the concept?
Thanks
If you're using Enterprise Manager, you can register the remote server with
the local server in EM. Perform a backup of the database with a
right-click, copy the backup file to the remote server (same location if
possible) then restore the database with another right-click. You can also
use Query Analyzer and the Transact-SQL statments (BACKUP and RESTORE) to
perform the backup and restore. Another technique is to use sp_detach_db
and sp_attach_db.
For more information see these topics in the SQL Server Books Online.
Also look at :
HOW TO: Move Databases Between Computers That Are Running SQL Server
http://support.microsoft.com/default...b;en-us;314546
HTH
Jerry
"Nando_uy" <Nandouy@.discussions.microsoft.com> wrote in message
news:2142AE07-CEEE-4FC1-AE1F-D33F417F6D4D@.microsoft.com...
> Hello all...I develop a Database in a Local Instance of a server.
> Then, I need to install ALL the New database in a remote server using TCP
> connection and, I have no idea how script them and how can I execute this
> script remotely. Obviously, I have Administrator permissions on this
> server
> (W2K3).
> Any Idea?
> Some sample to clarify me the concept?
> Thanks
Then, I need to install ALL the New database in a remote server using TCP
connection and, I have no idea how script them and how can I execute this
script remotely. Obviously, I have Administrator permissions on this server
(W2K3).
Any Idea?
Some sample to clarify me the concept?
Thanks
If you're using Enterprise Manager, you can register the remote server with
the local server in EM. Perform a backup of the database with a
right-click, copy the backup file to the remote server (same location if
possible) then restore the database with another right-click. You can also
use Query Analyzer and the Transact-SQL statments (BACKUP and RESTORE) to
perform the backup and restore. Another technique is to use sp_detach_db
and sp_attach_db.
For more information see these topics in the SQL Server Books Online.
Also look at :
HOW TO: Move Databases Between Computers That Are Running SQL Server
http://support.microsoft.com/default...b;en-us;314546
HTH
Jerry
"Nando_uy" <Nandouy@.discussions.microsoft.com> wrote in message
news:2142AE07-CEEE-4FC1-AE1F-D33F417F6D4D@.microsoft.com...
> Hello all...I develop a Database in a Local Instance of a server.
> Then, I need to install ALL the New database in a remote server using TCP
> connection and, I have no idea how script them and how can I execute this
> script remotely. Obviously, I have Administrator permissions on this
> server
> (W2K3).
> Any Idea?
> Some sample to clarify me the concept?
> Thanks
Installing a Database
Hello all...I develop a Database in a Local Instance of a server.
Then, I need to install ALL the New database in a remote server using TCP
connection and, I have no idea how script them and how can I execute this
script remotely. Obviously, I have Administrator permissions on this server
(W2K3).
Any Idea?
Some sample to clarify me the concept?
ThanksIf you're using Enterprise Manager, you can register the remote server with
the local server in EM. Perform a backup of the database with a
right-click, copy the backup file to the remote server (same location if
possible) then restore the database with another right-click. You can also
use Query Analyzer and the Transact-SQL statments (BACKUP and RESTORE) to
perform the backup and restore. Another technique is to use sp_detach_db
and sp_attach_db.
For more information see these topics in the SQL Server Books Online.
Also look at :
HOW TO: Move Databases Between Computers That Are Running SQL Server
http://support.microsoft.com/defaul...kb;en-us;314546
HTH
Jerry
"Nando_uy" <Nandouy@.discussions.microsoft.com> wrote in message
news:2142AE07-CEEE-4FC1-AE1F-D33F417F6D4D@.microsoft.com...
> Hello all...I develop a Database in a Local Instance of a server.
> Then, I need to install ALL the New database in a remote server using TCP
> connection and, I have no idea how script them and how can I execute this
> script remotely. Obviously, I have Administrator permissions on this
> server
> (W2K3).
> Any Idea?
> Some sample to clarify me the concept?
> Thankssql
Then, I need to install ALL the New database in a remote server using TCP
connection and, I have no idea how script them and how can I execute this
script remotely. Obviously, I have Administrator permissions on this server
(W2K3).
Any Idea?
Some sample to clarify me the concept?
ThanksIf you're using Enterprise Manager, you can register the remote server with
the local server in EM. Perform a backup of the database with a
right-click, copy the backup file to the remote server (same location if
possible) then restore the database with another right-click. You can also
use Query Analyzer and the Transact-SQL statments (BACKUP and RESTORE) to
perform the backup and restore. Another technique is to use sp_detach_db
and sp_attach_db.
For more information see these topics in the SQL Server Books Online.
Also look at :
HOW TO: Move Databases Between Computers That Are Running SQL Server
http://support.microsoft.com/defaul...kb;en-us;314546
HTH
Jerry
"Nando_uy" <Nandouy@.discussions.microsoft.com> wrote in message
news:2142AE07-CEEE-4FC1-AE1F-D33F417F6D4D@.microsoft.com...
> Hello all...I develop a Database in a Local Instance of a server.
> Then, I need to install ALL the New database in a remote server using TCP
> connection and, I have no idea how script them and how can I execute this
> script remotely. Obviously, I have Administrator permissions on this
> server
> (W2K3).
> Any Idea?
> Some sample to clarify me the concept?
> Thankssql
Installing a Database
Hello all...I develop a Database in a Local Instance of a server.
Then, I need to install ALL the New database in a remote server using TCP
connection and, I have no idea how script them and how can I execute this
script remotely. Obviously, I have Administrator permissions on this server
(W2K3).
Any Idea?
Some sample to clarify me the concept?
ThanksIf you're using Enterprise Manager, you can register the remote server with
the local server in EM. Perform a backup of the database with a
right-click, copy the backup file to the remote server (same location if
possible) then restore the database with another right-click. You can also
use Query Analyzer and the Transact-SQL statments (BACKUP and RESTORE) to
perform the backup and restore. Another technique is to use sp_detach_db
and sp_attach_db.
For more information see these topics in the SQL Server Books Online.
Also look at :
HOW TO: Move Databases Between Computers That Are Running SQL Server
http://support.microsoft.com/default.aspx?scid=kb;en-us;314546
HTH
Jerry
"Nando_uy" <Nandouy@.discussions.microsoft.com> wrote in message
news:2142AE07-CEEE-4FC1-AE1F-D33F417F6D4D@.microsoft.com...
> Hello all...I develop a Database in a Local Instance of a server.
> Then, I need to install ALL the New database in a remote server using TCP
> connection and, I have no idea how script them and how can I execute this
> script remotely. Obviously, I have Administrator permissions on this
> server
> (W2K3).
> Any Idea?
> Some sample to clarify me the concept?
> Thanks
Then, I need to install ALL the New database in a remote server using TCP
connection and, I have no idea how script them and how can I execute this
script remotely. Obviously, I have Administrator permissions on this server
(W2K3).
Any Idea?
Some sample to clarify me the concept?
ThanksIf you're using Enterprise Manager, you can register the remote server with
the local server in EM. Perform a backup of the database with a
right-click, copy the backup file to the remote server (same location if
possible) then restore the database with another right-click. You can also
use Query Analyzer and the Transact-SQL statments (BACKUP and RESTORE) to
perform the backup and restore. Another technique is to use sp_detach_db
and sp_attach_db.
For more information see these topics in the SQL Server Books Online.
Also look at :
HOW TO: Move Databases Between Computers That Are Running SQL Server
http://support.microsoft.com/default.aspx?scid=kb;en-us;314546
HTH
Jerry
"Nando_uy" <Nandouy@.discussions.microsoft.com> wrote in message
news:2142AE07-CEEE-4FC1-AE1F-D33F417F6D4D@.microsoft.com...
> Hello all...I develop a Database in a Local Instance of a server.
> Then, I need to install ALL the New database in a remote server using TCP
> connection and, I have no idea how script them and how can I execute this
> script remotely. Obviously, I have Administrator permissions on this
> server
> (W2K3).
> Any Idea?
> Some sample to clarify me the concept?
> Thanks
Wednesday, March 21, 2012
Installed SQL2005: now can't access SQL2000 (Local) in EM
After installing SQL2005 (with a new instance), I couldn't access my previous
(local) server through Enterprise Mnager, although I can access it through
Query Analyser.
I deleted the connection in Enterprise manager and tried to recreate it
(using either windows security or SQL Autentication): get the message 'Client
unable to establish connection. TCP Provider: No connection could be made
because the target machine actively refused it.'
Ashley,
Earlier versions of SQL Server 2005 had a tendancy to trash the SQL Server
2000 tools, perhaps this is your issue. I always put SQL 2005 into a virtual
machine and will keep it there until it RTMs, unless I can install it on a
fresh machine without SQL Server 2000 on.
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602m.html
"Ashley Brewerton" wrote:
> After installing SQL2005 (with a new instance), I couldn't access my previous
> (local) server through Enterprise Mnager, although I can access it through
> Query Analyser.
> I deleted the connection in Enterprise manager and tried to recreate it
> (using either windows security or SQL Autentication): get the message 'Client
> unable to establish connection. TCP Provider: No connection could be made
> because the target machine actively refused it.'
|||You should re-register SQLDMO.DLL using:
regsvr32 "C:\Program Files\Microsoft SQL
Server\80\Tools\Binn\sqldmo.dll"
Razvan
|||Thanks Razvan: after restarting the services that worked perfectly.
Ashley
"Razvan Socol" wrote:
> You should re-register SQLDMO.DLL using:
> regsvr32 "C:\Program Files\Microsoft SQL
> Server\80\Tools\Binn\sqldmo.dll"
> Razvan
>
(local) server through Enterprise Mnager, although I can access it through
Query Analyser.
I deleted the connection in Enterprise manager and tried to recreate it
(using either windows security or SQL Autentication): get the message 'Client
unable to establish connection. TCP Provider: No connection could be made
because the target machine actively refused it.'
Ashley,
Earlier versions of SQL Server 2005 had a tendancy to trash the SQL Server
2000 tools, perhaps this is your issue. I always put SQL 2005 into a virtual
machine and will keep it there until it RTMs, unless I can install it on a
fresh machine without SQL Server 2000 on.
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602m.html
"Ashley Brewerton" wrote:
> After installing SQL2005 (with a new instance), I couldn't access my previous
> (local) server through Enterprise Mnager, although I can access it through
> Query Analyser.
> I deleted the connection in Enterprise manager and tried to recreate it
> (using either windows security or SQL Autentication): get the message 'Client
> unable to establish connection. TCP Provider: No connection could be made
> because the target machine actively refused it.'
|||You should re-register SQLDMO.DLL using:
regsvr32 "C:\Program Files\Microsoft SQL
Server\80\Tools\Binn\sqldmo.dll"
Razvan
|||Thanks Razvan: after restarting the services that worked perfectly.
Ashley
"Razvan Socol" wrote:
> You should re-register SQLDMO.DLL using:
> regsvr32 "C:\Program Files\Microsoft SQL
> Server\80\Tools\Binn\sqldmo.dll"
> Razvan
>
Installed SQL2005: now can't access SQL2000 (Local) in EM
After installing SQL2005 (with a new instance), I couldn't access my previou
s
(local) server through Enterprise Mnager, although I can access it through
Query Analyser.
I deleted the connection in Enterprise manager and tried to recreate it
(using either windows security or SQL Autentication): get the message 'Clien
t
unable to establish connection. TCP Provider: No connection could be made
because the target machine actively refused it.'Ashley,
Earlier versions of SQL Server 2005 had a tendancy to trash the SQL Server
2000 tools, perhaps this is your issue. I always put SQL 2005 into a virtual
machine and will keep it there until it RTMs, unless I can install it on a
fresh machine without SQL Server 2000 on.
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602m.html
"Ashley Brewerton" wrote:
> After installing SQL2005 (with a new instance), I couldn't access my previ
ous
> (local) server through Enterprise Mnager, although I can access it through
> Query Analyser.
> I deleted the connection in Enterprise manager and tried to recreate it
> (using either windows security or SQL Autentication): get the message 'Cli
ent
> unable to establish connection. TCP Provider: No connection could be made
> because the target machine actively refused it.'|||You should re-register SQLDMO.DLL using:
regsvr32 "C:\Program Files\Microsoft SQL
Server\80\Tools\Binn\sqldmo.dll"
Razvan|||Thanks Razvan: after restarting the services that worked perfectly.
Ashley
"Razvan Socol" wrote:
> You should re-register SQLDMO.DLL using:
> regsvr32 "C:\Program Files\Microsoft SQL
> Server\80\Tools\Binn\sqldmo.dll"
> Razvan
>sql
s
(local) server through Enterprise Mnager, although I can access it through
Query Analyser.
I deleted the connection in Enterprise manager and tried to recreate it
(using either windows security or SQL Autentication): get the message 'Clien
t
unable to establish connection. TCP Provider: No connection could be made
because the target machine actively refused it.'Ashley,
Earlier versions of SQL Server 2005 had a tendancy to trash the SQL Server
2000 tools, perhaps this is your issue. I always put SQL 2005 into a virtual
machine and will keep it there until it RTMs, unless I can install it on a
fresh machine without SQL Server 2000 on.
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602m.html
"Ashley Brewerton" wrote:
> After installing SQL2005 (with a new instance), I couldn't access my previ
ous
> (local) server through Enterprise Mnager, although I can access it through
> Query Analyser.
> I deleted the connection in Enterprise manager and tried to recreate it
> (using either windows security or SQL Autentication): get the message 'Cli
ent
> unable to establish connection. TCP Provider: No connection could be made
> because the target machine actively refused it.'|||You should re-register SQLDMO.DLL using:
regsvr32 "C:\Program Files\Microsoft SQL
Server\80\Tools\Binn\sqldmo.dll"
Razvan|||Thanks Razvan: after restarting the services that worked perfectly.
Ashley
"Razvan Socol" wrote:
> You should re-register SQLDMO.DLL using:
> regsvr32 "C:\Program Files\Microsoft SQL
> Server\80\Tools\Binn\sqldmo.dll"
> Razvan
>sql
Installed SQL2005: now can't access SQL2000 (Local) in EM
After installing SQL2005 (with a new instance), I couldn't access my previous
(local) server through Enterprise Mnager, although I can access it through
Query Analyser.
I deleted the connection in Enterprise manager and tried to recreate it
(using either windows security or SQL Autentication): get the message 'Client
unable to establish connection. TCP Provider: No connection could be made
because the target machine actively refused it.'Ashley,
Earlier versions of SQL Server 2005 had a tendancy to trash the SQL Server
2000 tools, perhaps this is your issue. I always put SQL 2005 into a virtual
machine and will keep it there until it RTMs, unless I can install it on a
fresh machine without SQL Server 2000 on.
--
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602m.html
"Ashley Brewerton" wrote:
> After installing SQL2005 (with a new instance), I couldn't access my previous
> (local) server through Enterprise Mnager, although I can access it through
> Query Analyser.
> I deleted the connection in Enterprise manager and tried to recreate it
> (using either windows security or SQL Autentication): get the message 'Client
> unable to establish connection. TCP Provider: No connection could be made
> because the target machine actively refused it.'|||You should re-register SQLDMO.DLL using:
regsvr32 "C:\Program Files\Microsoft SQL
Server\80\Tools\Binn\sqldmo.dll"
Razvan|||Thanks Razvan: after restarting the services that worked perfectly.
Ashley
"Razvan Socol" wrote:
> You should re-register SQLDMO.DLL using:
> regsvr32 "C:\Program Files\Microsoft SQL
> Server\80\Tools\Binn\sqldmo.dll"
> Razvan
>
(local) server through Enterprise Mnager, although I can access it through
Query Analyser.
I deleted the connection in Enterprise manager and tried to recreate it
(using either windows security or SQL Autentication): get the message 'Client
unable to establish connection. TCP Provider: No connection could be made
because the target machine actively refused it.'Ashley,
Earlier versions of SQL Server 2005 had a tendancy to trash the SQL Server
2000 tools, perhaps this is your issue. I always put SQL 2005 into a virtual
machine and will keep it there until it RTMs, unless I can install it on a
fresh machine without SQL Server 2000 on.
--
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602m.html
"Ashley Brewerton" wrote:
> After installing SQL2005 (with a new instance), I couldn't access my previous
> (local) server through Enterprise Mnager, although I can access it through
> Query Analyser.
> I deleted the connection in Enterprise manager and tried to recreate it
> (using either windows security or SQL Autentication): get the message 'Client
> unable to establish connection. TCP Provider: No connection could be made
> because the target machine actively refused it.'|||You should re-register SQLDMO.DLL using:
regsvr32 "C:\Program Files\Microsoft SQL
Server\80\Tools\Binn\sqldmo.dll"
Razvan|||Thanks Razvan: after restarting the services that worked perfectly.
Ashley
"Razvan Socol" wrote:
> You should re-register SQLDMO.DLL using:
> regsvr32 "C:\Program Files\Microsoft SQL
> Server\80\Tools\Binn\sqldmo.dll"
> Razvan
>
Installed Quick Start on Local Computer - Need new SQL Instance
Hello, PLEASE Help me.
I have just installed the Quick Starts on my local machine, and it mentions that you will need a new instance of SQL called (local)/NetSDK.
I already have the MS Personal Edition and the tutorials say to download the MS Desktop Engine.
So what do i need to do in order to get teh Quick Start samples to work locally?
Can i not just use my own instance and use the Grocer and other Databases there?
Please HelpYou don't have to install MSDE if you have the SQL Server personal Edition installed but you need to use the Microsoft Datalink property at the top of Visual studio to connect to your database. Hope this helps.sql
I have just installed the Quick Starts on my local machine, and it mentions that you will need a new instance of SQL called (local)/NetSDK.
I already have the MS Personal Edition and the tutorials say to download the MS Desktop Engine.
So what do i need to do in order to get teh Quick Start samples to work locally?
Can i not just use my own instance and use the Grocer and other Databases there?
Please HelpYou don't have to install MSDE if you have the SQL Server personal Edition installed but you need to use the Microsoft Datalink property at the top of Visual studio to connect to your database. Hope this helps.sql
Monday, March 19, 2012
installation steps
hi !!!
i try to connect to my sql server local instance but it is always failed .... can you please tell me the step by steps and options to use to install sql server on my machine and i think i need to use he personal copy rather than the standard as it will be on my machne not in the server? please helpThe way I install SQL Server and any other database on Windows, I don't answer questions Windows ask me during installation because Windows does not know RDBMS and all your installation will complete. So you answer one or two relevant questions and you can install even Oracle. Hope this helps|||
fadil, whichs the OS on which ur trying to install the sql server?
just go thru this ,
http://www.functionx.com/sql/Lesson01.htm
hope this works..
all the best
i try to connect to my sql server local instance but it is always failed .... can you please tell me the step by steps and options to use to install sql server on my machine and i think i need to use he personal copy rather than the standard as it will be on my machne not in the server? please helpThe way I install SQL Server and any other database on Windows, I don't answer questions Windows ask me during installation because Windows does not know RDBMS and all your installation will complete. So you answer one or two relevant questions and you can install even Oracle. Hope this helps|||
thanks for reply .... but there is a reply to those questions in choosing options.... can you tell me in each step what shal i choose ?
|||When you are asked what option don't choose custom and the only other question that is relevant to you is the account to use to install and being a developer use the local system account and you can install the personal in less than five minutes. When you answer questions Windows checks those against what is in its database and end your installation. Hope this helps.|||let me expalin toyou the problem...i have machine at work i installed sql server before it was fine ...i did the same thing in my machine at home it does not work ..i can nto connect to the database.... can you please help i try connectionstrings.com and i tried different things still does not work .. please help !!|||In Visual Studio use the datalink property and use integrated security, all the answers I have been giving you are to install the database. And post your error so it can be investigated. Hope this helps.|||Hi,
fadil, whichs the OS on which ur trying to install the sql server?
just go thru this ,
http://www.functionx.com/sql/Lesson01.htm
hope this works..
all the best
Installation question
Hi,
I have MSDE (SQL server) running various workstations within my home
network. I have no problem connecting to the SQL server instance on
each local machine but when I try to connect to a SQL server on one of
the other workstations I get errors indicating that the Server cannot
be found. However, if I use Widows XP ODBC manager I can create a
system DSN that passes the connection test.
Was I supposed to do something to allow SQL server to be used by other
workstations?
Thanks
hi,
ZRexRider wrote:
> Hi,
> I have MSDE (SQL server) running various workstations within my home
> network. I have no problem connecting to the SQL server instance on
> each local machine but when I try to connect to a SQL server on one of
> the other workstations I get errors indicating that the Server cannot
> be found. However, if I use Widows XP ODBC manager I can create a
> system DSN that passes the connection test.
> Was I supposed to do something to allow SQL server to be used by other
> workstations?
> Thanks
please verify each MSDE instance, on each computer, has the required/desired
network protocols enabled..
use the Server Network Utility (svrnetcn.exe)
MSDE installs by default disabling network protocols, but you can override
this setting at install time specifying the
DISABLENETWORKPROTOCOLS=0
parameter to the setup.exe boostrap installer..
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.14.0 - DbaMgr ver 0.59.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
I have MSDE (SQL server) running various workstations within my home
network. I have no problem connecting to the SQL server instance on
each local machine but when I try to connect to a SQL server on one of
the other workstations I get errors indicating that the Server cannot
be found. However, if I use Widows XP ODBC manager I can create a
system DSN that passes the connection test.
Was I supposed to do something to allow SQL server to be used by other
workstations?
Thanks
hi,
ZRexRider wrote:
> Hi,
> I have MSDE (SQL server) running various workstations within my home
> network. I have no problem connecting to the SQL server instance on
> each local machine but when I try to connect to a SQL server on one of
> the other workstations I get errors indicating that the Server cannot
> be found. However, if I use Widows XP ODBC manager I can create a
> system DSN that passes the connection test.
> Was I supposed to do something to allow SQL server to be used by other
> workstations?
> Thanks
please verify each MSDE instance, on each computer, has the required/desired
network protocols enabled..
use the Server Network Utility (svrnetcn.exe)
MSDE installs by default disabling network protocols, but you can override
this setting at install time specifying the
DISABLENETWORKPROTOCOLS=0
parameter to the setup.exe boostrap installer..
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.14.0 - DbaMgr ver 0.59.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
Friday, March 9, 2012
Installation problem
I'm trying to install SQL Server 2000 developer edition on my notebook,
but every time i select option for installation on local computer a get
following message:
A previous program installation created pendng file operations on the
installation machine. You must restart the computer before running
setup.
Restart doesn't help.I manualy clean all temporary folders, and check
Run section of registry. Any other installation on computer is running
without any problems. Does anybody know how to solve this?
Sale
As I undestood from your post , you have already installed SQL Server 2000
previously and used Add Remove Program to uninstall it , am I right?
"Sale" <aleksandar.stancic@.gmail.com> wrote in message
news:1164703735.718730.73040@.80g2000cwy.googlegrou ps.com...
> I'm trying to install SQL Server 2000 developer edition on my notebook,
> but every time i select option for installation on local computer a get
> following message:
> A previous program installation created pendng file operations on the
> installation machine. You must restart the computer before running
> setup.
> Restart doesn't help.I manualy clean all temporary folders, and check
> Run section of registry. Any other installation on computer is running
> without any problems. Does anybody know how to solve this?
>
|||No Uri,
I'm trying to install new instance of SQL Server. It was never
installed on that computer before.
Uri Dimant wrote:
> Sale
> As I undestood from your post , you have already installed SQL Server 2000
> previously and used Add Remove Program to uninstall it , am I right?
>
>
|||Aha , I see, well I have been installing many times and have not seen such
problems ,can you unisnstall a default instance /reinstall it and try
again?
"Sale" <aleksandar.stancic@.gmail.com> wrote in message
news:1164704553.068893.125430@.j72g2000cwa.googlegr oups.com...
> No Uri,
> I'm trying to install new instance of SQL Server. It was never
> installed on that computer before.
> Uri Dimant wrote:
>
|||I cannot unistal the instance, as i already said i can't install it
first time, so there is nothing to uninstall :-)
Uri Dimant wrote:
> Aha , I see, well I have been installing many times and have not seen such
> problems ,can you unisnstall a default instance /reinstall it and try
> again?
>
|||Sale
Sorry, I tought you have already a DEFAULT instanse and try to install a
NAMED one, so I thin you have to go thru a registry and remove any
refernces to SQL Server if there are any.
"Sale" <aleksandar.stancic@.gmail.com> wrote in message
news:1164706022.879333.88450@.l12g2000cwl.googlegro ups.com...
>I cannot unistal the instance, as i already said i can't install it
> first time, so there is nothing to uninstall :-)
> Uri Dimant wrote:
>
|||I checked every corner of registry, and temp folders but no results.
I give up i'll reinstall entire windows
Uri Dimant wrote:
> Sale
> Sorry, I tought you have already a DEFAULT instanse and try to install a
> NAMED one, so I thin you have to go thru a registry and remove any
> refernces to SQL Server if there are any.
>
|||Check this registry key and clear out the value if it is there:
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Contro l\Session
Manager\PendingFileRenameOperations
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
"Sale" <aleksandar.stancic@.gmail.com> wrote in message
news:1164703735.718730.73040@.80g2000cwy.googlegrou ps.com...
> I'm trying to install SQL Server 2000 developer edition on my notebook,
> but every time i select option for installation on local computer a get
> following message:
> A previous program installation created pendng file operations on the
> installation machine. You must restart the computer before running
> setup.
> Restart doesn't help.I manualy clean all temporary folders, and check
> Run section of registry. Any other installation on computer is running
> without any problems. Does anybody know how to solve this?
>
but every time i select option for installation on local computer a get
following message:
A previous program installation created pendng file operations on the
installation machine. You must restart the computer before running
setup.
Restart doesn't help.I manualy clean all temporary folders, and check
Run section of registry. Any other installation on computer is running
without any problems. Does anybody know how to solve this?
Sale
As I undestood from your post , you have already installed SQL Server 2000
previously and used Add Remove Program to uninstall it , am I right?
"Sale" <aleksandar.stancic@.gmail.com> wrote in message
news:1164703735.718730.73040@.80g2000cwy.googlegrou ps.com...
> I'm trying to install SQL Server 2000 developer edition on my notebook,
> but every time i select option for installation on local computer a get
> following message:
> A previous program installation created pendng file operations on the
> installation machine. You must restart the computer before running
> setup.
> Restart doesn't help.I manualy clean all temporary folders, and check
> Run section of registry. Any other installation on computer is running
> without any problems. Does anybody know how to solve this?
>
|||No Uri,
I'm trying to install new instance of SQL Server. It was never
installed on that computer before.
Uri Dimant wrote:
> Sale
> As I undestood from your post , you have already installed SQL Server 2000
> previously and used Add Remove Program to uninstall it , am I right?
>
>
|||Aha , I see, well I have been installing many times and have not seen such
problems ,can you unisnstall a default instance /reinstall it and try
again?
"Sale" <aleksandar.stancic@.gmail.com> wrote in message
news:1164704553.068893.125430@.j72g2000cwa.googlegr oups.com...
> No Uri,
> I'm trying to install new instance of SQL Server. It was never
> installed on that computer before.
> Uri Dimant wrote:
>
|||I cannot unistal the instance, as i already said i can't install it
first time, so there is nothing to uninstall :-)
Uri Dimant wrote:
> Aha , I see, well I have been installing many times and have not seen such
> problems ,can you unisnstall a default instance /reinstall it and try
> again?
>
|||Sale
Sorry, I tought you have already a DEFAULT instanse and try to install a
NAMED one, so I thin you have to go thru a registry and remove any
refernces to SQL Server if there are any.
"Sale" <aleksandar.stancic@.gmail.com> wrote in message
news:1164706022.879333.88450@.l12g2000cwl.googlegro ups.com...
>I cannot unistal the instance, as i already said i can't install it
> first time, so there is nothing to uninstall :-)
> Uri Dimant wrote:
>
|||I checked every corner of registry, and temp folders but no results.
I give up i'll reinstall entire windows
Uri Dimant wrote:
> Sale
> Sorry, I tought you have already a DEFAULT instanse and try to install a
> NAMED one, so I thin you have to go thru a registry and remove any
> refernces to SQL Server if there are any.
>
|||Check this registry key and clear out the value if it is there:
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Contro l\Session
Manager\PendingFileRenameOperations
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
"Sale" <aleksandar.stancic@.gmail.com> wrote in message
news:1164703735.718730.73040@.80g2000cwy.googlegrou ps.com...
> I'm trying to install SQL Server 2000 developer edition on my notebook,
> but every time i select option for installation on local computer a get
> following message:
> A previous program installation created pendng file operations on the
> installation machine. You must restart the computer before running
> setup.
> Restart doesn't help.I manualy clean all temporary folders, and check
> Run section of registry. Any other installation on computer is running
> without any problems. Does anybody know how to solve this?
>
Installation problem
I'm trying to install SQL Server 2000 developer edition on my notebook,
but every time i select option for installation on local computer a get
following message:
A previous program installation created pendng file operations on the
installation machine. You must restart the computer before running
setup.
Restart doesn't help.I manualy clean all temporary folders, and check
Run section of registry. Any other installation on computer is running
without any problems. Does anybody know how to solve this?Sale
As I undestood from your post , you have already installed SQL Server 2000
previously and used Add Remove Program to uninstall it , am I right?
"Sale" <aleksandar.stancic@.gmail.com> wrote in message
news:1164703735.718730.73040@.80g2000cwy.googlegroups.com...
> I'm trying to install SQL Server 2000 developer edition on my notebook,
> but every time i select option for installation on local computer a get
> following message:
> A previous program installation created pendng file operations on the
> installation machine. You must restart the computer before running
> setup.
> Restart doesn't help.I manualy clean all temporary folders, and check
> Run section of registry. Any other installation on computer is running
> without any problems. Does anybody know how to solve this?
>|||No Uri,
I'm trying to install new instance of SQL Server. It was never
installed on that computer before.
Uri Dimant wrote:
> Sale
> As I undestood from your post , you have already installed SQL Server 2000
> previously and used Add Remove Program to uninstall it , am I right?
>
>|||Aha , I see, well I have been installing many times and have not seen such
problems ,can you unisnstall a default instance /reinstall it and try
again?
"Sale" <aleksandar.stancic@.gmail.com> wrote in message
news:1164704553.068893.125430@.j72g2000cwa.googlegroups.com...
> No Uri,
> I'm trying to install new instance of SQL Server. It was never
> installed on that computer before.
> Uri Dimant wrote:
>> Sale
>> As I undestood from your post , you have already installed SQL Server
>> 2000
>> previously and used Add Remove Program to uninstall it , am I right?
>>
>|||I cannot unistal the instance, as i already said i can't install it
first time, so there is nothing to uninstall :-)
Uri Dimant wrote:
> Aha , I see, well I have been installing many times and have not seen such
> problems ,can you unisnstall a default instance /reinstall it and try
> again?
>|||Sale
Sorry, I tought you have already a DEFAULT instanse and try to install a
NAMED one, so I thin you have to go thru a registry and remove any
refernces to SQL Server if there are any.
"Sale" <aleksandar.stancic@.gmail.com> wrote in message
news:1164706022.879333.88450@.l12g2000cwl.googlegroups.com...
>I cannot unistal the instance, as i already said i can't install it
> first time, so there is nothing to uninstall :-)
> Uri Dimant wrote:
>> Aha , I see, well I have been installing many times and have not seen
>> such
>> problems ,can you unisnstall a default instance /reinstall it and try
>> again?
>>
>|||I checked every corner of registry, and temp folders but no results.
I give up i'll reinstall entire windows
Uri Dimant wrote:
> Sale
> Sorry, I tought you have already a DEFAULT instanse and try to install a
> NAMED one, so I thin you have to go thru a registry and remove any
> refernces to SQL Server if there are any.
>|||The problem is that setup *thinks* you have done some installation process and the machine need a
reboot. This installation process could be any software. So, what you need to do is to clean up the
registry entry where it says that a re-boot is needed. Google for suitable elements of the error
message and you will find a KB article explaining just how to do that. You can post back if you
can't find the KB article.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Sale" <aleksandar.stancic@.gmail.com> wrote in message
news:1164703735.718730.73040@.80g2000cwy.googlegroups.com...
> I'm trying to install SQL Server 2000 developer edition on my notebook,
> but every time i select option for installation on local computer a get
> following message:
> A previous program installation created pendng file operations on the
> installation machine. You must restart the computer before running
> setup.
> Restart doesn't help.I manualy clean all temporary folders, and check
> Run section of registry. Any other installation on computer is running
> without any problems. Does anybody know how to solve this?
>|||Check this registry key and clear out the value if it is there:
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Session
Manager\PendingFileRenameOperations
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
"Sale" <aleksandar.stancic@.gmail.com> wrote in message
news:1164703735.718730.73040@.80g2000cwy.googlegroups.com...
> I'm trying to install SQL Server 2000 developer edition on my notebook,
> but every time i select option for installation on local computer a get
> following message:
> A previous program installation created pendng file operations on the
> installation machine. You must restart the computer before running
> setup.
> Restart doesn't help.I manualy clean all temporary folders, and check
> Run section of registry. Any other installation on computer is running
> without any problems. Does anybody know how to solve this?
>
but every time i select option for installation on local computer a get
following message:
A previous program installation created pendng file operations on the
installation machine. You must restart the computer before running
setup.
Restart doesn't help.I manualy clean all temporary folders, and check
Run section of registry. Any other installation on computer is running
without any problems. Does anybody know how to solve this?Sale
As I undestood from your post , you have already installed SQL Server 2000
previously and used Add Remove Program to uninstall it , am I right?
"Sale" <aleksandar.stancic@.gmail.com> wrote in message
news:1164703735.718730.73040@.80g2000cwy.googlegroups.com...
> I'm trying to install SQL Server 2000 developer edition on my notebook,
> but every time i select option for installation on local computer a get
> following message:
> A previous program installation created pendng file operations on the
> installation machine. You must restart the computer before running
> setup.
> Restart doesn't help.I manualy clean all temporary folders, and check
> Run section of registry. Any other installation on computer is running
> without any problems. Does anybody know how to solve this?
>|||No Uri,
I'm trying to install new instance of SQL Server. It was never
installed on that computer before.
Uri Dimant wrote:
> Sale
> As I undestood from your post , you have already installed SQL Server 2000
> previously and used Add Remove Program to uninstall it , am I right?
>
>|||Aha , I see, well I have been installing many times and have not seen such
problems ,can you unisnstall a default instance /reinstall it and try
again?
"Sale" <aleksandar.stancic@.gmail.com> wrote in message
news:1164704553.068893.125430@.j72g2000cwa.googlegroups.com...
> No Uri,
> I'm trying to install new instance of SQL Server. It was never
> installed on that computer before.
> Uri Dimant wrote:
>> Sale
>> As I undestood from your post , you have already installed SQL Server
>> 2000
>> previously and used Add Remove Program to uninstall it , am I right?
>>
>|||I cannot unistal the instance, as i already said i can't install it
first time, so there is nothing to uninstall :-)
Uri Dimant wrote:
> Aha , I see, well I have been installing many times and have not seen such
> problems ,can you unisnstall a default instance /reinstall it and try
> again?
>|||Sale
Sorry, I tought you have already a DEFAULT instanse and try to install a
NAMED one, so I thin you have to go thru a registry and remove any
refernces to SQL Server if there are any.
"Sale" <aleksandar.stancic@.gmail.com> wrote in message
news:1164706022.879333.88450@.l12g2000cwl.googlegroups.com...
>I cannot unistal the instance, as i already said i can't install it
> first time, so there is nothing to uninstall :-)
> Uri Dimant wrote:
>> Aha , I see, well I have been installing many times and have not seen
>> such
>> problems ,can you unisnstall a default instance /reinstall it and try
>> again?
>>
>|||I checked every corner of registry, and temp folders but no results.
I give up i'll reinstall entire windows
Uri Dimant wrote:
> Sale
> Sorry, I tought you have already a DEFAULT instanse and try to install a
> NAMED one, so I thin you have to go thru a registry and remove any
> refernces to SQL Server if there are any.
>|||The problem is that setup *thinks* you have done some installation process and the machine need a
reboot. This installation process could be any software. So, what you need to do is to clean up the
registry entry where it says that a re-boot is needed. Google for suitable elements of the error
message and you will find a KB article explaining just how to do that. You can post back if you
can't find the KB article.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Sale" <aleksandar.stancic@.gmail.com> wrote in message
news:1164703735.718730.73040@.80g2000cwy.googlegroups.com...
> I'm trying to install SQL Server 2000 developer edition on my notebook,
> but every time i select option for installation on local computer a get
> following message:
> A previous program installation created pendng file operations on the
> installation machine. You must restart the computer before running
> setup.
> Restart doesn't help.I manualy clean all temporary folders, and check
> Run section of registry. Any other installation on computer is running
> without any problems. Does anybody know how to solve this?
>|||Check this registry key and clear out the value if it is there:
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Session
Manager\PendingFileRenameOperations
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
"Sale" <aleksandar.stancic@.gmail.com> wrote in message
news:1164703735.718730.73040@.80g2000cwy.googlegroups.com...
> I'm trying to install SQL Server 2000 developer edition on my notebook,
> but every time i select option for installation on local computer a get
> following message:
> A previous program installation created pendng file operations on the
> installation machine. You must restart the computer before running
> setup.
> Restart doesn't help.I manualy clean all temporary folders, and check
> Run section of registry. Any other installation on computer is running
> without any problems. Does anybody know how to solve this?
>
Installation problem
I'm trying to install SQL Server 2000 developer edition on my notebook,
but every time i select option for installation on local computer a get
following message:
A previous program installation created pendng file operations on the
installation machine. You must restart the computer before running
setup.
Restart doesn't help.I manualy clean all temporary folders, and check
Run section of registry. Any other installation on computer is running
without any problems. Does anybody know how to solve this?Sale
As I undestood from your post , you have already installed SQL Server 2000
previously and used Add Remove Program to uninstall it , am I right?
"Sale" <aleksandar.stancic@.gmail.com> wrote in message
news:1164703735.718730.73040@.80g2000cwy.googlegroups.com...
> I'm trying to install SQL Server 2000 developer edition on my notebook,
> but every time i select option for installation on local computer a get
> following message:
> A previous program installation created pendng file operations on the
> installation machine. You must restart the computer before running
> setup.
> Restart doesn't help.I manualy clean all temporary folders, and check
> Run section of registry. Any other installation on computer is running
> without any problems. Does anybody know how to solve this?
>|||No Uri,
I'm trying to install new instance of SQL Server. It was never
installed on that computer before.
Uri Dimant wrote:
> Sale
> As I undestood from your post , you have already installed SQL Server 2000
> previously and used Add Remove Program to uninstall it , am I right?
>
>|||Aha , I see, well I have been installing many times and have not seen such
problems ,can you unisnstall a default instance /reinstall it and try
again?
"Sale" <aleksandar.stancic@.gmail.com> wrote in message
news:1164704553.068893.125430@.j72g2000cwa.googlegroups.com...
> No Uri,
> I'm trying to install new instance of SQL Server. It was never
> installed on that computer before.
> Uri Dimant wrote:
>|||I cannot unistal the instance, as i already said i can't install it
first time, so there is nothing to uninstall :-)
Uri Dimant wrote:
> Aha , I see, well I have been installing many times and have not seen such
> problems ,can you unisnstall a default instance /reinstall it and try
> again?
>|||Sale
Sorry, I tought you have already a DEFAULT instanse and try to install a
NAMED one, so I thin you have to go thru a registry and remove any
refernces to SQL Server if there are any.
"Sale" <aleksandar.stancic@.gmail.com> wrote in message
news:1164706022.879333.88450@.l12g2000cwl.googlegroups.com...
>I cannot unistal the instance, as i already said i can't install it
> first time, so there is nothing to uninstall :-)
> Uri Dimant wrote:
>|||I checked every corner of registry, and temp folders but no results.
I give up i'll reinstall entire windows
Uri Dimant wrote:
> Sale
> Sorry, I tought you have already a DEFAULT instanse and try to install a
> NAMED one, so I thin you have to go thru a registry and remove any
> refernces to SQL Server if there are any.
>|||The problem is that setup *thinks* you have done some installation process a
nd the machine need a
reboot. This installation process could be any software. So, what you need t
o do is to clean up the
registry entry where it says that a re-boot is needed. Google for suitable e
lements of the error
message and you will find a KB article explaining just how to do that. You c
an post back if you
can't find the KB article.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Sale" <aleksandar.stancic@.gmail.com> wrote in message
news:1164703735.718730.73040@.80g2000cwy.googlegroups.com...
> I'm trying to install SQL Server 2000 developer edition on my notebook,
> but every time i select option for installation on local computer a get
> following message:
> A previous program installation created pendng file operations on the
> installation machine. You must restart the computer before running
> setup.
> Restart doesn't help.I manualy clean all temporary folders, and check
> Run section of registry. Any other installation on computer is running
> without any problems. Does anybody know how to solve this?
>|||Check this registry key and clear out the value if it is there:
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControl
Set\Control\Session
Manager\PendingFileRenameOperations
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
"Sale" <aleksandar.stancic@.gmail.com> wrote in message
news:1164703735.718730.73040@.80g2000cwy.googlegroups.com...
> I'm trying to install SQL Server 2000 developer edition on my notebook,
> but every time i select option for installation on local computer a get
> following message:
> A previous program installation created pendng file operations on the
> installation machine. You must restart the computer before running
> setup.
> Restart doesn't help.I manualy clean all temporary folders, and check
> Run section of registry. Any other installation on computer is running
> without any problems. Does anybody know how to solve this?
>
but every time i select option for installation on local computer a get
following message:
A previous program installation created pendng file operations on the
installation machine. You must restart the computer before running
setup.
Restart doesn't help.I manualy clean all temporary folders, and check
Run section of registry. Any other installation on computer is running
without any problems. Does anybody know how to solve this?Sale
As I undestood from your post , you have already installed SQL Server 2000
previously and used Add Remove Program to uninstall it , am I right?
"Sale" <aleksandar.stancic@.gmail.com> wrote in message
news:1164703735.718730.73040@.80g2000cwy.googlegroups.com...
> I'm trying to install SQL Server 2000 developer edition on my notebook,
> but every time i select option for installation on local computer a get
> following message:
> A previous program installation created pendng file operations on the
> installation machine. You must restart the computer before running
> setup.
> Restart doesn't help.I manualy clean all temporary folders, and check
> Run section of registry. Any other installation on computer is running
> without any problems. Does anybody know how to solve this?
>|||No Uri,
I'm trying to install new instance of SQL Server. It was never
installed on that computer before.
Uri Dimant wrote:
> Sale
> As I undestood from your post , you have already installed SQL Server 2000
> previously and used Add Remove Program to uninstall it , am I right?
>
>|||Aha , I see, well I have been installing many times and have not seen such
problems ,can you unisnstall a default instance /reinstall it and try
again?
"Sale" <aleksandar.stancic@.gmail.com> wrote in message
news:1164704553.068893.125430@.j72g2000cwa.googlegroups.com...
> No Uri,
> I'm trying to install new instance of SQL Server. It was never
> installed on that computer before.
> Uri Dimant wrote:
>|||I cannot unistal the instance, as i already said i can't install it
first time, so there is nothing to uninstall :-)
Uri Dimant wrote:
> Aha , I see, well I have been installing many times and have not seen such
> problems ,can you unisnstall a default instance /reinstall it and try
> again?
>|||Sale
Sorry, I tought you have already a DEFAULT instanse and try to install a
NAMED one, so I thin you have to go thru a registry and remove any
refernces to SQL Server if there are any.
"Sale" <aleksandar.stancic@.gmail.com> wrote in message
news:1164706022.879333.88450@.l12g2000cwl.googlegroups.com...
>I cannot unistal the instance, as i already said i can't install it
> first time, so there is nothing to uninstall :-)
> Uri Dimant wrote:
>|||I checked every corner of registry, and temp folders but no results.
I give up i'll reinstall entire windows
Uri Dimant wrote:
> Sale
> Sorry, I tought you have already a DEFAULT instanse and try to install a
> NAMED one, so I thin you have to go thru a registry and remove any
> refernces to SQL Server if there are any.
>|||The problem is that setup *thinks* you have done some installation process a
nd the machine need a
reboot. This installation process could be any software. So, what you need t
o do is to clean up the
registry entry where it says that a re-boot is needed. Google for suitable e
lements of the error
message and you will find a KB article explaining just how to do that. You c
an post back if you
can't find the KB article.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Sale" <aleksandar.stancic@.gmail.com> wrote in message
news:1164703735.718730.73040@.80g2000cwy.googlegroups.com...
> I'm trying to install SQL Server 2000 developer edition on my notebook,
> but every time i select option for installation on local computer a get
> following message:
> A previous program installation created pendng file operations on the
> installation machine. You must restart the computer before running
> setup.
> Restart doesn't help.I manualy clean all temporary folders, and check
> Run section of registry. Any other installation on computer is running
> without any problems. Does anybody know how to solve this?
>|||Check this registry key and clear out the value if it is there:
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControl
Set\Control\Session
Manager\PendingFileRenameOperations
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
"Sale" <aleksandar.stancic@.gmail.com> wrote in message
news:1164703735.718730.73040@.80g2000cwy.googlegroups.com...
> I'm trying to install SQL Server 2000 developer edition on my notebook,
> but every time i select option for installation on local computer a get
> following message:
> A previous program installation created pendng file operations on the
> installation machine. You must restart the computer before running
> setup.
> Restart doesn't help.I manualy clean all temporary folders, and check
> Run section of registry. Any other installation on computer is running
> without any problems. Does anybody know how to solve this?
>
Installation of SQL Server 2005 on the partition disk drive
Trying to install SQL Server 2005 beta version on partition disk drive say
F:\ (Other than local disk drive c:\),
F:\ (Other than local disk drive c:\),
Does anyone know how can I do this? During the installation, it never asks
me on which drive it install to nor browse button is there to browse the
disk drive for installation...
Any help?
Thanks
J.Joriveek (nojunk@.please.com) writes:
> Trying to install SQL Server 2005 beta version on partition disk drive say
> F:\ (Other than local disk drive c:\),
> Does anyone know how can I do this? During the installation, it never asks
> me on which drive it install to nor browse button is there to browse the
> disk drive for installation...
As I recall, you need to go to the Advanced section to do this.
But part of the installations will always be in your ProgramFilesDir,
that is normally C:\Program Files.
Also, you should post your SQL 2005 to the SQL 2005 newsgroups, as these
are monitored by the SQL Server folks. See here for access:
http://go.microsoft.com/fwlink/?linkid=31765.
--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp
Wednesday, March 7, 2012
Installation of local database
I have installed SQL Sever 2000 on my Windows XP Pro machine from the
Enterprise Edition setup and it prompts you that only the client tools
can be installed. I wanted to have a local database as well So what
install should I have used to do so. Any information would greatly be
appreciated.(cjayp@.yahoo.com) writes:
Enterprise Edition runs on server operating systems only. That is,
Windows 2003 or Windows 2000 Server.
>
Enterprise Edition runs on server operating systems only. That is,
Windows 2003 or Windows 2000 Server.
>
To have a local database on your workstation, you need to install either
Developer Edition or Personal Edition. Of these Developer Edition is
surely the better choice, as it has all the features of Enterprise
Edition. It's just the licensing which is different.
>
>
--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
>
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx
Enterprise Edition setup and it prompts you that only the client tools
can be installed. I wanted to have a local database as well So what
install should I have used to do so. Any information would greatly be
appreciated.(cjayp@.yahoo.com) writes:
Quote:
Originally Posted by
I have installed SQL Sever 2000 on my Windows XP Pro machine from the
Enterprise Edition setup and it prompts you that only the client tools
can be installed. I wanted to have a local database as well So what
install should I have used to do so. Any information would greatly be
appreciated.
Enterprise Edition runs on server operating systems only. That is,
Windows 2003 or Windows 2000 Server.
To have a local database on your workstation, you need to install either
Developer Edition or Personal Edition. Of these Developer Edition is
surely the better choice, as it has all the features of Enterprise
Edition. It's just the licensing which is different.
--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx|||Thanks, I ended up installing Personal Edition, due to inability to get
DE to install correctly from only copy I had.
Erland Sommarskog wrote:
Quote:
Originally Posted by
(cjayp@.yahoo.com) writes:
Quote:
Originally Posted by
I have installed SQL Sever 2000 on my Windows XP Pro machine from the
Enterprise Edition setup and it prompts you that only the client tools
can be installed. I wanted to have a local database as well So what
install should I have used to do so. Any information would greatly be
appreciated.
>
Enterprise Edition runs on server operating systems only. That is,
Windows 2003 or Windows 2000 Server.
>
To have a local database on your workstation, you need to install either
Developer Edition or Personal Edition. Of these Developer Edition is
surely the better choice, as it has all the features of Enterprise
Edition. It's just the licensing which is different.
>
>
--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
>
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx
Installation of IS to Server
Hi,
Is there a need to install the Integration Services to a Server? Isn't it enough to just port the .dtsx file from my local drive to the server and execute it by SQL Agent using DTExec /f command?
thanks,
cherriesh
cherriesh wrote:
Hi,
Is there a need to install the Integration Services to a Server? Isn't it enough to just port the .dtsx file from my local drive to the server and execute it by SQL Agent using DTExec /f command?
thanks,
cherriesh
You won't have dtexec.exe without installing SSIS. And SSIS is required to be installed regardless, as dtexec.exe would require the SSIS dlls to execute anyway. SSIS isn't redistributable like the old DTS was.
Sunday, February 19, 2012
Installation Error
to I keep getting the following error "SQL Server Setup was unable add user NT AUTHORITY\NETWORK SERVICE to local group SQLServer2005DTSUser" everytime i try to load SQL 2005. How can i stop this to be able to complete the install?
Here are a couple of things to try:
1. Check the installation log files, located at %Program
Files%\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files for more
details on the error. (Search for the text string "value 3" to get to the failed log)
2. Try to add the service manually to the local groups using the Computer Management Admin tool. Then re-run setup.
Thanks,
Sam Lester (MSFT)
Installation Error
to I keep getting the following error "SQL Server Setup was unable add user NT AUTHORITY\NETWORK SERVICE to local group SQLServer2005DTSUser" everytime i try to load SQL 2005. How can i stop this to be able to complete the install?
Here are a couple of things to try:
1. Check the installation log files, located at %Program
Files%\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files for more
details on the error. (Search for the text string "value 3" to get to the failed log)
2. Try to add the service manually to the local groups using the Computer Management Admin tool. Then re-run setup.
Thanks,
Sam Lester (MSFT)
Subscribe to:
Posts (Atom)