problem with installation of sqlserver 2000

I have a problem with installation of sqlserver 2000.
I have a pc at home, my pc is not in a network. The
operative system installed is Windows XP professional.
When I try to install sqlserver I receive the following
message: " sqlserver 2000 enterprise edition component is
not supported in this operative system. You can install
only client components"; so I install only client
components.
I must use Query Analizer, but when I try to connect to
my computer (local server) I get this error message: "
Unable to connect to server (my pc) Msg 17, level 16,
[Microsoft][odbc sqlserver driver][Shared Memory]
sqlserver does not exist or access denied".
I cannot change system operative and I must use Query
Analizer. How can I do? Please help me!Hi,
Since you have not installed a SQL server , you can not connect Query
Analyser with out having access to a server.
In Windows XP try installing SQL 2K Personal Edition.
Thanks
Hari
MCDBA
"Giulia" <giulia74z@.libero.it> wrote in message
news:050701c3cadd$dca77110$a101280a@.phx.gbl...

quote:

---

> I have a problem with installation of sqlserver 2000.
> I have a pc at home, my pc is not in a network. The
> operative system installed is Windows XP professional.
> When I try to install sqlserver I receive the following
> message: " sqlserver 2000 enterprise edition component is
> not supported in this operative system. You can install
> only client components"; so I install only client
> components.
> I must use Query Analizer, but when I try to connect to
> my computer (local server) I get this error message: "
> Unable to connect to server (my pc) Msg 17, level 16,
> [Microsoft][odbc sqlserver driver][Shared Memory]
> sqlserver does not exist or access denied".
> I cannot change system operative and I must use Query
> Analizer. How can I do? Please help me!
>

---

|||Giulia (giulia74z@.libero.it) writes:

quote:

---

> I have a problem with installation of sqlserver 2000.
> I have a pc at home, my pc is not in a network. The
> operative system installed is Windows XP professional.
> When I try to install sqlserver I receive the following
> message: " sqlserver 2000 enterprise edition component is
> not supported in this operative system. You can install
> only client components"; so I install only client
> components.

---

This is because on Windows XP you can only install Deverloper Edition,
Personal Edition, Evaulation Edition and MSDE. You cannot install
Standard Edition and Enterprise Edition. These two edition require
a server operating system.

quote:

---

> I must use Query Analizer, but when I try to connect to
> my computer (local server) I get this error message: "
> Unable to connect to server (my pc) Msg 17, level 16,
> [Microsoft][odbc sqlserver driver][Shared Memory]
> sqlserver does not exist or access denied".
> I cannot change system operative and I must use Query
> Analizer. How can I do? Please help me!

---

Since you did not install server components, there is no local server
to connect to. So either you need to connect to network where there
is an SQL Server available, install an edition of SQL Server that
runs on XP.
Erland Sommarskog, SQL Server MVP, sommar@.algonet.se
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp|||Thank you for help!
I installed MSDE from Office 2000 and client components
of sqlserver 2000.
Then I started sql server service manager, in this way I
can connect to local server from Query Analizer!
thank you another

quote:

---

>--Original Message--
>Giulia (giulia74z@.libero.it) writes:
following[QUOTE]
is[QUOTE]
install[QUOTE]
>This is because on Windows XP you can only install

---

Deverloper Edition,

quote:

---

>Personal Edition, Evaulation Edition and MSDE. You

---

cannot install

quote:

---

>Standard Edition and Enterprise Edition. These two

---

edition require

quote:

---

>a server operating system.
>
to[QUOTE]
>Since you did not install server components, there is no

---

local server

quote:

---

>to connect to. So either you need to connect to network

---

where there

quote:

---

>is an SQL Server available, install an edition of SQL

---

Server that

quote:

---

>runs on XP.
>
>--
>Erland Sommarskog, SQL Server MVP, sommar@.algonet.se
>Books Online for SQL Server SP3 at
>http://www.microsoft.com/sql/techin...uctdoc/2000/boo

---

ks.asp

quote:

---

>.
>

---

|||Thank you for help!
I installed MSDE from Office 2000 and client components
of sqlserver 2000.
Then I started sql server service manager, in this way I
can connect to local server from Query Analizer!

quote:

---

>--Original Message--
>Hi,
>Since you have not installed a SQL server , you can not

---

connect Query

quote:

---

>Analyser with out having access to a server.
>In Windows XP try installing SQL 2K Personal Edition.
>Thanks
>Hari
>MCDBA
>"Giulia" <giulia74z@.libero.it> wrote in message
>news:050701c3cadd$dca77110$a101280a@.phx.gbl...
is[QUOTE]
>
>.
>

---

problem with dtexec

Hi

I have a SSIS package which pulls files from a network share and loads data into SQLServer Database. When I execute the application using DTExecUI , It runs fine without any issues , but where as when I run it using the command line arguments, It seems to go in sleep mode and nothing happens. I need to kill the package from Task manager.

Following is the command I use to run my application

Dtexec /FILE "N:\Temp\LoadFirewallData.dtsx" /CONFIGFILE "N:\Temp\LoadFirewallData.dtsConfig" /MAXCONCURRENT " -1 " /CHECKPOINTING OFF /REPORTING EWCDI /SET "\Package.Variables[User::RunID]";41

Regards

Meghana

Are you running DTExecUi and DTExec on the same machine, same use? is the DTExec command line exactly the same as that for DTExecUI (look at the Command Line page in DTExecUI if you have not already)?|||

I ran to similar problems. My package has several variables. When I passed them to DTExec, it does not work and it always takes the values I set when I design the package.

Should I design the package differently? No configurations?

Guangming

|||I am using the exact same command line which shows up in dtexecui. It is not working.|||I'm afraid I cannot see why you should get any problems between the two like this, so I assume it is the package. The only other idea I have is to turn on some detailed logging in the package and see what happens prior to it getting stuck.|||

Following is the error which occurs before it gets hung. The variable is of type string. This error occurs on multi proc machine when executed using dtexec. But the same does not happen when we execute it with dtexecui.

The variable "User::stripfilename" is already on the read list. A variable may only be added once to either the read lock list or the write lock list.

Also, when executed through dtexec command line, it is not consistent enough to show the same error, sometimes it runs through fine and sometimes it errors and hangs till we kill the job from task manager

It seems like couple of other folks are also facing the similar issue

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=222351&SiteID=1

Please let us know if there is any way to resolve this as this is very crucial part of our project.

Regards

Meghana

|||have you tried running the tasks in sequence, rarther than parallel? Have you tried MaxConcurrentExecutables? Seems there is a bug here, but in the meantime one of those should allow you to get going again.|||If it's an issue with variables, and you're not using this in the script, try using

Public Shared Function getVar(ByVal varName As String) As String
Dim vars As Variables
Dts.VariableDispenser.LockOneForRead(varName, vars)
Return vars(varName).Value.ToString()
End Function

rather than referencing the variable in the script properties.

|||

Finally I found the problem:

The way to put the command string is not right after "dtexec /SQL. "

If there is not ENTER and all commands in one line (as it is a dos command), everything is OK!

Is it COOL!?

Guangming

problem with dtexec

Hi

I have a SSIS package which pulls files from a network share and loads data into SQLServer Database. When I execute the application using DTExecUI , It runs fine without any issues , but where as when I run it using the command line arguments, It seems to go in sleep mode and nothing happens. I need to kill the package from Task manager.

Following is the command I use to run my application

Dtexec /FILE "N:\Temp\LoadFirewallData.dtsx" /CONFIGFILE "N:\Temp\LoadFirewallData.dtsConfig" /MAXCONCURRENT " -1 " /CHECKPOINTING OFF /REPORTING EWCDI /SET "\Package.Variables[User::RunID]";41

Regards

Meghana

Are you running DTExecUi and DTExec on the same machine, same use? is the DTExec command line exactly the same as that for DTExecUI (look at the Command Line page in DTExecUI if you have not already)?|||

I ran to similar problems. My package has several variables. When I passed them to DTExec, it does not work and it always takes the values I set when I design the package.

Should I design the package differently? No configurations?

Guangming

|||I am using the exact same command line which shows up in dtexecui. It is not working.|||I'm afraid I cannot see why you should get any problems between the two like this, so I assume it is the package. The only other idea I have is to turn on some detailed logging in the package and see what happens prior to it getting stuck.|||

Following is the error which occurs before it gets hung. The variable is of type string. This error occurs on multi proc machine when executed using dtexec. But the same does not happen when we execute it with dtexecui.

The variable "User::stripfilename" is already on the read list. A variable may only be added once to either the read lock list or the write lock list.

Also, when executed through dtexec command line, it is not consistent enough to show the same error, sometimes it runs through fine and sometimes it errors and hangs till we kill the job from task manager

It seems like couple of other folks are also facing the similar issue

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=222351&SiteID=1

Please let us know if there is any way to resolve this as this is very crucial part of our project.

Regards

Meghana

|||have you tried running the tasks in sequence, rarther than parallel? Have you tried MaxConcurrentExecutables? Seems there is a bug here, but in the meantime one of those should allow you to get going again.|||If it's an issue with variables, and you're not using this in the script, try using

Public Shared Function getVar(ByVal varName As String) As String
Dim vars As Variables
Dts.VariableDispenser.LockOneForRead(varName, vars)
Return vars(varName).Value.ToString()
End Function

rather than referencing the variable in the script properties.

|||

Finally I found the problem:

The way to put the command string is not right after "dtexec /SQL. "

If there is not ENTER and all commands in one line (as it is a dos command), everything is OK!

Is it COOL!?

Guangming