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 |
|
innocent73
Starting Member
20 Posts |
 Posted - 2002-09-10 : 09:31:18
|
| I have installed MSDE via Office 2000 CD and service started..But howcan I attach an SQL Server database to MSDE??I have detached my SQl Server database and copied it to Desktop Engine's folder...Please help..very very very urgent!! |
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2002-09-10 : 09:53:37
|
| You can't do itDamian |
 |
|
|
innocent73
Starting Member
20 Posts |
Posted - 2002-09-10 : 11:03:29
|
| thanks for your detailed answer...If it possible could you please say why???? |
|
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2002-09-10 : 11:15:06
|
| Ummm, because they are different programs ?Damian |
|
|
|
Doug G
Constraint Violating Yak Guru
331 Posts |
Posted - 2002-09-10 : 21:16:23
|
| I have detached SQL Server 7 DB's and attached the .mdf file to MSDE1.0 and vice-versa. Office 2000 includes MSDE 1.0, if your server is SQL Server 2000 you won't be able to attach the db file. You may be able to if you install MSDE 2000.======Doug G======Edited by - Doug G on 09/10/2002 21:17:16 |
|
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2002-09-10 : 23:08:16
|
Really ? Wow, I stand corrected  Damian |
|
|
|
innocent73
Starting Member
20 Posts |
Posted - 2002-09-11 : 02:53:08
|
| I have installed MSDE via Office 2000 CD on a Win98 machine.And I have installed to SQL Server 2000 to attach my database to MSDE.It worked.I have tried the same operations on a different win98 machine.MSDE installed and a folder named MSSQL7 was created.But I could not attach my SQL Server 2000 database to MSDE..And very interesting point I can not access this MSDE via network.Because I dont know the user name and password settings of this MSDE instance.. |
|
|
|
Doug G
Constraint Violating Yak Guru
331 Posts |
Posted - 2002-09-12 : 01:33:03
|
| If your msde ended up in a folder MSSQL7, that's MSDE1, and you won't be able to attach a SQL Server 2K database file.You should be able to connect to your MSDE via the network using your windows authentication. You can change the MSDE login mode to mixed mode and set up sql user accounts as well. I think the default installation either creates a sa user with a blank password or is in windows authentication mode only.There are some command line utilities that will let you change the authentication mode, etc, search the MS KB.You also have to use a command line utility to change the default network library for MSDE 1 on W98. W98 doesn't support named pipes, you have to connect with TCP over the network to a MSDE hosted on W98.======Doug G====== |
|
|
|
|
|
|
ATTACHING AN SQL SERVER DATABASE