SQL Server 2005 Express Edition

Question

Post reply

SQL Server 2005 Express Edition

Subrata Bauri

SSCommitted

Points: 1503
More actions
January 4, 2010 at 3:53 am

#136337

Dear all,
Can I create SQL Server with the help of SQL Server 2005 Express Edition ??

Viewing 10 posts - 1 through 9 (of 9 total)

You must be logged in to reply to this topic. Login to reply

steveb. SSC-Forever Points: 46733 More actions · Answer 1

yes with SQL server express you can create SQL databases up to 4gb all for free..

Subrata Bauri SSCommitted Points: 1503 More actions · Answer 2

Thanks for your reply.

Can Other Client (Pc) access the Server Database ?

steveb. SSC-Forever Points: 46733 More actions · Answer 3

Yes it works excatly the same way as standard SQL server,

However you will need to explicity allow remote network connections in the SQL config manager on the server

Subrata Bauri SSCommitted Points: 1503 More actions · Answer 4

How to create Server in SQL Server Express edition ??

How To create Users in the DB ??

steveb. SSC-Forever Points: 46733 More actions · Answer 5

you create users and dbs in the same way as you do in SQL standard.

You may want to start by looking at books on line

http://msdn.microsoft.com/en-us/library/ms130214.aspx"> http://msdn.microsoft.com/en-us/library/ms130214.aspx

there is a lot of information here on setting up SQL server.

Once you have an understanding of the bascis then feel free to ask more specific questions if you run into problems.

lawsonj Grasshopper Points: 20 More actions · Answer 6

The only drawback to SQL Server Express is that you will not have the ability to create Maintenance plans or create Jobs for Maintenance on the databases.

Chris Houghton SSCrazy Points: 2557 More actions · Answer 7

Although you can script the backups / Maintenance Tasks and execute them using windows scheduled tasks.

Subrata Bauri SSCommitted Points: 1503 More actions · Answer 8

How to Create DB Login Users with specific permissions/Authentication Mode in this Express edition.

muthukkumaran Kaliyamoorthy SSCoach Points: 19026 More actions · Answer 9

subrata.bauri-1051938 (1/7/2010)
How to Create DB Login Users with specific permissions/Authentication Mode in this Express edition.

Look the BOL.

Muthukkumaran Kaliyamoorthy
https://www.sqlserverblogforum.com/