Access Control List (structure) invalid - updating Virtual directory information

Hi,

I've just installed SQL server and then IIS and SQLCE tools.
I created a virtual directory and was trying to update the NTFS
permissions from SQLServer Connectivity management when i got the
following error - Access Control List (structure) invalid.

Has anyone come across this and if so, what did u do to fix it.

Thanks
LynThis seems to be an OS error, rather than something specific to MSSQL,
so you might get a better response in a Windows
admin/security/filesystem newsgroup. The error message is documented,
but the explanation is very minimal:

http://msdn.microsoft.com/library/d...w2kmsgs/393.asp

The replies to a previous (old) post about this error suggested using
CHKDSK to look for any NTFS corruption issues, so that might be worth a
go:

http://groups.google.ch/group/micro...43a9a59d?hl=en&

Simon|||Thanks

I'll give it a go

Simon Hayes wrote:
> This seems to be an OS error, rather than something specific to MSSQL,
> so you might get a better response in a Windows
> admin/security/filesystem newsgroup. The error message is documented,
> but the explanation is very minimal:
> http://msdn.microsoft.com/library/d...w2kmsgs/393.asp
> The replies to a previous (old) post about this error suggested using
> CHKDSK to look for any NTFS corruption issues, so that might be worth a
> go:
> http://groups.google.ch/group/micro...43a9a59d?hl=en&
> Simonsql

Acces Enterprise console

Hi everyone,
Can someone tell me if there are any tools to access the enterprise console
of sql server from another pc?
I've got 4 w2k clients and 1 w2k server.
Who can help me?
--
Pascual de la Cruz
Data Manager
Generation R
Erasmus MC
P.O. Box 1738
3000 DR Rotterdam
The Netherlands
Phone: +31 (0)10-4087479
Mail: delacruz@.generationr.nlYou simply need to install SQL Server client tools on your other PC. If you
cannot fo that, then log onto your SQL Server using Remote Desktop
connection.
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
What hardware is your SQL Server running on?
http://vyaskn.tripod.com/poll.htm
"Nicollo Machiaveli" <machiaveli280278@.hotmail.com> wrote in message
news:udIw5qHaDHA.4028@.tk2msftngp13.phx.gbl...
Hi everyone,
Can someone tell me if there are any tools to access the enterprise console
of sql server from another pc?
I've got 4 w2k clients and 1 w2k server.
Who can help me?
--
Pascual de la Cruz
Data Manager
Generation R
Erasmus MC
P.O. Box 1738
3000 DR Rotterdam
The Netherlands
Phone: +31 (0)10-4087479
Mail: delacruz@.generationr.nl|||Yes. Run thesetup program, and you can select Client Components (or whathever the selection is
named).
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as ugroup=microsoft.public.sqlserver
"Nicollo Machiaveli" <machiaveli280278@.hotmail.com> wrote in message
news:uz6UsELaDHA.384@.TK2MSFTNGP12.phx.gbl...
> Where can i find the client tools? Are they on the cd of sql server
> enterprise?
> --
> Pascual de la Cruz
> Data Manager
> Generation R
> Erasmus MC
> P.O. Box 1738
> 3000 DR Rotterdam
> The Netherlands
> Phone: +31 (0)10-4087479
> Mail: delacruz@.generationr.nl
> "Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
> news:eC0Z9gKaDHA.2648@.TK2MSFTNGP09.phx.gbl...
> > You simply need to install SQL Server client tools on your other PC. If
> you
> > cannot fo that, then log onto your SQL Server using Remote Desktop
> > connection.
> >
> > --
> > HTH,
> > Vyas, MVP (SQL Server)
> > http://vyaskn.tripod.com/
> > What hardware is your SQL Server running on?
> > http://vyaskn.tripod.com/poll.htm
> >
> >
> > "Nicollo Machiaveli" <machiaveli280278@.hotmail.com> wrote in message
> > news:udIw5qHaDHA.4028@.tk2msftngp13.phx.gbl...
> > Hi everyone,
> >
> > Can someone tell me if there are any tools to access the enterprise
> console
> > of sql server from another pc?
> >
> > I've got 4 w2k clients and 1 w2k server.
> >
> > Who can help me?
> >
> > --
> > Pascual de la Cruz
> > Data Manager
> > Generation R
> > Erasmus MC
> > P.O. Box 1738
> > 3000 DR Rotterdam
> > The Netherlands
> > Phone: +31 (0)10-4087479
> > Mail: delacruz@.generationr.nl
> >
> >
> >
>

Absolute Beginner Questions

I just downloaded and installed Visual Basic Express Edition and SQL Server Express Edition. All I have in the Start menu is SQL Configuration Tools. My absolutely stupid question is, how do I get started with this?

I know a little bit about SQL from using SQL command line in Oracle, and I've built small databases before using Access. Where does this program fit into all of that? And what do I use and how can I get started with this program?
Hi there,
What you've probably installed is only the database engine and probably the command line utilities. You could connect and work with your databases via the command line but it's easier doing it via a GUI. Couple of options:
A) You can download SQL Server Management Studio Express Edition here:
http://msdn.microsoft.com/vstudio/express/sql/download/
This'll give you a GUI where you can connect to the database server (which you have installed already) and you can work with and create databases in it.
B) It is also possible to create and work with your database using Visual Basic Express Edition. Generally you'll create a project first (e.g. a Windows Application) and then you'd create a database for your project. The steps are:

1) In the Solution Explorer right click on the name of the solution and select Add > New Item from the menu that appears
2) The "Add New Item" window will appear. In this window select the "SQL Database" template. Change the name of the database's .mdf file to whatever you prefer.
Click "Next>" after doing the above
3) Select whatever database objects you want in your dataset (I select everything that's available but it does depend on what you want). Click the "Finish" button
After doing all of this a database local to the project you are working with will be created. If you open up Database Explorer (View Menu > Database Explorer or View Menu > Other Windows > Database Explorer) you should see you database. You can then do things like create tables for your DB and make an application that connects to your database and does, well, stuff (sorry).

As for learning more about it, try reading some stuff at:
http://www.microsoft.com/sql/editions/express/default.mspx
http://msdn.microsoft.com/sql/express/
They should give you some overview of the product. The Developer Center (2nd link) might give you some ideas to get started in coding database apps with VB Express Edition.
There's also a white paper that might help get you going with Management Studio Express at:
http://download.microsoft.com/download/4/f/8/4f8f2dc9-a9a7-4b68-98cb-163482c95e0b/MgSQLExpwSSMSE.doc
Hope that helps a bit, but sorry if it doesn't

About sql server administration tools

Hi Guys,
I am planning to buy some tools that facilitate my admin of my sql server
live database. Now I don't any tools to use. I just want to inquiry that is
there any tools I can buy to facilitate my admin of sql server, such as
minitor tools, backup tools, performance tunning tools, so on. Thanks.Iter
http://sqlblog.com/blogs/rhundhause...bs.a
spx
"Iter" <Iter@.discussions.microsoft.com> wrote in message
news:EA1E5BBC-F9DA-44E9-9BC2-2BE6E11B23C7@.microsoft.com...
> Hi Guys,
> I am planning to buy some tools that facilitate my admin of my sql server
> live database. Now I don't any tools to use. I just want to inquiry that
> is
> there any tools I can buy to facilitate my admin of sql server, such as
> minitor tools, backup tools, performance tunning tools, so on. Thanks.
>|||Hi
Check these sites
http://www.apexsql.com/
http://www.idera.com/
regards
VT
Knowledge is power, share it...
http://oneplace4sql.blogspot.com/
"Iter" <Iter@.discussions.microsoft.com> wrote in message
news:EA1E5BBC-F9DA-44E9-9BC2-2BE6E11B23C7@.microsoft.com...
> Hi Guys,
> I am planning to buy some tools that facilitate my admin of my sql server
> live database. Now I don't any tools to use. I just want to inquiry that
> is
> there any tools I can buy to facilitate my admin of sql server, such as
> minitor tools, backup tools, performance tunning tools, so on. Thanks.
>|||I really like a few of Red-Gate's tools. I couldn't live without SQL
Compare and SQL Backup has been very useful.
http://www.red-gate.com/
For deployment I rely heavily on SQL Farms Combine:
http://www.sqlfarms.com/
Aaron Bertrand
SQL Server MVP
http://www.sqlblog.com/
http://www.aspfaq.com/5006
"Iter" <Iter@.discussions.microsoft.com> wrote in message
news:EA1E5BBC-F9DA-44E9-9BC2-2BE6E11B23C7@.microsoft.com...
> Hi Guys,
> I am planning to buy some tools that facilitate my admin of my sql server
> live database. Now I don't any tools to use. I just want to inquiry that
> is
> there any tools I can buy to facilitate my admin of sql server, such as
> minitor tools, backup tools, performance tunning tools, so on. Thanks.
>|||As already mentioned, there are a number of tools that can do the job.
That being said, you should maybe evaluate what you need is before you
go out and buy a tool. SQL Servers own Enterprise Manager/SQL Server
Management Studio, can actually do the job very well for most
administrative purposes. You should also keep in mind that the tools you
can buy, in many cases can't do much more than what you can do your self
with Managent Studio and some SQL scripting knowledge - the tools just
make it a little bit more "userfriendly".
It's my personal feeling that if you only have a few SQL Servers to look
after, you might not really need a 3rd. party tool for the admin. If you
have many servers to look after, some of the tools might be better to
give you this "over-all" view of the whole SQL server farm.
I've over the years never really felt the need to use a 3rd. party tool
for administration, but have been quite happy with Enterprise Manager /
Query analyser / SQL Server Management studio. I've then written various
scripts over time to do some specific task that I needed - and the
benefit of that is that I've learned a lot more about how SQL server
does things "behind the scenes".
Regards
Steen Schlüter Persson
Database Administrator / System Administrator
Iter wrote:
> Hi Guys,
> I am planning to buy some tools that facilitate my admin of my sql server
> live database. Now I don't any tools to use. I just want to inquiry that i
s
> there any tools I can buy to facilitate my admin of sql server, such as
> minitor tools, backup tools, performance tunning tools, so on. Thanks.
>

About sql server administration tools

Hi Guys,
I am planning to buy some tools that facilitate my admin of my sql server
live database. Now I don't any tools to use. I just want to inquiry that is
there any tools I can buy to facilitate my admin of sql server, such as
minitor tools, backup tools, performance tunning tools, so on. Thanks.
Iter
http://sqlblog.com/blogs/rhundhausen/archive/2007/06/18/cool-dba-automation-jobs.aspx
"Iter" <Iter@.discussions.microsoft.com> wrote in message
news:EA1E5BBC-F9DA-44E9-9BC2-2BE6E11B23C7@.microsoft.com...
> Hi Guys,
> I am planning to buy some tools that facilitate my admin of my sql server
> live database. Now I don't any tools to use. I just want to inquiry that
> is
> there any tools I can buy to facilitate my admin of sql server, such as
> minitor tools, backup tools, performance tunning tools, so on. Thanks.
>
|||I really like a few of Red-Gate's tools. I couldn't live without SQL
Compare and SQL Backup has been very useful.
http://www.red-gate.com/
For deployment I rely heavily on SQL Farms Combine:
http://www.sqlfarms.com/
Aaron Bertrand
SQL Server MVP
http://www.sqlblog.com/
http://www.aspfaq.com/5006
"Iter" <Iter@.discussions.microsoft.com> wrote in message
news:EA1E5BBC-F9DA-44E9-9BC2-2BE6E11B23C7@.microsoft.com...
> Hi Guys,
> I am planning to buy some tools that facilitate my admin of my sql server
> live database. Now I don't any tools to use. I just want to inquiry that
> is
> there any tools I can buy to facilitate my admin of sql server, such as
> minitor tools, backup tools, performance tunning tools, so on. Thanks.
>
|||As already mentioned, there are a number of tools that can do the job.
That being said, you should maybe evaluate what you need is before you
go out and buy a tool. SQL Servers own Enterprise Manager/SQL Server
Management Studio, can actually do the job very well for most
administrative purposes. You should also keep in mind that the tools you
can buy, in many cases can't do much more than what you can do your self
with Managent Studio and some SQL scripting knowledge - the tools just
make it a little bit more "userfriendly".
It's my personal feeling that if you only have a few SQL Servers to look
after, you might not really need a 3rd. party tool for the admin. If you
have many servers to look after, some of the tools might be better to
give you this "over-all" view of the whole SQL server farm.
I've over the years never really felt the need to use a 3rd. party tool
for administration, but have been quite happy with Enterprise Manager /
Query analyser / SQL Server Management studio. I've then written various
scripts over time to do some specific task that I needed - and the
benefit of that is that I've learned a lot more about how SQL server
does things "behind the scenes".
Regards
Steen Schlüter Persson
Database Administrator / System Administrator
Iter wrote:
> Hi Guys,
> I am planning to buy some tools that facilitate my admin of my sql server
> live database. Now I don't any tools to use. I just want to inquiry that is
> there any tools I can buy to facilitate my admin of sql server, such as
> minitor tools, backup tools, performance tunning tools, so on. Thanks.
>

About sql server administration tools

Hi Guys,
I am planning to buy some tools that facilitate my admin of my sql server
live database. Now I don't any tools to use. I just want to inquiry that is
there any tools I can buy to facilitate my admin of sql server, such as
minitor tools, backup tools, performance tunning tools, so on. Thanks.Iter
http://sqlblog.com/blogs/rhundhausen/archive/2007/06/18/cool-dba-automation-jobs.aspx
"Iter" <Iter@.discussions.microsoft.com> wrote in message
news:EA1E5BBC-F9DA-44E9-9BC2-2BE6E11B23C7@.microsoft.com...
> Hi Guys,
> I am planning to buy some tools that facilitate my admin of my sql server
> live database. Now I don't any tools to use. I just want to inquiry that
> is
> there any tools I can buy to facilitate my admin of sql server, such as
> minitor tools, backup tools, performance tunning tools, so on. Thanks.
>|||Hi
Check these sites
http://www.apexsql.com/
http://www.idera.com/
regards
VT
Knowledge is power, share it...
http://oneplace4sql.blogspot.com/
"Iter" <Iter@.discussions.microsoft.com> wrote in message
news:EA1E5BBC-F9DA-44E9-9BC2-2BE6E11B23C7@.microsoft.com...
> Hi Guys,
> I am planning to buy some tools that facilitate my admin of my sql server
> live database. Now I don't any tools to use. I just want to inquiry that
> is
> there any tools I can buy to facilitate my admin of sql server, such as
> minitor tools, backup tools, performance tunning tools, so on. Thanks.
>|||I really like a few of Red-Gate's tools. I couldn't live without SQL
Compare and SQL Backup has been very useful.
http://www.red-gate.com/
For deployment I rely heavily on SQL Farms Combine:
http://www.sqlfarms.com/
--
Aaron Bertrand
SQL Server MVP
http://www.sqlblog.com/
http://www.aspfaq.com/5006
"Iter" <Iter@.discussions.microsoft.com> wrote in message
news:EA1E5BBC-F9DA-44E9-9BC2-2BE6E11B23C7@.microsoft.com...
> Hi Guys,
> I am planning to buy some tools that facilitate my admin of my sql server
> live database. Now I don't any tools to use. I just want to inquiry that
> is
> there any tools I can buy to facilitate my admin of sql server, such as
> minitor tools, backup tools, performance tunning tools, so on. Thanks.
>|||As already mentioned, there are a number of tools that can do the job.
That being said, you should maybe evaluate what you need is before you
go out and buy a tool. SQL Servers own Enterprise Manager/SQL Server
Management Studio, can actually do the job very well for most
administrative purposes. You should also keep in mind that the tools you
can buy, in many cases can't do much more than what you can do your self
with Managent Studio and some SQL scripting knowledge - the tools just
make it a little bit more "userfriendly".
It's my personal feeling that if you only have a few SQL Servers to look
after, you might not really need a 3rd. party tool for the admin. If you
have many servers to look after, some of the tools might be better to
give you this "over-all" view of the whole SQL server farm.
I've over the years never really felt the need to use a 3rd. party tool
for administration, but have been quite happy with Enterprise Manager /
Query analyser / SQL Server Management studio. I've then written various
scripts over time to do some specific task that I needed - and the
benefit of that is that I've learned a lot more about how SQL server
does things "behind the scenes".
--
Regards
Steen Schlüter Persson
Database Administrator / System Administrator
Iter wrote:
> Hi Guys,
> I am planning to buy some tools that facilitate my admin of my sql server
> live database. Now I don't any tools to use. I just want to inquiry that is
> there any tools I can buy to facilitate my admin of sql server, such as
> minitor tools, backup tools, performance tunning tools, so on. Thanks.
>

about setup

Just appear 'configuration tools' and 'documentation and tutorials' after installed katmai June CTP

OS: WinXP sp2

any idea about this? many thanks

resetup failed,error code is :-2147467259 Message:Unspecified error
Log shown below:
MSI (s) (CC:04) [21:03:16:062]: Note: 1: 1708
MSI (s) (CC:04) [21:03:16:062]: Product: Microsoft SQL Server "Katmai" Tools -- Installation failed.

MSI (s) (CC:04) [21:03:16:093]: Cleaning up uninstalled install packages, if any exist
MSI (s) (CC:04) [21:03:16:093]: MainEngineThread is returning 1603
MSI (s) (CC:24) [21:03:16:203]: Destroying RemoteAPI object.
MSI (s) (CC:70) [21:03:16:203]: Custom Action Manager thread ending.
=== Logging stopped: 6/27/2007 21:03:16 ===
MSI (c) (AC:1C) [21:03:16:234]: Decrementing counter to disable shutdown. If counter >= 0, shutdown will be denied. Counter after decrement: -1
MSI (c) (AC:1C) [21:03:16:234]: MainEngineThread is returning 1603
=== Verbose logging stopped: 6/27/2007 21:03:16 ===

Also, I already uninstalled workstation component of 2005

What's this matter? thanks

|||Well, I think the solution was came from mverun
My VS8 was installed in non-default folder