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.
Author |
Topic |
horse
Starting Member
5 Posts |
Posted - 2005-01-18 : 04:13:40
|
I thought this post [url]http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=44557[/url] was going to help me move databases from one server to another. I did the orphaning thing and it worked on the main database. I then ported across some new databases and not only do they not work but nor does the main database now.I therefore think its not the orphaning but I still get the following error message :-Microsoft OLE DB Provider for ODBC Drivers error '80004005' [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot open database requested in login '*******'. Login fails Can you think of any thing I may have overlooked on a new install of IIS 6 and SQL Server 2000 that may have caused this? |
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2005-01-18 : 05:31:49
|
Do you specify a databasetry sp_defaultdb to change the default database for the login.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
horse
Starting Member
5 Posts |
Posted - 2005-01-18 : 06:15:43
|
Could you give an example please. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-01-18 : 17:44:03
|
Did you look at the sp_defaultdb example in SQL Server Books Online?Tara |
|
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
|
|
|
|