Downloading sample databases

I am trying to download the sample databases for SQL Server 2005 and SQL
Server 2008.
As I often find to be the case, http://www.codeplex.com is not available. I
have reported this on the codeplex forums in the past. It does not appear
that there has ever been an improvement in the availability of this site.
When I need something from that site, it seems to be unavailable more than it
is available.
Here is the result of running tracert on the site, showing that the problem
is internal within Microsoft's own network:
P:\>tracert www.codeplex.com
Tracing route to www.codeplex.com [207.46.208.126]
over a maximum of 30 hops:
1 <1 ms 1 ms <1 ms myrouter-name is company
confidential[xxx.xxx.xxx.xxx]
2 <1 ms <1 ms <1 ms myfirewall-name is company
confidential[xxx.xxx.xxx.xxx]
3 1 ms <1 ms 1 ms myrouter-name is company
confidential[xxx.xxx.xxx.xxx]
4 10 ms 10 ms 9 ms POS1-3.GW6.DFW9.ALTER.NET [xxx.xxx.xxx.xxx]
5 12 ms 11 ms 11 ms 158.at-5-0-0.XR1.DFW9.ALTER.NET
[xxx.xxx.xxx.xxx]
6 13 ms 11 ms 9 ms 0.so-2-1-0.XT3.DFW9.ALTER.NET [152.63.101.249]
7 75 ms 75 ms 76 ms 0.so-7-0-0.XL1.SEA4.ALTER.NET [152.63.104.194]
8 76 ms 75 ms 75 ms 0.so-6-0-0.GW1.SEA4.ALTER.NET [152.63.107.249]
9 76 ms 75 ms 76 ms msft-oc48.customer.alter.net [157.130.177.254]
10 77 ms 78 ms 76 ms ge-5-2-0-54.tuk-64cb-1a.ntwk.msn.net
[207.46.45.
69]
11 * * * Request timed out.
12 * 79 ms 76 ms po1.tuk-6ns-mcs-2a.ntwk.msn.net [207.46.39.33]
13 * * * Request timed out.
14 * po1.tuk-6ns-mcs-2b.ntwk.msn.net [207.46.39.45] reports:
Destinati
on net unreachable.
Trace complete.
Firstly, I would like to suggest/request that the important developer
downloads that have been moved to codeplex.com, such as enterprise library
and sql server sample databases, be made available in the MSDN subscriber
downloads.
Secondly, and more important right now, is that I need those downloads and
the site is not available. I am trying to understand some code from MSDN and
BOL that uses the sample databases. Before I can understand that code so
that I can use the information from BOL in the task I am working on today, I
need to have the sample databases for SQL Server 2005 for certain and,
hopefully, SQL Server 2008. As a MSDN subscriber, please tell me where I can
get those downloads other than the unavailable codeplex.com site.
Thanks,
Dale
Thank you for your uresponse, Gail. I did finally get the samples
downloaded. I attached them to my developer version of SQL Server 2005 by
copying the mdf and ldf files from the default installation in Express
Edition.
*Big sigh of relief*... That was two hours waisted. It probably would not
have been so frustrating if the issues with CodePlex availability didn't
happen so often.
Thanks again for your quick response.
Dale
"Gail Erickson [MS]" wrote:

> Hi Dale,
> I've forwarded your post to the samples team so that they are aware of your
> on-going problem with Codeplex. I notice that you provided similar feedback
> on the Sample Databases page in Codeplex
> (http://www.codeplex.com/MSFTDBProdSamples) today. I assume that means you
> were finally able to download the sample databases. If that's not the case,
> let me know.
> If you have a version of SQL Server 2005 other than the Express or Compact
> editions, you can install the sample databases by re-running setup.See the
> section "Installation After Setup" in the BOL topic "Running Setup to
> Install AdventureWorks Sample Databases and Samples". Cut/paste this URL
> to get to that topic:
> ms-help://sql90/instsql9/html/8c4c2af8-f2ed-4559-b5d2-984a9f7ce5ca.htm
> Right now there is no significant difference between AdventureWorks for 2005
> and AdventureWorks for 2008, so you should be able to use the database for
> either versions of SQL Server.
> --
> Gail Erickson [MS]
> SQL Server Documentation Team
> This posting is provided "AS IS" with no warranties, and confers no rights
> Download the latest version of Books Online from
> http://technet.microsoft.com/en-us/sqlserver/bb428874.aspx
> "Dale" <dale0973@.nospam.nospam> wrote in message
> news:83FEED8D-9360-4CF8-BEFC-4AC632E5B077@.microsoft.com...
>
>
sql

Downloading File located in SQL Server with ASP

I have a SQL 2000 Standard server setup and I have a table in one of my
databases to store files in. I am using asp code to retrieve the files from
the database. I can download txt, bmp files just fine but when it comes to
pdf documents it just hangs at the downloading the file screen and then gives
me a timeout error after awhile. It is not a problem with the file sizes. I
am testing it with a 20 and 60k pdf files and one of the txt files I used to
test with is a few mb. I am thinking it's either an IIS server config issue
or SQL Server config problem. The IIS server is for our intranet and is not
locked down. Both IIS and SQL are running on the same box which is a Windows
2003 Enterprise server. Any help would be great.
Thanks,
Brett Bishop
MCSE, MCP+I
US Bankruptcy Court"fibreiv" <fibreiv@.discussions.microsoft.com> wrote in message
news:0880684A-A141-4D78-842A-041C501DBCF5@.microsoft.com...
> I have a SQL 2000 Standard server setup and I have a table in one of my
> databases to store files in. I am using asp code to retrieve the files
from
> the database. I can download txt, bmp files just fine but when it comes
to
> pdf documents it just hangs at the downloading the file screen and then
gives
> me a timeout error after awhile. It is not a problem with the file sizes.
I
> am testing it with a 20 and 60k pdf files and one of the txt files I used
to
> test with is a few mb. I am thinking it's either an IIS server config
issue
> or SQL Server config problem. The IIS server is for our intranet and is
not
> locked down. Both IIS and SQL are running on the same box which is a
Windows
> 2003 Enterprise server. Any help would be great.
Can you access PDF files via URL from the file system?|||fibreiv wrote:
> I have a SQL 2000 Standard server setup and I have a table in one of my
> databases to store files in. I am using asp code to retrieve the files from
> the database. I can download txt, bmp files just fine but when it comes to
> pdf documents it just hangs at the downloading the file screen and then gives
> me a timeout error after awhile. It is not a problem with the file sizes. I
> am testing it with a 20 and 60k pdf files and one of the txt files I used to
> test with is a few mb. I am thinking it's either an IIS server config issue
> or SQL Server config problem. The IIS server is for our intranet and is not
> locked down. Both IIS and SQL are running on the same box which is a Windows
> 2003 Enterprise server. Any help would be great.
Perhaps it has to do with the content type when the file is being sent
down. You may also want to set the content-disposition to indicate to
download the file, "Content-Disposition: Attachment" in the response header.
You aren't saying if you are trying to open up the file directly or save
it to disk first.
--
Aaron Weiker
http://aaronweiker.com/
http://www.sqlprogrammer.org/|||Hi,
This is what i would do.
Try to download a PDF file from the file system (this rules out a problem
with IIS serving PDF-files).
Use WFetch[1] to request the PDF page (from the db), and see if IIS gives
a complete reply back (this will rule out a client-side problem).
Usually these kind of problems are caused by the programmers code. SQL
Server only stores the data, and IIS only "gives" the client the data.
Your code however do everything in between, and that is where it usually
goes wrong.
--
Regards,
Kristofer Gafvert
www.gafvert.info - My Articles and help
www.ilopia.com
fibreiv wrote:
> I have a SQL 2000 Standard server setup and I have a table in one of my
> databases to store files in. I am using asp code to retrieve the files
from
> the database. I can download txt, bmp files just fine but when it comes
to
> pdf documents it just hangs at the downloading the file screen and then
gives
> me a timeout error after awhile. It is not a problem with the file
sizes. I
> am testing it with a 20 and 60k pdf files and one of the txt files I
used to
> test with is a few mb. I am thinking it's either an IIS server config
issue
> or SQL Server config problem. The IIS server is for our intranet and is
not
> locked down. Both IIS and SQL are running on the same box which is a
Windows
> 2003 Enterprise server. Any help would be great.
> Thanks,
> Brett Bishop
> MCSE, MCP+I
> US Bankruptcy Court|||I have the Content type set to application/pdf and I can't open it or save
it. Just to clarify the data is stored in SQL Image field.
"Aaron Weiker" wrote:
> fibreiv wrote:
> > I have a SQL 2000 Standard server setup and I have a table in one of my
> > databases to store files in. I am using asp code to retrieve the files from
> > the database. I can download txt, bmp files just fine but when it comes to
> > pdf documents it just hangs at the downloading the file screen and then gives
> > me a timeout error after awhile. It is not a problem with the file sizes. I
> > am testing it with a 20 and 60k pdf files and one of the txt files I used to
> > test with is a few mb. I am thinking it's either an IIS server config issue
> > or SQL Server config problem. The IIS server is for our intranet and is not
> > locked down. Both IIS and SQL are running on the same box which is a Windows
> > 2003 Enterprise server. Any help would be great.
> Perhaps it has to do with the content type when the file is being sent
> down. You may also want to set the content-disposition to indicate to
> download the file, "Content-Disposition: Attachment" in the response header.
> You aren't saying if you are trying to open up the file directly or save
> it to disk first.
> --
> Aaron Weiker
> http://aaronweiker.com/
> http://www.sqlprogrammer.org/
>|||The file is stored in the Database in an Image field so there is no file
system access to the file.
"Tom Kaminski [MVP]" wrote:
> "fibreiv" <fibreiv@.discussions.microsoft.com> wrote in message
> news:0880684A-A141-4D78-842A-041C501DBCF5@.microsoft.com...
> > I have a SQL 2000 Standard server setup and I have a table in one of my
> > databases to store files in. I am using asp code to retrieve the files
> from
> > the database. I can download txt, bmp files just fine but when it comes
> to
> > pdf documents it just hangs at the downloading the file screen and then
> gives
> > me a timeout error after awhile. It is not a problem with the file sizes.
> I
> > am testing it with a 20 and 60k pdf files and one of the txt files I used
> to
> > test with is a few mb. I am thinking it's either an IIS server config
> issue
> > or SQL Server config problem. The IIS server is for our intranet and is
> not
> > locked down. Both IIS and SQL are running on the same box which is a
> Windows
> > 2003 Enterprise server. Any help would be great.
> Can you access PDF files via URL from the file system?
>
>|||"fibreiv" <fibreiv@.discussions.microsoft.com> wrote in message
news:9BEC1745-770E-47BF-8749-06E8EBB48601@.microsoft.com...
> The file is stored in the Database in an Image field so there is no file
> system access to the file.
Understood.
As part of the troubleshooting routine, I'm asking if you can access one
from the file system.|||I copied the same file thats in the database to the folder I have all the asp
files in on my server and put the url right to the pdf document and it opened
up acrobat and opened the file.
"Tom Kaminski [MVP]" wrote:
> "fibreiv" <fibreiv@.discussions.microsoft.com> wrote in message
> news:9BEC1745-770E-47BF-8749-06E8EBB48601@.microsoft.com...
> > The file is stored in the Database in an Image field so there is no file
> > system access to the file.
> Understood.
> As part of the troubleshooting routine, I'm asking if you can access one
> from the file system.
>
>|||fibreiv wrote:
> I have the Content type set to application/pdf and I can't open it or save
> it. Just to clarify the data is stored in SQL Image field.
> "Aaron Weiker" wrote:
>>Perhaps it has to do with the content type when the file is being sent
>>down. You may also want to set the content-disposition to indicate to
>>download the file, "Content-Disposition: Attachment" in the response header.
Are you setting "Content-Disposition" at all in the header?
--
Aaron Weiker
http://aaronweiker.com/
http://www.sqlprogrammer.org/|||"fibreiv" <fibreiv@.discussions.microsoft.com> wrote in message
news:AED1E8B2-C2EE-4E02-9A38-BA527F0C6B2B@.microsoft.com...
> I copied the same file thats in the database to the folder I have all the
asp
> files in on my server and put the url right to the pdf document and it
opened
> up acrobat and opened the file.
OK - at this point, we'll need to see code to get an idea of how you're
doing it. In that case, I would suggest adding the ASP newsgroup as well
...|||Here is what I am doing to test it. I have hardcoded the file I want to get
out of the database.
Connect = "Provider=SQLOLEDB.1;Persist Security Info=False;User
ID=sa;Password=;Initial Catalog=INNB;Data Source=pompom"
Set db = Server.CreateObject("ADODB.Connection")
db.Open Connect
SQL = "SELECT filesize, contenttype, filename, filedata FROM thefiles where
id = 2"
Set rs = db.Execute( SQL )
If rs.EOF Then Response.End
Response.ContentType = "application/pdf"
Response.AddHeader "Content-Disposition", "attachment;filename=agencies.pdf"
Response.AddHeader "Content-Length", "16863"
Response.BinaryWrite rs("filedata")
"Aaron Weiker" wrote:
> fibreiv wrote:
> > I have the Content type set to application/pdf and I can't open it or save
> > it. Just to clarify the data is stored in SQL Image field.
> >
> > "Aaron Weiker" wrote:
> >>Perhaps it has to do with the content type when the file is being sent
> >>down. You may also want to set the content-disposition to indicate to
> >>download the file, "Content-Disposition: Attachment" in the response header.
> Are you setting "Content-Disposition" at all in the header?
> --
> Aaron Weiker
> http://aaronweiker.com/
> http://www.sqlprogrammer.org/
>|||fibreiv wrote:
> Connect = "Provider=SQLOLEDB.1;Persist Security Info=False;User
> ID=sa;Password=;Initial Catalog=INNB;Data Source=pompom"
> Set db = Server.CreateObject("ADODB.Connection")
> db.Open Connect
> SQL = "SELECT filesize, contenttype, filename, filedata FROM thefiles where
> id = 2"
> Set rs = db.Execute( SQL )
> If rs.EOF Then Response.End
> Response.ContentType = "application/pdf"
> Response.AddHeader "Content-Disposition", "attachment;filename=agencies.pdf"
> Response.AddHeader "Content-Length", "16863"
> Response.BinaryWrite rs("filedata")
Have you tried putting Response.End at the end? Someone else may be able
to help identify a missing piece as it's been a long time since I did this.
--
Aaron Weiker
http://aaronweiker.com/
http://www.sqlprogrammer.org/

download source? - Mike Wachal - developing apps w/embedded databases

Hello,

I watched the ondemand video and I am still looking for the source that is referred to. I, of course, would like to download it and work with it.

Please post where I can find it.

Thanks.

Thanks for watching the webcast!

I'm a bad webcast host and I haven't posted the source yet. When I post it, it will be available on the SQL Express Blog and I'll post a notice in this forum that it's there. Sorry to be so lame, I'll get to this next week at the latest.

Regards,

Mike Wachal
SQL Express team

-
Mark the best posts as Answers!

Downgrading from Enterprise to Standard

Hi
Does anyone know how to go from SQL Server 2000 Enterprise to Standard and restore all of the databases? I've tried restoring the Mater Database, but I am getting the following
The backup of the system database on device XXXX cannot be restored because it was created by a different version of the server (134217546) than this server (134217488)
KB article 264474 shows how to get a server back to the version level, if the flavor of SQL Server is the same [i.e. Enterprise] but not if the server is being downgraded from Enterprise to Standard for licensing reasons
Thanks
ChrisChris,
This appears to be backup / restore that is the problem.
You should be able to detach the databases from the SS2KEE server and then
attach them to the SS2KSt server. Check this article (from the BOL) on
Attaching and Detaching Databases. The file formats are the same.
http://msdn.microsoft.com/library/default.asp?
url=/library/en-us/createdb/cm_8_des_03_89pv.asp
Russell Fields
"Chris Smith" <chriss@.resultmatrix.com> wrote in message
news:D8C2FF80-CA31-495C-9B6D-2F4D9172FA84@.microsoft.com...
> Hi,
> Does anyone know how to go from SQL Server 2000 Enterprise to Standard and
restore all of the databases? I've tried restoring the Mater Database, but
I am getting the following:
> The backup of the system database on device XXXX cannot be restored
because it was created by a different version of the server (134217546) than
this server (134217488).
> KB article 264474 shows how to get a server back to the version level, if
the flavor of SQL Server is the same [i.e. Enterprise] but not if the
server is being downgraded from Enterprise to Standard for licensing
reasons.
> Thanks,
> Chris|||I would double check that you really have the same service pack/hotfix level. This is what the error
implies.
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"Chris Smith" <chriss@.resultmatrix.com> wrote in message
news:D8C2FF80-CA31-495C-9B6D-2F4D9172FA84@.microsoft.com...
> Hi,
> Does anyone know how to go from SQL Server 2000 Enterprise to Standard and restore all of the
databases? I've tried restoring the Mater Database, but I am getting the following:
> The backup of the system database on device XXXX cannot be restored because it was created by a
different version of the server (134217546) than this server (134217488).
> KB article 264474 shows how to get a server back to the version level, if the flavor of SQL Server
is the same [i.e. Enterprise] but not if the server is being downgraded from Enterprise to Standard
for licensing reasons.
> Thanks,
> Chris

Downgarde from SQL 2000 to SQL 7

HI i need to downgrade one of my databases to SQL 7..but ti doesnt allow me to not a backup restore or a script import works.
please can any one help.or is there some tool that does this fot you
Hi,
DTS will be the easiest way to transfer the data from SQL 2000 to SQL 7.
For other objects, generate the SQL script and execute in SQL 7.
Thanks
Hari
MCDBA
"Emil" <emil@.mint.co.za> wrote in message
news:25998566-E751-4E34-9530-9F05532F0B53@.microsoft.com...
> HI i need to downgrade one of my databases to SQL 7..but ti doesnt allow
me to not a backup restore or a script import works.
> please can any one help.or is there some tool that does this fot you

Downgarde from SQL 2000 to SQL 7

HI i need to downgrade one of my databases to SQL 7..but ti doesnt allow me
to not a backup restore or a script import works.
please can any one help.or is there some tool that does this fot youHi,
DTS will be the easiest way to transfer the data from SQL 2000 to SQL 7.
For other objects, generate the SQL script and execute in SQL 7.
Thanks
Hari
MCDBA
"Emil" <emil@.mint.co.za> wrote in message
news:25998566-E751-4E34-9530-9F05532F0B53@.microsoft.com...
> HI i need to downgrade one of my databases to SQL 7..but ti doesnt allow
me to not a backup restore or a script import works.
> please can any one help.or is there some tool that does this fot you

Downgarde from SQL 2000 to SQL 7

HI i need to downgrade one of my databases to SQL 7..but ti doesnt allow me to not a backup restore or a script import works
please can any one help.or is there some tool that does this fot youHi,
DTS will be the easiest way to transfer the data from SQL 2000 to SQL 7.
For other objects, generate the SQL script and execute in SQL 7.
Thanks
Hari
MCDBA
"Emil" <emil@.mint.co.za> wrote in message
news:25998566-E751-4E34-9530-9F05532F0B53@.microsoft.com...
> HI i need to downgrade one of my databases to SQL 7..but ti doesnt allow
me to not a backup restore or a script import works.
> please can any one help.or is there some tool that does this fot yousql

Doubts about sp_spaceused

Hello, All!
I'm making a maintenance in my DataBases and I have doubts about somethings.
Could you help me?
One of my DataBases, the DataFile has 1,8GB and the LOG File has 400MB. I
executed Shrink DataBase and my DataBases fell down to 700MB.
But, When I execute the Stored Procedure sp_spaceused, it comes for
unallocated space -1050MB.
What's mean?
What I need to do to revert it? The other information when I run sp_spaceused
is:
DataBase
BDSeg_Bosch
DataBase size: 700MB
Unallocated space: -1050MB
reserved: 1691176 KB
data: 225336 KB
index_size: 1442216 KB
unused: 23624 KB
Thanks
Juliano Horta
Message posted via droptable.com
http://www.droptable.com/Uwe/Forums...erver/200603/1
Run:
DBCC UPDATEUSAGE (0)
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinpub.com
..
"julianohorta via droptable.com" <u13014@.uwe> wrote in message
news:5dfad6bddc673@.uwe...
Hello, All!
I'm making a maintenance in my DataBases and I have doubts about somethings.
Could you help me?
One of my DataBases, the DataFile has 1,8GB and the LOG File has 400MB. I
executed Shrink DataBase and my DataBases fell down to 700MB.
But, When I execute the Stored Procedure sp_spaceused, it comes for
unallocated space -1050MB.
What's mean?
What I need to do to revert it? The other information when I run
sp_spaceused
is:
DataBase
BDSeg_Bosch
DataBase size: 700MB
Unallocated space: -1050MB
reserved: 1691176 KB
data: 225336 KB
index_size: 1442216 KB
unused: 23624 KB
Thanks
Juliano Horta
Message posted via droptable.com
http://www.droptable.com/Uwe/Forums...erver/200603/1
|||Did you run DBCC UPDATEUSAGE command before running sp_spaceused?
"julianohorta via droptable.com" <u13014@.uwe> wrote in message
news:5dfad6bddc673@.uwe...
> Hello, All!
> I'm making a maintenance in my DataBases and I have doubts about
> somethings.
> Could you help me?
> One of my DataBases, the DataFile has 1,8GB and the LOG File has 400MB. I
> executed Shrink DataBase and my DataBases fell down to 700MB.
> But, When I execute the Stored Procedure sp_spaceused, it comes for
> unallocated space -1050MB.
> What's mean?
> What I need to do to revert it? The other information when I run
> sp_spaceused
> is:
> DataBase
> BDSeg_Bosch
> DataBase size: 700MB
> Unallocated space: -1050MB
> reserved: 1691176 KB
> data: 225336 KB
> index_size: 1442216 KB
> unused: 23624 KB
> Thanks
> Juliano Horta
> --
> Message posted via droptable.com
> http://www.droptable.com/Uwe/Forums...erver/200603/1

Doubts about sp_spaceused

Hello, All!
I'm making a maintenance in my DataBases and I have doubts about somethings.
Could you help me?
One of my DataBases, the DataFile has 1,8GB and the LOG File has 400MB. I
executed Shrink DataBase and my DataBases fell down to 700MB.
But, When I execute the Stored Procedure sp_spaceused, it comes for
unallocated space -1050MB.
What's mean?
What I need to do to revert it? The other information when I run sp_spaceused
is:
DataBase
BDSeg_Bosch
DataBase size: 700MB
Unallocated space: -1050MB
reserved: 1691176 KB
data: 225336 KB
index_size: 1442216 KB
unused: 23624 KB
Thanks
Juliano Horta
--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server/200603/1Run:
DBCC UPDATEUSAGE (0)
--
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinpub.com
.
"julianohorta via SQLMonster.com" <u13014@.uwe> wrote in message
news:5dfad6bddc673@.uwe...
Hello, All!
I'm making a maintenance in my DataBases and I have doubts about somethings.
Could you help me?
One of my DataBases, the DataFile has 1,8GB and the LOG File has 400MB. I
executed Shrink DataBase and my DataBases fell down to 700MB.
But, When I execute the Stored Procedure sp_spaceused, it comes for
unallocated space -1050MB.
What's mean?
What I need to do to revert it? The other information when I run
sp_spaceused
is:
DataBase
BDSeg_Bosch
DataBase size: 700MB
Unallocated space: -1050MB
reserved: 1691176 KB
data: 225336 KB
index_size: 1442216 KB
unused: 23624 KB
Thanks
Juliano Horta
--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server/200603/1|||Did you run DBCC UPDATEUSAGE command before running sp_spaceused?
"julianohorta via SQLMonster.com" <u13014@.uwe> wrote in message
news:5dfad6bddc673@.uwe...
> Hello, All!
> I'm making a maintenance in my DataBases and I have doubts about
> somethings.
> Could you help me?
> One of my DataBases, the DataFile has 1,8GB and the LOG File has 400MB. I
> executed Shrink DataBase and my DataBases fell down to 700MB.
> But, When I execute the Stored Procedure sp_spaceused, it comes for
> unallocated space -1050MB.
> What's mean?
> What I need to do to revert it? The other information when I run
> sp_spaceused
> is:
> DataBase
> BDSeg_Bosch
> DataBase size: 700MB
> Unallocated space: -1050MB
> reserved: 1691176 KB
> data: 225336 KB
> index_size: 1442216 KB
> unused: 23624 KB
> Thanks
> Juliano Horta
> --
> Message posted via SQLMonster.com
> http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server/200603/1

Doubts about sp_spaceused

Hello, All!
I'm making a maintenance in my DataBases and I have doubts about somethings.
Could you help me?
One of my DataBases, the DataFile has 1,8GB and the LOG File has 400MB. I
executed Shrink DataBase and my DataBases fell down to 700MB.
But, When I execute the Stored Procedure sp_spaceused, it comes for
unallocated space -1050MB.
What's mean?
What I need to do to revert it? The other information when I run sp_spaceuse
d
is:
DataBase
BDSeg_Bosch
DataBase size: 700MB
Unallocated space: -1050MB
reserved: 1691176 KB
data: 225336 KB
index_size: 1442216 KB
unused: 23624 KB
Thanks
Juliano Horta
Message posted via droptable.com
http://www.droptable.com/Uwe/Forum...server/200603/1Run:
DBCC UPDATEUSAGE (0)
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinpub.com
.
"julianohorta via droptable.com" <u13014@.uwe> wrote in message
news:5dfad6bddc673@.uwe...
Hello, All!
I'm making a maintenance in my DataBases and I have doubts about somethings.
Could you help me?
One of my DataBases, the DataFile has 1,8GB and the LOG File has 400MB. I
executed Shrink DataBase and my DataBases fell down to 700MB.
But, When I execute the Stored Procedure sp_spaceused, it comes for
unallocated space -1050MB.
What's mean?
What I need to do to revert it? The other information when I run
sp_spaceused
is:
DataBase
BDSeg_Bosch
DataBase size: 700MB
Unallocated space: -1050MB
reserved: 1691176 KB
data: 225336 KB
index_size: 1442216 KB
unused: 23624 KB
Thanks
Juliano Horta
Message posted via droptable.com
http://www.droptable.com/Uwe/Forum...server/200603/1|||Did you run DBCC UPDATEUSAGE command before running sp_spaceused?
"julianohorta via droptable.com" <u13014@.uwe> wrote in message
news:5dfad6bddc673@.uwe...
> Hello, All!
> I'm making a maintenance in my DataBases and I have doubts about
> somethings.
> Could you help me?
> One of my DataBases, the DataFile has 1,8GB and the LOG File has 400MB. I
> executed Shrink DataBase and my DataBases fell down to 700MB.
> But, When I execute the Stored Procedure sp_spaceused, it comes for
> unallocated space -1050MB.
> What's mean?
> What I need to do to revert it? The other information when I run
> sp_spaceused
> is:
> DataBase
> BDSeg_Bosch
> DataBase size: 700MB
> Unallocated space: -1050MB
> reserved: 1691176 KB
> data: 225336 KB
> index_size: 1442216 KB
> unused: 23624 KB
> Thanks
> Juliano Horta
> --
> Message posted via droptable.com
> http://www.droptable.com/Uwe/Forum...server/200603/1

Doubt about SQL Server

I need an application to obtain the databases names from my SQL
Server, using Visual Basic 6.0.
Can somebody hel me?(aguzmanc@.gmail.com) writes:

Quote:

Originally Posted by

I need an application to obtain the databases names from my SQL
Server, using Visual Basic 6.0.
Can somebody hel me?

SELECT name FROM master..sysdatabases -- SQL 2000 or earlier
SELECT name FROM sys.databases -- SQL 2005.

Or what is you want help with?

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx

Don't want Trusted Connection option...

Hi,

Weird question, but hey!!

We have mixed-mode authentication on one of our databases.

Is there any way of avoiding the users seeing the "Use trusted connection" option when in the connection dialog (eg from Excel Import Data)

I would like to enforce use of the Username/Password option if possible.

Otherwise, I'm faced with implementing user-level SQL Server security & Windows authentication mode for an application which has, up until now, run as the only available app in a very restricted desktop environment.

All suggestions gratefully received.

TIA


SteveYou can provide a little form and ask for UID and PWD, use them in connect string instead of doing nothing and letting system decide what to do, in this case it provides generic login dialog box.

Don't want Trusted Connection option...

Hi,
Weird question, but hey!!
We have mixed-mode authentication on one of our databases.
Is there any way of avoiding the users seeing the "Use trusted connection"
option when in the connection dialog (eg from Excel Import Data)
I would like to enforce use of the Username/Password option if possible.
Otherwise, I'm faced with implementing user-level SQL Server security &
Windows authentication mode for an application which has, up until now, run
as the only available app in a very restricted desktop environment.
All suggestions gratefully received.
TIA
SteveSteve,
First of all security level is set at server level not per database. If I
understood you correctly, you want to use SQL Authentication for one
database and keep mixed mode for all other database
To stop user connecting to database using Trusted connection.
Deny BULITIN\Administrator account
make sure no windows user has permission on that database
create sql user account in that database
create dsn to use the new user name/password and use the new dsn to connect
to sql server
VT
"CyberDwarf" <steve.ingle@.furlongsolutions.com> wrote in message
news:Ory%23$IDIHHA.4804@.TK2MSFTNGP03.phx.gbl...
> Hi,
> Weird question, but hey!!
> We have mixed-mode authentication on one of our databases.
> Is there any way of avoiding the users seeing the "Use trusted connection"
> option when in the connection dialog (eg from Excel Import Data)
> I would like to enforce use of the Username/Password option if possible.
> Otherwise, I'm faced with implementing user-level SQL Server security &
> Windows authentication mode for an application which has, up until now,
> run as the only available app in a very restricted desktop environment.
> All suggestions gratefully received.
> TIA
>
> Steve
>|||Thanks VT.
I was already working down that route, but it's nice to have my reasoning
confirmed
Steve|||You may be interested in the route we have taken...
a.. Create a project custom property to hold the (encrypted) connection
string;
b.. In VBA code, ensure that Persist Security info is turned OFF;
c.. Make sure sure that all Windows users have no rights to access SQL
Server (ie, they won't be able to use a Trusted Connection);
d.. When the ADE starts, we look up the required connection info from the
custom property, connect to SQL Server using the required access
permissions, then remove the Persist Security setting (the project loses the
password);
e.. At this point we have our required connection and no-one else can
access the backend via our ADE, unless they know the admin logon &
password).
That's basically it!
We've done basic testing & it seems to work...

Dont backup if Database hasnt changed

I do weekly full backups of my SQL databases via a scheduled T-SQL job.
I noticed that I have some static databases that dont normally change,
so I dont want to back it up if it has not changed, but when it does,
then I want a backup.
Is there something in the master table, as example, that I can check
prior to running the backup that will indicate any changes?
An example is the Northwind database. I could exclude it from the
backup, but then I would not back it up if it where to change. Again
this is an example, I would not need to modify Northwind.
Thanks in advance for any ideas; they usually give me ideas to problems
yet to come...
Rob CamardaI don't think there's a generic way to tell if a database has changed
or not (assuming that you mean when data in a user table has changed).
You could run a trace which looks for INSERT/UPDATE/DELETE statements,
log the trace in a table, and then check the contents of the table in a
custom backup job, but that doesn't seem very practical.

If your concern is to reduce disk space used for backups, you could use
differential backups for your 'static' databases, and only do the full
backup once a month, or whatever interval is appropriate. But if your
concern is to simplify administration, and given how cheap disks are
relative to a DBA's time, I would consider just adding another disk and
continuing with the same backup job for all databases.

If this isn't helpful, you might want to give some more details about
your environment, especially about how big the databases are, how often
you expect updates, and what you're trying to achieve (eg. save disk
space).

Simon|||I use SQLsafe to backup and compress my data, which in turn is saved to
my backup server. My tape is HP's Surestore 6/6000 library. I have
5540GB tapes in the library.
Monday through Saturday I perform a differential backup and a full
backup on Sunday. My plan is to keep a 1 month worth of data on the
shared disk (890GB currently, upgrading to 10 300GB raid5 next year).
Once the full backup is a month old, I move it to the library and
delete the files from the disk once the backup is successful. I wont
backup the diffs to tape and will delete the prior weeks diff backups
once the full backup is complete.
This is my current plan, it will change as I get useful input and see
how it works in practice.
My full backup of some tables are not currently large; the largest
5.3GB after compression. However, I tend to look forward, and forsee
more demand on the backup server, so why backup data that hasnt
changed? The library will be backing up 3 Linux servers, 16 windows
servers, 5 SQL and 3 Sun machines with more to come. So, I wish to
maximize the storage on the Library by keeping unnecessary data off the
library.
Again, there may not be a practical solution to my question, but often
I find I learn something unrelated that may help me with a future
problem.|||Hi

If you don't back up the database(s) then the last good backup may fall off
the tape cycle. If you chose to do this then restoring the database(s) will
you having to search more tapes for the relevant backups.

If the backups don't fit onto a single tape then you may wish to use an
autochanger (if you aren't already!). It might be possible that you could
use a server that can stage the backups on disc before putting to tape at a
different time. You may also want to consider separating database backups
from other types of backups to speed up the time needed to recover.

You may want to remove the sample databases like northwind and pubs from
your live systems, they are re-creatable from the scripts which are
downloadable if necessary.

If databases are not updated or not updated in an ad-hoc way, then you may
wish to make them read-only and use a different backup cycle for them.

John

"rcamarda" <rcamarda@.cablespeed.com> wrote in message
news:1126799621.306011.34090@.o13g2000cwo.googlegro ups.com...
>I use SQLsafe to backup and compress my data, which in turn is saved to
> my backup server. My tape is HP's Surestore 6/6000 library. I have
> 5540GB tapes in the library.
> Monday through Saturday I perform a differential backup and a full
> backup on Sunday. My plan is to keep a 1 month worth of data on the
> shared disk (890GB currently, upgrading to 10 300GB raid5 next year).
> Once the full backup is a month old, I move it to the library and
> delete the files from the disk once the backup is successful. I wont
> backup the diffs to tape and will delete the prior weeks diff backups
> once the full backup is complete.
> This is my current plan, it will change as I get useful input and see
> how it works in practice.
> My full backup of some tables are not currently large; the largest
> 5.3GB after compression. However, I tend to look forward, and forsee
> more demand on the backup server, so why backup data that hasnt
> changed? The library will be backing up 3 Linux servers, 16 windows
> servers, 5 SQL and 3 Sun machines with more to come. So, I wish to
> maximize the storage on the Library by keeping unnecessary data off the
> library.
> Again, there may not be a practical solution to my question, but often
> I find I learn something unrelated that may help me with a future
> problem.

Domino VBA

Hi,
I am trying to read data from a domino databases (located in our LAN
not on my local machine!) from my access project. I pass a code to the
function checkCodeInDomino to be verified on Domino. On my local
machine everything went fine, but suddenly there came up following
problem:

I was coding and testing with the code below, and I have never been
asked for my lotus password, now when starting my function, there comes
a box up (dont know why this changed?) where I have to enter my lotus
password, when entering my notes password, my function works fine.
But I have to distribute my application to other clients and users, and
it doesnt make sense to use my password.
So I received a public account from our domino admin, for all of us.
When using "DomSession.Initialize (publicLotusPassword)" there are no
errors.
But the problem is, that that's not a real solution for my
appliacation, because each user has to enter his own password, I dont
want that,
but entering a hard coded password doesnt work, because the password
that is asked is referring to
"c:\lotus\notes\data\wk\$userName.ID"

Is there any way to use "DomSession.Initialize" in some kind of a
"generic" way, so that any other user can use the function
"checkCodeInDomino"?
Please remember that the domino database is always on a remote machine
and
"'DomSession.InitializeUsingNotesUserName($Admin, $Pass)"
does not work!

Here is my code...

Function checkCodeInDomino(checkCode As Long)
On Error GoTo Err_Quit_Click

Dim DomDir As NotesDatabase
Dim DomContacts As NotesView
Dim DomDoc As NotesDocument
Dim StrName As String

Dim DomSession As NotesSession
Dim serverName As String
Dim databaseFile As String

Set DomSession = CreateObject("Lotus.NotesSession")
serverName = "myServerName"
databaseFile = "myFile"

DomSession.Initialize

Set DomDir = DomSession.GetDatabase(serverName, databaseFile)
Set DomContacts = DomDir.GetView("myView")
Set DomDoc = DomContacts.GetFirstDocument

While Not (DomDoc Is Nothing)

If DomDoc.GetItemValue("Dealer_Code")(0) = checkCode Then
checkCodeInDomino = True
Exit Function
End If
Set DomDoc = DomContacts.GetNextDocument(DomDoc)
Wend

checkCodeInDomino = False

Exit_Quit_Click:
Exit Function

Err_Quit_Click:
MsgBox Err.Description
Resume Exit_Quit_Click

End Function

Thank you for your attention!

Peter NeumaierI think you'll have more luck asking in a newsgroup related to Notes or
Domino, as opposed to a database group.

Have you tried looking for documentation at http://www.lotus.com?

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

"Peter Neumaier" <Peter.Neumaier@.gmail.com> wrote in message
news:1112392663.538812.206890@.g14g2000cwa.googlegr oups.com...
> Hi,
> I am trying to read data from a domino databases (located in our LAN
> not on my local machine!) from my access project. I pass a code to the
> function checkCodeInDomino to be verified on Domino. On my local
> machine everything went fine, but suddenly there came up following
> problem:
> I was coding and testing with the code below, and I have never been
> asked for my lotus password, now when starting my function, there comes
> a box up (dont know why this changed?) where I have to enter my lotus
> password, when entering my notes password, my function works fine.
> But I have to distribute my application to other clients and users, and
> it doesnt make sense to use my password.
> So I received a public account from our domino admin, for all of us.
> When using "DomSession.Initialize (publicLotusPassword)" there are no
> errors.
> But the problem is, that that's not a real solution for my
> appliacation, because each user has to enter his own password, I dont
> want that,
> but entering a hard coded password doesnt work, because the password
> that is asked is referring to
> "c:\lotus\notes\data\wk\$userName.ID"
> Is there any way to use "DomSession.Initialize" in some kind of a
> "generic" way, so that any other user can use the function
> "checkCodeInDomino"?
> Please remember that the domino database is always on a remote machine
> and
> "'DomSession.InitializeUsingNotesUserName($Admin, $Pass)"
> does not work!
> Here is my code...
> Function checkCodeInDomino(checkCode As Long)
> On Error GoTo Err_Quit_Click
> Dim DomDir As NotesDatabase
> Dim DomContacts As NotesView
> Dim DomDoc As NotesDocument
> Dim StrName As String
> Dim DomSession As NotesSession
> Dim serverName As String
> Dim databaseFile As String
> Set DomSession = CreateObject("Lotus.NotesSession")
> serverName = "myServerName"
> databaseFile = "myFile"
> DomSession.Initialize
> Set DomDir = DomSession.GetDatabase(serverName, databaseFile)
> Set DomContacts = DomDir.GetView("myView")
> Set DomDoc = DomContacts.GetFirstDocument
> While Not (DomDoc Is Nothing)
> If DomDoc.GetItemValue("Dealer_Code")(0) = checkCode Then
> checkCodeInDomino = True
> Exit Function
> End If
> Set DomDoc = DomContacts.GetNextDocument(DomDoc)
> Wend
> checkCodeInDomino = False
> Exit_Quit_Click:
> Exit Function
> Err_Quit_Click:
> MsgBox Err.Description
> Resume Exit_Quit_Click
> End Function
> Thank you for your attention!
> Peter Neumaier|||Hi Douglas,

thank you for your answer, but I think that my problem is more VBA and
ACCES than it is to domino databases.

So the only problem I have to solve is, how to use a default password
when accessing the domino database ...

For sure I found documentation on lotus.com, but there isnt anything
regarding my problem

"Douglas J. Steele" <NOSPAM_djsteele@.NOSPAM_canada.com> wrote in message news:<0cCdnUdLW-09ddDfRVn-vA@.rogers.com>...
> I think you'll have more luck asking in a newsgroup related to Notes or
> Domino, as opposed to a database group.
> Have you tried looking for documentation at http://www.lotus.com?
> --
> Doug Steele, Microsoft Access MVP
> http://I.Am/DougSteele
> (no e-mails, please!)
>
> "Peter Neumaier" <Peter.Neumaier@.gmail.com> wrote in message
> news:1112392663.538812.206890@.g14g2000cwa.googlegr oups.com...
> > Hi,
> > I am trying to read data from a domino databases (located in our LAN
> > not on my local machine!) from my access project. I pass a code to the
> > function checkCodeInDomino to be verified on Domino. On my local
> > machine everything went fine, but suddenly there came up following
> > problem:
> > I was coding and testing with the code below, and I have never been
> > asked for my lotus password, now when starting my function, there comes
> > a box up (dont know why this changed?) where I have to enter my lotus
> > password, when entering my notes password, my function works fine.
> > But I have to distribute my application to other clients and users, and
> > it doesnt make sense to use my password.
> > So I received a public account from our domino admin, for all of us.
> > When using "DomSession.Initialize (publicLotusPassword)" there are no
> > errors.
> > But the problem is, that that's not a real solution for my
> > appliacation, because each user has to enter his own password, I dont
> > want that,
> > but entering a hard coded password doesnt work, because the password
> > that is asked is referring to
> > "c:\lotus\notes\data\wk\$userName.ID"
> > Is there any way to use "DomSession.Initialize" in some kind of a
> > "generic" way, so that any other user can use the function
> > "checkCodeInDomino"?
> > Please remember that the domino database is always on a remote machine
> > and
> > "'DomSession.InitializeUsingNotesUserName($Admin, $Pass)"
> > does not work!
> > Here is my code...
> > Function checkCodeInDomino(checkCode As Long)
> > On Error GoTo Err_Quit_Click
> > Dim DomDir As NotesDatabase
> > Dim DomContacts As NotesView
> > Dim DomDoc As NotesDocument
> > Dim StrName As String
> > Dim DomSession As NotesSession
> > Dim serverName As String
> > Dim databaseFile As String
> > Set DomSession = CreateObject("Lotus.NotesSession")
> > serverName = "myServerName"
> > databaseFile = "myFile"
> > DomSession.Initialize
> > Set DomDir = DomSession.GetDatabase(serverName, databaseFile)
> > Set DomContacts = DomDir.GetView("myView")
> > Set DomDoc = DomContacts.GetFirstDocument
> > While Not (DomDoc Is Nothing)
> > If DomDoc.GetItemValue("Dealer_Code")(0) = checkCode Then
> > checkCodeInDomino = True
> > Exit Function
> > End If
> > Set DomDoc = DomContacts.GetNextDocument(DomDoc)
> > Wend
> > checkCodeInDomino = False
> > Exit_Quit_Click:
> > Exit Function
> > Err_Quit_Click:
> > MsgBox Err.Description
> > Resume Exit_Quit_Click
> > End Function
> > Thank you for your attention!
> > Peter Neumaier|||While I recognize that you're experiencing the problem using automation from
VBA, you're still issuing commands to directly to Domino. I would think that
people more familiar with the Domino programming model would be better able
to help than people familiar with VBA.

YMMV, though.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

"Peter Neumaier" <Peter.Neumaier@.gmail.com> wrote in message
news:98284637.0504020824.4b7a20c9@.posting.google.c om...
> Hi Douglas,
> thank you for your answer, but I think that my problem is more VBA and
> ACCES than it is to domino databases.
> So the only problem I have to solve is, how to use a default password
> when accessing the domino database ...
> For sure I found documentation on lotus.com, but there isnt anything
> regarding my problem
>
> "Douglas J. Steele" <NOSPAM_djsteele@.NOSPAM_canada.com> wrote in message
> news:<0cCdnUdLW-09ddDfRVn-vA@.rogers.com>...
>> I think you'll have more luck asking in a newsgroup related to Notes or
>> Domino, as opposed to a database group.
>>
>> Have you tried looking for documentation at http://www.lotus.com?
>>
>> --
>> Doug Steele, Microsoft Access MVP
>> http://I.Am/DougSteele
>> (no e-mails, please!)
>>
>>
>>
>> "Peter Neumaier" <Peter.Neumaier@.gmail.com> wrote in message
>> news:1112392663.538812.206890@.g14g2000cwa.googlegr oups.com...
>> > Hi,
>> > I am trying to read data from a domino databases (located in our LAN
>> > not on my local machine!) from my access project. I pass a code to the
>> > function checkCodeInDomino to be verified on Domino. On my local
>> > machine everything went fine, but suddenly there came up following
>> > problem:
>>> > I was coding and testing with the code below, and I have never been
>> > asked for my lotus password, now when starting my function, there comes
>> > a box up (dont know why this changed?) where I have to enter my lotus
>> > password, when entering my notes password, my function works fine.
>> > But I have to distribute my application to other clients and users, and
>> > it doesnt make sense to use my password.
>> > So I received a public account from our domino admin, for all of us.
>> > When using "DomSession.Initialize (publicLotusPassword)" there are no
>> > errors.
>> > But the problem is, that that's not a real solution for my
>> > appliacation, because each user has to enter his own password, I dont
>> > want that,
>> > but entering a hard coded password doesnt work, because the password
>> > that is asked is referring to
>> > "c:\lotus\notes\data\wk\$userName.ID"
>>> > Is there any way to use "DomSession.Initialize" in some kind of a
>> > "generic" way, so that any other user can use the function
>> > "checkCodeInDomino"?
>> > Please remember that the domino database is always on a remote machine
>> > and
>> > "'DomSession.InitializeUsingNotesUserName($Admin, $Pass)"
>> > does not work!
>>> > Here is my code...
>>> > Function checkCodeInDomino(checkCode As Long)
>> > On Error GoTo Err_Quit_Click
>>> > Dim DomDir As NotesDatabase
>> > Dim DomContacts As NotesView
>> > Dim DomDoc As NotesDocument
>> > Dim StrName As String
>>> > Dim DomSession As NotesSession
>> > Dim serverName As String
>> > Dim databaseFile As String
>>> > Set DomSession = CreateObject("Lotus.NotesSession")
>> > serverName = "myServerName"
>> > databaseFile = "myFile"
>>> > DomSession.Initialize
>>> > Set DomDir = DomSession.GetDatabase(serverName, databaseFile)
>> > Set DomContacts = DomDir.GetView("myView")
>> > Set DomDoc = DomContacts.GetFirstDocument
>>> > While Not (DomDoc Is Nothing)
>>> > If DomDoc.GetItemValue("Dealer_Code")(0) = checkCode Then
>> > checkCodeInDomino = True
>> > Exit Function
>> > End If
>> > Set DomDoc = DomContacts.GetNextDocument(DomDoc)
>> > Wend
>>> > checkCodeInDomino = False
>>> > Exit_Quit_Click:
>> > Exit Function
>>> > Err_Quit_Click:
>> > MsgBox Err.Description
>> > Resume Exit_Quit_Click
>>> > End Function
>>> > Thank you for your attention!
>>> > Peter Neumaier
>

Domain Users Rights

I have a problem that im using Active Directory in Win2k Server, when domain users logon to workstations they can't open sql server databases, SQL server is local installed on Workstation and operating system is XP.

When i give administrator rights to users the sql server works fine.

Tell me is there is a way to use sql server without giving to the user administrative rights?

thanksYou need to login as the account that the SQL Server is running in on their boxes (set up a SQL Server "account". You then need to go into SQL Server while logged in as this account and add Domain Users as a login in SQL Server and grant permissions. They can then login and do what they need to do.

Domain group server access?

Hi,
If a user needs access to a databases and I carry out the following steps:
1) Create a domain group
2) Put the users login details in this group
3) Give the domain group access to SQL Server via Enterprise Manager
4) Give the domain group database access via Enterprise Manager
Do I also need to give this domain group direct server access by adding it
to a group in:
Computer Management\Local Users and Groups\Groups ?
Ta
wendyalso, we are using active directory.
wendy
"Woo" wrote:

> Hi,
> If a user needs access to a databases and I carry out the following steps:
> 1) Create a domain group
> 2) Put the users login details in this group
> 3) Give the domain group access to SQL Server via Enterprise Manager
> 4) Give the domain group database access via Enterprise Manager
> Do I also need to give this domain group direct server access by adding it
> to a group in:
> Computer Management\Local Users and Groups\Groups ?
> Ta
> wendy|||No you don't need to give OS level permissions on the server
that is running SQL Server for the group to access SQL
Server. You only need to add the windows group to the SQL
Server logins (and whatever databases).
-Sue
On Fri, 3 Nov 2006 04:14:02 -0800, Woo
<Woo@.discussions.microsoft.com> wrote:

>Hi,
>If a user needs access to a databases and I carry out the following steps:
>1) Create a domain group
>2) Put the users login details in this group
>3) Give the domain group access to SQL Server via Enterprise Manager
>4) Give the domain group database access via Enterprise Manager
>Do I also need to give this domain group direct server access by adding it
>to a group in:
>Computer Management\Local Users and Groups\Groups ?
>Ta
>wendy|||And you will have to give the windows group permissions to access tables,
views, stored procedures, etc.
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
news:bcjmk2h4eoundvep74genb5d43ldjveog2@.
4ax.com...
> No you don't need to give OS level permissions on the server
> that is running SQL Server for the group to access SQL
> Server. You only need to add the windows group to the SQL
> Server logins (and whatever databases).
> -Sue
> On Fri, 3 Nov 2006 04:14:02 -0800, Woo
> <Woo@.discussions.microsoft.com> wrote:
>
>

domain administrator password and sql services startup

A reality check please...
After changing the domain administrator password, we are no longer
able to connect to databases on a MS SQL Server 2000 server when
attempting to use ODBC drivers from W2K workstations.
The MSSQLSERVER and SQLSERVERAGENT services both show DomainName
\Administrator under the "Logon under This Account" in the 'Logon' tab
in services.msc. The server name inside the SQL server are set to
mixed mode.
Am I correct in thinking that changing the password field shown in the
"Login under This account:DomainName\Administrator to match the new
domain administrator password will bring Joy?
Thanks!
Benoit
(Cross-posted to microsoft.public.sqlserver.server,
microsoft.public.sqlserver.setup, microsoft.public.sqlserver.odbc)
Hello,
Yes, if the Windows account used by the SQL Server services has a new
password you should update it here or by using Enterprise Manager.
Also, it would be better if you use a dedicated Windows account for SQL
Server instead of the domain administrator account.
Hope this helps,
Ben Nevarez
Senior Database Administrator
AIG SunAmerica
"bntgoogle@.yahoo.com" wrote:

> A reality check please...
> After changing the domain administrator password, we are no longer
> able to connect to databases on a MS SQL Server 2000 server when
> attempting to use ODBC drivers from W2K workstations.
> The MSSQLSERVER and SQLSERVERAGENT services both show DomainName
> \Administrator under the "Logon under This Account" in the 'Logon' tab
> in services.msc. The server name inside the SQL server are set to
> mixed mode.
> Am I correct in thinking that changing the password field shown in the
> "Login under This account:DomainName\Administrator to match the new
> domain administrator password will bring Joy?
> Thanks!
> Benoit
> (Cross-posted to microsoft.public.sqlserver.server,
> microsoft.public.sqlserver.setup, microsoft.public.sqlserver.odbc)
>

domain administrator password and sql services startup

A reality check please...
After changing the domain administrator password, we are no longer
able to connect to databases on a MS SQL Server 2000 server when
attempting to use ODBC drivers from W2K workstations.
The MSSQLSERVER and SQLSERVERAGENT services both show DomainName
\Administrator under the "Logon under This Account" in the 'Logon' tab
in services.msc. The server name inside the SQL server are set to
mixed mode.
Am I correct in thinking that changing the password field shown in the
"Login under This account:DomainName\Administrator to match the new
domain administrator password will bring Joy?
Thanks!
Benoit
(Cross-posted to microsoft.public.sqlserver.server,
microsoft.public.sqlserver.setup, microsoft.public.sqlserver.odbc)
Are you saying that your SQL Server service is running under domain admin
user account? That is bad, that means SQL Server service can do anything
with the domain, which is really needed.
If the SQL Server service has to access something in the domain (say, you
added some extended procedures that require access files on other
computers), you can use a domain account that is only given proper
permission for just that purpose, using a domain admin account is an
overkill and dangerous.
With that said, the change you described should not affect how SQL Server is
accessed, as long as it still runs.
<bntgoogle@.yahoo.com> wrote in message
news:1194626641.221081.264340@.e34g2000pro.googlegr oups.com...
>A reality check please...
> After changing the domain administrator password, we are no longer
> able to connect to databases on a MS SQL Server 2000 server when
> attempting to use ODBC drivers from W2K workstations.
> The MSSQLSERVER and SQLSERVERAGENT services both show DomainName
> \Administrator under the "Logon under This Account" in the 'Logon' tab
> in services.msc. The server name inside the SQL server are set to
> mixed mode.
> Am I correct in thinking that changing the password field shown in the
> "Login under This account:DomainName\Administrator to match the new
> domain administrator password will bring Joy?
> Thanks!
> Benoit
> (Cross-posted to microsoft.public.sqlserver.server,
> microsoft.public.sqlserver.setup, microsoft.public.sqlserver.odbc)
>
|||Have both servers been rebooted since the domain name and password change?
Regards,
Jamie
"bntgoogle@.yahoo.com" wrote:

> A reality check please...
> After changing the domain administrator password, we are no longer
> able to connect to databases on a MS SQL Server 2000 server when
> attempting to use ODBC drivers from W2K workstations.
> The MSSQLSERVER and SQLSERVERAGENT services both show DomainName
> \Administrator under the "Logon under This Account" in the 'Logon' tab
> in services.msc. The server name inside the SQL server are set to
> mixed mode.
> Am I correct in thinking that changing the password field shown in the
> "Login under This account:DomainName\Administrator to match the new
> domain administrator password will bring Joy?
> Thanks!
> Benoit
> (Cross-posted to microsoft.public.sqlserver.server,
> microsoft.public.sqlserver.setup, microsoft.public.sqlserver.odbc)
>
|||Jamie
No, the SQL servers were not rebooted, a realization I had only after
we backed off and returned to the previous pwd. That seems to the
other likely reason why it breaks after this.
Put another way, my question is whether the username\password for the
account responsible for the server startup needs to be changed
*separately* after having changed the AD user password...
And oh yeah, I certainly know that is a bad user to use. That is why I
need to change it...
B
On Nov 9, 12:02 pm, thejamie <theja...@.discussions.microsoft.com>
wrote:[vbcol=seagreen]
> Have both servers been rebooted since the domain name and password change?
> --
> Regards,
> Jamie
> "bntgoo...@.yahoo.com" wrote:
>
>
>

domain administrator password and sql services startup

A reality check please...
After changing the domain administrator password, we are no longer
able to connect to databases on a MS SQL Server 2000 server when
attempting to use ODBC drivers from W2K workstations.
The MSSQLSERVER and SQLSERVERAGENT services both show DomainName
\Administrator under the "Logon under This Account" in the 'Logon' tab
in services.msc. The server name inside the SQL server are set to
mixed mode.
Am I correct in thinking that changing the password field shown in the
"Login under This account:DomainName\Administrator to match the new
domain administrator password will bring Joy?
Thanks!
Benoit
(Cross-posted to microsoft.public.sqlserver.server,
microsoft.public.sqlserver.setup, microsoft.public.sqlserver.odbc)Are you saying that your SQL Server service is running under domain admin
user account? That is bad, that means SQL Server service can do anything
with the domain, which is really needed.
If the SQL Server service has to access something in the domain (say, you
added some extended procedures that require access files on other
computers), you can use a domain account that is only given proper
permission for just that purpose, using a domain admin account is an
overkill and dangerous.
With that said, the change you described should not affect how SQL Server is
accessed, as long as it still runs.
<bntgoogle@.yahoo.com> wrote in message
news:1194626641.221081.264340@.e34g2000pro.googlegroups.com...
>A reality check please...
> After changing the domain administrator password, we are no longer
> able to connect to databases on a MS SQL Server 2000 server when
> attempting to use ODBC drivers from W2K workstations.
> The MSSQLSERVER and SQLSERVERAGENT services both show DomainName
> \Administrator under the "Logon under This Account" in the 'Logon' tab
> in services.msc. The server name inside the SQL server are set to
> mixed mode.
> Am I correct in thinking that changing the password field shown in the
> "Login under This account:DomainName\Administrator to match the new
> domain administrator password will bring Joy?
> Thanks!
> Benoit
> (Cross-posted to microsoft.public.sqlserver.server,
> microsoft.public.sqlserver.setup, microsoft.public.sqlserver.odbc)
>|||Have both servers been rebooted since the domain name and password change?
--
Regards,
Jamie
"bntgoogle@.yahoo.com" wrote:

> A reality check please...
> After changing the domain administrator password, we are no longer
> able to connect to databases on a MS SQL Server 2000 server when
> attempting to use ODBC drivers from W2K workstations.
> The MSSQLSERVER and SQLSERVERAGENT services both show DomainName
> \Administrator under the "Logon under This Account" in the 'Logon' tab
> in services.msc. The server name inside the SQL server are set to
> mixed mode.
> Am I correct in thinking that changing the password field shown in the
> "Login under This account:DomainName\Administrator to match the new
> domain administrator password will bring Joy?
> Thanks!
> Benoit
> (Cross-posted to microsoft.public.sqlserver.server,
> microsoft.public.sqlserver.setup, microsoft.public.sqlserver.odbc)
>|||Jamie
No, the SQL servers were not rebooted, a realization I had only after
we backed off and returned to the previous pwd. That seems to the
other likely reason why it breaks after this.
Put another way, my question is whether the username\password for the
account responsible for the server startup needs to be changed
*separately* after having changed the AD user password...
And oh yeah, I certainly know that is a bad user to use. That is why I
need to change it...
B
On Nov 9, 12:02 pm, thejamie <theja...@.discussions.microsoft.com>
wrote:[vbcol=seagreen]
> Have both servers been rebooted since the domain name and password change?
> --
> Regards,
> Jamie
> "bntgoo...@.yahoo.com" wrote:
>
>
>
>
>
>