Access Denied Error attaching an existing MDF

I guess I messed up somehow, but I am not sure how to fix this.

On Vista, with SQL Server 2005 Developer Edition, I created a 6GB database and loaded it up with data. I then decided that I wanted to burn a copy of the files, so I detached (no problem.) But when I wanted to copy the physical MDF and LOG file to another folder. Vista said I did not have access to the folder, but if I hit continue, no problem--it would correct the situation. I did. I copied the files (no problem), but now when I go to reattach to the MDF (that is still in the Data folder), I get a "CREATE FILE encountered operating system 5 (Access is denied)" error. I checked permissions and SQL Server has full rights. I am the only user on the system (Admin), and the files do not appear to have anything weird set (read only, advanced permissions, etc.)

What did I do wrong? And how do I fix this? Oh the joys of advanced Vista security features Even the admin is locked out now.

Thank you for your help!

Michael

Usually the difference for Vista is that you do not get access simply by being a member of the Administrators group. You would need to grant explicit access to the account for the SQL service as well as your own account.|||

I want to understand what you are saying. Are you saying the error is occuring because my login was added to the permissions on the Data folder? MSSQLSERVER has full permissions to the folder and file. That doesn't appear to have changed. Or are you saying that I need to add permissions back for another service like the Agent?

I am trying to understand what Vista did that makes this operation fail.

Thanks!

|||

Attach will attempt to verify that your account has access to the file before attaching it to the server. This keeps random users from attaching random files that they would not normally have access to.

Check the file permissions for both the service account and your account.

|||

Check the NTFS permissions on the actual files. I have see time where after detaching a database from the SQL Server the only user account which has access to the files is the user who detached the database. All other accounts are removed including the SQL Server.

It can be a deceving problem becuase the NTFS permissions on the folder look fine (because they are), but the NTFS permissions of the data files are screwed up.

|||

I will check that out when I get in front of that PC -- thanks! I am still baffled by it. I was able to copy the file to another folder and attach, so I was able to move on. However, the copy that was in the original location still has the issue.

Thank you for replying -- that actually makes sense.

Michael

|||Permission on detach works differently in sql2k5 than sql2k (i.e. it does not preserve all acls like sql2k). This has caught many sql2k users off guard.
http://msdn2.microsoft.com/en-us/library/ms189128.aspx

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

Access ADP - SQL server diagram conflicts!

I've run into an annoyance, if I create a new Access project from an
existing SQL database and open up diagrams created earlier with th
enterprise manager Access XP crashes. Creating new diagrams through Access
seems to work just fine. Anyone else run into this? Thanks all.
JonSounds like an Access bug. I'd ask on those newsgroups. It may be
fixed in newer versions of Access.
--Mary
On Thu, 24 Jun 2004 08:25:04 -0400, "Jon" <jonremovemewest@.msn.com>
wrote:

>I've run into an annoyance, if I create a new Access project from an
>existing SQL database and open up diagrams created earlier with th
>enterprise manager Access XP crashes. Creating new diagrams through Access
>seems to work just fine. Anyone else run into this? Thanks all.
>Jon
>

Access ADP - SQL server diagram conflicts!

I've run into an annoyance, if I create a new Access project from an
existing SQL database and open up diagrams created earlier with th
enterprise manager Access XP crashes. Creating new diagrams through Access
seems to work just fine. Anyone else run into this? Thanks all.
JonSounds like an Access bug. I'd ask on those newsgroups. It may be
fixed in newer versions of Access.
--Mary
On Thu, 24 Jun 2004 08:25:04 -0400, "Jon" <jonremovemewest@.msn.com>
wrote:
>I've run into an annoyance, if I create a new Access project from an
>existing SQL database and open up diagrams created earlier with th
>enterprise manager Access XP crashes. Creating new diagrams through Access
>seems to work just fine. Anyone else run into this? Thanks all.
>Jon
>

Access ADP - SQL server diagram conflicts!

I've run into an annoyance, if I create a new Access project from an
existing SQL database and open up diagrams created earlier with th
enterprise manager Access XP crashes. Creating new diagrams through Access
seems to work just fine. Anyone else run into this? Thanks all.
Jon
Sounds like an Access bug. I'd ask on those newsgroups. It may be
fixed in newer versions of Access.
--Mary
On Thu, 24 Jun 2004 08:25:04 -0400, "Jon" <jonremovemewest@.msn.com>
wrote:

>I've run into an annoyance, if I create a new Access project from an
>existing SQL database and open up diagrams created earlier with th
>enterprise manager Access XP crashes. Creating new diagrams through Access
>seems to work just fine. Anyone else run into this? Thanks all.
>Jon
>
sql

Access a table

Another question about SQL Server tables and access grants.
I've created an user 'user1' as Access account, ad also as db_owner of a
selected database.
Then, I've created a table as user1.table1.
When I try to access the data of the table, with the account name of user1,
I must specify the owner ('select * from user1.table1') even if I've logged
as user1 (I need to access the data just with 'select * from table1').
What's the problem?

Thank you
Federica"Federica T" <fedina_chicca@.N_O_Spam_libero.it> wrote in message
news:ckgq2d$a46$1@.atlantis.cu.mi.it...
> Another question about SQL Server tables and access grants.
> I've created an user 'user1' as Access account, ad also as db_owner of a
> selected database.
> Then, I've created a table as user1.table1.
> When I try to access the data of the table, with the account name of
> user1,
> I must specify the owner ('select * from user1.table1') even if I've
> logged
> as user1 (I need to access the data just with 'select * from table1').
> What's the problem?
> Thank you
> Federica

It sounds as if it should work as you expect - for users not in the sysadmin
role, MSSQL always looks for an object owned by the current user first, then
dbo (see "Database Object Owner" in Books Online), but for sysadmins it will
always look for dbo first.

Do you get error 208 (invalid object name), or does it select from
dbo.table1 instead? If you get error 208, then you can use USER_NAME() to
check that you are user1, DB_NAME() to check you're in the correct database
(you might be in master by default, for example), and OBJECT_ID() to make
sure the object exists. If it selects from dbo.table1 instead, then user1's
login is probably also in the sysadmin role on the server.

If the problem is still unclear, what do you get when you run the following
as user1?

create table user1.t1 (col varchar(100))
insert into user1.t1 select 'Owned by user1'

create table dbo.t1 (col varchar(100))
insert into dbo.t1 select 'Owned by dbo'

select
'Database: '+ db_name() + ' ' +
'Login: ' + suser_sname() + ' ' +
'User: '+ user_name() + ' ' +
'Object owner: ' + col + ' ' +
'db_owner: ' + case is_member('db_owner') when 1 then 'Y' else 'N' end + '
' +
'sysadmin: ' + case is_srvrolemember('sysadmin') when 1 then 'Y' else 'N'
end
from t1

Simon|||"Simon Hayes" <sql@.hayes.ch
> It sounds as if it should work as you expect - for users not in the
sysadmin
> role, MSSQL always looks for an object owned by the current user first,
then
> dbo (see "Database Object Owner" in Books Online), but for sysadmins it
will
> always look for dbo first.

Thank you for the answer! The problem was caused by the user that was also a
sysadmin!
Fedesql

Access .Rdl from Asp.net webforms

Hi,

I am new to Sqlserver reporting.I have created few reports using vs2005 busineess intelligence projects and report designer-wizards.

I want to add/access those reports from webforms?is it possible?or do i need to deploy reports over report server.If i run the server i am able to see the report.

If i want to access from .aspx page what do i need to do?I tried adding existing item,.rdl but i do see only .xml part of .rdl .

Can anyone help me on this.

Thanks,

kar1978

Use ReportViewer control

It can be used with

// Set the processing mode for the ReportViewer to Remote

reportViewer.ProcessingMode =ProcessingMode.Remote;

or

reportViewer.ProcessingMode =ProcessingMode.Local

Accesing offline cubes with MS Excel 2003

Hi,

I created offline cube (.cub file) with SQL Server 2005 Analysis Services. Accessing the offline cube with MS Excel 2003 I get an error message: "Unable to obtain list of tables from the data source".

I can access the offline cube with MS Excel 2003 only when MS Excel 2007 is instaled. After uninstaling MS Excel 2007 the same error ocures.

I have MS Excel 2003 (11.8146.6568) SP2, Microsoft SQL Server 2005 Analysis Services 9.0 OLE DB Provider, Microsoft Core XML Services (MSXML) 6.0 instaled.

Thanks for help,

Martin

Hello! This is only from what I have read.

To create local cubes you can write XMLA commands in Management Studio or write code by using the SSAS2005 object model called AMO.

I do not think that these two possibilities are part of Excel 2003.

HTH

Thomas Ivarsson

Accent problem

I'm having a problem with character accentuation in SQL Server 2000.
The database was created with SQL_Latin1_General_CP850_CI_AI Collation and
table varchar fields are using the same collation.
The problem happens when I use characters with accentuation, database is not
saving the correct character value, I don't know if it is a client
configuration problem or a database configuration problem.
If I insert the character 'á', it is saving as '?'.
I think it is not a collate problem because I'm trying to select the field
using a different collate but the character still wrong.
select my_field collate SQL_Latin1_General_CP1_CS_AS
from my_table
I don't how to solve this problem, it's a collation problem? Client
configuration problem?
Some help will be usefull.
Thanks.
Its hard to say. There are some problems with some of the input mechanisms.
For instance if you input text files into a text or varchar column using the
ado stream object, they seem to go in as Unicode with an unknown code page.
Converting the text files to ANSI and then importing them seems to fix this
behavior.
It could also be related to the regional settings on the client computer.
Exactly how are you inputting these characters.
"Depaula" <Depaula@.discussions.microsoft.com> wrote in message
news:172EDC2E-1BEF-496A-AB27-529B0C1EF4D9@.microsoft.com...
> I'm having a problem with character accentuation in SQL Server 2000.
> The database was created with SQL_Latin1_General_CP850_CI_AI Collation and
> table varchar fields are using the same collation.
> The problem happens when I use characters with accentuation, database is
> not
> saving the correct character value, I don't know if it is a client
> configuration problem or a database configuration problem.
> If I insert the character 'á', it is saving as '?'.
> I think it is not a collate problem because I'm trying to select the field
> using a different collate but the character still wrong.
> select my_field collate SQL_Latin1_General_CP1_CS_AS
> from my_table
> I don't how to solve this problem, it's a collation problem? Client
> configuration problem?
> Some help will be usefull.
> Thanks.
|||I have an application that inserts data collected from users, it is very
curious because I have the same applications working in other databases and
it works right.
Only in this situation I have this problem and I don't know how to identify
where is the problem.
In first time I thought that problem was the database collation, but when I
select data using other collation the problem still happening.
** The text fields are varchar(254).
Thanks for help me.
"Hilary Cotter" wrote:

> Its hard to say. There are some problems with some of the input mechanisms.
> For instance if you input text files into a text or varchar column using the
> ado stream object, they seem to go in as Unicode with an unknown code page.
> Converting the text files to ANSI and then importing them seems to fix this
> behavior.
> It could also be related to the regional settings on the client computer.
> Exactly how are you inputting these characters.
>
> "Depaula" <Depaula@.discussions.microsoft.com> wrote in message
> news:172EDC2E-1BEF-496A-AB27-529B0C1EF4D9@.microsoft.com...
>
>
|||are the regional settings of both machines identical?
"Depaula" <Depaula@.discussions.microsoft.com> wrote in message
news:9615ED1B-EF46-4F3D-B491-BC9703A029D8@.microsoft.com...
> I have an application that inserts data collected from users, it is very
> curious because I have the same applications working in other databases
and
> it works right.
> Only in this situation I have this problem and I don't know how to
identify
> where is the problem.
> In first time I thought that problem was the database collation, but when
I[vbcol=seagreen]
> select data using other collation the problem still happening.
> ** The text fields are varchar(254).
> Thanks for help me.
>
> "Hilary Cotter" wrote:
mechanisms.[vbcol=seagreen]
the[vbcol=seagreen]
page.[vbcol=seagreen]
this[vbcol=seagreen]
computer.[vbcol=seagreen]
and[vbcol=seagreen]
is[vbcol=seagreen]
field[vbcol=seagreen]
|||Have you tested to define your column as unicode column : nvarchar and not
varchar ?
Phil.
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:e50MWXisEHA.3572@.tk2msftngp13.phx.gbl...[vbcol=seagreen]
> are the regional settings of both machines identical?
> "Depaula" <Depaula@.discussions.microsoft.com> wrote in message
> news:9615ED1B-EF46-4F3D-B491-BC9703A029D8@.microsoft.com...
> and
> identify
when[vbcol=seagreen]
> I
> mechanisms.
using[vbcol=seagreen]
> the
> page.
> this
> computer.
Collation[vbcol=seagreen]
> and
database
> is
> field
>
|||Hi Philippe,
Hmm... You are correct as Depaula's first posting indicated that he was
using "...and table varchar fields are using the same collation" and not
nvarchar!
Regards,
John
"Philippe [MS]" <ptrotin@.online.microsoft.com> wrote in message
news:u9$oczWtEHA.1220@.TK2MSFTNGP10.phx.gbl...[vbcol=seagreen]
> Have you tested to define your column as unicode column : nvarchar and not
> varchar ?
> Phil.
> "Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
> news:e50MWXisEHA.3572@.tk2msftngp13.phx.gbl...
very[vbcol=seagreen]
databases[vbcol=seagreen]
> when
> using
code[vbcol=seagreen]
fix[vbcol=seagreen]
2000.[vbcol=seagreen]
> Collation
> database
the[vbcol=seagreen]
Client
>

about transactional replication

Hi,
I have created a transactional replication on SQL Server 2000 with SP3. Only
one database is being published with 70 tables.
But when it begins to replicate data the following errors occured
""The process could not bulk copy into table 'tablename' ""
Violation of PRIMARY KEY constraint 'tablename_PKEY'. Cannot insert
duplicate key in object 'tablename'.
This table has a PKEY and it's not identity and this table also related with
other tables
This question is asked before but i have still no idea to solve this problem
without deleting the relationships of that table.
Please tell the solution step by step,
Best regards...
its hard to say what is going on here. There are a couple of possibilities:
1) data already exists at the subscriber and you are not deleting it before
sending over a new snapshot.
2) you are replicating two or more articles to the same object on the
subscriber.
3) you are getting a different error message than the one posted.
Are you replicating the DRI of these tables, or are you replicating to a
database where the schema already exists? If so you will need to send a
pre-snapshot command which disables all DRI, and a post snapshot command
which re-enables it.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Ugur Ekinci" <ugur@.argeset.com> wrote in message
news:OUdrkjtKFHA.2688@.TK2MSFTNGP15.phx.gbl...
> Hi,
> I have created a transactional replication on SQL Server 2000 with SP3.
Only
> one database is being published with 70 tables.
> But when it begins to replicate data the following errors occured
> ""The process could not bulk copy into table 'tablename' ""
> Violation of PRIMARY KEY constraint 'tablename_PKEY'. Cannot insert
> duplicate key in object 'tablename'.
> This table has a PKEY and it's not identity and this table also related
with
> other tables
> This question is asked before but i have still no idea to solve this
problem
> without deleting the relationships of that table.
> Please tell the solution step by step,
> Best regards...
>
|||Hi Mr. Hilary,
Yes data already exists at the subscriber, how can i provide to delete
record before replicate it ?
how can I disable DRI and reenable it after replicaiton finished ?
It would be great if you give an example,
Best regards...
"Hilary Cotter" <hilary.cotter@.gmail.com>, haber iletisinde unlar
yazd:ulKrEeuKFHA.3616@.TK2MSFTNGP09.phx.gbl...
> its hard to say what is going on here. There are a couple of
> possibilities:
> 1) data already exists at the subscriber and you are not deleting it
> before
> sending over a new snapshot.
> 2) you are replicating two or more articles to the same object on the
> subscriber.
> 3) you are getting a different error message than the one posted.
> Are you replicating the DRI of these tables, or are you replicating to a
> database where the schema already exists? If so you will need to send a
> pre-snapshot command which disables all DRI, and a post snapshot command
> which re-enables it.
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
> "Ugur Ekinci" <ugur@.argeset.com> wrote in message
> news:OUdrkjtKFHA.2688@.TK2MSFTNGP15.phx.gbl...
> Only
> with
> problem
>
|||It's ok, thanks Mr. Hilary,
Since i checked the "delete data in the existing table..." from publication
properties , that error does not occur ,
But I need to know that can we disable DRI with SP_ commands and enable it
again ?
Best regards...
"Hilary Cotter" <hilary.cotter@.gmail.com>, haber iletisinde unlar
yazd:ulKrEeuKFHA.3616@.TK2MSFTNGP09.phx.gbl...
> its hard to say what is going on here. There are a couple of
> possibilities:
> 1) data already exists at the subscriber and you are not deleting it
> before
> sending over a new snapshot.
> 2) you are replicating two or more articles to the same object on the
> subscriber.
> 3) you are getting a different error message than the one posted.
> Are you replicating the DRI of these tables, or are you replicating to a
> database where the schema already exists? If so you will need to send a
> pre-snapshot command which disables all DRI, and a post snapshot command
> which re-enables it.
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
> "Ugur Ekinci" <ugur@.argeset.com> wrote in message
> news:OUdrkjtKFHA.2688@.TK2MSFTNGP15.phx.gbl...
> Only
> with
> problem
>

about partition?

I created partition for one table

How to check if the partitioned data is correct?

Also if there is easier and quick method to tune this partition?

any idea? many thanks

A first ideea is to use $partition function (in Books Online have an example); with it you can get the number of rows in each nonempty partition of a partitioned table or index; make a job that insert time to time this data into a table and read it periodically.

Gigi Ciubuc
www.sqlserver.ro|||

thank you

I am going to read BOL

About join

I have Created two tables to test join key in sql server,but the result is
not what I thougt.Why?Wish all your explains.Thanks.I give all the sql code
in comment.
--The table name is first for tesing fulljoin
/*
create table testfulljoin
(a char(4),
b char(4),
c char(4))
insert testfulljoin(a,b,c)
select 'a','b','c' union all
select 'b','a','d' union all
select 'c','d','e' union all
select 'd','f','g'
*/

/*
create table testfulljoin2
(b char(4),
c char(4),
d char(4))
insert testfulljoin2(b,c,d)
select 'b','c','d' union all
select 'd','e','g' union all
select 'f','d','g' union all
select 'd','e','c'
*/

When testfulljoin2 left join testfulljoin the result is:
a b c d
c d e g
NULLNULLNULLg
c d e c

Why result is not like what I' v aways told:
a b c d
c d e g
null f d g
c d e c

If not why testfulljoin2 right join testfulljoin the result is
a b c d
b a d NULL
c d e g
c d e c
d f g NULLI found the answer myself
Use :

select a.a ,b.* from testfulljoin2 as b left join testfulljoin as a on a.b=b.b and a.c=b.c;|||

Quote:

Originally Posted by shenliang1985

I found the answer myself
Use :

select a.a ,b.* from testfulljoin2 as b left join testfulljoin as a on a.b=b.b and a.c=b.c;

Thas good that you found the solution by yourself. Self learning is the best way to learn new things.

MODERATOR

about indexes

Hi Grus,
How can i know that on what date a index was created and how many times
it was reindexed.
Or how offen it being reindexed.
from
DollerSQL Server doesn't keep such information. So you would have to keep track of
it yourself, possibly
using a Profiler trace.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"doller" <sufianarif@.gmail.com> wrote in message
news:1132808347.911840.163270@.g44g2000cwa.googlegroups.com...
> Hi Grus,
> How can i know that on what date a index was created and how many times
> it was reindexed.
> Or how offen it being reindexed.
> from
> Doller
>

about indexes

Hi Grus,
How can i know that on what date a index was created and how many times
it was reindexed.
Or how offen it being reindexed.
from
Doller
SQL Server doesn't keep such information. So you would have to keep track of it yourself, possibly
using a Profiler trace.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"doller" <sufianarif@.gmail.com> wrote in message
news:1132808347.911840.163270@.g44g2000cwa.googlegr oups.com...
> Hi Grus,
> How can i know that on what date a index was created and how many times
> it was reindexed.
> Or how offen it being reindexed.
> from
> Doller
>

about indexes

Hi Grus,
How can i know that on what date a index was created and how many times
it was reindexed.
Or how offen it being reindexed.
from
DollerSQL Server doesn't keep such information. So you would have to keep track of it yourself, possibly
using a Profiler trace.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"doller" <sufianarif@.gmail.com> wrote in message
news:1132808347.911840.163270@.g44g2000cwa.googlegroups.com...
> Hi Grus,
> How can i know that on what date a index was created and how many times
> it was reindexed.
> Or how offen it being reindexed.
> from
> Doller
>

about deployment with database

Hai,
We created one application, in .net with sql server 2005. we
created the setup file also.
Now we want to install the application in client place, But,
client don't have any sql server in their system. I heard about with
MSDE, there is no need for sql server.
Anybody can explain, what we have to do now.
Regards,
Raju.Go to www.microsoft.com/sql and look at the SQL Server 2005 Express.
It is a 'FREE' product, the successor to MSDE, and may serve your needs.
SQL Server 2005 Express Edition Feature Comparison
http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx
SQL Server 2005 Express Overview
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsse/html/sseoverview.asp
http://www.pcw.co.uk/personal-computer-world/software/2155087/review-microsoft-sql-server
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
"raju" <ponnurajs@.gmail.com> wrote in message
news:1162015230.775017.143230@.i42g2000cwa.googlegroups.com...
> Hai,
> We created one application, in .net with sql server 2005. we
> created the setup file also.
> Now we want to install the application in client place, But,
> client don't have any sql server in their system. I heard about with
> MSDE, there is no need for sql server.
> Anybody can explain, what we have to do now.
> Regards,
> Raju.
>|||Hai,
Thanks for you immediate response.
Whether we have to install the sql server 2005 express manually, is
it possible to install the sql server 2005 from our .net application
automatically.
First we will deploy, required installation files and database
files in our application.
So, when we install the application, first the sql server 2005
express will install and after that out application will get installed.
If this one is possible then, please give me the procedure for
that.
Thanks in advance.
Regards,
Raju.|||See:
SQL Server 2005 Unintended Installations
http://www.devx.com/dbzone/Article/31648
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
"raju" <ponnurajs@.gmail.com> wrote in message
news:1162021453.839712.248670@.i3g2000cwc.googlegroups.com...
> Hai,
> Thanks for you immediate response.
> Whether we have to install the sql server 2005 express manually, is
> it possible to install the sql server 2005 from our .net application
> automatically.
> First we will deploy, required installation files and database
> files in our application.
> So, when we install the application, first the sql server 2005
> express will install and after that out application will get installed.
> If this one is possible then, please give me the procedure for
> that.
> Thanks in advance.
> Regards,
> Raju.
>|||> SQL Server 2005 Unintended Installations
Freudian slip, Arnie? :-)
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Arnie Rowland" <arnie@.1568.com> wrote in message news:OFd5COr%23GHA.3952@.TK2MSFTNGP03.phx.gbl...
> See:
> SQL Server 2005 Unintended Installations
> http://www.devx.com/dbzone/Article/31648
>
> --
> 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
>
> "raju" <ponnurajs@.gmail.com> wrote in message
> news:1162021453.839712.248670@.i3g2000cwc.googlegroups.com...
>> Hai,
>> Thanks for you immediate response.
>> Whether we have to install the sql server 2005 express manually, is
>> it possible to install the sql server 2005 from our .net application
>> automatically.
>> First we will deploy, required installation files and database
>> files in our application.
>> So, when we install the application, first the sql server 2005
>> express will install and after that out application will get installed.
>> If this one is possible then, please give me the procedure for
>> that.
>> Thanks in advance.
>> Regards,
>> Raju.
>|||Got me...
But sometimes, the user may not have 'intended' to end up with a SQL
installation -but they get one anyway.
--
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
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:OaGw9Xr%23GHA.4708@.TK2MSFTNGP05.phx.gbl...
>> SQL Server 2005 Unintended Installations
> Freudian slip, Arnie? :-)
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Arnie Rowland" <arnie@.1568.com> wrote in message
> news:OFd5COr%23GHA.3952@.TK2MSFTNGP03.phx.gbl...
>> See:
>> SQL Server 2005 Unintended Installations
>> http://www.devx.com/dbzone/Article/31648
>>
>> --
>> 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
>>
>> "raju" <ponnurajs@.gmail.com> wrote in message
>> news:1162021453.839712.248670@.i3g2000cwc.googlegroups.com...
>> Hai,
>> Thanks for you immediate response.
>> Whether we have to install the sql server 2005 express manually, is
>> it possible to install the sql server 2005 from our .net application
>> automatically.
>> First we will deploy, required installation files and database
>> files in our application.
>> So, when we install the application, first the sql server 2005
>> express will install and after that out application will get installed.
>> If this one is possible then, please give me the procedure for
>> that.
>> Thanks in advance.
>> Regards,
>> Raju.
>>|||Hello Arnie Rowland,
Now we got the sqlexpress, when we run the applcation it is
running smoothly.
The database is from our application only. But when we run the
crystal reports it is refering the database logon information on the
machine, where we created the crystal reports.
I know the problem, why it is. Bec., we created the crystal
reports, using the local datasource only.
So, how to give the datasource, when we creating the crystal
reports.
Thanks in advance.
Regards,
Raju.|||That is a crystal reports issue, you need to change that in crystal reports. I suggest you post this
to some suitable crystal reports forum, as there isn't that high probability that you find experts
on crystal reports here.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"raju" <ponnurajs@.gmail.com> wrote in message
news:1162188434.813391.82120@.k70g2000cwa.googlegroups.com...
> Hello Arnie Rowland,
> Now we got the sqlexpress, when we run the applcation it is
> running smoothly.
> The database is from our application only. But when we run the
> crystal reports it is refering the database logon information on the
> machine, where we created the crystal reports.
> I know the problem, why it is. Bec., we created the crystal
> reports, using the local datasource only.
> So, how to give the datasource, when we creating the crystal
> reports.
> Thanks in advance.
> Regards,
> Raju.
>|||Hello,
Thanks for your response.
We can change that datasource at runtime also. Can you guide me
on how to do that.
Regards,
Raju.
Tibor Karaszi wrote:
> That is a crystal reports issue, you need to change that in crystal reports. I suggest you post this
> to some suitable crystal reports forum, as there isn't that high probability that you find experts
> on crystal reports here.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "raju" <ponnurajs@.gmail.com> wrote in message
> news:1162188434.813391.82120@.k70g2000cwa.googlegroups.com...
> > Hello Arnie Rowland,
> >
> > Now we got the sqlexpress, when we run the applcation it is
> > running smoothly.
> >
> > The database is from our application only. But when we run the
> > crystal reports it is refering the database logon information on the
> > machine, where we created the crystal reports.
> >
> > I know the problem, why it is. Bec., we created the crystal
> > reports, using the local datasource only.
> >
> > So, how to give the datasource, when we creating the crystal
> > reports.
> >
> > Thanks in advance.
> >
> > Regards,
> > Raju.
> >|||> We can change that datasource at runtime also. Can you guide me
> on how to do that.
I've never used Crystal Reports. You need ask people who know Crystal Reports on how to do this.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"raju" <ponnurajs@.gmail.com> wrote in message
news:1162378360.362543.118220@.b28g2000cwb.googlegroups.com...
> Hello,
> Thanks for your response.
> We can change that datasource at runtime also. Can you guide me
> on how to do that.
> Regards,
> Raju.
> Tibor Karaszi wrote:
>> That is a crystal reports issue, you need to change that in crystal reports. I suggest you post
>> this
>> to some suitable crystal reports forum, as there isn't that high probability that you find
>> experts
>> on crystal reports here.
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>>
>> "raju" <ponnurajs@.gmail.com> wrote in message
>> news:1162188434.813391.82120@.k70g2000cwa.googlegroups.com...
>> > Hello Arnie Rowland,
>> >
>> > Now we got the sqlexpress, when we run the applcation it is
>> > running smoothly.
>> >
>> > The database is from our application only. But when we run the
>> > crystal reports it is refering the database logon information on the
>> > machine, where we created the crystal reports.
>> >
>> > I know the problem, why it is. Bec., we created the crystal
>> > reports, using the local datasource only.
>> >
>> > So, how to give the datasource, when we creating the crystal
>> > reports.
>> >
>> > Thanks in advance.
>> >
>> > Regards,
>> > Raju.
>> >
>

about deployment with database

Hai,
We created one application, in .net with sql server 2005. we
created the setup file also.
Now we want to install the application in client place, But,
client don't have any sql server in their system. I heard about with
MSDE, there is no need for sql server.
Anybody can explain, what we have to do now.
Regards,
Raju.Go to www.microsoft.com/sql and look at the SQL Server 2005 Express.
It is a 'FREE' product, the successor to MSDE, and may serve your needs.
SQL Server 2005 Express Edition Feature Comparison
http://www.microsoft.com/sql/prodin...e-features.mspx
SQL Server 2005 Express Overview
http://msdn.microsoft.com/library/d...r />
rview.asp
http://www.pcw.co.uk/personal-compu...
-server
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
"raju" <ponnurajs@.gmail.com> wrote in message
news:1162015230.775017.143230@.i42g2000cwa.googlegroups.com...
> Hai,
> We created one application, in .net with sql server 2005. we
> created the setup file also.
> Now we want to install the application in client place, But,
> client don't have any sql server in their system. I heard about with
> MSDE, there is no need for sql server.
> Anybody can explain, what we have to do now.
> Regards,
> Raju.
>|||Hai,
Thanks for you immediate response.
Whether we have to install the sql server 2005 express manually, is
it possible to install the sql server 2005 from our .net application
automatically.
First we will deploy, required installation files and database
files in our application.
So, when we install the application, first the sql server 2005
express will install and after that out application will get installed.
If this one is possible then, please give me the procedure for
that.
Thanks in advance.
Regards,
Raju.|||See:
SQL Server 2005 Unintended Installations
http://www.devx.com/dbzone/Article/31648
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
"raju" <ponnurajs@.gmail.com> wrote in message
news:1162021453.839712.248670@.i3g2000cwc.googlegroups.com...
> Hai,
> Thanks for you immediate response.
> Whether we have to install the sql server 2005 express manually, is
> it possible to install the sql server 2005 from our .net application
> automatically.
> First we will deploy, required installation files and database
> files in our application.
> So, when we install the application, first the sql server 2005
> express will install and after that out application will get installed.
> If this one is possible then, please give me the procedure for
> that.
> Thanks in advance.
> Regards,
> Raju.
>|||> SQL Server 2005 Unintended Installations
Freudian slip, Arnie? :-)
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Arnie Rowland" <arnie@.1568.com> wrote in message news:OFd5COr%23GHA.3952@.TK2MSFTNGP03.phx.g
bl...
> See:
> SQL Server 2005 Unintended Installations
> http://www.devx.com/dbzone/Article/31648
>
> --
> 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 th
e
> top yourself.
> - H. Norman Schwarzkopf
>
> "raju" <ponnurajs@.gmail.com> wrote in message
> news:1162021453.839712.248670@.i3g2000cwc.googlegroups.com...
>|||Got me...
But sometimes, the user may not have 'intended' to end up with a SQL
installation -but they get one anyway.
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
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:OaGw9Xr%23GHA.4708@.TK2MSFTNGP05.phx.gbl...[vbcol=seagreen]
> Freudian slip, Arnie? :-)
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Arnie Rowland" <arnie@.1568.com> wrote in message
> news:OFd5COr%23GHA.3952@.TK2MSFTNGP03.phx.gbl...|||Hello Arnie Rowland,
Now we got the sqlexpress, when we run the applcation it is
running smoothly.
The database is from our application only. But when we run the
crystal reports it is refering the database logon information on the
machine, where we created the crystal reports.
I know the problem, why it is. Bec., we created the crystal
reports, using the local datasource only.
So, how to give the datasource, when we creating the crystal
reports.
Thanks in advance.
Regards,
Raju.|||That is a crystal reports issue, you need to change that in crystal reports.
I suggest you post this
to some suitable crystal reports forum, as there isn't that high probability
that you find experts
on crystal reports here.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"raju" <ponnurajs@.gmail.com> wrote in message
news:1162188434.813391.82120@.k70g2000cwa.googlegroups.com...
> Hello Arnie Rowland,
> Now we got the sqlexpress, when we run the applcation it is
> running smoothly.
> The database is from our application only. But when we run the
> crystal reports it is refering the database logon information on the
> machine, where we created the crystal reports.
> I know the problem, why it is. Bec., we created the crystal
> reports, using the local datasource only.
> So, how to give the datasource, when we creating the crystal
> reports.
> Thanks in advance.
> Regards,
> Raju.
>|||Hello,
Thanks for your response.
We can change that datasource at runtime also. Can you guide me
on how to do that.
Regards,
Raju.
Tibor Karaszi wrote:[vbcol=seagreen]
> That is a crystal reports issue, you need to change that in crystal report
s. I suggest you post this
> to some suitable crystal reports forum, as there isn't that high probabili
ty that you find experts
> on crystal reports here.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "raju" <ponnurajs@.gmail.com> wrote in message
> news:1162188434.813391.82120@.k70g2000cwa.googlegroups.com...|||> We can change that datasource at runtime also. Can you guide me
> on how to do that.
I've never used Crystal Reports. You need ask people who know Crystal Report
s on how to do this.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"raju" <ponnurajs@.gmail.com> wrote in message
news:1162378360.362543.118220@.b28g2000cwb.googlegroups.com...
> Hello,
> Thanks for your response.
> We can change that datasource at runtime also. Can you guide me
> on how to do that.
> Regards,
> Raju.
> Tibor Karaszi wrote:
>

about connections and Login

Hey guys,

I have created dtsx packages and i have one master package which would run couple of child packages.

1. I have all on my local machine.I want others who r working with me access these.So what do i need to do?for them to access...

2.what would be the best way in executing these packages.

the way it is set now is i had 3 connections set for each package.

a.Source connection

b.Destination Connection.

c.One more connection(which is used with in the process of execution)

Can i set connections in common for all the packages in one location.

3.i also want to set some logging settings to my master package too.and i want this package to run everyday automatically at a particular time how can this be done.

How can i do that.

please let me know.

sureshv wrote:

1. I have all on my local machine.I want others who r working with me access these.So what do i need to do?for them to access...

What you mean, to edit them? just use VSS or place them in a shared location. To execute them, place them in a shared location and then set up a Job (SQl Agent) to run them.

sureshv wrote:

2.what would be the best way in executing these packages.

Via SQL Agent job would be my preferred method

sureshv wrote:

Can i set connections in common for all the packages in one location.

No, but you can use package configuration instead.

sureshv wrote:

3.i also want to set some logging settings to my master package too.and i want this package to run everyday automatically at a particular time how can this be done.

To schedule them, again, use a SQL Agent Job. For logging just enable package logging.

About change log file folder after database was created

Hi Guys,
Can I change log file folder after database was created? I want to move log
file to other folder, how do I do? Thanks.
You could use detach and attach:
http://msdn2.microsoft.com/en-us/library/ms187858.aspx
Alternatively if you have just made a backup you could use RESTORE with
MOVE. Please look at example D here:
http://msdn2.microsoft.com/en-us/library/ms186858.aspx
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .

About change log file folder after database was created

Hi Guys,
Can I change log file folder after database was created? I want to move log
file to other folder, how do I do? Thanks.You could use detach and attach:
http://msdn2.microsoft.com/en-us/library/ms187858.aspx
Alternatively if you have just made a backup you could use RESTORE with
MOVE. Please look at example D here:
http://msdn2.microsoft.com/en-us/library/ms186858.aspx
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .