I'm attempting to do a clean up on someone else's database (whoopee!),
and I think the back end is on a SQL server, front end in access. I
know little about SQL and would like to get a copy into Access to work
with it for a while, before messing with the real thing. It sounds like
I can import the tables, or use DTS tool, but how do I get the
connections to the forms in the Front end? Is there any way to put it
in access without moving it into another sql server on my machine? I'm
lost. TIA!To copy database from SQL Server to Access you can do the following
1) Create a DTS Package to move the data between databasess
2) Create a lonked server to Access database (For more details see the
BOL)
3)
INSERT INTO OPENDATASOURCE(
'Microsoft.Jet.OLEDB.4.0', 'Data Source="\\servername\AccessData.mdb"; User
ID=Admin;Password='
)...TableName(col1,col2...)
SELECT col1,col2.... FROM TableName
<hmgeri@.gmail.com> wrote in message
news:1166076771.130361.39730@.t46g2000cwa.googlegroups.com...
> I'm attempting to do a clean up on someone else's database (whoopee!),
> and I think the back end is on a SQL server, front end in access. I
> know little about SQL and would like to get a copy into Access to work
> with it for a while, before messing with the real thing. It sounds like
> I can import the tables, or use DTS tool, but how do I get the
> connections to the forms in the Front end? Is there any way to put it
> in access without moving it into another sql server on my machine? I'm
> lost. TIA!
>
Showing posts with label attempting. Show all posts
Showing posts with label attempting. Show all posts
Tuesday, March 27, 2012
copy from sql to access
I'm attempting to do a clean up on someone else's database (whoopee!),
and I think the back end is on a SQL server, front end in access. I
know little about SQL and would like to get a copy into Access to work
with it for a while, before messing with the real thing. It sounds like
I can import the tables, or use DTS tool, but how do I get the
connections to the forms in the Front end? Is there any way to put it
in access without moving it into another sql server on my machine? I'm
lost. TIA!
To copy database from SQL Server to Access you can do the following
1) Create a DTS Package to move the data between databasess
2) Create a lonked server to Access database (For more details see the
BOL)
3)
INSERT INTO OPENDATASOURCE(
'Microsoft.Jet.OLEDB.4.0', 'Data Source="\\servername\AccessData.mdb"; User
ID=Admin;Password='
)...TableName(col1,col2...)
SELECT col1,col2.... FROM TableName
<hmgeri@.gmail.com> wrote in message
news:1166076771.130361.39730@.t46g2000cwa.googlegro ups.com...
> I'm attempting to do a clean up on someone else's database (whoopee!),
> and I think the back end is on a SQL server, front end in access. I
> know little about SQL and would like to get a copy into Access to work
> with it for a while, before messing with the real thing. It sounds like
> I can import the tables, or use DTS tool, but how do I get the
> connections to the forms in the Front end? Is there any way to put it
> in access without moving it into another sql server on my machine? I'm
> lost. TIA!
>
sqlsql
and I think the back end is on a SQL server, front end in access. I
know little about SQL and would like to get a copy into Access to work
with it for a while, before messing with the real thing. It sounds like
I can import the tables, or use DTS tool, but how do I get the
connections to the forms in the Front end? Is there any way to put it
in access without moving it into another sql server on my machine? I'm
lost. TIA!
To copy database from SQL Server to Access you can do the following
1) Create a DTS Package to move the data between databasess
2) Create a lonked server to Access database (For more details see the
BOL)
3)
INSERT INTO OPENDATASOURCE(
'Microsoft.Jet.OLEDB.4.0', 'Data Source="\\servername\AccessData.mdb"; User
ID=Admin;Password='
)...TableName(col1,col2...)
SELECT col1,col2.... FROM TableName
<hmgeri@.gmail.com> wrote in message
news:1166076771.130361.39730@.t46g2000cwa.googlegro ups.com...
> I'm attempting to do a clean up on someone else's database (whoopee!),
> and I think the back end is on a SQL server, front end in access. I
> know little about SQL and would like to get a copy into Access to work
> with it for a while, before messing with the real thing. It sounds like
> I can import the tables, or use DTS tool, but how do I get the
> connections to the forms in the Front end? Is there any way to put it
> in access without moving it into another sql server on my machine? I'm
> lost. TIA!
>
sqlsql
copy from sql to access
I'm attempting to do a clean up on someone else's database (whoopee!),
and I think the back end is on a SQL server, front end in access. I
know little about SQL and would like to get a copy into Access to work
with it for a while, before messing with the real thing. It sounds like
I can import the tables, or use DTS tool, but how do I get the
connections to the forms in the Front end? Is there any way to put it
in access without moving it into another sql server on my machine? I'm
lost. TIA!To copy database from SQL Server to Access you can do the following
1) Create a DTS Package to move the data between databasess
2) Create a lonked server to Access database (For more details see the
BOL)
3)
INSERT INTO OPENDATASOURCE(
'Microsoft.Jet.OLEDB.4.0', 'Data Source="\\servername\AccessData.mdb"; User
ID=Admin;Password='
)...TableName(col1,col2...)
SELECT col1,col2.... FROM TableName
<hmgeri@.gmail.com> wrote in message
news:1166076771.130361.39730@.t46g2000cwa.googlegroups.com...
> I'm attempting to do a clean up on someone else's database (whoopee!),
> and I think the back end is on a SQL server, front end in access. I
> know little about SQL and would like to get a copy into Access to work
> with it for a while, before messing with the real thing. It sounds like
> I can import the tables, or use DTS tool, but how do I get the
> connections to the forms in the Front end? Is there any way to put it
> in access without moving it into another sql server on my machine? I'm
> lost. TIA!
>
and I think the back end is on a SQL server, front end in access. I
know little about SQL and would like to get a copy into Access to work
with it for a while, before messing with the real thing. It sounds like
I can import the tables, or use DTS tool, but how do I get the
connections to the forms in the Front end? Is there any way to put it
in access without moving it into another sql server on my machine? I'm
lost. TIA!To copy database from SQL Server to Access you can do the following
1) Create a DTS Package to move the data between databasess
2) Create a lonked server to Access database (For more details see the
BOL)
3)
INSERT INTO OPENDATASOURCE(
'Microsoft.Jet.OLEDB.4.0', 'Data Source="\\servername\AccessData.mdb"; User
ID=Admin;Password='
)...TableName(col1,col2...)
SELECT col1,col2.... FROM TableName
<hmgeri@.gmail.com> wrote in message
news:1166076771.130361.39730@.t46g2000cwa.googlegroups.com...
> I'm attempting to do a clean up on someone else's database (whoopee!),
> and I think the back end is on a SQL server, front end in access. I
> know little about SQL and would like to get a copy into Access to work
> with it for a while, before messing with the real thing. It sounds like
> I can import the tables, or use DTS tool, but how do I get the
> connections to the forms in the Front end? Is there any way to put it
> in access without moving it into another sql server on my machine? I'm
> lost. TIA!
>
Tuesday, March 20, 2012
Copy Database Wizard
I am attempting to use the CDW, to copy a database on my
laptop running SQL server 2000 PE to a server running SQL
Server 2000 standard edition. I think that I have set
all of the appropriate permissions/authentications etc.
I have run it both from EM and the command line but it
fails to copy the source .mdf file. All other function
execute properly ie the share is created, single user
mode invoked, etc etc. I have tried changing the name of
the destination file etc and it still results in a
failure to copy the source file error. Is this yet
another limitation of the PE or am I not doing something
correctly?
Thanks
The copy database wizard uses detach, copy and attach, and there aren't any
issues going up a version that I know of (going down is different if EG you
used partitioned views then downgraded to Personal Edition):
http://www.winnetmag.com/Articles/Ar...91/pg/2/2.html
http://support.microsoft.com/default...;en-us;q268361
Can you try detaching manually, making a copy of the file, copying the file
over to the share on the EE then attaching manually.
Hopefully this should establish the point of error.
HTH,
Paul Ibison
|||Will give it a try, thanks
>--Original Message--
>The copy database wizard uses detach, copy and attach,
and there aren't any
>issues going up a version that I know of (going down is
different if EG you
>used partitioned views then downgraded to Personal
Edition):
>http://www.winnetmag.com/Articles/Ar.../21391/pg/2/2.
html
>http://support.microsoft.com/default.aspx?scid=kb;en-
us;q268361
>Can you try detaching manually, making a copy of the
file, copying the file
>over to the share on the EE then attaching manually.
>Hopefully this should establish the point of error.
>HTH,
>Paul Ibison
>
>.
>
|||That worked, thanks[vbcol=seagreen]
>--Original Message--
>Will give it a try, thanks
>and there aren't any
>different if EG you
>Edition):
..
>html
>us;q268361
>file, copying the file
>.
>
laptop running SQL server 2000 PE to a server running SQL
Server 2000 standard edition. I think that I have set
all of the appropriate permissions/authentications etc.
I have run it both from EM and the command line but it
fails to copy the source .mdf file. All other function
execute properly ie the share is created, single user
mode invoked, etc etc. I have tried changing the name of
the destination file etc and it still results in a
failure to copy the source file error. Is this yet
another limitation of the PE or am I not doing something
correctly?
Thanks
The copy database wizard uses detach, copy and attach, and there aren't any
issues going up a version that I know of (going down is different if EG you
used partitioned views then downgraded to Personal Edition):
http://www.winnetmag.com/Articles/Ar...91/pg/2/2.html
http://support.microsoft.com/default...;en-us;q268361
Can you try detaching manually, making a copy of the file, copying the file
over to the share on the EE then attaching manually.
Hopefully this should establish the point of error.
HTH,
Paul Ibison
|||Will give it a try, thanks
>--Original Message--
>The copy database wizard uses detach, copy and attach,
and there aren't any
>issues going up a version that I know of (going down is
different if EG you
>used partitioned views then downgraded to Personal
Edition):
>http://www.winnetmag.com/Articles/Ar.../21391/pg/2/2.
html
>http://support.microsoft.com/default.aspx?scid=kb;en-
us;q268361
>Can you try detaching manually, making a copy of the
file, copying the file
>over to the share on the EE then attaching manually.
>Hopefully this should establish the point of error.
>HTH,
>Paul Ibison
>
>.
>
|||That worked, thanks[vbcol=seagreen]
>--Original Message--
>Will give it a try, thanks
>and there aren't any
>different if EG you
>Edition):
..
>html
>us;q268361
>file, copying the file
>.
>
Copy Database Wizard
I am receiving the following error when attempting to copy a SQL Server 2000
database to SQL Server 2005 using copy database wizard.
When I use copy database wizard on the PUBS database the transfer is
successful.
ERROR:
Event Type:Error
Event Source:SQLISPackage
Event Category:None
Event ID:12550
Date:4/3/2006
Time:11:30:12 AM
User:IPC\Administrator
Computer:SQLSERV
Description:
Event Name: OnError
Message: ERROR : errorCode=-1073548784 description=Executing the query
"EXEC dbo.sp_grantdbaccess @.loginame = N'webapp', @.name_in_db = N'webapp'
" failed with the following error: "'webapp' is not a valid login or you do
not have permission.". Possible failure reasons: Problems with the query,
"ResultSet" property not set correctly, parameters not set correctly, or
connection not established correctly.
helpFile= helpContext=0
idofInterfaceWithError={8BDFE893-E9D8-4D23-9739-DA807BCDC2AC}
StackTrace: at
Microsoft.SqlServer.Management.Dts.DtsTransferProv ider.ExecuteTransfer()
at Microsoft.SqlServer.Management.Smo.Transfer.Transf erData()
at
Microsoft.SqlServer.Dts.Tasks.TransferObjectsTask. TransferObjectsTask.TransferDatabasesUsingSMOTrans fer()
Operator: IPC\Administrator
Source Name: IPC-DB_SQLSERV_Transfer Objects Task
Source ID: {8C9DDAF1-33A1-4FE0-A062-96D4185442B2}
Execution ID: {B0E899B3-B153-4B2D-8904-8D3137759A41}
Start Time: 4/3/2006 11:30:12 AM
End Time: 4/3/2006 11:30:12 AM
Data Code: 0
For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.
Just by reading the error, it looks like there is an issue with the webapp
login, which could be related to the security context (your permissions)
Do you have full permissions?
"Terry" wrote:
> I am receiving the following error when attempting to copy a SQL Server 2000
> database to SQL Server 2005 using copy database wizard.
> When I use copy database wizard on the PUBS database the transfer is
> successful.
>
> ERROR:
> Event Type:Error
> Event Source:SQLISPackage
> Event Category:None
> Event ID:12550
> Date:4/3/2006
> Time:11:30:12 AM
> User:IPC\Administrator
> Computer:SQLSERV
> Description:
> Event Name: OnError
> Message: ERROR : errorCode=-1073548784 description=Executing the query
> "EXEC dbo.sp_grantdbaccess @.loginame = N'webapp', @.name_in_db = N'webapp'
> " failed with the following error: "'webapp' is not a valid login or you do
> not have permission.". Possible failure reasons: Problems with the query,
> "ResultSet" property not set correctly, parameters not set correctly, or
> connection not established correctly.
> helpFile= helpContext=0
> idofInterfaceWithError={8BDFE893-E9D8-4D23-9739-DA807BCDC2AC}
> StackTrace: at
> Microsoft.SqlServer.Management.Dts.DtsTransferProv ider.ExecuteTransfer()
> at Microsoft.SqlServer.Management.Smo.Transfer.Transf erData()
> at
> Microsoft.SqlServer.Dts.Tasks.TransferObjectsTask. TransferObjectsTask.TransferDatabasesUsingSMOTrans fer()
> Operator: IPC\Administrator
> Source Name: IPC-DB_SQLSERV_Transfer Objects Task
> Source ID: {8C9DDAF1-33A1-4FE0-A062-96D4185442B2}
> Execution ID: {B0E899B3-B153-4B2D-8904-8D3137759A41}
> Start Time: 4/3/2006 11:30:12 AM
> End Time: 4/3/2006 11:30:12 AM
> Data Code: 0
> For more information, see Help and Support Center at
> http://go.microsoft.com/fwlink/events.asp.
>
database to SQL Server 2005 using copy database wizard.
When I use copy database wizard on the PUBS database the transfer is
successful.
ERROR:
Event Type:Error
Event Source:SQLISPackage
Event Category:None
Event ID:12550
Date:4/3/2006
Time:11:30:12 AM
User:IPC\Administrator
Computer:SQLSERV
Description:
Event Name: OnError
Message: ERROR : errorCode=-1073548784 description=Executing the query
"EXEC dbo.sp_grantdbaccess @.loginame = N'webapp', @.name_in_db = N'webapp'
" failed with the following error: "'webapp' is not a valid login or you do
not have permission.". Possible failure reasons: Problems with the query,
"ResultSet" property not set correctly, parameters not set correctly, or
connection not established correctly.
helpFile= helpContext=0
idofInterfaceWithError={8BDFE893-E9D8-4D23-9739-DA807BCDC2AC}
StackTrace: at
Microsoft.SqlServer.Management.Dts.DtsTransferProv ider.ExecuteTransfer()
at Microsoft.SqlServer.Management.Smo.Transfer.Transf erData()
at
Microsoft.SqlServer.Dts.Tasks.TransferObjectsTask. TransferObjectsTask.TransferDatabasesUsingSMOTrans fer()
Operator: IPC\Administrator
Source Name: IPC-DB_SQLSERV_Transfer Objects Task
Source ID: {8C9DDAF1-33A1-4FE0-A062-96D4185442B2}
Execution ID: {B0E899B3-B153-4B2D-8904-8D3137759A41}
Start Time: 4/3/2006 11:30:12 AM
End Time: 4/3/2006 11:30:12 AM
Data Code: 0
For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.
Just by reading the error, it looks like there is an issue with the webapp
login, which could be related to the security context (your permissions)
Do you have full permissions?
"Terry" wrote:
> I am receiving the following error when attempting to copy a SQL Server 2000
> database to SQL Server 2005 using copy database wizard.
> When I use copy database wizard on the PUBS database the transfer is
> successful.
>
> ERROR:
> Event Type:Error
> Event Source:SQLISPackage
> Event Category:None
> Event ID:12550
> Date:4/3/2006
> Time:11:30:12 AM
> User:IPC\Administrator
> Computer:SQLSERV
> Description:
> Event Name: OnError
> Message: ERROR : errorCode=-1073548784 description=Executing the query
> "EXEC dbo.sp_grantdbaccess @.loginame = N'webapp', @.name_in_db = N'webapp'
> " failed with the following error: "'webapp' is not a valid login or you do
> not have permission.". Possible failure reasons: Problems with the query,
> "ResultSet" property not set correctly, parameters not set correctly, or
> connection not established correctly.
> helpFile= helpContext=0
> idofInterfaceWithError={8BDFE893-E9D8-4D23-9739-DA807BCDC2AC}
> StackTrace: at
> Microsoft.SqlServer.Management.Dts.DtsTransferProv ider.ExecuteTransfer()
> at Microsoft.SqlServer.Management.Smo.Transfer.Transf erData()
> at
> Microsoft.SqlServer.Dts.Tasks.TransferObjectsTask. TransferObjectsTask.TransferDatabasesUsingSMOTrans fer()
> Operator: IPC\Administrator
> Source Name: IPC-DB_SQLSERV_Transfer Objects Task
> Source ID: {8C9DDAF1-33A1-4FE0-A062-96D4185442B2}
> Execution ID: {B0E899B3-B153-4B2D-8904-8D3137759A41}
> Start Time: 4/3/2006 11:30:12 AM
> End Time: 4/3/2006 11:30:12 AM
> Data Code: 0
> For more information, see Help and Support Center at
> http://go.microsoft.com/fwlink/events.asp.
>
Copy Database Wizard
I am receiving the following error when attempting to copy a SQL Server 2000
database to SQL Server 2005 using copy database wizard.
When I use copy database wizard on the PUBS database the transfer is
successful.
ERROR:
Event Type: Error
Event Source: SQLISPackage
Event Category: None
Event ID: 12550
Date: 4/3/2006
Time: 11:30:12 AM
User: IPC\Administrator
Computer: SQLSERV
Description:
Event Name: OnError
Message: ERROR : errorCode=-1073548784 description=Executing the query
"EXEC dbo.sp_grantdbaccess @.loginame = N'webapp', @.name_in_db = N'webapp'
" failed with the following error: "'webapp' is not a valid login or you do
not have permission.". Possible failure reasons: Problems with the query,
"ResultSet" property not set correctly, parameters not set correctly, or
connection not established correctly.
helpFile= helpContext=0
idofInterfaceWithError={8BDFE893-E9D8-4D23-9739-DA807BCDC2AC}
StackTrace: at
Microsoft.SqlServer.Management.Dts.DtsTransferProvider.ExecuteTransfer()
at Microsoft.SqlServer.Management.Smo.Transfer.TransferData()
at
Microsoft.SqlServer.Dts.Tasks.TransferObjectsTask.TransferObjectsTask.TransferDatabasesUsingSMOTransfer()
Operator: IPC\Administrator
Source Name: IPC-DB_SQLSERV_Transfer Objects Task
Source ID: {8C9DDAF1-33A1-4FE0-A062-96D4185442B2}
Execution ID: {B0E899B3-B153-4B2D-8904-8D3137759A41}
Start Time: 4/3/2006 11:30:12 AM
End Time: 4/3/2006 11:30:12 AM
Data Code: 0
For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.Just by reading the error, it looks like there is an issue with the webapp
login, which could be related to the security context (your permissions)
Do you have full permissions?
"Terry" wrote:
> I am receiving the following error when attempting to copy a SQL Server 2000
> database to SQL Server 2005 using copy database wizard.
> When I use copy database wizard on the PUBS database the transfer is
> successful.
>
> ERROR:
> Event Type: Error
> Event Source: SQLISPackage
> Event Category: None
> Event ID: 12550
> Date: 4/3/2006
> Time: 11:30:12 AM
> User: IPC\Administrator
> Computer: SQLSERV
> Description:
> Event Name: OnError
> Message: ERROR : errorCode=-1073548784 description=Executing the query
> "EXEC dbo.sp_grantdbaccess @.loginame = N'webapp', @.name_in_db = N'webapp'
> " failed with the following error: "'webapp' is not a valid login or you do
> not have permission.". Possible failure reasons: Problems with the query,
> "ResultSet" property not set correctly, parameters not set correctly, or
> connection not established correctly.
> helpFile= helpContext=0
> idofInterfaceWithError={8BDFE893-E9D8-4D23-9739-DA807BCDC2AC}
> StackTrace: at
> Microsoft.SqlServer.Management.Dts.DtsTransferProvider.ExecuteTransfer()
> at Microsoft.SqlServer.Management.Smo.Transfer.TransferData()
> at
> Microsoft.SqlServer.Dts.Tasks.TransferObjectsTask.TransferObjectsTask.TransferDatabasesUsingSMOTransfer()
> Operator: IPC\Administrator
> Source Name: IPC-DB_SQLSERV_Transfer Objects Task
> Source ID: {8C9DDAF1-33A1-4FE0-A062-96D4185442B2}
> Execution ID: {B0E899B3-B153-4B2D-8904-8D3137759A41}
> Start Time: 4/3/2006 11:30:12 AM
> End Time: 4/3/2006 11:30:12 AM
> Data Code: 0
> For more information, see Help and Support Center at
> http://go.microsoft.com/fwlink/events.asp.
>
database to SQL Server 2005 using copy database wizard.
When I use copy database wizard on the PUBS database the transfer is
successful.
ERROR:
Event Type: Error
Event Source: SQLISPackage
Event Category: None
Event ID: 12550
Date: 4/3/2006
Time: 11:30:12 AM
User: IPC\Administrator
Computer: SQLSERV
Description:
Event Name: OnError
Message: ERROR : errorCode=-1073548784 description=Executing the query
"EXEC dbo.sp_grantdbaccess @.loginame = N'webapp', @.name_in_db = N'webapp'
" failed with the following error: "'webapp' is not a valid login or you do
not have permission.". Possible failure reasons: Problems with the query,
"ResultSet" property not set correctly, parameters not set correctly, or
connection not established correctly.
helpFile= helpContext=0
idofInterfaceWithError={8BDFE893-E9D8-4D23-9739-DA807BCDC2AC}
StackTrace: at
Microsoft.SqlServer.Management.Dts.DtsTransferProvider.ExecuteTransfer()
at Microsoft.SqlServer.Management.Smo.Transfer.TransferData()
at
Microsoft.SqlServer.Dts.Tasks.TransferObjectsTask.TransferObjectsTask.TransferDatabasesUsingSMOTransfer()
Operator: IPC\Administrator
Source Name: IPC-DB_SQLSERV_Transfer Objects Task
Source ID: {8C9DDAF1-33A1-4FE0-A062-96D4185442B2}
Execution ID: {B0E899B3-B153-4B2D-8904-8D3137759A41}
Start Time: 4/3/2006 11:30:12 AM
End Time: 4/3/2006 11:30:12 AM
Data Code: 0
For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.Just by reading the error, it looks like there is an issue with the webapp
login, which could be related to the security context (your permissions)
Do you have full permissions?
"Terry" wrote:
> I am receiving the following error when attempting to copy a SQL Server 2000
> database to SQL Server 2005 using copy database wizard.
> When I use copy database wizard on the PUBS database the transfer is
> successful.
>
> ERROR:
> Event Type: Error
> Event Source: SQLISPackage
> Event Category: None
> Event ID: 12550
> Date: 4/3/2006
> Time: 11:30:12 AM
> User: IPC\Administrator
> Computer: SQLSERV
> Description:
> Event Name: OnError
> Message: ERROR : errorCode=-1073548784 description=Executing the query
> "EXEC dbo.sp_grantdbaccess @.loginame = N'webapp', @.name_in_db = N'webapp'
> " failed with the following error: "'webapp' is not a valid login or you do
> not have permission.". Possible failure reasons: Problems with the query,
> "ResultSet" property not set correctly, parameters not set correctly, or
> connection not established correctly.
> helpFile= helpContext=0
> idofInterfaceWithError={8BDFE893-E9D8-4D23-9739-DA807BCDC2AC}
> StackTrace: at
> Microsoft.SqlServer.Management.Dts.DtsTransferProvider.ExecuteTransfer()
> at Microsoft.SqlServer.Management.Smo.Transfer.TransferData()
> at
> Microsoft.SqlServer.Dts.Tasks.TransferObjectsTask.TransferObjectsTask.TransferDatabasesUsingSMOTransfer()
> Operator: IPC\Administrator
> Source Name: IPC-DB_SQLSERV_Transfer Objects Task
> Source ID: {8C9DDAF1-33A1-4FE0-A062-96D4185442B2}
> Execution ID: {B0E899B3-B153-4B2D-8904-8D3137759A41}
> Start Time: 4/3/2006 11:30:12 AM
> End Time: 4/3/2006 11:30:12 AM
> Data Code: 0
> For more information, see Help and Support Center at
> http://go.microsoft.com/fwlink/events.asp.
>
Copy Database Wizard
I am receiving the following error when attempting to copy a SQL Server 2000
database to SQL Server 2005 using copy database wizard.
When I use copy database wizard on the PUBS database the transfer is
successful.
ERROR:
Event Type: Error
Event Source: SQLISPackage
Event Category: None
Event ID: 12550
Date: 4/3/2006
Time: 11:30:12 AM
User: IPC\Administrator
Computer: SQLSERV
Description:
Event Name: OnError
Message: ERROR : errorCode=-1073548784 description=Executing the query
"EXEC dbo.sp_grantdbaccess @.loginame = N'webapp', @.name_in_db = N'webapp'
" failed with the following error: "'webapp' is not a valid login or you do
not have permission.". Possible failure reasons: Problems with the query,
"ResultSet" property not set correctly, parameters not set correctly, or
connection not established correctly.
helpFile= helpContext=0
idofInterfaceWithError={8BDFE893-E9D8-4D23-9739-DA807BCDC2AC}
StackTrace: at
Microsoft.SqlServer.Management.Dts.DtsTransferProvider.ExecuteTransfer()
at Microsoft.SqlServer.Management.Smo.Transfer.TransferData()
at
Microsoft.SqlServer.Dts.Tasks.TransferObjectsTask.TransferObjectsTask.Transf
erDatabasesUsingSMOTransfer()
Operator: IPC\Administrator
Source Name: IPC-DB_SQLSERV_Transfer Objects Task
Source ID: {8C9DDAF1-33A1-4FE0-A062-96D4185442B2}
Execution ID: {B0E899B3-B153-4B2D-8904-8D3137759A41}
Start Time: 4/3/2006 11:30:12 AM
End Time: 4/3/2006 11:30:12 AM
Data Code: 0
For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.Just by reading the error, it looks like there is an issue with the webapp
login, which could be related to the security context (your permissions)
Do you have full permissions?
"Terry" wrote:
> I am receiving the following error when attempting to copy a SQL Server 20
00
> database to SQL Server 2005 using copy database wizard.
> When I use copy database wizard on the PUBS database the transfer is
> successful.
>
> ERROR:
> Event Type: Error
> Event Source: SQLISPackage
> Event Category: None
> Event ID: 12550
> Date: 4/3/2006
> Time: 11:30:12 AM
> User: IPC\Administrator
> Computer: SQLSERV
> Description:
> Event Name: OnError
> Message: ERROR : errorCode=-1073548784 description=Executing the query
> "EXEC dbo.sp_grantdbaccess @.loginame = N'webapp', @.name_in_db = N'webapp'
> " failed with the following error: "'webapp' is not a valid login or you d
o
> not have permission.". Possible failure reasons: Problems with the query,
> "ResultSet" property not set correctly, parameters not set correctly, or
> connection not established correctly.
> helpFile= helpContext=0
> idofInterfaceWithError={8BDFE893-E9D8-4D23-9739-DA807BCDC2AC}
> StackTrace: at
> Microsoft.SqlServer.Management.Dts.DtsTransferProvider.ExecuteTransfer()
> at Microsoft.SqlServer.Management.Smo.Transfer.TransferData()
> at
> Microsoft.SqlServer.Dts.Tasks.TransferObjectsTask.TransferObjectsTask.Tran
sferDatabasesUsingSMOTransfer()
> Operator: IPC\Administrator
> Source Name: IPC-DB_SQLSERV_Transfer Objects Task
> Source ID: {8C9DDAF1-33A1-4FE0-A062-96D4185442B2}
> Execution ID: {B0E899B3-B153-4B2D-8904-8D3137759A41}
> Start Time: 4/3/2006 11:30:12 AM
> End Time: 4/3/2006 11:30:12 AM
> Data Code: 0
> For more information, see Help and Support Center at
> http://go.microsoft.com/fwlink/events.asp.
>
database to SQL Server 2005 using copy database wizard.
When I use copy database wizard on the PUBS database the transfer is
successful.
ERROR:
Event Type: Error
Event Source: SQLISPackage
Event Category: None
Event ID: 12550
Date: 4/3/2006
Time: 11:30:12 AM
User: IPC\Administrator
Computer: SQLSERV
Description:
Event Name: OnError
Message: ERROR : errorCode=-1073548784 description=Executing the query
"EXEC dbo.sp_grantdbaccess @.loginame = N'webapp', @.name_in_db = N'webapp'
" failed with the following error: "'webapp' is not a valid login or you do
not have permission.". Possible failure reasons: Problems with the query,
"ResultSet" property not set correctly, parameters not set correctly, or
connection not established correctly.
helpFile= helpContext=0
idofInterfaceWithError={8BDFE893-E9D8-4D23-9739-DA807BCDC2AC}
StackTrace: at
Microsoft.SqlServer.Management.Dts.DtsTransferProvider.ExecuteTransfer()
at Microsoft.SqlServer.Management.Smo.Transfer.TransferData()
at
Microsoft.SqlServer.Dts.Tasks.TransferObjectsTask.TransferObjectsTask.Transf
erDatabasesUsingSMOTransfer()
Operator: IPC\Administrator
Source Name: IPC-DB_SQLSERV_Transfer Objects Task
Source ID: {8C9DDAF1-33A1-4FE0-A062-96D4185442B2}
Execution ID: {B0E899B3-B153-4B2D-8904-8D3137759A41}
Start Time: 4/3/2006 11:30:12 AM
End Time: 4/3/2006 11:30:12 AM
Data Code: 0
For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.Just by reading the error, it looks like there is an issue with the webapp
login, which could be related to the security context (your permissions)
Do you have full permissions?
"Terry" wrote:
> I am receiving the following error when attempting to copy a SQL Server 20
00
> database to SQL Server 2005 using copy database wizard.
> When I use copy database wizard on the PUBS database the transfer is
> successful.
>
> ERROR:
> Event Type: Error
> Event Source: SQLISPackage
> Event Category: None
> Event ID: 12550
> Date: 4/3/2006
> Time: 11:30:12 AM
> User: IPC\Administrator
> Computer: SQLSERV
> Description:
> Event Name: OnError
> Message: ERROR : errorCode=-1073548784 description=Executing the query
> "EXEC dbo.sp_grantdbaccess @.loginame = N'webapp', @.name_in_db = N'webapp'
> " failed with the following error: "'webapp' is not a valid login or you d
o
> not have permission.". Possible failure reasons: Problems with the query,
> "ResultSet" property not set correctly, parameters not set correctly, or
> connection not established correctly.
> helpFile= helpContext=0
> idofInterfaceWithError={8BDFE893-E9D8-4D23-9739-DA807BCDC2AC}
> StackTrace: at
> Microsoft.SqlServer.Management.Dts.DtsTransferProvider.ExecuteTransfer()
> at Microsoft.SqlServer.Management.Smo.Transfer.TransferData()
> at
> Microsoft.SqlServer.Dts.Tasks.TransferObjectsTask.TransferObjectsTask.Tran
sferDatabasesUsingSMOTransfer()
> Operator: IPC\Administrator
> Source Name: IPC-DB_SQLSERV_Transfer Objects Task
> Source ID: {8C9DDAF1-33A1-4FE0-A062-96D4185442B2}
> Execution ID: {B0E899B3-B153-4B2D-8904-8D3137759A41}
> Start Time: 4/3/2006 11:30:12 AM
> End Time: 4/3/2006 11:30:12 AM
> Data Code: 0
> For more information, see Help and Support Center at
> http://go.microsoft.com/fwlink/events.asp.
>
Sunday, March 11, 2012
Copy database fails because of invalid object name in a view?
I'm getting the below error when attempting to copy a database. The view works just fine but the package keeps giving me the below error:
07 3:26:37 PM,4/11/2007 3:26:37 PM,0,0x,ERROR : errorCode=-1073548784 description=Executing the query "
CREATE VIEW [app].[vwbaseTransfer]
AS
Select a.app_id, a.app_year, u.first_name, u.middle_name, u.last_name, app_phoneAM, email, CONVERT(varchar(10), app_dob, 101) as app_dob, app_citizen,
CASE WHEN app_untilDate > GetDate() Then app_addr1 ELSE app_pAddr1 END AS app_addr1,
CASE WHEN app_untilDate > GetDate() Then app_addr2 ELSE app_pAddr2 END AS app_addr2,
CASE WHEN app_untilDate > GetDate() Then app_addr3 ELSE app_pAddr3 END AS app_addr3,
CASE WHEN app_untilDate > GetDate() Then app_addr3 ELSE app_pAddr3 END AS app_addr4,
CASE WHEN app_untilDate > GetDate() Then app_city ELSE app_pcity END AS app_city,
CASE WHEN app_untilDate > GetDate() Then app_state ELSE app_pstate END AS app_state,
CASE WHEN app_untilDate > GetDate() Then app_zipcode ELSE app_pzipcode END AS app_zipcode,
app_sex, app_racecode, app_accept_letter, app_acceptDate, app_orientation_date, app_ssn
FROM applicant a inner join uop_user u on u.id = a.app_id
where app_accept_letter is not null and app_acceptDate is not null
" failed with the following error: "Invalid object name 'applicant'.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.
helpFile= helpContext=0 idofInterfaceWithError={8BDFE893-E9D8-4D23-9739-DA807BCDC2AC}
StackTrace: at Microsoft.SqlServer.Management.Dts.DtsTransferProvider.ExecuteTransfer()
at Microsoft.SqlServer.Management.Smo.Transfer.TransferData()
jwelch wrote:
Maybe it is trying to copy the view before the applicant table?
Ooooo, I like that thought!|||That's not good. Anyone tried this before?|||Should I assume that this will not work and manually copy databases?|||
Should I assume that this will not work and manually copy databases?
What task are you using?
Also, isn't there a better method of "copying" databases? (That is, a backup/restore process.) Are you going for just the schema, or data as well?|||
That's not good. Anyone tried this before?
If you feel like wading through it, you could check your sys.sql_dependencies view to see if it has the dependency between the view and the table. Not sure if that is used to determine the order when db objects are copied, but it might be worth a shot.
|||I'm using the copy database task. If I do a backup and restore then I manually must reset the logins, correct. I was hoping that a simple copy database would take care of this.
thanks.
Subscribe to:
Posts (Atom)