Showing posts with label basic. Show all posts
Showing posts with label basic. Show all posts

Monday, March 26, 2012

Installing SQLXML Bulk Load through Code

Hi all,
I am using SQL XML Bulk load to add data from XML into my database.Is there a way where in i can install the basic dlls required for simply the process of copying data from XML Bulk load without having to go about physically installing the SQLXML bulk loa
d...
Any help would be greatly appreciated...
thanx,
regards,
Kalpna
************************************************** ********************
Sent via Fuzzy Software @. http://www.fuzzysoftware.com/
Comprehensive, categorised, searchable collection of links to ASP & ASP.NET resources...
HI
i am little confused by ur question. Do u want to do the buklload from multiple machines other than ur machine?
Thanks
Mathew
|||no...i want that during the time of installation ...my application should just register the entries required for my application...what i mean by this is that rather than installing the whole SQL XML bulk load i simply register the relevant Dlls on the m
achine where the application doing the bulk load will be hosted...
ne help wud be of great use...
thanx,
regards,
Kalpna
************************************************** ********************
Sent via Fuzzy Software @. http://www.fuzzysoftware.com/
Comprehensive, categorised, searchable collection of links to ASP & ASP.NET resources...

Wednesday, March 21, 2012

Installing Sql Server and Visual Basic .NET

Browsing the Sql server installation cd I found that I need to create a
domain name. What will be the difference with WORKGROUP network? Do I need to
change from workgroup to domain name?> Browsing the Sql server installation cd I found that I need to create a
> domain name.
? Could you be more specific? Where did you "find" this?|||Urraca wrote:
> Browsing the Sql server installation cd I found that I need to create
> a domain name. What will be the difference with WORKGROUP network? Do
> I need to change from workgroup to domain name?
No. A workgroup is fine for SQL Server installation.
--
David Gugick
Imceda Software
www.imceda.com|||You may want to search for "Authentication Modes" in BOL for a
discussion of how authentication can be configured in SQL Server.
Joe Webb
SQL Server MVP
~~~
Get up to speed quickly with SQLNS
http://www.amazon.com/exec/obidos/tg/detail/-/0972688811
I support PASS, the Professional Association for SQL Server.
(www.sqlpass.org)
On Wed, 4 May 2005 09:10:10 -0700, Urraca
<chiriqui9844(removethis)@.msn.com> wrote:
>Browsing the Sql server installation cd I found that I need to create a
>domain name. What will be the difference with WORKGROUP network? Do I need to
>change from workgroup to domain name?

Installing Sql Server and Visual Basic .NET

Browsing the Sql server installation cd I found that I need to create a
domain name. What will be the difference with WORKGROUP network? Do I need to
change from workgroup to domain name?
> Browsing the Sql server installation cd I found that I need to create a
> domain name.
? Could you be more specific? Where did you "find" this?
|||Urraca wrote:
> Browsing the Sql server installation cd I found that I need to create
> a domain name. What will be the difference with WORKGROUP network? Do
> I need to change from workgroup to domain name?
No. A workgroup is fine for SQL Server installation.
David Gugick
Imceda Software
www.imceda.com
|||You may want to search for "Authentication Modes" in BOL for a
discussion of how authentication can be configured in SQL Server.
Joe Webb
SQL Server MVP
~~~
Get up to speed quickly with SQLNS
http://www.amazon.com/exec/obidos/tg...l/-/0972688811
I support PASS, the Professional Association for SQL Server.
(www.sqlpass.org)
On Wed, 4 May 2005 09:10:10 -0700, Urraca
<chiriqui9844(removethis)@.msn.com> wrote:

>Browsing the Sql server installation cd I found that I need to create a
>domain name. What will be the difference with WORKGROUP network? Do I need to
>change from workgroup to domain name?

Installing Sql Server and Visual Basic .NET

Browsing the Sql server installation cd I found that I need to create a
domain name. What will be the difference with WORKGROUP network? Do I need t
o
change from workgroup to domain name?> Browsing the Sql server installation cd I found that I need to create a
> domain name.
? Could you be more specific? Where did you "find" this?|||Urraca wrote:
> Browsing the Sql server installation cd I found that I need to create
> a domain name. What will be the difference with WORKGROUP network? Do
> I need to change from workgroup to domain name?
No. A workgroup is fine for SQL Server installation.
David Gugick
Imceda Software
www.imceda.com|||You may want to search for "Authentication Modes" in BOL for a
discussion of how authentication can be configured in SQL Server.
Joe Webb
SQL Server MVP
~~~
Get up to speed quickly with SQLNS
http://www.amazon.com/exec/obidos/t...il/-/0972688811
I support PASS, the Professional Association for SQL Server.
(www.sqlpass.org)
On Wed, 4 May 2005 09:10:10 -0700, Urraca
<chiriqui9844(removethis)@.msn.com> wrote:

>Browsing the Sql server installation cd I found that I need to create a
>domain name. What will be the difference with WORKGROUP network? Do I need
to
>change from workgroup to domain name?sql

Monday, March 19, 2012

Installing SQL Server 2005 DB via .NET application

Hello all,

I've developed a visual basic .net (2005) application that uses sql server 2005 (express edition) as a database and I created a setup project that installes my application. Now, my question is how can I create a "all-in-one" installation procedure/file that will install both the SQL server (engine + db) and my application?

I've found the following link:

http://msdn.microsoft.com/sql/default.aspx?pull=/library/en-us/dnsse/html/sqlexpuserinst.asp#sqlexpuser_topic10

That mentions under: "Distribution and Deployment" section, something that sounds like what I'm looking for, but I didn't find any further information on how to do that. Can anyone help?

Thanks in advanced!

Tom.

I have the same question...bump...

_ANY_ resources out there?

|||

Hi,

SQL Server Express doesn′′t use merge modules anymore. It uses now the msi pakcage functionalty which is described in the help of Visual Studio, its like configuring any other MSI package within a setup project to deploy.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

Installing SQL Server 2005 DB via .NET application

Hello all,

I've developed a visual basic .net (2005) application that uses sql server 2005 (express edition) as a database and I created a setup project that installes my application. Now, my question is how can I create a "all-in-one" installation procedure/file that will install both the SQL server (engine + db) and my application?

I've found the following link:

http://msdn.microsoft.com/sql/default.aspx?pull=/library/en-us/dnsse/html/sqlexpuserinst.asp#sqlexpuser_topic10

That mentions under: "Distribution and Deployment" section, something that sounds like what I'm looking for, but I didn't find any further information on how to do that. Can anyone help?

Thanks in advanced!

Tom.

I have the same question...bump...

_ANY_ resources out there?

|||

Hi,

SQL Server Express doesn′′t use merge modules anymore. It uses now the msi pakcage functionalty which is described in the help of Visual Studio, its like configuring any other MSI package within a setup project to deploy.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

Monday, March 12, 2012

Integrated AND Basic authentication?!

Trying to set up a site with both integrated and basic authentication
enabled (anonymous disabled of course).
When working on local network I want integrated auth. to act, and it does,
no problem.
Accessing site from outside of local network Basic auth. should kick in, and
it does, no problem. But Basic auth. does not listen to default domain. It
takes the local machinename as auth. domain.
Am I doing something wrong or is this the behaviour to expect?
Any help would be very appreciated!
Kjellsorry wrong group, posting this to the right group...
Sorry!!
Kjell
"Kjell Brandes" <kjell@.brandes.tv> wrote in message
news:%232VKlMAlEHA.3520@.TK2MSFTNGP11.phx.gbl...
> Trying to set up a site with both integrated and basic authentication
> enabled (anonymous disabled of course).
> When working on local network I want integrated auth. to act, and it does,
> no problem.
> Accessing site from outside of local network Basic auth. should kick in,
and
> it does, no problem. But Basic auth. does not listen to default domain. It
> takes the local machinename as auth. domain.
> Am I doing something wrong or is this the behaviour to expect?
> Any help would be very appreciated!
> Kjell
>|||Are you typing domain\username for the user name in the security dialog? If
not specified, it will default to the local machine account.
--
Brian Welcker
Group Program Manager
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Kjell Brandes" <kjell@.brandes.tv> wrote in message
news:eafkcXAlEHA.2764@.TK2MSFTNGP11.phx.gbl...
> sorry wrong group, posting this to the right group...
> Sorry!!
> Kjell
>
> "Kjell Brandes" <kjell@.brandes.tv> wrote in message
> news:%232VKlMAlEHA.3520@.TK2MSFTNGP11.phx.gbl...
>> Trying to set up a site with both integrated and basic authentication
>> enabled (anonymous disabled of course).
>> When working on local network I want integrated auth. to act, and it
>> does,
>> no problem.
>> Accessing site from outside of local network Basic auth. should kick in,
> and
>> it does, no problem. But Basic auth. does not listen to default domain.
>> It
>> takes the local machinename as auth. domain.
>> Am I doing something wrong or is this the behaviour to expect?
>> Any help would be very appreciated!
>> Kjell
>>
>|||the default domain used for basic authenication is controlled by an IIS
property. Use the IIS snap in. Open Properties for the WWW server. Select
the Directory Security Tab. (on IIS 5)
you will see next to the Basic authentication check box the Phrase:
SELECT A DOMAIN and a button labeled EDIT
Click the EDIT button and type in the domain name you want to use for the
default.
the alternative, of course, as Brian pointed out, is to explicitly type the
domain in the username dialog box during basic authentication.
Hope this helps.
dlr
"Brian Welcker [MSFT]" <bwelcker@.online.microsoft.com> wrote in message
news:eUXUJSFlEHA.3520@.TK2MSFTNGP11.phx.gbl...
> Are you typing domain\username for the user name in the security dialog?
If
> not specified, it will default to the local machine account.
> --
> Brian Welcker
> Group Program Manager
> SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> "Kjell Brandes" <kjell@.brandes.tv> wrote in message
> news:eafkcXAlEHA.2764@.TK2MSFTNGP11.phx.gbl...
> > sorry wrong group, posting this to the right group...
> >
> > Sorry!!
> >
> > Kjell
> >
> >
> > "Kjell Brandes" <kjell@.brandes.tv> wrote in message
> > news:%232VKlMAlEHA.3520@.TK2MSFTNGP11.phx.gbl...
> >> Trying to set up a site with both integrated and basic authentication
> >> enabled (anonymous disabled of course).
> >> When working on local network I want integrated auth. to act, and it
> >> does,
> >> no problem.
> >> Accessing site from outside of local network Basic auth. should kick
in,
> > and
> >> it does, no problem. But Basic auth. does not listen to default domain.
> >> It
> >> takes the local machinename as auth. domain.
> >> Am I doing something wrong or is this the behaviour to expect?
> >>
> >> Any help would be very appreciated!
> >>
> >> Kjell
> >>
> >>
> >
> >
>