Regarding Import and Export of database

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SQL Server Administration (2005)

Regarding Import and Export of database

Author

Topic

john_andy
Starting Member

1 Post

Posted - 2009-08-11 : 14:16:31

Hi guys,

I have installed sql server2005 in windows Xp home. so i have 5 databases like pubs,northwind,adventureworks,student course,employeedetails. I have created an instance server sqlserverdev.

so when tried to export adventureworks database from main server(HOME-89B26BED1E\home) to instance server (HOME-89B26BED1E\MSSQLSERVERDEV ).I am getting an error login failed

detailed format of error:

===================================

Login failed for user 'HOME-89B26BED1E\home'.
Cannot open database "adventureworks" requested by the login. The login failed. (Microsoft SQL Native Client)

------------------------------
Program Location:

at System.Data.OleDb.OleDbConnectionInternal..ctor(OleDbConnectionString constr, OleDbConnection connection)
at System.Data.OleDb.OleDbConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup)
at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
at System.Data.OleDb.OleDbConnection.Open()
at Microsoft.SqlServer.Dts.DtsWizard.DTSWizard.GetOpenedConnection(WizardInputs wizardInputs, String connEntryName)
at Microsoft.SqlServer.Dts.DtsWizard.Step2.OnLeavePage(LeavePageEventArgs e)

so what could be the reason.........i thought that my windows user that is 'Home' is not a administrator but when i check the users in control panel it is telling 'Home' is a computer administrator......
can u help me guys in this regard...........

regards,

John

tripodal
Constraint Violating Yak Guru

259 Posts

Posted - 2009-08-11 : 14:32:50

Sounds like the permissions inside of sql server are not setup correctly. Look under the security section in enterprise manager.

Not only do you need access to the comptuer, you need access to sql, and to the individual databases.
There are many ways to get there. Check Sql BOL.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources