Re: Need helps with SQL Server Express

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

You can access SQL Server via the TCP/IP protocol.
In this case, you will have to make sure that TCP/IP is enabled (SQL Server Configuration Manager, SQL Server Network Configuration, Protocols --> TCP/IP).

When SQL Server is installed and the TCP/IP protocol is enabled, the specific SQL Server instance will be visible on the network. Then you can access SQL Server through the network but the access level depends on the access rights that each user or Windows Group has.

SQL Server provides multiple layers of security. I would recommend having different Windows Groups and assign specific access rights (i.e. server roles, database roles, etc) on these groups. To this end you can either use Windows authentication or mixed mode. Windows authentication is recommended.

I strongly disagree that whoever has Microsoft SQL Server Management Studio Express can go into the database and make changes to everything :)
The only type of user that can do anything in SQL Server is the one having the Sysadmin role. That is why you have to be careful with whom you assign this role to.

More on SQL Server 2005 security:
http://technet.microsoft.com/en-us/library/ms345149.aspx
http://download.microsoft.com/download/8/5/e/85eea4fa-b3bb-4426-97d0-7f7151b2011c/SQL2005SecBestPract.doc
http://www.microsoft.com/sqlserver/2005/en/us/Security.aspx

Regards.


--
Artemakis Artemiou
B.Sc., M.Sc.,
SQL Server MVP,
MCP, MCTS:SQL Server 2005, MCTS:SQL Server 2008 (Charter Member)

http://aartemiou.blogspot.com

This post is provided "as-is" and confers no rights.


"Accesshelp" <Accesshelp@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:C7F35382-DF6C-4766-A2A5-943DB1BF7029@xxxxxxxxxxxxxxxx
Artemakis,

Thanks again for the information. If I may, I would like to ask you more
questions. Unfortunately, these questions are, as you may have already
noticed, for the beginners.

After I build the SQL Server (SQL), the users will be using it. Currently,
the SQL is installed and located on my hard drive. After I finish with the
SQL, what should I do so that users can use it through front-end (FE)?

For Access, the back-end (BE) is located in a remote directory on the
network. the FE then connects to the BE for the users to use.

In addition, our IT dept told me that they want to put it on Citrix and told
me to tell them when the SQL is finished. Does it mean they know how to set
up on the network so that users can use it? Can you tell me a little about
it so that I know some background knowledge?

How about security? It appears to me that whoever has Microsoft SQL Server
Management Studio Express can go into the database and make changes to
everything. Is there a way to avoid it?

Thanks.

"Artemakis Artemiou" wrote:

In SQL Server 2005 Express Edition you cannot use the data import/export
wizard as it is one of the limitations.
Though, there are other tools which can be used for data import/export as
well. One such tool is BCP. More information on BCP can be found on the
following url:

http://msdn.microsoft.com/en-us/library/ms162802.aspx

Also, regarding the data you have in Access, you can use the functionality
of Access to directly export the data into SQL Server.

Regards.

--
Artemakis Artemiou
B.Sc., M.Sc.,
SQL Server MVP,
MCP, MCTS:SQL Server 2005, MCTS:SQL Server 2008 (Charter Member)

http://aartemiou.blogspot.com

This post is provided "as-is" and confers no rights.



"Accesshelp" <Accesshelp@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:EB495A63-8187-42A3-91B3-45210643D87A@xxxxxxxxxxxxxxxx
> Artemakis,
>
> Thanks for the information. I have some data in Access and CSV files.
> How
> can I bring them in electronically so that I do not have to type them
> manually?
>
> Thanks.
>
> "Artemakis Artemiou" wrote:
>
>> Hi,
>>
>> Good choice! :)
>>
>> Yes, in order to create a database (besides of using T-SQL), you can
>> right-click on "Databases", when connected to the Database Engine via
>> Management Studio, and select "New Database".
>> SQL Server 2005 Express Edition supports up to 4GB per Database.
>>
>> For more information about SQL Server 2005 Express Edition:
>> http://www.microsoft.com/Sqlserver/2005/en/us/express.aspx
>>
>> Cheers.
>>
>> -- >> Artemakis Artemiou
>> B.Sc., M.Sc.,
>> SQL Server MVP,
>> MCP, MCTS:SQL Server 2005, MCTS:SQL Server 2008 (Charter Member)
>>
>> http://aartemiou.blogspot.com
>>
>> This post is provided "as-is" and confers no rights.
>>
>>
>>
>> "Accesshelp" <Accesshelp@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
>> news:7E82E222-DBF4-422D-8F47-CC1096A54B39@xxxxxxxxxxxxxxxx
>> > Hello all,
>> >
>> > I am new to SQL Server. I just installed SQL Server 2005 Express
>> > Edition
>> > on
>> > my laptop (C drive), and I don't know where to continue.
>> >
>> > I want to use SQL Server because people told me that SQL Server can
>> > handle
>> > larger data than Access. Therefore, I am thinking about SQL Server >> > as
>> > a
>> > back-end database and Access as a front-end database for the users >> > to
>> > use.
>> >
>> > First of, where do I go to create a database for my data? Is it in
>> > under
>> > Databases in Database Engine in Microsoft SQL Server Management >> > Studio
>> > Express? Do I right click on the Summary screen in Databases to >> > create
>> > one?
>> >
>> > Secondly, is it true that SQL Server 2005 Express edition can handle
>> > only
>> > up
>> > to 4GB?
>> >
>> > Thanks.
>>
.

Relevant Pages

  • Idiomatic Expressions to Operating System Architecture: Transforming Rigids
    ... <Subject: Re: Idiomatic Expressions to Operating ... <endpoint during a single session * DATABASE + by ... <statements is a new feature of SQL Server 2005. ...
    (sci.math)
  • Re: Which Method to Create a Database Do I Use?
    ... To be fair, VS is a "generic" tool designed to front a variety of backend databases, but each of the serious engines have rights management needs as well. ... But the more I think about how connecting to a database is setup and the trouble it's been, the more it just pisses me off. ... Hitchhiker's Guide to Visual Studio and SQL Server ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Quick Question on SQL Server 2005 Express
    ... I wondered if we need any type of license to use Management Tools on a non-licensed machine so I asked to the Server and Tools Product Manager of Microsoft Turkey, whose name is Selma Karaca, I had met her on several Microsoft seminars which are held here in Istanbul... ... Server tools or technologies installed must have a valid SQL Server license. ... I have installed SQL Server 2005 Express, and now I want to connect to the remote database and use the Management Studio to manipulate the database. ...
    (microsoft.public.sqlserver.setup)
  • Re: MS Access DAO -> ADO.NET Migration
    ... William Vaughn ... Microsoft MVP ... Hitchhiker's Guide to Visual Studio and SQL Server ... My migration app works building a SSCE database file with imported data ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Cluster will not fail over.
    ... > As far as the TCP/IP issue goes, you had to rebuild the cluster and were ... > able to restore the master database. ... > a cluster installation you'll have to revisit. ... >> This worked bringing up the sql server in minimal mode. ...
    (microsoft.public.sqlserver.clustering)