| Author |
Topic |
|
Burlar
Starting Member
8 Posts |
 Posted - 2004-04-28 : 11:29:17
|
i have used sql 2000 server and i have build my application with integrated security using windows authentication. How can I blend this into msde. I tried sp_grantlogin for the machine but login failed. |
|
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
Posted - 2004-04-28 : 17:47:07
|
| The security model for MSDE 2000 is the same as it is for SQL 2000. Are you using a sysadmin account when you issue the sp_grantlogin command?--------------------------------------------------------------Find more words of wisdom at [url]http://weblogs.sqlteam.com/markc[/url] |
 |
|
|
Burlar
Starting Member
8 Posts |
Posted - 2004-04-29 : 07:03:33
|
| I discovered that the problem was that the database was no present. I now tried to attach using sp_attach but it failed. How do I attach my database that was copied from sql 2000 on another machine.? |
|
|
|
jora
Starting Member
2 Posts |
Posted - 2004-04-30 : 01:58:49
|
Run this command in osql:USE masterGOEXEC sp_attach_db @dbname = N'your_db_name', @filename1 = N'yourfirstfile.mdf', @filename2 = N'yoursecondfile.ndf', @filename3 = N'yourlogfile.ldf' Add all files that make up your database.Johan |
|
|
|
Burlar
Starting Member
8 Posts |
Posted - 2004-04-30 : 04:12:27
|
| It gave the following message:Msg 5172, Level 16, State 15, Server<servername>, Procedure, Line 1 [Microsoft][ODBC SQL server Driver][SQL Server] The header for the '<filepath>\filename.mdf' is not a valid database file header. The PageAudit property is incorrect.This error doesn't occur when i detach and attach the same file in sql server 2000.What am i not getting? |
|
|
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
Posted - 2004-04-30 : 19:09:02
|
| Did you detach it from SQL 2000 and make a copy to be attached to MSDE? And remember to attach it back to SQL 2000. I've heard of problems if the database file was not properly detached first.--------------------------------------------------------------Find more words of wisdom at [url]http://weblogs.sqlteam.com/markc[/url] |
|
|
|
Burlar
Starting Member
8 Posts |
Posted - 2004-05-03 : 03:15:52
|
| I detached it from SQL 2000 using Enterprise manager and then tried to attached it msde. I wouldn't expect it not to be properly detached. I attached it back to SQL 2000 on my machine an another machine and it worked. |
|
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2004-05-03 : 03:30:34
|
| Do you have the service packs applied to msde (you should have at lest sp3).Wouldn't have thought it would give this error though.Try select @@version. You do have msde 2000 not msde (which would be v7). That might give the sort of error you are seeing.You can do a sp_attach_single_file_db with just the .mdf if you have a single .mdf.The code pages used would affect the attach but again shouldn't give this error.==========================================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. |
|
|
|
Burlar
Starting Member
8 Posts |
Posted - 2004-05-04 : 08:46:35
|
| You are right. I installed msde7. Now I downloaded MSDE 2000 but discovered the packaging is not actually the same thing. how can I package it with my application using Package and Deployment wizard(PDW). |
|
|
|
nr
SQLTeam MVY
12543 Posts |
|
|
|
MSDE Authentication