(local) vs. the actual name of SQL Server when using a named instance

Hello,
My question is this: in a named instance installation of a SQL Server, when
you reference the server as (local) from a Stored Procedure that accesses a
table for example, will that point to the Named Instance or will it access
the table on the actual database on the main installation?
Thank you
leo
WHere yo you name the server as (local) in a stored procedure ? You
don=B4t have to. Just use the three or two part name that should be
enough for you.
HTH, Jens Suessmeyer,
sql

(local) vs. the actual name of SQL Server when using a named instance

Hello,
My question is this: in a named instance installation of a SQL Server, when
you reference the server as (local) from a Stored Procedure that accesses a
table for example, will that point to the Named Instance or will it access
the table on the actual database on the main installation?
Thank you
leoWHere yo you name the server as (local) in a stored procedure ? You
don=B4t have to. Just use the three or two part name that should be
enough for you.
HTH, Jens Suessmeyer,|||Referencing (local) implies that you are creating a new connection. This
connection won't know which instance the command comes from so will connect
to the default instance.
Is this bcp or osql? Can't think of another reason for it.
If you want to connect to the same instance from an sp then use @.@.servername
and put it in [].
"Leo" wrote:
> Hello,
> My question is this: in a named instance installation of a SQL Server, when
> you reference the server as (local) from a Stored Procedure that accesses a
> table for example, will that point to the Named Instance or will it access
> the table on the actual database on the main installation?
>
> Thank you
> leo
>
>|||I am actually running an Instance of SQL server on the same machine as an
installation of SQL server. The reason for that is QA testing. When I make a
change to the database I copy it to the instance os SQL on the same machine.
I am using store procedures to run DTS packages. So I am doing a DTSRUN
command on the package. On my SQL server I was using (local) as my server.
The reason I asked was that I didn't want to go into the Instance of the SQL
and change the name of the server on the stored procedures manually. I
wanted the stored proc to pick up the name of the server it;s running on
without manual changes to the code. I was affraid that if I leave that code
unchanged as (local) that the stored proc will look for the wrong DTS
package, meaning the one on the SQL server, not the one in the instance of
SQL. I am not sure if I made this more confusing or more explained.
in short I am trying to provide the samew functionality within one physical
sever using an installation of a SQL instance, as if it was two separate
physical servers, where you can reference (local) and whenever you more a
stored proc from one server to the other you do not need to change that code
to point to the right SQL server
Thanks
Leo
"Nigel Rivett" <NigelRivett@.discussions.microsoft.com> wrote in message
news:15408704-EE37-4A96-97D2-1BF39A6CE5AE@.microsoft.com...
> Referencing (local) implies that you are creating a new connection. This
> connection won't know which instance the command comes from so will
connect
> to the default instance.
> Is this bcp or osql? Can't think of another reason for it.
> If you want to connect to the same instance from an sp then use
@.@.servername
> and put it in [].
> "Leo" wrote:
> > Hello,
> >
> > My question is this: in a named instance installation of a SQL Server,
when
> > you reference the server as (local) from a Stored Procedure that
accesses a
> > table for example, will that point to the Named Instance or will it
access
> > the table on the actual database on the main installation?
> >
> >
> >
> > Thank you
> >
> > leo
> >
> >
> >

(local) vs. the actual name of SQL Server when using a named instance

Hello,
My question is this: in a named instance installation of a SQL Server, when
you reference the server as (local) from a Stored Procedure that accesses a
table for example, will that point to the Named Instance or will it access
the table on the actual database on the main installation?
Thank you
leoWHere yo you name the server as (local) in a stored procedure ? You
don=B4t have to. Just use the three or two part name that should be
enough for you.
HTH, Jens Suessmeyer,

(Complete newbie) Please help! Installation problem (I think)

Hello,

I most likely am being incredibly stupid here, but I have installed SQL 2005 Enterprise and Service Pack 2 on my Acer laptop running Vista Business and cannot for the life of me figure out how to start the thing.

When I hit the start button on the toolbar, and go to Microsoft SQL Server 2005, there is one folder that expands down called Configuration Tools. This has the options Notification Services, Configuration Management, Error and Usage Reports, and Surface Area Configuration. But no where can I find an icon that actually starts the database thing so I can create a database and learn some SQL stuff.

I would be most grateful if anybody could point out where I am going wrong or if there is anything I need to do.

Many thanks,

Chima

The default installation does NOT install the client tools.

Using the install media, run Setup again, and this time choose Client Tools.

|||Marvellous thanks Arnie!

"Failed to create web application" error during installation of SQL 2k5b2

I was installing SSRS 2005 Beta 2 and near completion of the installation, i encountered the following error. I don't know what causes this. How can i avoid this? I've installed the rest of the whole SQL 2K5 package.

Machine : xxxxx
Product : Microsoft SQL Server 2005 Reporting Services Beta 2
Product Version : 9.00.852
Install : Failed
Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0017_xxxxxx_RS.log
Last Action : InstallFinalize
Error String : The setup failed to create web application: /LM/W3SVC/1/Root/Reports. The error code is -2146959355.

Ok its working now. the MS DTC was enabled but not all its options were selected. I selected all of them, and reinstalled it worked.

If there's anyone just as blurr as i am, its available in WinXP thru the

Administrative tools > Component Services option.

In the left console, Expand 'Console Root > Component Services > Computers'. You should see My Computer as the next node.

The funny thing is, on my pc, when right-clicking on My Computer, i couldn't see the 'Properties' option. I had to click 'Configure My Computer' button at the toolbar (should be the last button) to enable MS DTC. AFter that , the properties option was visible on the menu.

Hope this helps anyone who might face this problem.

"Could not open SQLEVN70.RLL"

"Your SQL Server installation is eigher corrupt or has been tampered with (could not open SQLEVN70.rll). Please uninstall then re-run Setup to correct this problem."

What do I do? It says to uninstall/reinstall, but what DO I install? I need a step-by-step procedure to follow to get rid of this.

Not finding much on this one, I did see http://www.experts-exchange.com/Applications/MS_Office/Q_21754121.html that you should check out.

If you're still having this issue give a bit more information, what product are you working with? When are you getting this error?

Mike

|||Sorry for the late reply, but I got it fixed now.|||

How did you fix it - I have the same problem.

I am running af XP pro.

Tanx

/Stengaard

|||

Stengaard wrote:

How did you fix it - I have the same problem.

I am running af XP pro.

Tanx

/Stengaard

I uninstalled it all, and then reinstalled everything back. If you have anything important, back it up.|||

Thank you. I will have to do so then.

/Stengaard

|||

Stengaard wrote:

Thank you. I will have to do so then.

/Stengaard

No problem. ^_^|||

How did you fix the problem I have the same thing

Thank You

|||

HI, I have not been able to solve this same issue, I have found few sites to describe this specific issue. I need help to solve it. Thanks in advance for any help.

|||what is it and why did it do and how can i fix it i just got this computer.|||In the directory C:\Program Files\Microsoft SQL Server there are probably 2 subdirectories starting with MSSQL$. One of them is empty (look in C:\Program Files\Microsoft SQL Server\MSSQL$?MSDE\Binn\Resources\1033 or 1043). Delete this subdirectory and the problem is solved.|||

Thanx - this sounds about right, but both the subdirectory 1033 and 1043 is not empty, so wich one to delete?

|||

You just have to look in the subdirectory of Microsoft SQL Server.

Both 1033 and 1043 are subdirectories of the subdirectory and they both have the file SQLEVN70.RLL. So that's OK. Don't delete these files!

It looks a bit complicated, but it isn't.

In Explorer go to > Program Files >Microsoft SQL Server

Do you see one subdirectory starting with MSSQL$? or do you see two or more such subdirectories?

If you only see one subdirectory then this solution is not suitable for you.

If you see two or more subdirectories starting with MSSQL$, one of them is probably empty. Delete this (empty) directory.

|||I actually deleted the second file, and the problem has not gone away. How did you fix it?

"Could not open SQLEVN70.RLL"

"Your SQL Server installation is eigher corrupt or has been tampered with (could not open SQLEVN70.rll). Please uninstall then re-run Setup to correct this problem."

What do I do? It says to uninstall/reinstall, but what DO I install? I need a step-by-step procedure to follow to get rid of this.

Not finding much on this one, I did see http://www.experts-exchange.com/Applications/MS_Office/Q_21754121.html that you should check out.

If you're still having this issue give a bit more information, what product are you working with? When are you getting this error?

Mike

|||Sorry for the late reply, but I got it fixed now.|||

How did you fix it - I have the same problem.

I am running af XP pro.

Tanx

/Stengaard

|||

Stengaard wrote:

How did you fix it - I have the same problem.

I am running af XP pro.

Tanx

/Stengaard

I uninstalled it all, and then reinstalled everything back. If you have anything important, back it up.|||

Thank you. I will have to do so then.

/Stengaard

|||

Stengaard wrote:

Thank you. I will have to do so then.

/Stengaard

No problem. ^_^|||

How did you fix the problem I have the same thing

Thank You

|||

HI, I have not been able to solve this same issue, I have found few sites to describe this specific issue. I need help to solve it. Thanks in advance for any help.

|||what is it and why did it do and how can i fix it i just got this computer.|||In the directory C:\Program Files\Microsoft SQL Server there are probably 2 subdirectories starting with MSSQL$. One of them is empty (look in C:\Program Files\Microsoft SQL Server\MSSQL$?MSDE\Binn\Resources\1033 or 1043). Delete this subdirectory and the problem is solved.|||

Thanx - this sounds about right, but both the subdirectory 1033 and 1043 is not empty, so wich one to delete?

|||

You just have to look in the subdirectory of Microsoft SQL Server.

Both 1033 and 1043 are subdirectories of the subdirectory and they both have the file SQLEVN70.RLL. So that's OK. Don't delete these files!

It looks a bit complicated, but it isn't.

In Explorer go to > Program Files >Microsoft SQL Server

Do you see one subdirectory starting with MSSQL$? or do you see two or more such subdirectories?

If you only see one subdirectory then this solution is not suitable for you.

If you see two or more subdirectories starting with MSSQL$, one of them is probably empty. Delete this (empty) directory.

|||I actually deleted the second file, and the problem has not gone away. How did you fix it?

"Could not open SQLEVN70.RLL"

"Your

SQL Server installation is eigher corrupt or has been tampered with

(could not open SQLEVN70.rll). Please uninstall then re-run Setup to

correct this problem."

What do I do? It says to uninstall/reinstall, but what DO I install? I need a step-by-step procedure to follow to get rid of this.

Not finding much on this one, I did see http://www.experts-exchange.com/Applications/MS_Office/Q_21754121.html that you should check out.

If you're still having this issue give a bit more information, what product are you working with? When are you getting this error?

Mike

|||Sorry for the late reply, but I got it fixed now.|||

How did you fix it - I have the same problem.

I am running af XP pro.

Tanx

/Stengaard

|||

Stengaard wrote:

How did you fix it - I have the same problem.

I am running af XP pro.

Tanx

/Stengaard

I uninstalled it all, and then reinstalled everything back. If you have anything important, back it up.|||

Thank you. I will have to do so then.

/Stengaard

|||

Stengaard wrote:

Thank you. I will have to do so then.

/Stengaard

No problem. ^_^|||

How did you fix the problem I have the same thing

Thank You

|||

HI, I have not been able to solve this same issue, I have found few sites to describe this specific issue. I need help to solve it. Thanks in advance for any help.

|||what is it and why did it do and how can i fix it i just got this computer.|||In the directory C:\Program Files\Microsoft SQL Server there are probably 2 subdirectories starting with MSSQL$. One of them is empty (look in C:\Program Files\Microsoft SQL Server\MSSQL$?MSDE\Binn\Resources\1033 or 1043). Delete this subdirectory and the problem is solved.|||

Thanx - this sounds about right, but both the subdirectory 1033 and 1043 is not empty, so wich one to delete?

|||

You just have to look in the subdirectory of Microsoft SQL Server.

Both 1033 and 1043 are subdirectories of the subdirectory and they both have the file SQLEVN70.RLL. So that's OK. Don't delete these files!

It looks a bit complicated, but it isn't.

In Explorer go to > Program Files >Microsoft SQL Server

Do you see one subdirectory starting with MSSQL$? or do you see two or more such subdirectories?

If you only see one subdirectory then this solution is not suitable for you.

If you see two or more subdirectories starting with MSSQL$, one of them is probably empty. Delete this (empty) directory.

|||I actually deleted the second file, and the problem has not gone away. How did you fix it?

"Could not open SQLEVN70.RLL"

"Your

SQL Server installation is eigher corrupt or has been tampered with

(could not open SQLEVN70.rll). Please uninstall then re-run Setup to

correct this problem."

What do I do? It says to uninstall/reinstall, but what DO I install? I need a step-by-step procedure to follow to get rid of this.

Not finding much on this one, I did see http://www.experts-exchange.com/Applications/MS_Office/Q_21754121.html that you should check out.

If you're still having this issue give a bit more information, what product are you working with? When are you getting this error?

Mike

|||Sorry for the late reply, but I got it fixed now.|||

How did you fix it - I have the same problem.

I am running af XP pro.

Tanx

/Stengaard

|||

Stengaard wrote:

How did you fix it - I have the same problem.

I am running af XP pro.

Tanx

/Stengaard

I uninstalled it all, and then reinstalled everything back. If you have anything important, back it up.|||

Thank you. I will have to do so then.

/Stengaard

|||

Stengaard wrote:

Thank you. I will have to do so then.

/Stengaard

No problem. ^_^|||

How did you fix the problem I have the same thing

Thank You

|||

HI, I have not been able to solve this same issue, I have found few sites to describe this specific issue. I need help to solve it. Thanks in advance for any help.

|||what is it and why did it do and how can i fix it i just got this computer.|||In the directory C:\Program Files\Microsoft SQL Server there are probably 2 subdirectories starting with MSSQL$. One of them is empty (look in C:\Program Files\Microsoft SQL Server\MSSQL$?MSDE\Binn\Resources\1033 or 1043). Delete this subdirectory and the problem is solved.|||

Thanx - this sounds about right, but both the subdirectory 1033 and 1043 is not empty, so wich one to delete?

|||

You just have to look in the subdirectory of Microsoft SQL Server.

Both 1033 and 1043 are subdirectories of the subdirectory and they both have the file SQLEVN70.RLL. So that's OK. Don't delete these files!

It looks a bit complicated, but it isn't.

In Explorer go to > Program Files >Microsoft SQL Server

Do you see one subdirectory starting with MSSQL$? or do you see two or more such subdirectories?

If you only see one subdirectory then this solution is not suitable for you.

If you see two or more subdirectories starting with MSSQL$, one of them is probably empty. Delete this (empty) directory.

|||I actually deleted the second file, and the problem has not gone away. How did you fix it?

"Could not open SQLEVN70.RLL"

"Your

SQL Server installation is eigher corrupt or has been tampered with

(could not open SQLEVN70.rll). Please uninstall then re-run Setup to

correct this problem."

What do I do? It says to uninstall/reinstall, but what DO I install? I need a step-by-step procedure to follow to get rid of this.

Not finding much on this one, I did see http://www.experts-exchange.com/Applications/MS_Office/Q_21754121.html that you should check out.

If you're still having this issue give a bit more information, what product are you working with? When are you getting this error?

Mike

|||Sorry for the late reply, but I got it fixed now.|||

How did you fix it - I have the same problem.

I am running af XP pro.

Tanx

/Stengaard

|||

Stengaard wrote:

How did you fix it - I have the same problem.

I am running af XP pro.

Tanx

/Stengaard

I uninstalled it all, and then reinstalled everything back. If you have anything important, back it up.|||

Thank you. I will have to do so then.

/Stengaard

|||

Stengaard wrote:

Thank you. I will have to do so then.

/Stengaard

No problem. ^_^|||

How did you fix the problem I have the same thing

Thank You

|||

HI, I have not been able to solve this same issue, I have found few sites to describe this specific issue. I need help to solve it. Thanks in advance for any help.

|||what is it and why did it do and how can i fix it i just got this computer.|||In the directory C:\Program Files\Microsoft SQL Server there are probably 2 subdirectories starting with MSSQL$. One of them is empty (look in C:\Program Files\Microsoft SQL Server\MSSQL$?MSDE\Binn\Resources\1033 or 1043). Delete this subdirectory and the problem is solved.|||

Thanx - this sounds about right, but both the subdirectory 1033 and 1043 is not empty, so wich one to delete?

|||

You just have to look in the subdirectory of Microsoft SQL Server.

Both 1033 and 1043 are subdirectories of the subdirectory and they both have the file SQLEVN70.RLL. So that's OK. Don't delete these files!

It looks a bit complicated, but it isn't.

In Explorer go to > Program Files >Microsoft SQL Server

Do you see one subdirectory starting with MSSQL$? or do you see two or more such subdirectories?

If you only see one subdirectory then this solution is not suitable for you.

If you see two or more subdirectories starting with MSSQL$, one of them is probably empty. Delete this (empty) directory.

|||I actually deleted the second file, and the problem has not gone away. How did you fix it?

"Could not open SQLEVN70.RLL"

"Your SQL Server installation is eigher corrupt or has been tampered with (could not open SQLEVN70.rll). Please uninstall then re-run Setup to correct this problem."

What do I do? It says to uninstall/reinstall, but what DO I install? I need a step-by-step procedure to follow to get rid of this.

Not finding much on this one, I did see http://www.experts-exchange.com/Applications/MS_Office/Q_21754121.html that you should check out.

If you're still having this issue give a bit more information, what product are you working with? When are you getting this error?

Mike

|||Sorry for the late reply, but I got it fixed now.|||

How did you fix it - I have the same problem.

I am running af XP pro.

Tanx

/Stengaard

|||

Stengaard wrote:

How did you fix it - I have the same problem.

I am running af XP pro.

Tanx

/Stengaard

I uninstalled it all, and then reinstalled everything back. If you have anything important, back it up.|||

Thank you. I will have to do so then.

/Stengaard

|||

Stengaard wrote:

Thank you. I will have to do so then.

/Stengaard

No problem. ^_^|||

How did you fix the problem I have the same thing

Thank You

|||

HI, I have not been able to solve this same issue, I have found few sites to describe this specific issue. I need help to solve it. Thanks in advance for any help.

|||what is it and why did it do and how can i fix it i just got this computer.|||In the directory C:\Program Files\Microsoft SQL Server there are probably 2 subdirectories starting with MSSQL$. One of them is empty (look in C:\Program Files\Microsoft SQL Server\MSSQL$?MSDE\Binn\Resources\1033 or 1043). Delete this subdirectory and the problem is solved.|||

Thanx - this sounds about right, but both the subdirectory 1033 and 1043 is not empty, so wich one to delete?

|||

You just have to look in the subdirectory of Microsoft SQL Server.

Both 1033 and 1043 are subdirectories of the subdirectory and they both have the file SQLEVN70.RLL. So that's OK. Don't delete these files!

It looks a bit complicated, but it isn't.

In Explorer go to > Program Files >Microsoft SQL Server

Do you see one subdirectory starting with MSSQL$? or do you see two or more such subdirectories?

If you only see one subdirectory then this solution is not suitable for you.

If you see two or more subdirectories starting with MSSQL$, one of them is probably empty. Delete this (empty) directory.

|||I actually deleted the second file, and the problem has not gone away. How did you fix it?

"Could not open SQLEVN70.RLL"

"Your

SQL Server installation is eigher corrupt or has been tampered with

(could not open SQLEVN70.rll). Please uninstall then re-run Setup to

correct this problem."

What do I do? It says to uninstall/reinstall, but what DO I install? I need a step-by-step procedure to follow to get rid of this.

Not finding much on this one, I did see http://www.experts-exchange.com/Applications/MS_Office/Q_21754121.html that you should check out.

If you're still having this issue give a bit more information, what product are you working with? When are you getting this error?

Mike

|||Sorry for the late reply, but I got it fixed now.|||

How did you fix it - I have the same problem.

I am running af XP pro.

Tanx

/Stengaard

|||

Stengaard wrote:

How did you fix it - I have the same problem.

I am running af XP pro.

Tanx

/Stengaard

I uninstalled it all, and then reinstalled everything back. If you have anything important, back it up.|||

Thank you. I will have to do so then.

/Stengaard

|||

Stengaard wrote:

Thank you. I will have to do so then.

/Stengaard

No problem. ^_^|||

How did you fix the problem I have the same thing

Thank You

|||

HI, I have not been able to solve this same issue, I have found few sites to describe this specific issue. I need help to solve it. Thanks in advance for any help.

|||what is it and why did it do and how can i fix it i just got this computer.|||In the directory C:\Program Files\Microsoft SQL Server there are probably 2 subdirectories starting with MSSQL$. One of them is empty (look in C:\Program Files\Microsoft SQL Server\MSSQL$?MSDE\Binn\Resources\1033 or 1043). Delete this subdirectory and the problem is solved.|||

Thanx - this sounds about right, but both the subdirectory 1033 and 1043 is not empty, so wich one to delete?

|||

You just have to look in the subdirectory of Microsoft SQL Server.

Both 1033 and 1043 are subdirectories of the subdirectory and they both have the file SQLEVN70.RLL. So that's OK. Don't delete these files!

It looks a bit complicated, but it isn't.

In Explorer go to > Program Files >Microsoft SQL Server

Do you see one subdirectory starting with MSSQL$? or do you see two or more such subdirectories?

If you only see one subdirectory then this solution is not suitable for you.

If you see two or more subdirectories starting with MSSQL$, one of them is probably empty. Delete this (empty) directory.

|||I actually deleted the second file, and the problem has not gone away. How did you fix it?

"Beta period is over" (June 2005 CTP)

hi everyone,

This is home installation no tricky one. That's fine, I understand that. But I wonder whether I will be able to load any SSIS package already defined by mean of Visual Basic .Net after that message.

That message appears after I try to open BIDS IDE.

Thanks in advance,

You will not be able to run packages programatically.

The developer edition of SQL Server 2005 should be good for you, and is really very well priced.

Donald

|||

Hi Donald,

Thanks for that. Another question. SSIS is not longer available for me. But what about Database Engine? In a fact I've got a home-made vb .net solution dragged there and everything is fine.

Thanks again,

<MachineName>\NETSDK installation

I downloaded something that installed an SQL instance of <Machine
Name>NETSDK. It contains Northwind, Pubs, and other sample databases. Does
anyone know how I got this? For the life of me I can't remember.
Marty
If you installed .NET SDK (not just .NET framework), that is when you might
have also installed MSDE. But it would be installed automatically. It is
only when you choose to install .NET tutorial.
"Marty" <Marty@.discussions.microsoft.com> wrote in message
news:ADD3968D-7B7C-4456-9FEE-50A61C040810@.microsoft.com...
> I downloaded something that installed an SQL instance of <Machine
> Name>NETSDK. It contains Northwind, Pubs, and other sample databases. Does
> anyone know how I got this? For the life of me I can't remember.
> Marty
|||Is .NET SDK part of MSDE? If not, where can I get it?
Thanks for your help
"Norman Yuan" wrote:

> If you installed .NET SDK (not just .NET framework), that is when you might
> have also installed MSDE. But it would be installed automatically. It is
> only when you choose to install .NET tutorial.
> "Marty" <Marty@.discussions.microsoft.com> wrote in message
> news:ADD3968D-7B7C-4456-9FEE-50A61C040810@.microsoft.com...
>
>
|||"Marty" <Marty@.discussions.microsoft.com> wrote in message
news:595F40A2-ED7C-4A39-AD93-B6D76B1E111C@.microsoft.com...
> Is .NET SDK part of MSDE? If not, where can I get it?
> Thanks for your help
>
NetSDK is the name of your MSDE instance. That name was used because the
scripts set up to create your sample databases (Pubs, Northwind, etc.) were
written to expect that instance name.
As you say those databases have been created, it looks as if everything is
as it should be.
Peter [MVP Visual Developer]
Jack of all trades, master of none.
|||But where did it come from? The the best of my knowledge, MSDE made an
instance called <MachineName>. Where did <MachineName>\NETSDK come from?
"Peter van der Goes" wrote:

> "Marty" <Marty@.discussions.microsoft.com> wrote in message
> news:595F40A2-ED7C-4A39-AD93-B6D76B1E111C@.microsoft.com...
> NetSDK is the name of your MSDE instance. That name was used because the
> scripts set up to create your sample databases (Pubs, Northwind, etc.) were
> written to expect that instance name.
> As you say those databases have been created, it looks as if everything is
> as it should be.
> --
> Peter [MVP Visual Developer]
> Jack of all trades, master of none.
>
>
|||When installing SQL Server/MSDE, you can choose to use INSTANCE name or not
to. Your "<MachineName\NetSDK" instance on MSDE IS from your installation
with or without your awareness. As I said, in previous reply, it is most
likely installed when you set up .NET tutorial. from .NET document. Of
course you can choose to install it without instance name in the
expenctation that .NET tutorial not working.
"Marty" <Marty@.discussions.microsoft.com> wrote in message
news:394A46D6-F165-4A8C-9F1D-6219828A3205@.microsoft.com...[vbcol=seagreen]
> But where did it come from? The the best of my knowledge, MSDE made an
> instance called <MachineName>. Where did <MachineName>\NETSDK come from?
> "Peter van der Goes" wrote:
were[vbcol=seagreen]
is[vbcol=seagreen]
|||No, I didn't. When I installed MSDE I used the command line: setup SAPWD=
<password> SecurityMode=SQL. That's it. And it's not just an instance. I
contains databases.
"Norman Yuan" wrote:

> When installing SQL Server/MSDE, you can choose to use INSTANCE name or not
> to. Your "<MachineName\NetSDK" instance on MSDE IS from your installation
> with or without your awareness. As I said, in previous reply, it is most
> likely installed when you set up .NET tutorial. from .NET document. Of
> course you can choose to install it without instance name in the
> expenctation that .NET tutorial not working.
> "Marty" <Marty@.discussions.microsoft.com> wrote in message
> news:394A46D6-F165-4A8C-9F1D-6219828A3205@.microsoft.com...
> were
> is
>
>
|||There is another argument for the command line setup:
INSTANCENAME="InstanceName". If you did not specify instance name and you
get <MachineName>\NETSDK, then it can only be explained by that you used the
MSDE coming with .NET SDK or VisualStudio.NET. If your MSDE is directed
downloaded from MS site or from MS Office Pro/Access, the installation would
not add "NetSDK" instance name automatically.
BTW, If you do not like the instance name, you can uninstall and reinstall
the MSDE.
"Marty" <Marty@.discussions.microsoft.com> wrote in message
news:46041F11-611A-4F8D-8B84-67E1D963FB17@.microsoft.com...[vbcol=seagreen]
> No, I didn't. When I installed MSDE I used the command line: setup SAPWD=
> <password> SecurityMode=SQL. That's it. And it's not just an instance. I
> contains databases.
>
> "Norman Yuan" wrote:
not[vbcol=seagreen]
installation[vbcol=seagreen]
from?[vbcol=seagreen]
the[vbcol=seagreen]
etc.)[vbcol=seagreen]
everything[vbcol=seagreen]
|||It was downloaded from MS. But I installed something else and I don't know
what. Add/Remove programs shows MSDE and MSDE (NETSDK). I must have installed
something else because there are two entries but I only installed MSDE once.
"Norman Yuan" wrote:

> There is another argument for the command line setup:
> INSTANCENAME="InstanceName". If you did not specify instance name and you
> get <MachineName>\NETSDK, then it can only be explained by that you used the
> MSDE coming with .NET SDK or VisualStudio.NET. If your MSDE is directed
> downloaded from MS site or from MS Office Pro/Access, the installation would
> not add "NetSDK" instance name automatically.
> BTW, If you do not like the instance name, you can uninstall and reinstall
> the MSDE.
> "Marty" <Marty@.discussions.microsoft.com> wrote in message
> news:46041F11-611A-4F8D-8B84-67E1D963FB17@.microsoft.com...
> not
> installation
> from?
> the
> etc.)
> everything
>
>
|||For the public, although roblem has already been solved via IM: Those
databases can be downloaded at Microsoft under the folling link:
http://www.microsoft.com/downloads/d...displaylang=en
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
"Marty" <Marty@.discussions.microsoft.com> schrieb im Newsbeitrag
news:ADD3968D-7B7C-4456-9FEE-50A61C040810@.microsoft.com...
>I downloaded something that installed an SQL instance of <Machine
> Name>NETSDK. It contains Northwind, Pubs, and other sample databases. Does
> anyone know how I got this? For the life of me I can't remember.
> Marty