How to setup SQL Express for course use

I will be teaching a web scripting course, and I would like to switch from using MS Access to MS SQL as a database. Please forgive my ignorance, as have much to learn about SQL Express. We have installed SQL Express on a web server (windows box).

Question1:
is SQL like MS Access, in that the SQL Express software should be installed locally on the users machine. The user will create databases and tables locally, then upload the resulting database(s) to the appropriate folder on the web server along with web scripting files?
-- OR
is MS SQL like MySQL, where the db is installed on the remote server, and user accounts are created within the database with appropriate priv.'s. The user logs in to the db application remotely to create tables within a given database.

You can install it either way (locally or remotely). I could see advantages to both. If they install it locally to each machine, you wouldn't have to worry about setting up users/permissions/remote connections, etc on a central server. But if you install it on a central server, you only have to go through the install one time and don't have to worry about the student upload/transfer.

If you don't have much experience with Express, I'd suggest installing Express Advanced so you can get the GUI management tools as well.

Thanks,
Sam Lester (MSFT)

How to set SQL Server only accept SQL Server Authentication mode?

How to set SQL Server only accept SQL Server Authentication mode?
Our company will not use mixed authentication mode, how to switch SQL Server
Authentication?ABC
I don't think you can do that. Either SS2000 and SS2005 accept Windows and
SQL Server and Windows Authentication
However it does not o have onyl SQL Server Authentication.
Why would you want to do that? If you want , you cam build a connection
string to the SQL Server by using SQL Server Authentication by providing a
user and a password but it will be alwasy an another option to connect by
WA.
"ABC" <abc@.abc.com> wrote in message
news:ueCqj69JGHA.916@.TK2MSFTNGP10.phx.gbl...
> How to set SQL Server only accept SQL Server Authentication mode?
> Our company will not use mixed authentication mode, how to switch SQL
> Server Authentication?
>
>
>|||I don't know why.
Our web project is used VS2003 and Crystal Reports for Visual Studio.NET.
There have reports that directly call to sql server's stored procedure. I
also call SetDatabaseLogon method to change user id and password. But I
found the crystal reports use ASPNET account to logon SQL Server, not my
expected user id.
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:uk5WVE%23JGHA.3896@.TK2MSFTNGP15.phx.gbl...
> ABC
> I don't think you can do that. Either SS2000 and SS2005 accept Windows
> and SQL Server and Windows Authentication
> However it does not o have onyl SQL Server Authentication.
> Why would you want to do that? If you want , you cam build a connection
> string to the SQL Server by using SQL Server Authentication by providing a
> user and a password but it will be alwasy an another option to connect by
> WA.
>
>
> "ABC" <abc@.abc.com> wrote in message
> news:ueCqj69JGHA.916@.TK2MSFTNGP10.phx.gbl...
>|||ABC
Does the server have Mixed Authenitcation or Windows only?
"ABC" <abc@.abc.com> wrote in message
news:%23tATCN%23JGHA.2088@.TK2MSFTNGP11.phx.gbl...
>I don't know why.
> Our web project is used VS2003 and Crystal Reports for Visual Studio.NET.
> There have reports that directly call to sql server's stored procedure. I
> also call SetDatabaseLogon method to change user id and password. But I
> found the crystal reports use ASPNET account to logon SQL Server, not my
> expected user id.
>
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:uk5WVE%23JGHA.3896@.TK2MSFTNGP15.phx.gbl...
>|||Mixed mode.
"Uri Dimant" <urid@.iscar.co.il> glsD:%230Zzda%23JGHA.2912@.tk2msftngp13.phx.gbl...[
vbcol=seagreen]
> ABC
> Does the server have Mixed Authenitcation or Windows only?
>
> "ABC" <abc@.abc.com> wrote in message
> news:%23tATCN%23JGHA.2088@.TK2MSFTNGP11.phx.gbl...
>[/vbcol]

how to set connection string value by using SET switch of dtexec sql server 2005 command

hi

I need to load a text file into sql server table using SSIS package.

the idea is to load this file with the help of dtexec command by giving the file path and name in the SET switch of dtexec command.

anyone having an idea; would be of great help.

Regards,

Salman Shehbaz.

Try using the package configuration wizard to get the property path:

Jamie talks about it here:

http://blogs.conchango.com/jamiethomson/archive/2007/03/13/SSIS_3A00_-Property-Paths-syntax.aspx

|||

o.kays

i finally got hold of the command;

here it is

execute master.dbo.xp_cmdshell 'dtexec /Ser "ServerName" /SQ "SSISPackagehName" /SET "\Package.Connections[ConnectionManagerName].Properties[ConnectionString]";"TextFilePath/Name"'

Regards,

Salman Shehbaz.