Showing posts with label attached. Show all posts
Showing posts with label attached. Show all posts

Friday, March 23, 2012

remotely attached DB ends up readonly .. why oh why oh why ..

I have what seems like a commonish problem.
I have copied my database (mdf and logfile) to a remote XP desktop machine
... when using SQL server managment express tool when I try to attach the
DB it ends up readonly.
The file permissions are not set to read only (a problem I have read)
And I've done this shrink-detach-transfer-attach with various versions of
this database at least 20 times in the last week.
But not now it would seem.
The strange thing is that if I drop this database into the sql server default
'data' directory it works fine.
This doesnt explain why the second database that sits in the original 'destination'
directory attaches just fine.
I am utterly confused - traps for new players I guess.
---
[Sam Samson] - There is no greater folly than fixed price quoting.Sam
On the source machine, did you issue sp_detach the database? Take a look at
ALTER DATABASE... SET READ_WRITE option if I remember well
"Sam Samson" <nospamsam@.nospam.com.au> wrote in message
news:ece03a7894c38c9b916d29dee90@.news.microsoft.com...
>I have what seems like a commonish problem.
> I have copied my database (mdf and logfile) to a remote XP desktop machine
> ... when using SQL server managment express tool when I try to attach the
> DB it ends up readonly.
> The file permissions are not set to read only (a problem I have read) And
> I've done this shrink-detach-transfer-attach with various versions of this
> database at least 20 times in the last week.
> But not now it would seem.
> The strange thing is that if I drop this database into the sql server
> default 'data' directory it works fine.
> This doesnt explain why the second database that sits in the original
> 'destination' directory attaches just fine.
> I am utterly confused - traps for new players I guess.
> ---
> [Sam Samson] - There is no greater folly than fixed price quoting.
>
>

Monday, March 12, 2012

remote saleslogix user problem using msde

Hello, I am trying to setup a remote user in saleslogix. I can login to
the remote databse but i cant login to the local msde, I attached the
remote database successfully but i believe the password of the remote
database does not match. any ideas? should i regenerate the remote
database? can anyone tell me the steps, I dont see to many 6.1
saleslogix users anymore, where did everyone go?You might try this site: http://www.slxdeveloper.com/page.aspx
<jcharth@.hotmail.com> wrote in message
news:1110138810.089034.124370@.o13g2000cwo.googlegroups.com...
> Hello, I am trying to setup a remote user in saleslogix. I can login to
> the remote databse but i cant login to the local msde, I attached the
> remote database successfully but i believe the password of the remote
> database does not match. any ideas? should i regenerate the remote
> database? can anyone tell me the steps, I dont see to many 6.1
> saleslogix users anymore, where did everyone go?
>|||thanks Michael
I found this one too
http://www.saleslogixuser.com/Forum...aspx?ForumID=4
but no luck