Best Reporting Services Book

Any suggestions on the best reference book to help with building
simple-moderately difficult reports for a beginner? This looks pretty good
but wonder if it might be too advanced 'Hitchhiker's Guide to SQL Server
2000 Reporting Services'
Thanks!I think that the Hitchhiker book is very good. The tone is conversational,
and I have found much of the material to apply to my own real-world
situations. Actually, you can download the first two chapters for free
(http://www.sqlreportingservices.net/BookSrs2000/preview/default.aspx) . You
may want to try it and see if it works for you.
Another good one is Brian Larson's Microsoft SQL Server 2000 Reporting
Services". I am sure that there are other good books besides those, but
these are the two that I am familiar with.
"Mike Harbinger" wrote:
> Any suggestions on the best reference book to help with building
> simple-moderately difficult reports for a beginner? This looks pretty good
> but wonder if it might be too advanced 'Hitchhiker's Guide to SQL Server
> 2000 Reporting Services'
> Thanks!
>
>

Best Printed book of TSQL?

The two books by Itzik Ben-gan, Microsoft Press.

Inside SQL Server: T-SQL Programming

Inside SQL Server: T-SQL Querying

|||

Thanks Annie I will find in book store

Daniel

|||

(Inside SQL Server: T-SQL Programming)

http://support.microsoft.com/default.aspx/kb/920141

Comes with this long errata if you don't know SQL Server spend time with the BOL when you use this book, I don't think it was written for 2005 and Microsoft agree.

best book on complex DTS packages?

I already know how to use the basics for setting up and running DTS packages in SQL Server 2000. Does anyone have a good recommendation for book(s) that cover advanced DTS topics such as using command line scripts, ETL and so forth to work with complex DTS topics? ThanksThe only one I know about and own is Professional DTS by Wrox books, it was written by guys at Alltel and Encore development which is a BI company.

HTH

BTW: I do reccomend it!

Best book for SQL Server 2005 Administration

Can anyone please suggest a good book for SQL Server 2005 Administration for
experienced SQL Server 2000 DBA.
Thanks in advance.
ManuManu,
I can personally recommend these 2 books:
As a good general coverage - "Pro SQL Server 2005"
http://www.itbookworm.com/Review.asp?ID=11
For the internals in detail: "Inside Microsoft SQL Server 2005: The Storage
Engine"
http://www.amazon.com/Inside-Micros...ie=UTF8&s=books
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .

Best book for SQL Server 2005 Administration

Can anyone please suggest a good book for SQL Server 2005 Administration for
experienced SQL Server 2000 DBA.
Thanks in advance.
Manu
Manu,
I can personally recommend these 2 books:
As a good general coverage - "Pro SQL Server 2005"
http://www.itbookworm.com/Review.asp?ID=11
For the internals in detail: "Inside Microsoft SQL Server 2005: The Storage
Engine"
http://www.amazon.com/Inside-Microsoft-SQL-Server-2005/dp/0735621055/sr=8-1/qid=1167940895/ref=pd_bbs_sr_1/102-9099990-2949748?ie=UTF8&s=books
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .

Best book for relational db's?

Greetings,
I'm reentering SQLServer-land after an absense. I've forgotten most of
my school-taught relational/OO database design theory. Normalization is
still in the old memory banks, but it too is fading fast. :)
Can anyone recommend a good book on relational design that can refresh
my skills?
Thanks!See if this helps:
http://www.datamodel.org/DataModelLibrary.html
AMB
"Guerrilla_Coder" wrote:

> Greetings,
> I'm reentering SQLServer-land after an absense. I've forgotten most of
> my school-taught relational/OO database design theory. Normalization is
> still in the old memory banks, but it too is fading fast. :)
> Can anyone recommend a good book on relational design that can refresh
> my skills?
> Thanks!
>

Best book

I'm looking to learn sql server 2000 can anybody recommend
a book
thanks
suggsinside sql server 2000
"sugg" <suggs@.hotmail.com> wrote in message
news:038c01c38d80$7d867540$a001280a@.phx.gbl...
> I'm looking to learn sql server 2000 can anybody recommend
> a book
> thanks
> suggs|||Have a look at the books page on here :-
http://vyaskn.tripod.com/sqlbooks.htm
HTH
Ryan Waight, MCDBA, MCSE
"sugg" <suggs@.hotmail.com> wrote in message
news:038c01c38d80$7d867540$a001280a@.phx.gbl...
> I'm looking to learn sql server 2000 can anybody recommend
> a book
> thanks
> suggs|||This is a multi-part message in MIME format.
--=_NextPart_000_00C6_01C38D7F.DB92A650
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Try:
www.mssqlserver.com/books
-- Tom
---
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com/sql
"sugg" <suggs@.hotmail.com> wrote in message =news:038c01c38d80$7d867540$a001280a@.phx.gbl...
I'm looking to learn sql server 2000 can anybody recommend a book
thanks
suggs
--=_NextPart_000_00C6_01C38D7F.DB92A650
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&

---

Try:
www.mssqlserver.com/books
-- Tom
---T=homas A. Moreau, BSc, PhD, MCSE, MCDBASQL Server MVPColumnist, SQL =Server ProfessionalToronto, ON Canadahttp://www.pinnaclepublishing.com/sql">www.pinnaclepublishing.com=/sql
"sugg" wrote in message news:038c01c38d80$7d=867540$a001280a@.phx.gbl...I'm looking to learn sql server 2000 can anybody recommend a bookthankssuggs

---

--=_NextPart_000_00C6_01C38D7F.DB92A650--|||this book is for advanced users. hope it doesn't scare him away from
SQL.:-)
"Henry" <qiuliang@.163.net> wrote in message
news:ekOD6JYjDHA.1808@.TK2MSFTNGP09.phx.gbl...
> inside sql server 2000
> "sugg" <suggs@.hotmail.com> wrote in message
> news:038c01c38d80$7d867540$a001280a@.phx.gbl...
> > I'm looking to learn sql server 2000 can anybody recommend
> > a book
> >
> > thanks
> >
> > suggs
>

Best Admin Book?

What is the best book out there covering SQL Server 2000
administration/security?
HI
1.
SQL 2000 Server Operations Guide
<http://www.microsoft.com/technet/pro...n/sqlops1.mspx>
2.
BOL
3.
SQL Server 2000 Administrator's Companion
4.
SQL Server 2000 Resource Kit
JBandi
|||SQL DBA Survival Guide and the Joe Celko books for sql are
the only books I need.

>--Original Message--
>HI
>1.
>SQL 2000 Server Operations Guide
><http://www.microsoft.com/technet/pro...l/sql/2000/mai
ntain/sqlops1.mspx>
>2.
>BOL
>3.
>SQL Server 2000 Administrator's Companion
>4.
>SQL Server 2000 Resource Kit
>
>JBandi
>.
>

Best Admin Book?

What is the best book out there covering SQL Server 2000
administration/security?SQL DBA Survival Guide and the Joe Celko books for sql are
the only books I need.
>--Original Message--
>HI
>1.
>SQL 2000 Server Operations Guide
><http://www.microsoft.com/technet/prodtechnol/sql/2000/mai
ntain/sqlops1.mspx>
>2.
>BOL
>3.
>SQL Server 2000 Administrator's Companion
>4.
>SQL Server 2000 Resource Kit
>
>JBandi
>.
>

Best Admin Book?

What is the best book out there covering SQL Server 2000
administration/security?HI
1.
SQL 2000 Server Operations Guide
<http://www.microsoft.com/technet/pr...in/sqlops1.mspx
>
2.
BOL
3.
SQL Server 2000 Administrator's Companion
4.
SQL Server 2000 Resource Kit
JBandi|||SQL DBA Survival Guide and the Joe Celko books for sql are
the only books I need.

>--Original Message--
>HI
>1.
>SQL 2000 Server Operations Guide
><http://www.microsoft.com/technet/pr...ol/sql/2000/mai
ntain/sqlops1.mspx>
>2.
>BOL
>3.
>SQL Server 2000 Administrator's Companion
>4.
>SQL Server 2000 Resource Kit
>
>JBandi
>.
>

Beginning SQL Server Book?

Greetings:

I would like to ask for recommendations for a good beginning book on
SQL Server. My web host offers a 100MB SQL Server database as part of
the package, and I'd like to use the feature to learn.

I am proficient in Access and familiar with basic connectivity to it
via ASP. I don't have my own license for SQL Server (and currently
can't afford one) so all development will need to be done by
interfacing with the remote database. As such, I won't need a lot of
explanation regarding installation and software setup.

Does anyone here know of a good study resource for someone in this
scenario?

Many thanks in advance,
KayKayInPA (aviationns@.kmwonline.com) writes:
> I would like to ask for recommendations for a good beginning book on
> SQL Server. My web host offers a 100MB SQL Server database as part of
> the package, and I'd like to use the feature to learn.
> I am proficient in Access and familiar with basic connectivity to it
> via ASP. I don't have my own license for SQL Server (and currently
> can't afford one) so all development will need to be done by
> interfacing with the remote database. As such, I won't need a lot of
> explanation regarding installation and software setup.

Then again, it's very conventient to have a local database. And, this
is easy to get hold of! You can download the Evaluation Edition of
SQL Server from
http://www.microsoft.com/downloads/...&displaylang=en
This is installation is valid for 120 days.

If you buy a book, it is very likely that you will get the Evaulation
Edition with a book as well. However, by all means, use the download
instead. The download is protected against the Slammer worm, whereas
the CD in the book may be old and lacks Slammer protection.

As for books, I have little experience in SQL Server books for beginners,
but I believe that Richard Waymire's "SQL Server in 21 days" is a good
starter kit.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp|||If you want to practice on a local SQL Server you can donwload the
evaluation edition for free.

http://www.microsoft.com/downloads/...&displaylang=en

Everything you need to know is in the Book on line for SQL Server. I can't
tell you for sure if Books on line will download with the evaluation edition
because I got mine from New Horizons.

If you really need a book I have the SQL Server 2000 Bible to be pretty
good. The author, Paul Nielsen seems to really konw his stuff. And there
is a lot of good theortical info to support why you would do things in one
particular way vs another.

Take Care

Michael Leonard

"KayInPA" <aviationns@.kmwonline.com> wrote in message
news:1108322237.729635.106510@.l41g2000cwc.googlegr oups.com...
> Greetings:
> I would like to ask for recommendations for a good beginning book on
> SQL Server. My web host offers a 100MB SQL Server database as part of
> the package, and I'd like to use the feature to learn.
> I am proficient in Access and familiar with basic connectivity to it
> via ASP. I don't have my own license for SQL Server (and currently
> can't afford one) so all development will need to be done by
> interfacing with the remote database. As such, I won't need a lot of
> explanation regarding installation and software setup.
> Does anyone here know of a good study resource for someone in this
> scenario?
> Many thanks in advance,
> Kay|||MS Press's MS SQL Server 2000 Step by Step covers all the Enterprise Manager
tools, as well as admin tasks and some basic T-SQL. Very good for beginners
to learn, but it doesn't cover the command line tools at all. It has the 120
day eval CD, too. $49.99, but you might find it cheaper at Amazon. ISBN
7356-1142-4. For programming, you need a good ASP or ASP .net or VB.Net
book, but you can also learn a lot from the .Net Framework SDK available
from http://www.gotdotnet.com
I believe. Also, once your eval of the Enterprise edition runs out, you can
still use Enterprise manager to manage MSDE, the desktop edition of SQL
server. So don't uninstall it, lol. I used ASP,Ner Step by Step to learn
VB.Net, and a few other books, but that one covers more VB than the SQL
Server SbS mentioned above covers SQL.

"KayInPA" <aviationns@.kmwonline.com> wrote in message
news:1108322237.729635.106510@.l41g2000cwc.googlegr oups.com...
> Greetings:
> I would like to ask for recommendations for a good beginning book on
> SQL Server. My web host offers a 100MB SQL Server database as part of
> the package, and I'd like to use the feature to learn.
> I am proficient in Access and familiar with basic connectivity to it
> via ASP. I don't have my own license for SQL Server (and currently
> can't afford one) so all development will need to be done by
> interfacing with the remote database. As such, I won't need a lot of
> explanation regarding installation and software setup.
> Does anyone here know of a good study resource for someone in this
> scenario?
> Many thanks in advance,
> Kay|||Thanks to all for your suggestions. I'll be logging on to amazon
shortly!

I've had good success with both the "...in 21 days" and "Bible" books
with other technologies, so I may start there. I'm currently starting
a wrox book on ASP .NET but not yet convinced of it's superiority to
straight ASP, particularly since I'm well used to a dreamweaver
ultradev environment. I have no burning desire to purchase Visual
Studio any time soon, however this may change as I learn more.

Also not convinced of the real world benefits of MSDE. I've deployed
Access as the database for use on small (maybe 10 simulaneous users -
not 10 simultaneous connections) sites with no difficulty at all. I do
foresee the need for growth, however, and SQL Server will likely be the
way to go.

Again, thanks to all for your advice. Much appreciated.

Kay|||There's a Wrox book that was not very publicized that I like a lot. Of
course, it's about ASP.Net and SQL server 2000, but that is the way things
are. Visual Basic.Net and SQL Server 2000: Building and Effective Data
Layer, by Tony Bain and Denise Cosnell (2002). MS is already shipping SQL
Server 2005 beta. I believe they will have a free desktop edition of that,
too.

As far as MSDE, it IS SQL Server. It's just that it's limited to 5
concurrent connections, I think. But it's a good way to learn MS T-SQL,
cheaply. And the .Net Framework SDK has free editions of VB.Net, C#, and I
think C++ compliers (command line). If you can find a free IDE to handle
them, you would not need VS.Net (but wow, you'd be missing a lot).
Patrick

"KayInPA" <aviationns@.kmwonline.com> wrote in message
news:1108388967.331235.212930@.c13g2000cwb.googlegr oups.com...
> Thanks to all for your suggestions. I'll be logging on to amazon
> shortly!
> I've had good success with both the "...in 21 days" and "Bible" books
> with other technologies, so I may start there. I'm currently starting
> a wrox book on ASP .NET but not yet convinced of it's superiority to
> straight ASP, particularly since I'm well used to a dreamweaver
> ultradev environment. I have no burning desire to purchase Visual
> Studio any time soon, however this may change as I learn more.
> Also not convinced of the real world benefits of MSDE. I've deployed
> Access as the database for use on small (maybe 10 simulaneous users -
> not 10 simultaneous connections) sites with no difficulty at all. I do
> foresee the need for growth, however, and SQL Server will likely be the
> way to go.
> Again, thanks to all for your advice. Much appreciated.
> Kay

Beginner Question - SQL Server

Hi, I am currently learning ASP.net 1.1 using the apress Beginning
ASP.NET 1.1 E-Commerce book.
I am working my way through but have hit a problem on chapter 3.
When I try to start the application i get the following error:
Server Error in '/JokePoint' Application.
Login failed for user 'IND055000013\ASPNET'
In the book it says that this is down to SQL Server Security and that I
need to enabled mixed mode authentication. I did this by editting the
regedit, however, the error still persists.
Any help would be much appreciated.
Thanks
Did you restarted the service ?
HTH, jens Suessmeyer.
|||yes, the error message in full is
Description: An unhandled exception occurred during the execution of
the current web request. Please review the stack trace for more
information about the error and where it originated in the code.
Exception Details: System.Data.SqlClient.SqlException: Login failed for
user 'IND055000013\ASPNET'.
Source Error:
Line 9: command.CommandType = CommandType.StoredProcedure
Line 10: ' Open the connection
Line 11: connection.Open()
Line 12: 'Return a SqlDataReader to the calling function
Line 13: Return
command.ExecuteReader(CommandBehavior.CloseConnect ion)
Source File: F:\MyCommerceSite\JokePoint\BusinessObjects\Catalo g.vb
Line: 11
Stack Trace:
[SqlException: Login failed for user 'IND055000013\ASPNET'.]
System.Data.SqlClient.ConnectionPool.GetConnection (Boolean&
isInTransaction) +474
System.Data.SqlClient.SqlConnectionPoolManager.Get PooledConnection(SqlConnectionString
options, Boolean& isInTransaction) +372
System.Data.SqlClient.SqlConnection.Open() +384
JokePoint.Catalog.GetDepartments() in
F:\MyCommerceSite\JokePoint\BusinessObjects\Catalo g.vb:11
JokePoint.DepartmentsList.Page_Load(Object sender, EventArgs e) in
F:\MyCommerceSite\JokePoint\UserControls\Departmen tsList.ascx.vb:33
System.Web.UI.Control.OnLoad(EventArgs e) +67
System.Web.UI.Control.LoadRecursive() +35
System.Web.UI.Control.LoadRecursive() +98
System.Web.UI.Control.LoadRecursive() +98
System.Web.UI.Page.ProcessRequestMain() +750
Again any help would be very appreciated
|||Look in the BOl for more information:
"Allows a Microsoft=AE Windows NT=AE user or group account to connect to
Microsoft SQL Server=99 using Windows Authentication.
Syntax
sp_grantlogin [@.loginame =3D] 'login'"
--to give him permissions to access the server
"sp_grantdbaccess
Adds a security account in the current database for a Microsoft=AE SQL
Server=99 login or Microsoft Windows NT=AE user or group, and enables it
to be granted permissions to perform activities in the database.
Syntax
sp_grantdbaccess [@.loginame =3D] 'login'
[,[@.name_in_db =3D] 'name_in_db' [OUTPUT]]"
--to grant access in the database
"GRANT
Creates an entry in the security system that allows a user in the
current database to work with data in the current database or execute
specific Transact-SQL statements."
--to grant him specific privilegs e.g. Select on a table.
"sp_addrolemember
Adds a security account as a member of an existing Microsoft=AE SQL
Server=99 database role in the current database."
--to add him to a predefined role with specific permissions, e.g.
dbowner
sp_addrolemember 'db_owner','Domain\User'
Based ont he assumption that you have SQL Server MSDE or Express
installed, otherwise you could use a graphical interface for
configuring this.
HTH, jens Suessmeyer.

Beginner Question - SQL Server

Hi, I am currently learning ASP.net 1.1 using the apress Beginning
ASP.NET 1.1 E-Commerce book.
I am working my way through but have hit a problem on chapter 3.
When I try to start the application i get the following error:
Server Error in '/JokePoint' Application.
----
--
Login failed for user 'IND055000013\ASPNET'
In the book it says that this is down to SQL Server Security and that I
need to enabled mixed mode authentication. I did this by editting the
regedit, however, the error still persists.
Any help would be much appreciated.
ThanksDid you restarted the service ?
HTH, jens Suessmeyer.|||yes, the error message in full is
Description: An unhandled exception occurred during the execution of
the current web request. Please review the stack trace for more
information about the error and where it originated in the code.
Exception Details: System.Data.SqlClient.SqlException: Login failed for
user 'IND055000013\ASPNET'.
Source Error:
Line 9: command.CommandType = CommandType.StoredProcedure
Line 10: ' Open the connection
Line 11: connection.Open()
Line 12: 'Return a SqlDataReader to the calling function
Line 13: Return
command.ExecuteReader(CommandBehavior.CloseConnection)
Source File: F:\MyCommerceSite\JokePoint\BusinessObje
cts\Catalog.vb
Line: 11
Stack Trace:
[SqlException: Login failed for user 'IND055000013\ASPNET'.]
System.Data.SqlClient.ConnectionPool.GetConnection(Boolean&
isInTransaction) +474
System.Data.SqlClient.SqlConnectionPoolManager.GetPooledConnection(SqlConnec
tionString
options, Boolean& isInTransaction) +372
System.Data.SqlClient.SqlConnection.Open() +384
JokePoint.Catalog.GetDepartments() in
F:\MyCommerceSite\JokePoint\BusinessObje
cts\Catalog.vb:11
JokePoint.DepartmentsList.Page_Load(Object sender, EventArgs e) in
F:\MyCommerceSite\JokePoint\UserControls
\DepartmentsList.ascx.vb:33
System.Web.UI.Control.OnLoad(EventArgs e) +67
System.Web.UI.Control.LoadRecursive() +35
System.Web.UI.Control.LoadRecursive() +98
System.Web.UI.Control.LoadRecursive() +98
System.Web.UI.Page.ProcessRequestMain() +750
Again any help would be very appreciated|||Look in the BOl for more information:
"Allows a Microsoft=AE Windows NT=AE user or group account to connect to
Microsoft SQL Server=99 using Windows Authentication.
Syntax
sp_grantlogin [@.loginame =3D] 'login'"
--to give him permissions to access the server
"sp_grantdbaccess
Adds a security account in the current database for a Microsoft=AE SQL
Server=99 login or Microsoft Windows NT=AE user or group, and enables it
to be granted permissions to perform activities in the database.
Syntax
sp_grantdbaccess [@.loginame =3D] 'login'
[,[@.name_in_db =3D] 'name_in_db' [OUTPUT]]"
--to grant access in the database
"GRANT
Creates an entry in the security system that allows a user in the
current database to work with data in the current database or execute
specific Transact-SQL statements."
--to grant him specific privilegs e.g. Select on a table.
"sp_addrolemember
Adds a security account as a member of an existing Microsoft=AE SQL
Server=99 database role in the current database."
--to add him to a predefined role with specific permissions, e.g.
dbowner
sp_addrolemember 'db_owner','Domain\User'
Based ont he assumption that you have SQL Server MSDE or Express
installed, otherwise you could use a graphical interface for
configuring this.
HTH, jens Suessmeyer.

Beginner Question - SQL Server

Hi, I am currently learning ASP.net 1.1 using the apress Beginning
ASP.NET 1.1 E-Commerce book.
I am working my way through but have hit a problem on chapter 3.
When I try to start the application i get the following error:
Server Error in '/JokePoint' Application.
----
Login failed for user 'IND055000013\ASPNET'
In the book it says that this is down to SQL Server Security and that I
need to enabled mixed mode authentication. I did this by editting the
regedit, however, the error still persists.
Any help would be much appreciated.
ThanksDid you restarted the service ?
HTH, jens Suessmeyer.|||yes, the error message in full is
Description: An unhandled exception occurred during the execution of
the current web request. Please review the stack trace for more
information about the error and where it originated in the code.
Exception Details: System.Data.SqlClient.SqlException: Login failed for
user 'IND055000013\ASPNET'.
Source Error:
Line 9: command.CommandType = CommandType.StoredProcedure
Line 10: ' Open the connection
Line 11: connection.Open()
Line 12: 'Return a SqlDataReader to the calling function
Line 13: Return
command.ExecuteReader(CommandBehavior.CloseConnection)
Source File: F:\MyCommerceSite\JokePoint\BusinessObjects\Catalog.vb
Line: 11
Stack Trace:
[SqlException: Login failed for user 'IND055000013\ASPNET'.]
System.Data.SqlClient.ConnectionPool.GetConnection(Boolean&
isInTransaction) +474
System.Data.SqlClient.SqlConnectionPoolManager.GetPooledConnection(SqlConnectionString
options, Boolean& isInTransaction) +372
System.Data.SqlClient.SqlConnection.Open() +384
JokePoint.Catalog.GetDepartments() in
F:\MyCommerceSite\JokePoint\BusinessObjects\Catalog.vb:11
JokePoint.DepartmentsList.Page_Load(Object sender, EventArgs e) in
F:\MyCommerceSite\JokePoint\UserControls\DepartmentsList.ascx.vb:33
System.Web.UI.Control.OnLoad(EventArgs e) +67
System.Web.UI.Control.LoadRecursive() +35
System.Web.UI.Control.LoadRecursive() +98
System.Web.UI.Control.LoadRecursive() +98
System.Web.UI.Page.ProcessRequestMain() +750
Again any help would be very appreciated|||Look in the BOl for more information:
"Allows a Microsoft=AE Windows NT=AE user or group account to connect to
Microsoft SQL Server=99 using Windows Authentication.
Syntax
sp_grantlogin [@.loginame =3D] 'login'"
--to give him permissions to access the server
"sp_grantdbaccess
Adds a security account in the current database for a Microsoft=AE SQL
Server=99 login or Microsoft Windows NT=AE user or group, and enables it
to be granted permissions to perform activities in the database.
Syntax
sp_grantdbaccess [@.loginame =3D] 'login'
[,[@.name_in_db =3D] 'name_in_db' [OUTPUT]]"
--to grant access in the database
"GRANT
Creates an entry in the security system that allows a user in the
current database to work with data in the current database or execute
specific Transact-SQL statements."
--to grant him specific privilegs e.g. Select on a table.
"sp_addrolemember
Adds a security account as a member of an existing Microsoft=AE SQL
Server=99 database role in the current database."
--to add him to a predefined role with specific permissions, e.g.
dbowner
sp_addrolemember 'db_owner','Domain\User'
Based ont he assumption that you have SQL Server MSDE or Express
installed, otherwise you could use a graphical interface for
configuring this.
HTH, jens Suessmeyer.

Beginner needs help installing MSDE

Hi, I am trying to teach myself ASP.NET from the SAMS 24 Hrs book and I am trying to install MSDE for use with the web matrix project.

I think I succesfully installed it the first time I tried but entered a four digit SAPWD password not knowing it needed to be strong. I clicked on the data tab in the web matrix project as instructed to open the database and entered my user and password but it gave me some error message.

Now when I click the data tab it say I need to install MSDE on my computer and links me to www.asp.net.

Then when I try to install MSDE after it has downloaded, it gives me this error message. -- 'Setup failed to configure the server. Refer to the server error logs and setup error logs for more information.'--

I have tried uninstalling and reinstalling everything as well as everything else I can think of.

I would be forever grateful if someone could help me out with this.

Many Thanks

Mark
E-Mail: poolstar_uk@.hotmail.comTry this link. It might help.

http://support.microsoft.com/default.aspx?scid=kb%3Ben-us%3B829386

Goodluck|||Many Thanks for the advice but I am still having no luck with it.

Any other ideas? I'm not sure my pc will live to see many more days!|||Are you using the Web Matrix server or The IIS ?|||I appreciate your replies, thanks.

I am using the web matrix server.

I have tried installing IIS but it is asking for my windows disk and I cannot find it. I've just moved house and there are boxes and bags everywhere.

Do you think I could use IIS if I could find the disk? Or do you have any ideas on using the web matrix project?|||Follow this tutorial. It's from this website.

http://www.asp.net/webmatrix/guidedtour/Appendices/installMsde.aspx

Perfect example and exact step-by-step of what you need to do. Also, please post what your error logs state if this still doesn't work. You can specify where your logs dump to when you install MSDE from the command line.

Hope this helps. Good luck.|||Thanks everyone for your help, problem solved.

Many Thanks|||Hi poolstar, actually I have the same problem as yours, can u tell me how u solved the problem, thanks a lot man. can u email me this through this email jie_jeep@.yahoo.com|||I am having the same problem but the tutorial did not help.

How do you specify where the log dumps to?

I am using an XP machine networked to another XP machine for internet purposes. My machine is the slave and does not have its own modem. I normally turn off the connection unless I want to be hooked to the internet.

The instructions I had read that time said to install with sapwd=matrixsa instancename=matrixsa but did not add securitymode=sql so I tried the install without it (with the lan connection active). MSDE did install but then had no red x or green arrow in the white circle on the icon in the system tray. When I clicked on the icon, it was looking for the master machine and there were no possible selections in the dropdown box.

I uninstalled, restarted and tried it again with the securitymode and began to get the error again saying that setup failed to configure the server. I have tried three more times, restarting each time, and consistently get this error. All of the successive times, the lan connection has been off.

Any suggestions? Could this be caused by the lack of a modem in this machine and/or having the lan connection active?

Thanks,
Beth